Outbound Order staging table

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

    • The Outbound Order [sn_spend_intg_outbound_purchase_order] staging table stores important data about the purchase orders created so that an ERP integrator can export this data to a third-party ERP system.

    The following table lists the key fields for the Outbound Order [sn_spend_intg_outbound_purchase_order] staging table.
    Note:
    There are no mandatory fields for this table.
    Table 1. Outbound Order staging table
    Field Data type Description
    Blanket order end date Date Date on which the blanket order is expected to end.

    If you're unsure of the delivery date of the product, you can provide an estimated time frame, which then creates a blanket order.
    Blanket order start date Date Date on which the blanket order is expected to start.

    If you're unsure of the delivery date of the product, you can provide an estimated time frame, which then creates a blanket order.
    Business owner String The user who placed the order.
    Catalog ID String Unique identifier for each catalog of the purchase order.
    Customer ID Unique identifier for each customer of the purchase order.
    ERP number String Unique number generated within the ERP system for the purchase order.
    ERP source String ERP source from which the purchase order is imported.
    Integration status String Current status of the purchase order integration.
    Legal entity String Name of the legal entity making this purchase.
    Order date String Date and time of the order placed in YYYY-MM-DD HH: MM: SS format.
    Order type String Type of the purchase order, which can be Standard or Blanket.
    Payment term String The agreed time and conditions of payment for the purchase order.
    PO amount String Total amount of the purchase order.
    PO amount currency String Currency of the purchase order.
    Processing message String A message that describes the current processing status of the purchase order.
    Purchase order number String Unique number for the purchase order.
    Purchase order status String Current status of the purchase order.
    Purchasing group String The group of employees making the purchase order.
    Purchasing organization String The organization making the purchase order.
    Supplier company name String Supplier company name for which the purchase order is generated.
    Supplier ID String Supplier ID for which the purchase order is generated.