INT_MOTOR_SALVAGE_RECEIVED

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLAIMID BIGINT 8
2 TRANSACTION_ID BIGINT 8
3 PAYMENTREFNUMBER CHARACTER VARYING(19) 19
4 COSTCATEGORY BIGINT 8
5 COSTCATEGORY_TYPECODE CHARACTER VARYING(50) 50
6 STATUS BIGINT 8
7 STATUS_TYPECODE CHARACTER VARYING(50) 50
8 SUBTYPE BIGINT 8
9 TRANSACTION_SUBTYPECODE CHARACTER VARYING(50) 50
10 VEHICLEINCIDENTID BIGINT 8
11 TRANSACTION_CREATETIME TIMESTAMP 8
12 SC_GLSERVICEACKTIME TIMESTAMP 8
13 TRANSACTIONAMOUNT NUMERIC(18,2) 19
14 NET_TRANSACTIONAMOUNT NUMERIC(19,2) 19