CycleCountHeader
Header that defines a cycle count process and includes details such as the cycle count name, assigned ABC classification, approval limits, count calendar schedule, and tolerance thresholds.
Label, Plural Label
Cycle Count Header, Cycle Count Headers
Qualified Label, Qualified Plural Label
Inventory Cycle Count Header, Inventory Cycle Count Headers
Module
oraScmCoreInventoryCounting
Keys
-
$primary: id (default)
-
altKey: name, organizationId
Fields
* Field can't be null- allowSerialItems (int64)*
Indicates whether serialized items are permitted in this cycle count.
Label
Allow Serial Items
Properties
- not nullable
- approvalOptionCode (enumeration: CycleCountApprovalType)
Indicates whether approval is required for adjustment transactions in this cycle count.
Label
Approval Type
Type
-
Module: oraScmCoreInventorySetup
-
Enumeration Type: CycleCountApprovalType
Valid Values
- 1
- 2
- 3
-
- approvalRequired (int64)*
Indicates whether approval is required for this cycle count.
Label
Approval Required
Properties
- not nullable
- approvalToleranceNegative (big-decimal)
Negative quantity variance tolerance as a percentage of the system's on-hand quantity.
Label
Negative Quantity Tolerance
- approvalTolerancePositive (big-decimal)
Positive quantity variance tolerance as a percentage of the system's on-hand quantity.
Label
Positive Quantity Tolerance Percentage
- autoScheduleEnabledFlag (boolean)
Value that indicates whether to include the item in generation of count schedules.
Label
Auto Schedule Enabled
- containerAdjustmentOption (int64)
LPN adjustment options include-no adjustment, adjusting the LPN quantity (if possible), or reviewing all LPN adjustments.
Label
LPN Adjustment
- containerDiscrepancyOption (int64)
Indicates whether LPN discrepancies are allowed for the cycle count.
Label
Allow LPN Discrepancy
- containerEnabledFlag (boolean)
Value that indicates whether to include the item in generation of count schedules.
Label
Container Enabled
- costToleranceNegative (big-decimal)
Adjustment transactions with a cost below this amount require explicit approval.
Label
Negative Tolerance Cost
- costTolerancePositive (big-decimal)
Adjustment transactions with a cost above this amount require explicit approval.
Label
Positive Tolerance Cost
- countByCategoryFlag (boolean)
Indicates whether the Item Category is used for item classification.
Label
Count by Category
- createdBy (string)*
The user who created the record.
Label
Created By
Properties
- not nullable
- daysUntilLate (int64)
Number of days from the scheduled date by which a count must be recorded to avoid being considered late.
Label
Maximum Days Before Late
- description (string)
Value of the cycle count description corresponding to a cycle count.
Label
Description
Properties
- searchable
- sortable
- endDate (date)
Value that identifies the end date corresponding to a cycle count definition.
Label
Next Schedule Date
Properties
- searchable
- sortable
- excludedFromSync (string)
Indicates that items with negative balances should be excluded from the count.
Label
Exclude zero balances
- flowSource (string)
Indicates the source of the flow from which the cycle count is defined.
Label
Flow Source
- headerLastScheduleDate (date)
Value that identifies the end date corresponding to a cycle count definition.
Label
Last Schedule Date
Properties
- searchable
- sortable
- headerNextScheduleDate (date)
Value that identifies the end date corresponding to a cycle count definition.
Label
Next Schedule Date
Properties
- searchable
- sortable
- hitMissToleranceNegative (big-decimal)
Tolerance percentage by which a count quantity can be less than the system quantity.
Label
Negative Hit and Miss
- hitMissTolerancePositive (big-decimal)
Tolerance percentage by which a count quantity can exceed the system quantity.
Label
Positive Hit and Miss
- id (int64)*
Value that uniquely identifies the cycle count definition in an organization.
Label
Cycle Count ID
Properties
- searchable
- sortable
- not nullable
- lastSyncedDate (date)
Value that identifies the end date corresponding to a cycle count definition.
Label
Next Schedule Date
Properties
- searchable
- sortable
- locationBasedCount (int32)
Value that indicates whether cycle count is based on location.
Label
Location
- maximumAutoRecounts (int64)
Maximum number of recounts allowed.
Label
Maximum Recounts
- name (string)*
Name of the cycle count in an organization.
Label
Name
Properties
- searchable
- sortable
- not nullable
- onhandVisibleFlag (boolean)
Value that indicates whether to include the item in generation of count schedules.
Label
On-Hand Visible
- organizationId (int64)*
Value that uniquely identifies the warehouse organization that reserves inventory to fulfill the item.
Label
Organization ID
Properties
- searchable
- sortable
- not nullable
- serialAdjustmentOption (string)
Determines the options for adjusting the serial number in a cycle count, including the possibility of adjustments or reviewing all modifications.
Label
Serial Number Adjustment
- serialCountOption (string)
Number of serials allowed in a count sequence.
Label
Serial Numbers per Count
- serialDetailOption (int64)
Indicates the level of detail required when counting serialized items.
Label
Serial Detail
- serialDiscrepancyOption (int64)
Indicates whether to allow serial number discrepancies when counting serialized items.
Label
Serial Discrepancy
- startDate (date)*
Value that identifies the start date corresponding to a cycle count definition.
Label
Start Date
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
- workdaySchedule (int64)*
Workday calendar for the current cycle count period.
Label
Workday Schedule
Properties
- not nullable
- zeroCountFlag (boolean)
Value that indicates whether to include the item in generation of count schedules.
Label
Zero Count
Reference Objects
- abcAssignmentGroup (object)
ABC classes assigned to an ABC assignment group. An ABC class can be assigned to one or more groups but can only be used once within each group. The priority of the ABC class within the assignment group is also captured.
Label
ABC Assignment Group
Cardinality Target Object One to One - Module: oraScmCoreInventorySetup
- Business Object: AbcAssignmentGroup
Additional Mapping Details
Field in Current Object Field in Target Object abcAssignmentGroupId id
Business Views
** Available for extracting data- default
Data Source
RDBMS
Fields
- id (int64)
Value that uniquely identifies the cycle count definition in an organization.
Label
Cycle Count ID
Properties
- searchable
- sortable
- not nullable
- name (string)
Name of the cycle count in an organization.
Label
Name
Properties
- searchable
- sortable
- not nullable
- organizationId (int64)
Value that uniquely identifies the warehouse organization that reserves inventory to fulfill the item.
Label
Organization ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- cycleCountHeadersExtract**
Header that defines a cycle count process and includes details such as the cycle count name, assigned ABC classification, approval limits, count calendar schedule, and tolerance thresholds.
Label
Inventory Cycle Count Headers
Data Source
Read-optimized data store
Fields
- allowSerialItems (int64)
Indicates whether serialized items are permitted in this cycle count.
Label
Allow Serial Items
Properties
- not nullable
- approvalOptionCode (enumeration: CycleCountApprovalType)
Indicates whether approval is required for adjustment transactions in this cycle count.
Label
Approval Type
Type
-
Module: oraScmCoreInventorySetup
-
Enumeration Type: CycleCountApprovalType
Valid Values
- 1
- 2
- 3
-
- approvalRequired (int64)
Indicates whether approval is required for this cycle count.
Label
Approval Required
Properties
- not nullable
- approvalToleranceNegative (big-decimal)
Negative quantity variance tolerance as a percentage of the system's on-hand quantity.
Label
Negative Quantity Tolerance
- approvalTolerancePositive (big-decimal)
Positive quantity variance tolerance as a percentage of the system's on-hand quantity.
Label
Positive Quantity Tolerance Percentage
- autoScheduleEnabledFlag (boolean)
Value that indicates whether to include the item in generation of count schedules.
Label
Auto Schedule Enabled
- containerAdjustmentOption (int64)
LPN adjustment options include-no adjustment, adjusting the LPN quantity (if possible), or reviewing all LPN adjustments.
Label
LPN Adjustment
- containerDiscrepancyOption (int64)
Indicates whether LPN discrepancies are allowed for the cycle count.
Label
Allow LPN Discrepancy
- containerEnabledFlag (boolean)
Value that indicates whether to include the item in generation of count schedules.
Label
Container Enabled
- costToleranceNegative (big-decimal)
Adjustment transactions with a cost below this amount require explicit approval.
Label
Negative Tolerance Cost
- costTolerancePositive (big-decimal)
Adjustment transactions with a cost above this amount require explicit approval.
Label
Positive Tolerance Cost
- countByCategoryFlag (boolean)
Indicates whether the Item Category is used for item classification.
Label
Count by Category
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- not nullable
- daysUntilLate (int64)
Number of days from the scheduled date by which a count must be recorded to avoid being considered late.
Label
Maximum Days Before Late
- description (string)
Value of the cycle count description corresponding to a cycle count.
Label
Description
Properties
- searchable
- sortable
- endDate (date)
Value that identifies the end date corresponding to a cycle count definition.
Label
Next Schedule Date
Properties
- searchable
- sortable
- excludedFromSync (string)
Indicates that items with negative balances should be excluded from the count.
Label
Exclude zero balances
- flowSource (string)
Indicates the source of the flow from which the cycle count is defined.
Label
Flow Source
- headerLastScheduleDate (date)
Value that identifies the end date corresponding to a cycle count definition.
Label
Last Schedule Date
Properties
- searchable
- sortable
- headerNextScheduleDate (date)
Value that identifies the end date corresponding to a cycle count definition.
Label
Next Schedule Date
Properties
- searchable
- sortable
- hitMissToleranceNegative (big-decimal)
Tolerance percentage by which a count quantity can be less than the system quantity.
Label
Negative Hit and Miss
- hitMissTolerancePositive (big-decimal)
Tolerance percentage by which a count quantity can exceed the system quantity.
Label
Positive Hit and Miss
- id (int64)
Value that uniquely identifies the cycle count definition in an organization.
Label
Cycle Count ID
Properties
- searchable
- sortable
- not nullable
- lastSyncedDate (date)
Value that identifies the end date corresponding to a cycle count definition.
Label
Next Schedule Date
Properties
- searchable
- sortable
- locationBasedCount (int32)
Value that indicates whether cycle count is based on location.
Label
Location
- maximumAutoRecounts (int64)
Maximum number of recounts allowed.
Label
Maximum Recounts
- name (string)
Name of the cycle count in an organization.
Label
Name
Properties
- searchable
- sortable
- not nullable
- onhandVisibleFlag (boolean)
Value that indicates whether to include the item in generation of count schedules.
Label
On-Hand Visible
- organizationId (int64)
Value that uniquely identifies the warehouse organization that reserves inventory to fulfill the item.
Label
Organization ID
Properties
- searchable
- sortable
- not nullable
- serialAdjustmentOption (string)
Determines the options for adjusting the serial number in a cycle count, including the possibility of adjustments or reviewing all modifications.
Label
Serial Number Adjustment
- serialCountOption (string)
Number of serials allowed in a count sequence.
Label
Serial Numbers per Count
- serialDetailOption (int64)
Indicates the level of detail required when counting serialized items.
Label
Serial Detail
- serialDiscrepancyOption (int64)
Indicates whether to allow serial number discrepancies when counting serialized items.
Label
Serial Discrepancy
- startDate (date)
Value that identifies the start date corresponding to a cycle count definition.
Label
Start Date
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
- workdaySchedule (int64)
Workday calendar for the current cycle count period.
Label
Workday Schedule
Properties
- not nullable
- zeroCountFlag (boolean)
Value that indicates whether to include the item in generation of count schedules.
Label
Zero Count
Reference Object
- abcAssignmentGroup (AbcAssignmentGroup)
ABC classes assigned to an ABC assignment group. An ABC class can be assigned to one or more groups but can only be used once within each group. The priority of the ABC class within the assignment group is also captured.
Business Object
AbcAssignmentGroupFields
- id (int64)
Value that uniquely identifies the ABC assignment group.
Label
ABC Assignment Group ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- allowSerialItems (int64)
Other Properties
| Property | Value |
|---|---|
| Application Package Name | ora_scm_core_inventoryCounting |
| Extensible | Yes |