tableFinanceofficial - Microsoftderived - from the source, no model text

Table 751 "Standard General Journal Line"

Base Application · Microsoft.Finance.GeneralLedger.Journal

Across versions

  1. BC23present
  2. BC241 fields changed
  3. BC251 fields changed
  4. BC261 fields changed
  5. BC27unchanged
  6. BC2811 fields changed
  7. BC2937 fields changed
  8. BC30unchanged

Neighbourhood 36 connected objects and pages

Table 18 "Customer" (relates to, 5 links)CustomerTable 23 "Vendor" (relates to, 5 links)VendorTable 270 "Bank Account" (relates to, 3 links)Table 15 "G/L Account" (relates to, 2 links)Table 250 "Gen. Business Posting Group" (relates to, 2 links)Gen. Business Posting GroupTable 251 "Gen. Product Posting Group" (relates to, 2 links)Gen. Product Posting GroupTable 318 "Tax Area" (relates to, 2 links)Tax AreaTable 321 "Tax Group" (relates to, 2 links)Tax GroupTable 323 "VAT Business Posting Group" (relates to, 2 links)Table 324 "VAT Product Posting Group" (relates to, 2 links)VAT Product Posting GroupTable 349 "Dimension Value" (relates to, 2 links)Dimension ValueTable 410 "IC G/L Account" (relates to, 2 links)IC G/L AccountTable 5600 "Fixed Asset" (relates to, 2 links)Fixed AssetTable 13 "Salesperson/Purchaser" (relates to)Table 167 "Job" (relates to)JobTable 220 "Business Unit" (relates to)Table 222 "Ship-to Address" (relates to)Ship-to AddressTable 224 "Order Address" (relates to)Table 230 "Source Code" (relates to)Table 231 "Reason Code" (relates to)Table 3 "Payment Terms" (relates to)Table 308 "No. Series" (relates to)Table 4 "Currency" (relates to)Table 413 "IC Partner" (relates to)Table 422 "IC Bank Account" (relates to)Table 480 "Dimension Set Entry" (relates to)Table 5071 "Campaign" (relates to)Table 5606 "FA Posting Group" (relates to)Table 750 "Standard General Journal" (relates to)Table 80 "Gen. Journal Template" (relates to)Table 92 "Customer Posting Group" (relates to)Table 93 "Vendor Posting Group" (relates to)Page 752 "Standard Gen. Journal Subform" (pages and codeunits on it)Codeunit 408 "DimensionManagement" (calls, 8 links)DimensionManagementCodeunit 27 "Confirm Management" (calls, 4 links)Confirm ManagementWorking with general journals to post directly to G/L (Learn pages)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

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

Learn documents this table through its pages: Page 752 “Standard Gen. Journal Subform” (1 Learn page).

Properties

Property Value
Caption Standard General Journal 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 Journal Template Name Code[10] — TableRelation Table 80 “Gen. Journal Template” (Gen. Journal Template); not editable; NotBlank
2 Line No. Integer — not editable; NotBlank
3 Account Type Δ BC29 Enum “Gen. Journal Account Type” Specifies the type of account that the entry on the journal line will be posted to. enum Enum 81 “Gen. Journal Account Type”
4 Account No. Δ BC29 Code[20] Specifies the account number that the entry on the journal line will be posted to. TableRelation Table 15 “G/L Account”, Table 18 “Customer”, Table 23 “Vendor” (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” else if (“Account…)
6 Document Type Δ BC29 Enum “Gen. Journal Document Type” Specifies the type of document that the entry on the journal line is. enum Enum 6 “Gen. Journal Document Type”
8 Description Δ BC29 Text[100] Specifies a description of the entry.
10 VAT % Δ BC28 Decimal — not editable
11 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…)
12 Currency Code Δ BC29 Code[10] Specifies the code of the currency for the amounts on the journal line. TableRelation Table 4 “Currency”
13 Amount Δ BC28 Δ BC29 Decimal Specifies the total amount (including VAT) that the journal line consists of.
14 Debit Amount Δ BC29 Decimal Specifies the total of the ledger entries that represent debits.
15 Credit Amount Δ BC29 Decimal Specifies the total of the ledger entries that represent credits.
16 Amount (LCY) Δ BC28 Decimal —
17 Balance (LCY) Δ BC28 Decimal — not editable
18 Currency Factor Δ BC28 Decimal — not editable
19 Sales/Purch. (LCY) Δ BC28 Decimal —
20 Profit (LCY) Δ BC28 Decimal —
21 Inv. Discount (LCY) Δ BC28 Decimal —
22 Bill-to/Pay-to No. Δ BC29 Code[20] Specifies the number of the bill-to customer or pay-to vendor that the entry is linked to. TableRelation Table 18 “Customer”, Table 23 “Vendor” (if (“Account Type” = const(Customer)) Customer else if (“Bal. Account Type” = const(Customer)) Customer else if (“Account Type” = const(Vendor)) Vendor else if (“Bal. Account Type” = const(Vendor)) Vendor)
23 Posting Group Code[20] — TableRelation Table 5606 “FA Posting Group”, Table 92 “Customer Posting Group”, Table 93 “Vendor Posting Group” (if (“Account Type” = const(Customer)) “Customer Posting Group” else if (“Account Type” = const(Vendor)) “Vendor Posting Group” else if (“Account Type” = const(“Fixed Asset”)) “FA Posting Group”); not editable
24 Shortcut Dimension 1 Code Δ BC29 Code[20] Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window. TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false)))
25 Shortcut Dimension 2 Code Δ BC29 Code[20] Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window. TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false)))
26 Salespers./Purch. Code Δ BC29 Code[20] Specifies the salesperson or purchaser who is linked to the journal line. TableRelation Table 13 “Salesperson/Purchaser” (“Salesperson/Purchaser” where(Blocked = const(false)))
29 Source Code Code[10] — TableRelation Table 230 “Source Code” (Source Code); not editable
34 On Hold Δ BC29 Code[3] Specifies that the related entry represents an unpaid invoice for which either a payment suggestion, a reminder, or a finance charge memo exists.
35 Applies-to Doc. Type Δ BC29 Enum “Gen. Journal Document Type” Specifies the type of the posted document that this document or journal line will be applied to when you post, for example to register payment. enum Enum 6 “Gen. Journal Document Type”
40 Payment Discount % Δ BC28 Decimal —
42 Job No. Δ BC24 Code[20] Project No. caption TableRelation Table 167 “Job”; not editable
43 Quantity Δ BC28 Decimal —
44 VAT Amount Δ BC29 Decimal Specifies the amount of VAT that is included in the total amount.
47 Payment Terms Code Δ BC29 Code[10] Specifies a formula that calculates the payment due date, payment discount date, and payment discount amount. TableRelation Table 3 “Payment Terms” (Payment Terms)
50 Business Unit Code Δ BC29 Code[20] Specifies the code of the business unit that the entry derives from in a consolidated company. TableRelation Table 220 “Business Unit” (Business Unit)
51 Standard Journal Code Code[10] — TableRelation Table 750 “Standard General Journal” (“Standard General Journal”.Code)
52 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)
57 Gen. Posting Type Δ BC29 Enum “General Posting Type” Specifies the type of transaction. enum Enum 57 “General Posting Type”
58 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)
59 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)
60 VAT Calculation Type Enum “Tax Calculation Type” — enum Enum 254 “Tax Calculation Type”; not editable
63 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”
64 Bal. Gen. Posting Type Δ BC29 Enum “General Posting Type” Specifies the general posting type associated with the balancing account that will be used when you post the entry on the journal line. enum Enum 57 “General Posting Type”
65 Bal. Gen. Bus. Posting Group Δ BC29 Code[20] Specifies the general business posting group code associated with the balancing account that will be used when you post the entry. TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group)
66 Bal. Gen. Prod. Posting Group Δ BC29 Code[20] Specifies the general product posting group code associated with the balancing account that will be used when you post the entry. TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group)
67 Bal. VAT Calculation Type Enum “Tax Calculation Type” — enum Enum 254 “Tax Calculation Type”; not editable
68 Bal. VAT % Δ BC28 Decimal — not editable
69 Bal. VAT Amount Δ BC29 Decimal Specifies the amount of Bal. VAT included in the total amount.
70 Bank Payment Type Δ BC29 Enum “Bank Payment Type” Specifies the code for the payment type to be used for the entry on the journal line. enum Enum 272 “Bank Payment Type”
71 VAT Base Amount Decimal —
72 Bal. VAT Base Amount Decimal —
73 Correction Boolean —
77 External Document No. Δ BC29 Code[35] Specifies a document number that refers to the customer’s or vendor’s numbering system.
78 Source Type Option — OptionCaption: ,Customer,Vendor,Bank Account,Fixed Asset
79 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”)
80 Posting No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series)
82 Tax Area Code Code[20] — TableRelation Table 318 “Tax Area” (Tax Area)
83 Tax Liable Boolean —
84 Tax Group Code Code[20] — TableRelation Table 321 “Tax Group” (Tax Group)
85 Use Tax Boolean —
86 Bal. Tax Area Code Code[20] — TableRelation Table 318 “Tax Area” (Tax Area)
87 Bal. Tax Liable Boolean —
88 Bal. Tax Group Code Code[20] — TableRelation Table 321 “Tax Group” (Tax Group)
89 Bal. Use Tax Boolean —
90 VAT Bus. Posting Group Δ BC29 Code[20] Specifies the VAT specification of the involved customer or vendor to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
91 VAT Prod. Posting Group Δ BC29 Code[20] Specifies the VAT specification of the involved item or resource to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group)
92 Bal. VAT Bus. Posting Group Δ BC29 Code[20] Specifies the code of the VAT business posting group that will be used when you post the entry on the journal line. TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
93 Bal. VAT Prod. Posting Group Δ BC29 Code[20] Specifies the code of the VAT product posting group that will be used when you post the entry on the journal line. TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group)
110 Ship-to/Order Address Code Δ BC29 Code[10] Specifies the address code of the ship-to customer or order-from vendor that the entry is linked to. TableRelation Table 222 “Ship-to Address”, Table 224 “Order Address” (if (“Account Type” = const(Customer)) “Ship-to Address”.Code where(“Customer No.” = field(“Bill-to/Pay-to No.”)) else if (“Account Type” = const(Vendor)) “Order Address”.Code where(“Vendor No.” = field(“Bill-to/Pay-to No.”)) else if (“Bal. Account Type” = const(Customer)) “Ship-to Address”.Code wher…)
111 VAT Difference Δ BC29 Decimal Specifies the difference between the calculated VAT amount and a VAT amount that you have entered manually. not editable
112 Bal. VAT Difference Δ BC29 Decimal Specifies the difference between the calculate VAT amount and the VAT amount that you have entered manually. not editable
113 IC Partner Code Code[20] — TableRelation Table 413 “IC Partner” (IC Partner); not editable
116 IC Partner G/L Acc. No. Δ BC25 Δ BC26 Code[20] — obsolete Removed 25.0; #if not CLEANSCHEMA25; TableRelation Table 410 “IC G/L Account” (IC G/L Account)
118 Sell-to/Buy-from No. Code[20] — TableRelation Table 18 “Customer”, Table 23 “Vendor” (if (“Account Type” = const(Customer)) Customer else if (“Bal. Account Type” = const(Customer)) Customer else if (“Account Type” = const(Vendor)) Vendor else if (“Bal. Account Type” = const(Vendor)) Vendor)
130 IC Account Type Enum “IC Journal Account Type” — enum Enum 84 “IC Journal Account Type”
131 IC Account No. Code[20] — TableRelation Table 410 “IC G/L Account”, Table 422 “IC Bank Account” (if (“IC Account Type” = const(“G/L Account”)) “IC G/L Account” where(“Account Type” = const(Posting), Blocked = const(false)) else if (“Account Type” = const(Customer), “IC Account Type” = const(“Bank Account”)) “IC Bank Account” where(“IC Partner Code” = field(“IC Partner Code”), Blocked = const(fa…)
480 Dimension Set ID Integer — TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable
5050 Campaign No. Δ BC29 Code[20] Specifies the number of the campaign the journal line is linked to. TableRelation Table 5071 “Campaign”
5616 Index Entry Boolean —

Keys

  • Key1: Journal Template Name, Standard Journal Code, Line No. (clustered)

Events published

  • OnAfterInitDefaultDimensionSources(var StandardGenJournalLine: Record "Standard General Journal Line"; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]; FromFieldNo: Integer) (integration): Integration event raised after initializing default dimension sources for standard journal line. Enables custom dimension source configuration and additional dimension setup logic.
  • OnAfterGetGLAccount(var StandardGenJournalLine: Record "Standard General Journal Line"; GLAcc: Record "G/L Account") (integration): Integration event raised after retrieving G/L account for standard journal line processing. Enables custom G/L account validation and additional account-specific configuration.
  • OnAfterValidateShortcutDimCode(var StandardGenJournalLine: Record "Standard General Journal Line"; var xStandardGenJournalLine: Record "Standard General Journal Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration): Integration event raised after validating shortcut dimension code on standard journal line. Enables custom dimension validation logic and post-validation processing.
  • OnAfterCreateDim(var StandardGenJournalLine: Record "Standard General Journal Line"; CallingFieldNo: Integer; xStandardGeneralJournalLine: Record "Standard General Journal Line"; OldDimSetID: Integer; DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]) (integration): Integration event raised after creating dimension set for standard journal line. Enables custom dimension processing and validation after dimension creation.
  • OnBeforeCreateDim(var StandardGenJournalLine: Record "Standard General Journal Line"; var IsHandled: Boolean; CurrentFieldNo: Integer) (integration): Integration event raised before creating dimension set for standard journal line. Enables custom dimension setup logic and validation before standard creation.
  • OnAfterShowDimensions(var StandardGenJnlLine: Record "Standard General Journal Line") (integration): Integration event raised after displaying dimension information for standard journal line. Enables custom processing after dimension display operations complete.
  • OnBeforeLookupShortcutDimCode(var StandardGenJnlLine: Record "Standard General Journal Line"; xStandardGenJnlLine: Record "Standard General Journal Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20]; var IsHandled: Boolean) (integration): Integration event raised before looking up shortcut dimension code on standard journal line. Enables custom dimension lookup logic and validation before standard lookup processing.
  • OnBeforeShowDimensions(var StandardGeneralJournalLine: Record "Standard General Journal Line"; xStandardGeneralJournalLine: Record "Standard General Journal Line") (integration): Integration event raised before displaying dimension information for standard journal line. Enables custom dimension display logic and validation before showing dimensions.
  • OnBeforeValidateShortcutDimCode(var StandardGenJournalLine: Record "Standard General Journal Line"; var xStandardGenJournalLine: Record "Standard General Journal Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration): Integration event raised before validating shortcut dimension code on standard journal line. Enables custom dimension validation logic before standard validation processing.
  • OnValidateVATProdPostingGroupOnBeforeVATCalculationCheck(var StandardGeneralJournalLine: Record "Standard General Journal Line"; var VATPostingSetup: Record "VAT Posting Setup"; var IsHandled: Boolean) (integration): Integration event raised before VAT calculation check when validating VAT product posting group. Enables custom VAT validation logic and prevents standard VAT calculation checks.
  • OnValidateBalVATProdPostingGroupOnBeforeBalVATCalculationCheck(var StandardGeneralJournalLine: Record "Standard General Journal Line"; var VATPostingSetup: Record "VAT Posting Setup"; var IsHandled: Boolean) (integration): Integration event raised before balance VAT calculation check when validating balance VAT product posting group. Enables custom balance VAT validation logic and prevents standard balance VAT calculation checks.
  • OnAfterCheckGLAcc(var StandardGeneralJournalLine: Record "Standard General Journal Line"; GLAccount: Record "G/L Account") (integration): Integration event raised after checking G/L account validation on standard journal line. Enables custom G/L account validation logic and post-validation processing.

Procedures

  • ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20]): Validates shortcut dimension code for the specified dimension field number.
  • LookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20]): Opens lookup for shortcut dimension code for the specified dimension field number.
  • ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20]): Retrieves all shortcut dimension codes for the standard journal line.
  • ShowDimensions(): Opens the dimensions page for editing dimension set of the standard journal line.
  • CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]): Creates dimensions from default dimension sources for the standard journal line.
  • CreateDimFromDefaultDim(FromFieldNo: Integer): Creates dimensions from default dimension setup based on the specified field number.

Plus 21 local procedures.

Triggers

OnRename

Relations

Pages and codeunits on this 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” (8 calls: CreateDim → GetRecDefaultDimID, InitDefaultDimensionSources → AddDimSource, InitDefaultDimensionSources → TypeToTableID1, …)
  • Codeunit 27 “Confirm Management” (4 calls: GetCustomerAccount → GetResponseOrDefault, GetCustomerBalAccount → GetResponseOrDefault, GetVendorAccount → GetResponseOrDefault, …)

Countries that replace it

ES

Deprecations

  • field IC Partner G/L Acc. No.: Removed 25.0 (#if not CLEANSCHEMA25), “Replaced by IC Account No.”

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: "Standard General Journal Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources