OIC_TRANSACTION_DETAILS
Description
Synonyms
SDSNZP02_BANK..BNKFRC_OIC_TRANSACTION_DETAILS
SDSNZP02_BANK..UBAR_OIC_TRANSACTION_DETAILS
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | CREDITRECEIVER | CHARACTER VARYING(500) | 500 |
| 2 | DIRECTRECEIVER | CHARACTER VARYING(500) | 500 |
| 3 | CREATIONDATE | CHARACTER VARYING(15) | 15 |
| 4 | PROCESSEDDATE | CHARACTER VARYING(15) | 15 |
| 5 | TRANSACTIONTYPE | CHARACTER VARYING(250) | 250 |
| 6 | ADJUSTMENTSTATUS | CHARACTER VARYING(100) | 100 |
| 7 | TRANSACTIONSTATUS | CHARACTER VARYING(100) | 100 |
| 8 | ORIGINALCURRENCYCODE | CHARACTER VARYING(4) | 4 |
| 9 | TRANSACTIONAMOUNT | NUMERIC(10,2) | 19 |
| 10 | COMMISSION | NUMERIC(10,3) | 19 |
| 11 | COMMISSIONRATE | NUMERIC(10,4) | 19 |
| 12 | BUSINESSGROUP | CHARACTER VARYING(5) | 5 |
| 13 | EVENTTYPE | CHARACTER VARYING(10) | 10 |
| 14 | LINEOFBUSINESS | CHARACTER VARYING(30) | 30 |
| 15 | LOANTYPE | CHARACTER VARYING(50) | 50 |
| 16 | PRODUCTCATEGORY | CHARACTER VARYING(50) | 50 |
| 17 | PRODUCTCODE | CHARACTER VARYING(30) | 30 |
| 18 | PRODUCTNAME | CHARACTER VARYING(100) | 100 |
| 19 | KEYINDICATOR | CHARACTER VARYING(10) | 10 |
| 20 | ACCREDITEDBROKERCODE | CHARACTER VARYING(10) | 10 |
| 21 | ACCREDITEDBROKERNAME | CHARACTER VARYING(100) | 100 |
| 22 | CUSTOMERNAME | CHARACTER VARYING(100) | 100 |
| 23 | ELECTRONICLODGEID | CHARACTER VARYING(100) | 100 |
| 24 | ARRANGEMENTNUMBER | CHARACTER VARYING(50) | 50 |
| 25 | FACILITYNUMBER | CHARACTER VARYING(15) | 15 |
| 26 | ACCOUNTNUMBER | CHARACTER VARYING(20) | 20 |
| 27 | ACCOUNTSTATUS | CHARACTER VARYING(30) | 30 |
| 28 | LOANPURPOSE | CHARACTER VARYING(100) | 100 |
| 29 | SETTLEMENTSTATE | CHARACTER VARYING(30) | 30 |
| 30 | SPLITLOANREF | CHARACTER VARYING(10) | 10 |
| 31 | QUANTITY | INTEGER | 4 |
| 32 | ACCOUNTOPENINGBALANCE | NUMERIC(15,2) | 19 |
| 33 | ACCOUNTCLOSINGBALANCE | NUMERIC(15,2) | 19 |
| 34 | RECEIVEDDATE | CHARACTER VARYING(15) | 15 |
| 35 | SETTLEMENTDATE | CHARACTER VARYING(15) | 15 |
| 36 | CONVERSIONMETRIC | CHARACTER VARYING(100) | 100 |
| 37 | QUALITYMETRIC | CHARACTER VARYING(100) | 100 |
| 38 | ELECTRONICLODGEMETRIC | CHARACTER VARYING(100) | 100 |
| 39 | DAYSINARREARS | INTEGER | 4 |
| 40 | GSTAPPLICABLE | CHARACTER VARYING(3) | 3 |
| 41 | COMMISSIONELIGIBILITY | CHARACTER VARYING(3) | 3 |
| 42 | NONELIGIBILITYREASON | CHARACTER VARYING(500) | 500 |
| 43 | QUALITYNOTMETREASON | CHARACTER VARYING(250) | 250 |
| 44 | MANUALCOMMISSIONCALC | CHARACTER VARYING(3) | 3 |
| 45 | ENQUIRYNUMBER | INTEGER | 4 |
| 46 | SOURCESYSTEMID | CHARACTER VARYING(30) | 30 |
| 47 | BUSDEVMANAGER | CHARACTER VARYING(100) | 100 |
| 48 | BDMREGION | CHARACTER VARYING(50) | 50 |
| 49 | REVENUECLASS | CHARACTER VARYING(100) | 100 |
| 50 | PLANELEMENT | CHARACTER VARYING(100) | 100 |
| 51 | ROLE | CHARACTER VARYING(100) | 100 |
| 52 | COMPENSATIONPLAN | CHARACTER VARYING(100) | 100 |
| 53 | CREATEDBY | CHARACTER VARYING(30) | 30 |
| 54 | ADJUSTMENTDATE | CHARACTER VARYING(15) | 15 |
| 55 | ADJUSTEDBY | CHARACTER VARYING(30) | 30 |
| 56 | PAYBATCHNAME | CHARACTER VARYING(50) | 50 |
| 57 | PAYBATCHSTATUS | CHARACTER VARYING(10) | 10 |
| 58 | SUPPLIERNBR | INTEGER | 4 |
| 59 | DATA_DATE | TIMESTAMP | 8 |
| 60 | LOAD_ID | INTEGER | 4 |
| 61 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 62 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 63 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 64 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |