| ColumnName |
Domain |
Datatype |
NULL |
Definition |
Period |
|
int |
NO |
Accounting period when the labor transaction was posted. |
| PostSeq |
|
int |
NO |
Posting sequence number. |
| PKey |
|
varchar(32) |
NO |
Internal primary key. |
| WBS1 |
|
nvarchar(30) |
YES |
Project number. |
| 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 |
Date when the labor transaction was posted. |
| Name |
|
nvarchar(100) |
YES |
Employee name. |
| RegHrs |
|
decimal(19, 4) |
NO |
Regular hours posted. |
| OvtHrs |
|
decimal(19, 4) |
NO |
Overtime hours posted. |
| RegAmt |
|
decimal(19, 4) |
NO |
Regular amount posted. |
| OvtAmt |
|
decimal(19, 4) |
NO |
Overtime amount posted. |
| BillExt |
|
decimal(19, 4) |
NO |
Extended billing amount entered. |
| Rate |
|
decimal(19, 4) |
NO |
Employee's rate. |
| OvtPct |
|
decimal(19, 4) |
NO |
Employee's overtime percent. |
| OvtRate |
|
decimal(19, 4) |
NO |
Employee's overtime rate. |
| 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 |
Default billing category for the By Category labor billing method. |
| EmOrg |
|
nvarchar(30) |
YES |
Employee's organization. |
| PrOrg |
|
nvarchar(30) |
YES |
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. Valid options are H-Hourly, S-Salaried. |
| DebitLedgerMiscPKey |
|
varchar(32) |
YES |
Internal primary key. |
| CreditLedgerMiscPKey |
|
varchar(32) |
YES |
Internal primary key. |
| SuppressBill |
|
varchar(1) |
NO |
Variable indicating whether to suppress billing for the transaction. |
| BillStatus |
|
varchar(1) |
YES |
Variable indicating the billing status for the labor transaction. Valid options are B-Billable (released and available for billing to the client); D - Marked for deletion; F - Final billed (already billed to the client); H - Held (to temporarily prevent billing to the client); M - Modified (changed in some way from the original); N - Not billable; O - Deleted; R - Partial hold/released (part of the transaction has already been held or released); T - Transferred (moved from one project, phase, task, or labor code to another); W - To be written off (transaction has been written off, but the invoice has not been posted); X - Written off (transaction has been written off, and the invoice has been posted.) |
| Comment |
|
nvarchar(4000) |
YES |
Comment. |
| BilledWBS1 |
|
nvarchar(30) |
YES |
Project with which the labor detail 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 |
Invoice on which the labor detail was final billed. |
| BilledPeriod |
|
int |
NO |
Period when the labor detail was final billed. |
| XferWBS1 |
|
nvarchar(30) |
YES |
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 |
Internal flag used for interactive project reporting. |
| BillTaxCodeOverride |
|
nvarchar(10) |
YES |
Tax code that will override the standard billing tax code. |
| SpecialOvtHrs |
|
decimal(19, 4) |
NO |
Special overtime hours. |
| SpecialOvtAmt |
|
decimal(19, 4) |
NO |
Special overtime 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 final written-off (X) status, and a deleted (D) item is changed to final deleted (O) status. |
| Locale |
|
nvarchar(10) |
YES |
The 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 amount in the billing currency, as identified in the project record. Applies to all but time analysis conversion adjustment transactions. |
| 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 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 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 |
The first recurrence date for a managed recurring transaction file. |
| TransferredBillStatus |
|
varchar(1) |
YES |
This field indicates that the transaction file is a managed recurring transaction file. |
| 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. |