biuan SAP® BUSINESS ONE SDK
SQL Administration / Data Archive - Transaction Log
DTW Administration / System Initialization / Deduction Tax Groups
API DAR1
DAR1 - Data Archive - Transaction Log Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ArcEntry KEY UNIQUEData Archive EntryInt
11
PRIMARYYes
Line_IDRow NumberInt
11
DocTypeDocument TypenVarChar
20
DocNumDocument NumberInt
11
DocAbsDocument Internal IDInt
11
TotalTotalNum
20
RefDatePosting DateDate
8
ClusterIdCluster IDInt
11
RemarksRemarksnVarChar
100
KeySeg1Key Segment 1nVarChar
15
KeySeg2Key Segment 2nVarChar
15
KeySeg3Key Segment 3nVarChar
15
KeySeg4Key Segment 4nVarChar
15
KeySeg5Key Segment 5nVarChar
15
KeySeg6Key Segment 6nVarChar
15
KeySeg7Key Segment 7nVarChar
20
KeySeg8Key Segment 8nVarChar
15
KeySeg9Key Segment 9nVarChar
15
KeySeg10Key Segment 10nVarChar
15
SeriesSeriesInt
6
DocSubTypeDocument Sub-TypenVarChar
2
--
PIndicatorPeriod IndicatornVarChar
10
' '
InstanceInstanceInt
6
0
SegmentSegmentInt
6
0
CardCodeCard CodenVarChar
15OCRD
Business Partner

SELECT statement

SELECT DAR1.ArcEntry AS 'Data Archive Entry', DAR1.Line_ID AS 'Row Number', DAR1.DocType AS 'Document Type', DAR1.DocNum AS 'Document Number', DAR1.DocAbs AS 'Document Internal ID', DAR1.Total AS 'Total', DAR1.RefDate AS 'Posting Date', DAR1.ClusterId AS 'Cluster ID', DAR1.Remarks AS 'Remarks', DAR1.KeySeg1 AS 'Key Segment 1', DAR1.KeySeg2 AS 'Key Segment 2', DAR1.KeySeg3 AS 'Key Segment 3', DAR1.KeySeg4 AS 'Key Segment 4', DAR1.KeySeg5 AS 'Key Segment 5', DAR1.KeySeg6 AS 'Key Segment 6', DAR1.KeySeg7 AS 'Key Segment 7', DAR1.KeySeg8 AS 'Key Segment 8', DAR1.KeySeg9 AS 'Key Segment 9', DAR1.KeySeg10 AS 'Key Segment 10', DAR1.Series AS 'Series', DAR1.DocSubType AS 'Document Sub-Type', DAR1.PIndicator AS 'Period Indicator', DAR1.Instance AS 'Instance', DAR1.Segment AS 'Segment', DAR1.CardCode AS 'Card Code' FROM DAR1 AS DAR1

Related information


Business Partner OCRD SQL Table
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