title: "JobMaterial" category: reference tags: [entity, job-material, datamodel] source: Entities.xml date: 2026-04-17 status: published
JobMaterial
Type: Entity Properties: 59 Contexts: 1 Statussen: 9
Zie ook het handgeschreven artikel: job-material
Contextsbewerken
- 0: Standaard (
JobMaterialContext.None)
Statussenbewerken
- -1: Trash (
JobMaterialStatus.Trash) - 0: None (
JobMaterialStatus.None) - 1: Open (
JobMaterialStatus.Created) - 2: Goedgekeurd (
JobMaterialStatus.Approved) - 512: Factuurvoorstel (
JobMaterialStatus.InvoiceProposal) - 1024: 0 factureren (
JobMaterialStatus.InvoiceZero) - 2048: Volgende run (
JobMaterialStatus.InvoiceNextRun) - 8192: Uitgesteld (
JobMaterialStatus.Postponed) - 16384: Gefactureerd (
JobMaterialStatus.Invoiced)
Propertiesbewerken
| Property | Type | Kolom | Width | Nullable | Default |
|---|---|---|---|---|---|
| Id.Job | Job | JOBMJOBID | false | ||
| Id.LineId | UltimoString | JOBMLINEID | 9 | false | |
| Article | Article | JOBMARTID | true | ||
| ArticleReserved | Boolean | JOBMARTRESERVED | false | 0 | |
| BookDate | Date? | JOBMBOOKDATE | true | SYSDATE | |
| CatalogArticle | Article | JOBMCATARTID | true | ||
| ChargeRaisePercentage | Decimal | JOBMCHARGERAISEPERC | false | 0 | |
| Context | Context | JOBMCONTEXT | false | ||
| Cost | CompanyMoney | JOBMCOST | false | 0 | |
| CostCalculated | CompanyMoney | JOBMCOSTCALC | false | 0 | |
| CostCalculatedDecimals | Int16 | JOBMCOSTCALCDECIMALS | false | ||
| CostCenter | CostCenter | JOBMCCRID | true | ||
| CostDecimals | Int16 | JOBMCOSTDECIMALS | false | ||
| CostType | CostType | JOBMCSTTID | true | ||
| Customer | Customer | JOBMCUSID | true | ||
| DataProvider | UltimoString | JOBMDATAPROVIDER | 50 | true | |
| DeliveryTime | Time? | JOBMDLVTIME | true | ||
| Department | Department | JOBMDEPID | true | ||
| Discount | Decimal | JOBMDISCOUNT | false | 0 | |
| DiscountTariff | CompanyMoney | JOBMDISCOUNTTARIFF | false | 0 | |
| Equipment | Equipment | JOBMEQMID | true | ||
| Exported | Boolean | JOBMEXPORTED | false | ||
| ExternalId | UltimoString | JOBMEXTERNALID | 50 | true | |
| ExternalStatus | UltimoString | JOBMEXTERNALSTATUS | 50 | true | |
| Extra1 | Int16 | JOBMEXTRA1 | false | ||
| Extra2 | Int32 | JOBMEXTRA2 | false | ||
| Extra3 | UltimoString | JOBMEXTRA3 | 5 | true | |
| InternalChargeLine | InternalChargeLine | JOBMINVOID, JOBMINVOLLINEID | true | , | |
| InvoiceCost | CompanyMoney | JOBMINVCOST | false | 0 | |
| InvoiceQuantity | Decimal | JOBMINVQTY | false | ||
| JobJobPlan | JobJobPlan | JOBMJOBJPLID | true | ||
| JobPlan | JobPlan | JOBMJPID | true | ||
| OriginalReservedQuantity | Decimal | JOBMORGRESQTY | false | ||
| OriginalStatus | Status | JOBMORGRECSTATUS | false | ||
| PickedQuantity | Decimal | JOBMPICKEDQUANTITY | false | 0 | |
| PickListLines | List[PickListLine] | PLTLJOBMJOBID, PLTLJOBMLINEID | true | , | |
| PlannedQuantity | Decimal | JOBMPLANQTY | false | ||
| Price | CompanyMoney | JOBMPRICE | false | 0 | |
| PriceCalculated | CompanyMoney | JOBMPRICECALC | false | 0 | |
| ProcessFunction | ProcessFunction | JOBMPRFID | true | ||
| Project | Project | JOBMPRJID | true | ||
| ProviderMutationDate | DateTime? | JOBMPROVIDERMUTDATE | true | ||
| QuantityIn | Decimal | JOBMQTYIN | false | ||
| QuantityOut | Decimal | JOBMQTY | false | ||
| RaisePercentage | Decimal | JOBMRAISEPERC | false | 0 | |
| RecordCreateDate | DateTime? | JOBMRECCREATEDATE | true | SYSDATETIME | |
| ReservedQuantity | Decimal | JOBMRESQTY | false | ||
| Site | Site | JOBMSITID | true | ||
| SkillCategory | SkillCategory | JOBMSKCID | true | ||
| Status | Status | JOBMRECSTATUS | false | ||
| SystemCompany | Company | JOBMCOMPID | false | ||
| TotalPrice | CompanyMoney | JOBMTOTALPRICE | false | 0 | |
| TotalPriceDecimals | Int16 | JOBMTOTALPRICEDECIMALS | false | ||
| TransferNextTime | Boolean | JOBMTRANSFERNEXTTIME | false | 0 | |
| Vat | Vat | JOBMVATID | true | ||
| VatPercentage | Decimal | JOBMVATPERCENTAGE | false | 0 | |
| Warehouse | Warehouse | JOBMWHSID | true | ||
| WarehouseLocation | WarehouseLocation | JOBMWHSLWHSID, JOBMWHSLCODE | true | , | |
| WarehouseServeOutline | WarehouseServeOutline | JOBMWHSOID, JOBMWHSOLLINEID | true | , |
Brondatabewerken
- Entity-definitie —
lookup_entity("JobMaterial")Model-perspectief (properties, contexts, statussen). Bron:Entities.xml. - Workflows —
find_workflows("", entity="JobMaterial")Before/After Save events voor JobMaterial. Bron:workflows.xml.