| Table Name: | MPVKVertraegeCommissionPos |
| View Name: | MARIContractCommissionPos |
| Group: | |
| Description: | Contract Management: Percentage for each position for the commission receipient |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ContractCommissionPosID | ContractCommissionPosID INT Primary |
||
| CommissionDate | CommissionDate Datetime |
||
| ContractCommissionID | ContractCommissionID INT Index |
||
| ContractID | ContractID INT |
MPVKVertraege.VertragsID | |
| ContractPositionID | ContractPositionID INT Index |
MPVKVertraegePositionen.Vertragsposition | |
| CommisionByItemFactor | CommisionByItemFactor NUMERIC(19,6) |
||
| VendorClassID | VendorClassID INT |
||
| Vendor | Vendor NVARCHAR (20) |
OCRD.CardCode | |
| Company | Company SMALLINT |
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 |
||
| 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 |