INT_BASE_PI_RES_PREMTRAN

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY_NO INTEGER 4
2 PRODUCT_TYPE_CODE CHARACTER VARYING(3) 3
3 POLICY_NO BIGINT 8
4 ITEM_NO SMALLINT 2
5 TRANSACTION_DATE DATE 4
6 TRANTIME_REF INTEGER 4
7 TRANCNT INTEGER 4
8 PRODUCT_CLASS_CODE CHARACTER VARYING(2) 2
9 PRODUCT_SUBCLASS CHARACTER VARYING(2) 2
10 TRANSACTION_TYPE CHARACTER VARYING(2) 2
11 TRAN_BASIC_PREM NUMERIC(13,2) 19
12 ORIG_TXN_TYPE CHARACTER(2) 2
13 SUBLINE_OF_BUSS CHARACTER(3) 3
14 SCHEDULE_START DATE 4
15 COMM_ACCOUNT_1 CHARACTER(10) 10
16 COMM_ACCOUNT_2 CHARACTER(10) 10