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.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
AST-ASSET
Element: Asset | Numeric 10
The asset number contains up to ten
numeric characters that uniquely
identify an asset. Assets are
automatically numbered system-wide.
|
|
AST-DSP-ASSET
Element: Disposal Asset | Numeric 10
If the asset is partially disposed of,
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
Element: Description | Alpha 30 (Lower Case)
A description of the asset.
|
|
AST-CLASSIFICATION
Element: Classification | Alpha 1
This field contains the asset's
classification. Capital and Operating
refer to leased assets; Purchased refers
to non-leased assets. Valid values are:
P = Purchased
C = Capital
O = Operating
|
|
AST-LEASE-COMPANY
Element: Company | Numeric 4
The lessor company for the leased asset.
|
|
AST-LEASE
Element: Lease | Alpha 19
The lease number associated with a
leased asset.
|
|
AST-TAG-NBR
Element: Tag Number | Alpha 12
The tag is a user definable identifier
assigned to an asset.
|
|
AST-ASSET-GROUP
Element: Asset Group | Alpha 10
The asset group assigned to the asset.
Represents a parent asset number used
for report grouping.
|
|
AST-OBJ-ID
Element: Object ID | Numeric 12
The object identifier is a unique key
used to attach a list of user-defined
attributes for the asset.
|
|
AST-STATUS
Element: Status | Numeric 1
This field identifies the transaction
status of the asset record. Valid values
are:
1 = Entered.
2 = Active (updated).
3 = Post Active Process.
9 = Disposed.
|
|
AST-ASSET-PROCESS
Element: Asset Process | Alpha 3
This field identifies whether the asset
record is in the process of being
adjusted, disposed of, or transferred.
Valid values are:
ADJ = Adjustment
DSP = Disposal
TRF = Transfer
Blank = The asset is not being adjusted,
disposed of, or transferred.
RIN = Reinstate
ADD |
|
AST-PROCESS-DATE
Element: Process Date | Numeric 8 (yyyymmdd)
The last date an adjustment, disposal,
or transfer was processed for the asset
record.
|
|
AST-ASSET-CATEGORY
Element: Asset Category | Alpha 1
This field identifies whether the asset
is depreciable. Valid values are:
D = Depreciable.
N = Non-Depreciable.
|
|
AST-SIMULATED
Element: Simulated | Alpha 1
This field identifies whether the asset
is simulated, which means the asset is a
representation, not a real asset.
Simulated assets can be used to
experiment and test strategies. Valid
values are:
Y = Yes
N = No
|
|
AST-WORK-IN-PROC
Element: Work-in-Process | Alpha 1
This field identifies whether the asset
is considered work in process, which
means the asset is real, but not yet
complete. If this field is Yes, the
asset is on hold and cannot be released.
Valid values are:
N = No.
Y = Yes.
|
|
AST-TAX-EXEMPT
Element: Tax Exempt | Alpha 1
This field identifies whether the asset
is exempt from taxation. Valid values
are:
Y = Yes
N = No
|
|
AST-USED
Element: Used | Alpha 1
This field identifies whether the asset
has already been used at the time it was
purchased. Valid values are:
N = No.
Y = Yes.
|
|
AST-ITEM-TOT-QTY
Element: Item Total Quantity | Numeric 10
The total number of items that make up
this asset record.
|
|
AST-IT-TOT-CSTBASE
Element: Item Total Cost Base | Signed 18.2
The total cost of the asset items in
company base currency.
|
|
AST-IT-TOT-TAXBASE
Element: Item Total Tax Base | Signed 18.2
The total tax amount associated with
the asset items in the company base
currency.
|
|
AST-IT-TOT-CSTTRAN
Element: Item Total Cost Tran | Signed 18.2
The total cost of the asset items in
the currency of the transaction.
|
|
AST-IT-TOT-TAXTRAN
Element: Item Total Tax Tran | Signed 18.2
The total tax amount associated with
the asset items in the currency of the
transaction.
|
|
AST-BASE-ND
Base Number of
Decimals | Numeric 1
The number of decimal positions defined
for the company base currency.
|
|
AST-TRAN-ND
Tran Number of
Decimals | Numeric 1
The number of decimals assigned to a
particular account as determined by the
account currency.
|
|
AST-CURRENCY-CODE
Element: Currency Code | Alpha 5
The transaction currency code assigned
to the asset.
|
|
AST-ITEM-LAST-DATE
Item Last Purchase
Date | Numeric 8 (yyyymmdd)
The highest (latest) purchase date of
all of the items that make up the asset.
|
|
AST-ITEM-LAST-SEQ
Item Last Sequence
Number | Numeric 6
The last sequence number assigned to an
asset item for this asset record.
|
|
AST-COMPANY
Element: Company | Numeric 4
The general ledger company number
associated with the asset record. Used
for posting associated asset transaction
entries to the general ledger.
|
|
AST-LOCATION-NAME
Element: Location Name | Alpha 15
The location assigned to the asset.
|
|
AST-DIVISION
Element: Division | Alpha 15
The division assigned to the asset.
|
|
AST-ASSET-TYPE
Element: Asset Type | Alpha 10
This field identifies the asset type.
Asset types are user-defined and
represent a grouping of like assets.
Asset types are used to group assets
into reporting classes and to default
common asset definition data.
|
|
AST-SUB-TYPE
Element: Asset Subtype | Alpha 10
This field identifies the asset
subtype. An asset subtype represents a
more detailed grouping of assets within
an asset type. Asset subtypes are used
to group assets into reporting classes
and allow common asset definition data
to default.
|
|
AST-ACCT-GRP
Element: Account Group | Alpha 10
This is the account group assigned to
the asset. Account groups are
user-defined and are used to identify
the general ledger accounts used to
create journal entries when assets are
processed (added, adjusted, transferred,
or disposed of).
|
|
AST-ACCT-UNIT
Element: Accounting Unit | Alpha 15
The default accounting unit that will
be used, if necessary, to piece together
with accounts from the Type, Subtype,
and Account Group fields to make valid
general ledger accounts.
|
|
AST-AU-GROUP
Accounting Unit
Group | Alpha 10
Accounting unit groups group and
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.
|
|
AST-ACTIVITY
Element: Activity | Alpha 15
Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
|
|
AST-DEP-EXP-ACTVTY
Depreciation
Expense Activity | Alpha 15
Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
|
|
AST-DEP-ACCT-CAT
Depr Expense
Account Category | Alpha 5
Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
|
|
AST-ORIG-CO
Element: Original Company | Numeric 4
Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
|
|
AST-ASSET-LAST-SEQ
Last Process
Sequence Number | Numeric 6
The last sequence number assigned to
the last process created for the asset.
|
|
AST-TRAN-LAST-SEQ
Last Transaction
Sequence Nbr | Numeric 6
The sequence number assigned to the
last transaction created for the asset.
|
|
AST-COMM-LAST-SEQ
Last Comment
Sequence Number | Numeric 6
The sequence number of the last comment
defined for the asset.
|
|
AST-CREATION-DATE
Element: Creation Date | Numeric 8 (yyyymmdd)
The date the asset record was created.
|
|
AST-CREATION-TIME
Element: Creation Time | Numeric 6 (hhmmss)
The time the asset record was created.
|
|
AST-CREATOR-ID
Element: Creator ID | Alpha 10
This field identifies the operator who
created the asset record.
|
|
AST-INV-FLAG
Element: Inv Flag | Alpha 1
**Field purpose
You can indicate whether the asset
should be included as part of the
physical inventory. This value defaults
from the asset type and can be
overridden when the asset is created. If
the asset is not part of the physical
inventory, it will be ignored in the
inventory reports.
Valid values are:
Y = Yes
N = No
|
|
AST-ASSET-OWNER
Element: Asset Owner | Alpha 10
This field contains the name of the
person responsible for keeping track of
the asset in invnetory.
|
|
AST-ATP-PROPERTY
Element: Property Type | Derived
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
Element: Company | Derived
The name of the general ledger company
associated with the asset record.
|
|
AST-GL-CURR-CODE
Element: Currency Code | Derived
The base currency defined for the
posting company associated with the
asset.
|
|
AST-GL-CHART
Element: Chart | Derived
The chart name assigned to the posting
company associated with the asset.
|
|
AST-ACCT-UNIT-DESC
Accounting Unit
Description | Derived
A description of the general ledger
accounting unit that is assigned to the
asset.
|
|
AST-ACCT-GRP-DESC
Account Group
Description | Derived
A description of the account group
associated with the asset.
|
|
AST-LOC-DESC
Element: Location Description | Derived
A description of the location
associated with the asset.
|
|
AST-DIV-DESC
Element: Division Description | Derived
A description of the division
associated with the asset.
|
|
AST-TYPE-DESC
Element: Type Description | Derived
A description of the asset type.
|
|
AST-ASD-DSP-METHOD
Element: Disposal Method | Derived
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
Element: Full or Partial | Derived
If the asset is disposed of, this field
identifies whether the asset is
partially or fully disposed of.
|
|
AST-ASD-DSP-DATE
Element: Disposal Date | Derived
If the asset is disposed of, this field
identifies the date the asset was
partially or fully disposed of.
|
|
AST-ASD-DSP-PROP
Element: Disposal Property | Derived
If the asset is disposed of, this field
identifies the disposal property code
assigned to the asset.
|
|
AST-ASD-DSP-QTY
Element: Disposal Quantity | Derived
If the asset is partially or fully
disposed of, this field identifies the
number of units disposed of.
|
|
AST-ASD-PROC-CURR
Element: Proceeds Currency | Derived
If the asset is sold (disposed of),
this field identifies the currency of
the proceeds from the sale.
|
|
AST-ASD-PROCEEDS
Element: Proceeds | Derived
If the asset is sold (disposed of),
this field identifies the proceeds of
the sale in the proceeds currency.
|
|
AST-ASD-COS-CURR
Disposal Expense
Currency | Derived
If the asset is sold (disposed of),
this field identifies the currency of
the expenses in selling it.
|
|
AST-ASD-COST-SALE
Element: Disposal Expense | Derived
If the asset is sold (disposed of),
this field identifies the amount
received for the sale of the asset.
|
|
AST-BLANKAM
Element: Blank | Derived
This field consists of blank spaces. It
is used to provide column headings on
Drill Arounds.
|
|
AST-CLEARING-AU
Element: Clearing Au | Derived
|
|
AST-ASSET-AU
Element: Asset Au | Derived
|
|
AST-ACCUM-AU
Element: Accum Au | Derived
|
|
AST-DEPR-EXP-AU
Element: Depr Exp Au | Derived
|
|
AST-COST-AU
Element: Cost Au | Derived
|
|
AST-PROCEEDS-AU
Element: Proceeds Au | Derived
|
|
AST-GAIN-AU
Element: Gain Au | Derived
|
|
AST-LOSS-AU
Element: Loss Au | Derived
|
|
AST-DEF-GAIN-AU
Element: Def Gain Au | Derived
|
|
AST-DEF-LOSS-AU
Element: Def Loss Au | Derived
|
|
AST-OVRD-ACTIVITY
Element: Ovrd Activity | Derived
|
|
AST-OVRD-ACCT-CAT
Element: Ovrd Acct Cat | Derived
|
|
AST-REINSTATE-DATE
Element: Reinstate Date | Numeric 8 (yyyymmdd)
The date of the last disposal
reinstatement.
|
|
AST-REINSTATE-FLAG
Element: Reinstate Flag | Alpha 1
This field indicates that the disposal
has been reinstated.
N = No
Y = Yes |
|
AST-GEO-TYPE
Element: Customer Code | Alpha 4
|
|
AST-GEO-LATITUDE
Element: Gis Coordinate | Signed 12.6
|
|
AST-GEO-LONGITUDE
Element: Gis Coordinate | Signed 12.6
|
|
AST-GEO-ALTITUDE
Element: Gis Coordinate | Signed 12.6
|
|
AST-GEO-DATE
Element: Date | Numeric 8 (yyyymmdd)
|
|
AST-GEO-TIME
Element: Sys Time | Numeric 6 (hhmmss)
|
|
AST-CONCUR-NBR
Element: Num Of Dep | Numeric 2
|
|
RELATION
NAME |
RELATED 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 |
| Spaces | -> | AAC-ASSET-EVENT |
|
| 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 |
| Spaces | -> | AAC-ASSET-EVENT |
|
| 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 |
| Spaces | -> | AAC-ASSET-EVENT |
|
| 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 |
| Spaces | -> | AAC-ASSET-EVENT |
|
| 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 |
| Spaces | -> | AAC-ASSET-EVENT |
|
| 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 |
| Spaces | -> | AAC-ASSET-EVENT |
|
| 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 |
| Spaces | -> | AAC-ASSET-EVENT |
|
| 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 |
| Spaces | -> | AAC-ASSET-EVENT |
|
| 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 |
| Spaces | -> | AAC-ASSET-EVENT |
|
| 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 |
| Spaces | -> | AAC-ASSET-EVENT |
|
| Amacct Acm Add |
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 |
| "1" | -> | AAC-ASSET-EVENT |
|
| Amacct Acm Adj |
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 |
| "2" | -> | AAC-ASSET-EVENT |
|
| Amacct Acm Dsp |
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 |
| "4" | -> | AAC-ASSET-EVENT |
|
| Amacct Acm Rin |
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 |
| "5" | -> | AAC-ASSET-EVENT |
|
| Amacct Acm Trf |
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 |
| "3" | -> | AAC-ASSET-EVENT |
|
| Amacct Ast Add |
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 |
| "1" | -> | AAC-ASSET-EVENT |
|
| Amacct Ast Adj |
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 |
| "2" | -> | AAC-ASSET-EVENT |
|
| Amacct Ast Dsp |
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 |
| "4" | -> | AAC-ASSET-EVENT |
|
| Amacct Ast Rin |
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 |
| "5" | -> | AAC-ASSET-EVENT |
|
| Amacct Ast Trf |
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 |
| "3" | -> | AAC-ASSET-EVENT |
|
| Amacctgrp |
AMACCTGRP |
Required
| AST-COMPANY | -> | AAG-COMPANY |
| AST-ACCT-GRP | -> | AAG-ACCT-GRP |
|
| Amassetbod |
AMASSETBOD |
Not Required, Delete Cascades
|
| Amassetdsp |
AMASSETDSP |
Not Required
|
| Amassetgrp |
AMASSETGRP |
Not Required
| AST-ASSET-GROUP | -> | ATG-ASSET-GROUP |
|
| 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
|
| 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
|
| Lmlease |
LMLEASE |
Not Required
| AST-LEASE-COMPANY | -> | LSE-COMPANY |
| AST-LEASE | -> | LSE-LEASE |
|
