Table 45 "G/L Register"

Base Application · Microsoft.Finance.GeneralLedger.Ledger · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 116 “G/L Registers” (2 Learn pages).

Properties

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.

Keys

• Key1: No. (clustered)
• Key2: Creation Date
• Key3: Source Code, Journal Batch Name, Creation Date
• key4: From Entry No., To Entry No.
• key5: Source Code, Journal Batch Name, SystemCreatedAt
• key6: SystemCreatedAt

Events published

• OnInitializeOnAfterGLRegisterInit(var GLRegister: record "G/L Register"; TemplateName: Code[10]) (integration): Integration event raised after initializing a G/L Register record.

Procedures

• GetNextRegisterNo(UseLegacyPosting: Boolean): Integer + BC29
• GetNextEntryNo(): Integer + BC29
• GetLastEntryNo(): Integer Δ BC26: Retrieves the last (highest) register number from the G/L Register table.
• Initialize(NextRegNo: Integer; FromEntryNo: Integer; FromVATEntryNo: Integer; SourceCode: Code[10]; BatchName: Code[10]; TemplateName: Code[10]): Initializes a new G/L Register record with the specified parameters.
• UpdateGLEntriesWithRegisterNo() + BC29

Relations

• lookup page Page 116 “G/L Registers”
• From Entry No.: TableRelation Table 17 “G/L Entry”
• To Entry No.: TableRelation Table 17 “G/L Entry”
• Source Code: TableRelation Table 230 “Source Code”
• From VAT Entry No.: TableRelation Table 254 “VAT Entry”
• To VAT Entry No.: TableRelation Table 254 “VAT Entry”
• No. of Transactions: CalcFormula Table 57 “G/L Transaction”

Referenced by

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

• Table 17 “G/L Entry”: G/L Register No.
• Table 179 “Reversal Entry”: G/L Register No.
• Table 181 “Posted Gen. Journal Line”: G/L Register No.
• Table 21 “Cust. Ledger Entry”: G/L Register No.
• Table 25 “Vendor Ledger Entry”: G/L Register No.
• Table 254 “VAT Entry”: G/L Register No.
• Table 379 “Detailed Cust. Ledg. Entry”: G/L Register No.
• Table 380 “Detailed Vendor Ledg. Entry”: G/L Register No.
• Table 5222 “Employee Ledger Entry”: G/L Register No.
• Table 5223 “Detailed Employee Ledger Entry”: G/L Register No.
• Table 5617 “FA Register”: G/L Register No.
• Table 5823 “G/L - Item Ledger Relation”: G/L Register No.
• Table 87 “Date Compr. Register”: Register No.

Pages and codeunits on this table

• Page 116 “G/L Registers” (source table)
• Codeunit 235 “G/L Reg.-Gen. Ledger” (codeunit runs on it)
• Codeunit 236 “G/L Reg.-Cust.Ledger” (codeunit runs on it)
• Codeunit 237 “G/L Reg.-Vend.Ledger” (codeunit runs on it)
• Codeunit 238 “G/L Reg.-VAT Entries” (codeunit runs on it)
• Codeunit 377 “G/L Reg.-Bank Account Ledger” (codeunit runs on it)
• Codeunit 5619 “G/L Reg.-FALedger” (codeunit runs on it)
• Codeunit 5649 “G/L Reg.-Maint.Ledger” (codeunit runs on it)
• Codeunit 6788 “G/L Reg.-Withholding Entries” (codeunit runs on it)

Extended by

• Table extension 6795 “Withholding G/L Register Ext”

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 703 “Find Record Management” (1 call: GetLastEntryNo → GetLastEntryIntFieldValue)
• Codeunit 9500 “Sequence No. Mgt.” (1 call: GetNextEntryNo → GetNextSeqNo)

Countries that replace it

AU, ES, NZ

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