1.68 Import From External System To Amount Block Upload Format

This topic provides detailed information on the import from external system to amount block upload format for segment identification numbers.

Table 1-205 Import From External System To Amount Block Upload Format

Field Name	Description	Data Type	Length	Table Name
AMTBLKNO	Amount block number	VARCHAR2	35	BULK_AMT_BLOCK
ACC	Account	VARCHAR2	20	BULK_AMT_BLOCK
AMT	Amount	NUMBER	30	BULK_AMT_BLOCK
EFFDATE	Effective Date	DATE	7	BULK_AMT_BLOCK
EXPDATE	Expiry Date	DATE	7	BULK_AMT_BLOCK
REM	Remittance	VARCHAR2	255	BULK_AMT_BLOCK
ABLKTYPE	Amount Block Type	VARCHAR2	1	BULK_AMT_BLOCK
BRANCH	Branch	VARCHAR2	3	BULK_AMT_BLOCK
HOLD_CODE	Hold Codes	VARCHAR2	15	BULK_AMT_BLOCK
REFERENCE_NO	Reference number	VARCHAR2	40	BULK_AMT_BLOCK
VERIFY_AVL_BAL	Verify available balance	VARCHAR2	1	BULK_AMT_BLOCK
KEYSTRING	Key String	VARCHAR2	50	BULK_AMT_BLOCK
ACTION	Actions	VARCHAR2	1	BULK_AMT_BLOCK
RELATEDREFNO	Related reference number	VARCHAR2	40	BULK_AMT_BLOCK
EVENSEQNO	even sequence number	VARCHAR2	40	BULK_AMT_BLOCK
BENEMAILID	Beneficiary mail ID	VARCHAR2	40	BULK_AMT_BLOCK
BENFACEBOOKID	Beneficiary booking ID	VARCHAR2	40	BULK_AMT_BLOCK
BENTELPHONENO	Beneficiary telephone number	VARCHAR2	40	BULK_AMT_BLOCK
FUNDAVLCHECK	Fund available balance	VARCHAR2	40	BULK_AMT_BLOCK
SEQNO	Sequence number	VARCHAR2	16	BULK_AMT_BLOCK