Supplier outbound staging table

  • Release version: Xanadu
  • Updated August 1, 2024
  • 1 minute to read

    • The Supplier outbound [sn_spend_intg_outbound_supplier​] staging table stores important data about the supplier so that an ERP integrator can export this data to a third-party ERP system.

    Supplier outbound staging table

    The following table lists the fields for the Supplier outbound [sn_spend_intg_outbound_supplier​] staging table.

    Table 1. Supplier outbound staging table
    Field Data type Description
    ABA routing number string Unique, nine-digit number used to identify banks and financial institutions.
    Account number string Account number of the supplier.
    Active string Indicates whether the supplier payment record is active.
    Beneficiary name on account string Name of the beneficiary on the supplier's account.
    BSB code string Bank State Branch is a six-digit number that is used to identify a bank code and its associated branch in Australia.
    City string City where the supplier is located.
    Country string Country where the supplier is located.
    ERP company code string Company code of the supplier in the ERP system.
    ERP Source string ERP source used by the organization.
    Fax number ph_number Fax number of the supplier that can be used for sending documents.
    General ledger account string Accounts payable reconciliation account for the supplier.
    IFSC code string IFSC code of supplier's account number.
    Integration status String Status of the integration process.

    The outbound integration is considered successful only when the integrating status is New.

    This is a mandatory field.
    Legal entity string Name of the legal entity of the supplier.
    Legal Name String Legal name of the supplier.

    This is a mandatory field.
    Off-boarded date glide_date Date of the supplier's termination from the organization.
    On-boarded string Indicates whether the supplier is on-boarded into the ERP system.
    Payment term string Agreed time and conditions for payment to the supplier.
    Phone number String Phone number of the supplier.

    This is a mandatory field.
    Primary phone number ph_number Phone number of the primary contact at the supplier organization.
    Processing message string A message that describes the current processing status.
    State / Province string State or province where the supplier is located.
    Street address string Street where the supplier is located.
    Zip / Postal code string Zip code or postal code where the supplier is located.