PRT_MVMAKE

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 MVMAKE CHARACTER(4) 4
3 MVMODEL CHARACTER(7) 7
4 MVTYPE CHARACTER(2) 2
5 MVFUEL CHARACTER(1) 1
6 MVENGCAP SMALLINT 2
7 MVAUTO CHARACTER(1) 1
8 MVMANUFYR SMALLINT 2
9 MVYEARSEQ CHARACTER(1) 1
10 MVGEARS CHARACTER(1) 1
11 PRICENEW INTEGER 4
12 PRICETRDE INTEGER 4
13 PRICERETL INTEGER 4
14 DESC CHARACTER(60) 60
15 MVCATMAKE CHARACTER(4) 4
16 MVGUIDE1 CHARACTER(1) 1
17 MVGUIDE2 CHARACTER(1) 1
18 MVGUIDE3 CHARACTER(1) 1
19 MVGUIDE4 CHARACTER(1) 1
20 MVGUIDE5 CHARACTER(1) 1
21 MVNOCYL CHARACTER(3) 3
22 MVBODTYP2 CHARACTER(2) 2
23 MVSERIES CHARACTER(2) 2
24 MVDESC1 CHARACTER(20) 20
25 SEQUENCE INTEGER 4
26 MVTRANS CHARACTER(1) 1
27 USERID CHARACTER(8) 8
28 NVIC CHARACTER(6) 6
29 MVTRANSG CHARACTER(2) 2
30 MVENGTYPE CHARACTER(2) 2
31 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
32 RECORD_TYPE CHARACTER VARYING(16) 16
33 COMMIT_TIMESTAMP TIMESTAMP 8
34 EXTRACT_TIMESTAMP TIMESTAMP 8
35 CDC_ID BIGINT 8
36 COMPANY_CDC SMALLINT 2
37 DW_TIMESTAMP TIMESTAMP 8