Alias: IVPDS#
(INF_CV_DISBURSEMENTS)Checks
Table Columns#
Column name | Data Type / Size | Domain | Mand. | Notes |
---|---|---|---|---|
ID | Number(10) | ID | ||
ENTITY_CODE | Varchar2(16) | CODE | Y | |
PERSON_CODE | Varchar2(16) | CODE | Y | |
EMPLOYMENT_TYPE | Varchar2(30) | VARCHAR30 | ||
HIRE_DATE | Date() | DATE | ||
PAY_NUMBER | Number(5) | NUMBER5 | Y | |
PAY_ISSUE_DATE | Date() | DATE | Y | |
DISBURSEMENT_AMOUNT | Number(14) | AMT12V2 | Y | |
PAY_DESTINATION | Varchar2(30) | VARCHAR30 | ||
COUNTRY_CODE | Varchar2(16) | CODE | ||
BANK_TRANSIT_CODE | Varchar2(16) | CODE | ||
BANK_ACCOUNT | Varchar2(30) | VARCHAR30 | ||
STARTING_NUMBER | Number(10) | NUMBER10 | ||
CHECK_NUMBER | Number(10) | NUMBER10 | ||
CHECK_AMOUNT | Number(14) | AMT12V2 | ||
CHECK_STATUS | Varchar2(30) | VARCHAR30 | ||
CHECK_TYPE | Varchar2(30) | VARCHAR30 | ||
PAID_TO_ORDER_OF | Varchar2(50) | VARCHAR50 | ||
CLEAR_AMOUNT | Number(14) | AMT12V2 | ||
CLEAR_DATE | Date() | DATE | ||
CHECK_PRINTED | Varchar2(4) | VARCHAR4 | ||
PREVIOUS_OUTSTANDING | Varchar2(4) | VARCHAR4 | ||
RECONCILE_DATE | Date() | DATE | ||
OVERRIDE_CHECK_DATE | Date() | DATE | ||
CREATE_DATE | Date() | DATE | ||
CREATE_USER | Varchar2(30) | VARCHAR30 | ||
CHANGE_DATE | Date() | DATE | ||
CHANGE_USER | Varchar2(30) | VARCHAR30 |