| Table Name: | MPKontoauszuegeZeilen |
| View Name: | MARIBankStatementLine |
| Group: | |
| Description: | Booking line of a bank statement |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| MPImportLineID | MPImportLineID INT Primary |
||
| MPImportID | MPImportID INT Index |
MPKontoauszuege.MPImportID | |
| IdNumber | IdNumber INT Index |
||
| AcctCode | AcctCode NVARCHAR (15) |
||
| Sequence | Sequence INT |
||
| AcctName | AcctName NVARCHAR (200) |
||
| Ref | Ref NVARCHAR (27) |
||
| DueDate | DueDate Datetime |
||
| Memo | Memo NVARCHAR (254) |
||
| DebAmount | DebAmount NUMERIC(19,6) |
||
| DebAmntCur | DebAmntCur NVARCHAR (3) |
||
| CredAmnt | CredAmnt NUMERIC(19,6) |
||
| CredAmntCu | CredAmntCu NVARCHAR (3) |
||
| balance | balance NUMERIC(19,6) |
||
| BankMatch | BankMatch INT |
||
| DataSource | DataSource NVARCHAR (1) |
||
| UserSign | UserSign SMALLINT |
||
| ExternCode | ExternCode NVARCHAR (30) |
||
| CardCode | CardCode NVARCHAR (15) |
OCRD.CardCode | |
| CardName | CardName NVARCHAR (200) |
||
| StatemNo | StatemNo INT |
||
| DocNum | DocNum NVARCHAR (27) |
||
| PaymCreat | PaymCreat NVARCHAR (1) |
||
| LineStatus | LineStatus NVARCHAR (1) |
||
| VisOrder | VisOrder INT |
||
| DocNumType | DocNumType NVARCHAR (1) |
||
| Memo2 | Memo2 NVARCHAR (254) |
||
| PaymentRef | PaymentRef NVARCHAR (27) |
||
| autoCreate | autoCreate NVARCHAR (1) |
||
| BSLineDate | BSLineDate Datetime |
||
| BSValuDate | BSValuDate Datetime |
||
| InOpCode | InOpCode INT |
||
| Cleared | Cleared NVARCHAR (1) |
||
| OposAct | OposAct NVARCHAR (50) |
||
| DebAmntLC | DebAmntLC NUMERIC(19,6) |
||
| CredAmntLC | CredAmntLC NUMERIC(19,6) |
||
| ExchngRate | ExchngRate NUMERIC(19,6) |
||
| BPIBAN | BPIBAN NVARCHAR (50) |
||
| Fee | Fee NUMERIC(19,6) |
||
| PmnPstDate | PmnPstDate Datetime |
||
| PmnValDate | PmnValDate Datetime |
||
| LnDocDate | LnDocDate Datetime |
||
| VatAmntLC | VatAmntLC NUMERIC(19,6) |
||
| VatAmntFC | VatAmntFC NUMERIC(19,6) |
||
| JDTID | JDTID INT |
||
| PmntID | PmntID INT |
||
| ObjCrtType | ObjCrtType SMALLINT |
||
| PstMethod | PstMethod NVARCHAR (1) |
||
| FeeAct | FeeAct NVARCHAR (15) |
||
| FeeProfitC | FeeProfitC NVARCHAR (8) |
||
| FeeProj | FeeProj NVARCHAR (20) |
||
| BpBankCode | BpBankCode NVARCHAR (30) |
||
| FeeProfit2 | FeeProfit2 NVARCHAR (8) |
||
| FeeProfit3 | FeeProfit3 NVARCHAR (8) |
||
| FeeProfit4 | FeeProfit4 NVARCHAR (8) |
||
| FeeProfit5 | FeeProfit5 NVARCHAR (8) |
||
| ApplWTSum | ApplWTSum NUMERIC(19,6) |
||
| InfoLog | InfoLog NVARCHAR (254) |
||
| LineOrigin | LineOrigin NVARCHAR (1) |
||
| BPSwift | BPSwift NVARCHAR (50) |
||
| Source | Source NVARCHAR (1) |
||
| PayOrderNo | PayOrderNo INT |
||
| TaxIDNum | TaxIDNum NVARCHAR (32) |
||
| PONumber | PONumber INT |
||
| FormatName | FormatName NVARCHAR (254) |
||
| FileCRC | FileCRC NVARCHAR (32) |
||
| FolioPref | FolioPref NVARCHAR (4) |
||
| FolioNum | FolioNum INT |
||
| BPLIdPmn | BPLIdPmn INT |
||
| BPAcctName | BPAcctName NVARCHAR (250) |
||
| EnOposAct | EnOposAct NTEXT |
||
| EnBPIBAN | EnBPIBAN NTEXT |
||
| EncryptIV | EncryptIV NVARCHAR (100) |
||
| DPPStatus | DPPStatus NVARCHAR (1) |
||
| CreateDate | CreateDate Datetime |
||
| CtrlAcct | CtrlAcct NVARCHAR (15) |