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. |