USER_COMPANY_ID 
ColumnName  USER_COMPANY_ID 
Definition 
Name: Domain. Description: Alias for database schema that will be updated.
 

S_IMPORT_CD 
ColumnName  S_IMPORT_CD 
Definition 
Name: Import Type. Description: Indicates the type of transaction. The valid values are: A - Add C - Change D - Delete B - Batch 
 

TIME_STAMP 
ColumnName  TIME_STAMP 
Definition 
Name: Time Stamp. Description: A time/date stamp that indicates when the record was originally inserted into table.
 

EXTERNAL_USER 
ColumnName  EXTERNAL_USER 
Definition 
Name: External User. Description: User ID of the non-TC user initiating the insert into the Import table. 
 

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

REFERENCE_CD 
ColumnName  REFERENCE_CD 
Definition 
Name: Reference Code. Description: The reference number for the advance or payment. Usually it is the number of the check for the advance or payment.
 

S_METHOD_TYPE_CD 
ColumnName  S_METHOD_TYPE_CD 
Definition 
Name: Payment Method. Description: The type of advance or method of payment. The valid values for an advance type are: CHECK – Check. EFT – Electronic Funds Transfer. OTHER – Other. The valid values for a payment method are:. AP – A/P Check/EFT. PR – Payroll Check/EFT. CR – Cash Receipt
 

PAY_CURRENCY_CD 
ColumnName  PAY_CURRENCY_CD 
Definition 
Name: Pay Currency. Description: The currency code the advance was paid in.
 

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

PAY_AMT 
ColumnName  PAY_AMT 
Definition 
Name: Pay Currency Amount. Description: The amount of the advance or payment in the employee’s pay currency.
 

BASE_AMT 
ColumnName  BASE_AMT 
Definition 
Name: Base Currency Amount. Description: The amount of the advance or payment in the system’s base currency.
 

S_IMPORT_TYPE_CD 
ColumnName  S_IMPORT_TYPE_CD 
Definition 
Name: Transaction Type. Description: Indicates the type of record being imported. The valid values are: A – Advance. P - Payment
 

PAYMENT_DT 
ColumnName  PAYMENT_DT 
Definition 
Name: Payment Date. Description: Date of the advance or payment.
 

EXP_RPT_ID 
ColumnName  EXP_RPT_ID 
Definition 
Name: Expense Report ID. Description: The unique identifier of either the expense report or the expense authorization for an advance.
 

ADVANCE_ID 
ColumnName  ADVANCE_ID 
Definition 
Name: Advance ID  Description: The unique identifier for the advance.
 

DISPLAY_ADVANCE_ID 
ColumnName  DISPLAY_ADVANCE_ID 
Definition 
Name: Advance ID  Description: The advance ID that user will see.