Activity Asset
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.
REFERENCED BY
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||
---|---|---|---|---|---|---|
MCD-ACTIVITY Element: Activity | Alpha 15 Required key. This is the activity to be capitalized. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
MCD-DESCRIPTION Element: Item Description | Alpha 30 (Lower Case) This is the item number description. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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 |
|
||||
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. |
|
||||
MCD-REPAIR-TAX Element: Repair Tax | Signed 18.2 This field indicates the tax on an asset repair. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
MCD-PO-RELEASE Element: Po Release | Numeric 4 Used to identify a purchase order release (created from a Blanket or Standing order). |
|
||||
MCD-PO-CODE Element: Po Code | Alpha 4 This is the purchase order code. |
|
||||
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. |
|
||||
MCD-DIVISION Element: Division | Alpha 15 A user-defined division which is used for reporting assets. |
|
||||
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. |
|||||
MCD-APPEND-FLAG Element: Append Flag | Alpha 1 Y = Yes N = No " " = No |
|
||||
MCD-ADD-TO-BASIS Element: Add To Basis | Alpha 1 Y = Yes N = No |
|
||||
MCD-COMPUTE Element: Compute | Alpha 1 Y = Yes N = No |
|
||||
MCD-GRANT Element: Grant | Alpha 30 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MCDSET1 |
ACTIVITY ACCT-CATEGORY |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Acacctcat | ACACCTCAT |
Not Required
| |||||||||
Acacctcatx | ACACCTCATX |
Not Required
| |||||||||
Acactivity | ACACTIVITY |
Not Required
| |||||||||
Amasset | AMASSET |
Not Required
| |||||||||
Amasset Append | AMASSET |
Not Required
| |||||||||
Amtemplate | AMTEMPLATE |
Not Required
| |||||||||
Gmgrant | GMGRANT |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Actrans | ACTRANS |
| |||||||||||||||||||||
Actrans Allcat | ACTRANS |
|
All trademarks and registered trademarks are the property of their
respective owners.