WM_WO_INV_VW

(SQL View)
 Index Back

Work Mgmt Procurement Schedule

Work Order Management Procurement Schedule

SELECT a.BUSINESS_UNIT , a.WO_ID , a.WO_TASK_ID , a.RES_LN_NBR , a.RQMT_LN_NBR , a.BUSINESS_UNIT_IN , a.BUSINESS_UNIT_GL , a.ITM_SETID , a.INV_ITEM_ID , a.DESCR254_MIXED , a.UNIT_OF_MEASURE , a.UNIT_MEASURE_STD , a.QTY_REQUIRED , a.QTY_REQUIRED_BASE , a.WO_DELIVERY_FLAG , a.WO_DELIVERY_INST , a.EST_UNIT_COST , a.EST_COST_MATPO , a.SUPPLIER_REFERENCE , a.CURRENCY_CD , a.QTY_SCHEDULED , a.USED_QTY , a.WO_COMMIT_FLAG , a.PROCURE_STATUS , a.PROCURE_QTY , a.MAX_DISTRIB_LINE , a.SCHED_COST_MAT , a.ACTL_COST_MAT , a.PEG_STATUS FROM PS_WM_WO_SCHED_MAT a , PS_MASTER_ITEM_TBL b WHERE a.INV_ITEM_ID = b.INV_ITEM_ID AND a.ITM_SETID = b.SETID AND b.INVENTORY_ITEM = 'Y'

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

Default Value: OPR_DEF_TBL_FS.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.

Default Value: 1

5 RQMT_LN_NBR Number(5,0) INTEGER NOT NULL Requirement Line Number
6 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
7 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
8 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE3

10 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
11 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

12 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure

Default Value: MASTER_ITEM_TBL.UNIT_MEASURE_STD

13 QTY_REQUIRED Signed Number(17,4) DECIMAL(15,4) NOT NULL Work Order quantity required
14 QTY_REQUIRED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Work Order quantity required base
15 WO_DELIVERY_FLAG Character(1) VARCHAR2(1) NOT NULL Flag used by Work Order parts list processing to signify special delivery instructions if needed

Y/N Table Edit

Default Value: N

16 WO_DELIVERY_INST Character(254) VARCHAR2(254) NOT NULL Delivery instructions for work order parts list
17 EST_UNIT_COST Number(21,5) DECIMAL(20,5) NOT NULL Estimated unit cost
18 EST_COST_MATPO Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated cost for a material or Procure resource row in Work Management. This field will be used in the WM_PART_LST_SBR and used in the Requirement and Schedule record structures for Materials and Procured goods and services for a Work Order.
19 SUPPLIER_REFERENCE Character(20) VARCHAR2(20) NOT NULL Supplier Reference
20 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: BUS_UNIT_TBL_WM.BASE_CURRENCY

21 QTY_SCHEDULED Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Scheduled
22 USED_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Work Order Management Used quantity.
23 WO_COMMIT_FLAG Character(1) VARCHAR2(1) NOT NULL Work Order Management Commit Flag. This flag handles WO commitments against PS Inventory
1=Not Committed
2=In Process
3=Committed
24 PROCURE_STATUS Character(2) VARCHAR2(2) NOT NULL Indicates whether or not a Labor or a Tools resource in Maintenance Management is being procured.
1=No Procurement
2=Being Procured

Default Value: 1

25 PROCURE_QTY Number(12,4) DECIMAL(11,4) NOT NULL Procurement quantity for inventoried items in Work Order Management
26 MAX_DISTRIB_LINE Number(5,0) INTEGER NOT NULL Highest Distribution Line
27 SCHED_COST_MAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost of Scheduled Materials
28 ACTL_COST_MAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Cost
29 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged

Default Value: 40