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