Lawson Insight Technical Documentation |
|
AMASSETADJ
AMASSETADJ FILE
Asset Adjustment
The Asset Adjustment file is an audit file that stores records of changes
that are made to Asset file records. Each asset adjustment record describes
the before and after values of asset fields that were changed, as well as the
date and time of the change and the operator who made the changes.
REFERENCED BY
AM135 AM145 AM154 AM190 AM192 AM225
AM30.1 AM30.2 AM30.3 AM40.1 AM40.2 AM40.3
AM40.4 AM41.1 AM41.2 AMDL.1
UPDATED BY
AM115 AM125 AM15.1 AM15.2 AM15.3 AM15.4
AM170 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5
AM20.6 AM21.1 AM21.2 AM21.3 AM21.4 AM21.5
AM21.6 AM300 AM500 AM51.1 AM551 AM96.1
AM97.1 AM98.1 AM330
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ASA-ASSET Numeric 10 AM115 AM125
Element: Asset Key field. The asset number contains up AM15.1 AM15.2
to ten numeric characters that uniquely AM15.3 AM15.4
identify an asset. Assets are AM170 AM20.1
automatically numbered system-wide. AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-PROCESS-SEQ Numeric 4 AM115 AM125
Element: Process SequenKey field. This is the process sequence AM15.1 AM15.2
number for the adjustment. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-ADJUST-STATUS Alpha 1 AM115 AM125
Element: Adjustment StaThis is the adjustment status. Valid AM15.1 AM15.2
values are: AM15.3 AM15.4
R = Released AM170 AM20.1
N = Not released. AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-ADJUST-DATE Numeric 8 (yyyymmdd) AM115 AM125
Element: Adjustment DatThis is the effective date of the AM15.1 AM15.2
adjustment. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-DESCRIPTION Alpha 30 (Lower Case) AM115 AM125
Element: Description This is the asset description. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-DESCRIPTION Alpha 30 (Lower Case) AM115 AM125
Element: To DescriptionThis is the to-asset description. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TAG-NBR Alpha 12 AM115 AM125
Element: Tag Number The tag is a user-definable identifier AM15.1 AM15.2
assigned to an asset. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-TAG-NBR Alpha 12 AM115 AM125
Element: To Tag Number This is the tag for the to-asset. A tag AM15.1 AM15.2
is a user-definable identifier assigned AM15.3 AM15.4
to an asset. AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-ASSET-GROUP Alpha 10 AM115 AM125
Element: Asset Group This is the asset group that the asset AM15.1 AM15.2
being adjusted belongs to. An asset AM15.3 AM15.4
group represents a parent asset number AM170 AM20.1
used to group assets for reporting. AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-ASSET-GROUP Alpha 10 AM115 AM125
Element: To Asset GroupThis is the asset group that the AM15.1 AM15.2
transfer-to asset belongs to. An asset AM15.3 AM15.4
group represents a parent asset number AM170 AM20.1
used to group assets for reporting. AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-OBJ-ID Numeric 12 AM115 AM125
Element: Object ID The object identifier is a unique key AM15.1 AM15.2
used to attach a list of user-defined AM15.3 AM15.4
attributes for the asset. AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-ASSET-CATEGORY Alpha 1 AM115 AM125
Element: Asset CategoryThis field indicates the asset AM15.1 AM15.2
category: depreciable or nondepreciable. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-AST-CATEG Alpha 1 AM115 AM125
Element: To Asset CategThis field indicates the to-asset AM15.1 AM15.2
category: depreciable or nondepreciable. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-SIMULATED Alpha 1 AM115 AM125
Element: Simulated This field indicates whether an asset AM15.1 AM15.2
is simulated. Simulated assets are AM15.3 AM15.4
imitative representations of assets, not AM170 AM20.1
real assets. AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-SIMULATED Alpha 1 AM115 AM125
Element: To Simulated This field indicates whether the AM15.1 AM15.2
transfer-to asset is simulated. AM15.3 AM15.4
Simulated assets are imitative AM170 AM20.1
representations of assets, not real AM20.2 AM20.3
assets. AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-WORK-IN-PROC Alpha 1 AM115 AM125
Element: Work-in-ProcesThis field indicates whether the asset AM15.1 AM15.2
is work-in-process. Work-in-process AM15.3 AM15.4
assets are real but not yet complete. If AM170 AM20.1
this field is Yes, the asset is on hold AM20.2 AM20.3
and cannot be released. AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-WORK-IN-PRC Alpha 1 AM115 AM125
Element: To Work-in-ProThis field indicates whether the AM15.1 AM15.2
transfer-to asset is work-in-process. AM15.3 AM15.4
Work-in-process assets are real but not AM170 AM20.1
yet complete. If this field is Yes, the AM20.2 AM20.3
AM20.4 AM20.5
asset is on hold and cannot be released. AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TAX-EXEMPT Alpha 1 AM115 AM125
Element: Tax Exempt This field indicates whether the asset AM15.1 AM15.2
is tax exempt. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-TAX-EXEMPT Alpha 1 AM115 AM125
Element: To Tax Exempt This field indicates whether the AM15.1 AM15.2
to-asset is tax exempt. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-USED Alpha 1 AM115 AM125
Element: Used This field indicates whether the asset AM15.1 AM15.2
is used. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-USED Alpha 1 AM115 AM125
Element: To Used This field indicates whether the to- AM15.1 AM15.2
asset is used. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-ITEM-TOT-QTY Numeric 10 AM115 AM125
Element: Item Total QuaThis is the total item quantity. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-IT-TOT-QTY Numeric 10 AM115 AM125
To Item Total This is the total item quantity for the AM15.1 AM15.2
Quantity to-asset. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
ASA-IT-TOT-CSTBASE Signed 15.2 AM115 AM125
Element: Item Total CosThis is the total item cost in the base AM15.1 AM15.2
currency. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-IT-TOTCSTBS Signed 15.2 AM115 AM125
To Item Total Cost This is the total item cost for the AM15.1 AM15.2
Base to-asset in the base currency. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
ASA-IT-TOT-TAXBASE Signed 15.2 AM115 AM125
Element: Item Total TaxThis is the total item tax in the base AM15.1 AM15.2
currency. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-IT-TOTTAXBS Signed 15.2 AM115 AM125
To Item Total Tax This is the total item tax for the AM15.1 AM15.2
Base to-asset in the base currency. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
ASA-IT-TOT-CSTTRAN Signed 15.2 AM115 AM125
Element: Item Total CosThis is the total item cost in the AM15.1 AM15.2
transaction currency. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-IT-TOTCSTTR Signed 15.2 AM115 AM125
To Item Total Cost This is the total item cost for the to- AM15.1 AM15.2
Tran asset in the transaction currency. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
ASA-IT-TOT-TAXTRAN Signed 15.2 AM115 AM125
Element: Item Total TaxThis is the total item tax in the AM15.1 AM15.2
transaction currency. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-IT-TOTTAXTR Signed 15.2 AM115 AM125
To Item Total Tax This is the total item tax for the AM15.1 AM15.2
Tran to-asset in the transaction currency. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
ASA-BASE-ND Numeric 1 AM115 AM125
Base Number of AM15.1 AM15.2
Decimals AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TRAN-ND Numeric 1 AM115 AM125
Tran Number of This is the number of decimal positions AM15.1 AM15.2
Decimals defined for the transaction currency. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-TRAN-ND Numeric 1 AM115 AM125
To Tran Number of This is the number of decimal positions AM15.1 AM15.2
Decimals defined for the to-asset transaction AM15.3 AM15.4
currency. AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-CURRENCY-CODE Alpha 5 AM115 AM125
Element: Currency Code This field contains the company base AM15.1 AM15.2
currency code established in Company AM15.3 AM15.4
(GL10.1 ). AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-CURR-CODE Alpha 5 AM115 AM125
Element: To Currency Code AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-ITEM-LAST-DATE Numeric 8 (yyyymmdd) AM115 AM125
Element: Item Last DateThis is the last adjustment date for AM15.1 AM15.2
the item. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-IT-LAST-DT Numeric 8 (yyyymmdd) AM115 AM125
Element: To Item Last DThis is the last adjustment date for AM15.1 AM15.2
the item for the to-asset. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
ASA-COMPANY Numeric 4 AM115 AM125
Element: Company The company number represents an AM15.1 AM15.2
established company and is entered on AM15.3 AM15.4
all function codes. AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-COMPANY Numeric 4 AM115 AM125
Element: To Company AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-LOCATION-NAME Alpha 15 AM115 AM125
Element: Location Name A user-defined location name which AM15.1 AM15.2
represents where an asset is physically AM15.3 AM15.4
located. AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-LOCATION Alpha 15 AM115 AM125
Element: To Location This is the location for the to-asset. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-DIVISION Alpha 15 AM115 AM125
Element: Division A user-defined division which is used AM15.1 AM15.2
for reporting assets. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-DIVISION Alpha 15 AM115 AM125
Element: To Division This is the division for the to-asset. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-ASSET-TYPE Alpha 10 AM115 AM125
Element: Asset Type An asset type represents a grouping of AM15.1 AM15.2
like assets. Asset types are used to AM15.3 AM15.4
group assets into reporting classes and AM170 AM20.1
to default common asset definition data. AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-ASSET-TYPE Alpha 10 AM115 AM125
Element: To Asset Type This is the asset type for the AM15.1 AM15.2
to-asset. An asset type represents a AM15.3 AM15.4
grouping of like assets. Asset types are AM170 AM20.1
used to group assets into reporting AM20.2 AM20.3
classes and to default common asset AM20.4 AM20.5
definition data. AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-SUB-TYPE Alpha 10 AM115 AM125
Element: Asset Subtype An asset subtype represents a more AM15.1 AM15.2
detailed grouping of assets within an AM15.3 AM15.4
asset type grouping. Asset subtypes are AM170 AM20.1
used to group assets into reporting AM20.2 AM20.3
classes and allow common asset AM20.4 AM20.5
definition data to default. Subtypes AM20.6 AM21.1
must be unique within an asset type. AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-SUB-TYPE Alpha 10 AM115 AM125
Element: To Subtype This is the subtype for the to-asset. AM15.1 AM15.2
An asset subtype represents a more AM15.3 AM15.4
detailed grouping of assets within an AM170 AM20.1
asset type grouping. Asset subtypes are AM20.2 AM20.3
used to group assets into reporting AM20.4 AM20.5
classes and allow common asset AM20.6 AM21.1
definition data to default. Subtypes AM21.2 AM21.3
must be unique within an asset type. AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-ACCT-GRP Alpha 10 AM115 AM125
Element: Account Group A user-defined account group which AM15.1 AM15.2
identifies the general ledger accounts AM15.3 AM15.4
that are used to create journal entries AM170 AM20.1
when assets are processed (added, AM20.2 AM20.3
adjusted, transferred, or disposed of). AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-ACCT-GRP Alpha 10 AM115 AM125
Element: To Account GroThis is the account group for the AM15.1 AM15.2
to-asset. An account group is a AM15.3 AM15.4
user-defined group that identifies the AM170 AM20.1
general ledger accounts used to create AM20.2 AM20.3
journal entries when assets are AM20.4 AM20.5
processed (added, adjusted, transferred, AM20.6 AM21.1
or disposed of). AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-ACCT-UNIT Alpha 15 AM115 AM125
Element: Accounting UniThe accounting unit is a shorthand AM15.1 AM15.2
notation representing the variable level AM15.3 AM15.4
number. When used in the General Ledger AM170 AM20.1
Account Master file, the accounting unit AM20.2 AM20.3
must be defined in the General Ledger AM20.4 AM20.5
Names file as a posting accounting unit. AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-ACCT-UNIT Alpha 15 AM115 AM125
Element: To Accounting This is the accounting unit for the AM15.1 AM15.2
to-asset. The accounting unit must be AM15.3 AM15.4
defined in the General Ledger Names file AM170 AM20.1
as a posting accounting unit. AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-AU-GROUP Alpha 10 AM115 AM125
Accounting Unit Accounting unit groups group and AM15.1 AM15.2
Group identify the accounting units to use AM15.3 AM15.4
when you create journal entries for AM170 AM20.1
adding, adjusting, transferring, or AM20.2 AM20.3
disposing of assets. Changes to AM20.4 AM20.5
accounting unit groups are dynamic, AM20.6 AM21.1
affecting all assets using the AM21.2 AM21.3
accounting unit group. Accounting unit AM21.4 AM21.5
group names are user-definable, and AM21.6 AM500
accounting unit groups are set up by AM551 AM96.1
company. AM98.1
ASA-TO-AU-GROUP Alpha 10 AM115 AM125
To Accounting Unit AM15.1 AM15.2
Group AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-DEP-EXP-ACTVTY Alpha 15 AM115 AM125
Depr Expense This is the override depreciation AM15.1 AM15.2
Activity expense activity, which overrides any AM15.3 AM15.4
depreciation expense activity set up on AM170 AM20.1
AM06.1 (Type). This is the depreciation AM20.2 AM20.3
expense activity used for posting. AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-DEP-EXP-ATY Alpha 15 AM115 AM125
To Depr Expense AM15.1 AM15.2
Activity AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-DEP-ACCT-CAT Alpha 5 AM115 AM125
Depr Expense Acct AM15.1 AM15.2
Category AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-TO-DEP-ACCTCAT Alpha 5 AM115 AM125
To Depr Expense AM15.1 AM15.2
Acct Category AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-ORIG-CO Numeric 4 AM115 AM125
Element: Original Company AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-CREATION-DATE Numeric 8 (yyyymmdd) AM115 AM125
Element: Creation Date This is the date this adjustment was AM15.1 AM15.2
created. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-CREATION-TIME Numeric 6 (hhmmss) AM115 AM125
Element: Creation Time AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-CREATOR-ID Alpha 10 AM115 AM125
Element: Creator ID This is the identifier of the person AM15.1 AM15.2
who created this adjustment. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-LEASE-COMPANY Numeric 4 AM115 AM125
Element: Lease Company AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-LEASE Alpha 19 AM115 AM125
Element: Lease AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-CLASSIFICATION Alpha 1 AM115 AM125
Element: Classification AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-CLASS-TO Alpha 1 AM115 AM125
Element: Class To AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
ASA-INV-FLAG Alpha 1 AM115 AM15.1
Element: Inv Flag This required flag denotes whether an AM15.2 AM15.3
asset should be part of a physical AM15.4 AM170
inventory. It defaults fro Type, but AM20.1 AM20.2
may be overridden on Addition and AM20.3 AM20.4
Adjustment. AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM551
AM96.1 AM98.1
ASA-TO-INV-FLAG Alpha 1 AM115 AM15.1
Element: To Inv Flag This is the "To" inventory flag field, AM15.2 AM15.3
denoting whether the asset will be part AM15.4 AM170
of the inventory after the adjustment. AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM551
AM96.1 AM98.1
ASA-ASSET-OWNER Alpha 10 AM115 AM15.1
Element: Asset Owner This is the individual responsible for AM15.2 AM15.3
the asset, for asset tracking and AM15.4 AM170
management purposes. AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM551
AM96.1 AM98.1
ASA-TO-ASSET-OWNER Alpha 10 AM115 AM15.1
Element: To Asset OwnerThis is the new asset owner, if the AM15.2 AM15.3
asset owner is changed in the adjustment AM15.4 AM170
process. AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM551
AM96.1 AM98.1
AMASSETADJ FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ASASET1 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
AM225 AM30.1
AM30.2 AM30.3
AM300 AM330
...
ASASET2 COMPANY Subset AM125 AM20.2
ASSET Where ADJUST-STATUS = "R" AM21.2 AM225
PROCESS-SEQ
ASASET3 LOCATION-NAME Subset
ASSET Where ADJUST-STATUS = "R"
PROCESS-SEQ
ASASET4 DIVISION Subset
ASSET Where ADJUST-STATUS = "R"
PROCESS-SEQ
ASASET5 COMPANY Subset
ASSET-TYPE Where ADJUST-STATUS = "R"
SUB-TYPE
ASSET
PROCESS-SEQ
ASASET7 ASSET Subset AM115 AM125
Where ADJUST-STATUS = "N" AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM225
AM500 AM51.1
AM551 AM96.1
AM97.1 AM98.1
ASASET8 COMPANY Subset AM125
ASSET Where ADJUST-STATUS = "N"
PROCESS-SEQ
AMASSETADJ FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amasset AMASSET Not Required
ASA-ASSET -> AST-ASSET
Amasttype AMASTTYPE Not Required
ASA-COMPANY -> ATP-COMPANY
ASA-ASSET-TYPE -> ATP-ASSET-TYPE
ASA-SUB-TYPE -> ATP-SUB-TYPE
Amcontrol AMCONTROL Not Required
ASA-COMPANY -> CTL-COMPANY
Amcontrolto AMCONTROL Not Required
ASA-TO-COMPANY -> CTL-COMPANY
Amdivision AMDIVISION Not Required
ASA-DIVISION -> DIV-DIVISION
Amlocation AMLOCATION Not Required
ASA-LOCATION-NAME -> LOC-LOCATION-NAME
AMASSETADJ FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amastbkadj AMASTBKADJ
ASA-ASSET -> ABA-ASSET
ASA-PROCESS-SEQ -> ABA-PROCESS-SEQ
ABA-BOOK
|