TABLE DETAIL REFERENCE: UnitOfMeasureSetRelatedUnit
(USA VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 16TrueFalseFalseFalse%s
Name12 VARCHAR 31TrueTrueTrueTrue%s
IsActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
UnitOfMeasureType12 VARCHAR 15TrueTrueTrueTrue
Area
Count
Length
Other
Time
Volume
Weight
BaseUnitName12 VARCHAR 31TrueTrueTrueTrue%s
BaseUnitAbbreviation12 VARCHAR 31TrueTrueTrueTrue%s
RelatedUnitSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
RelatedUnitName12 VARCHAR 31TrueTrueTrueTrue%s
RelatedUnitAbbreviation12 VARCHAR 31TrueTrueTrueTrue%s
RelatedUnitConversionRatio3 DECIMAL 18TrueTrueTrueTrue%10.5f
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey