VCHR_MTCH_WS5

(SQL Table)
Index Back

Vchr Recv 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_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
4 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
5 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
6 RECEIPT_DT Date(10) DATE Received Date
7 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
8 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
9 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
10 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
11 PACKSLIP_NO Character(22) VARCHAR2(22) NOT NULL Packing Slip Number
12 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
13 PO_DT Date(10) DATE Date
14 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
15 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
16 USER_HDR_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
17 CUSTOM_C100_A1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
18 CUSTOM_C100_A2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
19 CUSTOM_C100_A3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
20 CUSTOM_C100_A4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
21 CUSTOM_DATE_A Date(10) DATE Custom Date
22 CUSTOM_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Character 2
23 PO_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
24 PRIMARY_UNIT Character(1) VARCHAR2(1) NOT NULL Primary Unit
N=No
Y=Yes
25 UNIT_ALLOC_QTY Number(16,4) DECIMAL(15,4) NOT NULL Unit Allocation Qty
26 UNIT_ALLOC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Unit Allocation Amt