FCT_MOTOR_SUPPLIER_PAYMENT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLAIM_ID BIGINT 8
2 CLAIM_NUMBER CHARACTER VARYING(40) 40
3 LODGEMENT_DATE DATE 4
4 CONSULTANT CHARACTER VARYING(181) 181
5 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
6 LOSS_TYPE_NAME CHARACTER VARYING(256) 256
7 INVOICE_RECEIVED_DATE DATE 4
8 INVOICE_ISSUE_DATE TIMESTAMP 8
9 PAYEE CHARACTER VARYING(255) 255
10 AMOUNT NUMERIC(18,2) 19
11 ISSUED_AGE INTERVAL 12
12 NUM_ISSUED_AGE BIGINT 8
13 ISSUED_AGE_BAND CHARACTER VARYING(12) 12
14 ISSUED_AGE_BAND_CUM CHARACTER VARYING(10) 10