Skip to main content
Mitratech Success Center

TInvoice

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

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

YCurrency
Info

object

8 The currency selected for the invoice.

--> Links to the definition information of the currency.

   

default
Category
-->

DEFAULT_CATEGORY_ID
(NUMBER)

Default Category
(Categories block)

   

YRecently
Viewed
Record

object

8 The default category for the invoice.

--> Links to the definition information of the category.

 

x

document
Folder-->

DOCUMENT_FOLDER_ID
(NUMBER)

Documents block

 

x

TDocument

object

Links to specific information about the document folder.

   

exchange
Rate

EXCHANGE_RATE
(NUMBER)

 

x

   

decimal

The exchange rate of the invoice.

   

expense
Adjustment Total

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

expense
Discount
Total

EXPENSE_DISCOUNT_TOTAL (NUMBER)

Invoice Header - Total Fees& Expenses section, Expenses
row Discounts
column intersection

x

   

decimal

Sum of line item expense original discounts

x

x

expense
TaxTotal

EXPENSE_TAX_
TOTAL (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

fee
AdjustmentTotal

FEE_
ADJUST
MENT _TOTAL (NUMBER)

Invoice Header - Total Fees& Expenses section, Fees row Adjustments column intersection

x

   

decimal

Line item fee adjustments total.

x

x

fee
Discount Total

FEE_
DISCOUNT_ TOTAL (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

group
AccessList-->

n/a

   

x

EInvcGroup Access

 

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

 

invoice
Adjustment Total

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

invoice
Date

INVOICE_
DATE (DATE)

Invoice
Date
(General block)

x

   

date

The date when the invoice was issued.
Time-zone- independent .

x

 

invoice
Discount
Total

INVOICE_
DISCOUNT_TOTAL (NUMBER)

Invoice Header - Total Fees& Expenses section, Line Items Total row Discounts column intersect ion

x

   

decimal

(Fee discounts total) + (Expense discounts total)

x

x

invoiceTax Total

INVOICE_
TAX_
TOTAL (NUMBER)

Invoice Header - Total Fees& Expenses section, 
Line Items Total row Taxes column intersection

x

   

decimal

(Fee taxes total) + (Expense taxes total)

x

x

is
Electronic

IS_
ELECTRONIC

 

x

   

boolean

If TRUE,
indicates that the invoice originated from an e- billing application such as Collaborati.

   

is
PercentageDiscount

IS_PERC
ENTAGE_ DISCOUNT

 

x

   

boolean

An invoice discount in percent form.

   

lineItems
-->

Before TeamConnect 3.3 SP2:

lineItem
List
-->

n/a

 

x

x

JInvcLine
Item

 

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.

   

modified
On

MODIFIED_ON (DATE)

Modified On
(Security block)

x

   

date

The date the invoice was last modified.

   

net
Expense Total

NET_
EXPENSE_TOTAL (NUMBER)

Invoice Header - Total Fees & Expenses section, Expenses
row Total column intersect ion

x

   

decimal

(Line item expenses total) + (Expense taxes total)

x

x

netFee
Total

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_
TOTAL (NUMBER)

Invoice Header - Total Fees& Expenses section, Line Items Total row,
Total 
column intersection

x

   

decimal

(Net fees total) + (Net expenses total)

x

x

nextLine
Item
Number

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.

   

number
String

NUMBER_STRING
(VARCHAR2) (50)

Number
(General block)

x

   

string
(50)

Any alphanumeric text that describes the invoice record.

   

original
Expense
Total

ORIGINAL_EXPENSE_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

original
FeeTotal

ORIGINAL_FEE_
TOTAL (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

original
Invoice
Total

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

   

periodStart Date

Before TeamConnect 3.3 SP2: periodStart On

PERIOD_ START_ ON (DATE)

Period From (General block)

x

   

date

The start date of the invoice period.
Time-zone- independent .

   

statusType

Before TeamConnect 3.3 SP2:
posting
StatusIID

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

 

primary
Key

PRIMARY_KEY (NUMBER)

 

x

   

int

The unique ID of the invoice record.

   

received
Date

RECEIVED_DATE (DATE)

Date Received (General block)

x

   

date

The date when the invoice was received.
Time-zone- independent .

x

 

reference
Number

REFEREN CE_
NUMBER (VARCHAR 50)

Reference Number

     

string

If this invoice is of type Credit Note, then reference
Number matches the numberString value of the original standard invoice for which this credit is intended.

   

security
TypeIID

SECURITY_TYPE_IID (NUMBER)

Security Type (Security block)

x

   

int

The security type of the invoice record .

0 - Public
2 - Private

   

submitted
Ellectronically

Before TeamConnect 3.3 SP2:

isElectronic

IS_ELECTRONIC

 

x

   

boolean

 

x

 

submitted
Total

Before TeamConnect 3.3 SP2:

manual
Total

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

TRANS
ACTION_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

 

user
Access List-->

n/a

   

x

EInvcUser
Access

 

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 TeamConne ct that is generated by another application that processes invoices.

X

 

JInvcCategoryAdjustment

JInvcCategoryAdjustment contains information about the adjustment of line items in an invoice record. This information includes the nature of the adjustment calculation, the reason for the adjustment, and comments about the adjustment.

Object: JInvcCategoryAdjustment (J_INVC_CATEGORY_ADJUSTMENT)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

               

Rules

Temp/Wiz

 

ADJUSTED_ BY_ID (NUMBER)

 

x

x

YUser

Number

8 The user who made the adjustment.

--> Links to specific information about the user account.

x

x

adjustmentDate

Before TeamConn ect 3.3
SP2: adjustedOn

ADJUSTED_ ON (DATE)

       

date

Defaults to current date/time.

   

adjustmentAmount

ADJUSTME NT_
AMOUNT (NUMBER)

 

x

   

decimal

Adjustment amount.

   

adjustmentMethod

Before TeamConn ect 3.3
SP2: adjustment
TypeIID

IS_
TAXABLE (NUMBER)

 

x

   

int

Adjustment type. One of these choices:

1 = By Amount
2 = By Percentage
3 = To Amount

   

adjustment Reason-->

ADJUSTME NT_
REASON
(NUMBER)

 

x

x

 

object

8 The selected reason for the adjustment.

   

dcategory
-->

CATEGORY_ ID
(NUMBER)

Category

     

object

8 The category fto which this adjustment applies.

 

x

comments ToVendor

COMMENT_TO_
VENDOR
(VARCHAR 250)

 

x

   

string (250)

Comments about the adjustment that will be visible to vendors outside your company.

   

inHouse
Comments

IN_HOUSE_ COMMENT<
(VARCHAR 250)

 

x

   

stri ng (25

0)

Comments that are private, not transmitted to vendors or other outside sources.

   

iowner-->

INVOICE_
ID (NUMBER)

   

x

TInvoice

object

8 The invoice to which the line item belongs.

--> Links to the specific information about the invoice object.

   

project-->

PROJECT_
ID
(NUMBER)

Project

x

x

TProject

object

8 The project associated with the adjustment.

--> Links to the specific information about the project object.

x

x

previous
NetTotal

PREVIOUS_NET_
TOTAL
(NUMBER)

Original Discount

x

   

decimal

The net total of the entire invoice immediately before the current adjustment was applied.

   

primary
Key

PRIMARY_KEY
(NUMBER)

 

x

   

int

The unique ID of this object.

   

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the object was updated.

   

JInvcHeaderAdjustment

JInvcHeaderAdjustment contains information about the adjustment of line items in an invoice record. This information includes the nature of the adjustment calculation, the reason for the adjustment, and comments about the adjustment.

Object: JInvcHeaderAdjustment (J_INVC_ADJUSTMENT)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

               

Rules

Temp/Wiz

 

ADJUSTED_BY_ID (NUMBER)

 

x

x

YUser

Number

8 The user who made the adjustment.

--> Links to specific information about the user account.

x

x

adjustmentDate

Before TeamConnect 3.3
SP2: adjustedOn

ADJUSTED_ON (DATE)

       

date

Defaults to current date/ time.

   

adjustmentMethod

Before TeamConnect 3.3
SP2: adjustment
TypeIID

IS_
TAXABLE (NUMBER)

 

x

   

int

Adjustment type. One of these choices:

1 = By Amount
2 = By Percentage 3 = To Amount

   

adjustmentReason-->

ADJUSTMENT_
REASON (NUMBER)

 

x

x

 

object

8 The selected reason for the adjustment.

   

adjustment
TargetIID

Before TeamConnect 3.3
SP2: adjustment
Target

ADJUSTMENT_
TARGET_
ID (NUMBER)

 

x

   

int

The target area to be impacted by the adjustment. One of these choices:

1 = Total Fees
2 = Total Expenses
3 = Total Invoice

   

adjustment
Total
Expenses

ADJUSTMENT_
TOTAL_
EXPENSES (NUMBER)

 

x

   

decimal

Adjustment amount to be applied only to the expense portion of the invoice. Calculation is done as specified by attribute adjustment
TypeIID.

   

adjustment
TotalFees

ADJUSTMENT_TOTAL_FEES (NUMBER)

 

x

   

decimal

Adjustment to be applied only to the fee portion of the invoice. Calculation is done as specified by attribute adjustment
TypeIID.

   

adjustment
Total
Invoice

ADJUSTMENT_
TOTAL_
INVOICES (NUMBER)

 

x

   

decimal

Adjustment to be applied to the entire amount of the invoice. 
Calculation is done as specified by attribute adjustment
TypeIID.

   

comments
ToVendor

COMMENT_TO_
VENDOR (VARCHAR 250)

 

x

   

string (250)

Comments about the adjustment that will be visible to vendors outside your company.

   

inHouse
Comments

IN_
HOUSE_
COMMENT< (VARCHAR 250)

 

x

   

string (250)

Comments that are private, not transmitted to vendors or other outside sources.

   

owner-->

Before TeamConnect 3.3
SP2: invoice-->

INVOICE_
ID (NUMBER)

   

x

TInvoice

object

8 The invoice to which the line item belongs.

--> Links to the specific information about the invoice object.

   

previous
NetTotal

PREVIOUS_NET_
TOTAL (NUMBER)

Original Discount

x

   

decimal

The net total of the entire invoice immediately before the current adjustment was applied.

   

primary
Key

PRIMARY_KEY (NUMBER)

 

x

   

int

The unique ID of this object.

   

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the object was updated.

   

JInvcLineItem

JInvcLineItem contains information about the line items in an invoice record. This information includes the project to which the line item is associated, amount, line item type (such as task or expense), activity, task category, timekeeper, and service date. This table represents the Line Items block on the Line Items tab of an invoice record.

Object: JInvcLineItem (J_INVC_LINE_ITEM)

Attribute

Database column name

Field in user interface

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

               

Rules

Temp/Wiz

activity

Before TeamConnect 3.3
SP2:

activityItem

ACTIVITY_
ITEM_ID (NUMBER)

Activity Item

x

x

LTask
ActivityItem

object

8 The activity item associated with the line item of type task.

--> Links to the definition information for the task activity item.

x

x

adjusted
Discount

Before TeamConnect 3.3
SP2:
netDiscount

ADJUSTED_
DISCOUNT (NUMBER)

Net Discount

x

   

decimal

The net discount of the line item.

   

adjusted
Quantity

Before TeamConnect 3.3
SP2: netQuantity

ADJUSTED_
QUANTITY (NUMBER)

Net Quantity

x

   

decimal

The net quantity of the line item.

   

adjusted
Rate

Before TeamConnect 3.3
SP2: netRate

ADJUSTED_RATE
(NUMBER)

Net Rate

x

   

decimal

The net rate of the line item.

   

adjusted
Total

Before TeamConnect 3.3
SP2: netTotal

TOTAL_
AMOUNT (NUMBER)

Net Total

x

   

decimal

The net total of the line item.

   

adjustments

Before TeamConnect 3.3
SP2: adjustment
List

   

x

x

 

list

8 Any invoice adjustments that have been entered against this line item.

--> Links to any adjustments that have been entered against this line item.

   

categories
-->

Before TeamConnect 3.3
SP2: detailList-->

   

x

x

ELitmDetail

list

8 The custom field detail values that have been entered against this line item.

--> Links to the collection of custom field detail values that have been entered against this line item.

   

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

currency
Item-->

CURRENCY_ITEM
_ID (NUMBER)

         

Currently not used.

   

default
Category

DEFAULT_CATEGORY_ID

Default Category (Categories block)

x

x

YRecently
Viewed
Record

object

8 The default category for the line item.

--> Links to the definition information of the category.

   

default
Currency
Net
Discount

DEFAULT_CURR_
DISCOUNT (NUMBER)

 

x

   

decimal

The net discount of the line item in the system's default currency.

   

default
Currency
NetRate

DEFAULT _CURR
_RATE

 

x

   

decimal

The net rate of the line item in the system's 
default currency

   

default
Currency
NetTotal

DEFAULT _CURR_
TOTAL (NUMBER)

 

x

   

decimal

The net total of the line item in the system's default currency.

   

expense
Category
-->

EXPENSE_TYPE_ID (NUMBER)

Category (when Expense is selected in the Task/
Expense
field)

x

x

YRecently
Viewed
Record

object

8 The expense category of the line item, if the line item is an expense.

--> Links to the definition information of the category.

x

x

group
Access List
-->

     

x

ELitmGroup

list

8 The non- default group access rights that have been granted against this line item.

--> Links to the collection of non-default group access rights that have been granted against this line item.

   

has
Warnings

HAS_
WARNINGS
(NUMBER)

 

x

   

boolean

Indicates whether 
warning conditions have been noted for this line item.

   

involved-->

INVOLVED_ID (NUMBER)

 

x

x

   

Currently not used.

   

item
Number

Before TeamConnect 3.3
SP2: itemNum

ITEM_
NUMBER

 

x

   

int

The number assigned to the line item at the time it was created.Invo ice item numbers begin at 1 and increment as high as necessary to accommodate the invoice's line item.If a line item is deleted, its item number is not reused for any existing or future line item.

   

modifiedBy
-->

MODIFIED _BY_ID (NUMBER)

 

x

x

YUser

object

8 The user who last modified the line item.

--> Links to specific information about the user account.

   

modified
On

MODIFIED
_ON (DATE)

Last
Modified On

 

x

 

   

date

The date that the line item was modified.

   

note

Before TeamConnect 3.3
SP2:

short
Description

ITEM_
DESCRIPTION
(VARCHAR2)(250)

Description

 

x

 

   

string
(2000)

The description of the line item.

 

x

original
Discount

DISCOUNT_PERCENT(NUMBER)

Original Discount

 

x

 

   

decimal

The original discount of the line item.

   

original
Quantity

QUANTITY
(NUMBER)

Original Quantity

 

x

 

   

decimal

The original quantity of the line item.

   

original
Rate

UNIT_
PRICE
(NUMBER)

Original Rate

 

x

 

   

decimal

The original rate of the line item.

   

original
Total

GROSS_
AMOUNT
(NUMBER)

Original Total

 

x

 

   

decimal

The original total of the line item.

   

owner-->

INVOICE_ ID
(NUMBER)

   

 

x

 

TInvoice

object

8 The invoice to which the line item belongs.

--> Links to the specific information about the invoice object.

   

primary
Key

PRIMARY_KEY (NUMBER)

 

 

x

 

   

int

The unique ID of the line item.

   

project-->

PROJECT _ID (NUMBER)

Project

x

x

TProject

object

8 The project associated with the line item.

--> Links to the specific information about the project object.

x

x

security
TypeIID

SECURITY_TYPE_ID (NUMBER)

 

x

   

int

Security type. One of these values:

0= Public
2 = Private

   

service
Date

SERVICE_ DATE (DATE)

Service
Date

x

   

date

The date when the service to which the line item refers was rendered.
Time-zone- independent .

   

task
Category
-->

TASK_
CATEGORY_ ID (NUMBER)

Category (when Task is selected in the Task/ Expense field)

x

x

YRecently
Viewed
Record

object

8 The task category of the line item, if the line item is a task.

--> Links to the definition information of the category.

x

x

taxable

Before TeamConnect 3.3
SP2: isTaxable

IS_
TAXABLE (NUMBER)

 

x

     

Currently not used.

   

timekeeper

Before TeamConnect 3.3
SP2: vendorRep
-->

VENDOR_ ID (NUMBER)

Time
keeper

x

x

TContact

object

8 The contact who performed the service or provided the goods.

--> Links to the specific information about the contact object.

x

x

total
Adjustment

TOTAL_ ADJUSTM ENT

Total
Adjustment

x

   

decimal

The total amount of all adjustments made to the line item.

x

 

type

Before TeamConnect 3.3
SP2: typeIID

TYPE_IID (NUMBER)

Task/ Expense

x

   

int

The type of the line item.

E- Expense
T - Task

x

x

user
AccessList-->

     

x

ELitmUser Access

list

8 The non- default user access rights that have been granted against this line item.

--> Links to the collection of non-default user access 
rights that have been granted against this line item.

   

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the invoice record was updated.

   

warnings

LINEITEM _
WARNINGS (NUMBER)

 

x

   

string (2000)

Collected text of warning messages related to this line item.

   
  • Was this article helpful?