Table 1296 "Posted Payment Recon. Line"

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

Properties

Property	Value
Caption	Posted Payment Recon. Line
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 1295 “Posted Payment Recon. Hdr” (“Posted Payment Recon. Hdr”.“Statement No.” where(“Bank Account No.” = field(“Bank Account No.”)))
3	Statement Line No.	Integer	—
4	Document No.	Code[20]	—
5	Transaction Date Δ BC28	Date	Specifies the date when the payment represented by the journal line was recorded in the bank account.
6	Description Δ BC28	Text[100]	Specifies the description of the posted payment.
7	Statement Amount Δ BC28	Decimal	Specifies the amount on the bank transaction that represents the posted payment.
8	Difference Δ BC28	Decimal	Specifies the difference between the amount in the Statement Amount field and the Applied Amount field.
9	Applied Amount Δ BC28	Decimal	Specifies the amount that was applied to the related invoice or credit memo before this payment was posted.	not editable
10	Type	Option	—	OptionCaption: Bank Account Ledger Entry,Check Ledger Entry,Difference
11	Applied Entries Δ BC28	Integer	Specifies which customer or vendor ledger entries were applied in relation to posting the payment.	not editable
12	Value Date	Date	—
14	Check No.	Code[20]	—
15	Related-Party Name Δ BC28	Text[250]	Specifies information about the customer or vendor that the posted payment was for.
16	Additional Transaction Info Δ BC28	Text[100]	Specifies information about the transaction as recorded on the bank statement line.
17	Data Exch. Entry No.	Integer	—	TableRelation Table 1220 “Data Exch.” (Data Exch.); not editable
18	Data Exch. Line No.	Integer	—	not editable
21	Account Type Δ BC28	Enum “Gen. Journal Account Type”	Specifies the type of the account that the payment was posted to.	enum Enum 81 “Gen. Journal Account Type”
22	Account No. Δ BC28	Code[20]	Specifies the account number that the payment was posted to.	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	Applied Document No. Δ BC28	Text[250]	Specifies the number of the document that the payment is applied to.
24	Applied Entry No.	Text[250]	—
70	Transaction ID Δ BC28	Text[250]	Specifies the ID of the posted payment reconciliation.
71	Reconciled	Boolean	—

Keys

Key1: Bank Account No., Statement No., Statement Line No. (clustered)

Procedures

1 local procedures, no public ones.

Relations

Data Exch. Entry No.: TableRelation Table 1220 “Data Exch.”
Statement No.: TableRelation Table 1295 “Posted Payment Recon. Hdr”
Account No.: TableRelation Table 15 “G/L Account” (conditional)
Account No.: TableRelation Table 18 “Customer” (conditional)
Account No.: TableRelation Table 23 “Vendor” (conditional)
Account No.: TableRelation Table 270 “Bank Account” (conditional)
Bank Account No.: TableRelation Table 270 “Bank Account”

Referenced by

1 fields in 1 objects relate to this table (TableRelation or CalcFormula).

Table 1295 “Posted Payment Recon. Hdr”: Is Reconciled

Pages and codeunits on this table

Page 1296 “Pstd. Pmt. Recon. Subform” (source table)

Countries that replace it

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

Ask your agent

Procedure bodies are not stored here (D10). 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: "Posted Payment Recon. Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.