biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Inventory / Manufacturers
API OMRC / / Manufacturers
OMRC - Manufacturers Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
FirmCode KEY UNIQUECodeInt
6
PRIMARYYes
FirmName KEY UNIQUEManufacturer NamenVarChar
30
GROUP_NAMEYes
DataSourceData SourceVarChar
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
UserSignUser SignatureInt
6OUSR
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 Manufacturers Object· Table: OMRC
The Manufacturers object enables to define manufacturers used in the Item master data. Source table: OMRC.

OMRC SQL Table

Users OUSR SQL Table



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