Supplier Site Import

Overview

The Supplier Site Import process reads files from ./Incoming/SupplierSites/ in the standard SFTP setup. These files are moved to the archive folder located at ./Incoming/Archive/SupplierSites/ before being processed in alphanumeric order.

Supplier Site

Field Name Required Field Unique? Field Type Field Description Possible Values
Code Yes Yes string(20) Must be unique supplier site code or else the system will attempt to updated the existing supplier site record
Name Yes No string(255) Supplier Site name
Id No No integer Coupa Unique Supplier Id
PO Method No No string(255) Possible values are email, cxml, xml, buy_online or prompt. If email, the system will send the PO via email (must fill in the PO email address). If cxml, system will send the PO via XML (must fill in the cXML values). If prompt, the system will hold the PO and wait for you to manually release the order. cxml, xml, email, prompt, mark_as_sent, buy_online
PO Change Method No No string(255) Possible values are email, cxml, xml, buy_online or prompt. If email, the system will send the PO via email (must fill in the PO email address). If cxml, system will send the PO via XML (must fill in the cXML values). If prompt, the system will hold the PO and wait for you to manually release the order. cxml, xml, email, prompt, mark_as_sent, buy_online
Default Locale No No string(255) Will accept any valid locale short code i.e. en, en-GB, fr, fr-CA, etc.
PO cXML URL Yes No string(255) Must be filled in if PO method is cXML
PO cXML Domain Yes No string(255) Must be filled in if PO method is cXML
PO cXML Identity Yes No string(255) Must be filled in if PO method is cXML
PO cXML Supplier Domain Yes No string(255) Must be filled in if PO method is cXML
PO cXML Supplier Identity Yes No string(255) Must be filled in if PO method is cXML
PO cXML Secret Yes No string(255) Must be filled in if PO method is cXML
PO cXML Protocol Yes No string(255) Must be filled in if PO method is cXML
PO cXML HTTP Basic Auth Username No No string(255) If sending PO cXML has HTTP Basic Auth
cXML SSL Version No No string(255) Blank to use latest version available (recommended). Set to TLSv1 or SSLv3 to override
Buyer Hold No No boolean Possible values are Yes or No. If yes, then the buyer will need to review the PO before issuing. If no, the system will automatically send the PO via the preferred PO method
Disable Cert Verify No No boolean Disable SSL Cert Checking
PO Email Yes No string(255) Must be filled in if PO method is email
Active No No boolean Possible values are true, false.
Request change orders No No integer Allow supplier to initiate an Order change requests
Allow Evaluated Receipt Settlement (ERS) Invoicing No No boolean If supplier site is eligible for Evaluated Receipt Settlement (ERS) Invoicing flow. Supplier must have ERS Invoicing flag set to true.
Supplier Name Yes No string(255) Parent Supplier name
Supplier Number No No Parent Supplier number
Payment Terms Yes Yes string(20) If filled in, must match one of your Payment Terms
Shipping Terms Yes Yes string(20) If filled in, must match one of your Shipping Terms
Content Groups No No Enter in content groups (for security)
Addresses No No Address List of associated Supplier address IDs. Must belong to a parent supplier
Contacts No No Contact List of associated Supplier contact IDs. Must belong to a parent supplier
Contact Reference Code No No Reference code of associated contact
Account Types No No AccountType Chart of Accounts for supplier site
Payment Method No No string(255) Must be "Invoice", "P-Card", "Invoice Only", or "P-Card Only"
Allow supplier to propose item substitute on Order Confirmations No No integer Allow supplier to propose item substitute on Order Confirmations