INT_PCSRCPN_ADSTAIL

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 MD5_KEY CHARACTER VARYING(128) 128
2 REC_TYPE_CD INTEGER 4
3 BATCH_KEY INTEGER 4
4 RUN_REG_KEY BIGINT 8
5 ROW_INSERT_DT TIMESTAMP 8
6 ROW_EFFECTIVE_DT TIMESTAMP 8
7 AUDIT_FLAG CHARACTER VARYING(1) 1
8 COMPANY SMALLINT 2
9 PRODUCT CHARACTER VARYING(3) 3
10 POLICY INTEGER 4
11 ITEMNO SMALLINT 2
12 EFFECTDTE INTEGER 4
13 ACTIVTO INTEGER 4
14 TRANCNT SMALLINT 2
15 IMAGEFLAG CHARACTER VARYING(1) 1
16 SBBLDSI NUMERIC(11,0) 19
17 SBBLDRTE NUMERIC(7,4) 19
18 SBBLDPRM NUMERIC(9,2) 19
19 SBBLDXS NUMERIC(7,0) 19
20 SBCNTSI NUMERIC(11,0) 19
21 SBCNTRTE NUMERIC(7,4) 19
22 SBCNTPRM NUMERIC(9,2) 19
23 SBCNTXS NUMERIC(7,0) 19
24 SBITEMSI NUMERIC(11,0) 19
25 SBITEMRTE NUMERIC(7,4) 19
26 SBITEMPRM NUMERIC(9,2) 19
27 SBITEMXS NUMERIC(7,0) 19
28 SBROCCUP CHARACTER VARYING(4) 4