Show/Hide Toolbars

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

LTaskActivityItem

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

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

currencyItem-->

CURRENCY_ITEM_ID

(NUMBER)

 

 

 

 

 

Currently not used.

 

 

defaultCategory

DEFAULT_CATEGORY_ID

Default Category

(Categories block)

x

x

YRecentlyViewedRecord

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

YRecentlyViewedRecord

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

ELitmGroupAccess

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

YUser

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

TInvoice

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

TProject

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

YRecentlyViewedRecord

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

TContact

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

ELitmUserAccess

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.