Objects/Tables/Table 273 Bank Acc. Reconciliation
Table 273 Bank Acc. Reconciliation in 17
Jonas Paprotka, Base Application 17.5.22499.32099, checked
- App
- Base Application
Fields, 26Keys, 1Procedures, 15Events, 5
Versions171819202122232425262728latest
Source29
Fields, 26
| Id | Name | Type | Obsolete |
|---|
| 1 | Bank Account No. | Code[20] | - |
| 2 | Statement No. | Code[20] | - |
| 3 | Statement Ending Balance | Decimal | - |
| 4 | Statement Date | Date | - |
| 5 | Balance Last Statement | Decimal | - |
| 6 | Bank Statement | Blob | - |
| 7 | Total Balance on Bank Account | Decimal | - |
| 8 | Total Applied Amount | Decimal | - |
| 9 | Total Transaction Amount | Decimal | - |
| 10 | Total Unposted Applied Amount | Decimal | - |
| 11 | Total Difference | Decimal | - |
| 20 | Statement Type | Option | - |
| 21 | Shortcut Dimension 1 Code | Code[20] | - |
| 22 | Shortcut Dimension 2 Code | Code[20] | - |
| 23 | Post Payments Only | Boolean | - |
| 24 | Import Posted Transactions | Option | - |
| 25 | Total Outstd Bank Transactions | Decimal | - |
| 26 | Total Outstd Payments | Decimal | - |
| 27 | Total Applied Amount Payments | Decimal | - |
| 28 | Bank Account Balance (LCY) | Decimal | - |
| 29 | Total Positive Adjustments | Decimal | - |
| 30 | Total Negative Adjustments | Decimal | - |
| 31 | Total Positive Difference | Decimal | - |
| 32 | Total Negative Difference | Decimal | - |
| 33 | Copy VAT Setup to Jnl. Line | Boolean | - |
| 480 | Dimension Set ID | Integer | - |
Keys, 1
| Name | Fields | Obsolete |
|---|
| Key1, clustered | Statement Type, Bank Account No., Statement No. | - |
Procedures, 15
| Name | Parameters | Returns | Access | Obsolete |
|---|
| CreateDim | (Integer, Code[20]) | | public | - |
| MatchSingle | (Integer) | | public | - |
| ImportBankStatement | () | | public | - |
| ValidateShortcutDimCode | (Integer, var Code[20]) | | public | - |
| ShowDocDim | () | | public | - |
| OpenNewWorksheet | () | | public | - |
| ImportAndProcessToNewStatement | () | | public | - |
| ImportStatement | (var Record Bank Acc. Reconciliation, Record Data Exch.) | Boolean | public | - |
| ProcessStatement | (var Record Bank Acc. Reconciliation) | | public | - |
| CreateNewBankPaymentAppBatch | (Code[20], var Record Bank Acc. Reconciliation) | | public | - |
| SelectBankAccountToUse | (var Record Bank Account, Boolean) | Boolean | public | - |
| OpenWorksheet | (Record Bank Acc. Reconciliation) | | public | - |
| OpenList | (Record Bank Acc. Reconciliation) | | public | - |
| SetFiltersOnBankAccReconLineTable | (Record Bank Acc. Reconciliation, var Record Bank Acc. Reconciliation Line) | | public | - |
| DrillDownOnBalanceOnBankAccount | () | | public | - |
Events, 5
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnAfterCreateDimTableIDs | (var Record Bank Acc. Reconciliation, var Integer, var Integer, var Code[20]) | - |
| Integration event | OnAfterValidateShortcutDimCode | (var Record Bank Acc. Reconciliation, var Record Bank Acc. Reconciliation, Integer, var Code[20]) | - |
| Integration event | OnBeforeImportAndProcessToNewStatement | (var Record Bank Acc. Reconciliation, var Record Data Exch., var Record Data Exch. Def, var Boolean) | - |
| Integration event | OnBeforeOpenWorksheetFromProcessStatement | (var Record Bank Acc. Reconciliation, var Boolean) | - |
| Integration event | OnBeforeValidateShortcutDimCode | (var Record Bank Acc. Reconciliation, var Record Bank Acc. Reconciliation, Integer, var Code[20]) | - |