REQ_PO_LN_S

(SQL View)
Index Back

Selector Order By Item Descr

Date Initials Issue Description 092107 dh F-AHAYT-95051 PRICE_REQ for ePro change from number to Sign to allow negative

SELECT A.BUSINESS_UNIT , A.REQ_ID , A.LINE_NBR , C.SCHED_NBR , B.REQ_DT , B.REQUESTOR_ID , B.APPROVAL_DT , C.QTY_OPEN + S.QTY_REQ , A.UNIT_OF_MEASURE , C.PRICE_REQ , C.AMT_OPEN , A.ITM_SETID , A.INV_ITEM_ID , A.DESCR254_MIXED , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.ITM_ID_VNDR , A.VNDR_CATALOG_ID , A.BUYER_ID , A.CATEGORY_ID , A.MFG_ID , A.MFG_ITM_ID , A.INSPECT_CD , S.QTY_REQ , A.UNIT_OF_MEASURE , A.PCT_UNIT_PRC_TOL , A.UNIT_PRC_TOL , A.RFQ_IND , A.IN_PROCESS_FLG , A.SOURCE_STATUS , C.BAL_STATUS , B.BUDGET_HDR_STATUS , A.OVERRIDE_SUGG_VNDR , A.INVENTORY_SRC_FLG , B.ORIGIN , A.CONSOLIDATE_FLG , A.CURRENCY_CD , A.CURRENCY_CD_BASE , A.QTY_REQ_STD , A.UNIT_MEASURE_STD , A.CONFIG_CODE , A.CP_TEMPLATE_ID , A.SOURCE_DATE , B.OPRID_ENTERED_BY , C.SHIPTO_SETID , C.SHIPTO_ID , D.SUT_BASE_ID , D.DUE_DT , A.REPLEN_OPT , S.PO_STG_TYPE , S.PO_STG_ID , S.REVISION FROM PS_REQ_LINE A , PS_REQ_HDR B , PS_REQ_LN_SHP_VW2 C , PS_REQ_LINE_SHIP D , PS_PO_ITM_STG S WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND D.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.REQ_ID = B.REQ_ID AND A.REQ_ID = C.REQ_ID AND A.LINE_NBR = C.LINE_NBR AND D.REQ_ID = C.REQ_ID AND D.LINE_NBR = C.LINE_NBR AND D.SCHED_NBR = C.SCHED_NBR AND D.BUSINESS_UNIT = S.BUSINESS_UNIT AND D.REQ_ID = S.REQ_ID AND D.LINE_NBR = S.REQ_LINE_NBR AND D.SCHED_NBR = S.REQ_SCHED_NBR AND S.PROCESS_INSTANCE = 0 AND S.STAGE_STATUS = 'S' AND S.PO_ID = 'UNASSIGNED'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
3 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
4 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
5 REQ_DT Date(10) DATE Requisition Date
6 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
7 REQ_APPROVAL_DT Date(10) DATE Requisition Approval Date
8 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
9 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
10 PRICE_REQ Signed Number(17,5) DECIMAL(15,5) NOT NULL Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative
11 AMT_OPEN Signed Number(28,3) DECIMAL(26,3) NOT NULL Open Amount
12 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
13 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
14 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
15 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
16 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: %EDITTABLE5

17 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: VNDR_LOC_REQ_VW

18 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
19 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
20 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
21 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
22 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
23 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
24 INSPECT_CD Character(1) VARCHAR2(1) NOT NULL Inspection Required
N=No
Y=Yes
25 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
26 UNIT_MEASURE_ORD Character(3) VARCHAR2(3) NOT NULL Ordering UOM

Prompt Table: %EDITTABLE6

27 PCT_UNIT_PRC_TOL Number(6,2) DECIMAL(5,2) NOT NULL % Unit Price Tolerance
28 UNIT_PRC_TOL Number(14,5) DECIMAL(13,5) NOT NULL Unit Price Tolerance
29 RFQ_IND Character(1) VARCHAR2(1) NOT NULL RFQ Required
N=No
Y=Yes
30 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
31 SOURCE_STATUS Character(1) VARCHAR2(1) NOT NULL AutoSource Status
A=Available
C=Sourcing Complete
E=Non-Price Error
I=Sourcing In Process
N=Non-Price Error
P=Pricing Error
32 BAL_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not the control totals for a deposit match the entered totals. A deposit is considered "balanced" when the two sets of totals are equal.
I=Balanced
O=Not Balanced
33 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
34 OVERRIDE_SUGG_VNDR Character(1) VARCHAR2(1) NOT NULL Override Suggested Vendor
35 INVENTORY_SRC_FLG Character(1) VARCHAR2(1) NOT NULL Inventory Source Flag
36 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
37 CONSOLIDATE_FLG Character(1) VARCHAR2(1) NOT NULL Consolidate with other Reqs
N=No
Y=Yes
38 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
39 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
40 QTY_REQ_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Requested Stand. UOM
41 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
42 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
43 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field
44 SOURCE_DATE Date(10) DATE Source Date
45 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
46 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
47 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
48 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination
49 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.
50 REPLEN_OPT Character(2) VARCHAR2(2) NOT NULL Replenish Code
01=Standard
02=Stockless
51 PO_STG_TYPE Character(1) VARCHAR2(1) NOT NULL Used in conjunction with PO_STG_ID to make a unique key on the stage tables.
O=Other
R=Requisition
52 PO_STG_ID Character(10) VARCHAR2(10) NOT NULL Uniqye key to the PO Staging table
53 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label