Columns for Asset Items Export Report
You can select the columns to display on your report.
Contents
Field | Description |
---|---|
Accumulated Depreciation Account | This column displays the asset account that will be used when you process the depreciation for the asset. |
Acquisition Date | This column displays the date when the asset was acquired. |
Actual Ship Date | This column displays the actual date the asset was shipped. |
Asset Status | This column displays the status of the asset: active, inactive or disposed. |
Asset Type | This column displays the type of asset that the asset is associated with. |
Buyer | This column displays the buyer name. |
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). |
Closed | This Yes/No column indicates whether or not the purchase order is closed. |
Company | This column displays the company name that the asset is associated with. |
Currency Code | This column displays the currency used 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. |
Disposal Date | This column displays the date that you disposed of or sold the asset. |
Due Date | This column displays the date on which the asset is due to be delivered. |
Equipment Number | This column displays the number associated with the equipment. |
Estimated Ship Date | This column displays the estimated date when the asset will be shipped. |
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. |
FOB | This column displays the FOB code used for the free on board terms of shipping. |
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 - Comments | This column displays the notes and comments about the asset's acquisition costs and depreciation. |
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 - Disposal | This column displays the GL disposal cost. |
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 Vantagepoint. |
GL Cost - Net Book Value | This column displays the net book value that is calculated for the asset item for the current accounting period. |
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 Depreciation | This column displays the depreciation that is calculated for the asset item for the current accounting period that you have open in Vantagepoint. |
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 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 - 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 Vantagepoint. 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 - 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 - User Defined Depreciation Range | This column displays the period range that was entered on the GL Cost tab of the Equipment hub. |
Improved Asset | This column displays the asset that was improved with the asset row item. |
Improvement Type | This column displays the type (classification) of the additional improvement expenditure. |
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. |
Inspection By | This column displays the name of the employee who performed the inspection of the asset. |
Inspection Comments | This column displays the comments about the inspection and condition of the asset. |
Inspection Date | This column displays the date on which the inspection of the asset was completed. |
Inspection Location | This column displays the location where the asset item is stored. |
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. |
Item Description | This column displays the item description associated with the equipment. |
Item Number | This column displays the item number associated with the equipment. |
Lease End Date | This column displays the end date of the lease. |
Lease Vendor | This column displays the end date of the lease. |
Lease Vendor Contact | This column displays the contact person from the vendor associated with the leased asset. |
Lease Start Date | This column displays the start date of the lease. |
Manufacturer | This column displays the manufacturer of the asset item. |
Method | This column displays how Vantagepoint calculates depreciation or amortization for the asset. |
Model Number | This column displays the model number of the asset item. |
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). |
Organization | If your enterprise uses organizations, this column displays the code for the organization that is associated with the record. |
Phase | This column displays the phase number. |
Phase Name | This column displays the name of the phase. |
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. |
PO - Quantity | This column displays the quantity of the asset, as specified on the purchase order. |
PO Approved Date | This column displays the date when the purchase, release, or change order was approved. |
PO Descriptions | This column displays the description for the asset, as specified on the purchase order. |
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). |
POCO Number | This column displays the number of the purchase order or change order from which this asset item was created. |
Project | This column displays the project number associated with the asset. |
Project Name | This column displays the project name associated with the asset. |
Property Type | This column displays the type of property associated with the asset. |
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. |
Received - Quantity | This column displays the number of units for the asset that was received. |
Release Number | This column displays the release number of the release order for a blanket purchase order that the asset is associated with. |
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). |
Sequence | This column displays the sequence number of the purchase order line item from which this asset item was created. |
Serial Number | This column displays the serial number of the asset. |
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. |
Shipping Received By | This column displays the person who received the asset to be shipped. |
Shipping Received Date | This column displays the date when the asset was received for shipping. |
Task | This column displays the task number associated with the asset. |
Task Name | This column displays the name of the task. |
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. |
Useful Life in Years | This column displays the number of years of useful life for the asset. |
Vendor | This column displays the vendor number. |
Vendor Contact | This column displays the vendor contact name. |
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. |
Vouchered - Quantity | This column displays the number of units for the asset, as indicated on the voucher. |
Parent Topic: Asset Item Data Export Report