| Table Name: | MPCommissionAccrualPeriods |
| View Name: | MARICommissionAccrualPeriods |
| Group: | Group: MPCommissionAccrual |
| Description: | Commission: Monthly values for employee commission |
| ClassID: | 584. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| DocumentAccrualPeriodID | DocumentAccrualPeriodID INT Primary |
||
| DocumentAccrualID | DocumentAccrualID INT Index |
MPCommissionAccrual.DocumentAccrualID | |
| ContractCommissionID | ContractCommissionID INT Index |
MPVKVertraegeCommission.ContractCommissionID | |
| AccrualDate | AccrualDate Datetime |
||
| AccrualPeriod | AccrualPeriod INT Index |
MPPerioden.PeriodeJahr | |
| MPSalesDocumentID | MPSalesDocumentID INT Index |
MPVKVertraegeBelege.MPBelID | |
| ContractVolumeCalcSys | ContractVolumeCalcSys NUMERIC(19,6) |
||
| ContractVolumeCalcComp | ContractVolumeCalcComp NUMERIC(19,6) |
||
| ContractVolumeCalcFC | ContractVolumeCalcFC NUMERIC(19,6) |
||
| ContractVolumeSys | ContractVolumeSys NUMERIC(19,6) |
||
| ContractVolumeComp | ContractVolumeComp NUMERIC(19,6) |
||
| ContractVolumeFC | ContractVolumeFC NUMERIC(19,6) |
||
| DocumentSalesCalcSys | DocumentSalesCalcSys NUMERIC(19,6) |
||
| DocumentSalesCalcComp | DocumentSalesCalcComp NUMERIC(19,6) |
||
| DocumentSalesCalcFC | DocumentSalesCalcFC NUMERIC(19,6) |
||
| DocumentSalesSys | DocumentSalesSys NUMERIC(19,6) |
||
| DocumentSalesComp | DocumentSalesComp NUMERIC(19,6) |
||
| DocumentSalesFC | DocumentSalesFC NUMERIC(19,6) |
||
| SalesCurrency | SalesCurrency NVARCHAR (3) |
||
| CommissionFraction | CommissionFraction NUMERIC(19,6) |
||
| CommissionValueSys | CommissionValueSys NUMERIC(19,6) |
||
| CommissionValueComp | CommissionValueComp NUMERIC(19,6) |
||
| CommissionValueFC | CommissionValueFC NUMERIC(19,6) |
||
| CommissionCurrency | CommissionCurrency NVARCHAR (3) |
||
| AccrualBookingID | AccrualBookingID INT |
MPFiBuPositionen.TAN | |
| AccrualBookingLine | AccrualBookingLine INT |
MPFiBuPositionen.BuchungsNr | |
| AccrualStatus | AccrualStatus INT |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |