Table 1293 "Payment Application Proposal"
Base Application · Microsoft.Bank.Reconciliation
Across versions
- BC23present
- BC24declaration changed
- BC251 events added
- BC26unchanged
- BC271 events added
- BC2818 fields changed, 2 procedures added
- BC291 procedures added
- BC30unchanged
Neighbourhood 18 connected objects and pages
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"): BooleanTransferFromBankAccReconLine(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)+ BC28UpdateDefaultCalculatedFields(var BankAccount: Record "Bank Account"; AppliesToEntryNo: Integer; SkipRemainingAmountUpdate: Boolean)+ BC28GetRemainingAmountAfterPostingValue(): DecimalRemoveApplications()AccountNameDrillDown()GetAccountName(): TextAppliesToEntryNoDrillDown()
Plus 21 local procedures.
Triggers
OnDelete, OnInsert, OnModify, OnRename
Relations
- Account No.: TableRelation Table 15 “G/L Account” (conditional)
- Applies-to Entry No.: TableRelation Table 17 “G/L Entry” (conditional)
- Account No.: TableRelation Table 18 “Customer” (conditional)
- Applies-to Entry No.: TableRelation Table 21 “Cust. Ledger Entry” (conditional)
- Account No.: TableRelation Table 23 “Vendor” (conditional)
- Applies-to Entry No.: TableRelation Table 25 “Vendor Ledger Entry” (conditional)
- Account No.: TableRelation Table 270 “Bank Account” (conditional)
- Bank Account No.: TableRelation Table 270 “Bank Account”
- Statement No.: TableRelation Table 273 “Bank Acc. Reconciliation”
- Currency Code: TableRelation Table 4 “Currency”
Pages and codeunits on this table
- Page 1292 “Payment Application” (source table)
- Codeunit 1295 “Get Bank Stmt. Line Candidates” (codeunit runs on it)
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.
- Codeunit 370 “Bank Acc. Reconciliation Post” (2 calls:
UpdateLedgEntryDisc → ApplyCustLedgEntry,UpdateLedgEntryDisc → ApplyVendLedgEntry) - Codeunit 1255 “Match Bank Payments” (1 call:
Apply → SetApplicationDataInCVLedgEntry) - Page 17 “G/L Account Card” (1 call:
AccountNameDrillDown → (object)) - Page 21 “Customer Card” (1 call:
AccountNameDrillDown → (object)) - Page 26 “Vendor Card” (1 call:
AccountNameDrillDown → (object)) - Page 370 “Bank Account Card” (1 call:
AccountNameDrillDown → (object)) - Page 5200 “Employee Card” (1 call:
AccountNameDrillDown → (object))
Recent changes
- 2026-08-31 #10819 [Pmt. Recon. Journal] Re-fire OnAfterGetLedgEntryInfo on proposal fast path (main, BC30, fix)
- 2026-08-28 #10498 [Pmt. Recon. Journal] Optimize opening of the Payment Application screen (main, BC30, performance)
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.