| Table Name: | MPCommissionDocuments |
| View Name: | MARICommissionDocuments |
| Group: | Group: MPCommissionAccrual |
| Description: | Commission: Sales Rep A/P Invoice Link |
| ClassID: | 290. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| CommissionDocumentID | CommissionDocumentID INT Primary |
||
| DocumentAccrualID | DocumentAccrualID INT Index |
MPCommissionAccrual.DocumentAccrualID | |
| TransactionType | TransactionType INT |
1=PM on payment, 2=SBO on payment | |
| BaseDocEntry | BaseDocEntry INT Index |
Link to Sales Document PaymentHead ORCT.DocEntry | ORCT.DocEntry |
| Company | Company SMALLINT Index |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| DocumentDate | DocumentDate Datetime |
||
| DocumentPeriod | DocumentPeriod INT |
||
| PaidDocumentCalcSys | PaidDocumentCalcSys NUMERIC(19,6) |
Original paid on the invoice (commissionable) | |
| PaidDocumentCalcComp | PaidDocumentCalcComp NUMERIC(19,6) |
||
| PaidDocumentCalcFC | PaidDocumentCalcFC NUMERIC(19,6) |
||
| PaidDocumentSys | PaidDocumentSys NUMERIC(19,6) |
Overwritten paid value commissionable | |
| PaidDocumentComp | PaidDocumentComp NUMERIC(19,6) |
||
| PaidDocumentFC | PaidDocumentFC NUMERIC(19,6) |
||
| SalesCurrency | SalesCurrency NVARCHAR (3) |
||
| 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) |
% of payment | |
| 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 | |
| DocumentStatus | DocumentStatus INT |
1=Created Based on Sales Document, 2=Closed by 100% payment, 3=Closed by reconsiliation | |
| MPDocumentID | MPDocumentID INT Index |
MPVKVertraegeBelege.MPBelID | |
| OPCHDocEntry | OPCHDocEntry INT |
OPCH.DocEntry | |
| Status | Status INT |
||
| SourceMode | SourceMode 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 |