OBP24_HST_FLX_DD_SWEEP_OUT_INST_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_CODE CHARACTER VARYING(40) 40
2 INSTRUCTION_NUM_CODE BIGINT 8
3 INSTRUCTION_NAME CHARACTER VARYING(40) 40
4 NARRATIVE_DESC CHARACTER VARYING(256) 256
5 LIMIT_PRIORITY_NUM BIGINT 8
6 MAX_INSTR_NUM BIGINT 8
7 LAST_EXECUTION_DATE TIMESTAMP 8
8 NEXT_EXECUTION_DATE TIMESTAMP 8
9 NEXT_PICKUP_DATE TIMESTAMP 8
10 LAST_PICKUP_DATE TIMESTAMP 8
11 SETTLEMENT_REF_CODE CHARACTER VARYING(40) 40
12 SWEEP_OUT_AMOUNT_BASIS CHARACTER VARYING(40) 40
13 PERCENTAGE_NUM BIGINT 8
14 FIXED_AMOUNT_AMT DOUBLE PRECISION 8
15 FIXED_AMOUNT_CCY_CODE CHARACTER VARYING(5) 5
16 TARGET_AMOUNT_AMT DOUBLE PRECISION 8
17 TARGET_AMOUNT_CCY_CODE CHARACTER VARYING(40) 40
18 FROM_AMOUNT_AMT DOUBLE PRECISION 8
19 FROM_AMOUNT_CCY_CODE CHARACTER VARYING(40) 40
20 TO_AMOUNT_AMT DOUBLE PRECISION 8
21 TO_AMOUNT_CCY_CODE CHARACTER VARYING(40) 40
22 MULTIPLES_OF_AMT DOUBLE PRECISION 8
23 MULTIPLES_OF_CCY_CODE CHARACTER VARYING(40) 40
24 MIN_TIMES_NUM BIGINT 8
25 MAX_TIMES_NUM BIGINT 8
26 RECUR_PATRN_CODE CHARACTER VARYING(50) 50
27 CREATED_BY CHARACTER VARYING(254) 254
28 LAST_UPDATED_BY CHARACTER VARYING(254) 254
29 CREATION_DATE TIMESTAMP 8
30 LAST_UPDATE_DATE TIMESTAMP 8
31 OBJECT_STATUS_FLAG CHARACTER(1) 1
32 OBJECT_VERSION_NUMBER INTEGER 4
33 EPOCH_TYPE CHARACTER VARYING(20) 20
34 LIMIT_LEVEL_NUM SMALLINT 2
35 MIN_BAL_TO_RETAIN_AMT DOUBLE PRECISION 8
36 MIN_BAL_TO_RETAIN_CCY_CODE CHARACTER VARYING(5) 5
37 MAX_AMT_TO_SW_OUT_AMT DOUBLE PRECISION 8
38 MAX_AMT_TO_SW_OUT_CCY_CODE CHARACTER VARYING(5) 5
39 THRESHOLD_AMOUNT_AMT DOUBLE PRECISION 8
40 THRESHOLD_AMOUNT_CCY_CODE CHARACTER VARYING(5) 5
41 PRICING_TICKET_CODE CHARACTER VARYING(40) 40
42 COUNT_EXE_INSTR_NUM BIGINT 8
43 BRANCH_CODE CHARACTER VARYING(50) 50
44 OVERDRAFT_FLAG CHARACTER(1) 1
45 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
46 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
47 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
48 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
49 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8