CFD_TCFDT_SUPER_COMMISSION_TXN

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_SYS_CODE CHARACTER VARYING(10) 10
2 COMM_TXN_ID DOUBLE PRECISION 8
3 COMM_PARTY_TYP_ID DOUBLE PRECISION 8
4 COMM_PARTY_ID DOUBLE PRECISION 8
5 TXN_TYP_ID DOUBLE PRECISION 8
6 TXN_TYP_CODE CHARACTER VARYING(20) 20
7 TXN_POSTED_DATE TIMESTAMP 8
8 TXN_EFF_DATE TIMESTAMP 8
9 COMM_TXN_AMT NUMERIC(18,6) 19
10 DISBURSMNT_RULE_ID DOUBLE PRECISION 8
11 DISBURSMNT_RULE_NUM DOUBLE PRECISION 8
12 TXN_NOTATION_DESC CHARACTER VARYING(300) 300
13 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
14 MBR_ACCT_TXN_ID DOUBLE PRECISION 8
15 DATA_LOAD_DATE TIMESTAMP 8
16 SNPSHT_DATE TIMESTAMP 8
17 SRC_SYS_ID CHARACTER VARYING(5) 5
18 LOAD_ID DOUBLE PRECISION 8
19 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
20 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
21 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
22 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8