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 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 (2009) and PP is the two-digit period (01). |
|
AmountProjectCurrency | decimal | 9 | Multicurrency only. |
AmountBillingCurrency | decimal | 9 | Multicurrency only. |