INT_PCSRCPN_PRT_MVMAKE

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 MVMAKE CHARACTER(4) 4
10 MVMODEL CHARACTER(7) 7
11 MVTYPE CHARACTER(2) 2
12 MVFUEL CHARACTER(1) 1
13 MVENGCAP SMALLINT 2
14 MVAUTO CHARACTER(1) 1
15 MVMANUFYR SMALLINT 2
16 MVYEARSEQ CHARACTER(1) 1
17 MVGEARS CHARACTER(1) 1
18 PRICENEW INTEGER 4
19 PRICETRDE INTEGER 4
20 PRICERETL INTEGER 4
21 DESC CHARACTER(60) 60
22 MVCATMAKE CHARACTER(4) 4
23 MVGUIDE1 CHARACTER(1) 1
24 MVGUIDE2 CHARACTER(1) 1
25 MVGUIDE3 CHARACTER(1) 1
26 MVGUIDE4 CHARACTER(1) 1
27 MVGUIDE5 CHARACTER(1) 1
28 MVNOCYL CHARACTER(3) 3
29 MVBODTYP2 CHARACTER(2) 2
30 MVSERIES CHARACTER(2) 2
31 MVDESC1 CHARACTER(20) 20
32 SEQUENCE INTEGER 4
33 MVTRANS CHARACTER(1) 1
34 USERID CHARACTER(8) 8
35 NVIC CHARACTER(6) 6
36 MVTRANSG CHARACTER(2) 2
37 MVENGTYPE CHARACTER(2) 2