BUSINESS_UNITLOAD_IDBOL_LOAD_VW(SQL View) |
Index Back |
|---|---|
BOL -Shipped lines by load id |
| SELECT DISTINCT s.business_unit , s.load_id , l.carrier_id , l.ship_type_id , l.sched_date , l.sched_time FROM PS_IN_DEMAND s , ps_load_inv l WHERE s.in_fulfill_state BETWEEN '60' AND '70' AND s.bill_of_lading = ' ' AND s.load_id <> ' ' AND s.deplete_inv_flg = 'Y' AND l.business_unit = s.business_unit AND l.load_id = s.load_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | LOAD_ID |
Character(10) | VARCHAR2(10) NOT NULL | Load ID |
| 3 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier ID |
| 4 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |
| 5 | SCHED_DATE | Date(10) | DATE | Schedule Date |
| 6 | SCHED_TIME | Time(15) | TIMESTAMP | Schedule Time |