Asset Item Export Columns Tab
Use the Columns tab to select the data that you want to export.
Contents
| Column | Description |
|---|---|
| Equipment Number | This column displays the number associated with the equipment. |
| Item Number | This column displays the item number associated with the equipment. |
| Item Description | This column displays the item description associated with the equipment. |
| GL Cost - Total Acquisition Cost | This column displays the sum of the amounts in the Amount column in the Acquisition Cost grid on the GL Cost Tab of the of the Equipment hubs form. |
| GL Cost - Business Use Percentage | This column displays the percentage of the asset's acquisition costs that is allocated for business use for depreciation purposes. |
| GL Cost - Salvage Value | This column displays the estimated monetary amount that you expect to receive when you sell the asset at the end of its useful life. |
| GL Cost - Depreciation Basis | This column displays the basis that determines how much of the asset's cost you will write off each year. |
| GL Cost - Fiscal Year Accumulated Depreciation | This column displays the accumulated depreciation that is calculated for the asset item for the current fiscal year through the current accounting period that you have open in DPS. |
| GL Cost - Total Accumulated Depreciation | This column displays the total accumulated depreciation that is calculated for the asset item through the current accounting period that you have open in DPS. The computation is based on the values entered on the GL Cost tab of the Equipment hub form and the Asset's Depreciation Basis. |
| GL Cost - Net Book Value | This column displays the net book value that is calculated for the asset item for the current accounting period. |
| Project | This column displays the project number associated with the asset. |
| Project Name | This column displays the project name associated with the asset. |
| Phase | This column displays the phase number associated with the asset. |
| Phase Name | This column displays the phase name associated with the asset. |
| Task | This column displays the task number associated with the asset |
| Task Name | This column displays the task name associated with the asset |
| Company | This column displays the company name that the asset is associated with. |
| Organization | This column displays the organization code that the asset is associated with. |
| Category | This column displays the category assigned to the asset (for example, Furniture, Data, Phone, or Supplies). |
| Category Type | This column displays the category type assigned to the asset (for example, Materials & Supplies, Services, or Capital Items). |
| Manufacturer | This column displays the manufacturer of the asset item. |
| Model Number | This column displays the model number of the asset. |
| Serial Number | This column displays the serial number of the asset. |
| National Stock Number | This column displays the national stock number of the asset. This number consists of the four-digit Federal Supply Classification (FSC) number and the nine-digit National Item Identification Number (NIIN). |
| Extra Notes | This column displays notes from the Extra Notes text box for the line item in Purchasing, for asset items that were generated automatically from purchase order, change order, or release order line items. |
| Internal Notes | This column displays notes from the Internal Notes text box for the line item in Purchasing, for asset items that were generated automatically from purchase order, change order, or release order line items. |
| Calculation | This column displays the accounting process used for the asset. |
| Acquisition Date | This column displays the date when the asset was acquired. |
| Asset Type | This column displays the type of asset that the asset is associated with. |
| In Service Date | This column displays the date when the asset was acquired. This date determines the period in which the depreciation calculation will start for the asset. |
| Disposal Date | This column displays the date that you disposed of or sold the asset. |
| Method | This column displays how DPS calculates depreciation or amortization for the asset. |
| Useful Life in Years | This column displays the number of years of useful life for the asset. |
| Improvement Type | This column displays the type (classification) of the additional improvement expenditure. |
| Improved Asset | This column displays the asset that was improved with the asset row item. |
| Asset Status | This column displays the status of the asset: active, inactive or disposed. |
| Accumulated Depreciation Account | This column displays the asset account that will be used when you process the depreciation for the asset. |
| Depreciation Expense Account | This column displays the indirect account or other expense account that will be used when you process depreciation for the asset. |
| Lease Start Date | This column displays the start date of the lease. |
| Lease End Date | This column displays the end date of the lease. |
| Lease Vendor | This column displays the vendor associated with the leased asset. |
| Lease Vendor Contact | This column displays the contact person from the vendor associated with the leased asset. |
| GL Cost - Net Total Acquisition Cost | This column displays a value based on multiplying the Total Acquisition Cost and Business Use Percentage entered on the GL Cost tab of the of the Equipment hub form. |
| GL Cost - Period Cost | This column displays the GL Cost for the current period. |
| GL Cost - User Defined Depreciation | This column displays the period range that was entered on the GL Cost tab of the Equipment hub. |
| GL Cost - Disposal | This column displays the GL disposal cost. |
| GL Cost - Recognized Gain or (Loss) | This column displays the recognized gain or loss calculated for a disposed asset item in the accounting period after its disposal, based on the GL Cost tab of the Equipment hub and the Asset's Depreciation Basis. |
| GL Cost - Comments | This column displays the notes and comments about the asset's acquisition costs and depreciation. |
| Additional Books - Name | This column displays the name of the additional book that is entered in Asset Management Settings. |
| Additional Books - Asset Type | This column displays the asset type for the asset that is entered on the GL Books tab of the Equipment hub form. |
| Additional Books - Property Type | This column displays the property type that is associated with the asset type that is entered for the asset on the GL Books tab of the Equipment hub form. |
| Additional Books - Method | This column displays the method that determines how DPS will calculate depreciation or amortization for the asset. |
| Additional Books - Useful Life | This column displays the number of years of useful life for the asset, based on the number of years specified in Asset Management Settings for the method entered in the Method field on the Additional Books tab of the Equipment hub form. |
| Additional Books - Acquisition Date | This column displays the date when the asset was acquired. |
| Additional Books - In Service Date | This column displays the date that determines the period in which the depreciation calculation will start for the asset. |
| Additional Books - Total Acquisition | This column displays the total acquisition cost of the asset for depreciation purposes. |
| Additional Books - Net Total Acquisition | This column displays a value based on multiplying the Total Acquisition Cost and Business Use Percentage entered on the Additional Books tab of the of the Equipment hub form. |
| Additional Books - Business Use Percentage | This column displays the percentage of the asset's acquisition costs that is allocated for business use for depreciation purposes. |
| Additional Books - Additional Cost | This column displays the additional costs for the asset, such as adjustments to the tax basis for future tax initiatives. |
| Additional Books - Salvage Value | This column displays the estimated monetary amount that you expect to receive when you sell the asset at the end of its useful life. |
| Additional Books - Additional First Year Depreciation | This column displays the additional amount of depreciation during the first year of depreciation for the asset. |
| Additional Books - Section 179D | This Yes/No column indicates whether or not your enterprise elected to use the section 179 deduction instead of recovering the cost by taking depreciation deductions for the asset. |
| Additional Books - Depreciation Basis | This column displays the amount of the asset's cost that you will write off each year. |
| Additional Books - Period Depreciation | This column displays the depreciation that is calculated for the asset item for the current accounting period that you have open in DPS. The computation is based on the values entered on the Additional Books tab of the Equipment hub and the Asset's Depreciation Basis. |
| Additional Books - User Defined | This column displays the period range that was entered on the Additional Books tab of the Equipment hub. |
| Additional Books - Fiscal Year Accumulated Depreciation | This column displays the accumulated depreciation that is calculated for the asset item for the fiscal year through the current accounting period that you have open in DPS. The computation is based on the values entered on the Additional Books tab of the Equipment hub and the Asset's Depreciation Basis. |
| Additional Books - Total Accumulated Depreciation | This column displays the total accumulated depreciation that is calculated for the asset item. The computation is based on the values entered on the Additional Books tab of the Equipment hub and the Asset's Depreciation Basis. |
| Additional Books - Net Book Value | This column displays the net book value that is calculated for the asset item for the current accounting period that you have open in DPS. The computation is based on the values entered on the Additional Books tab of the Equipment hub and the GL Cost Tab. |
| Additional Books - Disposal | This column displays the disposal amount for the asset item when you process the disposal in DPS. This is based on the values entered on the Additional Books tab of the Equipment hub and the Asset's Depreciation Basis. |
| Additional Books - Recognized Gain (or Loss) | This column displays the recognized gain or loss calculated for a disposed asset item in the accounting period after its disposal. This is based on the values entered on the Additional Books tab of the Equipment hub and the Asset's Depreciation Basis. |
| Additional Books - Comments | This column displays the comments about the asset's acquisition costs and depreciation. |
| The following fields only display if you have a Purchasing license. | |
| POCO Number | This column displays the number of the purchase order or change order from which this asset item was created. |
| Release Number | This column displays the release number of the release order for a blanket purchase order that the asset is associated with. |
| Sequence | This column displays the sequence number of the purchase order line item from which this asset item was created. |
| Currency Code | This column displays the currency code used for the asset. |
| Requisition Number | This column displays the purchase requisition number. |
| Requisition Status | This column displays the status of the purchase requisition, such as A (Approved), J (Rejected), N (In Progress), or S (Submitted). |
| PO Descriptions | This column displays the description for the asset, as specified on the purchase order. |
| PO - Quantity | This column displays the quantity of the asset, as specified on the purchase order. |
| PO - Amount | This column displays the price of the asset, as specified on the purchase order. |
| PO - Date | This column displays the purchase date of the asset, as specified on the purchase order. |
| Received - Quantity | This column displays the number of units for the asset that was received. |
| Received - Amount | This column displays the price of the asset that was received. |
| Received - Date | This column displays the date when the asset was received. |
| Vouchered - Quantity | This column displays the number of units for the asset, as indicated on the voucher. |
| Vouchered - Amount | This column displays the price of the asset, as indicated on the voucher. |
| Vouchered - Date | This column displays the date on the voucher that the asset is associated with. |
| PO Status | This column displays the status of the purchase order (for example, Approved, In Progress, or Released). |
| PO Type | This column displays the type of purchase order (for example, Standard or Service). |
| Unit of Measure | This column displays the unit of measure for the item or service (for example, Each, Box, Case, Dozen, or Hour). |
| Unit Price | This column displays the price per unit for the asset. |
| Buyer | This column displays the buyer name. |
| Vendor | This column displays the vendor number. |
| Vendor Contact | This column displays the vendor contact name. |
| Closed | This Yes/No column indicates whether or not the purchase order is closed. |
| PO Approved Date | This column displays the date when the purchase, release, or change order was approved. |
| Due Date | This column displays the date on which the asset is due to be delivered. |
| Shipping Received By | This column displays the person who received the asset to be shipped. |
| Estimated Ship Date | This column displays the estimated date when the asset will be shipped. |
| Actual Ship Date | This column displays the actual date the asset was shipped. |
| Shipping Received Date | This column displays the date when the asset was received for shipping. |
| Ship To | This column displays a code that identifies the shipping destination of the asset. |
| Ship Via | This column displays how the asset is going to be shipped. |
| FOB | This column displays the FOB code used for the free on board terms of shipping. |
| Inspection Date | This column displays the date on which the inspection of the asset was completed. |
| Inspection By | This column displays the name of the employee who performed the inspection of the asset. |
| Inspection Location | This column displays the location where the asset item is stored. |
| Inspection Comments | This column displays the comments about the inspection and condition of the asset. |