Project Receipts Table Formats (ProjectReceipt)

Follow Deltek 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 AR 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 and PP is the two-digit period.

AmountProjectCurrency decimal 9 Multicurrency feature only.
AmountBillingCurrency decimal 9 Multicurrency feature only.