Purchase Order inbound staging table

  • Release version: Zurich
  • Updated July 31, 2025
  • 1 minute to read

    • The Purchase Order inbound [sn_fcms_intg_imp_order] staging table temporarily stores important data about purchase orders before this data is sent to the primary table.

    The following table lists fields for the Purchase Order inbound [sn_fcms_intg_imp_order] staging table.
    Table 1. Purchase Order inbound staging table
    Field Data type Description
    Blanket order end date String 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 String 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.
    Cost center String Cost center that incurs the expense of the order.
    ERP PO number String Purchase order number from the ERP system.

    This is a mandatory field.
    ERP source String ERP source from which data is imported. For purchase order, receipt, and invoice integrations, the ERP source is determined through the legal entity associated with these records.

    This is a mandatory field.
    Legal entity String Legal entity corresponding to a purchase.
    Order type String Type of the purchase order- Standard or Blanket.
    Payment term String The agreed upon time and conditions under which a payment to a supplier is made.
    PO amount String Total amount of the purchase order.
    PO amount currency String Currency of the purchase order.
    PO status String Status of 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.