PROPERTY_IDPrompt Table: VEH_EQUIP_VW
VEH_EQUIP_SERVC_DTDefault Value: %date
LANGUAGE_CDVEH_EQUIPMT_LNG(SQL Table) |
Index Back |
|---|---|
RellangVehicle Service MaintUse this record to record service and maintenance data on vehicles or equipment owned by the company. Before a VEH_EQUIP_MAINT record can be created for a vehicle or piece of equipment, you must first assign a PROPERTY_ID on COMP_PROP_TBL to the item. This data is part of the Health and Safety module. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROPERTY_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Property Code
Prompt Table: VEH_EQUIP_VW |
| 2 | VEH_EQUIP_SERVC_DT |
Date(10) | DATE NOT NULL |
Service Date
Default Value: %date |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | MECHANIC_NAME | Character(50) | VARCHAR2(50) NOT NULL | Vehicle Mechanic |
| 5 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 6 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 7 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 8 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |