FCT_CUST_CRLGC_CLLTRL_SALES

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_NUM CHARACTER VARYING(20) 20
2 BRND_CODE CHARACTER VARYING(10) 10
3 BRND_DESC CHARACTER VARYING(50) 50
4 PRDT_SYS_CODE CHARACTER VARYING(10) 10
5 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
6 ACCOUNT_NUMBER CHARACTER VARYING(20) 20
7 PRDT_LIFECYCLE_STAT_CODE CHARACTER VARYING(1) 1
8 PRDT_ID INTEGER 4
9 PRDT_DESC CHARACTER VARYING(100) 100
10 CUST_PRDT_RSHIP_TYP_CODE CHARACTER VARYING(20) 20
11 CUST_PRDT_RSHIP_TYP_DESC CHARACTER VARYING(50) 50
12 ROLE_EFF_DATE TIMESTAMP 8
13 ROLE_EXPIRY_DATE TIMESTAMP 8
14 LOB_CODE CHARACTER VARYING(4) 4
15 SUB_LOB_CODE CHARACTER VARYING(4) 4
16 PRDT_CAT_2 CHARACTER VARYING(50) 50
17 PRDT_CAT_3 CHARACTER VARYING(50) 50
18 PRDT_CAT_TYP_DESC CHARACTER VARYING(50) 50
19 BASE_PRDT_IND CHARACTER VARYING(1) 1
20 OWNING_RSHIP_IND CHARACTER VARYING(1) 1
21 COLLATERAL_ID CHARACTER VARYING(18) 18
22 COLLATERAL_STATUS CHARACTER(1) 1
23 COLLATERAL_ASSET_DESCRIPTION CHARACTER VARYING(255) 255
24 FACILITY_STATUS CHARACTER VARYING(1) 1
25 FACILITY_ID CHARACTER VARYING(40) 40
26 EXTERNAL_ACCOUNT_NUMBER CHARACTER VARYING(40) 40
27 EXTERNAL_ACCOUNT_SYSTEM CHARACTER VARYING(20) 20
28 EXTERNAL_ACCOUNT_STATUS CHARACTER VARYING(50) 50
29 ADDRESS_LINE1 CHARACTER VARYING(35) 35
30 ADDRESS_LINE2 CHARACTER VARYING(35) 35
31 ADDRESS_LINE3 CHARACTER VARYING(1) 1
32 POSTCODE CHARACTER VARYING(30) 30
33 SUBURB CHARACTER VARYING(50) 50
34 STATE CHARACTER VARYING(30) 30
35 AKEY CHARACTER VARYING(151) 151
36 SOLD_DATE TIMESTAMP 8
37 SOLD_PRICE CHARACTER VARYING(256) 256
38 SENT_DATA_DATE DATE 4
39 RECEIVED_DATA_DATE TIMESTAMP 8