VCHR_MTCH_WS3

(SQL Table)
Index Back

Vchr PO WorkSheet Hdr Scroll

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
4 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
5 PO_DT Date(10) DATE Date
6 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
7 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
8 PO_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL PO Total
9 PO_LINE_CNT Number(5,0) INTEGER NOT NULL PO Line Count
10 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

Default Value: VOUCHER.TXN_CURRENCY_CD

11 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
12 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
13 USER_HDR_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
14 CUSTOM_C100_A1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
15 CUSTOM_C100_A2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
16 CUSTOM_C100_A3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
17 CUSTOM_C100_A4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
18 CUSTOM_DATE_A Date(10) DATE Custom Date
19 CUSTOM_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Character 2
20 PO_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
21 PRIMARY_UNIT Character(1) VARCHAR2(1) NOT NULL Primary Unit
N=No
Y=Yes
22 UNIT_ALLOC_QTY Number(16,4) DECIMAL(15,4) NOT NULL Unit Allocation Qty
23 UNIT_ALLOC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Unit Allocation Amt