Bewerken: JobWeekLabour

Sectie: Properties

Reden:

## Properties

| Property | Type | Kolom | Width | Nullable | Default |
|----------|------|-------|-------|----------|---------|
| Id.JobWeek | JobWeek | JOBWLJOBID, JOBWLWEEK |  | false | ,  |
| Id.LineId | UltimoString | JOBWLLINEID | 9 | false |  |
| BookDate | Date? | JOBWLBOOKDATE |  | true |  |
| ChargeTariff | CompanyMoney | JOBWLCHARGETARIFF |  | false | 0 |
| Context | Context | JOBWLCONTEXT |  | false |  |
| Cost | CompanyMoney | JOBWLCOST |  | false | 0 |
| CostCenter | CostCenter | JOBWLCCRID |  | true |  |
| CostType | CostType | JOBWLCSTTID |  | true |  |
| Craftsman | Craftsman | JOBWLCRMID |  | true |  |
| Customer | Customer | JOBWLCUSID |  | true |  |
| DataProvider | UltimoString | JOBWLDATAPROVIDER | 50 | true |  |
| Day | Day | JOBWLDAYID |  | true |  |
| Department | Department | JOBWLDEPID |  | true |  |
| Discount | Decimal | JOBWLDISCOUNT |  | false | 0 |
| DiscountTariff | CompanyMoney | JOBWLDISCOUNTTARIFF |  | false | 0 |
| Employee | Employee | JOBWLEMPID |  | true |  |
| EmployeeLabourLine | EmployeeLabourLine | JOBWLEMPLLEMPID, JOBWLEMPLLWEEK, JOBWLEMPLLLINEID |  | true | , ,  |
| EmployeeLabourPeriod | EmployeeLabourPeriod | JOBWLEMPLPID |  | true |  |
| Equipment | Equipment | JOBWLEQMID |  | true |  |
| Exported | Boolean | JOBWLEXPORTED |  | false |  |
| ExternalId | UltimoString | JOBWLEXTERNALID | 50 | true |  |
| ExternalStatus | UltimoString | JOBWLEXTERNALSTATUS | 50 | true |  |
| Extra1 | Int16 | JOBWLEXTRA1 |  | false |  |
| Extra2 | Int32 | JOBWLEXTRA2 |  | false |  |
| Extra3 | UltimoString | JOBWLEXTRA3 | 5 | true |  |
| HourCode | HourCode | JOBWLHOURID |  | true |  |
| Hours | Decimal | JOBWLHOURS |  | false |  |
| HourTariffCategory | HourTariffCategory | JOBWLHTCID |  | true |  |
| InternalChargeLine | InternalChargeLine | JOBWLINVOID, JOBWLINVOLLINEID |  | true | ,  |
| InvoiceCost | CompanyMoney | JOBWLINVCOST |  | false | 0 |
| InvoiceHours | Decimal | JOBWLINVHOURS |  | false |  |
| OriginalStatus | Status | JOBWLORGRECSTATUS |  | false |  |
| ProcessFunction | ProcessFunction | JOBWLPRFID |  | true |  |
| Project | Project | JOBWLPRJID |  | true |  |
| ProviderMutationDate | DateTime? | JOBWLPROVIDERMUTDATE |  | true |  |
| RecordChangeDate | DateTime? | JOBWLRECCHANGEDATE |  | true |  |
| RecordCreateDate | DateTime? | JOBWLRECCREATEDATE |  | true | SYSDATETIME |
| RemainingHours | Decimal | JOBWLREMHOURS |  | false |  |
| RemarkText | UltimoString | JOBWLREMARKTEXT |  | true |  |
| SkillCategory | SkillCategory | JOBWLSKCID |  | true |  |
| Status | Status | JOBWLRECSTATUS |  | false |  |
| StatusApprovedDate | DateTime? | JOBWLAPPROVEDDATE |  | true |  |
| SystemCompany | Company | JOBWLCOMPID |  | false |  |
| Tariff | CompanyMoney | JOBWLTARIFF |  | false | 0 |
| TransferNextTime | Boolean | JOBWLTRANSFERNEXTTIME |  | false | 0 |
| Vat | Vat | JOBWLVATID |  | true |  |
| VatPercentage | Decimal | JOBWLVATPERCENTAGE |  | false | 0 |