VCHR_TP_RC_L_VW

(SQL View)
 Index Back

Voucher Recv Line View


SELECT A.BUSINESS_UNIT , A.RECEIVER_ID , C.RECV_LN_NBR , C.RECV_SHIP_SEQ_NBR , C.BUSINESS_UNIT_PO , C.PO_ID , C.LINE_NBR , C.SCHED_NBR , E.ITM_SETID , C.INV_ITEM_ID , %Substring(C.DESCR254_MIXED,1,30) , C.RECEIPT_UM , C.PRICE_PO , C.QTY_SH_ACCPT_VUOM - F.QTY_MATCHED , C.MERCHANDISE_AMT - F.AMT_MATCHED , D.PRICE_PO , E.UNIT_OF_MEASURE , D.UNIT_PRC_TOL , D.PCT_UNIT_PRC_TOL , D.EXT_PRC_TOL , D.PCT_EXT_PRC_TOL , D.MATCH_LINE_OPT , C.RECEIPT_UM , C.QTY_SH_ACCPT_VUOM - F.QTY_MATCHED , E.WTHD_CD , E.WTHD_SW , D.DISTRIB_MTHD_FLG , C.CURRENCY_CD , C.RECV_SHIP_STATUS , C.RECV_SHIP_STATUS , C.SHIPTO_ID , D.VAT_USE_ID , D.VAT_TXN_TYPE_CD , D.TAX_CD_VAT , D.VAT_APPLICABILITY , D.SUT_APPLICABILITY , D.TAX_CD_SUT , D.SUT_EXCPTN_CERTIF , D.SUT_EXCPTN_TYPE FROM PS_RECV_HDR_FS A , PS_RECV_LN_SHIP_FS C , PS_PO_LINE_FS E , PS_PO_LINE_SHIP_FS D , PS_RECV_LN_SHP_MTH F WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.RECEIVER_ID = C.RECEIVER_ID AND A.IN_PROCESS_FLG = 'N' AND (A.ERS_FLAG = 'N' OR A.ERS_FLAG = ' ') AND C.RECV_SHIP_STATUS IN ('R','O','M','C') AND C.BUSINESS_UNIT_PO = E.BUSINESS_UNIT AND C.PO_ID = E.PO_ID AND C.LINE_NBR = E.LINE_NBR AND C.BUSINESS_UNIT_PO = D.BUSINESS_UNIT AND C.PO_ID = D.PO_ID AND C.LINE_NBR = D.LINE_NBR AND C.SCHED_NBR = D.SCHED_NBR AND C.BUSINESS_UNIT = F.BUSINESS_UNIT AND C.RECEIVER_ID = F.RECEIVER_ID AND C.RECV_LN_NBR = F.RECV_LN_NBR

# 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 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
10 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
12 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
13 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
14 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
15 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
16 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
17 UOM_PO Character(3) VARCHAR2(3) NOT NULL Unit Of Measure PO
18 UNIT_PRC_TOL Number(14,5) DECIMAL(13,5) NOT NULL Unit Price Tolerance
19 PCT_UNIT_PRC_TOL Number(6,2) DECIMAL(5,2) NOT NULL % Unit Price Tolerance
20 EXT_PRC_TOL Number(14,5) DECIMAL(13,5) NOT NULL Ext Price Tolerance
21 PCT_EXT_PRC_TOL Number(6,2) DECIMAL(5,2) NOT NULL % Ext Price Tolerance
22 MATCH_LINE_OPT Character(1) VARCHAR2(1) NOT NULL Match Line Option
E=ERS
F=Full Match
N=Don't Match
23 UOM_RECV Character(3) VARCHAR2(3) NOT NULL Unit Of Measure
24 QTY_SH_ACCPT_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Accept QTY in Supplier UOM
25 WTHD_CD Character(5) VARCHAR2(5) NOT NULL Withholding Code
26 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
B=Global and 1099
G=Global
T=1099
27 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
A=Amount
Q=Quantity
28 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
29 RECV_LN_STATUS Character(1) VARCHAR2(1) NOT NULL Receiver Line Status
C=Closed Item
H=Hold Item
I=In Inspection
M=Moved to Destination
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled
30 RECV_SHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Schedule Status
C=Closed
H=Hold
O=Open
R=Received
X=Canceled
31 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
32 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type
33 VAT_TXN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
34 TAX_CD_VAT Character(8) VARCHAR2(8) NOT NULL Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
35 VAT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated
36 SUT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Applicability
D=Direct Pay
E=Item is Exempt
S=Sales Tax Applicable
U=Use Tax Applicable
X=Purchaser Is Exonerated
37 TAX_CD_SUT Character(8) VARCHAR2(8) NOT NULL Tax Code - Sales and Use Tax
38 SUT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Sales/Use Tax Exception Certif
39 SUT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Exception Type
D=Direct Pay
E=Exempt/Exonerated
N=None