Project Expenses Table Formats (ProjectExpense)
Follow Vision specifications for preparing a file containing project expenses.
Field Name | Data Type | Length | Notes |
---|---|---|---|
WBS1 |
varchar | ||
WBS2 |
varchar | ||
WBS3 |
varchar | ||
Account |
varchar | Required. The account for this charge. The account must be a valid account number in Vision. | |
Vendor |
varchar | ||
TransDate |
datetime | Required. The transaction date for this charge. If you do not specify a date, this field defaults to today’s date. | |
Period |
integer |
Required. The period in which this charge was posted. The period must be prior or equal to the active period. The default for overhead projects is YTD (year-to-date). The default for regular projects 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). |
|
Description |
varchar | Optional. The description for this transaction. | |
Amount |
decimal | Optional. The cost amount for this transaction. | |
BillExt |
decimal | Optional. The billing amount for this transaction. | |
BillStatus |
varchar | Required. The billing status for this transaction. B for billable, H for held, W for written-off, or N for nonbillable. | |
AmountProjectCurrency |
decimal | 9 | Multicurrency only. NEEDS INFO |
AmountBillingCurrency |
decimal | 9 | Multicurrency only. NEEDS INFO |