UnitsOfMeasure
UnitsOfMeasure
Columns
| Name | Type | Description |
| UOMId [KEY] | Long | Value that uniquely identifies the unit of measure. It is a value that the application generates when it creates a unit. |
| UOMCode | String | User-supplied short code that identifies the unit of measure. This attribute is required. |
| UOMClass | String | Class that categorizes the unit of measure. Either this attribute or the UOMClassName is required when creating a new unit. The value of this attribute is the value of the ClassId attribute of the unitOfMeasureClasses instance. |
| UOMClassName | String | Name of the class that categorizes the unit of measure. Either this attribute or the UOMClass is required when creating a new unit. |
| UOM | String | Name of the unit of measure. This attribute is required. |
| Description | String | Description of the unit of measure. |
| UOMReciprocalDescription | String | Description of how to process the unit of measure so that the quantity that results from dividing it equals one. For example: Per Month is the reciprocal display for a service that uses the Month unit of measure. |
| UOMPluralDescription | String | Description of the plural value of the unit of measure. For example: Feet is the plural value for the Foot unit of measure. |
| BaseUnitFlag | Bool | Contains one of the following values: true or false. If true, then the unit of measure is the base unit of the class, typically the smallest unit within the class. If false, then the unit is not the base unit. All conversions within a class are made through the base unit. The default value is false. |
| DisableDate | Date | Date when the unit of measure is no longer active. |
| StandardConversion | Double | Rate of conversion between the unit of measure and the base unit of the class. This attribute is required. |
| StandardConversionEndDate | Date | Date when the standard conversion for the unit of measure is no longer active. |
| GlobalAttributeCategory | String | GlobalAttributeCategory of UnitsOfMeasure |
| OkeiCode | String | OkeiCode of UnitsOfMeasure |
| DerivedUnitParentCode | String | DerivedUnitParentCode of UnitsOfMeasure |
| CreatedBy | String | CreatedBy of UnitsOfMeasure |
| CreationDate | Datetime | CreationDate of UnitsOfMeasure |
| LastUpdateDate | Datetime | LastUpdateDate of UnitsOfMeasure |
| LastUpdatedBy | String | LastUpdatedBy of UnitsOfMeasure |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |