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

EInvcDetail

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

YUser

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

TContact

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

YCurrencyInfo

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)

YRecentlyViewedRecord

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

TDocument

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

EInvcGroupAccess

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

THistory

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

JInvcLineItem

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

YUser

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

JNote

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

RTransaction

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

EInvcUserAccess

Links to the user security information entered through the Security block of the record.

vendor-->

VENDOR_ID

(NUMBER)

Vendor

(General block)

x

x

TContact

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