Lawson Insight Technical Documentation |
|
AMBKTRANS
AMBKTRANS FILE
Asset Book Transactions
The Asset Book Transaction file stores a copy of each transaction
transactions for each asset and each book.
REFERENCED BY
AM320 AM80.1 AM80.2 AM85.1 AM85.2 AM270
AM75.1 AM75.2 AM275 AM277
UPDATED BY
AM115 AM117 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 AM30.1 AM30.2 AM30.3 AM300 AM40.1
AM40.2 AM40.3 AM40.4 AM41.1 AM41.2 AM500
AM502 AM551 AM92.1 AM96.1 AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABK-ASSET Numeric 10 AM115 AM117
Element: Asset Number The asset number associated with the AM125 AM135
asset transaction. AM145 AM15.1
AM15.2 AM15.3
The asset number contains up to ten AM15.4 AM154
numeric characters that uniquely AM190 AM192
identify an asset. Assets are AM20.1 AM20.2
automatically numbered system-wide. AM20.4 AM21.1
AM21.2 AM21.4
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM502 AM551
AM92.1 AM98.1
ABK-BOOK Alpha 10 AM115 AM117
Element: Book The book associated with the asset AM125 AM135
transaction. Books are used by assets AM145 AM15.1
for calculating depreciation, AM15.2 AM15.3
replacement cost, and insurance values, AM15.4 AM154
and for reporting. AM190 AM192
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM502 AM551
AM92.1 AM98.1
ABK-COMPANY Numeric 4 AM115 AM117
Element: Company The general ledger company number AM125 AM135
associated with the book and asset. AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM190 AM192
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM502 AM551
AM92.1 AM98.1
ABK-TRANS-STATUS Alpha 1 AM115 AM117
Element: Trans Status This field identifies the status of the AM125 AM135
asset transaction. The status can be: AM145 AM15.1
U = Unreleased AM15.2 AM15.3
R = Released AM15.4 AM154
H = Historical 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 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM92.1
AM96.1 AM98.1
ABK-SEQ-NUMBER Numeric 6 AM115 AM117
Record Sequence A unique number assigned to the asset AM125 AM135
Number transaction to keep records unique. 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 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM92.1
AM96.1 AM98.1
ABK-TRAN-AMOUNT Signed 18.2 AM115 AM117
Element: Intl Amt The amount of the asset transaction in AM125 AM135
book currency. 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 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM92.1
AM96.1 AM98.1
ABK-TRAN-ND Numeric 1 AM115 AM117
Account Currency The number of decimal positions defined AM125 AM135
Code for the book currency. AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM190 AM192
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM502 AM551
AM92.1 AM98.1
ABK-TRANS-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: Transaction DaThe date of the transaction. AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM190 AM192
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM502 AM551
AM92.1 AM98.1
ABK-PROCESS-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: Date 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 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM92.1
AM96.1 AM98.1
ABK-REFERENCE Alpha 10 (Lower Case) AM115 AM117
Element: Reference The program number that created the AM125 AM135
transaction. AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM190 AM192
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM41.1
AM500 AM502
AM551 AM92.1
AM98.1
ABK-ACC-TYPE Alpha 3 AM115 AM117
Element: Acc Type For posting books, this field contains AM125 AM135
the type of account to which the AM145 AM15.1
transaction will be posted. Values are: AM15.2 AM15.3
AM15.4 AM154
AST = Asset AM170 AM190
ACM = Accumulated Depreciation AM192 AM20.1
EXP = Depreciation Expense AM20.2 AM20.3
PRO = Proceeds AM20.4 AM20.5
GAN = Gain AM20.6 AM21.1
LOS = Loss AM21.2 AM21.3
CLR = Clearing AM21.4 AM21.5
COS = Disposal Expense AM21.6 AM30.1
DGN = Deferred Gain AM30.2 AM30.3
DLS = Deferred Loss AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM92.1
AM96.1 AM98.1
ABK-ACCT-UNIT Alpha 15 AM115 AM117
Element: Accounting UniThe accounting unit used to post the AM125 AM135
transaction to the general ledger. AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM190 AM192
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM502 AM551
AM92.1 AM98.1
ABK-ACCOUNT Numeric 6 AM115 AM117
Element: Account The account used to post the transaction AM125 AM135
to the general ledger. AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM190 AM192
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM502 AM551
AM92.1 AM98.1
ABK-SUB-ACCT Numeric 4 AM115 AM117
Element: Subaccount The subaccount used to post the AM125 AM135
transaction to the general ledger. AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM190 AM192
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM502 AM551
AM92.1 AM98.1
ABK-ASSET-PROCESS Alpha 3 AM115 AM117
Element: Asset Process This field identifies the Asset AM125 AM135
Management process that caused this AM145 AM15.1
record to be created. Valid values are: AM15.2 AM15.3
AM15.4 AM154
ADD = Addition AM190 AM192
ADJ = Adjustment AM20.1 AM20.2
DPR = Depreciation AM20.4 AM21.1
DSP = Disposal AM21.2 AM21.4
TRF = Transfer AM30.1 AM30.2
RIN = Reinstate AM40.1 AM40.2
RAD = Readd AM40.3 AM41.1
AM500 AM502
AM551 AM92.1
AM98.1
ABK-ATN-OBJ-ID Numeric 12
Object The object ID used for Driall Around
Identification operations.
ABK-ACTIVITY Alpha 15 AM115 AM117
Element: Activity The activity assigned to the asset AM125 AM135
transaction. AM145 AM15.1
AM15.2 AM15.3
Activities are the processes or AM15.4 AM154
procedures that produce work. Cost AM190 AM192
objects (products, services, customers, AM20.1 AM20.2
and so on) are the reasons for AM20.4 AM21.1
performing the activity. Activities and AM21.2 AM21.4
cost object activities are used AM30.1 AM30.2
synonymously in the Lawson Activity AM40.1 AM40.2
Management system. AM40.3 AM500
AM502 AM551
AM92.1 AM98.1
ABK-ACCT-CATEGORY Alpha 5 AM115 AM117
Element: Account CategoThe account category assigned to the AM125 AM135
asset transaction. AM145 AM15.1
AM15.2 AM15.3
Account categories are groupings of AM15.4 AM154
costs, revenues, or a combination of AM190 AM192
both used for reporting and inquiries AM20.1 AM20.2
for activities in the Lawson Activity AM20.4 AM21.1
Management system. All transactions are AM21.2 AM21.4
posted to an account category within an AM30.1 AM30.2
activity. AM40.1 AM40.2
AM40.3 AM500
AM502 AM551
AM92.1 AM98.1
ABK-CREATION-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: Creation Date The record's creation date. 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 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM92.1
AM96.1 AM98.1
ABK-CREATION-TIME Numeric 6 (hhmmss) AM115 AM117
Element: Creation Time The record's creation time. 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 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM92.1
AM96.1 AM98.1
ABK-CREATOR-ID Alpha 10 AM115 AM117
Element: Operator Code The user that created the record. 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 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM92.1
AM96.1 AM98.1
AMBKTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ABKSET1 ASSET AM115 AM117
BOOK AM125 AM135
COMPANY AM145 AM15.1
TRANS-STATUS AM15.2 AM15.3
SEQ-NUMBER 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 AM30.1
AM30.2 AM30.3
AM320 AM40.1
...
ABKSET2 COMPANY KeyChange AM270 AM300
ACCT-UNIT AM75.1 AM75.2
ACCOUNT
SUB-ACCT
TRANS-DATE
BOOK
ASSET
SEQ-NUMBER
ABKSET3 COMPANY KeyChange AM115 AM117
TRANS-STATUS AM125 AM135
ASSET-PROCESS AM145 AM15.1
BOOK AM15.2 AM15.3
ASSET AM15.4 AM154
SEQ-NUMBER 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 AM275
AM277 AM30.1
AM30.2 AM30.3
...
ABKSET4 COMPANY KeyChange AM85.1 AM85.2
TRANS-STATUS
ACTIVITY
ACCT-CATEGORY
BOOK
ASSET
SEQ-NUMBER
ABKSET5 ASSET KeyChange
BOOK
COMPANY
SEQ-NUMBER*
TRANS-STATUS
ABKSET6 TRANS-STATUS AM135
ASSET-PROCESS
ASSET
BOOK
SEQ-NUMBER
AMBKTRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amasset AMASSET Required
ABK-ASSET -> AST-ASSET
Ambook AMBOOK Required
ABK-BOOK -> AMB-BOOK
AMBKTRANS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ambkhistx AMBKHISTX
ABK-ASSET -> ABX-ASSET
ABK-BOOK -> ABX-BOOK
ABK-COMPANY -> ABX-COMPANY
ABX-YR-END-DATE
ABX-PERIOD
|