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

SQL Administration / Brazilian Multi-Indexer

DTW Administration / Setup / Financials / Tax / Sales Tax Authorities

API OBMI

SBO SQL database table details

Field	Description	Type	Size	Related	Default	Primary_Key	Unique
ID ^KEY ^UNIQUE	Unique ID	Int	11			PRIMARY	Yes
IndexType ^KEY ^UNIQUE	Indexer Type	Int	11		-1	IND_CODE_K	Yes
Code	Code	nVarChar	10
Descr	Description	nVarChar	127
RefIndCod1	First Referenced Indexer Code	nVarChar	10
RefIndCod2	Second Referenced Indexer Code	nVarChar	10
RefIndCod3	Third Referenced Indexer Code	nVarChar	10
UserSign	User Signature	Int	6	OUSR Users

Table relationship map

SELECT statement

SELECT
   OBMI.ID AS 'Unique ID', 
   OBMI.IndexType AS 'Indexer Type', 
   OBMI.Code AS 'Code', 
   OBMI.Descr AS 'Description', 
   OBMI.RefIndCod1 AS 'First Referenced Indexer Code', 
   OBMI.RefIndCod2 AS 'Second Referenced Indexer Code', 
   OBMI.RefIndCod3 AS 'Third Referenced Indexer Code', 
   OBMI.UserSign AS 'User Signature'
FROM OBMI AS OBMI

Related information

OBMI 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