PRT_MBTAIL

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 PRODUCT CHARACTER VARYING(3) 3
3 POLICY INTEGER 4
4 ITEMNO SMALLINT 2
5 EFFECTDTE INTEGER 4
6 ACTIVTO INTEGER 4
7 TRANCNT SMALLINT 2
8 IMAGEFLAG CHARACTER VARYING(1) 1
9 MBELMOTUN SMALLINT 2
10 MBELMOTVL NUMERIC(11,0) 19
11 MBELWELUN SMALLINT 2
12 MBELWELVL NUMERIC(11,0) 19
13 MBPUMPUN SMALLINT 2
14 MBPUMPVL NUMERIC(11,0) 19
15 MBFANUN SMALLINT 2
16 MBFANVL NUMERIC(11,0) 19
17 MBCONVUN SMALLINT 2
18 MBCONVVL NUMERIC(11,0) 19
19 MBMILKUN SMALLINT 2
20 MBMILKVL NUMERIC(11,0) 19
21 MBVATSUN SMALLINT 2
22 MBVATSVL NUMERIC(11,0) 19
23 MBFEEDUN SMALLINT 2
24 MBFEEDVL NUMERIC(11,0) 19
25 MBUNSPUN SMALLINT 2
26 MBUNSPVL NUMERIC(11,0) 19
27 MBVAR1DES CHARACTER VARYING(30) 30
28 MBVAR1UN SMALLINT 2
29 MBVAR1VL NUMERIC(11,0) 19
30 MBAIRUN SMALLINT 2
31 MBAIRVL NUMERIC(11,0) 19
32 MBWATERUN SMALLINT 2
33 MBWATERVL NUMERIC(11,0) 19
34 MBBOILUN SMALLINT 2
35 MBBOILVL NUMERIC(11,0) 19
36 MBVAR2DES CHARACTER VARYING(30) 30
37 MBVAR2UN SMALLINT 2
38 MBVAR2VL NUMERIC(11,0) 19
39 MBCOMPVL NUMERIC(11,0) 19
40 MBFRIGVL NUMERIC(11,0) 19
41 MBVAR3DES CHARACTER VARYING(30) 30
42 MBVAR3VL NUMERIC(11,0) 19
43 MBSPOILVL NUMERIC(11,0) 19
44 MBMLTDISC CHARACTER VARYING(2) 2
45 MBRICODE CHARACTER VARYING(2) 2
46 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
47 RECORD_TYPE CHARACTER VARYING(16) 16
48 COMMIT_TIMESTAMP TIMESTAMP 8
49 EXTRACT_TIMESTAMP TIMESTAMP 8
50 CDC_ID BIGINT 8
51 COMPANY_CDC SMALLINT 2
52 POLICY_CDC BIGINT 8
53 ACTIVTO_CDC DATE 4
54 EFFECTDTE_CDC DATE 4
55 DW_TIMESTAMP TIMESTAMP 8