|
|
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 AC06.1 AC105 AC112 AC113 AC12.1
AC120 AC121 AC123 AC128 AC13.3 AC130
AC135 AC145 AC165 AC169 AC190 AC191
AC197 AC198 AC200 AC203 AC206 AC207
AC210 AC213 AC218 AC220 AC225 AC240
AC246 AC261 AC265 AC290 AC295 AC298
AC30.3 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 ACBA.1 ACDL.1 ACDM.2 ACDM.9 ACVW.1
SE90.1 AP211 AR21.2 AR237 AR239 AR250
AR251 AR257 AR27.2 AR29.1 AR296 AR30.1
AR30.5 AR32.1 AR33.1 AR33.2 AR38.5 AR39.1
AR39.2 AR39.3 AR39.4 AR42.1 AR42.2 AR42.7
AR43.1 AR502 AR503 AR55.1 AR560 AR575
AR800 AR91.1 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 MX123 MX500 SN02.1 SNAC.1
UPDATED BY
AC10.3 AC10.1 AC110 AC160 AC300 AC310
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 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 MA180 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA66.3 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO29.1 PO30.1 PO30.2 PO30.3
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
POI3.1 POID.1 POII.1 POIJ.1 RQ10.1 RQ10.2
WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MCD-ACTIVITY Alpha 15 AC10.3 AC110
Element: Activity Required key. This is the activity to
be capitalized.
MCD-ACCT-CATEGORY Alpha 5 AC10.3 AC110
Element: Account CategoOptional 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
Element: Asset TemplateThis field is required for asset AR250 AR251
creation. Asset templates are defined in AR30.1 AR32.1
AM15.1 (Addition Template). The template AR33.1 AR39.1
defines asset category and detail and AR39.2
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
Element: 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
Element: 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
Element: Asset DescriptConditionally 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
Element: 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
Element: 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
Element: 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
Element: Item DescriptiThis is the item number description.
MCD-PURCHASE-DATE Numeric 8 (yyyymmdd) AC10.3 AC110
Element: 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
Element: In-service DatOptional. 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 18.2 AC10.3 AC110
Element: 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
Element: 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
Element: 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
Element: Asset Number This field is required for asset AR250 AR251
repair. The asset number contains up to AR30.1 AR32.1
10 alphanumeric characters that uniquely AR33.1 AR39.1
identify an asset. AR39.2
If you enter an asset number, you
cannot use an asset template.
MCD-REPAIR-TAX Signed 18.2 AC10.3 AC110
Element: Repair Tax This field indicates the tax on an
asset repair.
MCD-ASSET-GL-CD Alpha 4 AC10.3 AC110
Element: 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 18.2 AC110 AC160
Element: Total Capital This field tracks the total amount AC300
capitalized to date for the activity.
MCD-PO-NBR Alpha 14 AC10.3 AC110
Element: Po Nbr 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
Element: Po Release Used to identify a purchase order
release (created from a Blanket or
Standing order).
MCD-PO-CODE Alpha 4 AC10.3 AC110
Element: Po Code This is the purchase order code.
MCD-LOCATION-NAME Alpha 15 AC10.3
Element: 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
Element: Division A user-defined division which is used
for reporting assets.
MCD-ASSET-APPEND Numeric 10 AC10.3 AC160
Element: Asset The asset number contains up to ten AM115 AM117
numeric characters that uniquely AM15.1 AM15.2
identify an asset. Assets are AM15.3 AM15.4
automatically numbered system-wide. 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
MCD-APPEND-FLAG Alpha 1 AC10.3 AC110
Element: Append Flag Y = Yes
N = No
" " = No
MCD-ADD-TO-BASIS Alpha 1 AC10.3 AC110
Element: Add To Basis Y = Yes
N = No
MCD-COMPUTE Alpha 1 AC10.3 AC110
Element: Compute Y = Yes
N = No
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 AC113
AC12.1 AC120
AC121 AC123
AC128 AC13.3
AC130 AC135
AC145 AC160
AC165 AC169
AC190 AC191
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
...
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
Amasset Append AMASSET Not Required
MCD-ASSET-APPEND -> 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
Actrans Allcat ACTRANS
Valid When MCD-ACCT-CATEGORY = Spaces
MCD-ACTIVITY -> ATN-ACTIVITY
ATN-ACCT-CATEGORY
ATN-FISCAL-YEAR
ATN-PERIOD
ATN-OBJ-ID
|
