Bewerken: JobMaterial

Sectie: Properties

Reden:

## Properties

| 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 | ,  |