Fixed asset details stage inbound table

  • Release version: Xanadu
  • Updated August 26, 2024
  • 1 minute to read

    • The Fixed asset details inbound [sn_fcms_intg_imp_fixed_asset_details] staging table temporarily stores important data about imported invoice line before this data is sent to the primary table.

    Fixed asset details inbound staging table

    The following table lists the fields for the Fixed asset details inbound [sn_fcms_intg_imp_fixed_asset_details] staging table.
    Table 1. Fixed asset details stage
    Field Data type Description
    Asset id String Unique identifier for the fixed asset.
    Asset number String Unique identifier generated within the ERP system for the fixed asset.
    Capitalize on String Date on which the requester assumes the liability of the fixed asset, depending on the supplier incoterm.
    Currency String Currency associated with the purchase of the fixed asset.
    Depreciated amount String Amount that the fixed asset has depreciated by over time.
    Depreciation life-cycle String Length of time in which the fixed asset is fully depreciated.
    Depreciation start date String Start date of depreciation cycle.
    Depreciation term String Frequency of depreciation throughout the life-cycle of the fixed asset.
    ERP Asset number String Unique identifier generated within the ERP system for the fixed asset.
    ERP Asset sub number String Unique identifier number that, when paired with the Asset number, identifies an asset.
    ERP source String ERP source from which the fixed asset is imported.
    Original value String Amount originally paid for the fixed asset.
    Remaining value String Amount that the fixed asset is worth the current day, after factoring in depreciation.
    Salvage value String Amount that the fixed asset is worth after it has come to the end of its life.