OBP24_FLX_TD_STMT_REQ_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 STATEMENT_CODE CHARACTER VARYING(50) 50
2 ACCOUNT_CODE CHARACTER VARYING(50) 50
3 PARTY_CODE CHARACTER VARYING(50) 50
4 DEPOSIT_NUMBER DOUBLE PRECISION 8
5 PARENT_REQ_ID CHARACTER VARYING(50) 50
6 ACTION_DUE_DATE TIMESTAMP 8
7 ACTION_PICKUP_DATE TIMESTAMP 8
8 BEGIN_DATE TIMESTAMP 8
9 END_DATE TIMESTAMP 8
10 PRICING_TICKET_NO CHARACTER VARYING(50) 50
11 STATEMENT_REQUEST_TYPE CHARACTER VARYING(40) 40
12 STATEMENT_REQUEST_STATUS CHARACTER VARYING(40) 40
13 STATEMENT_NO CHARACTER VARYING(40) 40
14 CHANNEL_ID CHARACTER VARYING(50) 50
15 ADDR_LINE1 CHARACTER VARYING(50) 50
16 ADDR_LINE2 CHARACTER VARYING(50) 50
17 ADDR_LINE3 CHARACTER VARYING(50) 50
18 ADDR_LINE4 CHARACTER VARYING(50) 50
19 ADDR_LINE5 CHARACTER VARYING(50) 50
20 ADDR_LINE6 CHARACTER VARYING(50) 50
21 ADDR_LINE7 CHARACTER VARYING(50) 50
22 ADDR_LINE8 CHARACTER VARYING(50) 50
23 ADDR_LINE9 CHARACTER VARYING(50) 50
24 ADDR_LINE10 CHARACTER VARYING(50) 50
25 ADDR_LINE11 CHARACTER VARYING(50) 50
26 ADDR_LINE12 CHARACTER VARYING(50) 50
27 CITY CHARACTER VARYING(50) 50
28 STATE CHARACTER VARYING(50) 50
29 COUNTRY CHARACTER VARYING(50) 50
30 ZIP CHARACTER VARYING(50) 50
31 REORDER_FLAG CHARACTER(1) 1
32 REORDERED_STMT_CODE CHARACTER VARYING(50) 50
33 STATEMENT_DELIVERY_MODE CHARACTER VARYING(50) 50
34 POSTAL_ADDRESS_TYPE CHARACTER VARYING(50) 50
35 FAX_NUMBER CHARACTER VARYING(20) 20
36 EMAIL_ID CHARACTER VARYING(100) 100
37 STATEMENT_GEN_STATUS CHARACTER VARYING(50) 50
38 REMARKS CHARACTER VARYING(300) 300
39 NO_OF_CREDIT_TXN DOUBLE PRECISION 8
40 CREDIT_AMT DOUBLE PRECISION 8
41 ACY_CODE CHARACTER VARYING(3) 3
42 NO_OF_DEBIT_TXN DOUBLE PRECISION 8
43 DEBIT_AMT DOUBLE PRECISION 8
44 STMT_OPN_BAL DOUBLE PRECISION 8
45 STMT_CLS_BAL DOUBLE PRECISION 8
46 STMT_DELIVERY_STATUS CHARACTER VARYING(50) 50
47 DELIVERY_REMARKS CHARACTER VARYING(500) 500
48 DELIVERY_DATE TIMESTAMP 8
49 ENTITY_STATUS CHARACTER VARYING(1) 1
50 CREATED_BY CHARACTER VARYING(254) 254
51 LAST_UPDATED_BY CHARACTER VARYING(254) 254
52 CREATION_DATE TIMESTAMP 8
53 LAST_UPDATE_DATE TIMESTAMP 8
54 OBJECT_VERSION_NUMBER DOUBLE PRECISION 8
55 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
56 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
57 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
58 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8