ACAMCODE FILE
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.
REFERENCED BY
AC01.1 AC105 AC112 AC12.1 AC120 AC121
AC123 AC13.3 AC165 AC190 AC191 AC196
AC198 AC203 AC206 AC207 AC210 AC213
AC218 AC240 AC258 AC261 AC265 AC290
AC295 AC297 AC298 AC30.3 AC32.1 AC34.1
AC35.1 AC36.1 AC400 AC401 AC410 AC412
AC420 AC421 AC440 AC460 AC471 AC472
AC473 AC480 AC490 AC493 AC494 AC50.1
AC530 AC55.1 AC90.1 AC92.1 AC93.1 AC94.1
AC95.1 AC97.1 ACBA.1 ACVW.1 SE90.1 AR250
AR251 AR30.1 AR30.2 AR30.3 AR30.5 BR120
BR121 BR142 BR200 BR202 BR204 BR205
BR210 BR220 BR265 BR400 BR405 BR420
BR430 BR450 BRCC.1 MX123 MX500
UPDATED BY
AC06.1 AC10.3 AC10.1 AC110 AC160 AC300
AC310
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MCD-ACTIVITY Alpha 15 AC10.3 AC110
Activity Required key. This is the activity to
be capitalized.
MCD-ACCT-CATEGORY Alpha 5 AC10.3 AC110
Account Category 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 Alpha 10 AC10.3 AC110
Asset Template This field is required for asset AR250 AR251
creation. Asset templates are defined in AR30.1 AR30.2
AM15.1 (Addition Template). The template AR30.3
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 Numeric 8 AC10.3 AC110
Item Quantity 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 Alpha 10 AC10.3 AC110
Combine 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 Alpha 30 (Lower Case) AC10.3 AC110
Asset Description 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 Alpha 12 AC10.3 AC110
Tag Number Optional. You can assign a number to
identify each asset item. If you use an
asset template, tag number is optional.
MCD-ASSET-GROUP Alpha 10 AC10.3 AC110
Asset Group 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 Alpha 32 AC10.3 AC110
Item Number 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 Alpha 30 (Lower Case) AC10.3 AC110
Item Description This is the item number description.
MCD-PURCHASE-DATE Numeric 8 (yyyymmdd) AC10.3 AC110
Purchase Date 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 Numeric 8 (yyyymmdd) AC10.3 AC110
In-service Date 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 Signed 15.2 AC10.3 AC110
Item Tax 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 Alpha 30 AC10.3 AC110
Model Number Optional. You can enter a model number.
This field is valid only if you use an
asset template.
MCD-SERIAL-NUMBER Alpha 30 AC10.3 AC110
Serial Number 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 Alpha 1 AC10.3 AC110
Asset Management Optional. This field indicates whether
Hold 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 Numeric 10 AC10.3 AC110
Asset Number This field is required for asset AR250 AR251
repair. The asset number contains up to AR30.1 AR30.2
10 alphanumeric characters that uniquely AR30.3
identify an asset.
If you enter an asset number, you
cannot use an asset template.
MCD-REPAIR-TAX Signed 15.2 AC10.3 AC110
Repair Tax This field indicates the tax on an
asset repair.
MCD-ASSET-GL-CD Alpha 4 AC10.3 AC110
Asset GL Code 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 Alpha 4 AC10.3 AC110
Work-in-Process GL Optional. This is the GL code for the
Code 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 Signed 15.2 AC110 AC160
Total Capital This field tracks the total amount AC300
capitalized to date for the activity.
MCD-PO-NBR Alpha 14 AC10.3 AC110
PO Number 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 Numeric 4 AC10.3 AC110
PO Release Number Used to identify a purchase order
release (created from a Blanket or
Standing order).
MCD-PO-CODE Alpha 4 AC10.3 AC110
Po Code This is the purchase order code.
MCD-LOCATION-NAME Alpha 15 AC10.3
Location Name A user-defined location name which
represents where an asset is physically
located. Locations are used to report
asset information.
MCD-DIVISION Alpha 15 AC10.3
Division A user-defined division which is used
for reporting assets.
ACAMCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MCDSET1 ACTIVITY AC01.1 AC06.1
ACCT-CATEGORY AC10.1 AC10.3
AC105 AC110
AC112 AC12.1
AC120 AC121
AC123 AC13.3
AC160 AC165
AC190 AC191
AC196 AC198
AC203 AC206
AC207 AC210
AC213 AC218
AC240 AC258
AC261 AC265
AC290 AC295
...
ACAMCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
Amtemplate AMTEMPLATE Not Required
MCD-ASSET-TEMPLATE -> ATM-ASSET-TEMPLATE
ACAMCODE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|
