ENGINE_TYPE_CDDIE=Diesel with cylinder capacity
OTH=Car without cylinder capacity
PET=Petrol with cylinder capacity
N=Customer Data
S=Sample Data
Y=System Data
Default Value: Y
ENGINE_TYPE_UK(SQL Table) |
Index Back |
|---|---|
Used for entering engine typesEngine Type SETUP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ENGINE_TYPE_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Engine Type
DIE=Diesel with cylinder capacity OTH=Car without cylinder capacity PET=Petrol with cylinder capacity |
| 2 | ENGINE_TYPE_L_DESC | Character(45) | VARCHAR2(45) NOT NULL | Engine Type Long Description |
| 3 | ENGINE_TYPE_S_DESC | Character(10) | VARCHAR2(10) NOT NULL | Engine Type Short Description |
| 4 | BASE_DISCOUNT_PERC | Number(2,0) | SMALLINT NOT NULL | Base Discount % |
| 5 | SUPPLEMENT_PERC_UK | Number(2,0) | SMALLINT NOT NULL | Supplement Percentage for Company Cars Engine Type |
| 6 | EMISION_DISCOUNT_P | Number(2,0) | SMALLINT NOT NULL | Emissions Discount % |
| 7 | EMISION_DISCOUNT_G | Number(3,0) | SMALLINT NOT NULL | Emissions Discount gms |
| 8 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: Y |