PO_SRC_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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
6 PRICE_SETID Character(5) VARCHAR2(5) NOT NULL Price From Vendor SetID
7 PRICE_VENDOR Character(10) VARCHAR2(10) NOT NULL Price Vendor ID
8 PRICE_LOC Character(10) VARCHAR2(10) NOT NULL Price from Location
9 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
10 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
12 DECIMAL_POSITIONS Number(2,0) SMALLINT NOT NULL Decimal Positions
13 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
14 ERS_ACTION Character(1) VARCHAR2(1) NOT NULL ERS Action
N=No
Y=Yes
15 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
16 FREIGHT_TERMS_BU Character(10) VARCHAR2(10) NOT NULL BU default Freight Terms
17 WTHD_CD Character(5) VARCHAR2(5) NOT NULL Withholding Code
18 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
B=Global and 1099
G=Global
T=1099
19 MATCH_CNTRL_BU Character(10) VARCHAR2(10) NOT NULL BU default Match Control ID
20 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
21 MATCH_OPT Character(1) VARCHAR2(1) NOT NULL Requires Matching
22 MATCH_OPT_BU Character(1) VARCHAR2(1) NOT NULL BU default Match Option
23 MATCH_SETID Character(5) VARCHAR2(5) NOT NULL Setid ID for Match Rules
24 MATCH_TYPE Character(3) VARCHAR2(3) NOT NULL Match Type Field
E==
ERS=Evaluated Receipts
L=LIKE
MCH=Standard Matching
25 PAY_TRM_BSE_DT_DBU Character(1) VARCHAR2(1) NOT NULL Payment Terms Basis Date
26 PAY_TRM_BSE_DT_OPT Character(1) VARCHAR2(1) NOT NULL Payment Terms Basis Date Type
A=Acct Date
C=Doc Date
I=Inv Date
R=Recpt Date
S=Ship Date
U=User Date
27 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.
28 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
29 SHIP_TYPE_ID_BU Character(10) VARCHAR2(10) NOT NULL BU default Ship Type ID
30 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type
31 VAT_USE_ID_BU Character(6) VARCHAR2(6) NOT NULL VAT Use Type
32 VAT_TXN_TYPE_BU Character(4) VARCHAR2(4) NOT NULL VAT Transaction Type
33 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.