ACAMCODE – Activity Asset

System
Activity Management (AC)
Prefix
MCD
Primary key
ACTIVITY, ACCT-CATEGORY
Fields
31
Updated by
248 programs
Referenced by
129 programs

ACAMCODE is the Activity Asset table in Lawson Activity Management (prefix MCD). It is indexed by ACTIVITY, ACCT-CATEGORY (MCDSET1). It is related 1:1 to ACACCTCAT, ACACCTCATX, ACACTIVITY, AMASSET, AMTEMPLATE and GMGRANT and 1:M to ACTRANS. It is updated by AC10.1, AC10.3, AC110, AC160, AC300, AM115, AM117, AM15.1 and 240 more and referenced by AC01.1, AC06.1, AC105, AC112, AC113, AC12.1, AC120, AC121 and 121 more. The table has 31 fields, 1 index and 9 documented relations.

About ACAMCODE

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.

Fields (31)

Column = COBOL field name without the MCD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#MCD-ACTIVITY PK
ACTIVITY		Alpha 15Required key. This is the activity to be capitalized.AC10.3, AC110
#MCD-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5Optional 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
ASSET_TEMPLATE		Alpha 10This 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
ITEM_QUANTITY		Numeric 8Conditionally 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
COMBINE		Alpha 10Optional. 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
ASSET_DESC		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
TAG_NBR		Alpha 12Optional. 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
ASSET_GROUP		Alpha 10Optional. 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
ITEM_NBR		Alpha 32Optional. 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
DESCRIPTION		Alpha 30 (Lower Case)This is the item number description.AC10.3, AC110
#MCD-PURCHASE-DATE
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
INSRV_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
ITEM_TAX		Signed 18.2Optional. 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
MODEL_NUMBER		Alpha 30Optional. You can enter a model number. This field is valid only if you use an asset template.AC10.3, AC110
#MCD-SERIAL-NUMBER
SERIAL_NUMBER		Alpha 30This 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
HOLD_AM		Alpha 1Optional. 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
ASSET		Numeric 10This 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
REPAIR_TAX		Signed 18.2This field indicates the tax on an asset repair.AC10.3, AC110
#MCD-ASSET-GL-CD
ASSET_GL_CD		Alpha 4Required. 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
WIP_GL_CD		Alpha 4Optional. 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
TOTAL_CAPITAL		Signed 18.2This field tracks the total amount capitalized to date for the activity.AC110, AC160, AC300
#MCD-PO-NBR
PO_NBR		Alpha 14The 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
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AC10.3, AC110
#MCD-PO-CODE
PO_CODE		Alpha 4This is the purchase order code.AC10.3, AC110
#MCD-LOCATION-NAME
LOCATION_NAME		Alpha 15A user-defined location name which represents where an asset is physically located. Locations are used to report asset information.AC10.3
#MCD-DIVISION
DIVISION		Alpha 15A user-defined division which is used for reporting assets.AC10.3
#MCD-ASSET-APPEND
ASSET_APPEND		Numeric 10The 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 +52 more (list truncated in source)
#MCD-APPEND-FLAG
APPEND_FLAG		Alpha 1" " = No
  • Y Yes
  • N No
AC10.3, AC110
#MCD-ADD-TO-BASIS
ADD_TO_BASIS		Alpha 1—
  • Y Yes
  • N No
AC10.3, AC110
#MCD-COMPUTE
COMPUTE		Alpha 1—
  • Y Yes
  • N No
AC10.3, AC110
#MCD-GRANT
GRANT		Alpha 30—AC10.3, AC110

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MCDSET1
  1. ACTIVITY
  2. ACCT-CATEGORY
PrimaryAC01.1, AC06.1, AC10.1, AC10.3, AC105, AC110, AC112, AC113 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACCTCATACACCTCATXACACTIVITYAMASSETAMTEMPLATEGMGRANTACTRANSACAMCODE

One to one (7) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATNot Required
MCD-ACCT-CATEGORY→AAX-ACCT-CATEGORY
AcacctcatxACACCTCATXNot Required
ACV-ACTIVITY-GRP→AXX-ACTIVITY-GRP
MCD-ACTIVITY→AXX-ACTIVITY
MCD-ACCT-CATEGORY→AXX-ACCT-CATEGORY
AcactivityACACTIVITYNot Required
MCD-ACTIVITY→ACV-ACTIVITY
AmassetAMASSETNot Required
MCD-ASSET→AST-ASSET
Amasset AppendAMASSETNot Required
MCD-ASSET-APPEND→AST-ASSET
AmtemplateAMTEMPLATENot Required
MCD-ASSET-TEMPLATE→ATM-ASSET-TEMPLATE
GmgrantGMGRANTNot Required
MCD-GRANT→GRN-GRANT

One to many (2) — child tables

RelationTableRulesConditionField map
ActransACTRANS
MCD-ACTIVITY→ATN-ACTIVITY
MCD-ACCT-CATEGORY→ATN-ACCT-CATEGORY
—→ATN-FISCAL-YEAR
—→ATN-PERIOD
—→ATN-OBJ-ID
Actrans AllcatACTRANSValid When MCD-ACCT-CATEGORY = Spaces
MCD-ACTIVITY→ATN-ACTIVITY
—→ATN-ACCT-CATEGORY
—→ATN-FISCAL-YEAR
—→ATN-PERIOD
—→ATN-OBJ-ID

Programs

Updated by (248)

Referenced by (129)