OM_MUPD_RTE_LNG(SQL View) |
Index Back |
---|---|
Route Code Table Related Lang.Defines the route codes that can be used within the enterprise. Date Initials Issue Description 080703 dms IR625365001 New view for update schedules rc page |
SELECT route_cd , language_cd , descr FROM PS_ROUTE_INV_LANG |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ROUTE_CD | Character(6) | VARCHAR2(6) NOT NULL | A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles. |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |