biuan SAP® BUSINESS ONE SDK
API AUOM
AUOM - UoM Master Data Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
UomEntry KEY UNIQUEUoM Abs. EntryInt
11
PRIMARYYes
UomCodeUoM CodenVarChar
20
UomNameUoM NamenVarChar
100
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
LogInstancLog InstanceInt
6
0
UserSign2Updating UserInt
6OUSR
Users
UpdateDateDate of UpdateDate
8
CreateDateCreation DateDate
8
Length1Length 1Num
20
Len1UnitUnit of Length 1Int
6
length2Length 2Num
20
Len2UnitUnit of Length 2Int
6
Width1Width 1Num
20
Wdth1UnitUnit of Width 1Int
6
Width2Width 2Num
20
Wdth2UnitUnit of Width 2Int
6
Height1Height 1Num
20
Hght1UnitUnit of Height 1Int
6
Height2Height 2Num
20
Hght2UnitUnit of Height 2Int
6
VolumeVolumeNum
20
VolUnitVolume UoMInt
6
Weight1Weight 1Num
20
WghtUnitWeight UoMInt
6
Weight2Weight 2Num
20
Wght2UnitUnit of Weight 2Int
6
IntSymbolInternational SymbolnVarChar
20

SELECT statement

SELECT AUOM.UomEntry AS 'UoM Abs. Entry', AUOM.UomCode AS 'UoM Code', AUOM.UomName AS 'UoM Name', AUOM.Locked AS 'Locked', AUOM.DataSource AS 'Data Source', AUOM.UserSign AS 'User Signature', AUOM.LogInstanc AS 'Log Instance', AUOM.UserSign2 AS 'Updating User', AUOM.UpdateDate AS 'Date of Update', AUOM.CreateDate AS 'Creation Date', AUOM.Length1 AS 'Length 1', AUOM.Len1Unit AS 'Unit of Length 1', AUOM.length2 AS 'Length 2', AUOM.Len2Unit AS 'Unit of Length 2', AUOM.Width1 AS 'Width 1', AUOM.Wdth1Unit AS 'Unit of Width 1', AUOM.Width2 AS 'Width 2', AUOM.Wdth2Unit AS 'Unit of Width 2', AUOM.Height1 AS 'Height 1', AUOM.Hght1Unit AS 'Unit of Height 1', AUOM.Height2 AS 'Height 2', AUOM.Hght2Unit AS 'Unit of Height 2', AUOM.Volume AS 'Volume', AUOM.VolUnit AS 'Volume UoM', AUOM.Weight1 AS 'Weight 1', AUOM.WghtUnit AS 'Weight UoM', AUOM.Weight2 AS 'Weight 2', AUOM.Wght2Unit AS 'Unit of Weight 2', AUOM.IntSymbol AS 'International Symbol' FROM AUOM AS AUOM

Related information


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