biuan SAP® BUSINESS ONE SDK
SQL Administration / Data Archive - Handwritten Documents
DTW Administration / System Initialization / Authorization / User Permission Tree
API DAR3
DAR3 - Data Archive - Handwritten Documents Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ArcEntry KEY UNIQUEData Archive EntryInt
11
PRIMARYYes
Line_IDRow NumberInt
11
DocType KEYDocument TypenVarChar
20
DOC_NUMNo
DocAbsDoc. No.Int
11
DocNumDocument NumberInt
11
DocSubTypeDocument Sub-TypenVarChar
2
--
PIndicatorPeriod IndicatornVarChar
10
' '

SELECT statement

SELECT DAR3.ArcEntry AS 'Data Archive Entry', DAR3.Line_ID AS 'Row Number', DAR3.DocType AS 'Document Type', DAR3.DocAbs AS 'Doc. No.', DAR3.DocNum AS 'Document Number', DAR3.DocSubType AS 'Document Sub-Type', DAR3.PIndicator AS 'Period Indicator' FROM DAR3 AS DAR3

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