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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MCDSET1ACTIVITY, ACCT-CATEGORYPrimaryAC01.1, AC06.1, AC10.1, AC10.3, AC105, AC110, AC112, AC113 +22 more (list truncated in source)

Relations

One to one (7) — lookups and parents

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

One to many (2) — child tables

RelationTableRulesConditionField map
ActransACTRANSMCD-ACTIVITY → ATN-ACTIVITY, MCD-ACCT-CATEGORY → ATN-ACCT-CATEGORY, → ATN-FISCAL-YEAR, → ATN-PERIOD, → ATN-OBJ-ID
Actrans AllcatACTRANSValid When MCD-ACCT-CATEGORY = SpacesMCD-ACTIVITY → ATN-ACTIVITY, → ATN-ACCT-CATEGORY, → ATN-FISCAL-YEAR, → ATN-PERIOD, → ATN-OBJ-ID

Programs

Updated by (248)

Referenced by (129)