Supplier location inbound staging table

  • Release version: Yokohama
  • Updated January 30, 2025
  • 1 minute to read

    • The Supplier location inbound [sn_fcms_intg_supplier_location_inbound] staging table temporarily stores important data about the geographical location of a supplier before this data is sent to the Supplier Location [sn_slm_m2m_location] and Location [cmn_location] primary tables.

    Supplier location inbound staging table

    The following table lists the mandatory fields for the Supplier location inbound [sn_fcms_intg_supplier_location_inbound] staging table.
    Table 1. Supplier location inbound staging table
    Field Data type Description
    Category String The category that the supplier location belongs to. The choices are:
    • Contracting address
    • Delivery address
    • Facility (default)
    • Headquarters
    • Invoice address
    • Service center
    City String City of the supplier location.
    Company String Name of the company that the supplier location is linked to.
    Contact String Contact details of the supplier location.
    Coordinates retrieved on String Coordinates of the supplier location that was retrieved on a specific date.
    Country  String Country of the supplier location.
    Duplicate  String Indicates whether the supplier location is a duplicate or not.
    ERP source String ERP source from which data is imported.
    Fax phone String Fax phone details of the supplier location.
    Full name String Full name of the supplier location.
    Integration status String Latitude coordinates of the supplier location.
    Latitude String Latitude coordinates of the supplier location.
    Location source String Source of the supplier location.
    Location type String Type of the supplier location.
    Longitude String Longitude coordinates of the supplier location.
    Managed by group String Name of the group that manages the supplier location.
    Name String Name of the supplier.
    Primary String Indicates whether the supplier is primary or not.
    Primary location String Primary location of the supplier.
    Phone String Phone number of the supplier.
    Phone territory String Phone territory of the supplier.
    Processing message String A message that describes the current processing status.
    State / Province String State of the supplier location.
    Stock room String Stock room details of the supplier location.
    Street address String Street address of the supplier location.
    Time zone  String Timezone of the supplier location.
    Zip/Postal code String Zip code of the supplier location.