WM_WO_PEGITM_VW

(SQL View)
 Index Back

Work Order Peg Item View

Work Order Peg Item View - join of requisitions, purchase orders pegged to work order procurement items

SELECT A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , A.RES_LN_NBR , A.RSRC_TYPE , A.INV_ITEM_ID , A.DESCR254_MIXED , A.QTY_REQUIRED , A.UNIT_OF_MEASURE , A.DUE_DT , A.WO_DELIVERY_INST , A.EST_UNIT_COST , A.SCHED_COST_PO , A.CURRENCY_CD , A.BUSINESS_UNIT_PO , '100' , A.REQ_ID AS ORDER_NO , A.LINE_NBR , A.SCHED_NBR , A.DISTRIB_LINE_NUM , A.PEG_LINE_KEY , A.QTY_AVAILABLE , A.QTY_PEGGED , A.QTY_COMPLETE , A.QTY_ORDER , A.SCHED_DATE , A.SCHED_TIME , A.PEG_STATUS FROM PS_WM_WO_REQHSH_VW A UNION SELECT B.BUSINESS_UNIT , B.WO_ID , B.WO_TASK_ID , B.RES_LN_NBR , B.RSRC_TYPE , B.INV_ITEM_ID , B.DESCR254_MIXED , B.QTY_REQUIRED , B.UNIT_OF_MEASURE , B.DUE_DT , B.WO_DELIVERY_INST , B.EST_UNIT_COST , B.SCHED_COST_PO , B.CURRENCY_CD , B.BUSINESS_UNIT_PO , '010' , B.PO_ID AS ORDER_NO , B.LINE_NBR , B.SCHED_NBR , B.DISTRIB_LINE_NUM , B.PEG_LINE_KEY , B.QTY_AVAILABLE , B.QTY_PEGGED , B.QTY_COMPLETE , B.QTY_ORDER , B.SCHED_DATE , B.SCHED_TIME , B.PEG_STATUS FROM PS_WM_WO_POHASH_VW B

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
3 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
4 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.
5 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
1=Labor
2=Tools
3=Material
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE3

7 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
8 QTY_REQUIRED Signed Number(17,4) DECIMAL(15,4) NOT NULL Work Order quantity required
9 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Default Value: MASTER_ITEM_TBL.UNIT_MEASURE_STD

Prompt Table: %EDIT_UOM

10 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
11 WO_DELIVERY_INST Character(254) VARCHAR2(254) NOT NULL Delivery instructions for work order parts list
12 EST_UNIT_COST Number(21,5) DECIMAL(20,5) NOT NULL Estimated unit cost
13 SCHED_COST_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL This field will be used to store the Scheduled cost of Procurement
14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: BUS_UNIT_TBL_WM.BASE_CURRENCY

15 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
16 PEG_ORDER_TYPE Character(4) VARCHAR2(4) NOT NULL Used by Pegging Maintenance/Inquiry
010=Purchase
020=Production
030=Transfer Demand
035=Transfer Supply
070=Stock Request
090=Sales Order
100=Requisition
110=WO Inventory
115=WO Non-Inventory
17 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
18 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
19 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
20 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distrib
21 PEG_LINE_KEY Character(30) VARCHAR2(30) NOT NULL Used to Store the concatenation of Line, Demand, Sched, Kit, etc in 1 field.
22 QTY_AVAILABLE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Available
23 QTY_PEGGED Signed Number(17,4) DECIMAL(15,4) NOT NULL 06/16/04 EGS: Created.
24 QTY_COMPLETE Number(16,4) DECIMAL(15,4) NOT NULL Quantity Complete
25 QTY_ORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL 06/21/04 EGS: Created
26 SCHED_DATE Date(10) DATE Schedule Date
27 SCHED_TIME Time(15) TIMESTAMP Schedule Time
28 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged