JOP-AL

Objects/Tables/Table 274 Bank Acc. Reconciliation Line

Table 274 Bank Acc. Reconciliation Line in 23

, Base Application 23.5.16502.31399, checked

App
Base Application
Namespace
Microsoft.Bank.Reconciliation

Fields, 34Keys, 3Procedures, 51Events, 19

Versions171819202122232425262728latest

Source29

Fields, 34

IdNameTypeObsolete
1Bank Account No.Code[20]-
2Statement No.Code[20]-
3Statement Line No.Integer-
4Document No.Code[20]-
5Transaction DateDate-
6DescriptionText[100]-
7Statement AmountDecimal-
8DifferenceDecimal-
9Applied AmountDecimal-
10TypeOptionPending 21.0
This field is prone to confusion and is redundant. A type Difference can be manually tracked and a type Check Ledger Entry has a related Bank Account Ledger Entry
11Applied EntriesInteger-
12Value DateDate-
13Ready for ApplicationBoolean-
14Check No.Code[20]-
15Related-Party NameText[250]-
16Additional Transaction InfoText[100]-
17Data Exch. Entry No.Integer-
18Data Exch. Line No.Integer-
20Statement TypeEnum Bank Acc. Rec. Stmt. Type-
21Account TypeEnum Gen. Journal Account Type-
22Account No.Code[20]-
23Transaction TextText[140]-
24Related-Party Bank Acc. No.Text[100]-
25Related-Party AddressText[100]-
26Related-Party CityText[50]-
27Payment Reference No.Code[50]-
31Shortcut Dimension 1 CodeCode[20]-
32Shortcut Dimension 2 CodeCode[20]-
50Match ConfidenceEnum Bank Rec. Match Confidence-
51Match QualityInteger-
60Sorting OrderInteger-
61Parent Line No.Integer-
70Transaction IDText[50]-
480Dimension Set IDInteger-

Keys, 3

NameFieldsObsolete
Key1, clusteredStatement Type, Bank Account No., Statement No., Statement Line No.-
Key2Account Type, Statement Amount-
Key3Type, Applied Amount-

Procedures, 51

NameParametersReturnsAccessObsolete
DisplayApplication()public-
GetPaymentFile(var Record Data Exch. Field)Booleanpublic-
GetCurrencyCode()Code[10]public-
GetStyle()Textpublic-
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)Textpublic-
GetAppliedToName()Textpublic-
GetAppliedEntryAccountType(Integer)Integerpublic-
GetAppliedToAccountType()Integerpublic-
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)Booleanpublic-
GetAppliedToDocumentNo()Textpublic-
GetAppliedToEntryNo()Textpublic-
GetAppliedToEntryFilter()Textpublic-
ShowAppliedToEntries()public-
TransferRemainingAmountToAccount()public-
GetStatusText()Textpublic-
GetAmountRangeForTolerance(var Decimal, var Decimal)public-
GetAppliedPmtData(var Record Applied Payment Entry, var Decimal, var Decimal, Text)public-
IsTransactionPostedAndReconciled()Booleanpublic-
CanImport()Booleanpublic-
BankStatementLinesListIsEmpty(Code[20], Option, Code[20])Booleanpublic-
GetAppliesToID()Code[50]public-
GetDescription()Text[100]public-
GetMatchedAutomaticallyFilter()Textpublic-
FilterManyToOneMatches(var Record Bank Acc. Rec. Match Buffer)public-
GetAppliedPmtData(var Record Applied Payment Entry, Text)public-
CreateDim(List)public-
CreateDimFromDefaultDim()public-
GetPaymentRecJournalTelemetryFeatureName()Textinternal-
TransferFromPostedPaymentReconLine(Record Posted Payment Recon. Line)public-
FilterBankRecLinesByDate(Record Bank Acc. Reconciliation, Boolean)public-
FilterBankRecLines(Record Bank Acc. Reconciliation, Boolean)public-
GetAppliedToDocumentNo(Text)Textpublic-
GetAppliesToIDForBankStatement()Code[50]internal-

Events, 19

KindNameParametersObsolete
Integration eventOnAfterValidateShortcutDimCode(var Record Bank Acc. Reconciliation Line, var Record Bank Acc. Reconciliation Line, Integer, var Code[20])-
Integration eventOnBeforeOnModify(var Record Bank Acc. Reconciliation Line, var Boolean)-
Integration eventOnBeforeValidateShortcutDimCode(var Record Bank Acc. Reconciliation Line, var Record Bank Acc. Reconciliation Line, Integer, var Code[20])-
Integration eventOnAfterGetAccountName(Option, Code[20], var Text)-
Integration eventOnAfterOpenAccountPage(Option, Code[20])-
Integration eventOnAfterRemoveAppliedPaymentEntries(var Record Bank Acc. Reconciliation Line)-
Integration eventOnAfterDrillDownOnNoOfLedgerEntriesBasedOnAmount(var Record Bank Acc. Reconciliation Line, Text)-
Integration eventOnDisplayApplicationOnAfterBankAccLedgEntrySetFilters(var Record Bank Acc. Reconciliation Line, var Record Bank Account Ledger Entry)-
Integration eventOnDisplayApplicationOnAfterCheckLedgEntrySetFilters(var Record Bank Acc. Reconciliation Line, var Record Check Ledger Entry)Pending 21.0
This event will be removed, displaying check ledger entries is done via Bank Account Ledger Entries and Find entries.
Integration eventOnRemoveApplicationOnAfterBankAccLedgEntrySetFilters(var Record Bank Acc. Reconciliation Line, var Record Bank Account Ledger Entry)-
Integration eventOnRemoveApplicationOnAfterCheckLedgEntrySetFilters(var Record Bank Acc. Reconciliation Line, var Record Check Ledger Entry)Pending 21.0
This event will be removed, removing application from check ledger entries is done when removing application from Bank Account Ledger Entries.
Integration eventOnAfterSetUpNewLine(var Record Bank Acc. Reconciliation Line, Record Bank Acc. Reconciliation Line)-
Integration eventOnAfterFilterBankRecLines(var Record Bank Acc. Reconciliation Line, Record Bank Acc. Reconciliation)-
Integration eventOnAfterGetAppliedEntryAccountNo(var Record Bank Acc. Reconciliation Line, Integer, var Code[20])-
Integration eventOnDisplayApplicationOnAfterSetBankAccReconcLine(var Page Payment Application)-
Integration eventOnAfterInitDefaultDimensionSources(var Record Bank Acc. Reconciliation Line, var List)-
Integration eventOnAfterCreateDim(var Record Bank Acc. Reconciliation Line, List)-
Integration eventOnAfterShowDimensions(var Record Bank Acc. Reconciliation Line)-
Integration eventOnBeforeGetStyle(var Record Bank Acc. Reconciliation Line, var Text, var Boolean)-