1.70 Amount Block Export to External Systems Close Upload Format
This topic provides detailed information on the Amount Block Export to External Systems Close Upload Format for segment identification numbers.
Table 1-207 Amount Block Export to External Systems Close Upload Format
Field Name | Description | Data Type | Length | Table Name |
---|---|---|---|---|
KEYSTRING | Keystring | VARCHAR2 | 200 | BULK_AMT_BLOCK |
AMTBLKNO | Amount block number | VARCHAR2 | 140 | BULK_AMT_BLOCK |
ACC | Account | VARCHAR2 | 80 | BULK_AMT_BLOCK |
AMT | Amount | NUMBER | 22 | BULK_AMT_BLOCK |
EFFDATE | Effective Date | DATE | 7 | BULK_AMT_BLOCK |
EXPDATE | Expiry Date | DATE | 7 | BULK_AMT_BLOCK |
REM | Remittance | VARCHAR2 | 1020 | BULK_AMT_BLOCK |
ABLKTYPE | Amount block type | VARCHAR2 | 4 | BULK_AMT_BLOCK |
BRANCH | Branch | VARCHAR2 | 12 | BULK_AMT_BLOCK |
SEQNO | Sequence Number | VARCHAR2 | 64 | BULK_AMT_BLOCK |
REFERENCE_NO | Reference number | VARCHAR2 | 160 | BULK_AMT_BLOCK |
VERIFY_AVL_BAL | Verify available balance | VARCHAR2 | 4 | BULK_AMT_BLOCK |
ACTION | Action | VARCHAR2 | 4 | BULK_AMT_BLOCK |
RELATEDREFNO | Related reference number | VARCHAR2 | 160 | BULK_AMT_BLOCK |
EVENSEQNO | Event sequence number | VARCHAR2 | 160 | BULK_AMT_BLOCK |
BENEMAILID | Beneficiary mail ID | VARCHAR2 | 160 | BULK_AMT_BLOCK |
BENFACEBOOKID | Beneficiary booking ID | VARCHAR2 | 160 | BULK_AMT_BLOCK |
BENTELPHONENO | Beneficiary phone number | VARCHAR2 | 160 | BULK_AMT_BLOCK |
FUNDAVLCHECK | Fund available check | VARCHAR2 | 160 | BULK_AMT_BLOCK |
Parent topic: Appendix A - Upload File Formats A