| View Name: | MARIPurchaseProcessDocumentCommision |
| Based on table: | MPEKVertraegeCommission |
| Group: | Group: MPEKVertraegeBelege |
| Description: | Purchase Process: Purchase Document Bonus definition |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ContractCommissionID | ContractCommissionID INT Primary |
||
| CommissionDate | CommissionDate Datetime |
||
| ContractID | ContractID INT Index |
MARIPurchaseProcess.ContractID | |
| VendorClassID | VendorClassID INT Index |
||
| Vendor | Vendor NVARCHAR (20) Index |
OCRD.CardCode | |
| Company | Company SMALLINT Index |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| CommissionTypeID | CommissionTypeID INT |
MARICommissionTypes.CommissionTypeID | |
| CommissionText | CommissionText NVARCHAR (50) |
||
| CommissionItem | CommissionItem NVARCHAR (50) |
||
| 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) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIPurchaseProcessDocumentCommisionPos | Purchase Process: Purchase Document Bonus position definition |