Supplier Information Export

Overview

Talk to your CAM or CVM if you'd like to enable SIM in your instance. Export of these records once enabled is included as a Standard CSV Export.
Note:

Some additional/optional fields may need to be added to the ITF to be used in a CSV export. Integration Transaction Formats (ITF) are used to export records to third party systems. You can remove unneeded standard fields, add optional fields, reorder the fields, and publish the default for a record to make it active. Go to: Setup > Integration Documentation > Bulk Export Documentation or by URL go to /integration_transactional_formats.

For more information about ISO codes, see List of international country codes.

Supplier Information

Field NameDescriptionField TypeRequired/UniquePossible Values
RecordTypeSpecifies the header format for the row.No/No
SIM IDCoupa's unique identifier for the SIM record.integerNo/No
Supplier IDCoupa's unique identifier for the supplier associated with the SIM record.integerNo/Yes
Buyer IDCoupa's unique identifier for the buyer who created the SIM record.integerNo/No
SIM StatusThe current approval status of the SIM record.string(255)Yes/Nodraft, information_requested, pending_approval, approved, declined, pending_mapping
Company NameThe name of the SIM record.string(100)Yes/No
Display NameA user-friendly name for the supplier.string(255)No/No
Supplier NumberSupplier NumberNo/No
Parent Company NameParent Supplier Company Name as it exists in Coupa. Must exist in Coupa.No/No
IndustryThe default industry for the supplier.string(255)No/No
Preferred CurrencyThe currency the supplier would like to use to do business.No/No
Preferred LanguageThe language the supplier would like to use to do business.No/No
Inco TermsThree letter Incoterm code for the supplier's commercial terms.string(255)No/NoEXW, FCA, CPT, CIP, DAT, DAP, DDP, FAS, FOB, CFR, CIF, DPU
CommodityThe supplier's default commodity.No/No
Minority IndicatorIndicates if the supplier is a minority supplier.booleanNo/No
Minority TypeThree letter code for the minority type. Required if Minority Indicator is set to true.integerNo/No1, 2, 3, 4, 1, 2, 3, 4
Tax RegionThe tax jurisdiction.No/No
Tax ClassificationUS tax categories.No/No
Federal Tax IDThe supplier's Employer Identification Number (for US businesses).No/No
SSNThe supplier's Social Security Number (for personal US businesses).No/No
DUNSThe supplier's Data Universal Numbering System number.No/No
Tax Exempt ExplanationIf the supplier is tax exempt, they need to provide an explanation.No/No
Income TypeThe type of income for the supplier.No/No
Federal ReportableIndicates if the supplier is required to report federal taxes.No/No
International Tax IDThe supplier's tax ID (for non-US businesses).No/No
International Tax ClassificationNon-US tax categories.No/No
International ExplanationIf the supplier is tax exempt, they need to provide an explanation.textNo/No
Backend System InvoicingThe type of ERP that Coupa integrates with for invoices.string(255)No/NoSAP, Oracle
Backend System CatalogThe type of ERP that Coupa integrates with for catalogs.string(255)No/NoCatBase, Elastic, iPartner Product Suite, Claritum, Contalog, CatalognTime, Advizia, Aravo, MatrixCMX, SigmaCommerce
Payment TermThe supplier's default payment terms. Must match an exisiting payment term in Coupa. Use the payment term code.No/No
Supplier RegionThe supplier's geographic region.string(255)No/NoAMER, EMEA, APAC, Japan
Govt Agency Interaction IndicatorGovt agency interaction indicator for the ERP.booleanNo/No
Govt Agency InteractionText for the govt agency interaction indicator that's fed to the ERP.textNo/No
Organization TypeDescribes the type of organization for the supplier.string(255)No/NoCorporation, Foreign Corporation, Individual, Foreign Individual, Partnership, Foreign Partnership
Bribery Policy IndicatorBribery policy indicator for the ERP.booleanNo/No
Bribery Policy TextText for the bribery policy indicator that's fed to the ERP.textNo/No
Govt Allegation IndicatorGovt allegation indicator for the ERP.booleanNo/No
Govt Allegation TextText for the govt allegation indicator that's fed to the ERP.string(255)No/No
Third Party Interaction IndicatorThird party interaction indiciator for the ERP.booleanNo/No
Third Party Interaction TextText for the third party interaction indicator that's fed to the ERP.textNo/No
Country of OperationThe country where the supplier is based.No/No
Goods or Services ProvidedA short description of the what the supplier provides.string(255)No/No
Pay GroupA list of different ways the supplier can be paid.No/No
Invoice Amount LimitA preset limit for the maximum value of an invoice submitted by the supplier.No/No
Hold Payment IndicatorPrevent the supplier from being automatically paid through the ERP.No/No
Hold Payment TextText for the hold payment indicator that's fed to the ERP.No/No
Separate Remit ToEnable if the remit different than the primary address.No/No
Comment SourceField indicating who made the comment.string(255)No/No
CommentField for the actual comment.textNo/No
ExportedIndicates if the SIM record has exported to the ERP.No/No
Last Exported Date and TimeShows the last time the SIM record was exported to the ERP.datetimeNo/No
Created Date and TimeShows when the SIM record was created.datetimeNo/No
Created-By idCoupa's unique identifier for the user.No/No
Created-By Lastname, FirstnameThe full name of the created-by user.No/No
Created-By emailThe email address of the created-by user.No/No
Updated Date and TimeShows when the SIM record was last updated.datetimeNo/No
Updated-By idCoupa's unique identifier for the user.No/No
Updated-By Lastname, FirstnameThe full name of the updated-by user.No/No
Updated-By emailThe email address of the updated-by user.No/No
Logo file nameThe name of the supplier logo file, including file extension.string(255)No/No
Logo content typeThe type of image file used by the supplier logo.string(255)No/No
Logo file sizeThe file size of the supplier logo.integerNo/No
Logo updated atShows the last time the supplier logo was updated.datetimeNo/No
WebsiteThe address of the supplier's website.string(255)No/No
Allow cXML InvoicingIndicates if the supplier is allowed to send invoices via cXML.booleanNo/No
Hold Invoices for AP ReviewIndicates if invoices from this supplier should be reviewed by AP being approved to pay. Also known as AP Hold.booleanNo/No
Send Invoices to ApprovalsIndicates if the supplier's invoices will always be sent to approval, regardless of inovice tolerance settings.booleanNo/No
Allow Invoicing with no Backing Doc from ConnectIndicates if the supplier can create an invoice via the supplier portal without a purchase order.booleanNo/No
Allow Invoicing with Unbacked Lines from ConnectIndicates if the supplier can create an invoice lines via the supplier portal without a purchase order.booleanNo/No
Invoice Matching LevelSelects the supplier's matching level: none, 2-way, or 3-way.string(255)No/No
Shipping TermThe default shipping term for the supplier.No/No
Tax CodeThe default tax code for the supplier.No/No
Savings PercentageThe savings percentage for using the supplier.decimal(8,2)No/No
Allow Invoicing from ConnectIndicates if the supplier is allowed to create an invoice via the supplier portal.booleanNo/No
Allow Choosing Billing Account in InvoicingIndicates if the supplier can choose a billing account when creating an invoice.booleanNo/No
Invoice Inbound EmailsThis field is for the invoice inbox. Specify specific email address for the supplier.textNo/No
Default Invoice EmailThis field is useful when you've whitelisted addresses. Replies to any supplier email will go to this preferred email instead of the invoice email address.string(255)No/No
Inbound Invoice Email DomainThis field is for the invoice inbox. Specifiy an email domain for the supplier.string(255)No/No
Duplicate ExistsThere's already a supplier record that has similar fields: name, display name, DUNS, etc.booleanNo/No
One Time SupplierIndicates is the supplier is an One Time SupplierbooleanNo/No
Scope Three EmissionsIndicates if the supplier is tracking Scope Three EmissionsbooleanNo/No
Strategic SupplierIndicates if the supplier is a Strategic SupplierbooleanNo/No
ICT SupplierIndicates if the supplier is an ICT SupplierbooleanNo/No

Supplier Information allowable values

Pay Group values

1=Direct Debit, 2=Standard, 3=Customer Refund, 4=Employee, 5=Intercompany, 6=Lease, 7=Partner Referral, 8=Rent, 9=Tax, 10=Util/Telecom

Minority Type values

1=HIS, 2=NAT, 3=AFR, 4=ASN

Tax Classication values

1=1099, 2=C Corp, 3=Customer Refund, 4=Exempt 1099, 5=Tax Authority, 6=Tax & Gov, 7=Vendor, 8=Non-Profit, 9=Partner Referral, 10=S Corp, 11=Foreign Company

International Tax Classification values

1=Active NFFE, 2=Passive NFFE, 3=Exempt beneficial owner, 4=Deemed compliant FFI, 5=Canadian Financial Institution, 6=Other Partner Jurisdiction Financial Institution, 7=Participating Foreign Financial Institution, 8=Non Participating Financial Institution, 9=Specified U.S. Person, 10=Not a Specified U.S. Person

Supplier Information Address

Field NameDescriptionField TypeRequired/UniquePossible Values
RecordTypeSpecifies the header format for the row.No/No
Supplier Information IDCoupa's unique identifier for the SIM record associated with this address.integerNo/Yes
Address IDCoupa's unique identifier for this address record.integerNo/No
Address TypeThe type of address of this record.string(255)Yes/NoRTA, Primary, Standard
Location CodeA free field for storing info about the location from the ERP.string(255)No/No
Address NameA user-friendly name to identify this address.string(255)No/No
Street AddressThe first address line.string(255)No/No
Street Address 2The second address line.string(255)No/No
Postal CodeThe postal code of the address.string(255)No/No
CityThe city of the address.string(255)No/No
State or RegionThe state or region of the addressstring(255)No/No
State ISO CodeThe state iso code of the addressstring(255)No/No
CountryThe country of the address.No/No
Account CurrencyAccount CurrencyNo/No
PO BoxThe post office box of the address.string(255)No/No
PO Box Postal CodeThe post office box postal code.string(255)No/No
Account TypeThe type of account for the supplier.No/No
Intermediary Bank NameThe name of the intermediary bank name.No/No
Bank AddressThe address line for the bank.No/No
Bank CityThe city line for the bank.No/No
Bank State or RegionThe state or region of the bank.No/No
Bank Postal CodeThe postal code of the bank.No/No
Bank CountryThe country of the bank.No/No
Bank Work PhoneThe telephone number of the bank.No/No
Bank Fax PhoneThe fax number of the bank.No/No
Bank NameBank Name.No/No
Bank Account NameThe name on the bank account.No/No
Bank Account NumberThe bank account number.No/No
International Bank Account NumberThe international bank account numberNo/No
Bank Routing NumberThe bank routing number.No/No
Bank Wire Routing NumberThe bank wire routing number.No/No
IBAN NumberThe bank's International Bank Account Number.No/No
Sort CodeThe bank's Sort Code.No/No
Bank CodeBank CodeNo/No
IFSCIFSCNo/No
Transit Number And Institution NumberTransit Number And Institution NumberNo/No
SWIFT CodeThe bank's SWIFT code.No/No
BSB NumberThe bank's BSB number.No/No
BICThe bank's Bank Identifier Code.No/No
BIC Routing CodeThe bank's BIC Routing Code.No/No
Created Date and TimeThe date and time that the address record was created.datetimeNo/No
Updated Date and TimeThe date and time that the address record was last updated.datetimeNo/No
Payment MethodThe method of payment accepted by the supplier.string(255)No/Notran, cash, cred, pcard
Tax NumbersTax NumbersNo/No
Tax CountriesTax CountriesNo/No
PurposeThe names of the address purposes.stringNo/No
Remit To Contact EmailThe email address of the individual responsible for Remit To informationstring(255)No/No
Credit Card EmailEmail address to whom the Virtual Credit card will be deliveredstring(255)No/No
Beneficiary Account TypeThe type of beneficiary account for the supplier.No/Nocacc, svgs, ondp, moma, tras

Supplier Information Artifact

Field NameDescriptionField TypeRequired/UniquePossible Values
RecordTypeSpecifies the header format for the row.No/No
Supplier Information IDCoupa's unique identifier for the SIM record associated with this attachment record.integerNo/No
Attachment IDCoupa's unique identifier for this attachment record.integerNo/No
Attachment TypeThe type of document that's attached to the SIM record.string(255)No/No
Attachment Meta TypeMore detailed information about the type of document attached to the SIM record, based on the attachment type.string(255)No/No
Supplier IDCoupa's unique identifier for the supplier associated with the SIM record.string(255)No/No
Effective DateThe date when the document first becomes effective.datetimeNo/No
Expiry DateThe latest date when the document is effective.datetimeNo/No
DescriptionA brief description of the document that's attached to the SIM record.string(255)No/No
Created Date and TimeShows when the SIM record was created.datetimeNo/No
Created-By idCoupa's unique identifier for the user.No/No
Created-By Lastname, FirstnameThe full name of the created-by user.No/No
Created-By emailThe email address of the created-by user.No/No
Updated Date and TimeShows when the SIM record was last updated.datetimeNo/No
Updated-By idCoupa's unique identifier for the user.No/No
Updated-By Lastname, FirstnameThe full name of the updated-by user.No/No
Updated-By emailThe email address of the updated-by user.No/No

Supplier Information Contact

Field NameDescriptionField TypeRequired/UniquePossible Values
RecordTypeSpecifies the header format for the row.No/No
Supplier Information IDCoupa's unique identifier for the related SIM record associated with this contact.integerNo/No
Contact IDCoupa's unique identifier for this contact record.integerNo/No
Contact TypeThe job role of the supplier contact.string(255)Yes/NoPrimary, Standard
PrefixThe name prefix of the supplier contact.string(255)No/No
SuffixThe name suffix of the supplier contact.string(255)No/No
Additional Name FieldAny additional names of the supplier contact.string(255)No/No
First NameThe first name of the supplier contact.string(255)No/No
Last NameThe last name of the supplier contact.string(255)No/No
Full NameThe full name of the supplier contact.string(255)No/No
EmailThe email address of the supplier contact.string(255)No/No
Reference CodeThe reference code of the supplier contact.string(255)No/No
Work PhoneThe work phone number of the supplier contact.No/No
Mobile PhoneThe mobile phone number of the supplier contact.No/No
Fax PhoneThe fax number of the supplier contact.No/No
NotesA short note about the supplier contact.string(255)No/No
Created Date and TimeShows when the SIM record was createddatetimeNo/No
Created-By idCoupa's unique identifier for the user.No/No
Created-By Lastname, FirstnameThe full name of the created-by user.No/No
Created-By emailThe email address of the created-by user.No/No
Updated Date and TimeShows when the SIM record was last updated.datetimeNo/No
Updated-By idCoupa's unique identifier for the user.No/No
Updated-By Lastname, FirstnameThe full name of the updated-by user.No/No
Updated-By emailThe email address of the updated-by user.No/No
PurposeThe names of the address purposes.stringNo/No