Order Acknowledgement staging table

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

    • The Order Acknowledgment [sn_spend_intg_imp_purchase_order_ack] staging table temporarily stores important data about order acknowledgements before this data is sent to the primary table.

    Table 1. Order Acknowledgment staging table
    Field Data type Description
    Customer id String Unique identifier for a customer.
    Estimated arrival date String Date on which the order is expected to arrive.
    Purchase order line number String Line number against which the receipt of the product is acknowledged.
    Purchase order number String Unique number for the purchase order.
    Sales order line number String Unique identifier for each item on a sales order.
    Sales order number String Unique identifier for a customer's purchase.
    Status code String Code indicating the current status.
    Status message String A message that indicates the current status.
    Supplier id String Unique identifier for the supplier.
    Third party import ID String Unique identifier for external data imports.