| View Name: | MARIBankStatement |
| Based on table: | MPKontoauszuege |
| Group: | |
| Description: | Header of a bank statement like OBNH |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| MPImportID | MPImportID INT Primary |
Uniwue Key | |
| MPCompanyID | MPCompanyID SMALLINT Index |
MARISysConnections.MPCompanyID (WHERE ConnectionType=6) | |
| IdNumber | IdNumber INT Index |
||
| ActKey | ActKey INT Index |
||
| BSNum | BSNum INT |
||
| BSDate | BSDate Datetime |
||
| Status | Status NVARCHAR (1) |
||
| Imported | Imported NVARCHAR (1) |
||
| StrtBlncF | StrtBlncF NUMERIC(19,6) |
||
| EndBlncF | EndBlncF NUMERIC(19,6) |
||
| Currency | Currency NVARCHAR (3) |
||
| StrtBlncL | StrtBlncL NUMERIC(19,6) |
||
| EndBlncL | EndBlncL NUMERIC(19,6) |
||
| FileCRC | FileCRC NVARCHAR (32) |
||
| StmtGuid | StmtGuid NVARCHAR (32) |
||
| BSFileNum | BSFileNum NVARCHAR (50) |
||
| PeriodAbs | PeriodAbs INT |
||
| DfltBPL | DfltBPL INT |
||
| OrigBSDate | OrigBSDate Datetime |
| Table | Description |
|---|---|
| MARIBankStatementLine | Booking line of a bank statement |