Table 274 Bank Acc. Reconciliation Line in 18
- App
- Base Application
Fields, 34Keys, 3Procedures, 43Events, 12
Versions171819202122232425262728latest
Source29
Fields, 34
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Bank Account No. | Code[20] | - |
| 2 | Statement No. | Code[20] | - |
| 3 | Statement Line No. | Integer | - |
| 4 | Document No. | Code[20] | - |
| 5 | Transaction Date | Date | - |
| 6 | Description | Text[100] | - |
| 7 | Statement Amount | Decimal | - |
| 8 | Difference | Decimal | - |
| 9 | Applied Amount | Decimal | - |
| 10 | Type | Option | - |
| 11 | Applied Entries | Integer | - |
| 12 | Value Date | Date | - |
| 13 | Ready for Application | Boolean | - |
| 14 | Check No. | Code[20] | - |
| 15 | Related-Party Name | Text[250] | - |
| 16 | Additional Transaction Info | Text[100] | - |
| 17 | Data Exch. Entry No. | Integer | - |
| 18 | Data Exch. Line No. | Integer | - |
| 20 | Statement Type | Option | - |
| 21 | Account Type | Enum Gen. Journal Account Type | - |
| 22 | Account No. | Code[20] | - |
| 23 | Transaction Text | Text[140] | - |
| 24 | Related-Party Bank Acc. No. | Text[100] | - |
| 25 | Related-Party Address | Text[100] | - |
| 26 | Related-Party City | Text[50] | - |
| 27 | Payment Reference No. | Code[50] | - |
| 31 | Shortcut Dimension 1 Code | Code[20] | - |
| 32 | Shortcut Dimension 2 Code | Code[20] | - |
| 50 | Match Confidence | Option | - |
| 51 | Match Quality | Integer | - |
| 60 | Sorting Order | Integer | - |
| 61 | Parent Line No. | Integer | - |
| 70 | Transaction ID | Text[50] | - |
| 480 | Dimension Set ID | Integer | - |
Keys, 3
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Statement Type, Bank Account No., Statement No., Statement Line No. | - |
| Key2 | Account Type, Statement Amount | - |
| Key3 | Type, Applied Amount | - |
Procedures, 43
| Name | Parameters | Returns | Access | Obsolete | |||
|---|---|---|---|---|---|---|---|
| DisplayApplication | () | public | - | ||||
| GetPaymentFile | (var Record Data Exch. Field) | Boolean | public | - | |||
| GetCurrencyCode | () | Code[10] | public | - | |||
| GetStyle | () | Text | public | - | |||
| ClearDataExchEntries | () | public | - | ||||
| ShowDimensions | () | public | - | ||||
| CreateDim | (Integer, Code[20], Integer, Code[20]) | public | - | ||||
| SetUpNewLine | () | public | - | ||||
| ValidateShortcutDimCode | (Integer, var Code[20]) | public | - | ||||
| ShowShortcutDimCode | (var Code[20]) | public | - | ||||
| AcceptAppliedPaymentEntriesSelectedLines | () | public | - | ||||
| RejectAppliedPaymentEntriesSelectedLines | () | public | - | ||||
| RejectAppliedPayment | () | public | - | ||||
| AcceptApplication | () | public | - | ||||
| SetManualApplication | () | public | - | ||||
| GetAppliedEntryAccountName | (Integer) | Text | public | - | |||
| GetAppliedToName | () | Text | public | - | |||
| GetAppliedEntryAccountType | (Integer) | Integer | public | - | |||
| GetAppliedToAccountType | () | Integer | public | - | |||
| GetAppliedEntryAccountNo | (Integer) | Code[20] | public | - | |||
| GetAppliedToAccountNo | () | Code[20] | public | - | |||
| AppliedEntryAccountDrillDown | (Integer) | public | - | ||||
| AppliedToDrillDown | () | public | - | ||||
| OpenAccountPage | (Option, Code[20]) | public | - | ||||
| DrillDownOnNoOfLedgerEntriesWithinAmountTolerance | () | public | - | ||||
| DrillDownOnNoOfLedgerEntriesOutsideOfAmountTolerance | () | public | - | ||||
| FilterBankRecLines | (Record Bank Acc. Reconciliation) | public | - | ||||
| LinesExist | (Record Bank Acc. Reconciliation) | Boolean | public | - | |||
| GetAppliedToDocumentNo | () | Text | public | - | |||
| GetAppliedToEntryNo | () | Text | public | - | |||
| GetAppliedToEntryFilter | () | Text | public | - | |||
| ShowAppliedToEntries | () | public | - | ||||
| TransferRemainingAmountToAccount | () | public | - | ||||
| GetStatusText | () | Text | public | - | |||
| GetAmountRangeForTolerance | (var Decimal, var Decimal) | public | - | ||||
| GetAppliedPmtData | (var Record Applied Payment Entry, var Decimal, var Decimal, Text) | public | - | ||||
| IsTransactionPostedAndReconciled | () | Boolean | public | - | |||
| CanImport | () | Boolean | public | - | |||
| BankStatementLinesListIsEmpty | (Code[20], Option, Code[20]) | Boolean | public | - | |||
| GetNewExperienceActive | () | Boolean | internal | Pending 17.0 | |||
| This function will be removed once the feature switch is removed. The old ux and the ability to switch will be removed. | |||||||
| GetAppliesToID | () | Code[50] | public | - | |||
| GetDescription | () | Text[100] | public | - | |||
| GetMatchedAutomaticallyFilter | () | Text | public | - | |||
Events, 12
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| Integration event | OnAfterCreateDimTableIDs | (var Record Bank Acc. Reconciliation Line, var Integer, var Integer, var Code[20]) | - |
| Integration event | OnAfterValidateShortcutDimCode | (var Record Bank Acc. Reconciliation Line, var Record Bank Acc. Reconciliation Line, Integer, var Code[20]) | - |
| Integration event | OnBeforeOnModify | (var Record Bank Acc. Reconciliation Line, var Boolean) | - |
| Integration event | OnBeforeValidateShortcutDimCode | (var Record Bank Acc. Reconciliation Line, var Record Bank Acc. Reconciliation Line, Integer, var Code[20]) | - |
| Integration event | OnAfterGetAccountName | (Option, Code[20], var Text) | - |
| Integration event | OnAfterOpenAccountPage | (Option, Code[20]) | - |
| Integration event | OnAfterRemoveAppliedPaymentEntries | (var Record Bank Acc. Reconciliation Line) | - |
| Integration event | OnAfterDrillDownOnNoOfLedgerEntriesBasedOnAmount | (var Record Bank Acc. Reconciliation Line, Text) | - |
| Integration event | OnDisplayApplicationOnAfterBankAccLedgEntrySetFilters | (var Record Bank Acc. Reconciliation Line, var Record Bank Account Ledger Entry) | - |
| Integration event | OnDisplayApplicationOnAfterCheckLedgEntrySetFilters | (var Record Bank Acc. Reconciliation Line, var Record Check Ledger Entry) | - |
| Integration event | OnRemoveApplicationOnAfterBankAccLedgEntrySetFilters | (var Record Bank Acc. Reconciliation Line, var Record Bank Account Ledger Entry) | - |
| Integration event | OnRemoveApplicationOnAfterCheckLedgEntrySetFilters | (var Record Bank Acc. Reconciliation Line, var Record Check Ledger Entry) | - |