AMASSET FILE
Asset
The Asset file stores asset records. An asset record is a grouping of one or
more asset items that are grouped together, or "combined," for depreciation
purposes. The Asset file also contains many of the selection and sorting
fields that are used for reporting.
Each Asset file record has one or more related records in the Asset Item file
and may have related records in the Asset Book file.
REFERENCED BY
AC03.5 AC10.3 AC115 AC440 AC52.1 AC520
AM220 AM221 AM222 AM223 AM224 AM225
AM23.1 AM23.2 AM23.3 AM23.4 AM230 AM235
AM240 AM245 AM250 AM255 AM260 AM265
AM270 AM275 AM277 AM280 AM285 AM290
AM292 AM295 AM310 AM580 AM70.1 AM70.2
AM75.1 AM80.1 AM85.1 AM94.1 AP05.3 AP125
AP126 AP20.1 AP20.2 AP20.5 AP20.7 AP225
AP226 AP23.1 AP25.1 AP25.2 AP26.1 AP30.2
AP520 BL92.1 DR100 IC130 IC141 IC142
IC83.1 MX123 IN20.1 MA40.1 MA40.2 MA41.1
MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2
MA43.3 MA43.4 MA52.1 MA520 MA530 MA540
OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6
OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9
OE110 OE113 OE114 OE129 OE14.4 OE15.1
OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE810 OE830 OE920 OE950
PO100 PO135 PO180 PO20.1 PO21.1 PO21.2
PO21.3 PO21.5 PO21.6 PO22.1 PO22.2 PO22.3
PO25.1 PO25.2 PO25.4 PO26.1 PO28.6 PO30.1
PO31.1 PO32.1 PO33.1 PO34.1 PO35.1 PO530
PO821 PO990 RQ10.1 RQ10.2 RQ10.3 RQ11.1
RQ12.1 RQ13.1 RQ20.1 RQ20.3 RQ20.4 RQ35.1
RQ500 RQ990 WH130 WH132 WH190 WH20.2
WH20.7 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2
WH31.3 WH32.1 WH32.2 WH32.3 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2
WH520 WH830 WO132 WO140 AM01.1 AM01.2
AM01.3 AM120 AM180 AM185 AM35.1 AM45.1
AM60.1 AM90.1 AM90.2 AM95.1 AM95.2 AM07.1
AM07.2 AM12.1 AM08.1 AM08.2 AM05.1 AM06.1
AM06.2 AM09.1
UPDATED BY
AM115 AM118 AM125 AM135 AM145 AM15.1
AM15.2 AM15.3 AM15.4 AM170 AM18.1 AM18.2
AM190 AM192 AM195 AM20.1 AM20.2 AM20.3
AM20.4 AM20.5 AM20.6 AM30.1 AM30.2 AM30.3
AM300 AM40.1 AM40.2 AM40.3 AM40.4 AM50.1
AM500 AM700 AM951 AM952 AM956 AM957
AM96.1 AM97.1 AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AST-ASSET Numeric 10 AM115 AM135
Asset The asset number contains up to ten AM15.1 AM15.2
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 AM30.1
AM30.2 AM40.1
AM500 AM70.1
AM951 AM956
AM96.1 AM98.1
AST-DSP-ASSET Numeric 10 AM145 AM192
Disposal Asset If the asset is partially disposed of, AM40.1 AM956
this field contains the original asset
number of a new asset record that is
created due to the partial disposal. If
the asset is fully disposed of, this
field contains the same value as the
Asset field on this record.
AST-DESCRIPTION Alpha 30 (Lower Case) AM115 AM15.1
Description A description of the asset. AM15.2 AM15.3
AM15.4 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM500
AM951 AM956
AM96.1 AM98.1
AST-TAG-NBR Alpha 12 AM115 AM135
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 AM30.1
AM30.2 AM500
AM96.1 AM98.1
AST-ASSET-GROUP Alpha 10 AM115 AM125
Asset Group The asset group assigned to the asset. AM135 AM15.1
Represents a parent asset number used AM15.2 AM15.3
for report grouping. AM15.4 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM30.2
AM500 AM951
AM956 AM96.1
AM98.1
AST-OBJ-ID Numeric 12 AM115 AM135
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 AM30.1
AM30.2 AM40.1
AM500 AM951
AM956 AM96.1
AM98.1
AST-STATUS Numeric 1 AM115 AM125
Status This field identifies the transaction AM135 AM145
status of the asset record. Valid values AM15.1 AM15.2
are: AM15.3 AM15.4
AM170 AM192
1 = Entered. AM20.1 AM20.2
2 = Active (updated). AM20.3 AM20.4
3 = Post Active Process. AM20.5 AM20.6
9 = Disposed. AM30.1 AM30.2
AM40.1 AM500
AM951 AM956
AM96.1 AM98.1
AST-ASSET-PROCESS Alpha 3 AM115 AM125
Asset Process This field identifies whether the asset AM135 AM145
record is in the process of being AM15.1 AM15.2
adjusted, disposed of, or transferred. AM15.3 AM15.4
Valid values are: AM170 AM192
AM20.1 AM20.2
ADJ = Adjustment. The asset is currently AM20.3 AM20.4
in the adjustment process. AM20.5 AM20.6
AM30.1 AM30.2
DSP = Disposal. The asset is currently AM40.1 AM500
in the disposal process. AM951 AM956
AM96.1 AM98.1
TRF = Transfer. The asset is currently
in the transfer process.
Blank = The asset is not being adjusted,
disposed of, or transferred.
AST-PROCESS-DATE Numeric 8 (yyyymmdd) AM115 AM125
Process Date The last date an adjustment, disposal, AM135 AM145
or transfer was processed for the asset AM15.1 AM15.2
record. AM15.3 AM15.4
AM170 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM30.2
AM40.1 AM500
AM951 AM956
AM96.1 AM98.1
AST-ASSET-CATEGORY Alpha 1 AM115 AM15.1
Asset Category This field identifies whether the asset AM15.2 AM15.3
is depreciable. Valid values are: AM15.4 AM170
AM20.1 AM20.2
D = Depreciable. AM20.3 AM20.4
N = Non-Depreciable. AM20.5 AM20.6
AM30.1 AM500
AM951 AM956
AM96.1 AM98.1
AST-SIMULATED Alpha 1 AM115 AM125
Simulated This field identifies whether the asset AM15.1 AM15.2
is simulated, which means the asset is a AM15.3 AM15.4
representation, not a real asset. AM170 AM20.1
Simulated assets can be used to AM20.2 AM20.3
experiment and test strategies. AM20.4 AM20.5
AM20.6 AM30.1
N = No AM500 AM951
Y = Yes AM956 AM96.1
AM98.1
AST-WORK-IN-PROC Alpha 1 AM115 AM125
Work-in-Process This field identifies whether the asset AM15.1 AM15.2
is considered work in process, which AM15.3 AM15.4
means the asset is real, but not yet AM170 AM20.1
complete. If this field is Yes, the AM20.2 AM20.3
asset is on hold and cannot be released. AM20.4 AM20.5
Valid values are: AM20.6 AM30.1
AM500 AM951
N = No. AM956 AM96.1
Y = Yes. AM98.1
AST-TAX-EXEMPT Alpha 1 AM115 AM125
Tax Exempt This field identifies whether the asset AM15.1 AM15.2
is exempt from taxation. AM15.3 AM15.4
AM170 AM20.1
N = No AM20.2 AM20.3
Y = Yes AM20.4 AM20.5
AM20.6 AM30.1
AM500 AM951
AM956 AM96.1
AM98.1
AST-USED Alpha 1 AM115 AM125
Used This field identifies whether the asset AM15.1 AM15.2
has already been used at the time it was AM15.3 AM15.4
purchased. Valid values are: AM170 AM20.1
AM20.2 AM20.3
N = No. AM20.4 AM20.5
Y = Yes. AM20.6 AM30.1
AM500 AM951
AM956 AM96.1
AM98.1
AST-ITEM-TOT-QTY Numeric 10 AM115 AM135
Item Total Quantity The total number of items that make up AM15.1 AM15.2
this asset record. AM15.3 AM15.4
AM170 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM30.2
AM40.1 AM40.2
AM500 AM951
AM956 AM96.1
AM97.1 AM98.1
AST-IT-TOT-CSTBASE Signed 15.2 AM115 AM135
Item Total Cost Base The total cost of the asset items in AM15.1 AM15.2
company base currency. AM15.3 AM15.4
AM170 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM30.2
AM40.1 AM40.2
AM500 AM951
AM956 AM96.1
AM97.1 AM98.1
AST-IT-TOT-TAXBASE Signed 15.2 AM115 AM135
Item Total Tax Base The total tax amount associated with AM15.1 AM15.2
the asset items in the company base AM15.3 AM15.4
currency. AM170 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM30.2
AM40.1 AM40.2
AM500 AM951
AM956 AM96.1
AM97.1 AM98.1
AST-IT-TOT-CSTTRAN Signed 15.2 AM115 AM135
Item Total Cost Tran The total cost of the asset items in AM15.1 AM15.2
the currency of the transaction. AM15.3 AM15.4
AM170 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM30.2
AM40.1 AM40.2
AM500 AM951
AM956 AM96.1
AM97.1 AM98.1
AST-IT-TOT-TAXTRAN Signed 15.2 AM115 AM135
Item Total Tax Tran The total tax amount associated with AM15.1 AM15.2
the asset items in the currency of the AM15.3 AM15.4
transaction. AM170 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM30.2
AM40.1 AM40.2
AM500 AM951
AM956 AM96.1
AM97.1 AM98.1
AST-BASE-ND Numeric 1 AM115 AM135
Base Number of The number of decimal positions defined AM15.1 AM15.2
Decimals for the company base currency. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM30.1
AM30.2 AM500
AM951 AM956
AM96.1 AM98.1
AST-TRAN-ND Numeric 1 AM115 AM135
Tran Number of The number of decimal positions defined AM15.1 AM15.2
Decimals for the transaction currency. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM30.1
AM30.2 AM500
AM951 AM956
AM96.1 AM98.1
AST-CURRENCY-CODE Alpha 5 AM115 AM135
Currency Code The transaction currency code assigned AM15.1 AM15.2
to the asset. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM30.1
AM30.2 AM500
AM951 AM956
AM96.1 AM98.1
AST-ITEM-LAST-DATE Numeric 8 (yyyymmdd) AM115 AM135
Item Last Purchase The highest (latest) purchase date of AM15.1 AM15.2
Date all of the items that make up the asset. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM30.1
AM30.2 AM40.1
AM500 AM951
AM952 AM956
AM96.1 AM97.1
AM98.1
AST-ITEM-LAST-SEQ Numeric 6 AM115 AM135
Item Last Sequence The last sequence number assigned to an AM15.1 AM15.2
Number asset item for this asset record. AM15.3 AM15.4
AM192 AM20.1
AM20.3 AM30.1
AM30.2 AM40.1
AM500 AM951
AM952 AM956
AM97.1
AST-COMPANY Numeric 4 AM115 AM135
Company The general ledger company number AM15.1 AM15.2
associated with the asset record. Used AM15.3 AM15.4
for posting associated asset transaction AM170 AM20.1
entries to the general ledger. AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM30.1
AM30.2 AM500
AM951 AM956
AM96.1 AM98.1
AST-LOCATION-NAME Alpha 15 AM115 AM135
Location Name The location assigned to the asset. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM30.1
AM30.2 AM500
AM951 AM956
AM96.1 AM98.1
AST-DIVISION Alpha 15 AM115 AM135
Division The division assigned to the asset. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM30.1
AM30.2 AM500
AM951 AM956
AM96.1 AM98.1
AST-ASSET-TYPE Alpha 10 AM115 AM125
Asset Type This field identifies the asset type. AM135 AM15.1
Asset types are user-defined and AM15.2 AM15.3
represent a grouping of like assets. AM15.4 AM170
Asset types are used to group assets AM20.1 AM20.2
into reporting classes and to default AM20.3 AM20.4
common asset definition data. AM20.5 AM20.6
AM30.1 AM30.2
AM500 AM951
AM956 AM96.1
AM98.1
AST-SUB-TYPE Alpha 10 AM115 AM125
Asset Subtype This field identifies the asset AM135 AM15.1
subtype. An asset subtype represents a AM15.2 AM15.3
more detailed grouping of assets within AM15.4 AM170
an asset type. Asset subtypes are used AM20.1 AM20.2
to group assets into reporting classes AM20.3 AM20.4
and allow common asset definition data AM20.5 AM20.6
to default. AM30.1 AM30.2
AM500 AM951
AM956 AM96.1
AM98.1
AST-ACCT-GRP Alpha 10 AM115 AM125
Account Group This is the account group assigned to AM135 AM15.1
the asset. Account groups are AM15.2 AM15.3
user-defined and are used to identify AM15.4 AM170
the general ledger accounts used to AM20.1 AM20.2
create journal entries when assets are AM20.3 AM20.4
processed (added, adjusted, transferred, AM20.5 AM20.6
or disposed of). AM30.1 AM30.2
AM500 AM951
AM956 AM96.1
AM98.1
AST-ACCT-UNIT Alpha 15 AM115 AM125
Accounting Unit The default accounting unit that will AM135 AM15.1
be used, if necessary, to piece together AM15.2 AM15.3
with accounts from the Type, Subtype, AM15.4 AM170
and Account Group fields to make valid AM20.1 AM20.2
general ledger accounts. AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM30.2
AM500 AM700
AM951 AM956
AM96.1 AM98.1
AST-AU-GROUP Alpha 10 AM115 AM125
Accounting Unit Accounting unit groups group and AM135 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 AM30.1 AM30.2
accounting unit group. Accounting unit AM500 AM700
group names are user-definable, and AM951 AM96.1
accounting unit groups are set up by AM98.1
company.
AST-DEP-EXP-ACTVTY Alpha 15 AM115 AM125
Depreciation This is the override depreciation AM15.1 AM15.2
Expense 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 AM500
AM96.1 AM98.1
AST-DEP-ACCT-CAT Alpha 5 AM115 AM125
Depr Expense This is the override depreciation AM15.1 AM15.2
Account Category expense account category, which AM15.3 AM15.4
overrides any depreciation expense AM170 AM20.1
account category set up on AM06.1 AM20.2 AM20.3
(Type). This is the depreciation AM20.4 AM20.5
expense account category used for AM20.6 AM500
posting. AM96.1 AM98.1
AST-ORIG-CO Numeric 4 AM115 AM15.1
Original Company This field contains the original AM15.2 AM15.3
company number when the asset record is AM15.4 AM170
added to this file. This field is never AM20.1 AM20.2
changed after being added. AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM500
AM951 AM956
AM96.1 AM98.1
AST-ASSET-LAST-SEQ Numeric 6 AM115 AM125
Last Process The last sequence number assigned to AM135 AM145
Sequence Number the last process created for the asset. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM40.1
AM500 AM951
AM956 AM957
AM96.1 AM98.1
AST-TRAN-LAST-SEQ Numeric 6 AM115 AM118
Last Transaction The sequence number assigned to the AM125 AM135
Sequence Nbr last transaction created for the asset. AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM18.1
AM18.2 AM190
AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM20.6
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM500
AM951 AM956
AM98.1
AST-COMM-LAST-SEQ Numeric 6 AM50.1 AM951
Last Comment The sequence number of the last comment AM956
Sequence Number defined for the asset.
AST-CREATION-DATE Numeric 8 (yyyymmdd) AM115 AM135
Creation Date The date the asset record was created. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM30.1
AM30.2 AM40.1
AM500 AM951
AM956 AM96.1
AM98.1
AST-CREATION-TIME Numeric 6 (hhmmss) AM115 AM135
Creation Time The time the asset record was created. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM30.1
AM30.2 AM40.1
AM500 AM951
AM956 AM96.1
AM98.1
AST-CREATOR-ID Alpha 10 AM115 AM135
Creator ID This field identifies the operator who AM15.1 AM15.2
created the asset record. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM30.1
AM30.2 AM40.1
AM500 AM951
AM956 AM96.1
AM98.1
AST-ATP-PROPERTY Derived
Property Type This field identifies the kind of
property defined for the asset type,
such as personal, real, land, stock, or
other kinds of property.
AST-GL-NAME Derived
Company The name of the general ledger company
associated with the asset record.
AST-GL-CURR-CODE Derived
Currency Code The base currency defined for the
posting company associated with the
asset.
AST-GL-CHART Derived
Chart The chart name assigned to the posting
company associated with the asset.
AST-ACCT-UNIT-DESC Derived
Accounting Unit A description of the general ledger
Description accounting unit that is assigned to the
asset.
AST-ACCT-GRP-DESC Derived
Account Group A description of the account group
Description associated with the asset.
AST-LOC-DESC Derived
Location Description A description of the location
associated with the asset.
AST-DIV-DESC Derived
Division Description A description of the division
associated with the asset.
AST-TYPE-DESC Derived
Type Description A description of the asset type.
AST-ASD-DSP-METHOD Derived
Disposal Method If the asset is fully or partially
disposed of, this field identifies the
method by which the asset was disposed
of. Valid values are:
A = Abandoned.
D = Donated.
E = Exchanged.
P = Purged.
R = Retired.
S = Sold.
T = Traded.
O = Other.
AST-ASD-DSP-FL-PRT Derived
Full or Partial If the asset is disposed of, this field
identifies whether the asset is
partially or fully disposed of.
AST-ASD-DSP-DATE Derived
Disposal Date If the asset is disposed of, this field
identifies the date the asset was
partially or fully disposed of.
AST-ASD-DSP-PROP Derived
Disposal Property If the asset is disposed of, this field
identifies the disposal property code
assigned to the asset.
AST-ASD-DSP-QTY Derived
Disposal Quantity If the asset is partially or fully
disposed of, this field identifies the
number of units disposed of.
AST-ASD-PROC-CURR Derived
Proceeds Currency If the asset is sold (disposed of),
this field identifies the currency of
the proceeds from the sale.
AST-ASD-PROCEEDS Derived
Proceeds If the asset is sold (disposed of),
this field identifies the proceeds of
the sale in the proceeds currency.
AST-ASD-COS-CURR Derived
Disposal Expense If the asset is sold (disposed of),
Currency this field identifies the currency of
the expenses in selling it.
AST-ASD-COST-SALE Derived
Disposal Expense If the asset is sold (disposed of),
this field identifies the amount
received for the sale of the asset.
AST-BLANKAM Derived
Blank This field consists of blank spaces. It
is used to provide column headings on
Drill Arounds.
AMASSET FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ASTSET1 ASSET AC03.5 AC10.3
AC115 AC440
AC52.1 AC520
AM115 AM118
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM170
AM18.1 AM18.2
AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM20.8 AM220
AM221 AM222
...
ASTSET10 OBJ-ID AM220 AM221
AM222 AM223
AM224 AM225
AM23.2 AM23.3
AM23.4 AM230
AM235 AM240
AM245 AM250
AM255 AM260
AM265 AM275
AM277 AM280
AM285 AM290
AM292 AM295
MX123
ASTSET2 COMPANY KeyChange AM01.1 AM01.2
ASSET AM01.3 AM120
AM135 AM145
AM180 AM185
AM190 AM192
AM220 AM260
AM285 AM35.1
AM45.1 AM60.1
AM70.1 AM70.2
AM90.1 AM90.2
AM95.1 AM95.2
ASTSET3 STATUS KeyChange AM07.1 AM07.2
LOCATION-NAME AM115 AM12.1
DSP-ASSET AM125 AM15.1
ASSET AM15.2 AM15.3
AM15.4 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM500 AM60.1
AM96.1 AM98.1
ASTSET4 STATUS KeyChange AM08.1 AM08.2
DIVISION AM115 AM12.1
DSP-ASSET AM125 AM15.1
ASSET AM15.2 AM15.3
AM15.4 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM500 AM60.1
AM96.1 AM98.1
ASTSET5 STATUS KeyChange AM05.1 AM06.1
COMPANY AM06.2 AM09.1
ASSET-TYPE AM115 AM12.1
SUB-TYPE AM125 AM135
DSP-ASSET AM145 AM15.1
ASSET AM15.2 AM15.3
AM15.4 AM170
AM180 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
...
ASTSET6 STATUS KeyChange, Subset AM60.1 AM70.1
COMPANY Where ASSET-GROUP != Spaces AM70.2 AM90.1
ASSET-GROUP AM90.2 AM95.2
DSP-ASSET
ASSET
ASTSET7 STATUS KeyChange AM255 AM295
COMPANY AM60.1 AM70.1
LOCATION-NAME AM70.2 AM90.1
DIVISION AM90.2 AM95.2
ASSET-TYPE
SUB-TYPE
DSP-ASSET
ASSET
ASTSET8 DSP-ASSET KeyChange, Subset AM170 AM245
Where STATUS = 3 AM40.1
And ASSET-PROCESS = "DSP"
And DSP-ASSET != Zeroes
ASTSET9 STATUS KeyChange AM05.1 AM115
COMPANY AM12.1 AM125
DSP-ASSET AM135 AM145
ASSET AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM240 AM245
AM30.1 AM40.1
AM40.2 AM40.3
AM500 AM96.1
AM98.1
AMASSET FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amaccount Acm AMACCOUNT Not Required
AST-COMPANY -> AAC-COMPANY
Spaces -> AAC-ACCT-GRP
AST-ASSET-TYPE -> AAC-ASSET-TYPE
AST-SUB-TYPE -> AAC-SUB-TYPE
"ACM" -> AAC-ACCT-TYPE
Amaccount Ast AMACCOUNT Not Required
AST-COMPANY -> AAC-COMPANY
Spaces -> AAC-ACCT-GRP
AST-ASSET-TYPE -> AAC-ASSET-TYPE
AST-SUB-TYPE -> AAC-SUB-TYPE
"AST" -> AAC-ACCT-TYPE
Amaccount Clr AMACCOUNT Not Required
AST-COMPANY -> AAC-COMPANY
AST-ACCT-GRP -> AAC-ACCT-GRP
Spaces -> AAC-ASSET-TYPE
Spaces -> AAC-SUB-TYPE
"CLR" -> AAC-ACCT-TYPE
Amaccount Cos AMACCOUNT Not Required
AST-COMPANY -> AAC-COMPANY
AST-ACCT-GRP -> AAC-ACCT-GRP
Spaces -> AAC-ASSET-TYPE
Spaces -> AAC-SUB-TYPE
"COS" -> AAC-ACCT-TYPE
Amaccount Dgn AMACCOUNT Not Required
AST-COMPANY -> AAC-COMPANY
AST-ACCT-GRP -> AAC-ACCT-GRP
Spaces -> AAC-ASSET-TYPE
Spaces -> AAC-SUB-TYPE
"DGN" -> AAC-ACCT-TYPE
Amaccount Dls AMACCOUNT Not Required
AST-COMPANY -> AAC-COMPANY
AST-ACCT-GRP -> AAC-ACCT-GRP
Spaces -> AAC-ASSET-TYPE
Spaces -> AAC-SUB-TYPE
"DLS" -> AAC-ACCT-TYPE
Amaccount Exp AMACCOUNT Not Required
AST-COMPANY -> AAC-COMPANY
Spaces -> AAC-ACCT-GRP
AST-ASSET-TYPE -> AAC-ASSET-TYPE
AST-SUB-TYPE -> AAC-SUB-TYPE
"EXP" -> AAC-ACCT-TYPE
Amaccount Gan AMACCOUNT Not Required
AST-COMPANY -> AAC-COMPANY
AST-ACCT-GRP -> AAC-ACCT-GRP
Spaces -> AAC-ASSET-TYPE
Spaces -> AAC-SUB-TYPE
"GAN" -> AAC-ACCT-TYPE
Amaccount Los AMACCOUNT Not Required
AST-COMPANY -> AAC-COMPANY
AST-ACCT-GRP -> AAC-ACCT-GRP
Spaces -> AAC-ASSET-TYPE
Spaces -> AAC-SUB-TYPE
"LOS" -> AAC-ACCT-TYPE
Amaccount Pro AMACCOUNT Not Required
AST-COMPANY -> AAC-COMPANY
AST-ACCT-GRP -> AAC-ACCT-GRP
Spaces -> AAC-ASSET-TYPE
Spaces -> AAC-SUB-TYPE
"PRO" -> AAC-ACCT-TYPE
Amacctgrp AMACCTGRP Required
AST-COMPANY -> AAG-COMPANY
AST-ACCT-GRP -> AAG-ACCT-GRP
Amassetdsp AMASSETDSP Not Required
AST-ASSET -> ASD-ASSET
Amasttype AMASTTYPE Required
AST-COMPANY -> ATP-COMPANY
AST-ASSET-TYPE -> ATP-ASSET-TYPE
AST-SUB-TYPE -> ATP-SUB-TYPE
Amaugroup AMAUGROUP Not Required
AST-COMPANY -> AAU-COMPANY
AST-AU-GROUP -> AAU-AU-GROUP
Amcontrol AMCONTROL Not Required
AST-COMPANY -> CTL-COMPANY
Amdivision AMDIVISION Not Required
AST-DIVISION -> DIV-DIVISION
Amlocation AMLOCATION Not Required, Delete Restricted
AST-LOCATION-NAME -> LOC-LOCATION-NAME
Glnames GLNAMES Not Required
AST-COMPANY -> GLN-COMPANY
AST-ACCT-UNIT -> GLN-ACCT-UNIT
Glsystem GLSYSTEM Required
AST-COMPANY -> GLS-COMPANY
AMASSET FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Add Comments AMASTCOMM
AST-ASSET -> ASC-ASSET
"ADD" -> ASC-COMMENT-TYPES
ASC-COMMENT-DATE
ASC-SEQ-NUMBER
Adj Comments AMASTCOMM
AST-ASSET -> ASC-ASSET
"ADJ" -> ASC-COMMENT-TYPES
ASC-COMMENT-DATE
ASC-SEQ-NUMBER
Amassetadj AMASSETADJ
AST-ASSET -> ASA-ASSET
ASA-PROCESS-SEQ
Amassettrf AMASSETTRF
AST-ASSET -> ATF-ASSET
ATF-PROCESS-SEQ
Amastbkadj AMASTBKADJ
AST-ASSET -> ABA-ASSET
ABA-BOOK
ABA-PROCESS-SEQ
Amastbkdsp AMASTBKDSP
AST-ASSET -> ABD-ASSET
ABD-BOOK
Amastbktrf AMASTBKTRF
AST-ASSET -> ABT-ASSET
ABT-BOOK
ABT-PROCESS-SEQ
Amastbook AMASTBOOK Delete Restricted
AST-ASSET -> ASB-ASSET
ASB-BOOK
Amastitdsp AMASTITDSP
AST-ASSET -> ADS-ASSET
ADS-PROCESS-SEQ
ADS-SEQ-NUMBER
Amastitem AMASTITEM Delete Cascades
AST-ASSET -> ASI-ASSET
ASI-SEQ-NUMBER
Amastmxval AMASTMXVAL
AST-OBJ-ID -> MXT-OBJ-ID
MXT-MATRIX-CAT
Amastrpair AMASTRPAIR
AST-ASSET -> ASR-ASSET
ASR-REPAIR-DATE
ASR-SEQ-NUMBER
Amtrans AMTRANS
AST-ASSET -> AMT-ASSET
"R" -> AMT-TRANS-STATUS
AMT-COMPANY
AMT-BOOK
AMT-SEQ-NUMBER
Dsp Comments AMASTCOMM
AST-ASSET -> ASC-ASSET
"DSP" -> ASC-COMMENT-TYPES
ASC-COMMENT-DATE
ASC-SEQ-NUMBER
Trf Comments AMASTCOMM
AST-ASSET -> ASC-ASSET
"TRF" -> ASC-COMMENT-TYPES
ASC-COMMENT-DATE
ASC-SEQ-NUMBER
|