EMPL_ID 
ColumnName  EMPL_ID 
Definition 
Name: Employee ID. Description: The unique identifier of the employee.
 

ADVANCE_REFERENCE_CD 
ColumnName  ADVANCE_REFERENCE_CD 
Definition 
Name: Advance Reference Code. Description: The reference number for the advance. Usually it is the number of the check for the advance. 
 

ADVANCE_DT 
ColumnName  ADVANCE_DT 
Definition 
Name: Advance Date. Description: Date of Advance
 

S_ADVANCE_TYPE_CD 
ColumnName  S_ADVANCE_TYPE_CD 
Definition 
Name: Advance Type. Description: The method of advance. The valid values are: CHECK – Check. EFT – Electronic Funds Transfer. OTHER – Other
 

DUE_DTT 
ColumnName  DUE_DTT 
Definition 
Name: Advance Due Date. Description: The date/time the advance should be claimed by.
 

PAY_CURRENCY_CD 
ColumnName  PAY_CURRENCY_CD 
Definition 
Name: Pay Currency. Description: The currency code of that the employee will be reimbursed in.
 

BASE_CURRENCY_CD 
ColumnName  BASE_CURRENCY_CD 
Definition 
Name: Base Currency. Description: The base currency code of the system. 
 

PAY_ADVANCE_AMT 
ColumnName  PAY_ADVANCE_AMT 
Definition 
Name: Pay Currency Advance Amount . Description: The advance amount. This amount is in the employee’s pay currency.
 

BASE_ADVANCE_AMT 
ColumnName  BASE_ADVANCE_AMT 
Definition 
Name: Base Currency Advance Amount. Description: The advance amount. This amount is in the system’s base currency.
 

EXP_RPT_ID 
ColumnName  EXP_RPT_ID 
Definition 
Name: Expense Report ID. Description: The unique identifier for the expense report.
 

MODIFIED_BY 
ColumnName  MODIFIED_BY 
Definition 
Name: Modified By. Description: The User ID of the person who last modified this record.
 

ROWVERSION 
ColumnName  ROWVERSION 
Definition 
Name: Row Version. Description: The number of times this record has been updated.
 

TIME_STAMP 
ColumnName  TIME_STAMP 
Definition 
Name: Time Stamp. Description: Date and time the record was last modified.
 

EXP_AUTH_ID 
ColumnName  EXP_AUTH_ID 
Definition 
Name: Expense Authorization ID. Description: The unique identifier for the expense authorization.