VOUCHER_TMP

(SQL Table)
Index Back

# 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 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
4 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
5 PACKSLIP_NO Character(22) VARCHAR2(22) NOT NULL Packing Slip Number
6 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
7 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
8 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
9 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
10 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
11 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
12 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
13 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
14 MATCH_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Match Line Status
E=Match Error
M=Matched
N=Not Matched
15 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
16 UOM_VCHR Character(3) VARCHAR2(3) NOT NULL Unit Of Measure Voucher
17 UNIT_PRICE_VCHR Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
18 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
19 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
20 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
21 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
22 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
23 INVOICE_DT Date(10) DATE Invoice Date