CycleCountDefinitions
CycleCountDefinitions
Columns
| Name | Type | Description |
| CycleCountHeaderId [KEY] | Long | Value that uniquely identifies the cycle count definition. |
| CycleCountName | String | Name of the cycle count. |
| Description | String | Description of the cycle count. |
| OrganizationId | Long | Value that uniquely identifies the inventory organization. |
| OrganizationCode | String | Value that identifies the inventory organization. |
| OrganizationName | String | Name of the inventory organization. |
| AbcAssignmentGroupId | Long | Value that uniquely identifies the ABC group that the warehouse uses to initialize the item classification. |
| AbcAssigmentGroup | String | Name of the ABC group that the warehouse uses to initialize the item classification in the cycle count. |
| SynchronizationModeCode | String | Name of the ABC group that the warehouse uses to initialize the item classification in the cycle count. |
| SynchronizationMode | String | Value that determines the ABC synchronization mode. A list of accepted values is defined in the lookup type INV_CC_SYNC_MODE. |
| SynchronizeAbcAssociationFlag | Bool | Contains one of the following values: true or false. If true, then synchronize the ABC classes and items during ABC synchronization. If false, then do not synchronize the ABC classes and items during ABC synchronization. This attribute does not have a default value. |
| DeleteAdditionalItemsFlag | Bool | Contains one of the following values: true or false. If true, then delete the additional items during ABC synchronization. If false, then do not delete the additional items during ABC synchronization. This attribute does not have a default value. |
| AutomaticallyScheduleCode | Int | Value that indicates whether or not the warehouse schedules the counts. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC. |
| AutomaticallySchedule | String | Value that determines whether or not the warehouse schedules the counts. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC. |
| FrequencyCode | String | Value that indicates the time interval to use between two consecutive scheduling runs for a cycle count. A list of accepted values is defined in the lookup type INV_CC_SCHED_TIME. |
| Frequency | String | Value that determines the time interval to use between two consecutive scheduling runs for a cycle count. A list of accepted values is defined in the lookup type INV_CC_SCHED_TIME. |
| WorkdayScheduleCode | Long | Value that identifies the workday schedule that the cycle count references. |
| WorkdaySchedule | String | Workday schedule that the count references. |
| LastScheduledDate | Date | Date when the last cycle count was scheduled to run by the warehouse. |
| NextScheduledDate | Date | Date when the next cycle count is scheduled to run by the warehouse. |
| ApprovalRequiredCode | Long | Value that indicates whether or not the warehouse requires approval. |
| ApprovalRequired | String | Value that determines whether or not the warehouse requires approval. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC. |
| ApprovalTypeCode | String | Value that determines the type of approval that the warehouse requires for adjustment transactions. A list of accepted values is defined in the lookup type INV_APPROVAL_REQ. |
| ApprovalType | String | Type of approval that the warehouse requires for an adjustment transaction. A list of accepted values is defined in the lookup type INV_APPROVAL_REQ. |
| PositiveTolerancePercentage | Double | Positive percent tolerance. If the adjustment exceeds this tolerance, then the warehouse requires approval for the adjustment transaction. |
| NegativeTolerancePercentage | Double | Negative percent tolerance. If the adjustment falls below this tolerance, then the warehouse requires approval for the adjustment transaction. |
| PositiveAdjustmentTolerance | Double | Positive currency tolerance. If the currency exceeds this tolerance, then the warehouse requires approval for the adjustment transaction. |
| NegativeAdjustmentTolerance | Double | Negative currency tolerance. If the currency falls below this tolerance, then the warehouse requires approval for the adjustment transaction. |
| StartingCountSequence | Long | Starting number that the warehouse uses for the count sequence for the next scheduling run of the cycle count. |
| MaximumDaysBeforeLate | Long | Number of days after creation before the warehouse considers a scheduled count as late. |
| MaximumRecounts | Long | Maximum number of recounts that the warehouse uses on a cycle count. |
| StartDate | Date | Date when this cycle count becomes active. |
| EndDate | Date | Date when this cycle count becomes inactive. |
| ManualCountsAllowedCode | Long | Value that indicates whether or not the warehouse can use this cycle count to enter an unscheduled count. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC. |
| ManualCountsAllowed | String | Value that determines whether or not the warehouse can use this cycle count to enter an unscheduled count. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC. |
| ManualCountSequencePrefix | String | Prefix for a manual count sequence. |
| CountZeroQuantityCode | Long | Value that indicates whether the warehouse schedules a cycle count for an item when the on-hand quantity is zero. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC. |
| CountZeroQuantity | String | Value that determines whether the warehouse schedules a cycle count for an item when the on-hand quantity is zero. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC. |
| DisplaySuggestedQuantityCode | Long | Value that indicates whether or not to display the on-hand quantity for the cycle count sequence. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC. |
| DisplaySuggestedQuantity | String | Value that determines whether or not to display the on-hand quantity for the cycle count sequence. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC. |
| SerializedItemsAllowedCode | Long | Value that indicates whether or not to use the cycle count to count serial items. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC. |
| SerializedItemsAllowed | String | Value that determines whether or not to use the cycle count to count serial items. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC. |
| SerialCountOptionCode | String | Value that indicates whether or not to include serial items when creating the count. A list of accepted values is defined in the lookup type INV_CC_SERIAL_COUNT_OPTIONS. |
| SerialCountOption | String | Value that determines whether or not to include serial items when creating the count. A list of accepted values is defined in the lookup type INV_CC_SERIAL_COUNT_OPTIONS. |
| SerialNumberAdjustmentCode | String | Value that indicates whether or not to adjust for serial items. A list of accepted values is defined in the lookup type INV_CC_SERIAL_ADJ_OPTIONS. |
| SerialNumberAdjustment | String | Value that determines whether or not to adjust for serial items. A list of accepted values is defined in the lookup type INV_CC_SERIAL_ADJ_OPTIONS. |
| RecordCountSerialsCode | Long | Value that indicates the detail level to use when counting serial items. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC. |
| RecordCountSerials | String | Value that determines the detail level to use when counting serial items. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC. |
| SerialDiscrepancyCode | Long | Value that indicates whether or not to allow discrepancy when counting serial items. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC. |
| SerialDiscrepancyAllowed | String | Value that determines whether or not to allow discrepancy when counting serial items. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC. |
| PositiveHitMissPercentage | Double | Positive percent tolerance that the warehouse uses for hit or miss analysis. |
| NegativeHitMissPercentage | Double | Negative percent tolerance that the warehouse uses for hit or miss analysis. |
| CountByCategoryFlag | Bool | Contains one of the following values: true or false. If true, then enable the cycle count by item category. If false, then do not enable the cycle count by item category. The default value is false. |
| CategorySynchronizationModeCode | String | Abbreviation that identifies the item category synchronization mode. A list of accepted values is defined in the lookup type INV_CC_SYNC_MODE. |
| CategorySynchronizationMode | String | Mode of item category synchronization. A list of accepted values is defined in the lookup type INV_CC_SYNC_MODE. |
| SynchronizeItemCategoryAssociationFlag | Bool | Contains one of the following values: true or false. If true, then synchronize the count category items during item category synchronization. If false, then do not synchronize the count category items during item category synchronization. This attribute does not have a default value. |
| DeleteAdditionalCategoryItemsFlag | Bool | Contains one of the following values: true or false. If true, then delete the additional items during item category synchronization. If false, then do not delete the additional items during item category synchronization. This attribute does not have a default value. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ItemDescription | String | ItemDescription |
| ItemNumber | String | ItemNumber |
| Subinventory | String | Subinventory |
| BindCycleCountName | String | bindCycleCountName |
| BindOrganizationCode | String | bindOrganizationCode |
| Finder | String | finder |