Accounting period of the transaction.

Posting sequence number.

Internal primary key.

The project number for the project associated with the labor transaction.

The reference field for the project phase. This column is populated by Deltek once the WBS1 column in this table is filled in.

The reference field for the project task. This column is populated by Deltek once the WBS1 column in this table is filled in.

Labor Code.

Employee number.

Transaction type.

The transaction's posting date.

The employee's name.

Total regular hours charged to the project.

Total overtime hours charged to the project.

The employee's total regular pay amount.

Total overtime amount for the employee.

Extended regular and overtime hours and amounts for the employee/project combination.

Rate at which the employee's services are billed for regular hours.

Percentage at which the employee's overtime hours are billed.

Rate at which the employee's services are billed for overtime hours.

Variable indicating the employee type. Valid options are P-Principal, E-Employee.

Reserved for future use.

The employee's labor category.

The employee's organization.

The project's organization.

Variable indicating the project's charge type. Valid options are R-Regular, H-Overhead, P-Promotional.

Variable indicating the employee's rate type at the time of posting. Valid options are H-Hourly, S-Salaried.

Internal sequence number.

Internal sequence number.

Flag indicating whether to suppress billing for the transaction.

Billing status for the labor transaction.

Comment entered for the labor transaction.

The project number for the project with which the transaction was final billed.

The reference field for the project phase. This column is populated by Deltek once the BilledWBS1 column in this table is filled in.

The reference field for the project task. This column is populated by Deltek once the BilledWBS1 column in this table is filled in.

Number of the invoice on which the labor transaction was final billed.

Accounting period in which the labor transaction was final billed.

The project number for the project from which the labor detail was transferred.

The reference field for the project phase. This column is populated by Deltek once the XferWBS1 column in this table is filled in.

The reference field for the project task. This column is populated by Deltek once the XferWBS1 column in this table is filled in.

Labor code from which the labor detail was transferred.

Flag indicating whether project reporting is activated.

Tax code that overrides the standard billing tax code.

Special overtime hours.

Special overtime cost amount.

Special overtime percent.

Special overtime rate.

The period for which the regular timesheet hours are included in the payroll run.

The internal posting sequence number for which the regular timesheet hours are included in the payroll run.

The employee's payroll rate, from either the Employee Info Center or from Accounting, Cost/Pay Rate Tables.

The employee's payroll overtime percentage, from either the Employee Info Center or from Accounting, Cost/Pay Rate Tables.

The employee's special overtime percentage, from either the Employee Info Center or from Accounting, Cost/Pay Rate Tables.

The period for which the overtime or special overtime timesheet hours are included in the payroll run.

The internal posting sequence number for which the overtime or special overtime timesheet hours are included in the payroll run.

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.

The user-defined tax locale.

The employee's regular pay amount in the functional currency of the company owning the project; phase, if any; and task, if any.

The employee's overtime pay amount in the functional currency of the company owning the project; phase, if any; and task, if any.

The employee's special overtime pay amount in the functional currency of the company owning the project; phase, if any; and task, if any.

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.

The employee's overtime rate in the functional currency of the company owning the project, phase if any, and task if any.

The employee's special overtime rate in the functional currency of the company owning the project, phase if any, and task if any.

For internal use.

The employee's regular pay amount in the billing currency.

The employee's overtime pay amount in the billing currency.

The employee's special overtime pay amount in the billing currency.

The employee's job cost rate in the billing currency.

The employee's overtime rate in the billing currency.

The employee's special overtime rate in the billing currency.

For internal use.

The employee's regular pay amount in the employee's home currency.

The employee's overtime pay amount in the employee's home currency.

The employee's special overtime pay amount in the employee's home currency.

The employee's job cost rate in the employee's home currency.

The employee's overtime rate in the employee's home currency.

The employee's special overtime rate in the employee's home currency.

For internal use.

The currency code for the associated employee's home currency.

The billing category for billing transferred labor transactions.

Flag indicating whether a cost rate table was used to calculate the transaction's cost rate.

The secondary tax code that will override the standard billing secondary tax code.

The user who modified this record.

The Employee ID of the employee who approved this transaction.

Labor realization amount in the employee currency.

Labor realization amount in the project currency.

Labor realization amount in the billing currency.

Invoice approval status.

End date of the linked timesheet entry.

This field indicates that the next invoice will be processed as a pre-invoice.

The pre-invoice number.

Traffic Live Internal Key

The field that indicates that the entry has been processed by TrafficLIVE. For internal use.