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.