AMBKTRANS

Asset Book Transactions

The Asset Book Transaction file stores a copy of each transaction transactions for each asset and each book.

REFERENCED BY
AM320


UPDATED BY
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 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1
PO136 PO190 PO300 PO520 POCP.1 POI3.1
POII.1 POIJ.1 AM80.1 AM80.2 AM85.1 AM85.2
AM270 AM75.1 AM75.2 AM275 AM277

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABK-ASSET
Element: Asset
Numeric 10
The asset number associated with the asset transaction. The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.
...
AM115 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 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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
ABK-BOOK
Element: Book
Alpha 10
The book associated with the asset transaction. Books are used by assets for calculating depreciation, replacement cost, and insurance values, and for reporting.
...
AM115 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 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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
ABK-COMPANY
Element: Company
Numeric 4
The general ledger company number associated with the book and asset.
...
AM115 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 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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
ABK-TRANS-STATUS
Element: Trans Status
Alpha 1
This field identifies the status of the asset transaction. The status can be: U = Unreleased R = Released H = Historical
...
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
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 AP30.2
ABK-SEQ-NUMBER
Element: Seq Number
Numeric 6
A unique number assigned to the asset transaction to keep records unique.
...
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
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 AP30.2
ABK-TRAN-AMOUNT
Element: Intl Amt
Signed 18.2
The amount of the asset transaction in book currency.
...
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
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 AP30.2
ABK-TRAN-ND
Element: Acct Nd
Numeric 1
The number of decimal positions defined for the book currency.
...
AM115 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 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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
ABK-TRANS-DATE
Element: Trans Date
Numeric 8 (yyyymmdd)
The date of the transaction.
...
AM115 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 AM20.5
AM21.1 AM21.2
AM21.4 AM21.5
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 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 MA41.1
MA41.2 MA41.4
ABK-PROCESS-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
...
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
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 AP30.2
ABK-REFERENCE
Element: Reference
Alpha 10 (Lower Case)
The program number that created the transaction.
...
AM115 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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
ABK-ACC-TYPE
Element: Acc Type
Alpha 3
For posting books, this field contains the type of account to which the transaction will be posted. Values are: AST = Asset ACM = Accumulated Depreciation EXP = Depreciation Expense PRO = Proceeds GAN = Gain LOS = Loss CLR = Clearing COS = Disposal Expense DGN = Deferred Gain DLS = Deferred Loss
...
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
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 AP30.2
ABK-ACCT-UNIT
Element: Acct Unit
Alpha 15
The accounting unit used to post the transaction to the general ledger.
...
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
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 AP30.2
ABK-ACCOUNT
Element: Account
Numeric 6
The account used to post the transaction to the general ledger.
...
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
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 AP30.2
ABK-SUB-ACCT
Element: Sub Acct
Numeric 4
The subaccount used to post the transaction to the general ledger.
...
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
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 AP30.2
ABK-ASSET-PROCESS
Element: Asset Process
Alpha 3
This field identifies the Asset Management process that caused this record to be created. Valid values are: ADD = Addition ADJ = Adjustment DPR = Depreciation DSP = Disposal TRF = Transfer
RIN = Reinstate
RAD = Readd
...
AM115 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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
ABK-ATN-OBJ-ID
Element: Obj Id
Numeric 12
The object ID used for Driall Around operations.
ABK-ACTIVITY
Element: Activity
Alpha 15
The activity assigned to the asset transaction. Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. Activities and cost object activities are used synonymously in the Lawson Activity Management system.
...
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
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 AP30.2
ABK-ACCT-CATEGORY
Element: Acct Category
Alpha 5
The account category assigned to the asset transaction. Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Lawson Activity Management system. All transactions are posted to an account category within an activity.
...
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
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 AP30.2
ABK-CREATION-DATE
Element: Creation Date
Numeric 8 (yyyymmdd)
The record's creation date.
...
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
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 AP30.2
ABK-CREATION-TIME
Element: Creation Time
Numeric 6 (hhmmss)
The record's creation time.
...
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
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 AP30.2
ABK-CREATOR-ID
Element: Operator
Alpha 10
The user that created the record.
...
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
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 AP30.2


AMBKTRANS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ABKSET1 ASSET
BOOK
COMPANY
TRANS-STATUS
SEQ-NUMBER
...
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
ABKSET2 COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCT
TRANS-DATE
BOOK
ASSET
SEQ-NUMBER
KeyChange
AM270 AM300
AM75.1 AM75.2
ABKSET3 COMPANY
TRANS-STATUS
ASSET-PROCESS
BOOK
ASSET
SEQ-NUMBER
KeyChange
...
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 AM275
AM277 AM30.1
ABKSET4 COMPANY
TRANS-STATUS
ACTIVITY
ACCT-CATEGORY
BOOK
ASSET
SEQ-NUMBER
KeyChange
AM85.1 AM85.2
ABKSET5 ASSET
SEQ-NUMBER*
COMPANY
BOOK
TRANS-STATUS
KeyChange
...
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
ABKSET6 TRANS-STATUS
ASSET-PROCESS
ASSET
BOOK
SEQ-NUMBER
COMPANY
...
AM115 AM117
AM135 AM15.1
AM15.2 AM15.3
AM15.4 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 AP131


AMBKTRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Wed Jun 08 20:47:08 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.