Unbilled Revenue Table Formats (UnbilledRevenue)

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