PRCR_LST_AAP_VW

(SQL View)
 Index Back

Procurement AP List View


SELECT DISTINCT T.REPORT_ENTITY ,L.ITM_SETID ,L.INV_ITEM_ID ,H.VENDOR_SETID ,H.VENDOR_ID ,H.BUSINESS_UNIT ,H.VOUCHER_ID ,L.VOUCHER_LINE_NUM ,H.INVOICE_ID ,H.INVOICE_DT ,H.DUE_DT ,L.BUSINESS_UNIT_PO ,L.PO_ID ,L.LINE_NBR ,L.SCHED_NBR ,L.DESCR ,L.UNIT_OF_MEASURE ,L.MERCHANDISE_AMT ,L.QTY_VCHR ,L.UNIT_PRICE ,L.CURRENCY_CD ,L.BUSINESS_UNIT_RECV ,L.RECEIVER_ID ,L.RECV_LN_NBR ,L.RECV_SHIP_SEQ_NBR ,V.VENDOR_NAME_SHORT ,V.NAME1 FROM PS_VOUCHER_LINE L , PS_VOUCHER H , PS_VENDOR V , PS_PRCR_ENTITY_BU E , PS_PRCR_ENTITY_TBL T , PS_BUS_UNIT_TBL_AP BU WHERE ( (T.INCLUDE_ALL_AP_BU = 'Y' AND BU.BUSINESS_UNIT = H.BUSINESS_UNIT ) OR (T.INCLUDE_ALL_AP_BU = 'N' AND T.REPORT_ENTITY = E.REPORT_ENTITY AND E.UNIT_TYPE = 'A' AND E.BUSINESS_UNIT = H.BUSINESS_UNIT ) ) AND H.VENDOR_SETID = V.SETID AND H.VENDOR_ID = V.VENDOR_ID AND H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.VOUCHER_ID = L.VOUCHER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REPORT_ENTITY Character(5) VARCHAR2(5) NOT NULL Reporting Entity ID
2 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
8 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
9 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
10 INVOICE_DT Date(10) DATE Invoice Date
11 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.
12 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
13 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
14 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
15 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
16 ITM_DESCR Character(30) VARCHAR2(30) NOT NULL Item Description
17 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
18 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
19 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
20 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
21 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
22 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
23 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
24 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
25 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
26 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
27 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1