Import Asset - Revision history

Tcampbell at 23:13, 10 January 2023

2023-01-10T23:13:07Z

Tcampbell at 23:12, 10 January 2023

2023-01-10T23:12:14Z

Tcampbell at 19:54, 7 December 2022

2022-12-07T19:54:51Z

Tcampbell at 19:54, 7 December 2022

2022-12-07T19:54:17Z

Freddy at 15:30, 27 February 2018

2018-02-27T15:30:55Z

Gandrews at 20:47, 6 August 2013

2013-08-06T20:47:22Z

Gandrews at 14:02, 6 August 2013

2013-08-06T14:02:44Z

Gandrews at 13:40, 5 August 2013

2013-08-05T13:40:09Z

Gandrews at 13:39, 5 August 2013

2013-08-05T13:39:50Z

Gandrews at 21:38, 2 August 2013

2013-08-02T21:38:31Z

@@ Line 7: / Line 7: @@
 '''TAGID''' Asset Tag
 '''NAME''' Name of asset
 '''OWNER''' Organization that owns the asset
 '''DEPT''' Enter the department that controls/ owns the asset
 '''SERIAL''' Enter the serial number on each asset
 '''DESCRIP''' The description of the asset
 '''BasedOn''' When an asset is used in billing, fill out what item this asset is based on
 '''ENTRYDATE''' The Entry Date for the asset into the system
 '''SVRDATE''' Enter the in-service date for this asset
 '''LIFE''' Depreciation lifespan of the asset in years
 '''BUSUSE''' Percentage the asset is used for business purposes
 '''FEDLIFE''' Federal Depreciation: The estimated depreciable life of the asset, according to the convention selected
 '''FEDCOST''' Federal Depreciation: Asset Cost
 '''FEDSALVAGE''' Federal Depreciation: The salvage value of the asset
 '''FEDMETH''' Federal Depreciation: Method of depreciation; SL, DB200, DB150, SY
 '''FEDCONV''' Federal Depreciation: Half-Year, Quarter, Mid Month, or Full Month
 '''STLIFE''' State Depreciation: The estimated depreciable life of the asset, according to the convention selected
 '''STCOST''' State Depreciation: Asset Cost
 '''STSALVAGE''' State Depreciation: The salvage value of the asset
 '''STMETH''' State Depreciation: Half-Year, Quarter, Mid Month, or Full Month
 '''STCONV''' State Depreciation: The estimated depreciable life of the asset, according to the convention selected
 '''AMTLIFE''' Amount Depreciation: The estimated depreciable life of the asset, according to the convention selected
 '''AMTCOST''' Amount Depreciation: Asset Cost
 '''AMTSALVAGE''' Amount Depreciation: The salvage value of the asset
 '''AMTMETH''' Amount Depreciation: Method of depreciation; SL, DB200, DB150, SY
 '''AMTCONV''' Amount Depreciation: Half-Year, Quarter, Mid Month, or Full Month
 '''BKLIFE''' Book Depreciation: The estimated depreciable life of the asset, according to the convention selected
 '''BKCOST''' Book Depreciation: Asset Cost
 '''BKSALVAGE''' Book Depreciation: The salvage value of the asset
 '''BKMETH''' Book Depreciation: Method of depreciation; SL, DB200, DB150, SY
 '''BKCONV''' Book Depreciation: Half-Year, Quarter, Mid Month, or Full Month

@@ Line 7: / Line 7: @@
 '''TAGID''' Asset Tag
-<br\>'''NAME''' Name of asset
+'''NAME''' Name of asset
-<br\>'''OWNER''' Organization that owns the asset
+'''OWNER''' Organization that owns the asset
-<br\>'''DEPT''' Enter the department that controls/ owns the asset
+'''DEPT''' Enter the department that controls/ owns the asset
-<br\>'''SERIAL''' Enter the serial number on each asset
+'''SERIAL''' Enter the serial number on each asset
-<br\>'''DESCRIP''' The description of the asset
+'''DESCRIP''' The description of the asset
-<br\>'''BasedOn''' When an asset is used in billing, fill out what item this asset is based on
+'''BasedOn''' When an asset is used in billing, fill out what item this asset is based on
-<br\>'''ENTRYDATE''' The Entry Date for the asset into the system
+'''ENTRYDATE''' The Entry Date for the asset into the system
-<br\>'''SVRDATE''' Enter the in-service date for this asset
+'''SVRDATE''' Enter the in-service date for this asset
-<br\>'''LIFE''' Depreciation lifespan of the asset in years
+'''LIFE''' Depreciation lifespan of the asset in years
-<br\>'''BUSUSE''' Percentage the asset is used for business purposes
+'''BUSUSE''' Percentage the asset is used for business purposes
-<br\>'''FEDLIFE''' Federal Depreciation: The estimated depreciable life of the asset, according to the convention selected
+'''FEDLIFE''' Federal Depreciation: The estimated depreciable life of the asset, according to the convention selected
-<br\>'''FEDCOST''' Federal Depreciation: Asset Cost
+'''FEDCOST''' Federal Depreciation: Asset Cost
-<br\>'''FEDSALVAGE''' Federal Depreciation: The salvage value of the asset
+'''FEDSALVAGE''' Federal Depreciation: The salvage value of the asset
-<br\>'''FEDMETH''' Federal Depreciation: Method of depreciation; SL, DB200, DB150, SY
+'''FEDMETH''' Federal Depreciation: Method of depreciation; SL, DB200, DB150, SY
-<br\>'''FEDCONV''' Federal Depreciation: Half-Year, Quarter, Mid Month, or Full Month
+'''FEDCONV''' Federal Depreciation: Half-Year, Quarter, Mid Month, or Full Month
 [[Media:Asset_import.xlsx| Import Example‎]]

← Older revision		Revision as of 19:54, 7 December 2022
Line 54:		Line 54:
	Please visit our wiki page [http://www.abiscorp.com/adjwiki/IMPORTASSET.ashx here!] discussing the basics of how the asset importer runs.		Please visit our wiki page [http://www.abiscorp.com/adjwiki/IMPORTASSET.ashx here!] discussing the basics of how the asset importer runs.

−	[[category:~~FAQ~~]] [[category:Import/Export]]	+	[[category:Frequently Asked Questions]] [[category:Import/Export]]

← Older revision		Revision as of 19:54, 7 December 2022
Line 54:		Line 54:
	Please visit our wiki page [http://www.abiscorp.com/adjwiki/IMPORTASSET.ashx here!] discussing the basics of how the asset importer runs.		Please visit our wiki page [http://www.abiscorp.com/adjwiki/IMPORTASSET.ashx here!] discussing the basics of how the asset importer runs.

−	[[category:FAQ~~-Assets~~]]	+	[[category:FAQ]] [[category:Import/Export]]

@@ Line 2: / Line 2: @@
 [[File:Asset_import.png‎]]
-[[category:Basic Topics]]
 ===Filters===
@@ Line 53: / Line 53: @@
 Please visit our wiki page [http://www.abiscorp.com/adjwiki/IMPORTASSET.ashx here!] discussing the basics of how the asset importer runs.

@@ Line 5: / Line 5: @@
 ===Filters===
-'''CURLOC'''<br\>
+'''CURLOC'''
-'''OWNER'''<br\>
+<br\>'''OWNER''' Organization that owns the asset
-'''BUSUSE'''<br\>
+<br\>'''BUSUSE'''
-'''NOTE'''<br\>
+<br\>'''NOTE'''
-'''ASSETDEP'''<br\>
+<br\>'''ASSETDEP'''
-'''DEPT'''<br\>
+<br\>'''DEPT'''
-'''BasedOn'''<br\>
+<br\>'''BasedOn'''
-'''TAGID'''<br\>
+<br\>'''TAGID''' Asset Tag
-'''SERIAL'''<br\>
+<br\>'''SERIAL''' Enter the serial number on each asset
-'''NAME'''<br\>
+<br\>'''NAME''' Name of asset
-'''DESCRIP'''<br\>
+<br\>'''DESCRIP''' The description of the asset
-'''ENTRYDATE'''<br\>
+<br\>'''ENTRYDATE''' The Entry Date for the asset into the system
-'''SVRDATE'''<br\>
+<br\>'''SVRDATE'''
-'''LIFE'''<br\>
+<br\>'''LIFE'''
-'''SUBLOCT'''<br\>
+<br\>'''SUBLOCT'''
-'''RFID'''<br\>
+<br\>'''RFID'''
-'''CTYPE'''<br\>
+<br\>'''CTYPE'''
-'''ROUTE1'''<br\>
+<br\>'''ROUTE1'''
-'''ROUTE2'''<br\>
+<br\>'''ROUTE2'''
-'''ROUTE3'''<br\>
+<br\>'''ROUTE3'''
-'''ROUTE4'''<br\>
+<br\>'''ROUTE4'''
-'''FEDLIFE'''<br\>
+<br\>'''FEDLIFE'''
-'''FEDCOST'''<br\>
+<br\>'''FEDCOST'''
-'''FEDSALVAGE'''<br\>
+<br\>'''FEDSALVAGE'''
-'''FEDMETH'''<br\>
+<br\>'''FEDMETH'''
-'''FEDCONV'''<br\>
+<br\>'''FEDCONV'''
-'''STLIFE'''<br\>
+<br\>'''STLIFE'''
-'''STCOST'''<br\>
+<br\>'''STCOST'''
-'''STSALVAGE'''<br\>
+<br\>'''STSALVAGE'''
-'''STMETH'''<br\>
+<br\>'''STMETH'''
-'''STCONV'''<br\>
+<br\>'''STCONV'''
-'''AMTLIFE'''<br\>
+<br\>'''AMTLIFE'''
-'''AMTCOST'''<br\>
+<br\>'''AMTCOST'''
-'''AMTSALVAGE'''<br\>
+<br\>'''AMTSALVAGE'''
-'''AMTMETH'''<br\>
+<br\>'''AMTMETH'''
-'''AMTCONV'''<br\>
+<br\>'''AMTCONV'''
-'''BKCOST'''<br\>
+<br\>'''BKCOST'''
-'''BKSALVAGE'''<br\>
+<br\>'''BKSALVAGE'''
-'''BKMETH'''<br\>
+<br\>'''BKMETH'''
-'''BKLIFE'''<br\>
+<br\>'''BKLIFE'''
-'''BKCONV'''<br\>
+<br\>'''BKCONV'''

← Older revision		Revision as of 13:40, 5 August 2013
Line 53:		Line 53:
	===Additional Information===		===Additional Information===

−	Please visit our wiki page [[http://www.abiscorp.com/adjwiki/IMPORTASSET.ashx here!]] discussing the basics of how the asset importer runs.	+	Please visit our wiki page [http://www.abiscorp.com/adjwiki/IMPORTASSET.ashx here!] discussing the basics of how the asset importer runs.

← Older revision		Revision as of 13:39, 5 August 2013
Line 50:		Line 50:
	<br\>		<br\>
	[[Media:Asset_import.xlsx\| Import Example‎]]		[[Media:Asset_import.xlsx\| Import Example‎]]
		+
		+	===Additional Information===
		+
		+	Please visit our wiki page [[http://www.abiscorp.com/adjwiki/IMPORTASSET.ashx here!]] discussing the basics of how the asset importer runs.