UnitOfMeasureSetDefaultUnit Table

Back to list of tables.

Column Data type Data type name Length Can be queried? Can be updated? Can be inserted? Mandatory when inserting? Format Refers To Version introduced in Edition available in
ID 12 VARCHAR 115 True False False False %s 7.0 US, CA, UK
ListID 12 VARCHAR 36 True False False False %s ListID 7.0 US, CA, UK
TimeCreated 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 7.0 US, CA, UK
TimeModified 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 7.0 US, CA, UK
EditSequence 12 VARCHAR 16 True False False False %s 7.0 US, CA, UK
Name 12 VARCHAR 31 True True True True %s 7.0 US, CA, UK
IsActive -7 BIT 2 True True True False
1
0
true
false
 7.0 US, CA, UK
UnitOfMeasureType 12 VARCHAR 15 True True True True
Area
Count
Length
Other
Time
Volume
Weight
 7.0 US, CA, UK
BaseUnit_Name 12 VARCHAR 31 True True True True %s 7.0 US, CA, UK
BaseUnit_Abbreviation 12 VARCHAR 31 True True True True %s 7.0 US, CA, UK
DefaultUnit_UnitSeqNo 4 INTEGER 9 True False False False SeqNo 7.0 US, CA, UK
DefaultUnit_UnitUsedFor 12 VARCHAR 15 True True True True
Purchase
Sales
Shipping
 7.0 US, CA, UK
DefaultUnit_Unit 12 VARCHAR 31 True True True True %s 7.0 US, CA, UK
RQUseCachedID -7 BIT 2