INT_PCSRCPN_BUTAIL

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 BUSTKSI INTEGER 4
17 BUSTKVAL INTEGER 4
18 BUSTKSEAS INTEGER 4
19 BUCNTSI INTEGER 4
20 BUCNTVAL INTEGER 4
21 BUCIGSI INTEGER 4
22 BUCIGVAL INTEGER 4
23 BUCIGSEAS INTEGER 4
24 BUACNTSI INTEGER 4
25 BUACNTVAL INTEGER 4
26 BUACNTSS INTEGER 4
27 BUGOODSI INTEGER 4
28 BUGOODVAL INTEGER 4
29 BUAIRSI INTEGER 4
30 BUAIRVAL INTEGER 4
31 BUAIRSEAS INTEGER 4
32 BUDMGSI INTEGER 4
33 BUDMGSSI INTEGER 4
34 BUSPCSI INTEGER 4
35 BUSPCDESC CHARACTER VARYING(80) 80
36 BUROCCUP CHARACTER VARYING(4) 4
37 BURIOTS CHARACTER VARYING(1) 1
38 BUHOLDUP CHARACTER VARYING(1) 1
39 BUTHEFT CHARACTER VARYING(1) 1
40 BUSKYLT CHARACTER VARYING(1) 1
41 BUSKYLTTY CHARACTER VARYING(1) 1
42 BUTYWIND CHARACTER VARYING(1) 1
43 BUBARS CHARACTER VARYING(1) 1
44 BUDOORPRT CHARACTER VARYING(1) 1
45 BUDOORLCK CHARACTER VARYING(1) 1
46 BUALARM CHARACTER VARYING(2) 2
47 BUWATCHMN CHARACTER VARYING(1) 1
48 BUTYWINDP CHARACTER VARYING(1) 1
49 BULIQSI INTEGER 4
50 BULIQVAL INTEGER 4
51 BULIQSEAS INTEGER 4
52 BUMLTDISC CHARACTER VARYING(2) 2
53 BUSTKPC SMALLINT 2
54 BUCNTPC SMALLINT 2
55 BUCIGPC SMALLINT 2
56 BULIQPC SMALLINT 2
57 BUACNTPC SMALLINT 2
58 BUGOODPC SMALLINT 2
59 BUAIRPC SMALLINT 2
60 BUTOOLS INTEGER 4
61 BUFURNTRE INTEGER 4
62 BUTARGET CHARACTER VARYING(1) 1