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

SQL Inventory and Production / Weight Units

DTW Administration / Setup / Inventory / Weight UoM

API OWGT / Weight Measures

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
UnitCode ^KEY ^UNIQUE	Unit Code	Int		6			PRIMARY	Yes
UnitDisply ^KEY ^UNIQUE	Unit Display	nVarChar		2			DISPLAY	Yes
UnitName ^KEY ^UNIQUE	Unit Name	nVarChar		20			UNIT_NAME	Yes
WightInMG	Unit Weight in mg	Num		20
Locked	Locked	VarChar	Y) Yes N) No	1		N
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
   OWGT.UnitCode AS 'Unit Code', 
   OWGT.UnitDisply AS 'Unit Display', 
   OWGT.UnitName AS 'Unit Name', 
   OWGT.WightInMG AS 'Unit Weight in mg', 
   OWGT.Locked AS 'Locked', 
   OWGT.DataSource AS 'Data Source', 
   OWGT.UserSign AS 'User Signature'
FROM OWGT AS OWGT

Related information

WeightMeasures Object· Table: OWGT

The WeightMeasures object enables to define the weight measure units that are used for item records. Source table: OWGT.

OWGT SQL Table

OUSR SQL Table

biuan SAP® BUSINESS ONE

Object
WeightMeasures

Method

Add

GetAsXML

GetByKey

Remove

SaveToFile

SaveXML

Update

Property

Browser

DTW DB

DTW DB

DTW DB

DTW DB

UserFields

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