INT_PCSRCPN_SUBLIMEX

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 SUBLIMCDE CHARACTER VARYING(4) 4
13 DEDUCTCDE CHARACTER VARYING(4) 4
14 TRANCNT SMALLINT 2
15 LINENO SMALLINT 2
16 EFFECTDTE INTEGER 4
17 ACTIVTO INTEGER 4
18 IMAGEFLAG CHARACTER VARYING(1) 1
19 DATATYPE CHARACTER VARYING(2) 2
20 DATAVAL NUMERIC(15,4) 19
21 SECTNIND CHARACTER VARYING(1) 1
22 DESC CHARACTER VARYING(50) 50