AMASSET – Asset

System
Asset Management (AM)
Prefix
AST
Primary key
ASSET
Fields
87
Updated by
300 programs
Referenced by
144 programs

AMASSET is the Asset table in Lawson Asset Management (prefix AST). It is indexed by ASSET (ASTSET1); alternate indexes: ASTSET10, ASTSET11, ASTSET12, ASTSET13, ASTSET2, ASTSET3, ASTSET4, ASTSET5 and 4 more. It is related 1:1 to AMACCOUNT, AMACCTGRP, AMASSETBOD, AMASSETDSP, AMASSETGRP, AMASTTYPE, AMAUGROUP, AMCONTROL and 5 more and 1:M to AMASSETADJ, AMASSETRIN, AMASSETTRF, AMASTBKADJ, AMASTBKDSP, AMASTBKTRF, AMASTBOOK, AMASTITDSP and 5 more. It is updated by AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 and 292 more and referenced by AC03.5, AC03.7, AC10.1, AC10.3, AC145, AC17.5, AC18.4, AC191 and 136 more. The table has 87 fields, 13 indexes and 46 documented relations.

About AMASSET

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.

Fields (87)

Column = COBOL field name without the AST- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
AST-ASSET PK
ASSET
Numeric 10The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-DSP-ASSET
DSP_ASSET
Numeric 10If 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.AM145, AM154, AM170, AM192, AM40.1, AM41.1
AST-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)A description of the asset.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
AST-CLASSIFICATION
CLASSIFICATION
Alpha 1This 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
AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
AST-LEASE-COMPANY
LEASE_COMPANY
Numeric 4The lessor company for the leased asset.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-LEASE
LEASE
Alpha 19The lease number associated with a leased asset.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-TAG-NBR
TAG_NBR
Alpha 12The tag is a user definable identifier assigned to an asset.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
AST-ASSET-GROUP
ASSET_GROUP
Alpha 10The asset group assigned to the asset. Represents a parent asset number used for report grouping.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
AST-OBJ-ID
OBJ_ID
Numeric 12The object identifier is a unique key used to attach a list of user-defined attributes for the asset.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-STATUS
STATUS
Numeric 1This field identifies the transaction status of the asset record. Valid values are:
  • 1 Entered.
  • 2 Active (updated).
  • 3 Post Active Process.
  • 9 Disposed.
AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
AST-ASSET-PROCESS
ASSET_PROCESS
Alpha 3This field identifies whether the asset record is in the process of being adjusted, disposed of, or transferred. Valid values are: disposed of, or transferred. ADD
  • ADJ Adjustment
  • DSP Disposal
  • TRF Transfer
  • Blank The asset is not being adjusted,
  • RIN Reinstate
AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
AST-PROCESS-DATE
PROCESS_DATE
Numeric 8 (yyyymmdd)The last date an adjustment, disposal, or transfer was processed for the asset record.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
AST-ASSET-CATEGORY
ASSET_CATEGORY
Alpha 1This field identifies whether the asset is depreciable. Valid values are:
  • D Depreciable.
  • N Non-Depreciable.
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
AST-SIMULATED
SIMULATED
Alpha 1This 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
AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-WORK-IN-PROC
WORK_IN_PROC
Alpha 1This 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.
AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-TAX-EXEMPT
TAX_EXEMPT
Alpha 1This field identifies whether the asset is exempt from taxation. Valid values are:
  • Y Yes
  • N No
AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-USED
USED
Alpha 1This field identifies whether the asset has already been used at the time it was purchased. Valid values are:
  • N No.
  • Y Yes.
AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-ITEM-TOT-QTY
ITEM_TOT_QTY
Numeric 10The total number of items that make up this asset record.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-IT-TOT-CSTBASE
IT_TOT_CSTBASE
Signed 18.2The total cost of the asset items in company base currency.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-IT-TOT-TAXBASE
IT_TOT_TAXBASE
Signed 18.2The total tax amount associated with the asset items in the company base currency.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-IT-TOT-CSTTRAN
IT_TOT_CSTTRAN
Signed 18.2The total cost of the asset items in the currency of the transaction.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-IT-TOT-TAXTRAN
IT_TOT_TAXTRAN
Signed 18.2The total tax amount associated with the asset items in the currency of the transaction.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-BASE-ND
BASE_ND
Numeric 1The number of decimal positions defined for the company base currency.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-TRAN-ND
TRAN_ND
Numeric 1The number of decimals assigned to a particular account as determined by the account currency.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-CURRENCY-CODE
CURRENCY_CODE
Alpha 5The transaction currency code assigned to the asset.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-ITEM-LAST-DATE
ITEM_LAST_DATE
Numeric 8 (yyyymmdd)The highest (latest) purchase date of all of the items that make up the asset.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-ITEM-LAST-SEQ
ITEM_LAST_SEQ
Numeric 6The last sequence number assigned to an asset item for this asset record.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-COMPANY
COMPANY
Numeric 4The general ledger company number associated with the asset record. Used for posting associated asset transaction entries to the general ledger.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
AST-LOCATION-NAME
LOCATION_NAME
Alpha 15The location assigned to the asset.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
AST-DIVISION
DIVISION
Alpha 15The division assigned to the asset.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
AST-ASSET-TYPE
ASSET_TYPE
Alpha 10This 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.AC160, AM06.4, AM06.5, AM115, AM117, AM125, AM135, AM15.1 +52 more (list truncated in source)
AST-SUB-TYPE
SUB_TYPE
Alpha 10This 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.AC160, AM06.4, AM06.5, AM115, AM117, AM125, AM135, AM15.1 +52 more (list truncated in source)
AST-ACCT-GRP
ACCT_GRP
Alpha 10This 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).AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
AST-ACCT-UNIT
ACCT_UNIT
Alpha 15The 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.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
AST-AU-GROUP
AU_GROUP
Alpha 10Accounting 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.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
AST-ACTIVITY
ACTIVITY
Alpha 15Activities 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
DEP_EXP_ACTVTY
Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-DEP-ACCT-CAT
DEP_ACCT_CAT
Alpha 5Account 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 thruAC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-ORIG-CO
ORIG_CO
Numeric 4Identifies 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.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
AST-ASSET-LAST-SEQ
ASSET_LAST_SEQ
Numeric 6The last sequence number assigned to the last process created for the asset.AC160, AM115, AM117, AM118, AM125, AM135, AM145, AM15.1 +52 more (list truncated in source)
AST-TRAN-LAST-SEQ
TRAN_LAST_SEQ
Numeric 6The sequence number assigned to the last transaction created for the asset.
AST-COMM-LAST-SEQ
COMM_LAST_SEQ
Numeric 6The sequence number of the last comment defined for the asset.
AST-CREATION-DATE
CREATION_DATE
Numeric 8 (yyyymmdd)The date the asset record was created.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-CREATION-TIME
CREATION_TIME
Numeric 6 (hhmmss)The time the asset record was created.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-CREATOR-ID
CREATOR_ID
Alpha 10This field identifies the operator who created the asset record.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AST-INV-FLAG
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
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
AST-ASSET-OWNER
ASSET_OWNER
Alpha 10This field contains the name of the person responsible for keeping track of the asset in invnetory.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
AST-ATP-PROPERTY
ATP_PROPERTY
DerivedThis 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
GL_NAME
DerivedThe name of the general ledger company associated with the asset record.
AST-GL-CURR-CODE
GL_CURR_CODE
DerivedThe base currency defined for the posting company associated with the asset.
AST-GL-CHART
GL_CHART
DerivedThe chart name assigned to the posting company associated with the asset.
AST-ACCT-UNIT-DESC
ACCT_UNIT_DESC
DerivedA description of the general ledger accounting unit that is assigned to the asset.
AST-ACCT-GRP-DESC
ACCT_GRP_DESC
DerivedA description of the account group associated with the asset.
AST-LOC-DESC
LOC_DESC
DerivedA description of the location associated with the asset.
AST-DIV-DESC
DIV_DESC
DerivedA description of the division associated with the asset.
AST-TYPE-DESC
TYPE_DESC
DerivedA description of the asset type.
AST-ASD-DSP-METHOD
ASD_DSP_METHOD
DerivedIf 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
ASD_DSP_FL_PRT
DerivedIf the asset is disposed of, this field identifies whether the asset is partially or fully disposed of.
AST-ASD-DSP-DATE
ASD_DSP_DATE
DerivedIf the asset is disposed of, this field identifies the date the asset was partially or fully disposed of.
AST-ASD-DSP-PROP
ASD_DSP_PROP
DerivedIf the asset is disposed of, this field identifies the disposal property code assigned to the asset.
AST-ASD-DSP-QTY
ASD_DSP_QTY
DerivedIf the asset is partially or fully disposed of, this field identifies the number of units disposed of.
AST-ASD-PROC-CURR
ASD_PROC_CURR
DerivedIf the asset is sold (disposed of), this field identifies the currency of the proceeds from the sale.
AST-ASD-PROCEEDS
ASD_PROCEEDS
DerivedIf the asset is sold (disposed of), this field identifies the proceeds of the sale in the proceeds currency.
AST-ASD-COS-CURR
ASD_COS_CURR
DerivedIf the asset is sold (disposed of), this field identifies the currency of the expenses in selling it.
AST-ASD-COST-SALE
ASD_COST_SALE
DerivedIf the asset is sold (disposed of), this field identifies the amount received for the sale of the asset.
AST-BLANKAM
BLANKAM
DerivedThis field consists of blank spaces. It is used to provide column headings on Drill Arounds.
AST-CLEARING-AU
CLEARING_AU
Derived
AST-ASSET-AU
ASSET_AU
Derived
AST-ACCUM-AU
ACCUM_AU
Derived
AST-DEPR-EXP-AU
DEPR_EXP_AU
Derived
AST-COST-AU
COST_AU
Derived
AST-PROCEEDS-AU
PROCEEDS_AU
Derived
AST-GAIN-AU
GAIN_AU
Derived
AST-LOSS-AU
LOSS_AU
Derived
AST-DEF-GAIN-AU
DEF_GAIN_AU
Derived
AST-DEF-LOSS-AU
DEF_LOSS_AU
Derived
AST-OVRD-ACTIVITY
OVRD_ACTIVITY
Derived
AST-OVRD-ACCT-CAT
OVRD_ACCT_CAT
Derived
AST-REINSTATE-DATE
REINSTATE_DATE
Numeric 8 (yyyymmdd)The date of the last disposal reinstatement.AM41.1
AST-REINSTATE-FLAG
REINSTATE_FLAG
Alpha 1This field indicates that the disposal has been reinstated.
  • N No
  • Y Yes
AM41.1
AST-GEO-TYPE
GEO_TYPE
Alpha 4
AST-GEO-LATITUDE
GEO_LATITUDE
Signed 12.6AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
AST-GEO-LONGITUDE
GEO_LONGITUDE
Signed 12.6AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
AST-GEO-ALTITUDE
GEO_ALTITUDE
Signed 12.6AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
AST-GEO-DATE
GEO_DATE
Numeric 8 (yyyymmdd)AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
AST-GEO-TIME
GEO_TIME
Numeric 6 (hhmmss)AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
AST-CONCUR-NBR
CONCUR_NBR
Numeric 2AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)

Indexes (13)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ASTSET1ASSETPrimaryAC03.5, AC03.7, AC10.3, AC145, AC160, AC17.5, AC18.4, AC191 +22 more (list truncated in source)
ASTSET10OBJ-IDAM120, AM145, AM220, AM221, AM222, AM223, AM224, AM225 +22 more (list truncated in source)
ASTSET11CONCUR-NBR, STATUS, COMPANY, ASSET-TYPE, SUB-TYPE, DSP-ASSET, ASSETKeyChangeAM190
ASTSET12ASSET-GROUP, ASSETKeyChangeAM213, AM75.1, AM75.2, AM80.1, AM80.2, AM85.1, AM85.2
ASTSET13LEASE-COMPANY, LEASE, ASSETAM145, AM21.2, AM21.4, AM25.1, AM25.3, AM330, AM35.1, AM40.1 +2 more
ASTSET2COMPANY, ASSETKeyChangeAC160, AM01.1, AM01.2, AM01.3, AM05.1, AM06.1, AM06.2, AM06.3 +22 more (list truncated in source)
ASTSET3STATUS, LOCATION-NAME, DSP-ASSET, ASSETKeyChangeAC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM07.1, AM07.2 +22 more (list truncated in source)
ASTSET4STATUS, DIVISION, DSP-ASSET, ASSETKeyChangeAC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM08.1, AM08.2 +22 more (list truncated in source)
ASTSET5STATUS, COMPANY, ASSET-TYPE, SUB-TYPE, DSP-ASSET, ASSETKeyChangeAC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +22 more (list truncated in source)
ASTSET6STATUS, COMPANY, ASSET-GROUP, DSP-ASSET, ASSETKeyChange, SubsetWhere ASSET-GROUP != SpacesAM145, AM25.3, AM45.1, AM45.3, AM60.1, AM70.1, AM70.2, AM90.1 +8 more
ASTSET7STATUS, COMPANY, LOCATION-NAME, DIVISION, ASSET-TYPE, SUB-TYPE, DSP-ASSET, ASSETKeyChangeAM145, AM25.3, AM255, AM295, AM330, AM35.3, AM45.1, AM45.3 +11 more
ASTSET8ASSET, DSP-ASSETKeyChange, SubsetWhere STATUS = 3 And ASSET-PROCESS = "DSP" And DSP-ASSET != ZeroesAM245, AM40.1
ASTSET9STATUS, COMPANY, DSP-ASSET, ASSETKeyChangeAC160, AM05.1, AM115, AM117, AM12.1, AM12.2, AM125, AM145 +22 more (list truncated in source)

Relations

One to one (32) — lookups and parents

RelationTableRulesConditionField map
Amaccount AcmAMACCOUNTNot RequiredAST-COMPANYAAC-COMPANY, SpacesAAC-ACCT-GRP, AST-ASSET-TYPEAAC-ASSET-TYPE, AST-SUB-TYPEAAC-SUB-TYPE, "ACM"AAC-ACCT-TYPE, SpacesAAC-ASSET-EVENT
Amaccount AstAMACCOUNTNot RequiredAST-COMPANYAAC-COMPANY, SpacesAAC-ACCT-GRP, AST-ASSET-TYPEAAC-ASSET-TYPE, AST-SUB-TYPEAAC-SUB-TYPE, "AST"AAC-ACCT-TYPE, SpacesAAC-ASSET-EVENT
Amaccount ClrAMACCOUNTNot RequiredAST-COMPANYAAC-COMPANY, AST-ACCT-GRPAAC-ACCT-GRP, SpacesAAC-ASSET-TYPE, SpacesAAC-SUB-TYPE, "CLR"AAC-ACCT-TYPE, SpacesAAC-ASSET-EVENT
Amaccount CosAMACCOUNTNot RequiredAST-COMPANYAAC-COMPANY, AST-ACCT-GRPAAC-ACCT-GRP, SpacesAAC-ASSET-TYPE, SpacesAAC-SUB-TYPE, "COS"AAC-ACCT-TYPE, SpacesAAC-ASSET-EVENT
Amaccount DgnAMACCOUNTNot RequiredAST-COMPANYAAC-COMPANY, AST-ACCT-GRPAAC-ACCT-GRP, SpacesAAC-ASSET-TYPE, SpacesAAC-SUB-TYPE, "DGN"AAC-ACCT-TYPE, SpacesAAC-ASSET-EVENT
Amaccount DlsAMACCOUNTNot RequiredAST-COMPANYAAC-COMPANY, AST-ACCT-GRPAAC-ACCT-GRP, SpacesAAC-ASSET-TYPE, SpacesAAC-SUB-TYPE, "DLS"AAC-ACCT-TYPE, SpacesAAC-ASSET-EVENT
Amaccount ExpAMACCOUNTNot RequiredAST-COMPANYAAC-COMPANY, SpacesAAC-ACCT-GRP, AST-ASSET-TYPEAAC-ASSET-TYPE, AST-SUB-TYPEAAC-SUB-TYPE, "EXP"AAC-ACCT-TYPE, SpacesAAC-ASSET-EVENT
Amaccount GanAMACCOUNTNot RequiredAST-COMPANYAAC-COMPANY, AST-ACCT-GRPAAC-ACCT-GRP, SpacesAAC-ASSET-TYPE, SpacesAAC-SUB-TYPE, "GAN"AAC-ACCT-TYPE, SpacesAAC-ASSET-EVENT
Amaccount LosAMACCOUNTNot RequiredAST-COMPANYAAC-COMPANY, AST-ACCT-GRPAAC-ACCT-GRP, SpacesAAC-ASSET-TYPE, SpacesAAC-SUB-TYPE, "LOS"AAC-ACCT-TYPE, SpacesAAC-ASSET-EVENT
Amaccount ProAMACCOUNTNot RequiredAST-COMPANYAAC-COMPANY, AST-ACCT-GRPAAC-ACCT-GRP, SpacesAAC-ASSET-TYPE, SpacesAAC-SUB-TYPE, "PRO"AAC-ACCT-TYPE, SpacesAAC-ASSET-EVENT
Amacct Acm AddAMACCOUNTNot RequiredAST-COMPANYAAC-COMPANY, SpacesAAC-ACCT-GRP, AST-ASSET-TYPEAAC-ASSET-TYPE, AST-SUB-TYPEAAC-SUB-TYPE, "ACM"AAC-ACCT-TYPE, "1"AAC-ASSET-EVENT
Amacct Acm AdjAMACCOUNTNot RequiredAST-COMPANYAAC-COMPANY, SpacesAAC-ACCT-GRP, AST-ASSET-TYPEAAC-ASSET-TYPE, AST-SUB-TYPEAAC-SUB-TYPE, "ACM"AAC-ACCT-TYPE, "2"AAC-ASSET-EVENT
Amacct Acm DspAMACCOUNTNot RequiredAST-COMPANYAAC-COMPANY, SpacesAAC-ACCT-GRP, AST-ASSET-TYPEAAC-ASSET-TYPE, AST-SUB-TYPEAAC-SUB-TYPE, "ACM"AAC-ACCT-TYPE, "4"AAC-ASSET-EVENT
Amacct Acm RinAMACCOUNTNot RequiredAST-COMPANYAAC-COMPANY, SpacesAAC-ACCT-GRP, AST-ASSET-TYPEAAC-ASSET-TYPE, AST-SUB-TYPEAAC-SUB-TYPE, "ACM"AAC-ACCT-TYPE, "5"AAC-ASSET-EVENT
Amacct Acm TrfAMACCOUNTNot RequiredAST-COMPANYAAC-COMPANY, SpacesAAC-ACCT-GRP, AST-ASSET-TYPEAAC-ASSET-TYPE, AST-SUB-TYPEAAC-SUB-TYPE, "ACM"AAC-ACCT-TYPE, "3"AAC-ASSET-EVENT
Amacct Ast AddAMACCOUNTNot RequiredAST-COMPANYAAC-COMPANY, SpacesAAC-ACCT-GRP, AST-ASSET-TYPEAAC-ASSET-TYPE, AST-SUB-TYPEAAC-SUB-TYPE, "AST"AAC-ACCT-TYPE, "1"AAC-ASSET-EVENT
Amacct Ast AdjAMACCOUNTNot RequiredAST-COMPANYAAC-COMPANY, SpacesAAC-ACCT-GRP, AST-ASSET-TYPEAAC-ASSET-TYPE, AST-SUB-TYPEAAC-SUB-TYPE, "AST"AAC-ACCT-TYPE, "2"AAC-ASSET-EVENT
Amacct Ast DspAMACCOUNTNot RequiredAST-COMPANYAAC-COMPANY, SpacesAAC-ACCT-GRP, AST-ASSET-TYPEAAC-ASSET-TYPE, AST-SUB-TYPEAAC-SUB-TYPE, "AST"AAC-ACCT-TYPE, "4"AAC-ASSET-EVENT
Amacct Ast RinAMACCOUNTNot RequiredAST-COMPANYAAC-COMPANY, SpacesAAC-ACCT-GRP, AST-ASSET-TYPEAAC-ASSET-TYPE, AST-SUB-TYPEAAC-SUB-TYPE, "AST"AAC-ACCT-TYPE, "5"AAC-ASSET-EVENT
Amacct Ast TrfAMACCOUNTNot RequiredAST-COMPANYAAC-COMPANY, SpacesAAC-ACCT-GRP, AST-ASSET-TYPEAAC-ASSET-TYPE, AST-SUB-TYPEAAC-SUB-TYPE, "AST"AAC-ACCT-TYPE, "3"AAC-ASSET-EVENT
AmacctgrpAMACCTGRPRequiredAST-COMPANYAAG-COMPANY, AST-ACCT-GRPAAG-ACCT-GRP
AmassetbodAMASSETBODNot Required, Delete CascadesAST-ASSETYAP-ASSET
AmassetdspAMASSETDSPNot RequiredAST-ASSETASD-ASSET
AmassetgrpAMASSETGRPNot RequiredAST-ASSET-GROUPATG-ASSET-GROUP
AmasttypeAMASTTYPERequiredAST-COMPANYATP-COMPANY, AST-ASSET-TYPEATP-ASSET-TYPE, AST-SUB-TYPEATP-SUB-TYPE
AmaugroupAMAUGROUPNot RequiredAST-COMPANYAAU-COMPANY, AST-AU-GROUPAAU-AU-GROUP
AmcontrolAMCONTROLNot RequiredAST-COMPANYCTL-COMPANY
AmdivisionAMDIVISIONNot RequiredAST-DIVISIONDIV-DIVISION
AmlocationAMLOCATIONNot Required, Delete RestrictedAST-LOCATION-NAMELOC-LOCATION-NAME
GlnamesGLNAMESNot RequiredAST-COMPANYGLN-COMPANY, AST-ACCT-UNITGLN-ACCT-UNIT
GlsystemGLSYSTEMRequiredAST-COMPANYGLS-COMPANY
LmleaseLMLEASENot RequiredAST-LEASE-COMPANYLSE-COMPANY, AST-LEASELSE-LEASE

One to many (14) — child tables

RelationTableRulesConditionField map
AmassetadjAMASSETADJAST-ASSETASA-ASSET, ASA-PROCESS-SEQ
AmassetrinAMASSETRINAST-ASSETRIN-ASSET, RIN-CREATION-DATE, RIN-CREATION-TIME
AmassettrfAMASSETTRFAST-ASSETATF-ASSET, ATF-PROCESS-SEQ
AmastbkadjAMASTBKADJAST-ASSETABA-ASSET, ABA-BOOK, ABA-PROCESS-SEQ
AmastbkdspAMASTBKDSPAST-ASSETABD-ASSET, ABD-BOOK
AmastbktrfAMASTBKTRFAST-ASSETABT-ASSET, ABT-BOOK, ABT-PROCESS-SEQ
AmastbookAMASTBOOKDelete RestrictedAST-ASSETASB-ASSET, ASB-BOOK
AmastitdspAMASTITDSPAST-ASSETADS-ASSET, ADS-PROCESS-SEQ, ADS-SEQ-NUMBER
AmastitemAMASTITEMDelete CascadesAST-ASSETASI-ASSET, ASI-SEQ-NUMBER
AmastmxvalAMASTMXVALAST-OBJ-IDMXT-OBJ-ID, MXT-MATRIX-CAT
AmastrpairAMASTRPAIRAST-ASSETASR-ASSET, ASR-REPAIR-DATE, ASR-SEQ-NUMBER
AmtransAMTRANSAST-ASSETAMT-ASSET, "R"AMT-TRANS-STATUS, AMT-COMPANY, AMT-BOOK, AMT-SEQ-NUMBER
AmtranshistAMTRANSAST-ASSETAMT-ASSET, "H"AMT-TRANS-STATUS, AMT-COMPANY, AMT-BOOK, AMT-SEQ-NUMBER
AmtypallocAMTYPALLOCAST-COMPANYALL-COMPANY, AST-ASSET-TYPEALL-ASSET-TYPE, AST-SUB-TYPEALL-SUB-TYPE, ALL-START-DATE, ALL-SEQUENCE-NBR

Programs

Updated by (300)

Referenced by (144)