| Table Name: | MPVKVertraegeCommission |
| View Name: | MARIContractCommission |
| Group: | Group: Contract |
| Description: | Contract Management: Link Sales Representetive to Contract |
| ClassID: | 295. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ContractCommissionID | ContractCommissionID INT Primary |
||
| CommissionDate | CommissionDate Datetime |
||
| ContractID | ContractID INT Index |
MPVKVertraege.VertragsID | |
| VendorClassID | VendorClassID INT Index |
ClassID | |
| Vendor | Vendor NVARCHAR (20) Index |
Business Partner | OCRD.CardCode |
| Company | Company SMALLINT Index |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| CommissionTypeID | CommissionTypeID INT |
MPCommissionTypes.CommissionTypeID | |
| CommissionText | CommissionText NVARCHAR (50) |
||
| CommissionItem | CommissionItem NVARCHAR (50) |
OITM.ItemCode | |
| CommissionPercent | CommissionPercent NUMERIC(19,6) |
||
| CommissionValueSys | CommissionValueSys NUMERIC(19,6) |
||
| CommissionValueComp | CommissionValueComp NUMERIC(19,6) |
||
| CommissionValueFC | CommissionValueFC NUMERIC(19,6) |
||
| CommissionCurr | CommissionCurr NVARCHAR (3) |
||
| CommisionByItemMode | CommisionByItemMode INT |
||
| CommisionByItemFactor | CommisionByItemFactor NUMERIC(19,6) |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPCommissionAccrual | Commission: Stores the Accrual on Sales Invoicing Time (Project related) |
| MPCommissionAccrualPeriods | Commission: Monthly values for employee commission |