CFD_TCFDW_DOM_BRCH_LOCN

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COST_CTR DOUBLE PRECISION 8
2 BRANCH_NAME CHARACTER VARYING(25) 25
3 SUBURB CHARACTER VARYING(20) 20
4 STATE CHARACTER VARYING(3) 3
5 POSTCODE DOUBLE PRECISION 8
6 REGION CHARACTER VARYING(100) 100
7 XX DOUBLE PRECISION 8
8 YY DOUBLE PRECISION 8
9 FLAG CHARACTER VARYING(7) 7
10 COST_CTR2 CHARACTER VARYING(10) 10
11 POST_CODE CHARACTER VARYING(10) 10
12 BRCH_ID DOUBLE PRECISION 8
13 CRM_QUEUE_NAME CHARACTER VARYING(100) 100
14 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
15 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
16 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
17 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8