Equipment List Columns Tab

Use the Columns tab to modify the columns included in the report. Columns can be removed, added, resized, renamed, and sequenced.

Contents

Field Description
Project This column displays the project number associated with the equipment.
Project Name This column displays the project name associated with the equipment.
Phase This column displays the phase number associated with the equipment.
Phase Name This column displays the phase name associated with the equipment.
Task This column displays the task number associated with the equipment.
Task Name This column displays the task name associated with the equipment.
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.
Row Count This column displays the total number of detail lines for each equipment.
Company This column displays the company name that the equipment is associated with.
Organization This column displays the organization code that the equipment is associated with.
Category This column displays the category assigned to the equipment (for example, Furniture, Data, Phone, or Supplies).
Category Type This column displays the category type assigned to the equipment (for example, Materials & Supplies, Services, or Capital Items).
Manufacturer This column displays the manufacturer of the equipment item.
Model Number This column displays the model number of the equipment.
Serial Number This column displays the serial number of the equipment.
National Stock Number This column displays the national stock number of the equipment. 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 equipment 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 equipment items that were generated automatically from purchase order, change order, or release order line items.
POCO Number This column displays the number of the purchase order or change order from which this equipment item was created.
Release Number This column displays the release number of the release order for a blanket purchase order that the equipment is associated with.
Sequence This column displays the sequence number of the purchase order line item from which this equipment item was created.
Currency Code This column displays the currency code used for the equipment.
Requisitions Number This column displays the purchase requisitions number.
Requisitions Status This column displays the status of the purchase requisitions, such as A (Approved), J (Rejected), N (In Progress), or S (Submitted).
PO Descriptions This column displays the description for the equipment found on the purchase order.
PO - Quantity This column displays the quantity of the equipment found on the purchase order.
PO - Amount This column displays the price of the equipment found on the purchase order.
PO - Date This column displays the date of the purchase order the equipment is associated with.
Received - Quantity This column displays the number of units for the equipment that was received.
Received - Amount This column displays the price of the equipment that was received.
Received - Date This column displays the date when the equipment that was received.
Vouchered - Quantity This column displays the number of units for the equipment as indicated on the voucher.
Vouchered - Amount This column displays the price of the equipment as indicated on the voucher.
Vouchered - Date This column displays the date on the voucher that the equipment 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 equipment.
Buyer This column displays the buyer name.
Vendor This column displays the vendor number.
Vendor Contact This column displays the vendor contact person.
Closed This Yes/No column indicates if 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 equipment is due to be delivered.
Shipping Received By This column displays the person who received the equipment to be shipped.
Estimated Ship Date This column displays the estimated date when the equipment will be shipped.
Actual Ship Date This column displays the date when the equipment was shipped.
Shipping Received Date This column displays the date when the equipment was received for shipping.
Ship To This column displays a code that identifies the shipping destination of the equipment.
Ship Via This column displays how the equipment 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 when the inspection of the equipment was completed.
Inspection By This column displays the employee who performed the inspection of the equipment.
Inspection Location This column displays the location where the equipment item is stored.
Inspection Comments This column displays the comments about the inspection and condition of the equipment.
Calculation This column displays the accounting process used for the equipment.
Acquisition Date This column displays the date when the equipment was acquired.
Asset Type This column displays the type of asset that the equipment is associated with.
In Service Date This column displays the date when the equipment was acquired. This date determines the period in which the depreciation calculation will start for the equipment.
Property Type This column displays the type of property that the equipment is associated with.
Disposal Date This column displays the date that you disposed of or sold the equipment.
Method This column displays how DPS calculates depreciation or amortization for the equipment.
Useful Life in Years This column displays the number of years of useful life for the equipment.
Improvement Type This column displays the type (classification) of the additional improvement expenditure.
Improved Asset This column displays the equipment that was improved with the equipment row item.
Asset Status This column displays the status of the equipment: active, inactive or disposed.
Accumulated Depreciation Account This column displays the equipment account that will be used when you process the depreciation for the equipment.
Depreciation Expense Account This column displays the indirect account or other expense account that will be used when you process depreciation for the equipment.
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 equipment.
Lease Vendor Contact This column displays the contact person from the vendor associated with the leased 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 Equipment hub form.
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 Equipment hub form.
GL Cost - Business Use Percentage This column displays the percentage of the equipment'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 equipment at the end of its useful life.
GL Cost - Depreciation Basis This column displays the basis that determines how much of the equipment's cost you will write off each year.
GL Cost - Comments This column displays the notes and comments about the equipment's acquisition costs and depreciation.
Acquisition Cost - Type This column displays the type of acquisition cost for an equipment, if it was a Purchase Order, AP Voucher, or Insert.
Acquisition Cost - Include This Yes/No column indicates whether or not the cost row is included in the depreciation basis calculation.
Acquisition Cost - Vendor This column displays the vendor associated with the acquisition cost of the equipment.
Acquisition Cost - Amount This column displays the acquisition cost amount for the equipment. If you use multiple currencies in DPS, the displayed amount is in the functional currency of the company for the equipment.
Acquisition Cost - Period This column displays the accounting period for the acquisition cost of the equipment.
Acquisition Cost - Description This column displays the description of the acquisition cost for the equipment.
Acquisition Cost - Voucher PO Number This column displays the purchase order number or AP voucher number associated with acquisition cost of the equipment.
Acquisition Cost - Account This column displays the account that is associated with the acquisition cost of the equipment.
Additional Books - Name This column displays the name of the additional book that is specified on the Additional Books tab of the Asset Configuration form (Settings > Accounting > Asset Management).
Additional Books - Asset Type This column displays the equipment type for the equipment that is entered on the GL Books tab of the Equipment form.
Additional Books - Property Type This column displays the property type that is associated with the equipment type that is entered for the equipment on the GL Books tab of the Equipment form.
Additional Books - Method This column displays the method that determines how DPS will calculate depreciation or amortization for the equipment.
Additional Books - Useful Life This column displays the number of years of useful life for the equipment, based on the number of years specified in Asset Management Configuration for the method entered in the Method field on the Additional Books tab of the Equipment form.
Additional Books - Acquisition Date This column displays the date when the equipment 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 equipment.
Additional Books - Total Acquisition Cost This column displays the total acquisition cost of the equipment for depreciation purposes.
Additional Books - Net Total Acquisition Cost Value This column displays a value based on multiplying the Total Acquisition Cost and Business Use Percentage entered on the Additional Books tab of the Equipment hub form.
Additional Books - Business Use Percentage This column displays the percentage of the equipment's acquisition costs that is allocated for business use for depreciation purposes.
Additional Books - Additional Cost This column displays the additional costs for the equipment, 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 equipment at the end of its useful life.
Additional Books - First year Depreciation This column displays the additional amount of depreciation that you plan to take during the first year of depreciation.
Additional Books - Section 179 Deduction This Yes/No column indicates whether or not your enterprise elected to use section 179 deduction instead of recovering the cost by taking depreciation deductions for the equipment.
Additional Books - Depreciation Basis This column displays how much of the equipment's cost you will write off each year.
Additional Books - Comments This column displays the comments about the equipment's acquisition costs and depreciation.
Assignments - Assigned This Yes/No column indicates whether or not the equipment is assigned to an employee.
Assignments - Employee This column displays the name of the employee who currently has the assigned equipment.
Assignments - Assigned Date This column displays the date when the equipment was assigned to the employee.
Assignments - Recovered Date This column displays the date when the equipment was recovered from the employee.
Assignments - Address 1, Assignments - Address 2, Assignments - Address 3, Assignments - City, Assignments - State/Province, Assignments - Zip/Postcode, Assignments - Country, Assignments - Office, Assignments - Floor These columns display the address information where the employee and equipment are located.
Files - Description This column displays the description for the file or URL.
Files - File Path This column displays the link to the file or URL.
Files - Graphic This Yes/No column indicates whether or not the file is an image.