PO_POB_TMP_VNDR

(SQL Table)
Index Back

Sourcing Temp Supplier

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 PROC_INST_POCALC Number(10,0) DECIMAL(10) NOT NULL POCALC Process Instance
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
6 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
7 PRICE_SETID Character(5) VARCHAR2(5) NOT NULL Price From Vendor SetID
8 PRICE_VENDOR Character(10) VARCHAR2(10) NOT NULL Price Vendor ID
9 PRICE_LOC Character(10) VARCHAR2(10) NOT NULL Price from Location
10 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
11 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
13 DECIMAL_POSITIONS Number(2,0) SMALLINT NOT NULL Decimal Positions
14 DISP_METHOD Character(3) VARCHAR2(3) NOT NULL Dispatch Method
EDX=Electronic Document Exchange
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print
15 ERS_ACTION Character(1) VARCHAR2(1) NOT NULL ERS Action
N=No
Y=Yes
16 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
17 FREIGHT_TERMS_BU Character(10) VARCHAR2(10) NOT NULL BU default Freight Terms
18 WTHD_CD Character(5) VARCHAR2(5) NOT NULL Withholding Code
19 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
B=Global and 1099
G=Global
T=1099
20 MATCH_CNTRL_BU Character(10) VARCHAR2(10) NOT NULL BU default Match Control ID
21 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
22 MATCH_OPT Character(1) VARCHAR2(1) NOT NULL Requires Matching
23 MATCH_OPT_BU Character(1) VARCHAR2(1) NOT NULL BU default Match Option
24 MATCH_SETID Character(5) VARCHAR2(5) NOT NULL Setid ID for Match Rules
25 MATCH_TYPE Character(3) VARCHAR2(3) NOT NULL Match Type Field
E==
ERS=Evaluated Receipts
L=LIKE
MCH=Standard Matching
26 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.
27 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
28 SHIP_TYPE_ID_BU Character(10) VARCHAR2(10) NOT NULL BU default Ship Type ID
29 VAT_TXN_TYPE_BU Character(4) VARCHAR2(4) NOT NULL VAT Transaction Type
30 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.