RECV_VCHR_MTCH

(SQL Table)
Index Back

Receivers Matched to a Voucher

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL 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_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
6 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
7 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
8 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
9 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
10 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
11 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
12 UOM_VCHR Character(3) VARCHAR2(3) NOT NULL Unit Of Measure Voucher
13 UOM_PO Character(3) VARCHAR2(3) NOT NULL Unit Of Measure PO
14 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
15 TXN_CURRENCY_PO Character(3) VARCHAR2(3) NOT NULL Transaction Currency
16 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
17 QTY_VCHR_CNVT Signed Number(17,4) DECIMAL(15,4) NOT NULL Voucher Qty Converted
18 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
19 UNIT_PRICE_CNVT Number(16,5) DECIMAL(15,5) NOT NULL Unit Price Converted
20 MERCH_AMT_VCHR Signed Number(28,3) DECIMAL(26,3) NOT NULL Voucher Merchandise Amount
21 MERCH_AMT_VCHR_B Signed Number(28,3) DECIMAL(26,3) NOT NULL Voucher Merchandise Amt base
22 QTY_RECV_APPLIED Signed Number(17,4) DECIMAL(15,4) NOT NULL Receiver line ship quantity applied to voucher line in PO unit of measure
23 MERCH_AMT_RECVAPPL Signed Number(28,3) DECIMAL(26,3) NOT NULL Receiver line ship merchandise amt applied to voucher line in PO currency
24 QTY_SH_ACCPT_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Accept QTY in Supplier UOM
25 MERCH_AMT_RECV Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amount Received
26 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
27 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
28 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
29 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
30 LC_EXTRCT_STATUS Character(1) VARCHAR2(1) NOT NULL Landed Cost Extract Status

Default Value: N