ColumnName |
Domain |
Datatype |
NULL |
Definition |
EXP_RPT_ID |
|
VARCHAR2(10) |
NO |
Name: Expense Report ID. Description: Unique identifier for expense report. |
EXPENSE_ID |
|
NUMBER(10, 0) |
NO |
Name: Expense ID. Description: The unique identifier for the expense. |
ATTENDEE_SEQ_NO |
|
NUMBER(10, 0) |
NO |
Name: Sequence Number. Description: Synthetic. |
EMPL_ID |
|
VARCHAR2(20) |
YES |
Name: Employee ID. Description: The employee ID of the attendee. |
ATTENDEE_NAME |
|
VARCHAR2(65) |
YES |
Name: Attendee Name. Description: Name of the Attendee. |
COMPANY_NAME |
|
VARCHAR2(30) |
YES |
Name: Company Name. Description: Company of the Attendee. |
TITLE_DESC |
|
VARCHAR2(30) |
YES |
Name: Attendee Title. Description: Title of the Attendee. |
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMBER(10, 0) |
NO |
Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
|
DATE |
NO |
Name: Time Stamp. Description: Date and time the record was last modified. |
ATTENDEE_NOTES_DESC |
|
VARCHAR2(60) |
YES |
Name: Attendee Comment. Description: Notes describing reason Attendee is included in the expense. |
LOCATION_DESC |
|
VARCHAR2(30) |
YES |
Name: Location Description. Description: The location of the employee |
COMPANY_USER_INPUT_FL |
|
VARCHAR2(1) |
NO |
Name: Company User Input Flag. Description: Logical as to whether the employee’s company was defaulted in from Employee Default screen. |
TITLE_USER_INPUT_FL |
|
VARCHAR2(1) |
NO |
Name: Title User Input Flag. Description: Logical as to whether the employee’s title was defaulted in from Employee Default screen. |
LOCATION_USER_INPUT_FL |
|
VARCHAR2(1) |
NO |
Name: Location User Input Flag. Description: Logical as to whether the employee’s location was defaulted in from Employee Default screen. |