LOAD_IDPrompt Table: LOAD_INV
Prompt Table: SP_BUIN_NONVW
Prompt Table: CARRIER_ID
Prompt Table: SHIP_METHOD
OM_MUPD_LOAD_VW(SQL View) |
Index Back |
|---|---|
Load Table View |
| SELECT load_id ,business_unit ,carrier_id ,ship_type_id ,sched_date ,sched_time FROM PS_LOAD_INV WHERE load_id_status='O' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LOAD_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Load ID
Prompt Table: LOAD_INV |
| 2 | SHIP_FROM_BU | Character(5) | VARCHAR2(5) NOT NULL |
Ship from INV BU
Prompt Table: SP_BUIN_NONVW |
| 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 |