VCH_VAL_ADJ_VW5

(SQL View)
 Index Back

Voucher PO Distrib Line


SELECT A.BUSINESS_UNIT , A.RECEIVER_ID , C.RECV_LN_NBR , C.RECV_SHIP_SEQ_NBR , E.BUSINESS_UNIT , E.PO_ID , E.LINE_NBR , E.SCHED_NBR , E.DST_ACCT_TYPE , E.MISC_CHARGE_CODE , C.QTY_SH_ACCPT_VUOM , E.UNIT_PRICE_LC , E.UNIT_PRICE_LC , E.CURRENCY_CD , E.UNIT_OF_MEASURE , E.UNIT_OF_MEASURE , %Round(%DecMult(E.QTY_PO , E.UNIT_PRICE) , 3) , 0 , %Round(%DecDiv(%DecMult(E.ADJ_AMT, C.QTY_SH_ACCPT_VUOM), E.QTY_PO), 3) , 0 , E.MISC_PRORATE_FLG , E.LC_COMP_ALLOC , E.LC_COMP_ON_PO , E.X_VENDOR_SETID , E.X_VENDOR_ID FROM PS_RECV_HDR_FS A , PS_RECV_LN_SHIP_FS C , PS_PO_VAL_ADJ E WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.IN_PROCESS_FLG = 'N' AND (A.ERS_FLAG = 'N' OR A.ERS_FLAG = ' ') AND A.RECEIVER_ID = C.RECEIVER_ID AND C.RECV_SHIP_STATUS IN ('R','O','M','C') AND C.RECV_LN_MATCH_OPT = 'N' AND C.BUSINESS_UNIT_PO = E.BUSINESS_UNIT AND C.PO_ID = E.PO_ID AND C.LINE_NBR = E.LINE_NBR AND C.SCHED_NBR = E.SCHED_NBR AND C.MERCHANDISE_AMT_PO = 0 AND E.DST_ACCT_TYPE <> ' ' AND E.MISC_CHARGE_CODE <> ' ' AND 'DST' IN ( SELECT DST_ACCT_TYPE FROM PS_RECV_LN_DIST_FS WHERE A.BUSINESS_UNIT = BUSINESS_UNIT AND C.RECEIVER_ID = RECEIVER_ID AND C.RECV_LN_NBR = RECV_LN_NBR AND C.RECV_SHIP_SEQ_NBR = RECV_SHIP_SEQ_NBR AND BUSINESS_UNIT_PO = E.BUSINESS_UNIT AND PO_ID = E.PO_ID AND LINE_NBR = E.LINE_NBR AND SCHED_NBR = E.SCHED_NBR) AND E.MISC_CHARGE_CODE <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
3 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
4 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
5 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
6 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
7 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
8 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
9 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
10 MISC_CHARGE_CODE Character(10) VARCHAR2(10) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
11 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
12 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
13 UNIT_PRICE_CNVT Number(16,5) DECIMAL(15,5) NOT NULL Unit Price Converted
14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
15 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
16 UOM_VCHR Character(3) VARCHAR2(3) NOT NULL Unit Of Measure Voucher
17 BASE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents a transaction amount calculated and stored in the base currency of its associated General Ledger bus
18 MISC_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
19 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
20 PCT_ALLOC Number(3,0) SMALLINT NOT NULL Allocation Percentage
21 PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate
22 LC_COMP_ALLOC Character(3) VARCHAR2(3) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
MAT=Matl Value
QTY=Quantity
VOL=Volume
WT=Weight
23 LC_COMP_ON_PO Character(1) VARCHAR2(1) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement Indicates whether this Landed cost component is typically included on the Purchase order to the merchandise supplier
24 X_VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Supplier Set ID
25 X_VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Third Party Supplier