REQ_LN_SHP_VW_T

(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.SHIPTO_SETID, A.SHIPTO_ID, A.QTY_REQ, A.MERCHANDISE_AMT, A.DISTRIB_MTHD_FLG, A.PRICE_REQ, sum(B.QTY_OPEN), sum(B.AMT_OPEN), A.BAL_STATUS, A.BUSINESS_UNIT_OM, A.ORDER_NO, A.ORDER_INT_LINE_NO, A.SCHED_LINE_NBR, A.SHIP_TO_CUST_ID, A.CURRENCY_CD, A.CURRENCY_CD_BASE, A.PRICE_REQ_BSE, A.MERCH_AMT_BSE, A.QTY_REQ_STD, sum(B.AMT_OPEN_BSE), sum(B.QTY_OPEN_STD), A.UNIT_MEASURE_STD from PS_REQ_LINE_SHIP A, PS_REQ_LN_DISTRIB B 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' group by A.BUSINESS_UNIT, A.REQ_ID, A.LINE_NBR, A.SCHED_NBR, A.DUE_DT, A.SHIPTO_SETID, A.SHIPTO_ID, A.QTY_REQ, A.MERCHANDISE_AMT, A.DISTRIB_MTHD_FLG, A.PRICE_REQ, A.BAL_STATUS, A.BUSINESS_UNIT_OM, A.ORDER_NO, A.ORDER_INT_LINE_NO, A.SCHED_LINE_NBR, A.SHIP_TO_CUST_ID, A.CURRENCY_CD, A.CURRENCY_CD_BASE, A.PRICE_REQ_BSE, A.MERCH_AMT_BSE, A.QTY_REQ_STD, A.UNIT_MEASURE_STD

# 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 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
7 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: SHIPTO_TBL

8 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
9 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
10 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
A=Amount
Q=Quantity

Default Value: Q

11 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
12 QTY_OPEN Number(16,4) DECIMAL(15,4) NOT NULL Open Quantity
13 AMT_OPEN Signed Number(28,3) DECIMAL(26,3) NOT NULL Open Amount
14 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
15 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
16 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
17 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
18 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
19 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
20 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
21 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
22 PRICE_REQ_BSE 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
23 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
24 QTY_REQ_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Requested Stand. UOM
25 AMT_OPEN_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Open Base
26 QTY_OPEN_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Open Standard UOM
27 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure