TInvoice

Last updated
Save as PDF

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.
currentPhaseType -->	CURRENT_PHASE_TYPE_ID					number
currentVersion -->	CURRENT_VERSION_ID					number
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.
docuSourceLocation -->	DOCU_SOURCE_LOCATION_ID					number
forum -->	FORUM_ID					number
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.
isNonUsTaxSummaryLevel	IS_NON_US_TAX_SUMMARY_LEVEL					boolean
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 NVARCHAR2(50 CHAR)	Number (General block)	x			string (50)	Any alphanumeric text that describes the invoice record.
approvalStatus -->	APPROVAL_STATUS_ID (NUMBER)					number
batchInvoice -->	BATCHINVOICE_ID (NUMBER)					number
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 Posted 2 = Posted 3 = Failed 4 = 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) 4- Appeal Invoice	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.
adjustmentType -->	ADJUSTMENT_TYPE_ID					number
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.
adjustmentTypte -->	ADJUSTMENT_TYPE_ID					number
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
appealedInvoiceID	APPEALED_INVOICE_ID					number
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.
adjustmentSource	ADJUSTMENT_SOURCE_IID					number
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.
documentFolderID	DOCUMENT_FOLDER_ID					number
docuSourceLocationID	DOCU_SOURCE_LOCATION_ID					number
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.
isAppealed	IS_APPEALED					number
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.
escalateFlag	ESCALATE_FLAG					number
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.
hasAdjustments	HAS_ADJUSTMENTS					number
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_IID (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 .
internalComments -->	INTERNAL_COMMENTS NVARCHAR2(2000 CHAR)					string (2000)
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.