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