tableFinanceofficial - Microsoftderived - from the source, no model text

Table 1293 "Payment Application Proposal"

Base Application · Microsoft.Bank.Reconciliation

Across versions

  1. BC23present
  2. BC24declaration changed
  3. BC251 events added
  4. BC26unchanged
  5. BC271 events added
  6. BC2818 fields changed, 2 procedures added
  7. BC291 procedures added
  8. BC30unchanged

Neighbourhood 18 connected objects and pages

Table 270 "Bank Account" (relates to, 2 links)Bank AccountTable 15 "G/L Account" (relates to)G/L AccountTable 17 "G/L Entry" (relates to)Table 18 "Customer" (relates to)CustomerTable 21 "Cust. Ledger Entry" (relates to)Cust. Ledger EntryTable 23 "Vendor" (relates to)VendorTable 25 "Vendor Ledger Entry" (relates to)Vendor Ledger EntryTable 273 "Bank Acc. Reconciliation" (relates to)Table 4 "Currency" (relates to)CurrencyCodeunit 1295 "Get Bank Stmt. Line Candidates" (pages and codeunits on it)Get Bank Stmt. Line CandidatesPage 1292 "Payment Application" (pages and codeunits on it)Payment ApplicationCodeunit 370 "Bank Acc. Reconciliation Post" (calls, 2 links)Bank Acc. Reconciliation PostCodeunit 1255 "Match Bank Payments" (calls)Match Bank PaymentsPage 17 "G/L Account Card" (calls)G/L Account CardPage 21 "Customer Card" (calls)Customer CardPage 26 "Vendor Card" (calls)Vendor CardPage 370 "Bank Account Card" (calls)Page 5200 "Employee Card" (calls)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

Base Application · Microsoft.Bank.Reconciliation · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property Value
Caption Payment Application Proposal
DataClassification CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No. Name Type Explanation Notes
1 Bank Account No. Code[20] — TableRelation Table 270 “Bank Account” (Bank Account)
2 Statement No. Code[20] — TableRelation Table 273 “Bank Acc. Reconciliation” (“Bank Acc. Reconciliation”.“Statement No.” where(“Bank Account No.” = field(“Bank Account No.”), “Statement Type” = field(“Statement Type”)))
3 Statement Line No. Integer —
20 Statement Type Enum “Bank Acc. Rec. Stmt. Type” — enum Enum 1254 “Bank Acc. Rec. Stmt. Type”
21 Account Type Δ BC28 Enum “Gen. Journal Account Type” Specifies the type of account that the payment application will be posted to when you post the payment reconciliation journal. enum Enum 81 “Gen. Journal Account Type”
22 Account No. Δ BC28 Code[20] Specifies the account number the payment application will be posted to when you post the payment reconciliation journal. TableRelation Table 15 “G/L Account”, Table 18 “Customer”, Table 23 “Vendor” (if (“Account Type” = const(“G/L Account”)) “G/L Account” where(“Account Type” = const(Posting), Blocked = const(false)) else if (“Account Type” = const(Customer)) Customer else if (“Account Type” = const(Vendor)) Vendor else if (“Account Type” = const(“Bank Account”)) “Bank Account” else if (“Accoun…)
23 Applies-to Entry No. Δ BC28 Integer Specifies the number of the customer or vendor ledger entry that the payment will be applied to when you post the payment reconciliation journal line. TableRelation Table 17 “G/L Entry”, Table 21 “Cust. Ledger Entry”, Table 25 “Vendor Ledger Entry” (if (“Account Type” = const(“G/L Account”)) “G/L Entry” else if (“Account Type” = const(Customer)) “Cust. Ledger Entry” where(Open = const(true)) else if (“Account Type” = const(Vendor)) “Vendor Ledger Entry” where(Open = const(true)) else if (“Account Type” = const(“Bank Account”)) “Bank Account Led…)
24 Applied Amount Decimal —
25 Applied Δ BC28 Boolean Specifies that the payment specified on the header of the Payment Application window is applied to the open entry.
29 Applied Pmt. Discount Decimal —
30 Quality Integer —
31 Posting Date Δ BC28 Date Specifies the posting date of the open entry.
32 Document Type Δ BC28 Enum “Gen. Journal Document Type” Specifies the type of document that is related to the open entry. enum Enum 6 “Gen. Journal Document Type”
33 Document No. Δ BC28 Code[20] Specifies the number of the document that is related to the open entry.
34 Description Δ BC28 Text[100] Specifies the description of the open entry.
35 Currency Code Δ BC28 Code[10] Specifies the currency code of the open entry. TableRelation Table 4 “Currency”; not editable
36 Due Date Δ BC28 Date Specifies the due date of the open entry. not editable
37 External Document No. Δ BC28 Code[35] Specifies a document number that refers to the customer’s or vendor’s numbering system.
50 Match Confidence Δ BC28 Enum “Bank Rec. Match Confidence” Specifies the quality of the match between the payment and the open entry for payment application purposes. enum Enum 1252 “Bank Rec. Match Confidence”; not editable
51 Pmt. Disc. Due Date Δ BC28 Date Specifies the date on which the remaining amount on the open entry must be paid to grant a discount.
52 Remaining Pmt. Disc. Possible Δ BC28 Decimal Specifies how much discount you can grant for the payment if you apply it to the open entry.
53 Pmt. Disc. Tolerance Date Δ BC28 Date Specifies the latest date the amount in the entry must be paid in order for payment discount tolerance to be granted.
60 Applied Amt. Incl. Discount Δ BC28 Decimal Specifies the payment amount, excluding the value in the Applied Pmt. Discount field, that is applied to the open entry.
61 Remaining Amount Δ BC28 Decimal Specifies the amount that remains to be paid for the open entry. not editable
62 Remaining Amt. Incl. Discount Δ BC28 Decimal Specifies the amount that remains to be paid for the open entry, minus any granted payment discount. not editable
63 Type Option — OptionCaption: Bank Account Ledger Entry,Check Ledger Entry
100 Sorting Order Integer — not editable
101 Stmt To Rem. Amount Difference Decimal — not editable

Keys

  • Key1: Statement Type, Bank Account No., Statement No., Statement Line No., Account Type, Account No., Applies-to Entry No. (clustered)
  • Key2: Applied, Quality
  • Key3: Sorting Order
  • Key4: Applied, Account Type, Account No., Type

Events published

  • OnAfterCreateFromBankStmtMacthingBuffer(var PaymentApplicationProposal: Record "Payment Application Proposal"; TempBankStmtMatchingBuffer: Record "Bank Statement Matching Buffer" temporary; BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; BankAccount: Record "Bank Account") (integration)
  • OnBeforeUpdateRemainingAmount(var PaymentApplicationProposal: Record "Payment Application Proposal"; BankAccount: Record "Bank Account"; var IsHandled: Boolean) + BC25 (integration)
  • OnBeforeLoadLedgEntryInfoAndRemainingAmount(var PaymentApplicationProposal: Record "Payment Application Proposal"; BankAccount: Record "Bank Account"; var IsHandled: Boolean) + BC28 (integration)
  • OnApplyOnBeforeShowMessage(BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; PostingDate: Date; var ShowMessage: Boolean) + BC27 (integration)

Procedures

  • GetAppliedPaymentEntry(var AppliedPaymentEntry: Record "Applied Payment Entry"): Boolean
  • TransferFromBankAccReconLine(BankAccReconLine: Record "Bank Acc. Reconciliation Line")
  • CreateFromAppliedPaymentEntry(AppliedPaymentEntry: Record "Applied Payment Entry")
  • CreateFromBankStmtMacthingBuffer(TempBankStmtMatchingBuffer: Record "Bank Statement Matching Buffer" temporary; BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; BankAccount: Record "Bank Account")
  • UpdateDefaultCalculatedFields(var BankAccount: Record "Bank Account"; AppliesToEntryNo: Integer) + BC28
  • UpdateDefaultCalculatedFields(var BankAccount: Record "Bank Account"; AppliesToEntryNo: Integer; SkipRemainingAmountUpdate: Boolean) + BC28
  • GetRemainingAmountAfterPostingValue(): Decimal
  • RemoveApplications()
  • AccountNameDrillDown()
  • GetAccountName(): Text
  • AppliesToEntryNoDrillDown()

Plus 21 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

Pages and codeunits on this table

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Recent changes

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Payment Application Proposal"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources