Table "Bank Acc. Reconciliation Line"

ID 274

Namespace: Microsoft.Bank.Reconciliation

Properties

Name	Value
Caption	Bank Acc. Reconciliation Line
Permissions	TableData "Data Exch. Field" = rimd
DataClassification	CustomerContent

Fields

Name	Type	Description
"Bank Account No."	Code[20]
"Statement No."	Code[20]
"Statement Line No."	Integer
"Document No."	Code[20]
"Transaction Date"	Date
Description	Text[100]
"Statement Amount"	Decimal
Difference	Decimal
"Applied Amount"	Decimal
Type	Option
"Applied Entries"	Integer
"Value Date"	Date
"Ready for Application"	Boolean
"Check No."	Code[20]
"Related-Party Name"	Text[250]
"Additional Transaction Info"	Text[100]
"Data Exch. Entry No."	Integer
"Data Exch. Line No."	Integer
"Statement Type"	Microsoft.Bank.Reconciliation."Bank Acc. Rec. Stmt. Type"
"Account Type"	Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Account Type"
"Account No."	Code[20]
"Transaction Text"	Text[140]
"Related-Party Bank Acc. No."	Text[100]
"Related-Party Address"	Text[100]
"Related-Party City"	Text[50]
"Payment Reference No."	Code[50]
"Shortcut Dimension 1 Code"	Code[20]
"Shortcut Dimension 2 Code"	Code[20]
"Match Confidence"	Microsoft.Bank.Reconciliation."Bank Rec. Match Confidence"
"Match Quality"	Integer
"Sorting Order"	Integer
"Parent Line No."	Integer
"Transaction ID"	Text[50]
"Dimension Set ID"	Integer
SystemId	Guid
SystemCreatedAt	DateTime
SystemCreatedBy	Guid
SystemModifiedAt	DateTime
SystemModifiedBy	Guid
SystemRowVersion	BigInteger

Methods

DisplayApplication

procedure DisplayApplication()

TransferFromPostedPaymentReconLine

procedure TransferFromPostedPaymentReconLine(PostedPaymentReconLine: Record "Posted Payment Recon. Line")

Parameters

Name	Type	Description
PostedPaymentReconLine	Record "Posted Payment Recon. Line"

GetPaymentFile

procedure GetPaymentFile(var DataExchField: Record "Data Exch. Field"): Boolean

Parameters

Name	Type	Description
DataExchField	Record "Data Exch. Field"

Returns

Type	Description
Boolean

GetCurrencyCode

procedure GetCurrencyCode(): Code[10]

Returns

Type	Description
Code[10]

GetStyle

procedure GetStyle(): Text

Returns

Type	Description
Text

ClearDataExchEntries

procedure ClearDataExchEntries()

ShowDimensions

procedure ShowDimensions()

CreateDim

procedure CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])

Parameters

Name	Type	Description
DefaultDimSource	List of [Dictionary of [Integer, Code[20]]]

SetUpNewLine

procedure SetUpNewLine()

ValidateShortcutDimCode

procedure ValidateShortcutDimCode(FieldNumber: Integer, var ShortcutDimCode: Code[20])

Parameters

Name	Type	Description
FieldNumber	Integer
ShortcutDimCode	Code[20]

ShowShortcutDimCode

procedure ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])

Parameters

Name	Type	Description
ShortcutDimCode	array[8] of Code[20]

AcceptAppliedPaymentEntriesSelectedLines

procedure AcceptAppliedPaymentEntriesSelectedLines()

RejectAppliedPaymentEntriesSelectedLines

procedure RejectAppliedPaymentEntriesSelectedLines()

RejectAppliedPayment

procedure RejectAppliedPayment()

AcceptApplication

procedure AcceptApplication()

FilterManyToOneMatches

procedure FilterManyToOneMatches(var BankAccRecMatchBuffer: Record "Bank Acc. Rec. Match Buffer")

Parameters

Name	Type	Description
BankAccRecMatchBuffer	Record "Bank Acc. Rec. Match Buffer"

SetManualApplication

procedure SetManualApplication()

GetAppliedEntryAccountName

procedure GetAppliedEntryAccountName(AppliedToEntryNo: Integer): Text

Parameters

Name	Type	Description
AppliedToEntryNo	Integer

Returns

Type	Description
Text

GetAppliedToName

procedure GetAppliedToName(): Text

Returns

Type	Description
Text

GetAppliedEntryAccountType

procedure GetAppliedEntryAccountType(AppliedToEntryNo: Integer): Integer

Parameters

Name	Type	Description
AppliedToEntryNo	Integer

Returns

Type	Description
Integer

GetAppliedToAccountType

procedure GetAppliedToAccountType(): Integer

Returns

Type	Description
Integer

GetAppliedEntryAccountNo

procedure GetAppliedEntryAccountNo(AppliedToEntryNo: Integer): Code[20]

Parameters

Name	Type	Description
AppliedToEntryNo	Integer

Returns

Type	Description
Code[20]

GetAppliedToAccountNo

procedure GetAppliedToAccountNo(): Code[20]

Returns

Type	Description
Code[20]

AppliedEntryAccountDrillDown

procedure AppliedEntryAccountDrillDown(AppliedEntryNo: Integer)

Parameters

Name	Type	Description
AppliedEntryNo	Integer

AppliedToDrillDown

procedure AppliedToDrillDown()

OpenAccountPage

procedure OpenAccountPage(AccountType: Option, AccountNo: Code[20])

Parameters

Name	Type	Description
AccountType	Option
AccountNo	Code[20]

DrillDownOnNoOfLedgerEntriesWithinAmountTolerance

procedure DrillDownOnNoOfLedgerEntriesWithinAmountTolerance()

DrillDownOnNoOfLedgerEntriesOutsideOfAmountTolerance

procedure DrillDownOnNoOfLedgerEntriesOutsideOfAmountTolerance()

FilterBankRecLinesByDate

procedure FilterBankRecLinesByDate(BankAccReconciliation: Record "Bank Acc. Reconciliation", Overwrite: Boolean)

Parameters

Name	Type	Description
BankAccReconciliation	Record "Bank Acc. Reconciliation"
Overwrite	Boolean

FilterBankRecLines

procedure FilterBankRecLines(BankAccReconciliation: Record "Bank Acc. Reconciliation", Overwrite: Boolean)

Parameters

Name	Type	Description
BankAccReconciliation	Record "Bank Acc. Reconciliation"
Overwrite	Boolean

FilterBankRecLines

procedure FilterBankRecLines(BankAccReconciliation: Record "Bank Acc. Reconciliation")

Parameters

Name	Type	Description
BankAccReconciliation	Record "Bank Acc. Reconciliation"

LinesExist

procedure LinesExist(BankAccRecon: Record "Bank Acc. Reconciliation"): Boolean

Parameters

Name	Type	Description
BankAccRecon	Record "Bank Acc. Reconciliation"

Returns

Type	Description
Boolean

GetAppliedToDocumentNo

procedure GetAppliedToDocumentNo(SeparatorTxt: Text): Text

Parameters

Name	Type	Description
SeparatorTxt	Text

Returns

Type	Description
Text

GetAppliedToDocumentNo

procedure GetAppliedToDocumentNo(): Text

Returns

Type	Description
Text

GetAppliedToEntryNo

procedure GetAppliedToEntryNo(): Text

Returns

Type	Description
Text

GetAppliedToEntryFilter

procedure GetAppliedToEntryFilter(): Text

Returns

Type	Description
Text

ShowAppliedToEntries

procedure ShowAppliedToEntries()

TransferRemainingAmountToAccount

procedure TransferRemainingAmountToAccount()

GetStatusText

procedure GetStatusText(): Text

Returns

Type	Description
Text

GetAmountRangeForTolerance

procedure GetAmountRangeForTolerance(var MinAmount: Decimal, var MaxAmount: Decimal)

Parameters

Name	Type	Description
MinAmount	Decimal
MaxAmount	Decimal

GetAppliedPmtData

procedure GetAppliedPmtData(var AppliedPmtEntry: Record "Applied Payment Entry", var RemainingAmountAfterPosting: Decimal, var DifferenceStatementAmtToApplEntryAmount: Decimal, PmtAppliedToTxt: Text)

Parameters

Name	Type	Description
AppliedPmtEntry	Record "Applied Payment Entry"
RemainingAmountAfterPosting	Decimal
DifferenceStatementAmtToApplEntryAmount	Decimal
PmtAppliedToTxt	Text

IsTransactionPostedAndReconciled

procedure IsTransactionPostedAndReconciled(): Boolean

Returns

Type	Description
Boolean

CanImport

procedure CanImport(): Boolean

Returns

Type	Description
Boolean

BankStatementLinesListIsEmpty

procedure BankStatementLinesListIsEmpty(StatementNo: Code[20], StatementType: Option, BankAccountNo: Code[20]): Boolean

Parameters

Name	Type	Description
StatementNo	Code[20]
StatementType	Option
BankAccountNo	Code[20]

Returns

Type	Description
Boolean

GetAppliesToID

procedure GetAppliesToID(): Code[50]

Returns

Type	Description
Code[50]

GetDescription

procedure GetDescription(): Text[100]

Returns

Type	Description
Text[100]

GetMatchedAutomaticallyFilter

procedure GetMatchedAutomaticallyFilter(): Text

Returns

Type	Description
Text

CreateDimFromDefaultDim

procedure CreateDimFromDefaultDim()

See also

• Table