Full expand

Full collapse

MaterialStatusTranslation

Jump to

• Fields
• Reference Objects
• 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 Translation, Material Status Translations

Qualified Label, Qualified Plural Label

Inventory Material Status Translation, Inventory Material Status Translations

Module

oraScmCoreInventorySetup

Keys

• $primary: id, $language

Expand all

Collapse all

Fields

* Field can't be null

• createdBy (string)*

  The user who created the record.

  Label

  Created By

  Properties

  • not nullable
• description (string)

  Description of the inventory material status..

  Label

  Description

  Properties

  • searchable
  • sortable
• id (int64)*

  Value that uniquely identifies the material status.

  Label

  Transaction ID

  Properties

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

  Name of the material status.

  Label

  Accrual Status Code

  Properties

  • searchable
  • sortable
  • 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
• $language (string)*

  The language of the record.

  Label

  Language

  Properties

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

  The language in which the values of the translatable columns were created, updated, or copied from.

  Label

  Source Language

  Properties

  • not nullable

Expand all

Collapse all

Reference Objects

• materialStatus (object)

  Name of the material status.

  Label

  Material Status

  Cardinality	Target Object
  One to One	Module: oraScmCoreInventorySetup Business Object: MaterialStatus

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  id	id

Expand all

Collapse all

Business Views

** Available for extracting data

• default

  Data Source

  RDBMS

  Expand all

  Collapse all

  Fields

  • id (int64)

    Value that uniquely identifies the material status.

    Label

    Transaction ID

    Properties

    • searchable
    • sortable
    • not nullable
  • $language (string)

    The language of the record.

    Label

    Language

    Properties

    • creatable
    • searchable
    • sortable
    • not nullable

Other Properties

Property	Value
Application Package Name	ora_scm_core_inventorySetup
Extensible	Yes

Back to Top