Bewerken: JobResource

Sectie: Properties

Reden:

## Properties

| Property | Type | Kolom | Width | Nullable | Default |
|----------|------|-------|-------|----------|---------|
| Id.Job | Job | JOBRJOBID |  | false |  |
| Id.LineId | UltimoString | JOBRLINEID | 9 | false |  |
| BookDate | Date? | JOBRBOOKDATE |  | true | SYSDATE |
| Context | Context | JOBRCONTEXT |  | false |  |
| CostCalculated | CompanyMoney | JOBRCOSTCALC |  | false | 0 |
| CostCenter | CostCenter | JOBRCCRID |  | true |  |
| CostType | CostType | JOBRCSTTID |  | true |  |
| Craftsman | Craftsman | JOBRCRMID |  | true |  |
| Customer | Customer | JOBRCUSID |  | true |  |
| DataProvider | UltimoString | JOBRDATAPROVIDER | 50 | true |  |
| Department | Department | JOBRDEPID |  | true |  |
| Discount | Decimal | JOBRDISCOUNT |  | false | 0 |
| DiscountTariff | CompanyMoney | JOBRDISCOUNTTARIFF |  | false | 0 |
| Equipment | Equipment | JOBREQMID |  | true |  |
| ExceedsOriginalTimeEstimate | Boolean | JOBREXCEEDSORIGINALTIMEESTIMATE |  | false |  |
| Exported | Boolean | JOBREXPORTED |  | false |  |
| ExternalId | UltimoString | JOBREXTERNALID | 50 | true |  |
| ExternalStatus | UltimoString | JOBREXTERNALSTATUS | 50 | true |  |
| Extra1 | Int16 | JOBREXTRA1 |  | false |  |
| Extra2 | Int32 | JOBREXTRA2 |  | false |  |
| Extra3 | UltimoString | JOBREXTRA3 | 5 | true |  |
| HoursCalculated | Decimal | JOBRHOURSCALC |  | false |  |
| HoursToPlan | Decimal | JOBRHOURSTOPLAN |  | false |  |
| InternalChargeLine | InternalChargeLine | JOBRINVOID, JOBRINVOLLINEID |  | true | ,  |
| InvoiceCost | CompanyMoney | JOBRINVCOST |  | false | 0 |
| InvoiceHours | Decimal | JOBRINVHOURS |  | false | 0 |
| JobJobPlan | JobJobPlan | JOBRJOBJPLID |  | true |  |
| JobPlan | JobPlan | JOBRJPID |  | true |  |
| JobScheduleParts | List[JobSchedulePart] | JOBSPJOBRJOBID, JOBSPJOBRLINEID |  | true | ,  |
| NextWeek | Int16 | JOBRNEXTWEEK |  | false |  |
| OriginalStatus | Int32 | JOBRORGRECSTATUS |  | false | 0 |
| ProcessFunction | ProcessFunction | JOBRPRFID |  | true |  |
| Project | Project | JOBRPRJID |  | true |  |
| ProviderMutationDate | DateTime? | JOBRPROVIDERMUTDATE |  | true |  |
| QuantityCalculated | Decimal | JOBRQTYCALC |  | false |  |
| RecordCreateDate | DateTime? | JOBRRECCREATEDATE |  | true | SYSDATETIME |
| SkillCategory | SkillCategory | JOBRSKCID |  | true |  |
| Status | Status | JOBRRECSTATUS |  | false |  |
| SystemCompany | Company | JOBRCOMPID |  | false |  |
| TariffCalculated | CompanyMoney | JOBRTARIFFCALC |  | false | 0 |
| TotalHoursPlanned | Decimal | JOBRTOTALHOURSPLANNED |  | false | 0 |
| TransferNextTime | Boolean | JOBRTRANSFERNEXTTIME |  | false | 0 |
| Vat | Vat | JOBRVATID |  | true |  |
| VatPercentage | Decimal | JOBRVATPERCENTAGE |  | false | 0 |
| Week | WeekOfYear | JOBRWEEK |  | false |  |