AbcCompileHeader
Information resulting from an ABC analysis, such as the number of items included in the analysis.
Label, Plural Label
ABC Compile Header, ABC Compile Headers
Qualified Label, Qualified Plural Label
Inventory ABC Compile Header, Inventory ABC Compile Headers
Module
oraScmCoreInventorySetup
Keys
-
$primary: id
Fields
* Field can't be null- compileDate (date)
The date on which the ABC classification set was created and ranked.
Label
ABC Classification Set Date
- compileItems (int64)
Items in the ABC classification set.
Label
Total Items
- compileName (string)*
Name of the ABC Classification Set
Label
ABC Classification Set
Properties
- not nullable
- compileStatus (enumeration: AbcCompileStatus)*
State or condition of the classification set.
Label
Status
Type
-
Module: oraScmCoreInventorySetup
-
Enumeration Type: AbcCompileStatus
Properties
- not nullable
Valid Values
- 1
- 2
- 3
- 4
-
- compileType (enumeration: AbcCompileType)*
The criteria selected to value and rank items based on predefined parameters.
Label
Criteria
Type
-
Module: oraScmCoreInventorySetup
-
Enumeration Type: AbcCompileType
Properties
- not nullable
Valid Values
- 1
- 10
- 2
- 3
- 4
- 5
- 8
- 9
-
- createdBy (string)*
The user who created the record.
Label
Created By
Properties
- searchable
- sortable
- not nullable
- cumulativeQuantity (big-decimal)
The total quantity of items in the ABC classification set.
Label
Total Quantity
- cumulativeValue (big-decimal)
The total monetary value of the items in the ABC classification set.
Label
Total Value
- cutoffDate (date)
Indicates the date when the ABC compilation becomes inactive.
Label
End Date
- description (string)
Description of the subinventory.
Label
Description
- id (int64)*
Value that uniquely identifies an ABC compile header.
Label
ABC Compile Header ID
Properties
- searchable
- sortable
- not nullable
- itemScopeCode (enumeration: AbcItemScope)
Specifies the scope of the ABC analysis, such as the entire organization or a specific subinventory.
Label
Valuation Scope
Type
-
Module: oraScmCoreInventorySetup
-
Enumeration Type: AbcItemScope
Valid Values
- 1
- 2
-
- startDate (date)
Indicates the date when the ABC compile becomes active.
Label
Start Date
- 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
- searchable
- sortable
- not nullable
Reference Objects
- organization (object)
An organization in supply chain management typically represents a physical facility representing a warehouse, manufacturing plant or maintenance depot. Such facilities are known as inventory organizations. For example, an organization is created for each warehouse in your enterprise. An organization may also represent a less complex version known as an item organization. For example, these are recommended to represent item master organizations. These are needed for item and item attribute setup but aren't used in business transactions.
Label
Organization
Cardinality Target Object One to One - Module: oraScmCoreOrganization
- Business Object: Organization
Additional Mapping Details
Field in Current Object Field in Target Object organizationId id - subinventory (object)
A subinventory is a unique physical or logical separation of material inventory, such as into raw inventory, finished goods, or defective material. All material in an organization is held in a subinventory.
Label
Subinventory
Cardinality Target Object One to One - Module: oraScmCoreInventorySetup
- Business Object: Subinventory
Additional Mapping Details
Field in Current Object Field in Target Object organizationId organizationId secondaryInventory name
Business Views
** Available for extracting data- default
Data Source
RDBMS
Fields
- id (int64)
Value that uniquely identifies an ABC compile header.
Label
ABC Compile Header ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- abcCompileHeadersExtract**
Information resulting from an ABC analysis, such as the number of items included in the analysis.
Label
Inventory ABC Compile Headers
Data Source
Read-optimized data store
Fields
- compileDate (date)
The date on which the ABC classification set was created and ranked.
Label
ABC Classification Set Date
- compileItems (int64)
Items in the ABC classification set.
Label
Total Items
- compileName (string)
Name of the ABC Classification Set
Label
ABC Classification Set
Properties
- not nullable
- compileStatus (enumeration: AbcCompileStatus)
State or condition of the classification set.
Label
Status
Type
-
Module: oraScmCoreInventorySetup
-
Enumeration Type: AbcCompileStatus
Properties
- not nullable
Valid Values
- 1
- 2
- 3
- 4
-
- compileType (enumeration: AbcCompileType)
The criteria selected to value and rank items based on predefined parameters.
Label
Criteria
Type
-
Module: oraScmCoreInventorySetup
-
Enumeration Type: AbcCompileType
Properties
- not nullable
Valid Values
- 1
- 10
- 2
- 3
- 4
- 5
- 8
- 9
-
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- searchable
- sortable
- not nullable
- cumulativeQuantity (big-decimal)
The total quantity of items in the ABC classification set.
Label
Total Quantity
- cumulativeValue (big-decimal)
The total monetary value of the items in the ABC classification set.
Label
Total Value
- cutoffDate (date)
Indicates the date when the ABC compilation becomes inactive.
Label
End Date
- description (string)
Description of the subinventory.
Label
Description
- id (int64)
Value that uniquely identifies an ABC compile header.
Label
ABC Compile Header ID
Properties
- searchable
- sortable
- not nullable
- itemScopeCode (enumeration: AbcItemScope)
Specifies the scope of the ABC analysis, such as the entire organization or a specific subinventory.
Label
Valuation Scope
Type
-
Module: oraScmCoreInventorySetup
-
Enumeration Type: AbcItemScope
Valid Values
- 1
- 2
-
- startDate (date)
Indicates the date when the ABC compile becomes active.
Label
Start Date
- 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
- searchable
- sortable
- not nullable
Reference Object
- organization (Organization)
An organization in supply chain management typically represents a physical facility representing a warehouse, manufacturing plant or maintenance depot. Such facilities are known as inventory organizations. For example, an organization is created for each warehouse in your enterprise. An organization may also represent a less complex version known as an item organization. For example, these are recommended to represent item master organizations. These are needed for item and item attribute setup but aren't used in business transactions.
Business Object
OrganizationFields
- id (int64)
Unique identifier of the organization.
Label
Organization ID
Properties
- inherited
- searchable
- sortable
- not nullable
- overridable
- id (int64)
- subinventory (Subinventory)
A subinventory is a unique physical or logical separation of material inventory, such as into raw inventory, finished goods, or defective material. All material in an organization is held in a subinventory.
Business Object
SubinventoryFields
- name (string)
Value that identifies the subinventory name.
Label
Name
Properties
- searchable
- sortable
- not nullable
- organizationId (int64)
Value that uniquely identifies the organization.
Label
Organization ID
Properties
- searchable
- sortable
- not nullable
- name (string)
- compileDate (date)
Other Properties
| Property | Value |
|---|---|
| Application Package Name | ora_scm_core_inventorySetup |
| Extensible | Yes |