Table "Posted Gen. Journal Line"

ID 181
Namespace: Microsoft.Finance.GeneralLedger.Journal

Properties

Name Value
Caption Posted Gen. Journal Line
LookupPageId Page Microsoft.Finance.GeneralLedger.Journal."Posted General Journal"
DrillDownPageId Page Microsoft.Finance.GeneralLedger.Journal."Posted General Journal"
DataClassification CustomerContent

Fields

Name Type Description
"Journal Template Name" Code[10]
"Line No." Integer
"Account Type" Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Account Type"
"Account No." Code[20]
"Posting Date" Date
"Document Type" Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type"
"Document No." Code[20]
Description Text[100]
"VAT %" Decimal
"Bal. Account No." Code[20]
"Currency Code" Code[10]
Amount Decimal
"Debit Amount" Decimal
"Credit Amount" Decimal
"Amount (LCY)" Decimal
"Balance (LCY)" Decimal
"Currency Factor" Decimal
"Sales/Purch. (LCY)" Decimal
"Profit (LCY)" Decimal
"Inv. Discount (LCY)" Decimal
"Bill-to/Pay-to No." Code[20]
"Posting Group" Code[20]
"Shortcut Dimension 1 Code" Code[20]
"Shortcut Dimension 2 Code" Code[20]
"Salespers./Purch. Code" Code[20]
"Source Code" Code[10]
"System-Created Entry" Boolean
"On Hold" Code[3]
"Applies-to Doc. Type" Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type"
"Applies-to Doc. No." Code[20]
"Due Date" Date
"Pmt. Discount Date" Date
"Payment Discount %" Decimal
"Job No." Code[20]
Quantity Decimal
"VAT Amount" Decimal
"VAT Posting" Option
"Payment Terms Code" Code[10]
"Applies-to ID" Code[50]
"Business Unit Code" Code[20]
"Journal Batch Name" Code[10]
"Reason Code" Code[10]
"Recurring Method" Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Recurring Method"
"Expiration Date" Date
"Recurring Frequency" DateFormula
"Gen. Posting Type" Enum Microsoft.Foundation.Enums."General Posting Type"
"Gen. Bus. Posting Group" Code[20]
"Gen. Prod. Posting Group" Code[20]
"VAT Calculation Type" Enum Microsoft.Foundation.Enums."Tax Calculation Type"
"EU 3-Party Trade" Boolean
"Allow Application" Boolean
"Bal. Account Type" Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Account Type"
"Bal. Gen. Posting Type" Enum Microsoft.Foundation.Enums."General Posting Type"
"Bal. Gen. Bus. Posting Group" Code[20]
"Bal. Gen. Prod. Posting Group" Code[20]
"Bal. VAT Calculation Type" Enum Microsoft.Foundation.Enums."Tax Calculation Type"
"Bal. VAT %" Decimal
"Bal. VAT Amount" Decimal
"Bank Payment Type" Enum Microsoft.Bank.BankAccount."Bank Payment Type"
"VAT Base Amount" Decimal
"Bal. VAT Base Amount" Decimal
Correction Boolean
"Print Posted Documents" Boolean
"Check Printed" Boolean
"Document Date" Date
"External Document No." Code[35]
"Source Type" Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Source Type"
"Source No." Code[20]
"Posting No. Series" Code[20]
"Tax Area Code" Code[20]
"Tax Liable" Boolean
"Tax Group Code" Code[20]
"Use Tax" Boolean
"Bal. Tax Area Code" Code[20]
"Bal. Tax Liable" Boolean
"Bal. Tax Group Code" Code[20]
"Bal. Use Tax" Boolean
"VAT Bus. Posting Group" Code[20]
"VAT Prod. Posting Group" Code[20]
"Bal. VAT Bus. Posting Group" Code[20]
"Bal. VAT Prod. Posting Group" Code[20]
"Additional-Currency Posting" Option
"FA Add.-Currency Factor" Decimal
"Source Currency Code" Code[10]
"Source Currency Amount" Decimal
"Source Curr. VAT Base Amount" Decimal
"Source Curr. VAT Amount" Decimal
"VAT Base Discount %" Decimal
"VAT Amount (LCY)" Decimal
"VAT Base Amount (LCY)" Decimal
"Bal. VAT Amount (LCY)" Decimal
"Bal. VAT Base Amount (LCY)" Decimal
"Reversing Entry" Boolean
"Allow Zero-Amount Posting" Boolean
"Ship-to/Order Address Code" Code[10]
"VAT Difference" Decimal
"Bal. VAT Difference" Decimal
"IC Partner Code" Code[20]
"IC Direction" Enum Microsoft.Intercompany.Setup."IC Direction Type"
"IC Partner G/L Acc. No." Code[20]
"IC Partner Transaction No." Integer
"Sell-to/Buy-from No." Code[20]
"VAT Registration No." Text[20]
"Country/Region Code" Code[10]
Prepayment Boolean
"Financial Void" Boolean
"Copy VAT Setup to Jnl. Lines" Boolean
"VAT Base Before Pmt. Disc." Decimal
"Orig. Pmt. Disc. Possible" Decimal
"Orig. Pmt. Disc. Possible(LCY)" Decimal
"IC Account Type" Enum Microsoft.Intercompany.Journal."IC Journal Account Type"
"IC Account No." Code[20]
"Job Queue Status" Enum System.Threading."Document Job Queue Status"
"Job Queue Entry ID" Guid
"Incoming Document Entry No." Integer
"Creditor No." Code[20]
"Payment Reference" Code[50]
"Payment Method Code" Code[10]
"Applies-to Ext. Doc. No." Code[35]
"Invoice Received Date" Date
"Recipient Bank Account" Code[20]
"Message to Recipient" Text[140]
"Exported to Payment File" Boolean
"Dimension Set ID" Integer
"Job Task No." Code[20]
"Job Unit Price (LCY)" Decimal
"Job Total Price (LCY)" Decimal
"Job Quantity" Decimal
"Job Unit Cost (LCY)" Decimal
"Job Line Discount %" Decimal
"Job Line Disc. Amount (LCY)" Decimal
"Job Unit Of Measure Code" Code[10]
"Job Line Type" Enum Microsoft.Projects.Project.Job."Job Line Type"
"Job Unit Price" Decimal
"Job Total Price" Decimal
"Job Unit Cost" Decimal
"Job Total Cost" Decimal
"Job Line Discount Amount" Decimal
"Job Line Amount" Decimal
"Job Total Cost (LCY)" Decimal
"Job Line Amount (LCY)" Decimal
"Job Currency Factor" Decimal
"Job Currency Code" Code[10]
"Job Planning Line No." Integer
"Job Remaining Qty." Decimal
"Direct Debit Mandate ID" Code[35]
"Data Exch. Entry No." Integer
"Payer Information" Text[50]
"Transaction Information" Text[100]
"Data Exch. Line No." Integer
"Applied Automatically" Boolean
"Deferral Code" Code[10]
"Deferral Line No." Integer
"Campaign No." Code[20]
"Prod. Order No." Code[20]
"FA Posting Date" Date
"FA Posting Type" Enum Microsoft.FixedAssets.Journal."Gen. Journal Line FA Posting Type"
"Depreciation Book Code" Code[10]
"Salvage Value" Decimal
"No. of Depreciation Days" Integer
"Depr. until FA Posting Date" Boolean
"Depr. Acquisition Cost" Boolean
"Maintenance Code" Code[10]
"Insurance No." Code[20]
"Budgeted FA No." Code[20]
"Duplicate in Depreciation Book" Code[10]
"Use Duplication List" Boolean
"FA Reclassification Entry" Boolean
"FA Error Entry No." Integer
"Index Entry" Boolean
"Source Line No." Integer
Comment Text[250]
"Check Exported" Boolean
"Check Transmitted" Boolean
"Non-Deductible VAT %" Decimal
"Non-Deductible VAT Base" Decimal
"Non-Deductible VAT Amount" Decimal
"Non-Deductible VAT Base LCY" Decimal
"Non-Deductible VAT Amount LCY" Decimal
"Non-Deductible VAT Base ACY" Decimal
"Non-Deductible VAT Amount ACY" Decimal
"Non-Deductible VAT Diff." Decimal
"Account Id" Guid
"Customer Id" Guid
"Applies-to Invoice Id" Guid
"Contact Graph Id" Text[250]
"Last Modified DateTime" DateTime
"Journal Batch Id" Guid
"Payment Method Id" Guid
"G/L Register No." Integer
Indentation Integer
SystemId Guid
SystemCreatedAt DateTime
SystemCreatedBy Guid
SystemModifiedAt DateTime
SystemModifiedBy Guid
SystemRowVersion BigInteger

Methods

InsertFromGenJournalLine

procedure InsertFromGenJournalLine(GenJournalLine: Record "Gen. Journal Line", GLRegNo: Integer, FirstLine: Boolean)

Parameters

Name Type Description
GenJournalLine Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Line"
GLRegNo Integer
FirstLine Boolean

Events

OnBeforeInsertFromGenJournalLine

[IntegrationEvent(True,False)]
local procedure OnBeforeInsertFromGenJournalLine(GenJournalLine: Record "Gen. Journal Line", var IsHandled: Boolean)

Parameters

Name Type Description
GenJournalLine Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Line"
IsHandled Boolean

OnAfterInsertFromGenJournalLine

[IntegrationEvent(True,False)]
local procedure OnAfterInsertFromGenJournalLine(GenJournalLine: Record "Gen. Journal Line", var PostedGenJournalLine: Record "Posted Gen. Journal Line")

Parameters

Name Type Description
GenJournalLine Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Line"
PostedGenJournalLine Table Microsoft.Finance.GeneralLedger.Journal."Posted Gen. Journal Line"

See also