ITM_SHIP_INV_VW

(SQL View)
Index Back

Picked/Shipped Orders View 2

04/05/04 MEG CN#IN890: Modified view to select from IN_DEMAND instead of SHIP_INF_INV. Replaced sched_line_no with sched_line_nbr. /* 06/09/2004 PWF Change reference from SCHED_LINE_NO to SCHED_LINE_NBR */

SELECT DISTINCT D.BUSINESS_UNIT , D.DEMAND_SOURCE , D.SOURCE_BUS_UNIT , D.ORDER_NO , D.ORDER_INT_LINE_NO , D.SCHED_LINE_NBR , D.SETID_INV_ITEM , D.INV_ITEM_ID , D.DEMAND_LINE_NO , D.SHIP_ID , E.SHIP_ID_EST , %DatePart(D.SHIP_DTTM ) , D.UNIT_OF_MEASURE , D.UNIT_MEASURE_SHIP , D.UNIT_MEASURE_WT , E.UNIT_MEASURE_VOL , D.QTY_SHIPPED_CONV , D.QTY_SHIP_BASE , D.QTY_SHIPPED , D.UNIT_MEASURE_STD , %TimePart(D.SHIP_DTTM ) , D.DIRECT_INVOICING , D.BUSINESS_UNIT_BI , D.PRODUCT_ID , D.CURRENCY_CD FROM PS_SHIP_INF_FC_TAO D , PS_IN_DEMAND E WHERE D.BUSINESS_UNIT = E.BUSINESS_UNIT AND D.DEMAND_SOURCE = E.DEMAND_SOURCE AND D.SOURCE_BUS_UNIT = E.SOURCE_BUS_UNIT AND D.ORDER_NO = E.ORDER_NO AND D.ORDER_INT_LINE_NO = E.ORDER_INT_LINE_NO AND D.SCHED_LINE_NBR = E.SCHED_LINE_NBR AND D.DEMAND_LINE_NO = E.DEMAND_LINE_NO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUIN_NONVW

2 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
3 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
4 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
5 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
6 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
7 SETID_INV_ITEM Character(5) VARCHAR2(5) NOT NULL Inv Items SETID
8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
9 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
10 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
11 SHIP_ID_EST Character(10) VARCHAR2(10) NOT NULL Estimated Ship ID
12 SHIP_DATE Date(10) DATE Item Shipping Date
13 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
14 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure
15 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
16 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM
17 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
18 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base
19 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
20 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
21 SHIP_TIME Time(15) TIMESTAMP Ship Time
22 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing
23 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
24 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
25 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code