OBP24_HST_FLX_PR_TRNDETL_FEE_CHARGE

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TICKET_CODE CHARACTER VARYING(128) 128
2 EVENT_CODE CHARACTER VARYING(50) 50
3 SERVICING_ARRANGEMENT_CODE CHARACTER VARYING(128) 128
4 PRICE_CODE CHARACTER VARYING(20) 20
5 FEE_CODE CHARACTER VARYING(128) 128
6 PROCESSED_BASE_CHILD_TYPE CHARACTER(1) 1
7 FEE_PARENT_CODE CHARACTER VARYING(128) 128
8 EFFECTIVE_DATE TIMESTAMP 8
9 COMPUTATION_DATE TIMESTAMP 8
10 CHARGE_DATE TIMESTAMP 8
11 NET_CHARGABLE_AMT DOUBLE PRECISION 8
12 NET_CHARGABLE_AMT_CCY_CODE CHARACTER VARYING(3) 3
13 CHARGEABLE_AMT DOUBLE PRECISION 8
14 CHARGEABLE_AMT_CCY_CODE CHARACTER VARYING(3) 3
15 CHARGED_AMT DOUBLE PRECISION 8
16 CHARGED_AMT_CCY_CODE CHARACTER VARYING(3) 3
17 REFUNDED_AMT DOUBLE PRECISION 8
18 REFUNDED_AMT_CCY_CODE CHARACTER VARYING(3) 3
19 SYS_WAIVED_AMT DOUBLE PRECISION 8
20 SYS_WAIVED_AMT_CCY_CODE CHARACTER VARYING(3) 3
21 CUSTM_WAIVED_AMT DOUBLE PRECISION 8
22 CUSTM_WAIVED_AMT_CCY_CODE CHARACTER VARYING(3) 3
23 BASE_CHARGABLE_AMT DOUBLE PRECISION 8
24 BASE_CHARGABLE_AMT_CCY_CODE CHARACTER VARYING(3) 3
25 UNROUNDED_BASE_CHARGABLE_AMT DOUBLE PRECISION 8
26 UNROUNDED_BASE_CHRG_CCY_CODE CHARACTER VARYING(3) 3
27 LOCAL_CHARGED_AMT DOUBLE PRECISION 8
28 LOCAL_CHARGED_AMT_CCY_CODE CHARACTER VARYING(3) 3
29 NEGOTIATED_BASE_AMT DOUBLE PRECISION 8
30 NEGOTIATED_BASE_AMT_CCY_CODE CHARACTER VARYING(3) 3
31 CHARGE_ACTION_TYPE CHARACTER VARYING(50) 50
32 IS_PRORATED_FLAG CHARACTER(1) 1
33 REASON_FOR_REVERSAL_CODE CHARACTER VARYING(20) 20
34 BUNDLE_VAR_AMT DOUBLE PRECISION 8
35 BUNDLE_VAR_CCY_CODE CHARACTER VARYING(3) 3
36 CAMPAIGN_VAR_AMT DOUBLE PRECISION 8
37 CAMPAIGN_VAR_CCY_CODE CHARACTER VARYING(3) 3
38 BEFORE_ACCT_VAR_BASE_AMT DOUBLE PRECISION 8
39 BEFORE_ACCT_VAR_CCY_CODE CHARACTER VARYING(3) 3
40 FEE_GRP_WAIVED_AMT DOUBLE PRECISION 8
41 FEE_GRP_WAIVED_AMT_CCY_CODE CHARACTER VARYING(3) 3
42 APPLICABLE_PERIOD_START_DATE TIMESTAMP 8
43 APPLICABLE_PERIOD_END_DATE TIMESTAMP 8
44 ORIGINAL_FEE_DETAIL_CODE CHARACTER VARYING(128) 128
45 CHARGE_ATTR_CODE CHARACTER VARYING(200) 200
46 ENTITY_STATUS CHARACTER VARYING(1) 1
47 ORG_NET_CHARGABLE_AMT DOUBLE PRECISION 8
48 ORG_NET_CHARGABLE_AMT_CCY_CODE CHARACTER VARYING(3) 3
49 APPROVAL_STATUS CHARACTER VARYING(50) 50
50 NARRATION_STRING CHARACTER VARYING(128) 128
51 ORIGINAL_PRICE_CODE CHARACTER VARYING(20) 20
52 ORIGINAL_PRICE_EFFECTIVE_DATE TIMESTAMP 8
53 COMMENTS_FOR_REFUND CHARACTER VARYING(2000) 2000
54 AFTER_ACCT_VAR_BASE_AMT DOUBLE PRECISION 8
55 AFTER_ACCT_VAR_CCY_CODE CHARACTER VARYING(3) 3
56 FEE_GROUP_CONCESSION_REQUIRED CHARACTER(1) 1
57 NEGOTIATION_REASON_CODE CHARACTER VARYING(255) 255
58 NEGOTIATION_REMARKS CHARACTER VARYING(255) 255
59 LAST_CHARGE_DATE TIMESTAMP 8
60 REFUND_COUNT DOUBLE PRECISION 8
61 DISCOUNT_PERCENT DOUBLE PRECISION 8
62 NEGOTIATION_TYPE CHARACTER VARYING(50) 50
63 DISCOUNT_OR_REPLACE_AMT DOUBLE PRECISION 8
64 DISCOUNT_OR_REPLACE_AMT_CCY CHARACTER VARYING(3) 3
65 FEE_CONCESSION_GROUP_ID CHARACTER VARYING(50) 50
66 FEE_CON_GROUP_EFFECTIVE_DATE TIMESTAMP 8
67 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
68 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
69 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
70 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8