Bewerken: JobExternal

Sectie: Properties

Reden:

## Properties

| Property | Type | Kolom | Width | Nullable | Default |
|----------|------|-------|-------|----------|---------|
| Id.Job | Job | JOBEJOBID |  | false |  |
| Id.LineId | UltimoString | JOBELINEID | 9 | false |  |
| BookDate | Date? | JOBEBOOKDATE |  | true | SYSDATE |
| Context | Context | JOBECONTEXT |  | false |  |
| Cost | CompanyMoney | JOBECOST |  | false | 0 |
| CostCalculated | CompanyMoney | JOBECOSTCALC |  | false | 0 |
| CostCenter | CostCenter | JOBECCRID |  | true |  |
| CostType | CostType | JOBECSTTID |  | true |  |
| Customer | Customer | JOBECUSID |  | true |  |
| DataProvider | UltimoString | JOBEDATAPROVIDER | 50 | true |  |
| Department | Department | JOBEDEPID |  | true |  |
| Description | UltimoString | JOBEDESCR | 200 | true |  |
| Equipment | Equipment | JOBEEQMID |  | true |  |
| Exported | Boolean | JOBEEXPORTED |  | false |  |
| External | External | JOBEEXT |  | true |  |
| ExternalId | UltimoString | JOBEEXTERNALID | 50 | true |  |
| ExternalStatus | UltimoString | JOBEEXTERNALSTATUS | 50 | true |  |
| Extra1 | Int16 | JOBEEXTRA1 |  | false |  |
| Extra2 | Decimal | JOBEEXTRA2 |  | false |  |
| Extra3 | UltimoString | JOBEEXTRA3 | 5 | true |  |
| InternalChargeLine | InternalChargeLine | JOBEINVOID, JOBEINVOLLINEID |  | true | ,  |
| InvoiceCost | CompanyMoney | JOBEINVCOST |  | false | 0 |
| InvoiceQuantity | Decimal | JOBEINVQTY |  | false |  |
| JobJobPlan | JobJobPlan | JOBEJOBJPLID |  | true |  |
| JobPlan | JobPlan | JOBEJPID |  | true |  |
| OriginalStatus | Status | JOBEORGRECSTATUS |  | false |  |
| ProcessFunction | ProcessFunction | JOBEPRFID |  | true |  |
| Project | Project | JOBEPRJID |  | true |  |
| ProviderMutationDate | DateTime? | JOBEPROVIDERMUTDATE |  | true |  |
| PurchaseStatus | Status | JOBEPCHSTATUS |  | false |  |
| Quantity | Decimal | JOBEQTY |  | false |  |
| QuantityCalculated | Decimal | JOBEQTYCALC |  | false |  |
| RecordCreateDate | DateTime? | JOBERECCREATEDATE |  | true | SYSDATETIME |
| SkillCategory | SkillCategory | JOBESKCID |  | true |  |
| Status | Status | JOBERECSTATUS |  | false | 1 |
| SystemCompany | Company | JOBECOMPID |  | false |  |
| Tariff | CompanyMoney | JOBETARIFF |  | false | 0 |
| TariffCalculated | CompanyMoney | JOBETARIFFCALC |  | false | 0 |
| TransferNextTime | Boolean | JOBETRANSFERNEXTTIME |  | false | 0 |
| Unit | UltimoString | JOBEUNIT | 5 | true |  |
| Vat | Vat | JOBEVATID |  | true |  |
| VatPercentage | Decimal | JOBEVATPERCENTAGE |  | false | 0 |
| Vendor | Vendor | JOBEVDRID |  | true |  |
| Week | WeekOfYear | JOBEWEEK |  | false |  |