CFD_TCFDR_DISBURSEMENT_RULE

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DISBURSMNT_RULE_ID BIGINT 8
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 DISBURSMNT_RULE_NUM BIGINT 8
4 DISBURSMNT_RULE_NAM CHARACTER VARYING(50) 50
5 DISBURSMNT_TYP_DESC CHARACTER VARYING(50) 50
6 DISBURSMNT_STAT_ID BIGINT 8
7 DISBURSMNT_STAT_CODE CHARACTER VARYING(20) 20
8 DISBURSMNT_STRT_DATE TIMESTAMP 8
9 DISBURSMNT_END_DATE TIMESTAMP 8
10 INDIVIDUAL_OVRDE_FLG CHARACTER VARYING(3) 3
11 FND_TYP_ID BIGINT 8
12 FND_TYP_CODE CHARACTER VARYING(20) 20
13 SUB_FND_TYP_ID BIGINT 8
14 SUB_FND_TYP_CODE CHARACTER VARYING(20) 20
15 PRDT_ID BIGINT 8
16 PRDT_GRP_CODE CHARACTER VARYING(20) 20
17 PRDT_TYP_CODE CHARACTER VARYING(20) 20
18 DLR_ID BIGINT 8
19 DLR_CODE CHARACTER VARYING(20) 20
20 AGNT_ACCT_NUM BIGINT 8
21 EMPR_NUM BIGINT 8
22 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
23 PRDT_SYS_CUST_NUM CHARACTER VARYING(30) 30
24 EFF_STRT_DATE TIMESTAMP 8
25 EFF_END_DATE TIMESTAMP 8
26 DATA_LOAD_DATE TIMESTAMP 8
27 SNPSHT_DATE TIMESTAMP 8
28 SRC_SYS_ID CHARACTER VARYING(5) 5
29 LOAD_ID BIGINT 8
30 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
31 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
32 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
33 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8