CycleCountDefinitionscountCategoryItems
CycleCountDefinitionscountCategoryItems
Columns
| Name | Type | Description |
| CycleCountDefinitionsCycleCountHeaderId [KEY] | Long | CycleCountDefinitionsCycleCountHeaderId of CycleCountDefinitionscountCategoryItems |
| CountCategoryItemId [KEY] | Long | Value that uniquely identifies the category item that the cycle count definition references. |
| InventoryItemId | Long | Value that uniquely identifies the category item. |
| ItemNumber | String | Number that identifies the category item. |
| ItemDescription | String | ItemDescription of CycleCountDefinitionscountCategoryItems |
| CategoryId | Long | Value that uniquely identifies the count category that the category item references. |
| CategoryName | String | Name of the count category that the category item references. |
| CategoryDescription | String | Description of the count category that the category item references. |
| AdjustmentValuePositiveTolerance | Double | Positive adjustment that the warehouse allows the value to vary for the category item. |
| AdjustmentValueNegativeTolerance | Double | Negative adjustment that the warehouse allows the value to vary for the category item. |
| QuantityVariancePositivePercentage | Double | Positive percent that the warehouse allows the quantity to vary from the requested quantity for the category item. |
| QuantityVarianceNegativePercentage | Double | Negative percent that the warehouse allows the quantity to vary from the requested quantity for the category item. |
| LastScheduledDate | Datetime | Date when the warehouse scheduled this category item for counting. |
| IncludeInScheduleFlag | Bool | Contains one of the following values: true or false. If true, then schedule this category item. If false, then do not schedule this category item. The default value is false. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| CycleCountHeaderId | Long | CycleCountHeaderId |
| Subinventory | String | Subinventory |
| BindCycleCountName | String | bindCycleCountName |
| BindOrganizationCode | String | bindOrganizationCode |
| Finder | String | finder |