| Table Name: | MPTrainingRegistrationContractLink |
| View Name: | MARITrainingRegistrationContractLink |
| Group: | Group: TrainingParticipant |
| Description: | Training Module: Selection of billable contract positions (Contract from registration) |
| ClassID: | 441. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| RegistrationContractLinkID | RegistrationContractLinkID INT Primary |
||
| RegistrationID | RegistrationID INT Index |
MPTrainingRegistration.RegistrationID | |
| Contract | Contract INT |
MPVKVertraege.VertragsID | |
| ContractPosition | ContractPosition INT |
MPVKVertraegePositionen.Vertragsposition | |
| BaseContractID | BaseContractID INT |
MPVKVertraege.VertragsID | |
| BaseContractPosition | BaseContractPosition INT |
MPVKVertraegePositionen.Vertragsposition | |
| Quantity | Quantity NUMERIC(19,6) |
||
| InvoiceMethod | InvoiceMethod INT |
||
| WorkItemPosID | WorkItemPosID INT Index |
MPWorkItemPosition.WorkItemPosID | |
| PriceMode | PriceMode INT |
||
| NetUnitPriceSys | NetUnitPriceSys NUMERIC(19,6) |
||
| NetUnitPriceLoc | NetUnitPriceLoc NUMERIC(19,6) |
||
| NetUnitPriceFC | NetUnitPriceFC NUMERIC(19,6) |
||
| CurrencySys | CurrencySys NVARCHAR (3) |
||
| CurrencyLoc | CurrencyLoc NVARCHAR (3) |
||
| CurrencyFC | CurrencyFC NVARCHAR (3) |
||
| CurrencyRateLoc | CurrencyRateLoc Float |
||
| CurrencyRateFc | CurrencyRateFc Float |
||
| Option1 | Option1 INT |
||
| Option2 | Option2 NVARCHAR (20) |