Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
USER_COMPANY_ID |
|
VARCHAR(30) |
NO |
Name: Domain. Description: Alias for database schema that will be updated. |
S_IMPORT_CD |
|
VARCHAR(1) |
NO |
Name: Import Type. Description: Indicates the type of transaction. The valid values are: A - Add C - Change D - Delete B - Batch |
TIME_STAMP |
|
DATE |
NO |
Name: Time Stamp. Description: A time/date stamp that indicates when the record was originally inserted into table. |
EXTERNAL_USER |
|
VARCHAR(20) |
NO |
Name: External User. Description: User ID of the non-TC user initiating the insert into the Import table. |
EMPL_ID |
|
VARCHAR(20) |
YES |
Name: Employee ID. Description: The unique identifier of the employee for the advance. |
REFERENCE_CD |
|
VARCHAR(20) |
NO |
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 |
|
VARCHAR(5) |
NO |
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 |
|
VARCHAR(3) |
YES |
Name: Pay Currency. Description: The currency code the advance was paid in. |
BASE_CURRENCY_CD |
|
VARCHAR(3) |
YES |
Name: Base Currency. Description: The base currency code of the system. |
PAY_AMT |
|
NUMERIC(15, 5) |
NO |
Name: Pay Currency Amount. Description: The amount of the advance or payment in the employee’s pay currency. |
BASE_AMT |
|
NUMERIC(15, 5) |
NO |
Name: Base Currency Amount. Description: The amount of the advance or payment in the system’s base currency. |
S_IMPORT_TYPE_CD |
|
VARCHAR(1) |
NO |
Name: Transaction Type. Description: Indicates the type of record being imported. The valid values are: A – Advance. P - Payment |
PAYMENT_DT |
|
DATE |
NO |
Name: Payment Date. Description: Date of the advance or payment. |
EXP_RPT_ID |
|
VARCHAR(10) |
YES |
Name: Expense Report ID. Description: The unique identifier of either the expense report or the expense authorization for an advance. |
ADVANCE_ID |
|
VARCHAR(40) |
YES |
Name: Advance ID Description: The unique identifier for the advance. |
DISPLAY_ADVANCE_ID |
|
VARCHAR(12) |
YES |
Name: Advance ID Description: The advance ID that user will see. |