Objects/Tables/Table 271 Bank Account Ledger Entry
Table 271 Bank Account Ledger Entry in 28
Jonas Paprotka, Base Application 28.5.54151.54365, checked
- App
- Base Application
- Namespace
- Microsoft.Bank.Ledger
Fields, 47Keys, 9Procedures, 9Events, 3
Versions171819202122232425262728latest
Source29
Fields, 47
| Id | Name | Type | Obsolete |
|---|
| 1 | Entry No. | Integer | - |
| 3 | Bank Account No. | Code[20] | - |
| 4 | Posting Date | Date | - |
| 5 | Document Type | Enum Gen. Journal Document Type | - |
| 6 | Document No. | Code[20] | - |
| 7 | Description | Text[100] | - |
| 11 | Currency Code | Code[10] | - |
| 13 | Amount | Decimal | - |
| 14 | Remaining Amount | Decimal | - |
| 17 | Amount (LCY) | Decimal | - |
| 22 | Bank Acc. Posting Group | Code[20] | - |
| 23 | Global Dimension 1 Code | Code[20] | - |
| 24 | Global Dimension 2 Code | Code[20] | - |
| 25 | Our Contact Code | Code[20] | - |
| 27 | User ID | Code[50] | - |
| 28 | Source Code | Code[10] | - |
| 36 | Open | Boolean | - |
| 43 | Positive | Boolean | - |
| 44 | Closed by Entry No. | Integer | - |
| 45 | Closed at Date | Date | - |
| 48 | Journal Templ. Name | Code[10] | - |
| 49 | Journal Batch Name | Code[10] | - |
| 50 | Reason Code | Code[10] | - |
| 51 | Bal. Account Type | Enum Gen. Journal Account Type | - |
| 52 | Bal. Account No. | Code[20] | - |
| 53 | Transaction No. | Integer | - |
| 55 | Statement Status | Option | - |
| 56 | Statement No. | Code[20] | - |
| 57 | Statement Line No. | Integer | - |
| 58 | Debit Amount | Decimal | - |
| 59 | Credit Amount | Decimal | - |
| 60 | Debit Amount (LCY) | Decimal | - |
| 61 | Credit Amount (LCY) | Decimal | - |
| 62 | Document Date | Date | - |
| 63 | External Document No. | Code[35] | - |
| 64 | Reversed | Boolean | - |
| 65 | Reversed by Entry No. | Integer | - |
| 66 | Reversed Entry No. | Integer | - |
| 67 | Statement Date | Date | - |
| 70 | Check Ledger Entries | Integer | - |
| 480 | Dimension Set ID | Integer | - |
| 481 | Shortcut Dimension 3 Code | Code[20] | - |
| 482 | Shortcut Dimension 4 Code | Code[20] | - |
| 483 | Shortcut Dimension 5 Code | Code[20] | - |
| 484 | Shortcut Dimension 6 Code | Code[20] | - |
| 485 | Shortcut Dimension 7 Code | Code[20] | - |
| 486 | Shortcut Dimension 8 Code | Code[20] | - |
Keys, 9
| Name | Fields | Obsolete |
|---|
| Key1, clustered | Entry No. | - |
| Key2 | Bank Account No., Posting Date | - |
| Key3 | Bank Account No., Open, Posting Date, Statement No., Statement Status, Statement Line No. | - |
| Key4 | Document Type, Bank Account No., Posting Date | - |
| Key5 | Document No., Posting Date | - |
| Key6 | Transaction No. | - |
| Key7 | Bank Account No., Global Dimension 1 Code, Global Dimension 2 Code, Posting Date | - |
| key8 | Statement No., Statement Line No. | - |
| Key13 | Bank Account No., Posting Date, Statement No., Closed at Date, Statement Status, Reversed, Open | - |
Procedures, 9
| Name | Parameters | Returns | Access | Obsolete |
|---|
| ShowDimensions | () | | public | - |
| CopyFromGenJnlLine | (Record Gen. Journal Line) | | public | - |
| UpdateDebitCredit | (Boolean) | | public | - |
| IsApplied | () | Boolean | public | - |
| SetStyle | () | Text | public | - |
| SetFilterBankAccNoOpen | (Code[20]) | | public | - |
| GetAppliedStatementNo | () | Code[20] | public | - |
| CopyFromBankAccLedgerEntry | (Record Bank Account Ledger Entry, Code[20]) | | public | - |
| SetBankReconciliationCandidatesFilter | (Record Bank Acc. Reconciliation) | | public | - |
Events, 3
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnAfterCopyFromGenJnlLine | (var Record Bank Account Ledger Entry, Record Gen. Journal Line) | - |
| Integration event | OnAfterUpdateDebitCredit | (var Record Bank Account Ledger Entry, Boolean) | - |
| Integration event | OnAfterSetBankReconciliationCandidatesFilter | (var Record Bank Account Ledger Entry) | - |