| Table Name: | MPCommissionDocumentPositions |
| View Name: | MARICommissionDocumentPositions |
| Group: | Group: MPCommissionAccrual |
| Description: | Commission: Sales Rep A/P Invoice Position Link |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| CommissionDocumentPosID | CommissionDocumentPosID INT Primary |
||
| CommissionDocumentID | CommissionDocumentID INT Index |
||
| PaidDocumentCalcSys | PaidDocumentCalcSys NUMERIC(19,6) |
||
| PaidDocumentCalcComp | PaidDocumentCalcComp NUMERIC(19,6) |
||
| PaidDocumentCalcFC | PaidDocumentCalcFC NUMERIC(19,6) |
||
| PaidDocumentSys | PaidDocumentSys NUMERIC(19,6) |
||
| PaidDocumentComp | PaidDocumentComp NUMERIC(19,6) |
||
| PaidDocumentFC | PaidDocumentFC NUMERIC(19,6) |
||
| CommissionFractionCalc | CommissionFractionCalc NUMERIC(19,6) |
||
| CommissionValueCalcSys | CommissionValueCalcSys NUMERIC(19,6) |
||
| CommissionValueCalcComp | CommissionValueCalcComp NUMERIC(19,6) |
||
| CommissionValueCalcFC | CommissionValueCalcFC NUMERIC(19,6) |
||
| CommissionFraction | CommissionFraction NUMERIC(19,6) |
||
| CommissionValueSys | CommissionValueSys NUMERIC(19,6) |
||
| CommissionValueComp | CommissionValueComp NUMERIC(19,6) |
||
| CommissionValueFC | CommissionValueFC NUMERIC(19,6) |
||
| MPBelPosID | MARIDocPosID INT Index |
MPVKVertraegeBelegePositionen.MPBelPosID | |
| 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 |