Show/Hide Toolbars

ELitmDetail organizes the detail values for an invoice line item (JInvcLineItem object). Detail values originate from custom fields associated with the category assigned to the line item.

There can be multiple ELitmDetail objects for each JInvcLineItem. There is one ELitmDetail for each category used in JInvcLineItem, including any parent categories, plus the Root category. For example, if the category assigned to the JInvcLineItem object were Root : Expense : Parking, there would be three associated ELitmDetail objects: one for Root, one for Expense, and one for Parking.

Note that in ELitmDetail there are attributes for multiple lists of detail values. However, in any given ELitmDetail object, it is possible that only some of those attributes will really have values. Since an ELitmDetail object has a specific category, only the custom fields that match the category will be used. Thus there will only be values for the field types that those custom fields represent.

Object: ELitmDetail (E_LITM_DETAIL)

Attribute

Database column name

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

isManual

IS_MANUAL

(NUMBER)

x

 

 

boolean

Specifies whether the category is added manually or automatically to the line item. Categories are added automatically when they are the parent of the category that is added manually.

0 - Added Automatically

1 - Added Manually

 

 

primaryKey

PRIMARY_KEY

(NUMBER)

x

 

 

int

Unique ID automatically assigned to this custom field value.

 

 

version

VERSION

(NUMBER)

x

 

 

int

Indicates how many times the line item detail was updated.

 

 

category-->

CATEGORY_ID

(NUMBER)

 

x

YRecentlyViewedRecord

object

8 The category to which this detail belongs.

Links to a category to which the line item belongs. Note that most line items belong to multiple categories - a specific category, plus any parent category, grandparent category, etc.

 

 

owner-->

ENTERPRISE_OBJECT_ID

(NUMBER)

x

x

JInvcLineItem

object

8 The invoice line item record to which this detail belongs.

--> Links to information about the invoice record to which the line item belongs.