OMDC - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Administration / Master Data Cleanup

DTW MRP / Sales Forecast

API OMDC

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Internal Key	Int		11		PRIMARY	Yes
Name	Master Data Cleanup Name	nVarChar		100
CreateDate	Create Date	Date		8
UserSign	User Signature	Int		6	OUSR Users
Status	Status	VarChar	S) Saved E) Executed	1
UpdUser	Last Update User	nVarChar		30

Table relationship map

SELECT statement

SELECT
   OMDC.AbsEntry AS 'Internal Key', 
   OMDC.Name AS 'Master Data Cleanup Name', 
   OMDC.CreateDate AS 'Create Date', 
   OMDC.UserSign AS 'User Signature', 
   OMDC.Status AS 'Status', 
   OMDC.UpdUser AS 'Last Update User'
FROM OMDC AS OMDC

Related information

OMDC SQL Table

OUSR SQL Table

biuan SAP® BUSINESS ONE

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