Project Receipts Table Formats (ProjectReceipt)

Follow Vision specifications for preparing a file containing project receipts.

Field Name Data Type Length Notes

WBS1

varchar

WBS2

varchar

WBS3

varchar

Account

varchar Required. The receivables account that is referenced in Invoice Mapping Accounts and A/R Mapping Accounts Configuration.

TransDate

datetime Required. The receipt transaction date. There is no default for this field; you must enter a date.

Amount

decimal Optional. The amount for this receipt.

Invoice

varchar Required. The invoice number to which this receipt applies.

Description

varchar Optional. The description of the receipt.

Period

integer

Required. The period in which this receipt was recorded, which will determine the paid period. The period must be prior or equal to the active period. The default for balance sheet accounts is 0. The default for other account types is 0.

The format for this field is YYYYPP, where YYYY is the four-digit year (2009) and PP is the two-digit period (01).

AmountProjectCurrency

decimal 9 Multicurrency only.

AmountBillingCurrency

decimal 9 Multicurrency only.