SHIP_FROM_BULOAD_IDPrompt Table: LOAD_INV
Prompt Table: CARRIER_ID
Prompt Table: SHIP_METHOD
OM_LOAD_INV_VW(SQL View) |
Index Back |
|---|---|
Load ViewDate Initials Issue Description 080703 dms IR625365001 New view for update schedules rc page |
| SELECT business_unit , load_id , carrier_id , ship_type_id , sched_date , sched_time FROM PS_LOAD_INV |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SHIP_FROM_BU |
Character(5) | VARCHAR2(5) NOT NULL | Ship from INV BU |
| 2 | LOAD_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Load ID
Prompt Table: LOAD_INV |
| 3 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table: CARRIER_ID |
| 4 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table: SHIP_METHOD |
| 5 | SCHED_DATE | Date(10) | DATE | Schedule Date |
| 6 | SCHED_TIME | Time(15) | TIMESTAMP | Schedule Time |