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. |