Fixed asset details stage inbound table
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.
| 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. |
Parent Topic:Inbound staging tables for Sourcing and Procurement Operations
Related topics
CMDB Model Category Stage inbound staging table
CMDB Service Model Stage inbound staging table
CMN Location Stage inbound staging table
Cost Center Stage inbound staging table
Department Stage inbound staging table
ERP Plant Address Mapping Stage inbound staging table
FX Currency Stage inbound staging table
FX Rate Stage inbound staging table
GL Account Stage inbound staging table
Import Availability Updates inbound staging table
Availability Error staging table
Cost Allocation inbound staging table (Deprecated)
Purchase Order inbound staging table
Purchase Order Line inbound staging table
Legal Entity Stage inbound staging table
Office Location Stage inbound staging table
Order Acknowledgement staging table
Order Acknowledgement Error staging table
Payment Terms Stage inbound staging table
Price Error outbound staging table
Product Model Stage inbound staging table
Purchase Entity Stage inbound staging table
Purchase Line Stage inbound staging table
Purchase Requisition staging table
Spend Shipment Import inbound staging table
Supplier Product Stage inbound staging table
Third Party Sourcing Registration staging table
Third Party Unit Mapping staging table