| View Name: | MARICommissionAccrualSBO |
| Based on table: | MPCommissionAccrualSBO |
| Group: | Group: MPCommissionAccrual |
| Description: | Commission: Stores the Accrual on Sales Invoicing Time (None Project related) |
| ClassID: | 289. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| DocumentAccrualID | DocumentAccrualID INT Primary |
||
| AccrualDate | AccrualDate Datetime |
||
| AccrualPeriod | AccrualPeriod INT |
MARIPeriods.AccrualPeriod | |
| Company | Company SMALLINT Index |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| ORDRDocEntry | ORDRDocEntry INT Index |
Sales Order | ORDR.DocEntry |
| OSLPCode | OSLPCode INT Index |
Sales Person | OSLP.SlpCode |
| Vendor | Vendor NVARCHAR (20) |
Creditor | OCRD.CardCode |
| CommissionPercent | CommissionPercent NUMERIC(19,6) |
||
| CommissionValueSys | CommissionValueSys NUMERIC(19,6) |
||
| CommissionValueComp | CommissionValueComp NUMERIC(19,6) |
||
| CommissionValueFC | CommissionValueFC NUMERIC(19,6) |
||
| DocObject | DocObject INT Index |
13 OINV or 14 ORIN | |
| DocEntry | DocEntry INT Index |
Invoice or Credit Note | OINV.DocEntry |
| OrderVolumeCalcSys | OrderVolumeCalcSys NUMERIC(19,6) |
||
| OrderVolumeCalcComp | OrderVolumeCalcComp NUMERIC(19,6) |
||
| OrderVolumeCalcFC | OrderVolumeCalcFC NUMERIC(19,6) |
||
| OrderVolumeSys | OrderVolumeSys NUMERIC(19,6) |
Overwritten commissionable volume | |
| OrderVolumeComp | OrderVolumeComp NUMERIC(19,6) |
||
| OrderVolumeFC | OrderVolumeFC NUMERIC(19,6) |
||
| DocumentSalesCalcSys | DocumentSalesCalcSys NUMERIC(19,6) |
Original value on the document commissionable | |
| DocumentSalesCalcComp | DocumentSalesCalcComp NUMERIC(19,6) |
||
| DocumentSalesCalcFC | DocumentSalesCalcFC NUMERIC(19,6) |
||
| DocumentSalesSys | DocumentSalesSys NUMERIC(19,6) |
Overwritten on the document commissionable | |
| DocumentSalesComp | DocumentSalesComp NUMERIC(19,6) |
||
| DocumentSalesFC | DocumentSalesFC NUMERIC(19,6) |
||
| SalesCurrency | SalesCurrency NVARCHAR (3) |
||
| DocCommissionFraction | DocCommissionFraction NUMERIC(19,6) |
% of total | |
| DocCommissionValueSys | DocCommissionValueSys NUMERIC(19,6) |
||
| DocCommissionValueComp | DocCommissionValueComp NUMERIC(19,6) |
||
| DocCommissionValueFC | DocCommissionValueFC NUMERIC(19,6) |
||
| CommissionCurrency | CommissionCurrency NVARCHAR (3) |
||
| AccrualBookingID | AccrualBookingID INT |
MARIJournalEntryExport.AccrualBookingID | |
| AccrualBookingLine | AccrualBookingLine INT |
MARIJournalEntryExport.AccrualBookingLine | |
| AccrualStatus | AccrualStatus INT |
1=Created Based on Sales Document, 2=Closed by 100% payment, 3=Closed by reconsiliation | |
| 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 |