INT_CTP_ITEM

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 AGREEMENT_TYPE_CDC CHARACTER(3) 3
3 PRODUCT CHARACTER(3) 3
4 POLICY INTEGER 4
5 ITEMNO SMALLINT 2
6 TRANCNT SMALLINT 2
7 CLASS CHARACTER(3) 3
8 EFFECTDTE INTEGER 4
9 TERMINCEP INTEGER 4
10 LOCATNREF INTEGER 4
11 TAILORGRP CHARACTER(2) 2
12 IMAGEFLAG CHARACTER(1) 1
13 CBASICPRM NUMERIC(11,2) 19
14 CCHARGES NUMERIC(11,2) 19
15 CSTMPDUTY NUMERIC(11,2) 19
16 CCOMMISN NUMERIC(11,2) 19
17 RBASICPRM NUMERIC(11,2) 19
18 RCHARGES NUMERIC(11,2) 19
19 RSTMPDUTY NUMERIC(11,2) 19
20 RCOMMISN NUMERIC(11,2) 19
21 RGST NUMERIC(11,2) 19
22 RCOMMGST NUMERIC(11,2) 19
23 TBASICPRM NUMERIC(11,2) 19
24 TCHARGES NUMERIC(11,2) 19
25 TSTMPDUTY NUMERIC(11,2) 19
26 TCOMMISN NUMERIC(11,2) 19
27 CGST NUMERIC(11,2) 19
28 TGST NUMERIC(11,2) 19
29 CCOMMGST NUMERIC(11,2) 19
30 TCOMMGST NUMERIC(11,2) 19
31 ACTIVTO_CDC DATE 4
32 RECORD_TYPE CHARACTER VARYING(16) 16