Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMASSETTRF


                            AMASSETTRF FILE

                             Asset Transfer

This file contains historical asset information related to transfers. It is
updated by AM30.1 (Transfers) and AM30.2 (Items).


REFERENCED BY

AM145     AM190     AM192     AM230     AM235     AM40.1
AM40.2    AM40.3    AM40.4    AM41.1    AM41.2    AMDL.1

UPDATED BY

AM135     AM154     AM170     AM30.1    AM30.2    AM300
AM115     AM125     AM15.1    AM15.2    AM15.3    AM15.4
AM20.1    AM20.2    AM20.3    AM20.4    AM20.5    AM20.6
AM21.1    AM21.2    AM21.3    AM21.4    AM21.5    AM21.6
AM330     AM500     AM551     AM96.1    AM98.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ATF-ASSET              Numeric 10                                AM135   AM154
Element: Asset         Required. The asset number contains up    AM30.1
                       to ten numeric characters that uniquely
                       identify a transfer-from asset. Assets
                       are automatically numbered system-wide.


ATF-PROCESS-SEQ        Numeric 4                                 AM135   AM154
Element: Process SequenKey field. This is the sequence number    AM30.1
                       for the process.


ATF-TO-ASSET           Numeric 10                                AM135   AM154
Element: To Asset      This is the to-asset for the transfer.    AM30.1  AM30.2

ATF-TRF-STATUS         Alpha 1                                   AM135   AM154
Element: Transfer StatuThis is the status of the transfer.       AM170   AM30.1
                       Valid values are:
                       R = Released
                       N = Not Released

ATF-TRANSFER-DATE      Numeric 8  (yyyymmdd)                     AM135   AM154
Element: Transfer Date This is the date the asset was            AM30.1
                       transferred.


ATF-TRANSFER-TYPE      Alpha 1                                   AM135   AM154
Element: Transfer Type This is the type of the transfer. Valid   AM30.1
                       values are:
                       T = Intracompany
                       I = Intercompany

ATF-TRF-QUANTITY       Numeric 10                                AM135   AM154
Element: Transfer QuantThis is the asset quantity transferred.   AM30.2

ATF-FULL-PARTIAL       Alpha 1                                   AM135   AM154
Element: Full Partial  This field indicates whether the          AM30.1
                       transfer is full (including all asset
                       items) or partial (including only some
                       asset items). Valid values are:
                       F = Full
                       P = Partial

ATF-DESCRIPTION        Alpha 30  (Lower Case)                    AM135   AM154
Element: Description   This is the transfer description.         AM30.1

ATF-TAG-NBR            Alpha 12                                  AM135   AM154
Element: Tag Number    This is the tag number, a                 AM30.1
                       user-definable identifier, for the
                       transfer-from asset.


ATF-TO-TAG-NBR         Alpha 12                                  AM135   AM154
Element: To Tag Number This is the tag number for the to-asset.  AM30.1


ATF-LEASE-COMPANY      Numeric 4                                 AM135   AM154
Element: Lease Company The lessor company for the transferred    AM30.1
                       leased asset.

ATF-LEASE              Alpha 19                                  AM135   AM154
Element: Lease         The lease number with which a             AM30.1
                       transferred leased asset is associated.

ATF-CLASSIFICATION     Alpha 1                                   AM135   AM154
Element: Classification                                          AM30.1

ATF-ASSET-GROUP        Alpha 10                                  AM135   AM154
Element: Asset Group   This is the asset group for the           AM30.1
                       transferred asset. An asset group
                       represents a parent asset used for
                       reporting purposes.


ATF-TO-ASSET-GROUP     Alpha 10                                  AM135   AM154
Element: To Asset GroupThis is the asset group, if any, for      AM30.1
                       the to-asset.


ATF-OBJ-ID             Numeric 12                                AM135   AM154
Element: Object ID     This is the object identifier. It is      AM30.1
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

ATF-TO-OBJ-ID          Numeric 12                                AM135   AM154
Element: To Object ID  This is the object identifier for the     AM30.1  AM30.2
                       to-asset. The object identifier is a
                       unique key used to attach a list of
                       user-defined attributes.


ATF-ASSET-CATEGORY     Alpha 1                                   AM135   AM154
Element: Asset CategoryThis is the category for the asset.       AM30.1
                       Valid values are:
                       D = Depreciable
                       N = Non Depreciable

ATF-SIMULATED          Alpha 1                                   AM135   AM154
Element: Simulated     This field indicates whether the asset    AM30.1
                       is simulated.


ATF-WORK-IN-PROC       Alpha 1                                   AM135   AM154
Element: Work-in-ProcesThis field indicates whether the asset    AM30.1
                       is a work-in-process asset.


ATF-TAX-EXEMPT         Alpha 1                                   AM135   AM154
Element: Tax Exempt    This field indicates whether the asset    AM30.1
                       is tax exempt.


ATF-USED               Alpha 1                                   AM135   AM154
Element: Used          This field indicates whether the asset    AM30.1
                       is used. Valid values are
                       Y = Yes
                       N = No


ATF-ITEM-TOT-QTY       Numeric 10                                AM135   AM154
Element: Item Total QuaThis is the total item quantity for the   AM30.1
                       from-asset.


ATF-TO-IT-TOT-QTY      Numeric 10                                AM135   AM154
To Item Total          This is the total item quantity for the   AM30.2
Quantity               to-asset.


ATF-IT-TOT-CSTBASE     Signed 15.2                               AM135   AM154
Element: Item Total CosThis is the total item cost for the       AM30.1
                       from-asset in the base currency.


ATF-TO-IT-TOTCSTBS     Signed 15.2                               AM135   AM154
To Item Total Cost     This is the total item cost for the       AM30.1  AM30.2
Base                   to-asset in the base currency.


ATF-IT-TOT-TAXBASE     Signed 15.2                               AM135   AM154
Element: Item Total TaxThis is the total item tax in the base    AM30.1
                       currency for the from-asset.


ATF-TO-IT-TOTTAXBS     Signed 15.2                               AM135   AM154
To Item Total Tax      This is the total item tax in the base    AM30.1  AM30.2
Base                   currency for the to-asset.


ATF-IT-TOT-CSTTRAN     Signed 15.2                               AM135   AM154
Element: Item Total CosThis is the total item cost in the        AM30.1
                       transaction currency for the from-asset.


ATF-TO-IT-TOTCSTTR     Signed 15.2                               AM135   AM154
To Item Total Cost      This is the total item cost in the       AM30.1  AM30.2
Tran                   transaction currency for the to-asset.


ATF-IT-TOT-TAXTRAN     Signed 15.2                               AM135   AM154
Element: Item Total TaxThis is the total item tax in the         AM30.1
                       transaction currency for the from-asset.


ATF-TO-IT-TOTTAXTR     Signed 15.2                               AM135   AM154
To Item Total Tax      This is the total item tax in the         AM30.1  AM30.2
Tran                   transaction currency for the to-asset.


ATF-BASE-ND            Numeric 1                                 AM135   AM154
Base Number of                                                   AM30.1
Decimals

ATF-TO-BASE-ND         Numeric 1                                 AM135   AM30.1
To Base Number of      This is the number of decimal positions
Decimals               defined in the company base currency for
                       the to-asset.


ATF-TRAN-ND            Numeric 1                                 AM135   AM154
Tran Number of                                                   AM30.1
Decimals

ATF-TO-TRAN-ND         Numeric 1                                 AM135   AM30.1
To Tran Number of      The number of decimal positions defined
Decimals               in the transaction currency for the
                       to-asset.


ATF-CURRENCY-CODE      Alpha 5                                   AM135   AM154
Element: Currency Code This field contains the company base      AM30.1
                       currency code established in Company
                       (GL10.1 ).

ATF-TO-CURR-CODE       Alpha 5                                   AM135   AM154
Element: To Currency CoThis is the company base currency code    AM30.1
                       for the to-asset.


ATF-ITEM-LAST-DATE     Numeric 8  (yyyymmdd)                     AM135   AM154
Element: Item Last DateThis is the last changed date for the     AM30.1
                       item.


ATF-TO-IT-LAST-DT      Numeric 8  (yyyymmdd)                     AM135   AM154
Element: To Item Last DThis is the last changed date for the     AM30.1  AM30.2
                       to-asset item.

ATF-ITEM-LAST-SEQ      Numeric 6                                 AM135   AM154
Element: Item Last SequThis is the last sequence number for      AM30.1
                       the last change to the item.


ATF-TO-IT-LAST-SEQ     Numeric 6                                 AM135   AM154
To Item Last           This is the last sequence number for      AM30.1  AM30.2
Sequence               the last change to the to-asset item.


ATF-COMPANY            Numeric 4                                 AM135   AM154
Element: Company       The company number represents an          AM30.1
                       established company and is entered on
                       all function codes.

ATF-TO-COMPANY         Numeric 4                                 AM135   AM154
Element: To Company    This is the company number for the        AM30.1
                       to-asset.


ATF-LOCATION-NAME      Alpha 15                                  AM135   AM154
Element: Location Name This is a user-defined location name      AM30.1
                       for the from-asset.


ATF-TO-LOCATION        Alpha 15                                  AM135   AM154
Element: To Location   This is the location for the to-asset.    AM30.1

ATF-DIVISION           Alpha 15                                  AM135   AM154
Element: Division      This is a user-defined division name      AM30.1
                       for the from-asset. Divisions can be
                       used in reporting on assets.


ATF-TO-DIVISION        Alpha 15                                  AM135   AM154
Element: To Division   This is the division name for the         AM30.1
                       to-asset.


ATF-ASSET-TYPE         Alpha 10                                  AM135   AM154
Element: Asset Type    An asset type represents a grouping of    AM30.1
                       like assets. Asset types are used to
                       group assets into reporting classes and
                       to default common asset definition data.



ATF-TO-ASSET-TYPE      Alpha 10                                  AM135   AM154
Element: To Asset Type This is the type for the to-asset. An     AM30.1
                       asset type represents a grouping of like
                       assets. Asset types are used to group
                       assets into reporting classes and to
                       default common asset definition data.


ATF-SUB-TYPE           Alpha 10                                  AM135   AM154
Element: Asset Subtype An asset subtype represents a more        AM30.1
                       detailed grouping of assets within an
                       asset type grouping. Asset subtypes are
                       used to group assets into reporting
                       classes and allow common asset
                       definition data to default. Subtypes
                       must be unique within an asset type.


ATF-TO-SUB-TYPE        Alpha 10                                  AM135   AM154
Element: To Asset SubtyThis is the to-asset subtype. An asset    AM30.1
                       subtype represents a more detailed
                       grouping of assets within an asset type
                       grouping. Asset subtypes are used to
                       group assets into reporting classes and
                       allow common asset definition data to
                       default. Subtypes must be unique within
                       an asset type.


ATF-ACCT-GRP           Alpha 10                                  AM135   AM154
Element: Account Group This is the user-defined account group    AM30.1
                       for the from-asset, identifying the
                       general ledger accounts used to create
                       journal entries when assets are
                       processed (added, adjusted, transferred,
                       or disposed of).


ATF-TO-ACCT-GRP        Alpha 10                                  AM135   AM154
Element: To Account GroThis is the account group for the         AM30.1
                       to-asset. An account group is a
                       user-defined grouping of accounts,
                       identifying the general ledger accounts
                       used to create journal entries when
                       assets are processed (added, adjusted,
                       transferred, or disposed of).



ATF-ACCT-UNIT          Alpha 15                                  AM135   AM154
Element: Accounting UniThis is the accounting unit for the       AM30.1
                       from-asset. An accounting unit is a
                       shorthand notation representing a
                       variable level number. The accounting
                       unit must be defined in the General
                       Ledger Names file as a posting
                       accounting unit.


ATF-TO-ACCT-UNIT       Alpha 15                                  AM135   AM154
Element: To Accounting This is the accounting unit for the       AM30.1
                       to-asset. An accounting unit is a
                       shorthand notation representing a
                       variable level number. The accounting
                       unit must be defined in the General
                       Ledger Names file as a posting
                       accounting unit.


ATF-AU-GROUP           Alpha 10                                  AM135   AM154
Accounting Unit        Accounting unit groups group and          AM30.1
Group                  identify the accounting units to use
                       when you create journal entries for
                       adding, adjusting, transferring, or
                       disposing of assets. Changes to
                       accounting unit groups are dynamic,
                       affecting all assets using the
                       accounting unit group. Accounting unit
                       group names are user-definable, and
                       accounting unit groups are set up by
                       company.

ATF-TO-AU-GROUP        Alpha 10                                  AM135   AM154
To Accounting Unit                                               AM30.1
Group

ATF-ORIG-CO            Numeric 4                                 AM135   AM154
Element: Original CompaThis field contains the original          AM30.1
                       company number when the asset record was
                       added to this file. This field is never
                       changed after being added.


ATF-SELECT-NAME        Alpha 15                                  AM135
Element: Selection NameThis is the name of the selection for
                       the mass transfer.


ATF-TO-LOC-DTL         Alpha 14                                  AM154   AM30.1
Element: To Loc Dtl    This is the location detail to which the
                       item is being transferred.

ATF-CREATION-DATE      Numeric 8  (yyyymmdd)                     AM135   AM154
Element: Creation Date This is the date that this transfer was   AM30.1
                       created.


ATF-CREATION-TIME      Numeric 6  (hhmmss)                       AM135   AM154
Element: Creation Time This is the time that the transfer was    AM30.1
                       created.


ATF-CREATOR-ID         Alpha 10                                  AM135   AM154
Element: Creator ID    This is the ID of the person who          AM30.1
                       created the transfer.


ATF-AST-DESCRIP        Derived
Element: Description   This is the description of the
                       transferred asset.


ATF-BLANKAM            Derived
Element: Blank         This field consists of blank spaces. It
                       is used to provide column headings on
                       Drill Arounds.


                         AMASSETTRF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ATFSET1   ASSET                                                  AM115   AM125
          PROCESS-SEQ                                            AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM230   AM235
                                                                 AM30.1  AM30.2
                                                                 AM30.3  AM300
                                                                 ...

ATFSET2   COMPANY       KeyChange, Subset                        AM230   AM235
          ASSET         Where TRF-STATUS = "R"
          PROCESS-SEQ

ATFSET3   LOCATION-NAME KeyChange, Subset
          ASSET         Where TRF-STATUS = "R"
          PROCESS-SEQ

ATFSET4   DIVISION      KeyChange, Subset
          ASSET         Where TRF-STATUS = "R"
          PROCESS-SEQ

ATFSET5   COMPANY       KeyChange, Subset
          ASSET-TYPE    Where TRF-STATUS = "R"
          SUB-TYPE
          ASSET
          PROCESS-SEQ

ATFSET6   TO-COMPANY    KeyChange, Subset                        AM115   AM125
          TO-ASSET      Where TRF-STATUS = "N"                   AM135   AM145
          ASSET                                                  AM15.1  AM15.2
          PROCESS-SEQ                                            AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM230   AM30.1
                                                                 AM30.2  AM30.3
                                                                 AM40.1  AM40.2
                                                                 ...

ATFSET7   ASSET         Subset                                   AM135   AM170
          PROCESS-SEQ   Where TRF-STATUS = "N"                   AM230   AM235
                                                                 AM30.1  AM30.2
                                                                 AM30.3

ATFSET8   ASSET         Subset
          PROCESS-SEQ   Where TRF-STATUS = "R"

ATFSET9   TO-COMPANY    KeyChange, Subset                        AM170   AM230
          TO-ASSET      Where TRF-STATUS = "R"                   AM235
          ASSET
          PROCESS-SEQ

                         AMASSETTRF FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amasset        AMASSET      Not Required

                            ATF-ASSET            -> AST-ASSET

Amassetto      AMASSET      Not Required

                            ATF-TO-ASSET         -> AST-ASSET

Amasttype      AMASTTYPE    Not Required

                            ATF-COMPANY          -> ATP-COMPANY
                            ATF-ASSET-TYPE       -> ATP-ASSET-TYPE
                            ATF-SUB-TYPE         -> ATP-SUB-TYPE

Amcontrol      AMCONTROL    Not Required

                            ATF-COMPANY          -> CTL-COMPANY

Amcontrolto    AMCONTROL    Not Required

                            ATF-TO-COMPANY       -> CTL-COMPANY

Amdivision     AMDIVISION   Not Required

                            ATF-DIVISION         -> DIV-DIVISION

Amlocation     AMLOCATION   Not Required

                            ATF-LOCATION-NAME    -> LOC-LOCATION-NAME

                         AMASSETTRF FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amastbktrf     AMASTBKTRF

                            ATF-ASSET            -> ABT-ASSET
                            ATF-PROCESS-SEQ      -> ABT-PROCESS-SEQ
                                                    ABT-BOOK