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

SQL

Inventory and Production /

Manufacturers

DTW Administration / Setup / Inventory / Manufacturers

API OMRC / / Manufacturers

OMRC - Manufacturers Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
FirmCode ^KEY ^UNIQUE	Code	Int		6			PRIMARY	Yes
FirmName ^KEY ^UNIQUE	Manufacturer Name	nVarChar		30			GROUP_NAME	Yes
DataSource	Data Source	VarChar	N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer	1		N
UserSign	User Signature	Int		6	OUSR Users

Table relationship map

SELECT statement

SELECT
   OMRC.FirmCode AS 'Code', 
   OMRC.FirmName AS 'Manufacturer Name', 
   OMRC.DataSource AS 'Data Source', 
   OMRC.UserSign AS 'User Signature'
FROM OMRC AS OMRC

Related information

Manufacturers Object· Table: OMRC

The Manufacturers object enables to define manufacturers used in the Item master data. Source table: OMRC.

OMRC SQL Table

OUSR SQL Table

biuan SAP® BUSINESS ONE

Object
Manufacturers

Method

Add

GetAsXML

GetByKey

Remove

SaveToFile

SaveXML

Update

Property

Browser

Code

DTW DB

ManufacturerName

DTW DB

UserFields

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