| View Name: | MARIAccountingProfitCenterPlanningLine |
| Based on table: | MPAccoutingProfitCenterPlanningLine |
| Group: | |
| Description: | Store the financial planning on profit center level per month |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| Company | Company SMALLINT Primary |
MARISysConnections.Company (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 |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| CreateDate | Erstanlage Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| UpdateStamp | UpdateStamp INT |