| Table Name: | MPCommissionAccrual |
| View Name: | MARICommissionAccrual |
| Group: | Group: MPCommissionAccrual |
| Description: | Commission: Stores the Accrual on Sales Invoicing Time (Project related) |
| ClassID: | 288. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| DocumentAccrualID | DocumentAccrualID INT Primary |
||
| ContractCommissionID | ContractCommissionID INT Index |
MPVKVertraegeCommission.ContractCommissionID | |
| AccrualDate | AccrualDate Datetime |
||
| AccrualPeriod | AccrualPeriod INT |
MPPerioden.PeriodeJahr | |
| MPSalesDocumentID | SalesDocumentID 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 | ContractVolumeLoc NUMERIC(19,6) |
||
| ContractVolumeFC | ContractVolumeFC NUMERIC(19,6) |
||
| DocumentSalesCalcSys | DocumentSalesCalcSys NUMERIC(19,6) |
||
| DocumentSalesCalcComp | DocumentSalesCalcLoc NUMERIC(19,6) |
||
| DocumentSalesCalcFC | DocumentSalesCalcFC NUMERIC(19,6) |
||
| DocumentSalesSys | DocumentSalesSys NUMERIC(19,6) |
||
| DocumentSalesComp | DocumentSalesLoc NUMERIC(19,6) |
||
| DocumentSalesFC | DocumentSalesFC NUMERIC(19,6) |
||
| SalesCurrency | SalesCurrency NVARCHAR (3) |
||
| CommissionFraction | CommissionFraction NUMERIC(19,6) |
||
| CommissionValueSys | CommissionValueSys NUMERIC(19,6) |
||
| CommissionValueComp | CommissionValueLoc 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 |
| Table | Description |
|---|---|
| MPCommissionAccrualPeriods | Commission: Monthly values for employee commission |
| MPCommissionDocuments | Commission: Sales Rep A/P Invoice Link |