Table 10124 "Posted Bank Rec. Line" (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. 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 Bank Account
2	Statement No.	Code[20]	—	TableRelation “Posted Bank Rec. Header”.“Statement No.” where(“Bank Account No.” = field(“Bank Account No.”))
3	Line No.	Integer	—
4	Record Type	Option	—	OptionCaption: Check,Deposit,Adjustment
5	Posting Date	Date	—
6	Document Type	Enum “Gen. Journal Document Type”	—	enum Enum 6 “Gen. Journal Document Type”
7	Document No.	Code[20]	—
8	Account Type	enum “Gen. Journal Account Type”	—	enum Enum 81 “Gen. Journal Account Type”
9	Account No.	Code[20]	—	TableRelation if (“Account Type” = const(“G/L Account”)) “G/L Account” 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 (“Account Type” = const(“Fixed Asset”)) “Fixed Asset”
10	Description	Text[100]	—
11	Amount	Decimal	—
12	Cleared	Boolean	—
13	Cleared Amount	Decimal	—
14	Bal. Account Type	enum “Gen. Journal Account Type”	—	enum Enum 81 “Gen. Journal Account Type”
15	Bal. Account No.	Code[20]	—	TableRelation if (“Bal. Account Type” = const(“G/L Account”)) “G/L Account” else if (“Bal. Account Type” = const(Customer)) Customer else if (“Bal. Account Type” = const(Vendor)) Vendor else if (“Bal. Account Type” = const(“Bank Account”)) “Bank Account” else if (“Bal. Account Type” = const(“Fixed Asset”)) “Fixed…
16	Currency Code	Code[10]	—	TableRelation Currency
17	Currency Factor	Decimal	—
18	External Document No.	Code[35]	—
19	Bank Ledger Entry No.	Integer	—	TableRelation “Bank Account Ledger Entry”.“Entry No.”
20	Check Ledger Entry No.	Integer	—	TableRelation “Check Ledger Entry”.“Entry No.”
21	Adj. Source Record ID	Option	—	OptionCaption: Check,Deposit,Adjustment
22	Adj. Source Document No.	Code[20]	—
23	Adj. No. Series	Code[20]	—	TableRelation No. Series
24	Shortcut Dimension 1 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1))
25	Shortcut Dimension 2 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2))
27	Positive	Boolean	—
480	Dimension Set ID	Integer	—	TableRelation Dimension Set Entry; not editable

Keys

Key1: Bank Account No., Statement No., Record Type, Line No. (clustered)
Key2: Bank Account No., Statement No., Record Type, Cleared
Key3: Bank Account No., Statement No., Record Type, Positive
Key4: Bank Account No., Statement No., Posting Date, Document Type, Document No., External Document No.
Key5: Bank Account No., Statement No., Record Type, Bal. Account Type, Bal. Account No., Positive
Key6: Bank Account No., Statement No., Record Type, Account Type, Positive, Account No.

Events published

OnBeforeCreateDim(var PostedBankAccRecLine: Record "Posted Bank Rec. Line"; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]; var IsHandled: Boolean) (integration)
OnAfterCreateDim(var PostedBankAccRecLine: Record "Posted Bank Rec. Line"; DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]) (integration)
OnAfterShowDimensions(var PostedBankAccRecLine: Record "Posted Bank Rec. Line") (integration)

Procedures

CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])
ShowDimensions()
ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
LookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])

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. Line"), 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.