Inbound staging tables for Supplier Lifecycle Operations › Inbound staging tables › Source-to-Pay integration framework › Integration with third-party applications › Integrations › Source-to-Pay Operations › Finance and Supply Chain

Release: Australia · Updated: 2026-03-12 · Official documentation · View source

Supplier inbound staging table

The Supplier inbound [sn_fcms_intg_imp_supplier] staging table temporarily stores important data about the supplier before this data is sent to the Supplier [sn_fin_supplier] primary table.

Supplier inbound staging table

The following table lists fields for the Supplier inbound [sn_fcms_intg_imp_supplier] staging table.

Field	Data type	Description
Accepted purchasing currency	String	Currency value in which purchase orders for this supplier must be created.
City	String	City where the supplier is located.
Company overall rating	String	Overall rating of the company.
Company type	String	Industry type of the supplier.
Country	String	Country where the supplier is located.
Country of registration	String	Country where the supplier is registered.
County / District	String	County or district where the supplier is located.
Customer number	String	Unique identifier for the organization to the supplier.
Domain	String	Domain name of the supplier.
Duns	String	Unique 9-digit identifier for a supplier.
Employee number	String	Employee number of the supplier contact.
ERP company code	String	Company code of the supplier in the ERP system.
ERP company code	String	Company code of the supplier in the ERP system.
ERP source	String	ERP source used by the organization.
Fax number	String	Number to which documents can be faxed to the supplier.
Founded year	String	Year the organization was founded.
General ledger account	String	Accounts payable reconciliation account for the supplier.
Goods shipped from	String	Location from where the supplier ships out the products.
Incoterm	String	Set of 11 internationally recognized rules that define the responsibilities of sellers and buyers.It specifies who is responsible for paying for and managing the shipment, insurance, documentation, customs clearance, and other logistical activities. Select one of these options: - Carriage and Insurance Paid to \(CIP\) - Carriage Paid to \(CPT\) - Cost and Freight \(CFR\) - Cost, Insurance, and Freight \(CIF\) - Delivered at Place \(DAP\) - Delivered at Terminal \(DAT\) - Delivered Duty Paid \(DDP\) - Ex Works \(EXW\) - Free Alongside Ship \(FAS\) - Free Carrier \(FCA\) - Free on Board \(FOB\)
Industry	String	Industry type of the supplier.
Legal entities	String	Name of the legal entity.
Legal name	String	Legal name of the supplier that corresponds to its operating location.
Locations count	String	Number of places where the supplier operates.
Logo URL	String	Image URL of the supplier’s logo.
Long description	String	Detailed description of the supplier.
Off-boarded date	String	Date of the supplier's termination from the organization.
Onboarded	String	Indicates whether the supplier is onboarded into the ERP system.
On-boarded by	String	Employee responsible for onboarding the supplier.
On-boarded date	String	Onboarding date of the supplier.
Parent company	String	Parent company of the supplier.
Payment term	String	Agreed upon time and conditions for payment to the supplier.
PO box number	String	Post office box number where the supplier correspondence and payments are made.
Posting Block	String	Postal block where the supplier is located.
Primary phone number	String	Primary phone number.
Purchasing entities	String	Purchasing entities that are allowed to purchase from the supplier.
Short description	String	Brief description about the supplier.
State / Province	String	State or province where the supplier is located.
Status	String
Street address	String	Street where the supplier is located.
Sustainability rating	String	The business relationship designated to the entity.
Tax id	String	Tax ID of the organization.
Tax jurisdiction	String	Taxation authority that imposes the taxes.
Twitter	String	Twitter account of the supplier.
URL	String	URL of the supplier.
Wikipedia	String	Wikipedia page of the supplier.
YouTube	String	Youtube channel of the supplier.
Zip / Postal code	String	Zip code or postal code where the supplier is located.

Parent Topic:Inbound staging tables for Supplier Lifecycle Operations

Related topics

Supplier Contact inbound staging table

Supplier Legal Entity mapping inbound staging table

Supplier Location inbound staging table

Supplier Payment inbound staging table