Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
EXP_RPT_TYPE_CD |
|
VARCHAR(10) |
NO |
Name: Expense Report Type. Description: The unique identifier for the expense report type |
S_TYPE_CD |
|
VARCHAR(2) |
NO |
Name: Type. Description: Indicates whether schedule is expense reports or expense authorizations. The valid values are as follows: ER – Expense Report. EA – Expense Auth |
S_SCHEDULE_CD |
|
VARCHAR(10) |
NO |
Name: Supporting Schedule. Description: The identifier for the schedule. The valid values are EASTAT – Expense Authorization Status Schedule. EACASH – Expense Authorization Cash Advance Schedule. EAREV – Expense Authorization Revision Schedule. EACHRG – Expense Authorization Charge Allocation Schedule. ERCASH – Expense Report Cash Advance Schedule. ERBILL – Expense Report Billable Schedule. ERCHRG – Expense Report Charge Allocation Schedule. ERCOPD – Expense Report Company Paid Schedule. ERLABOR – Expense Report Labor Supporting Schedule. ERNOREIM – Expense Report Non Reimbursable Schedule. EROVERCEIL – Expense Report Over Ceiling Schedule. ERPAY – Expense Report Payments Schedule. ERPERSON – Expense Report Personal Schedule. ERRECEIPT – Expense Report Receipt Schedule. ERSTAT – Expense Report Status Schedule. ERREV – Expense Report Revisions Schedule. ERVOUCH – Expense Report Voucher Distribution Schedule. ERUNALLOW – Expense Report Unallowable Schedule |
FIELD_LABEL_CD |
|
VARCHAR(7) |
NO |
Name: Message Bundle Label. Description: The message bundle label code for the record. |
ORDER_NO |
|
NUMERIC(10, 0) |
NO |
Name: Schedule Order. Description: The order in which the scheduled shall be shown. An order of 0 means that schedule shall not be displayed. |
MODIFIED_BY |
|
VARCHAR(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMERIC(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. |