Cost Allocation inbound staging table (Deprecated)

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

    • The Cost Allocation inbound [sn_spend_intg_imp_cost_allocation] staging table temporarily stores important data about cost allocations before this data is sent to the primary table.

    Important:
    This table is deprecated; please use the new one in the ERP integration framework instead. For more information, see KB2186786.

    The following table lists the fields for the Cost Allocation inbound [sn_spend_intg_imp_cost_allocation] staging table.

    Table 1. Cost Allocation inbound staging table
    Field Data type Description
    Allocate by String Determines whether the cost allocation is based on amount or percentage.
    Allocation amount String Amount that is allocated.
    Allocation percentage String Percentage of cost allocation.
    Cost center String Cost center associated with the cost allocation.
    Cost owner String User who incurs the cost of the allocated transaction amount.
    ERP CA number String CA number from the ERP system.
    ERP line number String Purchase order line number from the ERP system.

    This is a mandatory field.
    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.
    Order line String Order line associated with the cost allocation.