3.9 Instrument Collection

This topics describes the information to perform the bulk upload for the Instrument Collection in Oracle Banking Cash Management.

Table 3-11 Instrument Collection File Upload

S.No Attribute Name Type Character Mandatory/Optional Description
1 INDICATOR VARCHAR2 50 Y This field will indicate the data is of what type i.e. D and I.
2 BRANCH_CODE VARCHAR2 3 Y The branch from where or on behalf of which branch this data is being uploaded.
3 DEPOSIT_CHANNEL VARCHAR2 50 Y The channel from where the instruments are received i.e. Branch or Courier.
4 COURIER_CODE VARCHAR2 15 CM This field indicates the Courier Code; code will be from the courier code master. If the deposit selection channel is Courier ; then this field is mandatory.
5 CONSIGNMENT_NO VARCHAR2 30 N The consignment number as assigned by the Courier. If the deposit selection channel is Courier ; then this field can be filled up.
6 CONSIGNMENT_DATE DATE - N It cannot be greater than the Current date (Branch date).
7 CONSIGNMENT_RECEIPT_TIME TIME - N Input In format of 24 hrs.

HR MM SS
8 FINANCIAL_POSTING VARCHAR2 1 Y The field determines if GL entries need to be posted or not.

If user has left it blank then default to “N”.
9 PROCESSING_DATE DATE - N The date on which the Deposit slips are entered Based on the “Financial Posting” field; if it is selected as “N”; then user will have to input the date else will be defaulted to current business date of the branch.
10 ACK_RECEIPT_NO VARCHAR2 50 N This field will capture acknowledgment if any , for the Batch.
11 BAG_WEIGHT NUMBER (11,4) N The weight of the bag / package when received.
12 INITIATOR_REF_NO VARCHAR2 50 N In case if there is a reference number available when the package is received; it can be captured here.
13 TOTAL_BATCH_AMT_CCY VARCHAR2 3 Y The currency in which the instruments are collected i.e. USD, INR , SGD.
14 DEPOSIT_SLIP_NO VARCHAR2 10 Y This field will be an input field where the user can enter the deposit slip number.
15 CORPORATE_ID VARCHAR2 20 Y This field indicates the Corporate ID for whom the instrument collection entry is being made.

Non customer id should not be allowed.
16 DIVISION_CODE VARCHAR2 20 CM Division code against which the funds for the deposit slip need to be allocated.

Division code input here should be maintained for this corporate.

This field is mandatory if in Corporate Enrichment “Division Code Mandatory “is marked as Y.
17 CREDIT_ACCOUNT_NO VARCHAR2 35 N This field indicate the account number to which the funds needs to be credited. This field is non mandatory for the user for file upload as he can leave it blank.
18 ACCOUNT_TYPE VARCHAR2 30 Y The user can define whether the credit account selected is of type Real or Virtual i.e. R or V.

Default will be R.
19 DEPOSIT_SLIP_DATE DATE - Y The date, which is printed / available on deposit, slip summary. Can be backdated ; can be current branch date but cannot be future dated.
20 PICKUP_LOCATION_CODE VARCHAR2 105 Y This is the location from where the deposit slip has been collected.

If Deposit channel is Courier then this field is mandatory.

Location has to be part of the Location master maintained for the corporate.
21 PICKUP_POINT_CODE VARCHAR2 15 Y The exact pick up point of the Deposit.
22 PICKUP_DATE DATE - N The date and TS when the cheque’s / Instrument was collected. If blank can be defaulted to current business date of the branch.
23 UDF1 VARCHAR2 50 N The user will input enrichment labels, can be multiple (as defined in Corporate Enrichment).
24 UDF2 VARCHAR2 50 N The user will input enrichment labels, can be multiple (as defined in Corporate Enrichment).
25 UDF3 VARCHAR2 50 N The user will input enrichment labels, can be multiple (as defined in Corporate Enrichment).
26 UDF4 VARCHAR2 50 N The user will input enrichment labels, can be multiple (as defined in Corporate Enrichment).
27 UDF5 VARCHAR2 50 N The user will input enrichment labels, can be multiple (as defined in Corporate Enrichment).
28 UDF6 VARCHAR2 50 N The user will input enrichment labels, can be multiple (as defined in Corporate Enrichment).
29 UDF7 VARCHAR2 50 N The user will input enrichment labels, can be multiple (as defined in Corporate Enrichment).
30 UDF8 VARCHAR2 50 N The user will input enrichment labels, can be multiple (as defined in Corporate Enrichment).
31 UDF9 VARCHAR2 50 N The user will input enrichment labels, can be multiple (as defined in Corporate Enrichment).
32 UDF10 VARCHAR2 50 N The user will input enrichment labels, can be multiple (as defined in Corporate Enrichment).
33 MISC1 VARCHAR2 50 N Any miscellaneous information that user wants to capture for the deposit slip for e.g. Mobile number.
34 MISC2 VARCHAR2 50 N Any miscellaneous information that user wants to capture for the deposit slip for e.g. Mobile number.
35 MISC3 VARCHAR2 50 N Any miscellaneous information that user wants to capture for the deposit slip for e.g. Mobile number.
36 MISC4 VARCHAR2 50 N Any miscellaneous information that user wants to capture for the deposit slip for e.g. Mobile number.
37 MISC5 VARCHAR2 50 N Any miscellaneous information that user wants to capture for the deposit slip for e.g. Mobile number.
38 MISC6 VARCHAR2 50 N Any miscellaneous information that user wants to capture for the deposit slip for e.g. Mobile number.
39 MISC7 VARCHAR2 50 N Any miscellaneous information that user wants to capture for the deposit slip for e.g. Mobile number.
40 MISC8 VARCHAR2 50 N Any miscellaneous information that user wants to capture for the deposit slip for e.g. Mobile number.
41 MISC9 VARCHAR2 50 N Any miscellaneous information that user wants to capture for the deposit slip for e.g. Mobile number.
42 MISC10 VARCHAR2 50 N Any miscellaneous information that user wants to capture for the deposit slip for e.g. Mobile number.

Parent topic: File Upload