PO_SSRECVCHR_VW

(SQL View)
 Index Back

SELECT DISTINCT A.BUSINESS_UNIT , A.VOUCHER_ID , B.BUSINESS_UNIT_RECV , B.RECEIVER_ID , B.RECV_LN_NBR , B.RECV_SHIP_SEQ_NBR , B.DESCR , B.STATISTIC_AMOUNT , B.UNIT_OF_MEASURE , B.UNIT_PRICE , B.MERCHANDISE_AMT , A.INVOICE_ID , A.INVOICE_DT , B.TXN_CURRENCY_CD FROM PS_VCHR_FS A , PS_VCHR_LN_FS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.ENTRY_STATUS = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
4 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
5 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
6 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 STATISTIC_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
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 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
11 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
12 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
13 INVOICE_DT Date(10) DATE Invoice Date
14 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency