OBP24_FLX_PR_TRNDETL_FEE_CHARGE
Description
Synonyms
SDSNZP05_BANK..CBP_OBP_FLX_PR_TRNDETL_FEE_CHARGE
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 |