UnitOfMeasureSetDefaultUnit Table

Back to list of tables.

ColumnData typeData type nameLengthCan be queried?Can be updated?Can be inserted?Mandatory when inserting?FormatRefers ToVersion introduced inEdition available in
ID12VARCHAR115TrueFalseFalseFalse%s7.0US, CA, UK
ListID12VARCHAR36TrueFalseFalseFalse%sListID7.0US, CA, UK
TimeCreated93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ7.0US, CA, UK
TimeModified93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ7.0US, CA, UK
EditSequence12VARCHAR16TrueFalseFalseFalse%s7.0US, CA, UK
Name12VARCHAR31TrueTrueTrueTrue%s7.0US, CA, UK
IsActive-7BIT2TrueTrueTrueFalse
1
0
true
false
7.0US, CA, UK
UnitOfMeasureType12VARCHAR15TrueTrueTrueTrue
Area
Count
Length
Other
Time
Volume
Weight
7.0US, CA, UK
BaseUnit_Name12VARCHAR31TrueTrueTrueTrue%s7.0US, CA, UK
BaseUnit_Abbreviation12VARCHAR31TrueTrueTrueTrue%s7.0US, CA, UK
DefaultUnit_UnitSeqNo4INTEGER9TrueFalseFalseFalseSeqNo7.0US, CA, UK
DefaultUnit_UnitUsedFor12VARCHAR15TrueTrueTrueTrue
Purchase
Sales
Shipping
7.0US, CA, UK
DefaultUnit_Unit12VARCHAR31TrueTrueTrueTrue%s7.0US, CA, UK
RQUseCachedID-7BIT2