REQ_LN_SHP_VW2

(SQL View)
 Index Back

Req Shipping View

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 , A.SCHED_NBR , A.DUE_DT , A.DUE_TIME , A.SHIPTO_SETID , A.SHIPTO_ID , A.QTY_REQ , A.MERCHANDISE_AMT , A.REVISION , A.DISTRIB_MTHD_FLG , A.PRICE_REQ , SUM(B.QTY_OPEN) , SUM(B.AMT_OPEN) , A.BAL_STATUS , A.QTY_REQ_STD , SUM(B.QTY_OPEN_STD) , A.UNIT_MEASURE_STD , A.CURRENCY_CD , A.BUSINESS_UNIT_OM FROM PS_REQ_LINE_SHIP A , PS_REQ_LN_DISTRIB B , PS_REQ_HDR C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.REQ_ID = B.REQ_ID AND A.LINE_NBR = B.LINE_NBR AND A.SCHED_NBR = B.SCHED_NBR AND A.BAL_STATUS = 'I' AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.REQ_ID = A.REQ_ID AND C.HOLD_STATUS = 'N' AND C.BUDGET_HDR_STATUS = 'V' AND A.BAL_STATUS = 'I' AND B.KK_CLOSE_FLAG <> 'Y' GROUP BY A.BUSINESS_UNIT, A.REQ_ID, A.LINE_NBR, A.SCHED_NBR, A.DUE_DT, A.DUE_TIME, A.SHIPTO_SETID, A.SHIPTO_ID, A.QTY_REQ, A.MERCHANDISE_AMT, A.DISTRIB_MTHD_FLG, A.PRICE_REQ, A.BAL_STATUS, A.QTY_REQ_STD, A.UNIT_MEASURE_STD, A.CURRENCY_CD, A.REVISION, A.BUSINESS_UNIT_OM

# 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

Default Value: NEXT

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

Default Value: 1

4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

Default Value: 1

5 DUE_DT Date(10) DATE NOT NULL 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.
6 DUE_TIME Time(15) TIMESTAMP Due Time
7 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
8 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: SHIPTO_TBL

9 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
10 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
11 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
12 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
A=Amount
Q=Quantity

Default Value: Q

13 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
14 QTY_OPEN Number(16,4) DECIMAL(15,4) NOT NULL Open Quantity
15 AMT_OPEN Signed Number(28,3) DECIMAL(26,3) NOT NULL Open Amount
16 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
17 QTY_REQ_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Requested Stand. UOM
18 QTY_OPEN_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Open Standard UOM
19 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
20 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
21 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit