| Data element |
Definition |
EXP_CAT_CODE
Indexed - yes
Format - varchar2(10)
May be null? yes |
Expense category code. |
EXP_CODE
Indexed - yes
Format - varchar2(10)
May be null? yes |
Unique code identifying a collection of similarly grouped expense types. |
EXP_KEY
Indexed - yes
Format - char(5)
May be null? no |
Unique system-assigned key that identifies the expense type. |
EXP_TYPE_LAST_MODIFIED
Indexed - no
Format - date
May be null? yes |
Date on which the expense type record was last modified. |
EXP_TYPE_NAME
Indexed - no
Format - varchar2(64)
May be null? yes |
Name of the expense type. |
EXP_TYPE_NAME_LAST_MODIFIED
Indexed - no
Format - date
May be null? yes |
Date on which the expense type name record was last modified. |
IS_DELETED
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the expense type record has been deleted from Concur. |
PARENT_EXP_KEY
Indexed - yes
Format - char(5)
May be null? yes |
Another expense type under which the entry's expense type has been grouped. For example, the expense types Breakfast, Lunch, and Dinner might be grouped under another expense type called Meals. |
SYSTEM_RECORD
Indexed - no
Format - char(1)
May be null? yes |
|
