| ColumnName |
Domain |
Datatype |
NULL |
Definition |
Period |
|
int |
NO |
Accounting period of the transaction. |
| PostSeq |
|
int |
NO |
Posting sequence number. |
| PKey |
|
varchar(32) |
NO |
Internal primary key. |
| WBS1 |
|
nvarchar(30) |
YES |
The project number for the project associated with the labor transaction. |
| WBS2 |
|
nvarchar(30) |
YES |
The reference field for the project phase. This column is populated by Deltek once the WBS1 column in this table is filled in. |
| WBS3 |
|
nvarchar(30) |
YES |
The reference field for the project task. This column is populated by Deltek once the WBS1 column in this table is filled in. |
| LaborCode |
|
nvarchar(14) |
YES |
Labor Code. |
| Employee |
|
nvarchar(20) |
YES |
Employee number. |
| TransType |
|
nvarchar(2) |
YES |
Transaction type. |
| TransDate |
|
datetime |
YES |
The transaction's posting date. |
| Name |
|
nvarchar(100) |
YES |
The employee's name. |
| RegHrs |
|
decimal(19, 4) |
NO |
Total regular hours charged to the project. |
| OvtHrs |
|
decimal(19, 4) |
NO |
Total overtime hours charged to the project. |
| RegAmt |
|
decimal(19, 4) |
NO |
The employee's total regular pay amount. |
| OvtAmt |
|
decimal(19, 4) |
NO |
Total overtime amount for the employee. |
| BillExt |
|
decimal(19, 4) |
NO |
Extended regular and overtime hours and amounts for the employee/project combination. |
| Rate |
|
decimal(19, 4) |
NO |
Rate at which the employee's services are billed for regular hours. |
| OvtPct |
|
decimal(19, 4) |
NO |
Percentage at which the employee's overtime hours are billed. |
| OvtRate |
|
decimal(19, 4) |
NO |
Rate at which the employee's services are billed for overtime hours. |
| EmType |
|
varchar(1) |
YES |
Variable indicating the employee type. Valid options are P-Principal, E-Employee. |
| Pool |
|
smallint |
NO |
Reserved for future use. |
| Category |
|
smallint |
NO |
The employee's labor category. |
| EmOrg |
|
nvarchar(30) |
YES |
The employee's organization. |
| PrOrg |
|
nvarchar(30) |
YES |
The project's organization. |
| ChargeType |
|
varchar(1) |
YES |
Variable indicating the project's charge type. Valid options are R-Regular, H-Overhead, P-Promotional. |
| RateType |
|
varchar(1) |
YES |
Variable indicating the employee's rate type at the time of posting. Valid options are H-Hourly, S-Salaried. |
| DebitLedgerMiscPKey |
|
varchar(32) |
YES |
Internal sequence number. |
| CreditLedgerMiscPKey |
|
varchar(32) |
YES |
Internal sequence number. |
| SuppressBill |
|
varchar(1) |
NO |
Flag indicating whether to suppress billing for the transaction. |
| BillStatus |
|
varchar(1) |
YES |
Billing status for the labor transaction. |
| Comment |
|
nvarchar(4000) |
YES |
Comment entered for the labor transaction. |
| BilledWBS1 |
|
nvarchar(30) |
YES |
The project number for the project with which the transaction was final billed. |
| BilledWBS2 |
|
nvarchar(30) |
YES |
The reference field for the project phase. This column is populated by Deltek once the BilledWBS1 column in this table is filled in. |
| BilledWBS3 |
|
nvarchar(30) |
YES |
The reference field for the project task. This column is populated by Deltek once the BilledWBS1 column in this table is filled in. |
| BilledInvoice |
|
nvarchar(12) |
YES |
Number of the invoice on which the labor transaction was final billed. |
| BilledPeriod |
|
int |
NO |
Accounting period in which the labor transaction was final billed. |
| XferWBS1 |
|
nvarchar(30) |
YES |
The project number for the project from which the labor detail was transferred. |
| XferWBS2 |
|
nvarchar(30) |
YES |
The reference field for the project phase. This column is populated by Deltek once the XferWBS1 column in this table is filled in. |
| XferWBS3 |
|
nvarchar(30) |
YES |
The reference field for the project task. This column is populated by Deltek once the XferWBS1 column in this table is filled in. |
| XferLaborCode |
|
nvarchar(14) |
YES |
Labor code from which the labor detail was transferred. |
| ProjectCost |
|
varchar(1) |
NO |
Flag indicating whether project reporting is activated. |
| BillTaxCodeOverride |
|
nvarchar(10) |
YES |
Tax code that overrides the standard billing tax code. |
| SpecialOvtHrs |
|
decimal(19, 4) |
NO |
Special overtime hours. |
| SpecialOvtAmt |
|
decimal(19, 4) |
NO |
Special overtime cost amount. |
| SpecialOvtPct |
|
decimal(19, 4) |
NO |
Special overtime percent. |
| SpecialOvtRate |
|
decimal(19, 4) |
NO |
Special overtime rate. |
| SelPeriod |
|
int |
NO |
The period for which the regular timesheet hours are included in the payroll run. |
| SelPostSeq |
|
int |
NO |
The internal posting sequence number for which the regular timesheet hours are included in the payroll run. |
| Payrate |
|
decimal(19, 4) |
NO |
The employee's payroll rate, from either the Employee Info Center or from Accounting, Cost/Pay Rate Tables. |
| PayOvtPct |
|
decimal(19, 4) |
NO |
The employee's payroll overtime percentage, from either the Employee Info Center or from Accounting, Cost/Pay Rate Tables. |
| PaySpecialOvtPct |
|
decimal(19, 4) |
NO |
The employee's special overtime percentage, from either the Employee Info Center or from Accounting, Cost/Pay Rate Tables. |
| SelOvtPeriod |
|
int |
NO |
The period for which the overtime or special overtime timesheet hours are included in the payroll run. |
| SelOvtPostSeq |
|
int |
NO |
The internal posting sequence number for which the overtime or special overtime timesheet hours are included in the payroll run. |
| WrittenOffPeriod |
|
int |
NO |
The fiscal period when a write-off (W) item is changed to finall written off (X) status, and a deleted (D) item is changed to final deleted (O) status. |
| Locale |
|
nvarchar(10) |
YES |
The user-defined tax locale. |
| RegAmtProjectCurrency |
|
decimal(19, 4) |
NO |
The employee's regular pay amount in the functional currency of the company owning the project; phase, if any; and task, if any. |
| OvtAmtProjectCurrency |
|
decimal(19, 4) |
NO |
The employee's overtime pay amount in the functional currency of the company owning the project; phase, if any; and task, if any. |
| SpecialOvtAmtProjectCurrency |
|
decimal(19, 4) |
NO |
The employee's special overtime pay amount in the functional currency of the company owning the project; phase, if any; and task, if any. |
| RateProjectCurrency |
|
decimal(19, 4) |
NO |
The employee's job cost rate in the functional currency of the company owning the project, the project phase, if any, and the project task, if any. |
| OvtRateProjectCurrency |
|
decimal(19, 4) |
NO |
The employee's overtime rate in the functional currency of the company owning the project, phase if any, and task if any. |
| SpecialOvtRateProjectCurrency |
|
decimal(19, 4) |
NO |
The employee's special overtime rate in the functional currency of the company owning the project, phase if any, and task if any. |
| ProjectExchangeInfo |
|
nvarchar(4000) |
YES |
For internal use. |
| RegAmtBillingCurrency |
|
decimal(19, 4) |
NO |
The employee's regular pay amount in the billing currency. |
| OvtAmtBillingCurrency |
|
decimal(19, 4) |
NO |
The employee's overtime pay amount in the billing currency. |
| SpecialOvtAmtBillingCurrency |
|
decimal(19, 4) |
NO |
The employee's special overtime pay amount in the billing currency. |
| RateBillingCurrency |
|
decimal(19, 4) |
NO |
The employee's job cost rate in the billing currency. |
| OvtRateBillingCurrency |
|
decimal(19, 4) |
NO |
The employee's overtime rate in the billing currency. |
| SpecialOvtRateBillingCurrency |
|
decimal(19, 4) |
NO |
The employee's special overtime rate in the billing currency. |
| BillingExchangeInfo |
|
nvarchar(4000) |
YES |
For internal use. |
| RegAmtEmployeeCurrency |
|
decimal(19, 4) |
NO |
The employee's regular pay amount in the employee's home currency. |
| OvtAmtEmployeeCurrency |
|
decimal(19, 4) |
NO |
The employee's overtime pay amount in the employee's home currency. |
| SpecialOvtAmtEmployeeCurrency |
|
decimal(19, 4) |
NO |
The employee's special overtime pay amount in the employee's home currency. |
| RateEmployeeCurrency |
|
decimal(19, 4) |
NO |
The employee's job cost rate in the employee's home currency. |
| OvtRateEmployeeCurrency |
|
decimal(19, 4) |
NO |
The employee's overtime rate in the employee's home currency. |
| SpecialOvtRateEmployeeCurrency |
|
decimal(19, 4) |
NO |
The employee's special overtime rate in the employee's home currency. |
| ExchangeInfo |
|
nvarchar(4000) |
YES |
For internal use. |
| EMCurrencyCode |
|
nvarchar(3) |
YES |
The currency code for the associated employee's home currency. |
| XferCategory |
|
smallint |
NO |
The billing category for billing transferred labor transactions. |
| CostRateTableUsed |
|
varchar(1) |
NO |
Flag indicating whether a cost rate table was used to calculate the transaction's cost rate. |
| BillTax2CodeOverride |
|
nvarchar(10) |
YES |
The secondary tax code that will override the standard billing secondary tax code. |
| ModUser |
|
nvarchar(20) |
YES |
The user who modified this record. |
| AuthorizedBy |
|
nvarchar(20) |
YES |
The Employee ID of the employee who approved this transaction. |
| RealizationAmountEmployeeCurrency |
|
decimal(19, 4) |
NO |
Labor realization amount in the employee currency. |
| RealizationAmountProjectCurrency |
|
decimal(19, 4) |
NO |
Labor realization amount in the project currency. |
| RealizationAmountBillingCurrency |
|
decimal(19, 4) |
NO |
Labor realization amount in the billing currency. |
| NonBill |
|
varchar(1) |
YES |
|
| InvoiceStatus |
|
varchar(1) |
YES |
Invoice approval status. |
| TimekeeperEndDate |
|
datetime |
YES |
End date of the linked timesheet entry. |
| TransferredPeriod |
|
int |
NO |
This field indicates that the next invoice will be processed as a pre-invoice. |
| TransferredBillStatus |
|
varchar(1) |
YES |
The pre-invoice number. |
| TLInternalKey |
|
nvarchar(40) |
YES |
Traffic Live Internal Key |
| TLProcessed |
|
varchar(1) |
NO |
The field that indicates that the entry has been processed by TrafficLIVE. For internal use. |