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