Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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    AC135     AC165     AC190     AC191
AC196     AC198     AC203     AC206     AC207     AC210
AC213     AC218     AC220     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
DA233     DA240     GR240     SE90.1    AR250     AR251
AR30.1    AR30.2    AR30.3    AR30.5    BR120     BR121
BR130     BR131     BR142     BR165     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
                                                                 AC135   AC160
                                                                 AC165   AC190
                                                                 AC191   AC196
                                                                 AC198   AC203
                                                                 AC206   AC207
                                                                 AC210   AC213
                                                                 AC218   AC220
                                                                 AC240   AC258
                                                                 AC261   AC265
                                                                 ...

                         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