| View Name: | MARIBankAccounts |
| Based on table: | MPBankverbindungen |
| Group: | |
| Description: | Bank Accounts: Used only for synchronization with other databases |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ID | ID INT Primary |
||
| Company | Mandant SMALLINT Primary |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| Address | Adresse INT Index |
||
| AmountPaid | Zahlung SMALLINT |
||
| DebitMode | Lastschrift SMALLINT |
||
| Attribut | Attribut INT |
||
| Matchcode | Matchcode NVARCHAR (40) Index |
||
| Memo | Bemerkung NVARCHAR (50) |
||
| Account | Konto NVARCHAR (35) |
||
| BankCode | BLZ NVARCHAR (8) |
||
| IBAN | IBAN NVARCHAR (34) |
||
| institute | Institut NVARCHAR (40) |
||
| DebitFlag | Lastschriftkennzeichen NVARCHAR (2) |
||
| DebitStandard | LastschriftStandard SMALLINT |
||
| SWIFT | Swift NVARCHAR (11) |
||
| Institute2 | Institut2 NVARCHAR (40) |
||
| Street | Strasse NVARCHAR (40) |
||
| City | Ort NVARCHAR (40) |
||
| Country | Laenderschluessel NVARCHAR (3) |
||
| paymentMethod | Zahlungsart NVARCHAR (2) |
||
| paymenStandard | ZahlungStandard SMALLINT |
||
| BankText1 | Weisungscode1 NVARCHAR (2) |
||
| BankText2 | Weisungscode2 NVARCHAR (2) |
||
| BankText3 | Weisungscode3 NVARCHAR (2) |
||
| BankText4 | Weisungscode4 NVARCHAR (2) |
||
| BankText5 | Weisungszusatz NVARCHAR (25) |
||
| OrderInfo1 | Ordervermerk1 NVARCHAR (35) |
||
| OrderInfo2 | Ordervermerk2 NVARCHAR (35) |
||
| CostInfo | Kostenverrechnung NVARCHAR (2) |
||
| FinanceMessage | BuBaMeldung NVARCHAR (1) |
||
| PayRoleFlag | Entgeltregelung SMALLINT |
||
| TransactionType | Transaktionsart SMALLINT |
||
| UpdateStamp | UpdateStamp INT |