Previous Next JavaScript must be enabled to correctly display this content

## 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