Unbilled Revenue Table Formats (UnbilledRevenue)

Follow Vantagepoint specifications for preparing a file containing unbilled revenue data.

Field Name Data Type Width Notes
WBS1 varchar
WBS2 varchar
WBS3 varchar
Account varchar
Period integer Optional. Enter an accounting period here if you wish to enter separate unbilled revenue amounts for different periods. Leave this field blank if you want to enter a single job-to-date unbilled revenue amount for the project or the project/task.

The format for this field is YYYYPP, where YYYY is the 4-digit year (1999) and PP is the 2-digit period (01).

Amount decimal Required. The amount of unbilled revenue accumulated by the project or project/task. If the project or project/task has already accumulated unbilled revenue, either through the revenue generation utility or through the history loading procedure, Vantagepoint will add the unbilled revenue amount entered here to the amount that already exists.
AmountProjectCurrency decimal 9 Multicurrency feature only.
AmountBillingCurrency decimal 9 Multicurrency feature only.