title: "StockCount" category: reference tags: [entity, stock-count, datamodel] source: Entities.xml date: 2026-04-17 status: published
StockCount
Type: Entity Properties: 23 Contexts: 1 Statussen: 6
Zie ook het handgeschreven artikel: stock-count
DB-schema:
lookup_table_schema("StockCount")· ../tables/StockCount
Contextsbewerken
- 0: Standaard (
StockCountContext.None)
Statussenbewerken
- -1: Trash (
StockCountStatus.Trash) - 0: None (
StockCountStatus.None) - 1: Open (
StockCountStatus.Created) - 2: In uitvoering (
StockCountStatus.Active) - 4: Gereed (
StockCountStatus.Finished) - 8: Gesloten (
StockCountStatus.Closed)
Propertiesbewerken
| Property | Type | Kolom | Width | Nullable | Default |
|---|---|---|---|---|---|
| Id | UltimoString | SCID | 9 | false | |
| AbcCodeId | AbcCode | SCABCID | true | ||
| BlindCount | Boolean | SCBLINDCOUNT | false | 1 | |
| Context | Context | SCCONTEXT | false | 0 | |
| CostCenter | CostCenter | SCCCRID | true | ||
| Description | UltimoString | SCDESCR | 200 | true | |
| ExecuteBy | Employee | SCEMPID | true | ||
| Exported | Boolean | SCEXPORTED | false | 0 | |
| RealTimeStockCount | Boolean | SCREALTIMESTOCKCOUNT | false | 0 | |
| RecordCreateDate | DateTime | SCRECCREATEDATE | false | SYSDATETIME | |
| Recount | Boolean | SCRECOUNT | false | 0 | |
| Site | Site | SCSITID | true | ||
| Status | Status | SCRECSTATUS | false | 1 | |
| StatusActiveDate | DateTime? | SCACTIVEDATE | true | ||
| StatusActiveEmployee | Employee | SCACTIVEEMPID | true | ||
| StatusClosedDate | DateTime? | SCCLOSEDDATE | true | ||
| StatusClosedEmployee | Employee | SCCLOSEDEMPID | true | ||
| StatusCreatedDate | DateTime? | SCCREATEDDATE | true | SYSDATETIME | |
| StatusCreatedEmployee | Employee | SCCREATEDEMPID | true | USERID | |
| StatusFinishedDate | DateTime? | SCFINISHEDDATE | true | ||
| StatusFinishedEmployee | Employee | SCFINISHEDEMPID | true | ||
| SystemCompany | Company | SCCOMPID | true | ||
| Warehouse | Warehouse | SCWHSID | true |
Brondatabewerken
- Entity-definitie —
lookup_entity("StockCount")Model-perspectief (properties, contexts, statussen). Bron:Entities.xml. - DB-schema —
lookup_table_schema("StockCount")· ../tables/StockCount DB-perspectief (triggers, computed, defaults). Bron:database-schema.json. - Workflows —
find_workflows("", entity="StockCount")Before/After Save events voor StockCount. Bron:workflows.xml.