biuan SAP® BUSINESS ONE SDK
DTW Financials / Fixed Assets / Capitalization
API Asset Document Area Journal Collection / Asset Document Area Journal
ACQ2 - Capitalization - Area Journal Transactions Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11OACQ
Capitalization
PRIMARYYes
LineNumRow NumberInt
11
DprAreaDepreciation AreanVarChar
15ODPA
Fixed Asset Depreciation Areas
JrnlMemoJournal RemarksnVarChar
50
ObjTypeObject TypenVarChar
20
LogInstancLog InstanceInt
11
0
TransNumTransaction NumberInt
11OJDT
Journal Entry
JrnlMemo1Cancellation Journal RemarksnVarChar
50
TransNum1Cancellation Transaction No.Int
11OJDT
Journal Entry

Table relationship map

SELECT statement

SELECT ACQ2.DocEntry AS 'Document Internal ID', ACQ2.LineNum AS 'Row Number', ACQ2.DprArea AS 'Depreciation Area', ACQ2.JrnlMemo AS 'Journal Remarks', ACQ2.ObjType AS 'Object Type', ACQ2.LogInstanc AS 'Log Instance', ACQ2.TransNum AS 'Transaction Number', ACQ2.JrnlMemo1 AS 'Cancellation Journal Remarks', ACQ2.TransNum1 AS 'Cancellation Transaction No.' FROM ACQ2 AS ACQ2

Related information


Asset Document Area Journal AssetDocumentAreaJournal Object· Table: ACQ2
AssetDocumentAreaJournal is a child object of AssetDocument object and represents the Accounting tab fields of an asset document. Source table: ACQ2.
   Parent: Asset Document Area Journal Collection AssetDocumentAreaJournalCollection Collection
Capitalization OACQ SQL Table

Fixed Asset Depreciation Areas ODPA SQL Table

Journal Entry OJDT SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates