Full expand

Full collapse

PickingRule

Jump to

• Fields
• Business Views
• Other Properties

Rule that defines the picking priorities for replenishment and fulfillment. For example, pick the lots with the earliest expiration dates first.

Label, Plural Label

Picking Rule, Picking Rules

Qualified Label, Qualified Plural Label

Inventory Picking Rule, Inventory Picking Rules

Module

oraScmCoreInventorySetup

Keys

• $primary: id (default)

Expand all

Collapse all

Fields

* Field can't be null

• allocationModeIdentifier (int64)

  Value that identifies the mode of the picking rule.

  Label

  Allocation Mode Identifier

• createdBy (string)*

  The user who created the record.

  Label

  Created By

  Properties

  • not nullable
• description (string)

  Description of the picking rule.

  Label

  Description

  Properties

  • translatable
• enabledFlag (boolean)*

  Date when the picking rule becomes active.

  Label

  Active

  Properties

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

  Value that uniquely identifies the picking rule.

  Label

  ID

  Properties

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

  The date and time when the record was created.

  Label

  Last Updated By

  Properties

  • not nullable
• invPickingRuleTimeUpdated (date-time)*

  The date and time when the record was last updated.

  Label

  Last Updated Date

  Properties

  • not nullable
• invPickingRuleUpdatedBy (string)*

  The user who last updated the record.

  Label

  Last Updated By

  Properties

  • not nullable
• locatorSortRank (int64)

  Indicates that material is picked based on the locator name or the date when the material is received in a locator in ascending or descending order to satisfy the demand line.

  Label

  Locator Priority

  Properties

  • searchable
  • sortable
• locatorSortType (enumeration: PickingRuleLocationOrderSortType)

  Value that identifies the picked material based on the locator name or the date the material was received in a locator, sorted in ascending or descending order to fulfill the demand line.

  Label

  Locator Sort Type

  Type

  • Module: oraScmCoreInventorySetup

  • Enumeration Type: PickingRuleLocationOrderSortType

  Properties

  • searchable
  • sortable

  Valid Values

  • 0
  • 1
  • 2
  • 3
  • 4
• lotSortRank (enumeration: PickingRuleLotOrderSortType)

  Indicates that material is picked based on the lot number, earliest receipt, or expiration date for a lot in ascending or descending order to satisfy the demand line.

  Label

  Lot Priority

  Type

  • Module: oraScmCoreInventorySetup

  • Enumeration Type: PickingRuleLotOrderSortType

  Properties

  • searchable
  • sortable

  Valid Values

  • 0
  • 1
  • 2
  • 3
  • 4
• lotSortType (int64)

  Value that identifies the picked material based on the lot number, earliest receipt, or expiration date for a lot in ascending or descending order to satisfy the demand line.

  Label

  Lot Sort Type

  Properties

  • searchable
  • sortable
• name (string)*

  Name of the picking rule.

  Label

  Name

  Properties

  • translatable
  • not nullable
• partialAllowedFlag (boolean)

  Contains one of the following values: true or false. If true, then the material is selected partially from a lot. If false, then the material can't be selected partially from a lot. This attribute doesn't have a default value.

  Label

  Allow partial picking

  Properties

  • searchable
  • sortable
• revisionSortRank (int64)

  Indicates that material is picked based on the revision number or the effective date of a revision number in ascending or descending order to satisfy the demand line.

  Label

  Revision Priority

  Properties

  • searchable
  • sortable
• revisionSortType (enumeration: PickingRuleLotOrderSortType)

  Value that identifies the picked material based on the revision number or the effective date of the revision, sorted in ascending or descending order to fulfill the demand line.

  Label

  Revision Sort Type

  Type

  • Module: oraScmCoreInventorySetup

  • Enumeration Type: PickingRuleLotOrderSortType

  Properties

  • searchable
  • sortable

  Valid Values

  • 0
  • 1
  • 2
  • 3
  • 4
• ruleWeight (int64)

  Value that identifies the priority of the picking rule used for task type assignments and label printing rules.

  Label

  Rule Weight

• shelfDays (int32)

  Value that indicates the period of time in days that a material or product can be stored before it becomes spoiled or deteriorated beyond use or consumption.

  Label

  Shelf Life Days

  Properties

  • searchable
  • sortable
• singleLotFlag (boolean)

  Contains one of the following values: true or false. If true, then the material is selected from a single lot to fulfill a demand. If false, then the material can be selected from multiple lots to fulfill a demand. This attribute doesn't have a default value.

  Label

  Enforce single lot

  Properties

  • searchable
  • sortable
• subinventorySortRank (int64)

  Indicates that material is picked based on the subinventory name or the date when the material is received in a subinventory in ascending or descending order to satisfy the demand line.

  Label

  Subinventory Priority

  Properties

  • searchable
  • sortable
• subinventorySortType (enumeration: PickingRuleLocationOrderSortType)

  Value that identifies the picked material based on the subinventory name or the date when the material is received in a subinventory in ascending or descending order to satisfy the demand line.

  Label

  Subinventory Sort Type

  Type

  • Module: oraScmCoreInventorySetup

  • Enumeration Type: PickingRuleLocationOrderSortType

  Properties

  • searchable
  • sortable

  Valid Values

  • 0
  • 1
  • 2
  • 3
  • 4
• timeCreated (date-time)*

  The date and time when the record was created.

  Label

  Last Updated By

  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
• userDefinedFlag (boolean)*

  Value that identifies the picking rule defined by a user.

  Label

  User Defined

  Properties

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

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

  Label

  Source Language

  Properties

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

  Translatable description of the transaction source type.

  Label

  Translations

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

  Additional Mapping Details

  Mapped by relationship: pickingRule

Expand all

Collapse all

Business Views

** Available for extracting data

• default

  Data Source

  RDBMS

  Expand all

  Collapse all

  Fields

  • description (string)

    Description of the picking rule.

    Label

    Description

    Properties

    • translatable
  • enabledFlag (boolean)

    Date when the picking rule becomes active.

    Label

    Active

    Properties

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

    Value that uniquely identifies the picking rule.

    Label

    ID

    Properties

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

    Name of the picking rule.

    Label

    Name

    Properties

    • translatable
    • not nullable
• pickingRulesExtract**

  Rule that defines the picking priorities for replenishment and fulfillment. For example, pick the lots with the earliest expiration dates first.

  Label

  Inventory Picking Rules

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • allocationModeIdentifier (int64)

    Value that identifies the mode of the picking rule.

    Label

    Allocation Mode Identifier

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • description (string)

    Description of the picking rule.

    Label

    Description

    Properties

    • translatable
  • enabledFlag (boolean)

    Date when the picking rule becomes active.

    Label

    Active

    Properties

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

    Value that uniquely identifies the picking rule.

    Label

    ID

    Properties

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

    The date and time when the record was created.

    Label

    Last Updated By

    Properties

    • not nullable
  • invPickingRuleTimeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • not nullable
  • invPickingRuleUpdatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable
  • locatorSortRank (int64)

    Indicates that material is picked based on the locator name or the date when the material is received in a locator in ascending or descending order to satisfy the demand line.

    Label

    Locator Priority

    Properties

    • searchable
    • sortable
  • locatorSortType (enumeration: PickingRuleLocationOrderSortType)

    Value that identifies the picked material based on the locator name or the date the material was received in a locator, sorted in ascending or descending order to fulfill the demand line.

    Label

    Locator Sort Type

    Type

    • Module: oraScmCoreInventorySetup

    • Enumeration Type: PickingRuleLocationOrderSortType

    Properties

    • searchable
    • sortable

    Valid Values

    • 0
    • 1
    • 2
    • 3
    • 4
  • lotSortRank (enumeration: PickingRuleLotOrderSortType)

    Indicates that material is picked based on the lot number, earliest receipt, or expiration date for a lot in ascending or descending order to satisfy the demand line.

    Label

    Lot Priority

    Type

    • Module: oraScmCoreInventorySetup

    • Enumeration Type: PickingRuleLotOrderSortType

    Properties

    • searchable
    • sortable

    Valid Values

    • 0
    • 1
    • 2
    • 3
    • 4
  • lotSortType (int64)

    Value that identifies the picked material based on the lot number, earliest receipt, or expiration date for a lot in ascending or descending order to satisfy the demand line.

    Label

    Lot Sort Type

    Properties

    • searchable
    • sortable
  • name (string)

    Name of the picking rule.

    Label

    Name

    Properties

    • translatable
    • not nullable
  • partialAllowedFlag (boolean)

    Contains one of the following values: true or false. If true, then the material is selected partially from a lot. If false, then the material can't be selected partially from a lot. This attribute doesn't have a default value.

    Label

    Allow partial picking

    Properties

    • searchable
    • sortable
  • revisionSortRank (int64)

    Indicates that material is picked based on the revision number or the effective date of a revision number in ascending or descending order to satisfy the demand line.

    Label

    Revision Priority

    Properties

    • searchable
    • sortable
  • revisionSortType (enumeration: PickingRuleLotOrderSortType)

    Value that identifies the picked material based on the revision number or the effective date of the revision, sorted in ascending or descending order to fulfill the demand line.

    Label

    Revision Sort Type

    Type

    • Module: oraScmCoreInventorySetup

    • Enumeration Type: PickingRuleLotOrderSortType

    Properties

    • searchable
    • sortable

    Valid Values

    • 0
    • 1
    • 2
    • 3
    • 4
  • ruleWeight (int64)

    Value that identifies the priority of the picking rule used for task type assignments and label printing rules.

    Label

    Rule Weight

  • shelfDays (int32)

    Value that indicates the period of time in days that a material or product can be stored before it becomes spoiled or deteriorated beyond use or consumption.

    Label

    Shelf Life Days

    Properties

    • searchable
    • sortable
  • singleLotFlag (boolean)

    Contains one of the following values: true or false. If true, then the material is selected from a single lot to fulfill a demand. If false, then the material can be selected from multiple lots to fulfill a demand. This attribute doesn't have a default value.

    Label

    Enforce single lot

    Properties

    • searchable
    • sortable
  • subinventorySortRank (int64)

    Indicates that material is picked based on the subinventory name or the date when the material is received in a subinventory in ascending or descending order to satisfy the demand line.

    Label

    Subinventory Priority

    Properties

    • searchable
    • sortable
  • subinventorySortType (enumeration: PickingRuleLocationOrderSortType)

    Value that identifies the picked material based on the subinventory name or the date when the material is received in a subinventory in ascending or descending order to satisfy the demand line.

    Label

    Subinventory Sort Type

    Type

    • Module: oraScmCoreInventorySetup

    • Enumeration Type: PickingRuleLocationOrderSortType

    Properties

    • searchable
    • sortable

    Valid Values

    • 0
    • 1
    • 2
    • 3
    • 4
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Last Updated By

    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
  • userDefinedFlag (boolean)

    Value that identifies the picking rule defined by a user.

    Label

    User Defined

    Properties

    • searchable
    • not nullable

Other Properties

Property	Value
Application Package Name	ora_scm_core_inventorySetup
Extensible	No

Back to Top