REQ_LN_DIST_VW1

(SQL View)
Index Back

Req Distr Summ by schedule


Select business_unit, req_id, line_nbr, sched_nbr, sum(qty_req), sum(merchandise_amt), sum(qty_open), sum(amt_open), currency_cd, currency_cd_base, sum(amt_open_bse), sum(merch_amt_bse), unit_measure_std, sum(qty_req_std), sum(qty_open_std) from PS_REQ_LN_DISTRIB group by business_unit, req_id, line_nbr, sched_nbr, currency_cd, currency_cd_base, 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 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
6 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
7 QTY_OPEN Number(16,4) DECIMAL(15,4) NOT NULL Open Quantity
8 AMT_OPEN Signed Number(28,3) DECIMAL(26,3) NOT NULL Open Amount
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
10 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
11 AMT_OPEN_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Open Base
12 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
13 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
14 QTY_REQ_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Requested Stand. UOM
15 QTY_OPEN_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Open Standard UOM