Alias: IVPDS#

(INF_CV_DISBURSEMENTS)
Checks

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
PERSON_CODEVarchar2(16)CODEY
EMPLOYMENT_TYPEVarchar2(30)VARCHAR30
HIRE_DATEDate()DATE
PAY_NUMBERNumber(5)NUMBER5Y
PAY_ISSUE_DATEDate()DATEY
DISBURSEMENT_AMOUNTNumber(14)AMT12V2Y
PAY_DESTINATIONVarchar2(30)VARCHAR30
COUNTRY_CODEVarchar2(16)CODE
BANK_TRANSIT_CODEVarchar2(16)CODE
BANK_ACCOUNTVarchar2(30)VARCHAR30
STARTING_NUMBERNumber(10)NUMBER10
CHECK_NUMBERNumber(10)NUMBER10
CHECK_AMOUNTNumber(14)AMT12V2
CHECK_STATUSVarchar2(30)VARCHAR30
CHECK_TYPEVarchar2(30)VARCHAR30
PAID_TO_ORDER_OFVarchar2(50)VARCHAR50
CLEAR_AMOUNTNumber(14)AMT12V2
CLEAR_DATEDate()DATE
CHECK_PRINTEDVarchar2(4)VARCHAR4
PREVIOUS_OUTSTANDINGVarchar2(4)VARCHAR4
RECONCILE_DATEDate()DATE
OVERRIDE_CHECK_DATEDate()DATE
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30