TInvoice contains the general information for an invoice record. This information includes the invoice's creation date, received date, posting status, vendor, currency, exchange rate, and so on. This table also links to the list of custom fields created for the invoice categories, as well as the list of line items that have been added to the invoice.
Object: TInvoice (T_INVOICE)
Attribute |
Database column name |
Field in UI |
End of path |
Bridge |
Links to object table: |
Data type |
Comments |
Commonly used in: |
|
Rules |
Temp/Wiz |
||||||||
categories--> Before TeamConnect 3.3 SP2: detailList--> |
n/a |
|
x |
x |
In Object Navigator, links to Category list which appears in the UI only. |
|
8 The list of categories added to the current object. --> In the object model, the added categories link to the values that have been added for custom fields, according to field type. --> In Object Navigator, this attribute is enhanced. It links to a list of all categories defined for the object definition, rather than those added to the current object. From there, you can select a category and traverse to the list of custom fields that belong to it. |
|
|
comment |
COMMENTS (VARCHAR2) (2053) |
Comments (General block) |
x |
|
|
string (2053) |
The comments intended to appear on the invoice for the vendor. |
|
|
createdBy--> |
CREATED_BY_ID (NUMBER) |
Created By (Security block) |
x |
x |
object |
8 The user who created the invoice record. --> Links to specific information about the user account. |
x |
x |
|
createdOn |
CREATED_ON (DATE) |
Created On (Security block) |
x |
|
|
date |
Date the invoice was created. |
x |
x |
createdOnBehalfOf |
CREATED_ON_ BEHALF_OF_ID |
|
|
x |
object |
When not null, it indicates that the record was created through an e-billing system or other external application. The contact referenced will often be a vendor in TeamConnect. |
X |
|
|
currency--> |
CURRENCY_ID (NUMBER) |
Currency (General block) |
|
x |
object |
8 The currency selected for the invoice. --> Links to the definition information of the currency. |
|
|
|
defaultCategory--> |
DEFAULT_CATEGO RY_ID (NUMBER) |
Default Category (Categories block) |
|
|
object |
8 The default category for the invoice. --> Links to the definition information of the category. |
|
x |
|
documentFolder--> |
DOCUMENT_FOLDE R_ID (NUMBER) |
Documents block |
|
x |
object |
Links to specific information about the document folder. |
|
|
|
exchangeRate |
EXCHANGE_RATE (NUMBER) |
|
x |
|
|
decimal |
The exchange rate of the invoice. |
|
|
expenseAdjustmentTotal |
EXPENSE_ADJUST MENT_TOTAL (NUMBER) |
Invoice Header - Total Fees & Expenses section, Expenses row Adjustments column intersection |
x |
|
|
decimal |
Sum of line item expense adjustments |
x |
x |
expenseDiscountTotal |
EXPENSE_DISCOU NT_TOTAL (NUMBER) |
Invoice Header - Total Fees & Expenses section, Expenses row Discounts column intersection |
x |
|
|
decimal |
Sum of line item expense original discounts |
x |
x |
expenseTaxTotal |
EXPENSE_TAX_TO TAL (NUMBER) |
Invoice Header - Total Fees & Expenses section, Expenses row Taxes column intersection |
x |
|
|
decimal |
(Taxable line item expense net total) *(Invoice tax rate) |
x |
x |
feeAdjustmentTotal |
FEE_ADJUSTMENT _TOTAL (NUMBER) |
Invoice Header - Total Fees & Expenses section, Fees row Adjustments column intersection |
x |
|
|
decimal |
Line item fee adjustments total. |
x |
x |
feeDiscountTotal |
FEE_DISCOUNT_T OTAL (NUMBER) |
Invoice Header - Total Fees & Expenses section, Fees row Discounts column intersection |
x |
|
|
decimal |
Line item fee original discounts total. |
x |
x |
feeTaxTotal |
FEE_TAX_TOTAL (NUMBER) |
Invoice Header - Total Fees & Expenses section, Fees row Taxes column intersection |
x |
|
|
decimal |
(Taxable line item fee net total) * (Invoice tax rate) |
x |
x |
groupAccessList--> |
n/a |
|
|
x |
|
Links to the group security information entered through the Security block of the record. |
|
|
|
hasNonUSTax |
HAS_NON_US_TAX |
|
x |
|
|
boolean |
If any line items have non-US tax codes entered in them, this value is TRUE, else it is FALSE. |
|
|
historyList--> |
n/a |
History tab |
x |
x |
object |
8 The list of all histories that are related to the invoice record. --> Links to specific history information for all of the invoice's history records. |
x |
|
|
invoiceAdjustmentTotal |
INVOICE_ADJUST MENT_TOTAL (NUMBER) |
Invoice Header - Total Fees & Expenses section, Line Items Total row Adjustments column intersection |
x |
|
|
decimal |
(Fee adjustments total) + (Expense adjustments total) |
x |
x |
invoiceDate |
INVOICE_DATE (DATE) |
Invoice Date (General block) |
x |
|
|
date |
The date when the invoice was issued. Time-zone-independent. |
x |
|
invoiceDiscountTotal |
INVOICE_DISCOU NT_TOTAL (NUMBER) |
Invoice Header - Total Fees & Expenses section, Line Items Total row Discounts column intersection |
x |
|
|
decimal |
(Fee discounts total) + (Expense discounts total) |
x |
x |
invoiceTaxTotal |
INVOICE_TAX_TOT AL (NUMBER) |
Invoice Header - Total Fees & Expenses section, Line Items Total row Taxes column intersection |
x |
|
|
decimal |
(Fee taxes total) + (Expense taxes total) |
x |
x |
isElectronic |
IS_ELECTRONIC |
|
x |
|
|
boolean |
If TRUE, indicates that the invoice originated from an e-billing application such as Collaborati. |
|
|
isPercentageDiscount |
IS_PERCENTAGE_ DISCOUNT |
|
x |
|
|
boolean |
An invoice discount in percent form. |
|
|
lineItems--> Before TeamConnect 3.3 SP2: lineItemList--> |
n/a |
|
x |
x |
|
8 The list of all line items that are added to the invoice record. --> Links to the join table that contains information for all line items added to the invoice. |
x |
x |
|
modifiedBy--> |
MODIFIED_BY_ID (NUMBER) |
Modified By (Security block) |
x |
x |
object |
8 The user who last modified the invoice record. --> Links to specific information about the user account. |
|
|
|
modifiedOn |
MODIFIED_ON (DATE) |
Modified On (Security block) |
x |
|
|
date |
The date the invoice was last modified. |
|
|
netExpenseTotal |
NET_EXPENSE_TO TAL (NUMBER) |
Invoice Header - Total Fees & Expenses section, Expenses row Total column intersection |
x |
|
|
decimal |
(Line item expenses total) + (Expense taxes total) |
x |
x |
netFeeTotal |
NET_FEE_TOTAL (NUMBER) |
Invoice Header - Total Fees & Expenses section, Fees row Total column intersection |
x |
|
|
decimal |
(Line item fees net total) + (Fees taxes total) |
x |
x |
netInvoiceTotal |
NET_INVOICE_TOT AL (NUMBER) |
Invoice Header - Total Fees & Expenses section, Line Items Total row, Total column intersection |
x |
|
|
decimal |
(Net fees total) + (Net expenses total) |
x |
x |
nextLineItemNumber |
NEXT_LINE_ITEM_ NUMBER |
|
x |
|
|
int |
Displays the next available line item number for this invoice. |
|
|
note--> |
NOTE_ID (NUMBER) |
Notes (General block) |
|
x |
object |
Links to the table that contains the text entered into the Notes field of the record. |
|
|
|
numberString |
NUMBER_STRING (VARCHAR2) (50) |
Number (General block) |
x |
|
|
string (50) |
Any alphanumeric text that describes the invoice record. |
|
|
originalExpenseTotal |
ORIGINAL_EXPEN SE_TOTAL (NUMBER) |
Invoice Header - Total Fees & Expenses section, Expenses row Original column intersection |
x |
|
|
decimal |
(Line item expenses Original total) + (Line item expenses Original discounts total) |
x |
x |
originalFeeTotal |
ORIGINAL_FEE_TO TAL (NUMBER) |
Invoice Header - Total Fees & Expenses section, Fees row Original column intersection |
x |
|
|
decimal |
(Line item fees Original total) + (Line item fees Original discounts total) |
x |
x |
originalInvoiceTotal |
ORIGINAL_INVOIC E_TOTAL (NUMBER) |
Invoice Header - Total Fees & Expenses section, Line Items Total row Original column intersection |
x |
|
|
decimal |
(Original fees total) + (Original expenses total) |
x |
x |
periodEndDate Before TeamConnect 3.3 SP2: periodEndOn |
PERIOD_END_ON (DATE) |
Period To (General block) |
x |
|
|
date |
The end date of the invoice period. Time-zone-independent. |
|
|
periodStartDate Before TeamConnect 3.3 SP2: periodStartOn |
PERIOD_START_O N (DATE) |
Period From (General block) |
x |
|
|
date |
The start date of the invoice period. Time-zone-independent. |
|
|
statusType Before TeamConnect 3.3 SP2: postingStatusIID |
STATUS_TYPE_IID (NUMBER) |
Status (General block) |
x |
|
|
int |
The posting status of the invoice. 1 - Not Submitted 2 - Posted 3 - Not Posted 5- Rejected* |
x |
|
primaryKey |
PRIMARY_KEY (NUMBER) |
|
x |
|
|
int |
The unique ID of the invoice record. |
|
|
receivedDate |
RECEIVED_DATE (DATE) |
Date Received (General block) |
x |
|
|
date |
The date when the invoice was received. Time-zone-independent. |
x |
|
referenceNumber |
REFERENCE_NUMB ER (VARCHAR 50) |
Reference Number |
|
|
|
string |
If this invoice is of type Credit Note, then referenceNumber matches the numberString value of the original standard invoice for which this credit is intended. |
|
|
securityTypeIID |
SECURITY_TYPE_I ID (NUMBER) |
Security Type (Security block) |
x |
|
|
int |
The security type of the invoice record . 0 - Public 2 - Private |
|
|
submittedElectronically Before TeamConnect 3.3 SP2: isElectronic |
IS_ELECTRONIC |
|
x |
|
|
boolean |
|
x |
|
submittedTotal Before TeamConnect 3.3 SP2: manualTotal |
MANUAL_AMOUNT (NUMBER) |
Manual Amount (General block) |
x |
|
|
decimal |
The total amount of the invoice as entered manually by the user. |
x |
|
taxRate |
TAX_RATE (NUMBER) |
|
|
|
|
|
Currently not used in TeamConnect. |
|
|
transaction--> |
TRANSACTION_ID (NUMBER) |
Transaction block |
|
x |
object |
Contains the last transaction associated with the invoice that was either posted to or voided from an account. |
|
|
|
typeIID |
TYPE_IID (NUMBER) |
Invoice Type (General block) |
x |
|
|
Enum |
The general type of the invoice. 0 - Standard (STANDARD) 1 - Accrual (ACCRUAL) 2 -Credit Note (CREDIT_NOTE) 3 - Shadow Invoice (SHADOW) |
x |
|
userAccessList--> |
n/a |
|
|
x |
|
Links to the user security information entered through the Security block of the record. |
|
|
|
vendor--> |
VENDOR_ID (NUMBER) |
Vendor (General block) |
x |
x |
object |
8 The contact record of the vendor associated with the invoice. --> Links to the specific information about the contact object. |
|
|
|
version |
VERSION (NUMBER) |
|
x |
|
|
int |
Indicates how many times the invoice record was updated. |
|
|
warnings |
WARNINGS |
Warnings |
|
|
|
string (2000) |
Warning message for the invoice captured by TeamConnect that is generated by another application that processes invoices. |
X |
|