biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Inventory / Length and Width UoM
API OLGT / / Length Measures
OLGT - Length 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
VolDisply KEYUnit Code for Quantity DisplaynVarChar
3
VOLUMENo
SizeInMMUnit Length in mmNum
20
LockedLockedVarChar
N) Changeable
Y) Locked
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 OLGT.UnitCode AS 'Unit Code', OLGT.UnitDisply AS 'Unit Display', OLGT.UnitName AS 'Unit Name', OLGT.VolDisply AS 'Unit Code for Quantity Display', OLGT.SizeInMM AS 'Unit Length in mm', OLGT.Locked AS 'Locked', OLGT.DataSource AS 'Data Source', OLGT.UserSign AS 'User Signature' FROM OLGT AS OLGT

Related information


Length Measures LengthMeasures Object· Table: OLGT
The LengthMeasures object enables to define the length and width measure units that are used for item records. Source table: OLGT.

OLGT 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