Activity Asset Code

This file contains asset information from AC10.3 (Activity Asset). It includes activities tied to asset numbers (asset repairs) or asset templates (asset creation). An asset template is required for asset creation. Enter asset creation information in AC10.3 (Activity Asset). An asset number is required for asset repair. Enter asset repair information in the Repair section of the AC10.3 form. The Asset Interface lets you enter asset information in the Activity Management system for cost tracking. Then the interface program transfers the asset information to Asset Management when the activity is closed or the asset can begin being depreciated. An activity can be a unique asset, or each account category of the activity can be an asset by itself. You define the assets based on how you want to organize and capitalize assets. Asset transactions are created and enter the Asset Management system when you run AC160 (Asset Interface). Only activities with a capitalized status of Yes can create asset entries. The asset cost amount is determined by summing activity expense transactions. Activity expense transactions are flagged as capitalized when you create asset transactions. So, if you run AC160 again for the activity, the amounts previously capitalized are not capitalized again.
UPDATED BY

AC10.3	AC10.1	AM115	AM117	AM15.1	AM15.2
AM15.3	AM15.4	AM19.1	AM19.2	AM51.1	AM551
AP115	AP125	AP126	AP131	AP20.1	AP20.2
AP20.3	AP20.4	AP20.5	AP20.7	AP21.1	AP220
AP23.1	AP25.1	AP25.2	AP26.1	AP27.1	AP30.2
AP30.4	AP305	API1.1	API2.1	MA41.1	MA41.2
MA41.4	MA41.7	MA43.1	MA43.2	MA43.3	MA43.4
MA43.6	MA43.7	MAI1.1	PO136	PO190	PO300
PO520	POCP.1	POI3.1	POII.1	POIJ.1	AC200
AC210	ACVW.1	AP211	GL299	MX123	MX500
SN02.1	SNAC.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
MCD-ACTIVITY Element: Activity	Alpha 15 Required key. This is the activity to be capitalized.	AC10.3
MCD-ACCT-CATEGORY Element: Account Category	Alpha 5 Optional key. Enter an account category if more than one asset is being created for an activity. In this case, each account category is a unique asset or asset type. Leave this field blank for activities with one-to-one relationships (one activity to one asset) to Asset Management. In this case, each activity is a unique asset.	AC10.3
MCD-ASSET-TEMPLATE Element: Asset Template	Alpha 10 This field is required for asset creation. Asset templates are defined in AM15.1 (Addition Template). The template defines asset category and detail and category options for an asset. This field helps you enter activities or account categories to the Asset Management system. The template provides a shortcut for you to enter asset information. If you enter a template name, you cannot enter an asset number.	AC10.3
MCD-ITEM-QUANTITY Element: Item Quantity	Numeric 8 Conditionally required. If you use an asset template, item quantity is required. The Item Quantity field tells the number of units that make up this asset item. Each unit of an item is exactly the same as every other unit of the item.	AC10.3
MCD-COMBINE Element: Combine	Alpha 10 Optional. This code indicates how asset items in the Asset Interface are to be combined. If you want to combine items, this field is required. The Combine field allows you to combine many activities into a single asset. To combine Asset Interface records, the template, combine code, asset description, tag, asset group, and accounting unit must be the same.	AC10.3
MCD-ASSET-DESC Element: Asset Description	Alpha 30 (Lower Case) Conditionally required. If you use an asset template, the asset description is required. If you leave this field blank, the activity description defaults.	AC10.3
MCD-TAG-NBR Element: Tag Number	Alpha 12 Optional. You can assign a number to identify each asset item. If you use an asset template, tag number is optional.	AC10.3
MCD-ASSET-GROUP Element: Asset Group	Alpha 10 Optional. You can create a grouping of assets in an asset group. If you use an asset template, asset group is optional.	AC10.3
MCD-ITEM-NBR Element: Item Number	Alpha 32 Optional. This is the item number of an asset composed of different elements, but depreciated as a single unit. If you use an asset template, item number is optional.	AC10.3
MCD-DESCRIPTION Element: Item Description	Alpha 30 (Lower Case) This is the item number description.	AC10.3
MCD-PURCHASE-DATE Element: Purchase Date	Numeric 8 (yyyymmdd) Optional. This field contains the date the asset was purchased. The purchase date can be different from the in-service dates used for the depreciation books. If you use an asset template, purchase date is required. If you leave this field blank, the Asset Management interface defaults the distribution date. Or if you enter an in-service date, the in-service date defaults to the Purchase Date field.	AC10.3
MCD-INSRV-DATE Element: In-service Date	Numeric 8 (yyyymmdd) Optional. This is the date the asset is placed in service. The in-service date cannot be before the purchase date. If you use an asset template, a purchase date is required. If you leave this field blank, the Asset Management interface defaults the purchase date.	AC10.3
MCD-ITEM-TAX Element: Item Tax	Signed 18.2 Optional. You can enter a tax amount for an item. If you use an asset template, you can enter an item tax amount. The item tax amount is added to the item cost calculated by the Asset Management interface.	AC10.3
MCD-MODEL-NUMBER Element: Model Number	Alpha 30 Optional. You can enter a model number. This field is valid only if you use an asset template.	AC10.3
MCD-SERIAL-NUMBER Element: Serial Number	Alpha 30 This is an optional field used for the serial number of the asset. This field is valid only if you use an asset template.	AC10.3
MCD-HOLD-AM Asset Management Hold	Alpha 1 Optional. This field indicates whether assets are to be held in the Asset Management interface. It is valid only if you are creating an asset. Use Yes to hold an asset template. Use No to indicate a template is not to be held. N = No Y = Yes	AC10.3
MCD-ASSET Element: Asset Number	Numeric 10 This field is required for asset repair. The asset number contains up to 10 alphanumeric characters that uniquely identify an asset. If you enter an asset number, you cannot use an asset template.	AC10.3
MCD-REPAIR-TAX Element: Repair Tax	Signed 18.2 This field indicates the tax on an asset repair.	AC10.3
MCD-ASSET-GL-CD Element: Asset GL Code	Alpha 4 Required. This is the GL code for the asset clearing account. This account is for the debit side entry for asset creation only.	AC10.3
MCD-WIP-GL-CD Work-in-Process GL Code	Alpha 4 Optional. This is the GL code for the work-in-process (WIP) account. This account is for the credit side entry for asset creation only. If you leave this field blank, the system allocates amounts to the appropriate account based on the original cost entries posted to the activity and account category.	AC10.3
MCD-TOTAL-CAPITAL Element: Total Capital	Signed 18.2 This field tracks the total amount capitalized to date for the activity.
MCD-PO-NBR Element: Po Nbr	Alpha 14 The purchase order number field is an optional field for your reference. It is assumed to contain the original purchase order number on which this asset was included.	AC10.3
MCD-PO-RELEASE Element: Po Release	Numeric 4 Used to identify a purchase order release (created from a Blanket or Standing order).	AC10.3
MCD-PO-CODE Element: Po Code	Alpha 4 This is the purchase order code.	AC10.3
MCD-LOCATION-NAME Element: Location Name	Alpha 15 A user-defined location name which represents where an asset is physically located. Locations are used to report asset information.	AC10.3
MCD-DIVISION Element: Division	Alpha 15 A user-defined division which is used for reporting assets.	AC10.3
MCD-ASSET-APPEND Element: Asset	Numeric 10 The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.	AC10.3 AM115 AM117 AM15.1 AM15.2 AM15.3 AM15.4 AM19.1 AM19.2 AM51.1 AM551 AP115 AP125 AP126 AP131 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1 AP220 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP305 API1.1 API2.1 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136 PO190 PO300 PO520 POCP.1 POI3.1 POII.1 POIJ.1
MCD-APPEND-FLAG Element: Append Flag	Alpha 1 Y = Yes N = No " " = No	AC10.3
MCD-ADD-TO-BASIS Element: Add To Basis	Alpha 1 Y = Yes N = No	AC10.3
MCD-COMPUTE Element: Compute	Alpha 1 Y = Yes N = No	AC10.3
MCD-GRANT Element: Grant	Alpha 30	AC10.3

ACAMCODE FILE INDEX

ACAMCODE FILE RELATIONS

ONE TO ONE RELATIONS

ACAMCODE FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.