| View Name: | MARICommissionAccrual |
| Based on table: | MPCommissionAccrual |
| Group: | Group: MPCommissionAccrual |
| Description: | Commission: Stores the Accrual on Sales Invoicing Time (Project related) |
| ClassID: | 288. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| DocumentAccrualID | DocumentAccrualID INT Primary |
||
| ContractCommissionID | ContractCommissionID INT Index |
MARIContractCommission.ContractCommissionID | |
| AccrualDate | AccrualDate Datetime |
||
| AccrualPeriod | AccrualPeriod INT |
MARIPeriods.AccrualPeriod | |
| SalesDocumentID | MPSalesDocumentID INT Index |
MARIContractDocument.SalesDocumentID | |
| ContractVolumeCalcSys | ContractVolumeCalcSys NUMERIC(19,6) |
||
| ContractVolumeCalcComp | ContractVolumeCalcComp NUMERIC(19,6) |
||
| ContractVolumeCalcFC | ContractVolumeCalcFC NUMERIC(19,6) |
||
| ContractVolumeSys | ContractVolumeSys NUMERIC(19,6) |
||
| ContractVolumeLoc | ContractVolumeComp NUMERIC(19,6) |
||
| ContractVolumeFC | ContractVolumeFC NUMERIC(19,6) |
||
| DocumentSalesCalcSys | DocumentSalesCalcSys NUMERIC(19,6) |
||
| DocumentSalesCalcLoc | DocumentSalesCalcComp NUMERIC(19,6) |
||
| DocumentSalesCalcFC | DocumentSalesCalcFC NUMERIC(19,6) |
||
| DocumentSalesSys | DocumentSalesSys NUMERIC(19,6) |
||
| DocumentSalesLoc | DocumentSalesComp NUMERIC(19,6) |
||
| DocumentSalesFC | DocumentSalesFC NUMERIC(19,6) |
||
| SalesCurrency | SalesCurrency NVARCHAR (3) |
||
| CommissionFraction | CommissionFraction NUMERIC(19,6) |
||
| CommissionValueSys | CommissionValueSys NUMERIC(19,6) |
||
| CommissionValueLoc | CommissionValueComp NUMERIC(19,6) |
||
| CommissionValueFC | CommissionValueFC NUMERIC(19,6) |
||
| CommissionCurrency | CommissionCurrency NVARCHAR (3) |
||
| AccrualBookingID | AccrualBookingID INT |
MARIJournalEntryExport.AccrualBookingID | |
| AccrualBookingLine | AccrualBookingLine INT |
MARIJournalEntryExport.AccrualBookingLine | |
| AccrualStatus | AccrualStatus INT |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARICommissionDocuments | Commission: Sales Rep A/P Invoice Link |
| MARICommissionAccrualPeriods | Commission: Monthly values for employee commission |