Inbound Cost Allocation staging table

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

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

    The following table lists the fields for the Inbound Cost Allocation [sn_spend_intg_imp_cost_allocation] staging table.
    Table 1. Inbound Cost Allocation 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.