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