ACAMCODE

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
AC01.1 AC06.1 AC105 AC112 AC113 AC12.1
AC120 AC121 AC123 AC128 AC13.3 AC130
AC135 AC145 AC147 AC165 AC169 AC190
AC191 AC196 AC197 AC198 AC200 AC203
AC206 AC207 AC210 AC213 AC218 AC220
AC225 AC240 AC246 AC247 AC256 AC261
AC265 AC290 AC295 AC297 AC298 AC30.3
AC310 AC311 AC32.1 AC34.1 AC346 AC35.1
AC36.1 AC400 AC401 AC410 AC412 AC420
AC421 AC440 AC460 AC471 AC472 AC473
AC480 AC490 AC493 AC494 AC50.1 AC527
AC55.1 AC580 AC583 AC90.1 AC92.1 AC93.1
AC94.1 AC95.1 AC97.1 ACBA.1 ACDL.1 ACDM.2
ACDM.9 ACVW.1 SE90.1 AP211 ARLL.1 BR120
BR121 BR130 BR131 BR140 BR142 BR145
BR151 BR152 BR153 BR154 BR155 BR156
BR157 BR165 BR19.2 BR190 BR20.9 BR200
BR202 BR204 BR205 BR210 BR212 BR215
BR220 BR245 BR251 BR252 BR253 BR254
BR265 BR300 BR400 BR405 BR422 BR430
BR450 BR521 BR530 BR580 GL299 MX123
MX500 SN02.1 SNAC.1


UPDATED BY
AC10.3 AC10.1 AC110 AC160 AC300 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 AP510
API1.1 API2.1 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
DR100 IC12.1 IC140 IC141 IC142 IC145
IC243 IC330 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC83.1 MA126 MA180 MA278 MA41.1 MA41.2
MA41.4 MA41.7 MA42.1 MA42.2 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA44.1 MA44.2
MA53.1 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA69.1 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD570 PO04.1 PO04.2 PO10.1
PO10.2 PO100 PO101 PO115 PO120 PO122
PO131 PO132 PO136 PO15.1 PO15.2 PO15.4
PO150 PO17.1 PO190 PO20.1 PO20.6 PO20.9
PO204 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.3 PO22.4 PO220 PO222 PO224
PO225 PO229 PO23.1 PO230 PO234 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO251 PO26.3
PO26.7 PO26.9 PO27.2 PO27.3 PO27.4 PO275
PO276 PO277 PO28.2 PO280 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 PO54.5 POCP.1 POI3.1
POID.1 POII.1 POIJ.1 RQ01.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1
RQIF.1 RQII.1 RQIJ.1 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH32.5 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2
WH520 WH830

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MCD-ACTIVITY
Element: Activity
Alpha 15
Required key. This is the activity to be capitalized.
AC10.3 AC110
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 AC110
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 AC110
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 AC110
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 AC110
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 AC110
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 AC110
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 AC110
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 AC110
MCD-DESCRIPTION
Element: Item Description
Alpha 30 (Lower Case)
This is the item number description.
AC10.3 AC110
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 AC110
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 AC110
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 AC110
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 AC110
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 AC110
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 AC110
AC160
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 AC110
MCD-REPAIR-TAX
Element: Repair Tax
Signed 18.2
This field indicates the tax on an asset repair.
AC10.3 AC110
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 AC110
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 AC110
MCD-TOTAL-CAPITAL
Element: Total Capital
Signed 18.2
This field tracks the total amount capitalized to date for the activity.
AC110 AC160
AC300
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 AC110
MCD-PO-RELEASE
Element: Po Release
Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
AC10.3 AC110
MCD-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
AC10.3 AC110
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 AC160
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
MCD-APPEND-FLAG
Element: Append Flag
Alpha 1

Y = Yes
N = No
" " = No
AC10.3 AC110
MCD-ADD-TO-BASIS
Element: Add To Basis
Alpha 1

Y = Yes
N = No
AC10.3 AC110
MCD-COMPUTE
Element: Compute
Alpha 1

Y = Yes
N = No
AC10.3 AC110
MCD-GRANT
Element: Grant
Alpha 30
AC10.3 AC110


ACAMCODE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MCDSET1 ACTIVITY
ACCT-CATEGORY
...
AC01.1 AC06.1
AC10.1 AC10.3
AC105 AC110
AC112 AC113
AC12.1 AC120
AC121 AC123
AC128 AC13.3
AC130 AC135
AC145 AC147
AC160 AC165
AC169 AC190
AC191 AC196
AC197 AC198
AC200 AC203
AC206 AC207


ACAMCODE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
MCD-ACCT-CATEGORY->AAX-ACCT-CATEGORY
Acacctcatx ACACCTCATX Not Required
ACV-ACTIVITY-GRP->AXX-ACTIVITY-GRP
MCD-ACTIVITY->AXX-ACTIVITY
MCD-ACCT-CATEGORY->AXX-ACCT-CATEGORY
Acactivity ACACTIVITY Not Required
MCD-ACTIVITY->ACV-ACTIVITY
Amasset AMASSET Not Required
MCD-ASSET->AST-ASSET
Amasset Append AMASSET Not Required
MCD-ASSET-APPEND->AST-ASSET
Amtemplate AMTEMPLATE Not Required
MCD-ASSET-TEMPLATE->ATM-ASSET-TEMPLATE
Gmgrant GMGRANT Not Required
MCD-GRANT->GRN-GRANT


ACAMCODE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Actrans ACTRANS
MCD-ACTIVITY->ATN-ACTIVITY
MCD-ACCT-CATEGORY->ATN-ACCT-CATEGORY
  ATN-FISCAL-YEAR
  ATN-PERIOD
  ATN-OBJ-ID
Actrans Allcat ACTRANS
Valid When MCD-ACCT-CATEGORY =Spaces
MCD-ACTIVITY->ATN-ACTIVITY
  ATN-ACCT-CATEGORY
  ATN-FISCAL-YEAR
  ATN-PERIOD
  ATN-OBJ-ID


File created: Thu Jun 09 02:02:47 2016

Home
Contact Us



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