Accounting period when the transaction was posted.

The transaction's posting sequence number.

Internal sequence number.

The project associated with the expense 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.

Number of the account adjusted by the transaction.

The organization of the project for this transaction.

The transaction type. Valid options are AP - accounts payable; CD - cash disbursement; CR - cash receipt; EP - employee expense payment; EX - expense report, IH - invoice history records converted from Deltek CFMS; IN - invoice, JE - journal entry; JX - journal entry adjustments for conversions from Deltek CFMS; PP - payment processing; RX - an adjustment related to a conversion; UN - units; XD - a general ledger adjustment related to a conversion from Deltek CFMS; XE - a project expense adjustment related to a conversion from Deltek CFMS.

The TransType sub-type. Valid options are AP: L - voucher line item, T - voucher tax (VAT) line item; CD T - cash disbursement tax (VAT) line item; CR: R - retainage, T - tax (VAT) line item, X - adjustment related to Deltek CFMS conversion; EP: A -  payment, R - reimbursement, T - tax (VAT) entry; EX: A - adjustment, T - tax line item (VAT); IN: I - interest, R - retainage, X - adjustment related to Deltek CFMS conversion; JE: T - tax (VAT) line item; PP: A - regular payment, C - payment from an AP disbursement transaction, D - discount  line item, T - tax (VAT) payment, V - void check; UN: B - billing only, C - cost only; XD: X -general ledger adjustment related to a Deltek CFMS conversion; XE: X - project expense adjustment related to a Deltek CFMS conversion.

Reference number entered for the transaction during data entry.

Date entered for the transaction during data entry.

First description entered for the transaction.

Second description entered for the transaction.

Amount of the transaction for General Ledger reporting purposes.

Amount of the transaction for cash-basis reporting purposes.

Billing extension for generating project reports at billing rates.

Internal flag for project reporting.

Variable indicating whether this transaction is the result of an implicit posting.

Variable indicating whether to suppress billing for this transaction.

Billing status for this expense transaction.

Flag indicating whether to include this transaction for General Ledger Reporting (history transactions are not included.)

Bank Code assigned to this transaction.

Number of the invoice paid by this transaction.

Variable indicating the invoice section to which this transaction applies. Valid choices are F-Fee, L-Labor, E-Expense, C-Consultant, U-Unit, A-Add-on.

Employee number.

Vendor number.

Line number for the accounts payable voucher.

Partial payment amount in the voucher payment record.

Discount amount in the voucher payment record.

Voucher number.

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 this transaction was final billed.

Accounting period in which the transaction was final billed.

Unit number.

Unit table associated with the project to which the unit was charged.

Number of items specified for the unit.

The unit's cost rate per unit.

The unit's billing rate per unit.

The unit's billing extension, calculated as UnitQuantity times UnitBillingRate.

Internal sequence number.

Fiscal year and period for the expense detail.

Posting sequence number.

The project number for the project from which the expense 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.

Account from which the expense detail was transferred.

Tax code associated with the transaction.

Tax basis, if any, associated with the transaction.

Cash basis tax basis, if any, associated with the transaction.

Tax code that will override the standard billing tax code.

The accounting period that was active when this record was written off (billing status "X.")

The transaction amount in the project's project currency.

The transaction's currency code.

For internal use.

The transaction amount in the project's project currency.

For internal use.

The transaction amount in the project's billing currency.

For internal use.

For internal use.

For internal use.

For internal use.

For internal use.

The transaction amount in the billing currency for invoices (invoices and receipts.)

For internal use.

The purchase order number.

The UN Table CostRate in the billing currency.

For transactions posted or to be posted to intercompany accounts, this is the Due To or Due From company.

For transactions posted or to be posted to intercompany accounts, the Due To or Due From project.

For transactions posted or to be posted to intercompany accounts, the Due To or Due From phase.

For transactions posted or to be posted to intercompany accounts, the Due To or Due From task.

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

For internal use.

The Amount expressed in the transaction's tax currency.

The CBAmount expressed in the transaction's tax currency.

The TaxBasis expressed in the transaction's tax currency.

The TaxCBBasis expressed in the transaction's tax currency.

The TaxBasis expressed in the transaction's functional currency.

The TaxCBBasis expressed in the transaction's functional currency.

The user who modified this record.

The EmployeeID of the employee who approved this transaction.

Unit realization amount in the employee currency.

Unit realization amount in the project currency.

Unit  realization amount in the billing currency.

Credit memo invoice number.

Original Amount Source Currency

Original Payment Currency Code

Indicator of in-process account entry.

Indicator of in-process account cleared entry.

The original line number of this transaction, used to tie a billing transfer back to the expense "reason."

Invoice approval status.

The actual vendor for this line item, if different from the vendor being paid.

Diary

Diary Number

Primary Credit Card Code.

Credit Card Code.

For internal use.

The pre-invoice number.

This field indicates that the current invoice has a template setting of enable format for total earned calculation, meaning that the fee will display as the full earned amount.

The pre-invoice number.

The Equipment ID used for asset management.

The Additional Book code for asset management.

The employee organization for employee related units.