BUSINESS_UNITSHIP_IDSHIP_ID_ESTIN_FRT_CLC(SQL View) |
Index Back |
|---|---|
InventoryShipping freight viewUsed to calculate freight charges in IN. |
| SELECT s.business_unit , s.SHIP_ID , s.SHIP_ID_EST , os.trft_set_id , SUM(s.qty_shipped) , SUM(s.net_unit_price) , 0 , 0 FROM ps_in_frt_set os , PS_IN_DEMAND s WHERE s.in_fulfill_state >= '50' AND os.business_unit = s.business_unit AND os.ship_id = s.ship_id AND os.ship_id_est = s.ship_id_est GROUP BY s.business_unit, s.SHIP_ID, s.SHIP_ID_EST, os.trft_set_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SHIP_ID |
Character(10) | VARCHAR2(10) NOT NULL | Shipping ID |
| 3 | SHIP_ID_EST |
Character(10) | VARCHAR2(10) NOT NULL | Estimated Ship ID |
| 4 | TRFT_SET_ID | Character(10) | VARCHAR2(10) NOT NULL | Rule Cd |
| 5 | TOT_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Quantity |
| 6 | TOT_NET | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Net Price |
| 7 | TOTAL_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Weight |
| 8 | TOTAL_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Volume |