Bewerken: JobTool

Sectie: Properties

Reden:

## Properties

| Property | Type | Kolom | Width | Nullable | Default |
|----------|------|-------|-------|----------|---------|
| Id.Job | Job | JOBTJOBID |  | false |  |
| Id.LineId | UltimoString | JOBTLINEID | 9 | false |  |
| BookDate | Date? | JOBTBOOKDATE |  | true | SYSDATE |
| Context | Context | JOBTCONTEXT |  | false |  |
| Cost | CompanyMoney | JOBTCOST |  | false | 0 |
| CostCalculated | CompanyMoney | JOBTCOSTCALC |  | false | 0 |
| CostCenter | CostCenter | JOBTCCRID |  | true |  |
| CostType | CostType | JOBTCSTTID |  | true |  |
| Customer | Customer | JOBTCUSID |  | true |  |
| DataProvider | UltimoString | JOBTDATAPROVIDER | 50 | true |  |
| Department | Department | JOBTDEPID |  | true |  |
| Equipment | Equipment | JOBTEQMID |  | true |  |
| Exported | Boolean | JOBTEXPORTED |  | false |  |
| ExternalId | UltimoString | JOBTEXTERNALID | 50 | true |  |
| ExternalStatus | UltimoString | JOBTEXTERNALSTATUS | 50 | true |  |
| Extra1 | Int16 | JOBTEXTRA1 |  | false |  |
| Extra2 | Decimal | JOBTEXTRA2 |  | false |  |
| Extra3 | UltimoString | JOBTEXTRA3 | 5 | true |  |
| Hours | Decimal | JOBTHOURS |  | false |  |
| HoursCalculated | Decimal | JOBTHOURSCALC |  | false |  |
| InternalChargeLine | InternalChargeLine | JOBTINVOID, JOBTINVOLLINEID |  | true | ,  |
| InvoiceCost | CompanyMoney | JOBTINVCOST |  | false | 0 |
| InvoiceHours | Decimal | JOBTINVHOURS |  | false | 0 |
| InvoiceQuantity | Decimal | JOBTINVQTY |  | false |  |
| JobJobPlan | JobJobPlan | JOBTJOBJPLID |  | true |  |
| JobPlan | JobPlan | JOBTJPID |  | true |  |
| OriginalStatus | Status | JOBTORGRECSTATUS |  | false |  |
| ProcessFunction | ProcessFunction | JOBTPRFID |  | true |  |
| Project | Project | JOBTPRJID |  | true |  |
| ProviderMutationDate | DateTime? | JOBTPROVIDERMUTDATE |  | true |  |
| Quantity | Decimal | JOBTQTY |  | false |  |
| QuantityCalculated | Decimal | JOBTQTYCALC |  | false |  |
| RecordCreateDate | DateTime? | JOBTRECCREATEDATE |  | true | SYSDATETIME |
| SkillCategory | SkillCategory | JOBTSKCID |  | true |  |
| Status | Status | JOBTRECSTATUS |  | false | 1 |
| SystemCompany | Company | JOBTCOMPID |  | false |  |
| Tariff | CompanyMoney | JOBTTARIFF |  | false | 0 |
| TariffCalculated | CompanyMoney | JOBTTARIFFCALC |  | false | 0 |
| Tool | Tool | JOBTTLSID |  | true |  |
| TransferNextTime | Boolean | JOBTTRANSFERNEXTTIME |  | false | 0 |
| Vat | Vat | JOBTVATID |  | true |  |
| VatPercentage | Decimal | JOBTVATPERCENTAGE |  | false | 0 |
| Week | WeekOfYear | JOBTWEEK |  | false |  |