Full expand

Full collapse

MaterialStatus

Jump to

• Fields
• Business Views
• Other Properties

A transaction that can be performed on an item. You can assign material statuses at different levels, including subinventory, locator, lot, serial number, or on-hand quantity. This enables you to control whether items can be picked, shipped, or issued for work orders and manage items that need to be quarantined or inspected.

Label, Plural Label

Material Status, Material Statuses

Qualified Label, Qualified Plural Label

Inventory Material Status, Inventory Material Statuses

Module

oraScmCoreInventorySetup

Keys

• $primary: id

Expand all

Collapse all

Fields

* Field can't be null

• availabilityType (int32)

  Value that indicates if the material in this status should be included in the netting calculations for planning.

  Label

  Nettable

  Properties

  • searchable
  • sortable
• createdBy (string)*

  The user who created the record.

  Label

  Created By

  Properties

  • not nullable
• description (string)

  Description of the material status.

  Label

  Description

  Properties

  • translatable
• enabledFlag (boolean)*

  Contains one of the following values: 1 or 2. If 1, then the material status is active. If 2, then the material status isn't active. The default value is 1.

  Label

  Status

  Properties

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

  Identifier for the material status ID.

  Label

  Status ID

  Properties

  • searchable
  • sortable
  • not nullable
• inventoryAvailableToPromiseCode (int32)

  Code that identifies if the material in this status should be included in the available-to-promise calculations.

  Label

  Include in ATP

• licensePlateNumberControl (int32)*

  Contains one of the following values: 1 or 2. If 1, then the material status can be assigned to the license plate number. If 2, then the material status can't be assigned to the license plate number. The default value is 2.

  Label

  Content License Plate Number

  Properties

  • searchable
  • sortable
  • not nullable
• locatorControl (int32)*

  Contains one of the following values: 1 or 2. If 1, then the material status can be assigned to the locator. If 2, then the material status can't be assigned to locator. The default value is 2.

  Label

  Locator

  Properties

  • not nullable
• lotControl (int32)*

  Contains one of the following values: 1 or 2. If 1, then the material status can be assigned to the lot. If 2, then the material status can't be assigned to the lot. The default value is 2.

  Label

  Lot

  Properties

  • searchable
  • sortable
  • not nullable
• reservableTypeFlag (boolean)

  Contains one of the following values: 1 or 2. If 1, then the material status can allow reservations. If 2, then the material status can't allow reservations. The default value is 2.

  Label

  Allow Reservations

  Properties

  • searchable
  • sortable
• serialControl (int32)*

  Contains one of the following values: 1 or 2. If 1, then the material status can be assigned to the serial number. If 2, then the material status can't be assigned to the serial number. The default value is 2.

  Label

  Serial Number

  Properties

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

  Value that uniquely identifies the status.

  Label

  Status Code

  Properties

  • translatable
  • 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
• updatedBy (string)*

  The user who last updated the record.

  Label

  Last Updated By

  Properties

  • not nullable
• zoneControl (int32)*

  Contains one of the following values: 1 or 2. If 1, then the material status can be assigned to the subinventory. If 2, then the material status can't be assigned to the subinventory. The default value is 2.

  Label

  Usage

  Properties

  • searchable
  • sortable
  • not nullable
• $sourceLang (string)*

  Code indicating the original language of the material status.

  Label

  Source Language

  Properties

  • translatable
  • not nullable
• $translations (object-collection)*

  Code that identifies the language used to translate the translatable columns.

  Label

  Transaction

  Cardinality	Target Object
  One to many	Module: oraScmCoreInventorySetup Business Object: MaterialStatusTranslation

  Additional Mapping Details

  Mapped by relationship: materialStatus

Expand all

Collapse all

Business Views

** Available for extracting data

• default

  Data Source

  RDBMS

  Expand all

  Collapse all

  Fields

  • id (int64)

    Identifier for the material status ID.

    Label

    Status ID

    Properties

    • searchable
    • sortable
    • not nullable
• materialStatusesExtract**

  A transaction that can be performed on an item. You can assign material statuses at different levels, including subinventory, locator, lot, serial number, or on-hand quantity. This enables you to control whether items can be picked, shipped, or issued for work orders and manage items that need to be quarantined or inspected.

  Label

  Inventory Material Statuses

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • availabilityType (int32)

    Value that indicates if the material in this status should be included in the netting calculations for planning.

    Label

    Nettable

    Properties

    • searchable
    • sortable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • description (string)

    Description of the material status.

    Label

    Description

    Properties

    • translatable
  • enabledFlag (boolean)

    Contains one of the following values: 1 or 2. If 1, then the material status is active. If 2, then the material status isn't active. The default value is 1.

    Label

    Status

    Properties

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

    Identifier for the material status ID.

    Label

    Status ID

    Properties

    • searchable
    • sortable
    • not nullable
  • inventoryAvailableToPromiseCode (int32)

    Code that identifies if the material in this status should be included in the available-to-promise calculations.

    Label

    Include in ATP

  • licensePlateNumberControl (int32)

    Contains one of the following values: 1 or 2. If 1, then the material status can be assigned to the license plate number. If 2, then the material status can't be assigned to the license plate number. The default value is 2.

    Label

    Content License Plate Number

    Properties

    • searchable
    • sortable
    • not nullable
  • locatorControl (int32)

    Contains one of the following values: 1 or 2. If 1, then the material status can be assigned to the locator. If 2, then the material status can't be assigned to locator. The default value is 2.

    Label

    Locator

    Properties

    • not nullable
  • lotControl (int32)

    Contains one of the following values: 1 or 2. If 1, then the material status can be assigned to the lot. If 2, then the material status can't be assigned to the lot. The default value is 2.

    Label

    Lot

    Properties

    • searchable
    • sortable
    • not nullable
  • reservableTypeFlag (boolean)

    Contains one of the following values: 1 or 2. If 1, then the material status can allow reservations. If 2, then the material status can't allow reservations. The default value is 2.

    Label

    Allow Reservations

    Properties

    • searchable
    • sortable
  • serialControl (int32)

    Contains one of the following values: 1 or 2. If 1, then the material status can be assigned to the serial number. If 2, then the material status can't be assigned to the serial number. The default value is 2.

    Label

    Serial Number

    Properties

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

    Value that uniquely identifies the status.

    Label

    Status Code

    Properties

    • translatable
    • 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
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable
  • zoneControl (int32)

    Contains one of the following values: 1 or 2. If 1, then the material status can be assigned to the subinventory. If 2, then the material status can't be assigned to the subinventory. The default value is 2.

    Label

    Usage

    Properties

    • searchable
    • sortable
    • not nullable

Other Properties

Property	Value
Application Package Name	ora_scm_core_inventorySetup
Extensible	No

Back to Top