biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Inventory / Weight UoM
API OWGT / / Weight Measures
OWGT - Weight Units Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
UnitCode KEY UNIQUEUnit CodeInt
6
PRIMARYYes
UnitDisply KEY UNIQUEUnit DisplaynVarChar
2
DISPLAYYes
UnitName KEY UNIQUEUnit NamenVarChar
20
UNIT_NAMEYes
WightInMGUnit Weight in mgNum
20
LockedLockedVarChar
Y) Yes
N) No
1
N
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 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


Weight Measures 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

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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates