Table 181 "Posted Gen. Journal Line"
Base Application · Microsoft.Finance.GeneralLedger.Journal
Across versions
- BC23present
- BC2423 fields changed
- BC251 fields changed
- BC261 fields changed, 1 events added
- BC274 fields changed, 1 procedures added
- BC2837 fields changed
- BC2928 fields changed, 2 fields added
- BC30unchanged
Neighbourhood 55 connected objects and pages
Base Application · Microsoft.Finance.GeneralLedger.Journal · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 182 “Posted General Journal” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Posted Gen. Journal Line |
| DataClassification | CustomerContent |
| LookupPageId | Posted General Journal |
| DrillDownPageId | Posted General Journal |
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 Δ BC29 | Code[10] | Specifies the name of the journal template. | |
| 2 | Line No. | Integer | — | AutoIncrement |
| 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” where(“Account Type” = const(Posting), Blocked = const(false)) 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 (“Accoun…) |
| 5 | Posting Date Δ BC29 | Date | Specifies the entry’s posting date. | |
| 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” |
| 7 | Document No. Δ BC29 | Code[20] | Specifies a document number for the journal line. | |
| 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 to which a balancing entry for the journal line will posted (for example, 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” where(“Account Type” = const(Posting), Blocked = const(false)) 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 Accou…) |
| 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 Δ BC29 | Decimal | Specifies the total amount (including VAT) that the journal line consists of. | |
| 14 | Debit Amount Δ BC29 | Decimal | Specifies the total amount (including VAT) that the journal line consists of, if it is a debit amount. | |
| 15 | Credit Amount Δ BC29 | Decimal | Specifies the total amount (including VAT) that the journal line consists of, if it is a credit amount. | |
| 16 | Amount (LCY) Δ BC28 | Decimal | Specifies the total amount in local currency (including VAT) that the journal line consists of. via Page 182 “Posted General Journal” | |
| 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. | 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); not editable |
| 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 | Code[20] | — | TableRelation Table 13 “Salesperson/Purchaser” (Salesperson/Purchaser) |
| 29 | Source Code | Code[10] | — | TableRelation Table 230 “Source Code” (Source Code); not editable |
| 30 | System-Created Entry | Boolean | — | not editable |
| 34 | On Hold | Code[3] | — | |
| 35 | Applies-to Doc. Type | Enum “Gen. Journal Document Type” | — | enum Enum 6 “Gen. Journal Document Type” |
| 36 | Applies-to Doc. No. | Code[20] | — | |
| 38 | Due Date | Date | — | |
| 39 | Pmt. Discount Date | Date | — | |
| 40 | Payment Discount % Δ BC28 | Decimal | — | |
| 42 | Job No. Δ BC24 | Code[20] | Project No. caption | TableRelation Table 167 “Job” |
| 43 | Quantity Δ BC28 Δ BC29 | Decimal | Specifies the quantity of items to be included on the journal line. | |
| 44 | VAT Amount Δ BC29 | Decimal | Specifies the amount of VAT included in the total amount. | |
| 45 | VAT Posting | Option | — | OptionCaption: Automatic VAT Entry,Manual VAT Entry; not editable |
| 47 | Payment Terms Code | Code[10] | — | TableRelation Table 3 “Payment Terms” (Payment Terms) |
| 48 | Applies-to ID | Code[50] | — | |
| 50 | Business Unit Code | Code[20] | — | TableRelation Table 220 “Business Unit” (Business Unit) |
| 51 | Journal Batch Name Δ BC29 | Code[10] | Specifies the name of the journal batch. | TableRelation Table 182 “Posted Gen. Journal Batch” (“Posted Gen. Journal Batch”.Name where(“Journal Template Name” = field(“Journal Template Name”))) |
| 52 | Reason Code | Code[10] | — | TableRelation Table 231 “Reason Code” (Reason Code) |
| 53 | Recurring Method | Enum “Gen. Journal Recurring Method” | — | enum Enum 53 “Gen. Journal Recurring Method” |
| 54 | Expiration Date | Date | — | |
| 55 | Recurring Frequency | DateFormula | — | |
| 57 | Gen. Posting Type Δ BC29 | Enum “General Posting Type” | Specifies the general posting type that will be used when you post the entry on this journal line. | 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 |
| 61 | EU 3-Party Trade | Boolean | — | not editable |
| 62 | Allow Application | Boolean | — | |
| 63 | Bal. Account Type Δ BC29 | Enum “Gen. Journal Account Type” | Specifies the code for the balancing account type that should be used in this journal line. | 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 | Decimal | — | |
| 70 | Bank Payment Type | Enum “Bank Payment Type” | — | enum Enum 272 “Bank Payment Type” |
| 71 | VAT Base Amount | Decimal | — | |
| 72 | Bal. VAT Base Amount | Decimal | — | |
| 73 | Correction | Boolean | — | |
| 74 | Print Posted Documents | Boolean | — | |
| 75 | Check Printed | Boolean | — | not editable |
| 76 | Document Date | Date | — | |
| 77 | External Document No. | Code[35] | — | |
| 78 | Source Type | Enum “Gen. Journal Source Type” | — | enum Enum 82 “Gen. Journal Source Type” |
| 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” else if (“Source Type” = const(Employee)) Employee) |
| 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 business posting group code that will be used when you post the entry on the journal line. | TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group) |
| 91 | VAT Prod. Posting Group Δ BC29 | Code[20] | Specifies the VAT product posting group. Links business transactions made for the item, resource, or G/L account with the general ledger, to account for VAT amounts resulting from trade with that record. | TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group) |
| 92 | Bal. VAT Bus. Posting Group | Code[20] | — | TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group) |
| 93 | Bal. VAT Prod. Posting Group | Code[20] | — | TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group) |
| 95 | Additional-Currency Posting | Option | — | OptionCaption: None,Amount Only,Additional-Currency Amount Only; not editable |
| 98 | FA Add.-Currency Factor Δ BC28 | Decimal | — | |
| 99 | Source Currency Code | Code[10] | — | TableRelation Table 4 “Currency”; not editable |
| 100 | Source Currency Amount Δ BC28 | Decimal | — | not editable |
| 101 | Source Curr. VAT Base Amount Δ BC28 | Decimal | — | not editable |
| 102 | Source Curr. VAT Amount Δ BC28 | Decimal | — | not editable |
| 103 | VAT Base Discount % Δ BC28 | Decimal | — | not editable |
| 104 | VAT Amount (LCY) Δ BC28 | Decimal | — | not editable |
| 105 | VAT Base Amount (LCY) Δ BC28 | Decimal | — | not editable |
| 106 | Bal. VAT Amount (LCY) Δ BC28 | Decimal | — | not editable |
| 107 | Bal. VAT Base Amount (LCY) Δ BC28 | Decimal | — | not editable |
| 108 | Reversing Entry | Boolean | — | not editable |
| 109 | Allow Zero-Amount Posting | Boolean | — | not editable |
| 110 | Ship-to/Order Address Code | Code[10] | — | 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 | Decimal | — | not editable |
| 112 | Bal. VAT Difference | Decimal | — | not editable |
| 113 | IC Partner Code | Code[20] | — | TableRelation Table 413 “IC Partner” (IC Partner); not editable |
| 114 | IC Direction | Enum “IC Direction Type” | — | enum Enum 129 “IC Direction Type” |
| 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) |
| 117 | IC Partner Transaction No. | Integer | — | not editable |
| 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) |
| 119 | VAT Registration No. | Text[20] | — | |
| 120 | Country/Region Code | Code[10] | — | TableRelation Table 9 “Country/Region” (Country/Region) |
| 121 | Prepayment | Boolean | — | |
| 122 | Financial Void | Boolean | — | not editable |
| 123 | Copy VAT Setup to Jnl. Lines | Boolean | — | not editable |
| 125 | VAT Base Before Pmt. Disc. | Decimal | — | not editable |
| 126 | Orig. Pmt. Disc. Possible | Decimal | Original Pmt. Disc. Possible caption | not editable |
| 127 | Orig. Pmt. Disc. Possible(LCY) Δ BC28 | Decimal | Orig. Pmt. Disc. Possible (LCY) caption | not editable |
| 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…) |
| 146 | Spend Request No. + BC29 | Code[20] | Specifies the spend request that this journal line relates to. | TableRelation Table 6840 “Spend Request” (Spend Request) |
| 147 | Spend Request Close + BC29 | Boolean | Specifies that the spend request will be closed when the journal line is posted. | |
| 160 | Job Queue Status Δ BC24 | Enum “Document Job Queue Status” | — | enum Enum 485 “Document Job Queue Status”; not editable |
| 161 | Job Queue Entry ID | Guid | — | not editable |
| 165 | Incoming Document Entry No. | Integer | — | TableRelation Table 130 “Incoming Document” (Incoming Document) |
| 170 | Creditor No. | Code[20] | — | |
| 171 | Payment Reference | Code[50] | — | |
| 172 | Payment Method Code | Code[10] | — | TableRelation Table 289 “Payment Method” (Payment Method) |
| 173 | Applies-to Ext. Doc. No. | Code[35] | — | |
| 175 | Invoice Received Date | Date | — | |
| 288 | Recipient Bank Account | Code[20] | — | TableRelation Table 287 “Customer Bank Account”, Table 288 “Vendor Bank Account” (if (“Account Type” = const(Customer)) “Customer Bank Account”.Code where(“Customer No.” = field(“Account No.”)) else if (“Account Type” = const(Vendor)) “Vendor Bank Account”.Code where(“Vendor No.” = field(“Account No.”)) else if (“Account Type” = const(Employee)) Employee.“No.” where(“Employee No….) |
| 289 | Message to Recipient | Text[140] | — | |
| 290 | Exported to Payment File | Boolean | — | not editable |
| 480 | Dimension Set ID | Integer | — | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
| 1001 | Job Task No. Δ BC24 | Code[20] | Project Task No. caption | TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”))) |
| 1002 | Job Unit Price (LCY) Δ BC24 Δ BC28 | Decimal | Project Unit Price (LCY) caption | not editable |
| 1003 | Job Total Price (LCY) Δ BC24 Δ BC28 | Decimal | Project Total Price (LCY) caption | not editable |
| 1004 | Job Quantity Δ BC24 Δ BC28 | Decimal | Project Quantity caption | |
| 1005 | Job Unit Cost (LCY) Δ BC24 Δ BC28 | Decimal | Project Unit Cost (LCY) caption | not editable |
| 1006 | Job Line Discount % Δ BC24 Δ BC28 | Decimal | Project Line Discount % caption | |
| 1007 | Job Line Disc. Amount (LCY) Δ BC24 Δ BC28 | Decimal | Project Line Disc. Amount (LCY) caption | not editable |
| 1008 | Job Unit Of Measure Code Δ BC24 | Code[10] | Project Unit Of Measure Code caption | TableRelation Table 204 “Unit of Measure” (Unit of Measure) |
| 1009 | Job Line Type Δ BC24 | Enum “Job Line Type” | Project Line Type caption | enum Enum 1002 “Job Line Type” |
| 1010 | Job Unit Price Δ BC24 | Decimal | Project Unit Price caption | |
| 1011 | Job Total Price Δ BC24 | Decimal | Project Total Price caption | not editable |
| 1012 | Job Unit Cost Δ BC24 | Decimal | Project Unit Cost caption | not editable |
| 1013 | Job Total Cost Δ BC24 | Decimal | Project Total Cost caption | not editable |
| 1014 | Job Line Discount Amount Δ BC24 | Decimal | Project Line Discount Amount caption | |
| 1015 | Job Line Amount Δ BC24 | Decimal | Project Line Amount caption | |
| 1016 | Job Total Cost (LCY) Δ BC24 Δ BC28 | Decimal | Project Total Cost (LCY) caption | not editable |
| 1017 | Job Line Amount (LCY) Δ BC24 Δ BC28 | Decimal | Project Line Amount (LCY) caption | not editable |
| 1018 | Job Currency Factor Δ BC24 Δ BC28 | Decimal | Project Currency Factor caption | |
| 1019 | Job Currency Code Δ BC24 | Code[10] | Project Currency Code caption | |
| 1020 | Job Planning Line No. Δ BC24 | Integer | Project Planning Line No. caption | |
| 1030 | Job Remaining Qty. Δ BC24 Δ BC28 | Decimal | Project Remaining Qty. caption | |
| 1200 | Direct Debit Mandate ID | Code[35] | — | TableRelation Table 1230 “SEPA Direct Debit Mandate” (if (“Account Type” = const(Customer)) “SEPA Direct Debit Mandate” where(“Customer No.” = field(“Account No.”))) |
| 1220 | Data Exch. Entry No. | Integer | — | TableRelation Table 1220 “Data Exch.” (Data Exch.); not editable |
| 1221 | Payer Information | Text[50] | — | |
| 1222 | Transaction Information | Text[100] | — | |
| 1223 | Data Exch. Line No. | Integer | — | not editable |
| 1224 | Applied Automatically | Boolean | — | |
| 1700 | Deferral Code Δ BC29 | Code[10] | Specifies the deferral template that governs how expenses or revenue are deferred to the different accounting periods when the expenses or revenue were incurred. | TableRelation Table 1700 “Deferral Template” (“Deferral Template”.“Deferral Code”) |
| 1701 | Deferral Line No. | Integer | — | |
| 5050 | Campaign No. | Code[20] | — | TableRelation Table 5071 “Campaign” |
| 5400 | Prod. Order No. | Code[20] | — | not editable |
| 5600 | FA Posting Date | Date | — | |
| 5601 | FA Posting Type | Enum “Gen. Journal Line FA Posting Type” | — | enum Enum 5603 “Gen. Journal Line FA Posting Type” |
| 5602 | Depreciation Book Code | Code[10] | — | TableRelation Table 5611 “Depreciation Book” (Depreciation Book) |
| 5603 | Salvage Value Δ BC28 | Decimal | — | |
| 5604 | No. of Depreciation Days | Integer | — | |
| 5605 | Depr. until FA Posting Date | Boolean | — | |
| 5606 | Depr. Acquisition Cost | Boolean | — | |
| 5609 | Maintenance Code | Code[10] | — | TableRelation Table 5626 “Maintenance” |
| 5610 | Insurance No. | Code[20] | — | TableRelation Table 5628 “Insurance” |
| 5611 | Budgeted FA No. | Code[20] | — | TableRelation Table 5600 “Fixed Asset” (Fixed Asset) |
| 5612 | Duplicate in Depreciation Book | Code[10] | — | TableRelation Table 5611 “Depreciation Book” (Depreciation Book) |
| 5613 | Use Duplication List | Boolean | — | |
| 5614 | FA Reclassification Entry | Boolean | — | |
| 5615 | FA Error Entry No. | Integer | — | TableRelation Table 5601 “FA Ledger Entry” (FA Ledger Entry) |
| 5616 | Index Entry | Boolean | — | |
| 5617 | Source Line No. | Integer | — | |
| 5618 | Comment | Text[250] | — | |
| 5701 | Check Exported | Boolean | — | |
| 5702 | Check Transmitted | Boolean | — | |
| 6200 | Non-Deductible VAT % Δ BC28 | Decimal | — | |
| 6201 | Non-Deductible VAT Base Δ BC28 | Decimal | — | |
| 6202 | Non-Deductible VAT Amount Δ BC28 | Decimal | — | |
| 6203 | Non-Deductible VAT Base LCY Δ BC27 Δ BC28 | Decimal | — | |
| 6204 | Non-Deductible VAT Amount LCY Δ BC27 Δ BC28 | Decimal | — | |
| 6205 | Non-Deductible VAT Base ACY Δ BC27 | Decimal | — | |
| 6206 | Non-Deductible VAT Amount ACY Δ BC27 | Decimal | — | |
| 6208 | Non-Deductible VAT Diff. Δ BC28 | Decimal | Non-Deductible VAT Difference caption | |
| 8001 | Account Id | Guid | — | TableRelation Table 15 “G/L Account” (“G/L Account”.SystemId) |
| 8002 | Customer Id | Guid | — | TableRelation Customer.SystemId |
| 8003 | Applies-to Invoice Id | Guid | — | TableRelation Table 112 “Sales Invoice Header” (“Sales Invoice Header”.SystemId) |
| 8004 | Contact Graph Id | Text[250] | — | |
| 8005 | Last Modified DateTime | DateTime | — | |
| 8006 | Journal Batch Id | Guid | — | TableRelation Table 232 “Gen. Journal Batch” (“Gen. Journal Batch”.SystemId) |
| 8007 | Payment Method Id | Guid | — | TableRelation Table 289 “Payment Method” (“Payment Method”.SystemId) |
| 8010 | G/L Register No. Δ BC29 | Integer | Specifies the number of the general ledger register. | TableRelation Table 45 “G/L Register” (G/L Register) |
| 8011 | Indentation | Integer | — |
Keys
- Key1: Line No.
- Key2: Journal Template Name, Journal Batch Name, Line No. (clustered)
- Key3: G/L Register No.
- Key4: Document No., Posting Date
Events published
OnBeforeInsertFromGenJournalLine(GenJournalLine: Record "Gen. Journal Line"; var IsHandled: Boolean)(integration): Integration event triggered before creating a posted general journal line record from a general journal line.OnAfterInsertFromGenJournalLine(GenJournalLine: Record "Gen. Journal Line"; var PostedGenJournalLine: Record "Posted Gen. Journal Line")+ BC26 − BC26 (integration): Integration event triggered after successfully creating a posted general journal line record from a general journal line.- subscribers: Codeunit 4850 “AA Codes Posting Helper” OnAfterInsertFromGenJournalLine
Procedures
InsertFromGenJournalLine(GenJournalLine: Record "Gen. Journal Line"; GLRegNo: Integer; FirstLine: Boolean): Creates a posted general journal line record from a general journal line during the posting process.
Plus 1 local procedures.
Relations
- drill-down page Page 182 “Posted General Journal”
- lookup page Page 182 “Posted General Journal”
- Job Task No.: TableRelation Table 1001 “Job Task”
- Applies-to Invoice Id: TableRelation Table 112 “Sales Invoice Header”
- Data Exch. Entry No.: TableRelation Table 1220 “Data Exch.”
- Direct Debit Mandate ID: TableRelation Table 1230 “SEPA Direct Debit Mandate”
- Salespers./Purch. Code: TableRelation Table 13 “Salesperson/Purchaser”
- Incoming Document Entry No.: TableRelation Table 130 “Incoming Document”
- Account Id: TableRelation Table 15 “G/L Account”
- Account No.: TableRelation Table 15 “G/L Account” (conditional)
- Bal. Account No.: TableRelation Table 15 “G/L Account” (conditional)
- Job No.: TableRelation Table 167 “Job”
- Deferral Code: TableRelation Table 1700 “Deferral Template”
- Account No.: TableRelation Table 18 “Customer” (conditional)
- Bal. Account No.: TableRelation Table 18 “Customer” (conditional)
- Bill-to/Pay-to No.: TableRelation Table 18 “Customer” (conditional)
- Sell-to/Buy-from No.: TableRelation Table 18 “Customer” (conditional)
- Source No.: TableRelation Table 18 “Customer” (conditional)
- Journal Batch Name: TableRelation Table 182 “Posted Gen. Journal Batch”
- Job Unit Of Measure Code: TableRelation Table 204 “Unit of Measure”
- Business Unit Code: TableRelation Table 220 “Business Unit”
- Ship-to/Order Address Code: TableRelation Table 222 “Ship-to Address” (conditional)
- Ship-to/Order Address Code: TableRelation Table 224 “Order Address” (conditional)
- Account No.: TableRelation Table 23 “Vendor” (conditional)
- Bal. Account No.: TableRelation Table 23 “Vendor” (conditional)
- Bill-to/Pay-to No.: TableRelation Table 23 “Vendor” (conditional)
- Sell-to/Buy-from 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”
- Journal Batch Id: TableRelation Table 232 “Gen. Journal Batch”
- Bal. Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
- Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
- Bal. Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
- Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
- Account No.: TableRelation Table 270 “Bank Account” (conditional)
- Source No.: TableRelation Table 270 “Bank Account” (conditional)
- Recipient Bank Account: TableRelation Table 287 “Customer Bank Account” (conditional)
- Recipient Bank Account: TableRelation Table 288 “Vendor Bank Account” (conditional)
- Payment Method Code: TableRelation Table 289 “Payment Method”
- Payment Method Id: TableRelation Table 289 “Payment Method”
- Payment Terms Code: TableRelation Table 3 “Payment Terms”
- Posting No. Series: TableRelation Table 308 “No. Series”
- Bal. Tax Area Code: TableRelation Table 318 “Tax Area”
- Tax Area Code: TableRelation Table 318 “Tax Area”
- Bal. Tax Group Code: TableRelation Table 321 “Tax Group”
- Tax Group Code: TableRelation Table 321 “Tax Group”
- Bal. VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
- VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
- Bal. VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
- VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
- Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Currency Code: TableRelation Table 4 “Currency”
- Source Currency Code: TableRelation Table 4 “Currency”
- IC Account No.: TableRelation Table 410 “IC G/L Account” (conditional)
- IC Partner G/L Acc. No.: TableRelation Table 410 “IC G/L Account”
- IC Partner Code: TableRelation Table 413 “IC Partner”
- IC Account No.: TableRelation Table 422 “IC Bank Account” (conditional)
- G/L Register No.: TableRelation Table 45 “G/L Register”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Campaign No.: TableRelation Table 5071 “Campaign”
- Source No.: TableRelation Table 5200 “Employee” (conditional)
- Budgeted FA No.: TableRelation Table 5600 “Fixed Asset”
- Source No.: TableRelation Table 5600 “Fixed Asset” (conditional)
- FA Error Entry No.: TableRelation Table 5601 “FA Ledger Entry”
- Posting Group: TableRelation Table 5606 “FA Posting Group” (conditional)
- Depreciation Book Code: TableRelation Table 5611 “Depreciation Book”
- Duplicate in Depreciation Book: TableRelation Table 5611 “Depreciation Book”
- Maintenance Code: TableRelation Table 5626 “Maintenance”
- Insurance No.: TableRelation Table 5628 “Insurance”
- Spend Request No.: TableRelation Table 6840 “Spend Request”
- Country/Region Code: TableRelation Table 9 “Country/Region”
- Posting Group: TableRelation Table 92 “Customer Posting Group” (conditional)
- Posting Group: TableRelation Table 93 “Vendor Posting Group” (conditional)
Pages and codeunits on this table
- Page 182 “Posted General Journal” (source table)
Extended by
- Table extension 4855 “Auto Posted Gen. Journal Line”
- Table extension 6225 “Sust. Posted Gen. Journal Line”
Recent changes
- 2026-08-17 #10248 Bug 646799: Spend Request fields in Posted Gen. Journal Line have wrong/different field numbers in country versions (correct in w1) (main, BC30, fix)
- 2026-07-31 #8959 Deliverable 638799: Spend Requests in Base App (main, BC30, feature)
Countries that replace it
AU, BE, CA, CH, ES, FI, FR, GB, IT, MX, NL, NO, NZ, RU, SE, US
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). 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: "Posted Gen. Journal Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.