PRT_INSTPREM_SNAPSHOT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
4 TERMSTART INTEGER 4
5 INSTSEQ SMALLINT 2
9 INSTDATE INTEGER 4
10 INSTTYPE CHARACTER VARYING(1) 1
11 INSTSTAT CHARACTER VARYING(1) 1
12 INSTAMT NUMERIC(9,2) 19
13 BASICPRM NUMERIC(9,2) 19
14 CHARGES NUMERIC(9,2) 19
15 STMPDUTY NUMERIC(9,2) 19
16 DEBITDATE INTEGER 4
17 DEBITTYPE CHARACTER VARYING(1) 1
18 DEBITSEQ INTEGER 4
19 BSBNO CHARACTER VARYING(6) 6
20 DEBITACCT CHARACTER VARYING(9) 9
21 CREDCARD CHARACTER VARYING(16) 16
22 REJECTDATE INTEGER 4
23 REJECTCNT SMALLINT 2
24 REJREASON CHARACTER VARYING(2) 2
25 STATE SMALLINT 2
26 BRANCH SMALLINT 2
27 GST NUMERIC(9,2) 19
28 COMMISN NUMERIC(9,2) 19
29 COMMGST NUMERIC(9,2) 19
36 POLICY_CDC BIGINT 8
37 ACTIVTO_CDC DATE 4