Supplier inbound staging table

  • Release version: Yokohama
  • Updated January 30, 2025
  • 2 minutes to read

    • 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.
    Table 1. Supplier inbound 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.