| Table Name: | MPAccoutingProfitCenterPlanningLine |
| View Name: | MARIAccountingProfitCenterPlanningLine |
| Group: | |
| Description: | Store the financial planning on profit center level per month |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Company | Company SMALLINT Primary |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| AbsID | AbsID INT Primary |
||
| Line_ID | Line_ID INT Primary |
||
| Instance | Instance INT Index |
||
| DebLTotal | DebLTotal NUMERIC(19,6) |
||
| CredLTotal | CredLTotal NUMERIC(19,6) |
||
| DebSTotal | DebSTotal NUMERIC(19,6) |
||
| CredSTotal | CredSTotal NUMERIC(19,6) |
||
| DebRLTotal | DebRLTotal NUMERIC(19,6) |
||
| CrdRLTotal | CrdRLTotal NUMERIC(19,6) |
||
| DebRSTotal | DebRSTotal NUMERIC(19,6) |
||
| CrdRSTotal | CrdRSTotal NUMERIC(19,6) |
||
| FtrIDRLSum | FtrIDRLSum NUMERIC(19,6) |
||
| FtrIDRSSum | FtrIDRSSum NUMERIC(19,6) |
||
| FtrICRLSum | FtrICRLSum NUMERIC(19,6) |
||
| FtrICRSSum | FtrICRSSum NUMERIC(19,6) |
||
| FtrODRLSum | FtrODRLSum NUMERIC(19,6) |
||
| FtrOCRLSum | FtrOCRLSum NUMERIC(19,6) |
||
| FtrODRSSum | FtrODRSSum NUMERIC(19,6) |
||
| FtrOCRSSum | FtrOCRSSum NUMERIC(19,6) |
||
| MonthPrcnt | MonthPrcnt NUMERIC(19,6) |
||
| LineMemo | LineMemo NTEXT |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Erstanlage | CreateDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| UpdateStamp | UpdateStamp INT |