Project Labor Table Formats (ProjectLabor)
Follow Vision specifications for preparing a file containing project labor.
Field Name | Data Type | Length | Notes |
---|---|---|---|
WBS1 |
varchar | ||
WBS2 |
varchar | ||
WBS3 |
varchar | ||
LaborCode |
varchar | Required. The labor code for this charge. This code must be a valid labor code in Vision. | |
Employee |
varchar | Required. The employee number for this charge. Vision does not validate the employee number because the number you enter could be for a terminated employee. | |
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. The default for regular projects is 0. The format for this field is YYYYPP, where YYYY is the 4 digit year (2003) and PP is the 2 digit period (01). |
|
RegHrs |
decimal | Optional. The employee’s regular hours for this transaction. | |
OvtHrs |
decimal | Optional. The employee’s overtime hours for this transaction. | |
RegAmt |
decimal | Optional. The employee’s regular cost amount for this transaction. | |
OvtAmt |
decimal | Optional. The employee’s overtime cost amount for this transaction. | |
BillEst |
decimal | Optional. The employee’s billing amount for this transaction. | |
BillStatus |
varchar | Required. The employee’s billing status for this transaction. B for billable, H for held, W for written-off, or N for nonbillable. | |
TransComment |
varchar | Optional. The comment for this charge. | |
SpecialOvtHrs |
decimal | Special overtime hours. | |
SpecialOvtAmt |
decimal | Special overtime cost amount. | |
SpecialOvtPct |
decimal | Special overtime percent. | |
SpecialOvtRate |
decimal | Special overtime rate. | |
RegAmtProjectCurrency |
decimal | 9 | Multicurrency only. |
OvtAmtProjectCurrency |
decimal | 9 | Multicurrency only. |
SpecialOvtAmtProjectCurrency |
decimal | 9 | Multicurrency only. |
RateProjectCurrency |
decimal | 9 | Multicurrency only. |
OvtRateProjectCurrency |
decimal | 9 | Multicurrency only. |
SpecialOvtRateProjectCurrency |
decimal | 9 | Multicurrency only. |
RegAmtBillingCurrency |
decimal | 9 | Multicurrency only. |
OvtAmtBillingCurrency |
decimal | 9 | Multicurrency only. |
SpecialOvtAmtBillingCurrency |
decimal | 9 | Multicurrency only. |
RateBillingCurrency |
decimal | 9 | Multicurrency only. |
OvtRateBillingCurrency |
decimal | 9 | Multicurrency only. |
SpecialOvtRateBillingCurrency |
decimal | 9 | Multicurrency only. |
RegAmtEmployeeCurrency |
decimal | 9 | Multicurrency only. |
OvtAmtEmployeeCurrency |
decimal | 9 | Multicurrency only. |
SpecialOvtAmtEmployeeCurrency |
decimal | 9 | Multicurrency only. |
RateEmployeeCurrency |
decimal | 9 | Multicurrency only. |
OvtRateEmployeeCurrency |
decimal | 9 | Multicurrency only. |
SpecialOvtRateEmployeeCurrency |
decimal | 9 | Multicurrency only. |
RealizationAmount |
decimal | 9 | Available only if you do not have the Multicurrency feature. Realization amount for the labor record. |
RealizationAmountEmployeeCurrency |
decimal | 9 | Available only if you have the Multicurrency feature. Realization amount for the labor record in the functional currency of the employee's company. |
RealizationAmountProjectCurrency |
decimal | 9 | Available only if you have the Multicurrency feature. Realization amount for the labor record in the project currency. |
RealizationAmountBillingCurrency |
decimal | 9 | Available only if you have the Multicurrency feature. Realization amount for the labor record in the billing currency. |