EInvcDetail contains all categories added to invoice records. Each time a category is added to an invoice record, an entry is made in this table in the database.
In Object Navigator, EInvcDetail is not displayed when you traverse using the detailList--> bridge. Instead, a list of all categories that have been defined for the object definition appears. This list is labeled Category. From each category, you can traverse to a table called Detail Fields, which displays all custom fields belonging to the category you selected.
For more information about how custom field values are stored in the database, see Object Model: Custom Fields.
Object: EInvcDetail (E_INVC_DETAIL)
Attribute |
Database column name |
Field in UI |
End of path |
Bridge |
Links to object table: |
Data type |
Comments |
Commonly used in: |
|
Rules |
Temp/Wiz |
||||||||
category--> |
CATEGORY_ID (NUMBER) |
Category |
x |
x |
object |
The category of the invoice with which the details are associated. |
|
|
|
owner--> |
ENTERPRISE_OBJECT_ID (NUMBER) |
|
|
x |
object |
The invoice with which the custom fields are associated. |
|
|
|
isManual |
IS_MANUAL (NUMBER) |
|
x |
|
|
boolean |
Specifies whether the category is added manually or automatically to the invoice. 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 |
The unique ID of the invoice category record. |
|
|
version |
VERSION (NUMBER) |
|
x |
|
|
int |
Indicates how many times the added category was updated. |
|
|
