Table 12400 "G/L Correspondence" (RU)

RU country layer · BC29-30 · source at ea08af5e · facts from BC29

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

Properties

Property	Value
Caption	G/L Correspondence
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	Debit Account No.	Code[20]	—	TableRelation G/L Account
2	Debit Account Name	Text[100]	—	FlowField: lookup(“G/L Account”.Name where(“No.” = field(“Debit Account No.”))); not editable
4	Debit Totaling	Text[250]	—	TableRelation G/L Account
5	Credit Account No.	Code[20]	—	TableRelation G/L Account
6	Credit Account Name	Text[100]	—	FlowField: lookup(“G/L Account”.Name where(“No.” = field(“Credit Account No.”))); not editable
8	Credit Totaling	Text[250]	—	TableRelation G/L Account
9	Amount	Decimal	—	FlowField: sum(“G/L Correspondence Entry”.Amount where(“Debit Account No.” = field(“Debit Account No.”), “Debit Account No.” = field(filter(“Debit Totaling”)), “Credit Account No.” = field(“Credit Account No.”), “Credit Account No.” = field(filter(“Credit Totaling”)), “Debit Global Dimension 1 Code” = field(“D…; not editable
15	Date Filter	Date	—	FlowFilter
16	Business Unit Filter	Code[20]	—	TableRelation Business Unit; FlowFilter
17	Debit Global Dim. 1 Filter	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1)); FlowFilter
18	Debit Global Dim. 2 Filter	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2)); FlowFilter
20	Amount (ACY)	Decimal	—	FlowField: sum(“G/L Correspondence Entry”.“Amount (ACY)” where(“Debit Account No.” = field(“Debit Account No.”), “Debit Account No.” = field(filter(“Debit Totaling”)), “Credit Account No.” = field(“Credit Account No.”), “Credit Account No.” = field(filter(“Credit Totaling”)), “Debit Global Dimension 1 Code” = …; not editable
21	Credit Global Dim. 1 Filter	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1)); FlowFilter
22	Credit Global Dim. 2 Filter	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2)); FlowFilter
23	Debit Source Type Filter	Option	—	FlowFilter; OptionCaption: ,Customer,Vendor,Bank Account,FA
24	Credit Source Type Filter	Option	—	FlowFilter; OptionCaption: ,Customer,Vendor,Bank Account,FA
25	Debit Source No. Filter	Code[20]	—	FlowFilter
26	Credit Source No. Filter	Code[20]	—	FlowFilter

Keys

Key1: Debit Account No., Credit Account No. (clustered)
Key2: Credit Account No., Debit Account No.

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: "G/L Correspondence"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

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