title: "PickList" category: reference tags: [entity, pick-list, datamodel] source: Entities.xml date: 2026-04-17 status: published
PickList
Type: Entity Properties: 28 Contexts: 2 Statussen: 5
Zie ook het handgeschreven artikel: pick-list
DB-schema:
lookup_table_schema("PickList")· ../tables/PickList
Contextsbewerken
- 0: Standaard (
PickListContext.None) - 2: Jobmateriaal (
PickListContext.JobMaterial)
Statussenbewerken
- -1: Trash (
PickListStatus.Trash) - 0: None (
PickListStatus.None) - 1: Open (
PickListStatus.Created) - 2: Actief (
PickListStatus.Active) - 4: Verwerkt (
PickListStatus.Processed)
Propertiesbewerken
| Property | Type | Kolom | Width | Nullable | Default |
|---|---|---|---|---|---|
| Id | UltimoString | PLTID | 9 | false | |
| Activate | Boolean | PLTACTIVATE | false | 0 | |
| Context | Context | PLTCONTEXT | false | ||
| DataProvider | UltimoString | PLTDATAPROVIDER | 50 | true | |
| Employee | Employee | PLTEMPID | true | USERID | |
| Exported | Boolean | PLTEXPORTED | false | 0 | |
| ExternalId | UltimoString | PLTEXTERNALID | 50 | true | |
| ExternalStatus | UltimoString | PLTEXTERNALSTATUS | 50 | true | |
| Job | Job | PLTJOBID | true | ||
| PickListRun | PickListRun | PLTPLTRID | true | ||
| ProviderMutationDate | DateTime? | PLTPROVIDERMUTDATE | true | ||
| PurchaseRequest | PurchaseRequest | PLTPCHRID | true | ||
| RecordCreateDate | DateTime? | PLTRECCREATEDATE | true | SYSDATETIME | |
| Remarks | UltimoString | PLTTEXT | true | ||
| ShowLinesForAllArticles | Boolean | PLTSHOWLINESFORALLARTICLES | false | 0 | |
| Site | Site | PLTSITID | true | ||
| Status | Status | PLTRECSTATUS | false | 1 | |
| StatusActivatedDate | DateTime? | PLTACTIVATEDDATE | true | ||
| StatusActivatedEmployee | Employee | PLTACTIVATEDEMPID | true | ||
| StatusCreatedDate | DateTime? | PLTCREATEDDATE | true | SYSDATETIME | |
| StatusCreatedEmployee | Employee | PLTCREATEDEMPID | true | USERID | |
| StatusProcessedDate | DateTime? | PLTPROCESSEDDATE | true | ||
| StatusProcessedEmployee | Employee | PLTPROCESSEDEMPID | true | ||
| SystemCompany | Company | PLTCOMPID | false | ||
| ToWarehouse | Warehouse | PLTTOWHSID | true | ||
| ToWarehouseLocation | WarehouseLocation | PLTTOWHSLWHSID, PLTTOWHSLCODE | true | , | |
| TransferNextTime | Boolean | PLTTRANSFERNEXTTIME | false | 0 | |
| Warehouse | Warehouse | PLTWHSID | true |
Brondatabewerken
- Entity-definitie —
lookup_entity("PickList")Model-perspectief (properties, contexts, statussen). Bron:Entities.xml. - DB-schema —
lookup_table_schema("PickList")· ../tables/PickList DB-perspectief (triggers, computed, defaults). Bron:database-schema.json. - Workflows —
find_workflows("", entity="PickList")Before/After Save events voor PickList. Bron:workflows.xml.