Table 10123 "Posted Bank Rec. Header" (MX)

MX country layer · Microsoft.Bank.Reconciliation · BC29-30 · source at ea08af5e · facts from BC29

An object of the MX localization, not part of W1.

Properties

Property	Value
Caption	Posted Bank Rec. Header
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 Bank Account; NotBlank
2	Statement No.	Code[20]	—
3	Statement Date	Date	—
4	Statement Balance	Decimal	—
5	G/L Balance (LCY)	Decimal	G/L Balance ($) caption	not editable
6	Positive Adjustments	Decimal	—	FlowField: sum(“Posted Bank Rec. Line”.Amount where(“Bank Account No.” = field(“Bank Account No.”), “Statement No.” = field(“Statement No.”), “Record Type” = const(Adjustment), Positive = const(true), “Account Type” = const(“Bank Account”), “Account No.” = field(“Bank Account No.”)))
7	Negative Adjustments	Decimal	—	FlowField: sum(“Posted Bank Rec. Line”.Amount where(“Bank Account No.” = field(“Bank Account No.”), “Statement No.” = field(“Statement No.”), “Record Type” = const(Adjustment), Positive = const(false), “Account Type” = const(“Bank Account”), “Account No.” = field(“Bank Account No.”)))
8	Outstanding Deposits	Decimal	—	FlowField: sum(“Posted Bank Rec. Line”.Amount where(“Bank Account No.” = field(“Bank Account No.”), “Statement No.” = field(“Statement No.”), “Record Type” = const(Deposit), Cleared = const(false)))
9	Outstanding Checks	Decimal	—	FlowField: sum(“Posted Bank Rec. Line”.Amount where(“Bank Account No.” = field(“Bank Account No.”), “Statement No.” = field(“Statement No.”), “Record Type” = const(Check), Cleared = const(false)))
10	Date Created	Date	—
11	Time Created	Time	—
12	Created By	Code[50]	—	DataClassification EndUserIdentifiableInformation
13	Currency Code	Code[10]	—	TableRelation Currency
14	Currency Factor	Decimal	—
16	Cleared With./Chks. Per Stmnt.	Decimal	—
17	Cleared Inc./Dpsts. Per Stmnt.	Decimal	—
19	Total Cleared Checks	Decimal	—	FlowField: sum(“Posted Bank Rec. Line”.“Cleared Amount” where(“Bank Account No.” = field(“Bank Account No.”), “Statement No.” = field(“Statement No.”), “Record Type” = const(Check), Cleared = const(true)))
20	Total Cleared Deposits	Decimal	—	FlowField: sum(“Posted Bank Rec. Line”.“Cleared Amount” where(“Bank Account No.” = field(“Bank Account No.”), “Statement No.” = field(“Statement No.”), “Record Type” = const(Deposit), Cleared = const(true)))
21	Total Adjustments	Decimal	—	FlowField: sum(“Posted Bank Rec. Line”.Amount where(“Bank Account No.” = field(“Bank Account No.”), “Statement No.” = field(“Statement No.”), “Record Type” = const(Adjustment)))
22	G/L Bank Account No.	Code[20]	—	TableRelation G/L Account; not editable
23	Date Filter	Date	—	FlowFilter
24	Comment	Boolean	—	FlowField: exist(“Bank Comment Line” where(“Table Name” = const(“Posted Bank Rec.”), “Bank Account No.” = field(“Bank Account No.”), “No.” = field(“Statement No.”))); not editable
25	Posting Date	Date	—
26	No. Printed	Integer	—	not editable
27	G/L Balance	Decimal	—	not editable
28	Total Balanced Adjustments	Decimal	—	FlowField: sum(“Posted Bank Rec. Line”.Amount where(“Bank Account No.” = field(“Bank Account No.”), “Statement No.” = field(“Statement No.”), “Record Type” = const(Adjustment), “Bal. Account No.” = filter(<> ‘’)))
29	Positive Bal. Adjustments	Decimal	—	FlowField: sum(“Posted Bank Rec. Line”.Amount where(“Bank Account No.” = field(“Bank Account No.”), “Statement No.” = field(“Statement No.”), “Record Type” = const(Adjustment), Positive = const(true), “Bal. Account No.” = field(“Bank Account No.”), “Bal. Account Type” = const(“Bank Account”)))
30	Negative Bal. Adjustments	Decimal	—	FlowField: sum(“Posted Bank Rec. Line”.Amount where(“Bank Account No.” = field(“Bank Account No.”), “Statement No.” = field(“Statement No.”), “Record Type” = const(Adjustment), Positive = const(false), “Bal. Account No.” = field(“Bank Account No.”), “Bal. Account Type” = const(“Bank Account”)))
480	Dimension Set ID	Integer	—	TableRelation Dimension Set Entry; not editable

Keys

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

Events published

OnUpdateAllLineDimOnBeforePostedBankRecLinesModify(var PostedBankRecLines: Record "Posted Bank Rec. Line") (integration)

Procedures

PrintRecords(ShowRequestForm: Boolean)
Navigate()
ShowDocDim()
PostedBankRecLinesExist(): Boolean

Plus 1 local procedures.

Triggers

OnDelete

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 Bank Rec. Header"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A MX country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.