Full expand

Full collapse

StandardConversion

Jump to

• Fields
• Business Views
• Other Properties

Standard conversions represent the optional conversion factor between a UOM and the base UOM for the shared parent class. For example, the standard conversion for liter is 1000 milliliters.

Label, Plural Label

Standard Conversion, Standard Conversions

Qualified Label, Qualified Plural Label

Standard Conversion, Standard Conversions

Module

oraScmCoreUnitOfMeasure

Keys

• $primary: id (default)

• altKey: classId, inventoryItemId, uomCode

Expand all

Collapse all

Fields

* Field can't be null

• classId (string)*

  Value that uniquely identifies the parent class of the two units in the standard conversion.

  Label

  UOM Class

  Properties

  • searchable
  • not nullable
• conversion (big-decimal)*

  Value of the conversion between the base unit and a second unit of measure in the same parent class.

  Label

  Conversion

  Properties

  • not nullable
• disableDate (date)

  Date when the standard conversion is no longer active.

  Label

  Disable Date

  Properties

  • searchable
• id (int64)*

  Value that uniquely identifies the standard conversion between a unit of measure and the base unit of the parent class. It's a value that the application generates when it creates a class.

  Label

  ID

  Properties

  • searchable
  • sortable
  • not nullable
• inventoryItemId (int64)*

  Zero value to indicate that the conversion is a standard conversion and not for an item.

  Label

  Inventory Item ID

  Properties

  • not nullable
• timeCreated (date-time)*

  The date and time when the record was created.

  Label

  Creation Date

  Properties

  • searchable
  • sortable
  • not nullable
• timeUpdated (date-time)*

  The date and time when the record was last updated.

  Label

  Last Updated Date

  Properties

  • searchable
  • sortable
  • not nullable
• uomCode (string)*

  User-supplied short code that identifies the unit of measure the conversion rate is defined for.

  Label

  UOM Code

  Properties

  • searchable
  • not nullable

Expand all

Collapse all

Business Views

** Available for extracting data

• default

  Data Source

  RDBMS

  Expand all

  Collapse all

  Fields

  • classId (string)

    Value that uniquely identifies the parent class of the two units in the standard conversion.

    Label

    UOM Class

    Properties

    • searchable
    • not nullable
  • id (int64)

    Value that uniquely identifies the standard conversion between a unit of measure and the base unit of the parent class. It's a value that the application generates when it creates a class.

    Label

    ID

    Properties

    • searchable
    • sortable
    • not nullable
  • inventoryItemId (int64)

    Zero value to indicate that the conversion is a standard conversion and not for an item.

    Label

    Inventory Item ID

    Properties

    • not nullable
  • uomCode (string)

    User-supplied short code that identifies the unit of measure the conversion rate is defined for.

    Label

    UOM Code

    Properties

    • searchable
    • not nullable
• standardConversionsExtract**

  Standard conversions represent the optional conversion factor between a UOM and the base UOM for the shared parent class. For example, the standard conversion for liter is 1000 milliliters.

  Label

  Standard Conversions

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • classId (string)

    Value that uniquely identifies the parent class of the two units in the standard conversion.

    Label

    UOM Class

    Properties

    • searchable
    • not nullable
  • conversion (big-decimal)

    Value of the conversion between the base unit and a second unit of measure in the same parent class.

    Label

    Conversion

    Properties

    • not nullable
  • disableDate (date)

    Date when the standard conversion is no longer active.

    Label

    Disable Date

    Properties

    • searchable
  • id (int64)

    Value that uniquely identifies the standard conversion between a unit of measure and the base unit of the parent class. It's a value that the application generates when it creates a class.

    Label

    ID

    Properties

    • searchable
    • sortable
    • not nullable
  • inventoryItemId (int64)

    Zero value to indicate that the conversion is a standard conversion and not for an item.

    Label

    Inventory Item ID

    Properties

    • not nullable
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • sortable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • sortable
    • not nullable
  • uomCode (string)

    User-supplied short code that identifies the unit of measure the conversion rate is defined for.

    Label

    UOM Code

    Properties

    • searchable
    • not nullable

Other Properties

Property	Value
Application Package Name	ora_scm_core_unit_of_measure
Extensible	No

Back to Top