CycleCountSequenceDetailshistory
CycleCountSequenceDetailshistory
Columns
| Name | Type | Description |
| CycleCountSequenceDetailsCycleCountEntryId [KEY] | Long | CycleCountSequenceDetailsCycleCountEntryId of CycleCountSequenceDetailshistory |
| CycleCountSequenceDetailsCycleCountHeaderId [KEY] | Long | CycleCountSequenceDetailsCycleCountHeaderId of CycleCountSequenceDetailshistory |
| CycleCountSequenceDetailsOrganizationId [KEY] | Long | CycleCountSequenceDetailsOrganizationId of CycleCountSequenceDetailshistory |
| EntryHistoryId [KEY] | Long | EntryHistoryId of CycleCountSequenceDetailshistory |
| CycleCountEntryId | Long | CycleCountEntryId of CycleCountSequenceDetailshistory |
| ReviewDate | Datetime | ReviewDate of CycleCountSequenceDetailshistory |
| ReviewedByEmployeeId | Long | ReviewedByEmployeeId of CycleCountSequenceDetailshistory |
| ReviewedBy | String | ReviewedBy of CycleCountSequenceDetailshistory |
| CountDate | Datetime | CountDate of CycleCountSequenceDetailshistory |
| CountQuantity | Double | CountQuantity of CycleCountSequenceDetailshistory |
| SecondaryCountUOMCode | String | SecondaryCountUOMCode of CycleCountSequenceDetailshistory |
| SecondaryCountUOM | String | SecondaryCountUOM of CycleCountSequenceDetailshistory |
| CountUOMCode | String | CountUOMCode of CycleCountSequenceDetailshistory |
| CountUOM | String | CountUOM of CycleCountSequenceDetailshistory |
| CountedByEmployeeId | Long | CountedByEmployeeId of CycleCountSequenceDetailshistory |
| CountedBy | String | CountedBy of CycleCountSequenceDetailshistory |
| ItemUnitCost | Double | ItemUnitCost of CycleCountSequenceDetailshistory |
| PrimaryUOMQuantity | Double | PrimaryUOMQuantity of CycleCountSequenceDetailshistory |
| SecondarySuggestedQuantity | Double | SecondarySuggestedQuantity of CycleCountSequenceDetailshistory |
| SecondaryUOMQuantity | Double | SecondaryUOMQuantity of CycleCountSequenceDetailshistory |
| PrimarySuggestedQuantity | Double | PrimarySuggestedQuantity of CycleCountSequenceDetailshistory |
| ReasonId | Long | ReasonId of CycleCountSequenceDetailshistory |
| Reason | String | Reason of CycleCountSequenceDetailshistory |
| Comments | String | Comments of CycleCountSequenceDetailshistory |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| CycleCountHeaderId | Long | CycleCountHeaderId |
| FromSerialNumber | String | FromSerialNumber |
| OrganizationId | Long | OrganizationId |
| ToSerialNumber | String | ToSerialNumber |
| BindCycleCountName | String | bindCycleCountName |
| BindOrganizationCode | String | bindOrganizationCode |
| Finder | String | finder |