CFD_TCFDD_AGENT_ADDRESS

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 AGNT_CODE CHARACTER VARYING(20) 20
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 ADDR_TYP_CODE CHARACTER VARYING(20) 20
4 EFF_STRT_DATE TIMESTAMP 8
5 AGNT_DETL_ID BIGINT 8
6 ADDR_TYP_ID BIGINT 8
7 ADDR_LNE_1 CHARACTER VARYING(100) 100
8 ADDR_LNE_2 CHARACTER VARYING(100) 100
9 ADDR_LNE_3 CHARACTER VARYING(100) 100
10 ADDR_LNE_4 CHARACTER VARYING(100) 100
11 SBRB_CODE CHARACTER VARYING(50) 50
12 PCODE CHARACTER VARYING(10) 10
13 STATE_ID BIGINT 8
14 STATE_CODE CHARACTER VARYING(50) 50
15 CNTRY_DESC CHARACTER VARYING(50) 50
16 ASIS_ADDR_CODE CHARACTER VARYING(20) 20
17 CRNT_ADDR_FLG CHARACTER VARYING(1) 1
18 EFF_END_DATE TIMESTAMP 8
19 DATA_LOAD_DATE TIMESTAMP 8
20 SNPSHT_DATE TIMESTAMP 8
21 SRC_SYS_ID CHARACTER VARYING(5) 5
22 AGGRESSIVE_LOAD_IND CHARACTER VARYING(3) 3
23 LOAD_ID BIGINT 8
24 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
25 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
26 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
27 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8