Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
EXP_RPT_ID |
|
VARCHAR(10) |
NO |
Name: Expense Report ID. Description: The unique identifier of the expense report for which the payment was reimbursing. |
PAYMENT_REFERENCE_CD |
|
VARCHAR(20) |
NO |
Name: Payment Reference Code. Description: The reference number for the payment. Usually it is the number of the check for the payment. |
PAYMENT_DT |
|
DATE |
NO |
Name: Payment Date. Description: The date the payment occurred. |
PAY_PAYMENT_AMT |
|
NUMERIC(15, 5) |
NO |
Name: Pay Currency Payment Amount. Description: The amount of the payment in employee’s pay currency. |
BASE_PAYMENT_AMT |
|
NUMERIC(15, 5) |
NO |
Name: Base Currency Payment Amount. Description: The amount of the payment in system’s base currency. |
S_PAYMENT_METHOD_CD |
|
VARCHAR(5) |
NO |
Name: Payment Method. Description: The method of payment. The valid values are: AP – A/P Check/EFT PR – Payroll Check/EFT CR – Cash Receipt |
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. |