Accounting period when the labor transaction was posted.

Posting sequence number.

Internal primary key.

Project number.

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.

Date when the labor transaction was posted.

Employee name.

Regular hours posted.

Overtime hours posted.

Regular amount posted.

Overtime amount posted.

Extended billing amount entered.

Employee's rate.

Employee's overtime percent.

Employee's overtime rate.

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

Reserved for future use.

Default billing category for the By Category labor billing method.

Employee's organization.

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. Valid options are H-Hourly, S-Salaried.

Internal primary key.

Internal primary key.

Variable indicating whether to suppress billing for the transaction.

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.

Project with which the labor detail 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.

Invoice on which the labor detail was final billed.

Period when the labor detail was final billed.

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.

Internal flag used for interactive project reporting.

Tax code that will override the standard billing tax code.

Special overtime hours.

Special overtime 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 final written-off (X) status, and a deleted (D) item is changed to final deleted (O) status.

The 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 amount in the billing currency, as identified in the project record.  Applies to all but time analysis conversion adjustment transactions.

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 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 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.

The first recurrence date for a managed recurring transaction file.

This field indicates that the transaction file is a managed recurring transaction file.

Traffic Live Internal Key

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