Project Receipts Table Formats (ProjectReceipt)

Follow DPS 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.