Unbilled Revenue Table Formats (UnbilledRevenue)

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

Field Name Data Type Width Notes

WBS1

varchar

WBS2

varchar

WBS3

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, Advantage will add the unbilled revenue amount entered here to the amount that already exists.

AmountProjectCurrency

decimal 9 Multicurrency only.

AmountBillingCurrency

decimal 9 Multicurrency only.