Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACAMCODE


                             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     AC113     AC12.1    AC120
AC121     AC123     AC13.3    AC130     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    SE90.1    AR250     AR251     AR30.1
AR30.2    AR30.3    AR30.5    BR120     BR121     BR130
BR131     BR142     BR151     BR152     BR153     BR154
BR155     BR156     BR157     BR165     BR200     BR202
BR204     BR205     BR210     BR215     BR220     BR251
BR252     BR253     BR254     BR265     BR400     BR405
BR420     BR430     BR450     BR521     BR530     BR900
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
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  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
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 15.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  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
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 15.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 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
Element: PO Release NumUsed 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: Destination

MCD-DIVISION           Alpha 15                                  AC10.3
Element: 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   AC113
                                                                 AC12.1  AC120
                                                                 AC121   AC123
                                                                 AC13.3  AC130
                                                                 AC135   AC160
                                                                 AC165   AC190
                                                                 AC191   AC196
                                                                 AC198   AC203
                                                                 AC206   AC207
                                                                 AC210   AC213
                                                                 AC218   AC220
                                                                 AC240   AC258
                                                                 ...

                         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