INT_BASE_QUOTE_SHADOW_SHOP_20190926

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY_NO SMALLINT 2
2 POLICY_NO INTEGER 4
3 ITEM_NO SMALLINT 2
4 PRODUCT_TYPE_CODE CHARACTER(3) 3
5 PRODUCT_CLASS_CODE CHARACTER(3) 3
6 PRODUCT_SUBCLASS CHARACTER(3) 3
7 TRANSACTION_DATE DATE 4
8 FREQUENT_LURN_FLAG CHARACTER VARYING(1) 1
9 FREQUENT_DOB_FLAG CHARACTER VARYING(1) 1
10 FREQUENT_LURN_OCUPYAS_FLAG CHARACTER VARYING(1) 1
11 FREQUENT_LURN_AGE_FLAG CHARACTER VARYING(1) 1
12 FREQUENT_LURN_LIST_FLAG CHARACTER VARYING(1) 1
13 FREQUENT_POSTCODE_FLAG CHARACTER VARYING(1) 1
14 OTHER_COVER_GENUINE_FLAG CHARACTER VARYING(1) 1
15 SHADOW_SHOP_FLAG CHARACTER VARYING(1) 1