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
AC160 AM115 AM117 AM125 AM135 AM145
AM15.1 AM15.2 AM15.3 AM15.4 AM154 AM170
AM19.1 AM19.2 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 AM502 AM520
AM551 AM92.1 AM96.1 AM98.1 AP115 AP125
AP126 AP131 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP220 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP305
API1.1 API2.1 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 MA180 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA66.3 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.2 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
POI3.1 POID.1 POII.1 POIJ.1 RQ10.1 RQ10.2
WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABK-ASSET Numeric 10 AC160 AM115
Element: Asset The asset number associated with the AM117 AM125
asset transaction. AM135 AM145
AM15.1 AM15.2
The asset number contains up to ten AM15.3 AM15.4
numeric characters that uniquely AM154 AM19.1
identify an asset. Assets are AM19.2 AM190
automatically numbered system-wide. 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
...
ABK-BOOK Alpha 10 AC160 AM115
Element: Book The book associated with the asset AM117 AM125
transaction. Books are used by assets AM135 AM145
for calculating depreciation, AM15.1 AM15.2
replacement cost, and insurance values, AM15.3 AM15.4
and for reporting. AM154 AM19.1
AM19.2 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
AM520 AM551
AM92.1 AM98.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
...
ABK-COMPANY Numeric 4 AC160 AM115
Element: Company The general ledger company number AM117 AM125
associated with the book and asset. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM19.1
AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
...
ABK-TRANS-STATUS Alpha 1 AC160 AM115
Element: Trans Status This field identifies the status of the AM117 AM125
asset transaction. The status can be: AM135 AM145
U = Unreleased AM15.1 AM15.2
R = Released AM15.3 AM15.4
H = Historical AM154 AM170
AM19.1 AM19.2
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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
...
ABK-SEQ-NUMBER Numeric 6 AC160 AM115
Element: Seq Number A unique number assigned to the asset AM117 AM125
transaction to keep records unique. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
...
ABK-TRAN-AMOUNT Signed 18.2 AC160 AM115
Element: Intl Amt The amount of the asset transaction in AM117 AM125
book currency. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
...
ABK-TRAN-ND Numeric 1 AC160 AM115
Element: Acct Nd The number of decimal positions defined AM117 AM125
for the book currency. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM19.1
AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
...
ABK-TRANS-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Trans Date The date of the transaction. AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM19.1
AM19.2 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
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
...
ABK-PROCESS-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Date This field displays the system date AM117 AM125
when this was created. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
...
ABK-REFERENCE Alpha 10 (Lower Case) AC160 AM115
Element: Reference The program number that created the AM117 AM125
transaction. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM19.1
AM19.2 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
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
...
ABK-ACC-TYPE Alpha 3 AC160 AM115
Element: Acc Type For posting books, this field contains AM117 AM125
the type of account to which the AM135 AM145
transaction will be posted. Values are: AM15.1 AM15.2
AM15.3 AM15.4
AST = Asset AM154 AM170
ACM = Accumulated Depreciation AM19.1 AM19.2
EXP = Depreciation Expense AM190 AM192
PRO = Proceeds AM20.1 AM20.2
GAN = Gain AM20.3 AM20.4
LOS = Loss AM20.5 AM20.6
CLR = Clearing AM21.1 AM21.2
COS = Disposal Expense AM21.3 AM21.4
DGN = Deferred Gain AM21.5 AM21.6
DLS = Deferred Loss 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
...
ABK-ACCT-UNIT Alpha 15 AC160 AM115
Element: Acct Unit The accounting unit used to post the AM117 AM125
transaction to the general ledger. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
...
ABK-ACCOUNT Numeric 6 AC160 AM115
Element: Account The account used to post the transaction AM117 AM125
to the general ledger. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
...
ABK-SUB-ACCT Numeric 4 AC160 AM115
Element: Sub Acct The subaccount used to post the AM117 AM125
transaction to the general ledger. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
...
ABK-ASSET-PROCESS Alpha 3 AC160 AM115
Element: Asset Process This field identifies the Asset AM117 AM125
Management process that caused this AM135 AM145
record to be created. Valid values are: AM15.1 AM15.2
AM15.3 AM15.4
ADD = Addition AM154 AM19.1
ADJ = Adjustment AM19.2 AM190
DPR = Depreciation AM192 AM20.1
DSP = Disposal AM20.2 AM20.4
TRF = Transfer AM21.1 AM21.2
RIN = Reinstate AM21.4 AM30.1
RAD = Readd AM30.2 AM40.1
AM40.2 AM40.3
AM41.1 AM500
AM502 AM551
AM92.1 AM98.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
...
ABK-ATN-OBJ-ID Numeric 12
Element: Obj Id The object ID used for Driall Around
operations.
ABK-ACTIVITY Alpha 15 AC160 AM115
Element: Activity The activity assigned to the asset AM117 AM125
transaction. AM135 AM145
AM15.1 AM15.2
Activities are the processes or AM15.3 AM15.4
procedures that produce work. Cost AM154 AM170
objects (products, services, customers, AM19.1 AM19.2
and so on) are the reasons for AM190 AM192
performing the activity. Activities and AM20.1 AM20.2
cost object activities are used AM20.3 AM20.4
synonymously in the Lawson Activity AM20.5 AM20.6
Management system. 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
...
ABK-ACCT-CATEGORY Alpha 5 AC160 AM115
Element: Acct Category The account category assigned to the AM117 AM125
asset transaction. AM135 AM145
AM15.1 AM15.2
Account categories are groupings of AM15.3 AM15.4
costs, revenues, or a combination of AM154 AM170
both used for reporting and inquiries AM19.1 AM19.2
for activities in the Lawson Activity AM190 AM192
Management system. All transactions are AM20.1 AM20.2
posted to an account category within an AM20.3 AM20.4
activity. 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
...
ABK-CREATION-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Creation Date The record's creation date. AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
...
ABK-CREATION-TIME Numeric 6 (hhmmss) AC160 AM115
Element: Creation Time The record's creation time. AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
...
ABK-CREATOR-ID Alpha 10 AC160 AM115
Element: Operator The user that created the record. AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
...
AMBKTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ABKSET1 ASSET AC160 AM115
BOOK AM117 AM125
COMPANY AM135 AM145
TRANS-STATUS AM15.1 AM15.2
SEQ-NUMBER AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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
...
ABKSET2 COMPANY KeyChange AM270 AM300
ACCT-UNIT AM75.1 AM75.2
ACCOUNT
SUB-ACCT
TRANS-DATE
BOOK
ASSET
SEQ-NUMBER
ABKSET3 COMPANY KeyChange AC160 AM115
TRANS-STATUS AM117 AM125
ASSET-PROCESS AM135 AM145
BOOK AM15.1 AM15.2
ASSET AM15.3 AM15.4
SEQ-NUMBER AM154 AM170
AM19.1 AM19.2
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
...
ABKSET4 COMPANY KeyChange AM85.1 AM85.2
TRANS-STATUS
ACTIVITY
ACCT-CATEGORY
BOOK
ASSET
SEQ-NUMBER
ABKSET5 ASSET KeyChange AC160 AM115
SEQ-NUMBER* AM117 AM125
COMPANY AM135 AM145
BOOK AM15.1 AM15.2
TRANS-STATUS AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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
...
ABKSET6 TRANS-STATUS AC160 AM115
ASSET-PROCESS AM117 AM135
ASSET AM15.1 AM15.2
BOOK AM15.3 AM15.4
SEQ-NUMBER AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1 AP115
AP125 AP126
...
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
|