biuan SAP® BUSINESS ONE SDK
DTW Administration / System Initialization / Opening Balances / Business Partners Opening Balance
API DADB
DADB - Data Archive DSA Balance Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEDocument Internal IDInt
11
PRIMARYYes
ItemCodeItem NumbernVarChar
20OITM
Items
LocCodeLocation CodeInt
11OLCT
Location
OpenBalOpening BalanceNum
20

Table relationship map

SELECT statement

SELECT DADB.AbsEntry AS 'Document Internal ID', DADB.ItemCode AS 'Item Number', DADB.LocCode AS 'Location Code', DADB.OpenBal AS 'Opening Balance' FROM DADB AS DADB

Related information


Items OITM SQL Table

Location OLCT 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