Table 1570 "G/L Entry Posting Preview"
Base Application · Microsoft.Finance.GeneralLedger.Ledger
Across versions
- BC23present
- BC243 fields changed
- BC25-27unchanged
- BC285 fields changed
- BC2933 fields changed
- BC30unchanged
Neighbourhood 25 connected objects and pages
Base Application · Microsoft.Finance.GeneralLedger.Ledger · captioned “G/L Entry” · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | G/L Entry |
| TableType | Temporary |
| DataClassification | SystemMetadata |
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 | Entry No. | Integer | — | |
| 3 | G/L Account No. Δ BC29 | Code[20] | Specifies the number of the account that the entry has been posted to. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 4 | Posting Date Δ BC29 | Date | Specifies the entry’s posting date. | |
| 5 | Document Type Δ BC29 | Enum “Gen. Journal Document Type” | Specifies the Document Type that the entry belongs to. | enum Enum 6 “Gen. Journal Document Type” |
| 6 | Document No. Δ BC29 | Code[20] | Specifies the entry’s Document No. | |
| 7 | Description Δ BC29 | Text[100] | Specifies a description of the entry or record. | |
| 10 | Bal. Account No. Δ BC29 | Code[20] | Specifies the number of the general ledger, customer, vendor, or bank account that the balancing entry is posted to, such as a cash account for cash purchases. | TableRelation Table 15 “G/L Account”, Table 18 “Customer”, Table 23 “Vendor” (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…) |
| 17 | Amount Δ BC28 Δ BC29 | Decimal | Specifies the Amount of the entry. | |
| 23 | Global Dimension 1 Code Δ BC29 | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))) |
| 24 | Global Dimension 2 Code Δ BC29 | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))) |
| 27 | User ID Δ BC29 | Code[50] | Specifies the ID of the user who posted the entry, to be used, for example, in the change log. | DataClassification EndUserIdentifiableInformation |
| 28 | Source Code Δ BC29 | Code[10] | Specifies the source code that specifies where the entry was created. | TableRelation Table 230 “Source Code” (Source Code) |
| 29 | System-Created Entry | Boolean | — | |
| 30 | Prior-Year Entry | Boolean | — | |
| 41 | Job No. Δ BC24 | Code[20] | Project No. caption | TableRelation Table 167 “Job” |
| 42 | Quantity Δ BC28 | Decimal | — | |
| 43 | VAT Amount Δ BC28 Δ BC29 | Decimal | Specifies the amount of VAT that is included in the total amount. | |
| 45 | Business Unit Code | Code[20] | — | TableRelation Table 220 “Business Unit” (Business Unit) |
| 46 | Journal Batch Name | Code[10] | — | |
| 47 | Reason Code Δ BC29 | Code[10] | Specifies the reason code, a supplementary source code that enables you to trace the entry. | TableRelation Table 231 “Reason Code” (Reason Code) |
| 48 | Gen. Posting Type Δ BC29 | Enum “General Posting Type” | Specifies the type of transaction. | enum Enum 57 “General Posting Type” |
| 49 | Gen. Bus. Posting Group Δ BC29 | Code[20] | Specifies the vendor’s or customer’s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup. | TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group) |
| 50 | Gen. Prod. Posting Group Δ BC29 | Code[20] | Specifies the item’s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup. | TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group) |
| 51 | Bal. Account Type Δ BC29 | Enum “Gen. Journal Account Type” | Specifies the type of account that a balancing entry is posted to, such as BANK for a cash account. | enum Enum 81 “Gen. Journal Account Type” |
| 52 | Transaction No. | Integer | — | |
| 53 | Debit Amount Δ BC28 Δ BC29 | Decimal | Specifies the total of the ledger entries that represent debits. | |
| 54 | Credit Amount Δ BC28 Δ BC29 | Decimal | Specifies the total of the ledger entries that represent credits. | |
| 55 | Document Date | Date | — | |
| 56 | External Document No. | Code[35] | — | |
| 57 | Source Type | Enum “Gen. Journal Source Type” | — | enum Enum 82 “Gen. Journal Source Type” |
| 58 | Source No. | Code[20] | — | TableRelation Table 18 “Customer”, Table 23 “Vendor”, Table 270 “Bank Account” (if (“Source Type” = const(Customer)) Customer else if (“Source Type” = const(Vendor)) Vendor else if (“Source Type” = const(“Bank Account”)) “Bank Account” else if (“Source Type” = const(“Fixed Asset”)) “Fixed Asset” else if (“Source Type” = const(Employee)) Employee) |
| 59 | No. Series | Code[20] | — | TableRelation Table 308 “No. Series” (No. Series) |
| 60 | Tax Area Code | Code[20] | — | TableRelation Table 318 “Tax Area” (Tax Area) |
| 61 | Tax Liable | Boolean | — | |
| 62 | Tax Group Code | Code[20] | — | TableRelation Table 321 “Tax Group” (Tax Group) |
| 63 | Use Tax | Boolean | — | |
| 64 | VAT Bus. Posting Group | Code[20] | — | TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group) |
| 65 | VAT Prod. Posting Group | Code[20] | — | TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group) |
| 68 | Additional-Currency Amount Δ BC29 | Decimal | Specifies the general ledger entry that is posted if you post in an additional reporting currency. | |
| 69 | Add.-Currency Debit Amount | Decimal | — | |
| 70 | Add.-Currency Credit Amount | Decimal | — | |
| 71 | Close Income Statement Dim. ID | Integer | — | |
| 72 | IC Partner Code | Code[20] | — | TableRelation Table 413 “IC Partner” (IC Partner) |
| 73 | Reversed Δ BC29 | Boolean | Specifies if the entry has been part of a reverse transaction (correction) made by the Reverse function. | |
| 74 | Reversed by Entry No. Δ BC29 | Integer | Specifies the number of the correcting entry. If the field Specifies a number, the entry cannot be reversed again. | TableRelation Table 17 “G/L Entry” (G/L Entry) |
| 75 | Reversed Entry No. Δ BC29 | Integer | Specifies the number of the original entry that was undone by the reverse transaction. | TableRelation Table 17 “G/L Entry” (G/L Entry) |
| 76 | G/L Account Name Δ BC24 Δ BC29 | Text[100] | Specifies the name of the account that the entry has been posted to. | FlowField: lookup(“G/L Account”.Name where(“No.” = field(“G/L Account No.”))); not editable |
| 480 | Dimension Set ID Δ BC29 | Integer | Specifies a reference to a combination of dimension values. The actual values are stored in the Dimension Set Entry table. | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
| 481 | Shortcut Dimension 3 Code Δ BC29 | Code[20] | Specifies the code for Shortcut Dimension 3, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(3))); not editable |
| 482 | Shortcut Dimension 4 Code Δ BC29 | Code[20] | Specifies the code for Shortcut Dimension 4, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(4))); not editable |
| 483 | Shortcut Dimension 5 Code Δ BC29 | Code[20] | Specifies the code for Shortcut Dimension 5, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(5))); not editable |
| 484 | Shortcut Dimension 6 Code Δ BC29 | Code[20] | Specifies the code for Shortcut Dimension 6, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(6))); not editable |
| 485 | Shortcut Dimension 7 Code Δ BC29 | Code[20] | Specifies the code for Shortcut Dimension 7, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(7))); not editable |
| 486 | Shortcut Dimension 8 Code Δ BC29 | Code[20] | Specifies the code for Shortcut Dimension 8, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(8))); not editable |
| 495 | Last Dim. Correction Entry No. | Integer | — | not editable |
| 496 | Last Dim. Correction Node | Integer | — | not editable |
| 497 | Dimension Changes Count | Integer | Count of Dimension Changes caption | not editable |
| 1570 | Indentation | Integer | — | |
| 1571 | G/L Entry No. | Integer | — | |
| 5400 | Prod. Order No. | Code[20] | — | |
| 5600 | FA Entry Type Δ BC29 | Option | Specifies the number of the fixed asset entry. | OptionCaption: ,Fixed Asset,Maintenance |
| 5601 | FA Entry No. Δ BC29 | Integer | Specifies the number of the fixed asset entry. | TableRelation Table 5601 “FA Ledger Entry”, Table 5625 “Maintenance Ledger Entry” (if (“FA Entry Type” = const(“Fixed Asset”)) “FA Ledger Entry” else if (“FA Entry Type” = const(Maintenance)) “Maintenance Ledger Entry”) |
| 5618 | Comment | Text[250] | — | |
| 8001 | Account Id Δ BC24 | Guid | — | TableRelation Table 15 “G/L Account” (“G/L Account”.SystemId); FlowField: lookup(“G/L Account”.SystemId where(“No.” = field(“G/L Account No.”))) |
| 8005 | Last Modified DateTime | DateTime | — | not editable |
Keys
- Key1: Entry No. (clustered)
Procedures
ShowDimensions(): Opens the dimensions window to show the dimension set for this preview G/L entry.GetCurrencyCode(): Code[10]: Retrieves the additional reporting currency code from General Ledger Setup.
Relations
- Account Id: CalcFormula Table 15 “G/L Account”
- G/L Account Name: CalcFormula Table 15 “G/L Account”
- Account Id: TableRelation Table 15 “G/L Account”
- Bal. Account No.: TableRelation Table 15 “G/L Account” (conditional)
- G/L Account No.: TableRelation Table 15 “G/L Account”
- Job No.: TableRelation Table 167 “Job”
- Reversed by Entry No.: TableRelation Table 17 “G/L Entry”
- Reversed Entry No.: TableRelation Table 17 “G/L Entry”
- Bal. Account No.: TableRelation Table 18 “Customer” (conditional)
- Source No.: TableRelation Table 18 “Customer” (conditional)
- Business Unit Code: TableRelation Table 220 “Business Unit”
- Bal. Account No.: TableRelation Table 23 “Vendor” (conditional)
- Source No.: TableRelation Table 23 “Vendor” (conditional)
- Source Code: TableRelation Table 230 “Source Code”
- Reason Code: TableRelation Table 231 “Reason Code”
- Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
- Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
- Bal. Account No.: TableRelation Table 270 “Bank Account” (conditional)
- Source No.: TableRelation Table 270 “Bank Account” (conditional)
- No. Series: TableRelation Table 308 “No. Series”
- Tax Area Code: TableRelation Table 318 “Tax Area”
- Tax Group Code: TableRelation Table 321 “Tax Group”
- VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
- VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
- Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- IC Partner Code: TableRelation Table 413 “IC Partner”
- Shortcut Dimension 3 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 4 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 5 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 6 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 7 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 8 Code: CalcFormula Table 480 “Dimension Set Entry”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Source No.: TableRelation Table 5200 “Employee” (conditional)
- Source No.: TableRelation Table 5600 “Fixed Asset” (conditional)
- FA Entry No.: TableRelation Table 5601 “FA Ledger Entry” (conditional)
- FA Entry No.: TableRelation Table 5625 “Maintenance Ledger Entry” (conditional)
Pages and codeunits on this table
- Page 1571 “G/L Entries Preview Subform” (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 408 “DimensionManagement” (1 call:
ShowDimensions → ShowDimensionSet)
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 Entry Posting Preview"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.