Table 274 Bank Acc. Reconciliation Line in 28
- App
- Base Application
- Namespace
- Microsoft.Bank.Reconciliation
Fields, 33Keys, 2Procedures, 52Events, 23
Versions171819202122232425262728latest
Source29
Fields, 33
| 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 | - |
| 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 | Enum Bank Acc. Rec. Stmt. Type | - |
| 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 | Enum Bank Rec. Match Confidence | - |
| 51 | Match Quality | Integer | - |
| 60 | Sorting Order | Integer | - |
| 61 | Parent Line No. | Integer | - |
| 70 | Transaction ID | Text[50] | - |
| 480 | Dimension Set ID | Integer | - |
Keys, 2
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Statement Type, Bank Account No., Statement No., Statement Line No. | - |
| Key2 | Account Type, Statement Amount | - |
Procedures, 52
| 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 | - | |
| 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 | - |
| GetAppliesToID | () | Code[50] | public | - |
| GetDescription | () | Text[100] | public | - |
| GetMatchedAutomaticallyFilter | () | Text | public | - |
| FilterManyToOneMatches | (var Record Bank Acc. Rec. Match Buffer) | public | - | |
| GetAppliedPmtData | (var Record Applied Payment Entry, Text) | public | - | |
| CreateDim | (List) | public | - | |
| CreateDimFromDefaultDim | () | public | - | |
| GetPaymentRecJournalTelemetryFeatureName | () | Text | internal | - |
| TransferFromPostedPaymentReconLine | (Record Posted Payment Recon. Line) | public | - | |
| FilterBankRecLinesByDate | (Record Bank Acc. Reconciliation, Boolean) | public | - | |
| FilterBankRecLines | (Record Bank Acc. Reconciliation, Boolean) | public | - | |
| GetAppliedToDocumentNo | (Text) | Text | public | - |
| GetAppliesToIDForBankStatement | () | Code[50] | internal | - |
| RemoveApplication | () | protected | - |
Events, 23
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| 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 | OnRemoveApplicationOnAfterBankAccLedgEntrySetFilters | (var Record Bank Acc. Reconciliation Line, var Record Bank Account Ledger Entry) | - |
| Integration event | OnAfterSetUpNewLine | (var Record Bank Acc. Reconciliation Line, Record Bank Acc. Reconciliation Line) | - |
| Integration event | OnAfterFilterBankRecLines | (var Record Bank Acc. Reconciliation Line, Record Bank Acc. Reconciliation) | - |
| Integration event | OnAfterGetAppliedEntryAccountNo | (var Record Bank Acc. Reconciliation Line, Integer, var Code[20]) | - |
| Integration event | OnDisplayApplicationOnAfterSetBankAccReconcLine | (var Page Payment Application) | - |
| Integration event | OnAfterInitDefaultDimensionSources | (var Record Bank Acc. Reconciliation Line, var List) | - |
| Integration event | OnAfterCreateDim | (var Record Bank Acc. Reconciliation Line, List) | - |
| Integration event | OnAfterShowDimensions | (var Record Bank Acc. Reconciliation Line) | - |
| Integration event | OnBeforeGetStyle | (var Record Bank Acc. Reconciliation Line, var Text, var Boolean) | - |
| Integration event | OnBeforeIsTransactionPostedAndReconciled | (var Record Bank Acc. Reconciliation Line, var Boolean, var Boolean) | - |
| Integration event | OnBeforeGetCustomerLedgerEntriesInAmountRange | (Record Bank Acc. Reconciliation Line, var Record Cust. Ledger Entry, Code[20], Text, Decimal, Decimal, var Integer, var Boolean) | - |
| Integration event | OnBeforeGetVendorLedgerEntriesInAmountRange | (Record Bank Acc. Reconciliation Line, var Record Vendor Ledger Entry, Code[20], Text, Decimal, Decimal, var Integer, var Boolean) | - |
| Integration event | OnBeforeShowDimensions | (var Record Bank Acc. Reconciliation Line, var Boolean) | - |
| Integration event | OnGetAppliedPmtDataOnAfterLoopIteration | (var Record Bank Acc. Reconciliation Line, Record Applied Payment Entry) | - |
| Integration event | OnAfterTransferFromPostedPaymentReconLine | (var Record Bank Acc. Reconciliation Line, Record Posted Payment Recon. Line) | - |