| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
VENDOR_SIC_VW1
|
| 2 |
PV_MS_SUP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Linked Supplier Type
1=MarketPlace Supplier
2=Cohera Supplier
3=Catalog Management Supplier
4=Direct Connect Supplier
5=Oracle Network Supplier
|
| 3 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR_SIC_VW1
|
| 4 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
VNDR_LOC_SBI_VW
|
| 5 |
PV_MS_SUP_MPID |
Character(50) |
VARCHAR2(50) NOT NULL |
e
|
| 6 |
PV_MS_SUP_TP_SNAME |
Character(25) |
VARCHAR2(25) NOT NULL |
Supplier TP Short Name
|
| 7 |
PV_MS_SUP_TP_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Linked Supplier Name
|
| 8 |
PV_MS_BUY_ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Buyer Account Code
|
| 9 |
EOTP_PARTNERID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Partner ID
|
| 10 |
PV_EDX_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Application Message Node Name. Name of the Application Message Node Definition.
Prompt Table:
PV_EDX_TYPE
|
| 11 |
PV_PO_NODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Message Node Name. Name of the Application Message Node Definition.
Prompt Table:
PSMSGNODEDEFN
|
| 12 |
PV_DC_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Application Message Node Name. Name of the Application Message Node Definition.
Prompt Table:
PV_DC_TYPE
|
| 13 |
PV_DC_NODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Message Node Name. Name of the Application Message Node Definition.
Prompt Table:
PSMSGNODEDEFN
|
| 14 |
PV_MS_SUP_MPTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifier Type
1=DUNS Number
2=Global Location Number
3=Miscellaneous
4=Telephone Number
5=US Federal Tax Identifier
|
| 15 |
PV_TPO_NODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Transparent Punchout Node
Prompt Table:
PSMSGNODEDEFN
|
| 16 |
PV_ACTIVE_MKT |
Character(1) |
VARCHAR2(1) NOT NULL |
Linked supplier active marketplace flag
Y/N Table Edit
Default Value: N
|
| 17 |
ATT_FTPSRV_LOGIN |
Character(24) |
VARCHAR2(24) NOT NULL |
Login name for attachment ftp servers
|
| 18 |
ATT_FTPSRV_PASSWD |
Character(254) |
VARCHAR2(254) NOT NULL |
Password for attachment ftp servers
|
| 19 |
ATT_SRV_NAME |
Character(254) |
VARCHAR2(254) NOT NULL |
Name of attachment server, if it is an ftp server; name of the database record which holds attached files, if attachments are to be stored in the database
|
| 20 |
SERVER_PATH |
Character(254) |
VARCHAR2(254) NOT NULL |
For attached files already uploaded to an ftp server, the path under the ftp root directory in which the file is to be found.
|
| 21 |
PV_INT_PASSWORD |
Character(254) |
VARCHAR2(254) NOT NULL |
Internal password
|