biuan SAP® BUSINESS ONE SDK
SQL Administration / Data Archive - Transaction Log
DTW Administration / System Initialization / Opening Balances
API DAR2
DAR2 - Data Archive - Transaction Log Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ArcEntry KEY UNIQUEData Archive EntryInt
11
PRIMARYYes
Line_IDRow NumberInt
11
0
ApproveApproveVarChar
Y) Yes
N) No
1
Y
DocTypeDocument TypeInt
11
DocNumDocument NumberInt
11
DocAbsDocument Abs EntryInt
11
CardCodeCustomer/Vendor CodenVarChar
15
RefDatePosting DateDate
8
DueDateDue DateDate
8
TaxDateDocument DateDate
8
TotalTotalNum
20
ActionActionVarChar
R) Remove
L) Locked
T) Temporary
1
T
RemarksRemarksnVarChar
50
KeySeg1Key Segment 1nVarChar
15
KeySeg2Key Segment 2nVarChar
15
KeySeg3Key Segment 3nVarChar
15
KeySeg4Key Segment 4nVarChar
15
KeySeg5Key Segment 5nVarChar
15
KeySeg6Key Segment 6nVarChar
15
ClusterIdCluster IDInt
11

SELECT statement

SELECT DAR2.ArcEntry AS 'Data Archive Entry', DAR2.Line_ID AS 'Row Number', DAR2.Approve AS 'Approve', DAR2.DocType AS 'Document Type', DAR2.DocNum AS 'Document Number', DAR2.DocAbs AS 'Document Abs Entry', DAR2.CardCode AS 'Customer/Vendor Code', DAR2.RefDate AS 'Posting Date', DAR2.DueDate AS 'Due Date', DAR2.TaxDate AS 'Document Date', DAR2.Total AS 'Total', DAR2.Action AS 'Action', DAR2.Remarks AS 'Remarks', DAR2.KeySeg1 AS 'Key Segment 1', DAR2.KeySeg2 AS 'Key Segment 2', DAR2.KeySeg3 AS 'Key Segment 3', DAR2.KeySeg4 AS 'Key Segment 4', DAR2.KeySeg5 AS 'Key Segment 5', DAR2.KeySeg6 AS 'Key Segment 6', DAR2.ClusterId AS 'Cluster ID' FROM DAR2 AS DAR2

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