Mapping Supplier Data to the PeopleSoft Supplier Tables

Note:

Depending on the PeopleSoft products that you have licensed, that is, PeopleSoft Payables, Purchasing, or Asset Management, and the functionality that you require, you may not need to populate all of these records.

Table	Description	Required for PeopleSoft Payables	Required for PeopleSoft Purchasing	Required for PeopleSoft Asset Management
VENDOR	Base.	Yes	Yes	Yes
VENDOR_ADDR	Address.	Yes	Yes	Yes
VENDOR_LOC	Locations.	Yes	Yes	Yes
VENDOR_PAY	Payment processing specifications.	Yes	No	No
VNDR_ADDR_SCROL	Index to address table.	Yes	Yes	Yes
VNDR_CNTCT_SCR	Index to contact table.	Yes	Yes	Yes
VNDR_LOC_SCROL	Index to location table.	Yes	Yes	Yes
VENDOR_ID_NBRS	Additional ID numbers (Dun & Bradstreet numbers).	No	Yes	Yes
VENDOR_ADDR_PHN	Phone numbers.	No	Yes	Yes
VENDOR_CNTCT	Contacts.	No Required if you have contact information specific to accounts payable.	Yes	Yes
VENDOR_CONVER	Conversations.	No	Yes	Yes
VENDOR_INVOICE	Invoice processing specifications.	Yes	Yes	No
VENDOR_TYPE	Type codes.	No	Yes	Yes
VNDR_BANK_ACCT	Electronic payment information.	No	No	No
VNDR_CNTCT_PHN	Contact phone numbers.	No	Yes	Yes
VNDR_IND_CLASS	Standard industrial classification (SIC) codes.	No	Yes	Yes
VNDR_LOC_ID_NBR	Additional ID numbers associated with location.	No	Yes	Yes
VNDR_URL	Internet address.	No	Yes	Yes
VNDR_VAT_RGSTRN	VAT information.	No	Yes	No
VENDOR_WTHD	Withholding data.	Yes for withholding applicable suppliers only	No	No
VENDOR_WTHD_JUR	Withholding type.	Yes for withholding applicable suppliers only	No	No

This diagram shows the organization of supplier tables in parent-child relationships: