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 |
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 |
|
adjustedDiscount Before TeamConnect 3.3 SP2: netDiscount |
ADJUSTED_DISCOUNT (NUMBER) |
Net Discount |
x |
|
|
decimal |
The net discount of the line item. |
|
|
adjustedQuantity Before TeamConnect 3.3 SP2: netQuantity |
ADJUSTED_QUANTITY (NUMBER) |
Net Quantity |
x |
|
|
decimal |
The net quantity of the line item. |
|
|
adjustedRate Before TeamConnect 3.3 SP2: netRate |
ADJUSTED_RATE (NUMBER) |
Net Rate |
x |
|
|
decimal |
The net rate of the line item. |
|
|
adjustedTotal 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: adjustmentList |
|
|
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 |
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 |
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 |
currencyItem--> |
CURRENCY_ITEM_ID (NUMBER) |
|
|
|
|
|
Currently not used. |
|
|
defaultCategory |
DEFAULT_CATEGORY_ID |
Default Category (Categories block) |
x |
x |
object |
8 The default category for the line item. --> Links to the definition information of the category. |
|
|
|
defaultCurrencyNetDiscount |
DEFAULT_CURR_DISCOUNT (NUMBER) |
|
x |
|
|
decimal |
The net discount of the line item in the system's default currency. |
|
|
defaultCurrencyNetRate |
DEFAULT_CURR_RATE (NUMBER) |
|
x |
|
|
decimal |
The net rate of the line item in the system's default currency. |
|
|
defaultCurrencyNetTotal |
DEFAULT_CURR_TOTAL (NUMBER) |
|
x |
|
|
decimal |
The net total of the line item in the system's default currency. |
|
|
expenseCategory--> |
EXPENSE_TYPE_ID (NUMBER) |
Category (when Expense is selected in the Task/Expense field) |
x |
x |
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 |
|
groupAccessList--> |
|
|
|
x |
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. |
|
|
|
hasWarnings |
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. |
|
|
itemNumber Before TeamConnect 3.3 SP2: itemNum |
ITEM_NUMBER |
|
x |
|
|
int |
The number assigned to the line item at the time it was created.Invoice 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 |
object |
8 The user who last modified the line item. --> Links to specific information about the user account. |
|
|
|
modifiedOn |
MODIFIED_ON (DATE) |
Last Modified On |
x |
|
|
date |
The date that the line item was modified. |
|
|
note Before TeamConnect 3.3 SP2: shortDescription |
ITEM_DESCRIPTION (VARCHAR2) (250) |
Description |
x |
|
|
string (2000) |
The description of the line item. |
|
x |
originalDiscount |
DISCOUNT_PERCENT (NUMBER) |
Original Discount |
x |
|
|
decimal |
The original discount of the line item. |
|
|
originalQuantity |
QUANTITY (NUMBER) |
Original Quantity |
x |
|
|
decimal |
The original quantity of the line item. |
|
|
originalRate |
UNIT_PRICE (NUMBER) |
Original Rate |
x |
|
|
decimal |
The original rate of the line item. |
|
|
originalTotal |
GROSS_AMOUNT (NUMBER) |
Original Total |
x |
|
|
decimal |
The original total of the line item. |
|
|
owner--> |
INVOICE_ID (NUMBER) |
|
|
x |
object |
8 The invoice to which the line item belongs. --> Links to the specific information about the invoice object. |
|
|
|
primaryKey |
PRIMARY_KEY (NUMBER) |
|
x |
|
|
int |
The unique ID of the line item. |
|
|
project--> |
PROJECT_ID (NUMBER) |
Project |
x |
x |
object |
8 The project associated with the line item. --> Links to the specific information about the project object. |
x |
x |
|
securityTypeIID |
SECURITY_TYPE_ID (NUMBER) |
|
x |
|
|
int |
Security type. One of these values: 0= Public 2 = Private |
|
|
serviceDate |
SERVICE_DATE (DATE) |
Service Date |
x |
|
|
date |
The date when the service to which the line item refers was rendered. Time-zone-independent. |
|
|
taskCategory--> |
TASK_CATEGORY_ID (NUMBER) |
Category (when Task is selected in the Task/Expense field) |
x |
x |
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) |
Timekeeper |
x |
x |
object |
8 The contact who performed the service or provided the goods. --> Links to the specific information about the contact object. |
x |
x |
|
totalAdjustment |
TOTAL_ ADJUSTMENT |
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 |
userAccessList--> |
|
|
|
x |
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. |
|
|