Order Acknowledgement staging table

  • 릴리스 버전: Australia
  • 업데이트 날짜 2026년 03월 12일
  • 소요 시간: 1분

    • 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.

    표 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.