FCT_PI_HOME_PROPERTY_SERVICE_INSIGHT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TRANSACTION_MONTH_YEAR TIMESTAMP 8
2 COST_CATEGORY CHARACTER VARYING(272) 272
3 COST_ITEM CHARACTER VARYING(256) 256
4 PROCUREMENT_CATEGORY CHARACTER VARYING(256) 256
5 EXPOSURE_TYPE CHARACTER VARYING(256) 256
6 LOSS_CAUSE CHARACTER VARYING(256) 256
7 PAYEE_NAME CHARACTER VARYING(255) 255
8 CASH_SETTLE_LIABILITY CHARACTER VARYING(256) 256
9 FULFILMENT_METHOD CHARACTER VARYING(15) 15
10 CLAIM_STATE CHARACTER VARYING(256) 256
11 EVENT_NAME CHARACTER VARYING(256) 256
12 CLAIM_TYPE CHARACTER VARYING(256) 256
13 BRAND_NAME CHARACTER VARYING(256) 256
14 OP_LOB CHARACTER VARYING(3) 3
15 SUBLOSS_GROUP CHARACTER VARYING(18) 18
16 NET_PAYMENTS NUMERIC(38,2) 19