Table 57 "G/L Transaction"
Base Application · Microsoft.Finance.GeneralLedger.Ledger
Across versions
- BC23-28not present
- BC29added
- BC30unchanged
Neighbourhood 16 connected objects and pages
Base Application · Microsoft.Finance.GeneralLedger.Ledger · BC29-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | G/L Transaction |
| DataClassification | SystemMetadata |
| LookupPageId | G/L Transactions |
| DrillDownPageId | G/L Transactions |
| Permissions | TableData “G/L Transaction” = ri |
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 | No. | Integer | Specifies the number of the general ledger register. | |
| 2 | G/L Register No. | Integer | Specifies the number of the general ledger register. | |
| 5 | No. of G/L Entries | Integer | Specifies the number of general ledger entries in this transaction. | FlowField: count(“G/L Entry” where(“Transaction No.” = field(“No.”))); not editable |
| 6 | No. of VAT Entries | Integer | Specifies the number of VAT entries in this transaction. | FlowField: count(“VAT Entry” where(“Transaction No.” = field(“No.”))); not editable |
| 7 | No. of Customer Ledger Entries | Integer | Specifies the number of customer ledger entries in this transaction. | FlowField: count(“Cust. Ledger Entry” where(“Transaction No.” = field(“No.”))); not editable |
| 8 | No. of Vendor Ledger Entries | Integer | Specifies the number of vendor ledger entries in this transaction. | FlowField: count(“Vendor Ledger Entry” where(“Transaction No.” = field(“No.”))); not editable |
| 9 | No. of Employee Ledger Entries | Integer | Specifies the number of employee ledger entries in this transaction. | FlowField: count(“Employee Ledger Entry” where(“Transaction No.” = field(“No.”))); not editable |
Keys
- Key1: No. (clustered)
- Key2: G/L Register No., No.
Procedures
GetNextTransactionNo(): IntegerInsertFromGLEntry(var GLEntry: Record "G/L Entry"; var GLRegisterNo: Record "G/L Register")
Triggers
OnInsert
Relations
- drill-down page Page 811 “G/L Transactions”
- lookup page Page 811 “G/L Transactions”
- No. of G/L Entries: CalcFormula Table 17 “G/L Entry”
- No. of Customer Ledger Entries: CalcFormula Table 21 “Cust. Ledger Entry”
- No. of Vendor Ledger Entries: CalcFormula Table 25 “Vendor Ledger Entry”
- No. of VAT Entries: CalcFormula Table 254 “VAT Entry”
- No. of Employee Ledger Entries: CalcFormula Table 5222 “Employee Ledger Entry”
Referenced by
9 fields in 9 objects relate to this table (TableRelation or CalcFormula).
- Table 17 “G/L Entry”: Transaction No.
- Table 21 “Cust. Ledger Entry”: Transaction No.
- Table 25 “Vendor Ledger Entry”: Transaction No.
- Table 254 “VAT Entry”: Transaction No.
- Table 379 “Detailed Cust. Ledg. Entry”: Transaction No.
- Table 380 “Detailed Vendor Ledg. Entry”: Transaction No.
- Table 45 “G/L Register”: No. of Transactions
- Table 5222 “Employee Ledger Entry”: Transaction No.
- Table 5223 “Detailed Employee Ledger Entry”: Transaction No.
Pages and codeunits on this table
- Page 811 “G/L Transactions” (source table)
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 9500 “Sequence No. Mgt.” (1 call:
GetNextTransactionNo → GetNextSeqNo)
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 Transaction"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.