INT_BASE_PI_JCI_PREMTRAN

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY_NO INTEGER 4
2 AGREEMENT_TYPE CHARACTER VARYING(3) 3
3 POLICY_NO INTEGER 4
4 ITEM_NO SMALLINT 2
5 PRODUCT_TYPE_CODE CHARACTER(3) 3
6 PRODUCT_CLASS_CODE CHARACTER(3) 3
7 PRODUCT_SUBCLASS CHARACTER(3) 3
8 DIVISION_ID CHARACTER(2) 2
9 TRANSACTION_DATE DATE 4
10 TRANTIME_REF INTEGER 4
11 TRANSACTION_TYPE CHARACTER(2) 2
12 SCHEDULE_START DATE 4
13 SCHEDULE_END DATE 4
14 TRAN_BASIC_PREM NUMERIC(11,2) 19
15 CANCEL_REASON_ID CHARACTER(2) 2