VCHR_RCV_LN_VW2

(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 , C.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 , C.PRICE_PO , C.RECEIPT_UM , 0 , 0 , 0 , 0 , C.MATCH_LINE_FLG , C.RECEIPT_UM , C.QTY_SH_ACCPT_VUOM - F.QTY_MATCHED , ' ' , ' ' , C.DISTRIB_MTHD_FLG , C.CURRENCY_CD , C.RECV_SHIP_STATUS , C.RECV_SHIP_STATUS , C.SHIPTO_ID , C.SHIPTO_ID , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , A.VENDOR_ID , A.VNDR_LOC , %subrec(PUR_USR_HDR_SBR, A) , %subrec(PUR_USR_LIN_SBR, C) , %subrec(PUR_USR_SHP_SBR, C) , C.CATEGORY_ID , A.FREIGHT_TERMS , C.BILL_OF_LADING , C.PRO_NUMBER , C.PACKSLIP_NO , C.ITM_ID_VNDR , C.MFG_ITM_ID , C.AMT_ONLY_FLG , A.MATCH_CNTRL_ID , C.DESCR254_MIXED , C.MFG_ID , C.UPN_TYPE_CD , C.UPN_ID FROM PS_RECV_HDR_FS A , PS_RCV_L_SH_PRO_VW C , 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.RECV_LN_MATCH_OPT IN ('N', 'P') AND C.QTY_SH_ACCPT_VUOM <> 0 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 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination
33 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type
34 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.
35 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.
36 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
37 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
38 TAX_CD_SUT Character(8) VARCHAR2(8) NOT NULL Tax Code - Sales and Use Tax
39 SUT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Sales/Use Tax Exception Certif
40 SUT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Exception Type
D=Direct Pay
E=Exempt/Exonerated
N=None
41 ULTIMATE_USE_CD Character(8) VARCHAR2(8) NOT NULL Ultimate Use Code
42 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
43 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
44 USER_HDR_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
45 CUSTOM_C100_A1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
46 CUSTOM_C100_A2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
47 CUSTOM_C100_A3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
48 CUSTOM_C100_A4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
49 CUSTOM_DATE_A Date(10) DATE Custom Date
50 CUSTOM_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Character 2
51 USER_LINE_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
52 CUSTOM_C100_B1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
53 CUSTOM_C100_B2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
54 CUSTOM_C100_B3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
55 CUSTOM_C100_B4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
56 CUSTOM_DATE_B Date(10) DATE Custom Date
57 CUSTOM_C1_B Character(1) VARCHAR2(1) NOT NULL Custom Character 2
58 USER_SCHED_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
59 CUSTOM_C100_C1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
60 CUSTOM_C100_C2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
61 CUSTOM_C100_C3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
62 CUSTOM_DATE_C1 Date(10) DATE Custom Date 1
63 CUSTOM_DATE_C2 Date(10) DATE Custom Date 2
64 CUSTOM_C1_C Character(1) VARCHAR2(1) NOT NULL Custom Character 2
65 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
66 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
67 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
68 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
69 PACKSLIP_NO Character(22) VARCHAR2(22) NOT NULL Packing Slip Number
70 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
71 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
72 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
N=No
Y=Yes
73 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
74 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
75 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
76 UPN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Universal Product Number Format Type
77 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number