CycleCountDefinitionscountItems
CycleCountDefinitionscountItems
Columns
| Name | Type | Description |
| CycleCountDefinitionsCycleCountHeaderId [KEY] | Long | CycleCountDefinitionsCycleCountHeaderId of CycleCountDefinitionscountItems |
| CycleCountItemId [KEY] | Long | Value that uniquely identifies the item that the cycle count definition references. |
| InventoryItemId | Long | Value that uniquely identifies the item. |
| ItemNumber | String | Number that identifies the item. |
| ItemDescription | String | Description of the item. |
| AbcClassId | Long | Value that uniquely identifies the ABC class that the item references. |
| AbcClass | String | Name of the ABC class that the item references. |
| IncludeInScheduleCode | Long | Value that indicates whether or not to schedule this item. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC. |
| IncludeInSchedule | String | Value that determines whether or not to schedule this item. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC. |
| AdjustmentValuePositiveTolerance | Double | Positive adjustment that the warehouse allows the value to vary for the item. |
| AdjustmentValueNegativeTolerance | Double | Negative adjustment that the warehouse allows the value to vary for the item. |
| QuantityVariancePositivePercentage | Double | Positive percent that the warehouse allows the quantity to vary from the requested quantity for the item. |
| QuantityVarianceNegativePercentage | Double | Negative percent that the warehouse allows the quantity to vary from the requested quantity for the item. |
| LastScheduledDate | Datetime | Value that indicates the most recent date that the warehouse scheduled this item for counting. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| CycleCountHeaderId | Long | CycleCountHeaderId |
| Subinventory | String | Subinventory |
| BindCycleCountName | String | bindCycleCountName |
| BindOrganizationCode | String | bindOrganizationCode |
| Finder | String | finder |