EXP_RPT_ID |
ColumnName | EXP_RPT_ID |
Definition | Name: Expense Report ID. Description: The unique identifier of the expense report for which the payment was reimbursing. |
PAYMENT_REFERENCE_CD |
ColumnName | PAYMENT_REFERENCE_CD |
Definition | Name: Payment Reference Code. Description: The reference number for the payment. Usually it is the number of the check for the payment. |
PAYMENT_DT |
ColumnName | PAYMENT_DT |
Definition | Name: Payment Date. Description: The date the payment occurred. |
PAY_PAYMENT_AMT |
ColumnName | PAY_PAYMENT_AMT |
Definition | Name: Pay Currency Payment Amount. Description: The amount of the payment in employee’s pay currency. |
BASE_PAYMENT_AMT |
ColumnName | BASE_PAYMENT_AMT |
Definition | Name: Base Currency Payment Amount. Description: The amount of the payment in system’s base currency. |
S_PAYMENT_METHOD_CD |
ColumnName | S_PAYMENT_METHOD_CD |
Definition | 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 |
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. |