BUS_UNIT_SOURCEPrompt Table: SP_BUIN_NONVW
SHIP_TYPE_IDPL_TRAN_GEN_VW(SQL View) |
Index Back |
|---|---|
Unit Transfer Attrib. by Item12/13/01 EGS (CN#PL900-1): Added. |
| SELECT s.business_unit , a.inv_item_id , s.bus_unit_source , s.ship_type_id , s.effdt , s.transfer_min_order , s.transfer_max_order , s.trans_ord_multiple , s.transfer_yield , s.transit_cost , 0.0 FROM ps_trans_unit s , ps_pl_item_attrib a WHERE s.business_unit = a.business_unit AND a.planned_by = '1' AND s.eff_status = 'A' AND s.incl_in_plan = 'Y' AND s.effdt = ( SELECT MAX(I.effdt) FROM ps_trans_unit I WHERE I.business_unit = s.business_unit AND I.bus_unit_source = s.bus_unit_source AND I.ship_type_id = s.ship_type_id AND I.effdt <= %CurrentDateIn AND I.eff_status = 'A') AND EXISTS ( SELECT 'X' FROM ps_pl_item_attrib aa , PS_BU_ITEMS_INV bb WHERE s.bus_unit_source = aa.business_unit AND a.inv_item_id = aa.inv_item_id AND s.bus_unit_source = bb.business_unit AND a.inv_item_id = bb.inv_item_id AND bb.itm_status_current <> '4' AND bb.itm_status_effdt <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | BUS_UNIT_SOURCE |
Character(5) | VARCHAR2(5) NOT NULL |
Source Business Unit
Prompt Table: SP_BUIN_NONVW |
| 4 | SHIP_TYPE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |
| 5 | DATE_IN_EFFECT | Date(10) | DATE | 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label |
| 6 | TRANSFER_MIN_ORDER | Number(12,4) | DECIMAL(11,4) NOT NULL | CN#PL800-18.0 MACN 11/02/99 - Changed short description from Order Qty to Min Order Qty. jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4 KPN 08/26/02: Added label PL_TRANS_MIN_ORDER |
| 7 | TRANSFER_MAX_ORDER | Number(12,4) | DECIMAL(11,4) NOT NULL | CN#PL800-18.0 MACN 11/02/99 - Changed short description from Order Qty to Max Order Qty. jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4 KPN 08/26/02: Added label PL_TRANS_MAX_ORDER |
| 8 | TRANS_ORD_MULTIPLE | Number(12,4) | DECIMAL(11,4) NOT NULL | jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4 |
| 9 | TRANSFER_YIELD | Number(5,1) | DECIMAL(4,1) NOT NULL | Transfer Yield |
| 10 | TRANSIT_COST | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Transportation Cost |
| 11 | COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Cost |