Table 181 Posted Gen. Journal Line
- App
- Base Application
- Namespace
- Microsoft.Finance.GeneralLedger.Journal
- Versions
- 17-28
Fields, 191Keys, 4Procedures, 1Events, 3Obsolete, 1
Versions171819202122232425262728
Source29
Source in 29
src/Layers/W1/BaseApp/Finance/GeneralLedger/Journal/PostedGenJournalLine.Table.al1899 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------
// Copyright (c) Microsoft Corporation. All rights reserved.
// Licensed under the MIT License. See License.txt in the project root for license information.
// ------------------------------------------------------------------------------------------------
namespace Microsoft.Finance.GeneralLedger.Journal;
using Microsoft.Bank.BankAccount;
using Microsoft.Bank.Check;
using Microsoft.Bank.DirectDebit;
using Microsoft.CRM.Campaign;
using Microsoft.CRM.Team;
using Microsoft.EServices.EDocument;
using Microsoft.Finance.Consolidation;
using Microsoft.Finance.Currency;
using Microsoft.Finance.Deferral;
using Microsoft.Finance.Dimension;
using Microsoft.Finance.GeneralLedger.Account;
using Microsoft.Finance.GeneralLedger.Ledger;
using Microsoft.Finance.GeneralLedger.Setup;
using Microsoft.Finance.SalesTax;
using Microsoft.Finance.SpendRequest;
using Microsoft.Finance.VAT.Setup;
using Microsoft.FixedAssets.Depreciation;
using Microsoft.FixedAssets.FixedAsset;
using Microsoft.FixedAssets.Insurance;
using Microsoft.FixedAssets.Journal;
using Microsoft.FixedAssets.Ledger;
using Microsoft.FixedAssets.Maintenance;
using Microsoft.Foundation.Address;
using Microsoft.Foundation.AuditCodes;
using Microsoft.Foundation.Enums;
using Microsoft.Foundation.NoSeries;
using Microsoft.Foundation.PaymentTerms;
using Microsoft.Foundation.UOM;
using Microsoft.HumanResources.Employee;
using Microsoft.Intercompany.BankAccount;
using Microsoft.Intercompany.GLAccount;
using Microsoft.Intercompany.Journal;
using Microsoft.Intercompany.Partner;
using Microsoft.Intercompany.Setup;
using Microsoft.Projects.Project.Job;
using Microsoft.Purchases.Vendor;
using Microsoft.Sales.Customer;
using Microsoft.Sales.History;
using System.IO;
using System.Threading;
/// <summary>
/// Table storing historical records of posted general journal lines for audit trail and reference purposes.
/// Maintains complete transaction history including account details, amounts, dimensions, and posting information.
/// </summary>
/// <remarks>
/// Archive table for posted general journal transactions providing comprehensive audit trail functionality.
/// Contains complete transaction details including account information, amounts, dimensions, VAT, and posting metadata.
/// Key features: Historical transaction tracking, audit trail compliance, transaction reconstruction capability.
/// Integration: Links to ledger entries via transaction numbers, maintains posting batch relationships.
/// </remarks>
table 181 "Posted Gen. Journal Line"
{
Caption = 'Posted Gen. Journal Line';
LookupPageId = "Posted General Journal";
DrillDownPageId = "Posted General Journal";
DataClassification = CustomerContent;
fields
{
/// <summary>
/// Journal template name that defined the original journal's behavior and validation rules.
/// </summary>
field(1; "Journal Template Name"; Code[10])
{
Caption = 'Journal Template Name';
ToolTip = 'Specifies the name of the journal template.';
}
/// <summary>
/// Original line number from the general journal line before posting.
/// </summary>
field(2; "Line No."; Integer)
{
Caption = 'Line No.';
AutoIncrement = true;
}
/// <summary>
/// Account type that was posted (G/L Account, Customer, Vendor, Bank Account, etc.).
/// </summary>
field(3; "Account Type"; Enum "Gen. Journal Account Type")
{
Caption = 'Account Type';
ToolTip = 'Specifies the type of account that the entry on the journal line will be posted to.';
}
/// <summary>
/// Account number that was posted to in the original journal transaction.
/// </summary>
field(4; "Account No."; Code[20])
{
Caption = 'Account No.';
ToolTip = 'Specifies the account number that the entry on the journal line will be posted to.';
TableRelation = 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 ("Account Type" = const("Fixed Asset")) "Fixed Asset"
else
if ("Account Type" = const("IC Partner")) "IC Partner"
else
if ("Account Type" = const(Employee)) Employee;
}
/// <summary>
/// Date when the journal line was posted to the ledgers.
/// </summary>
field(5; "Posting Date"; Date)
{
Caption = 'Posting Date';
ToolTip = 'Specifies the entry''s posting date.';
ClosingDates = true;
}
/// <summary>
/// Document type of the posted transaction (Invoice, Payment, Credit Memo, etc.).
/// </summary>
field(6; "Document Type"; Enum "Gen. Journal Document Type")
{
Caption = 'Document Type';
ToolTip = 'Specifies the type of document that the entry on the journal line is.';
}
/// <summary>
/// Document number of the posted transaction for reference and tracking.
/// </summary>
field(7; "Document No."; Code[20])
{
Caption = 'Document No.';
ToolTip = 'Specifies a document number for the journal line.';
}
/// <summary>
/// Description text from the original journal line explaining the transaction purpose.
/// </summary>
field(8; Description; Text[100])
{
Caption = 'Description';
ToolTip = 'Specifies a description of the entry.';
}
/// <summary>
/// VAT percentage rate applied to the posted transaction amount.
/// </summary>
field(10; "VAT %"; Decimal)
{
AutoFormatType = 0;
Caption = 'VAT %';
DecimalPlaces = 0 : 5;
Editable = false;
MaxValue = 100;
MinValue = 0;
}
/// <summary>
/// Balancing account number used in the posted journal transaction.
/// </summary>
field(11; "Bal. Account No."; Code[20])
{
Caption = 'Bal. Account No.';
ToolTip = '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 = 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 Account"
else
if ("Bal. Account Type" = const("Fixed Asset")) "Fixed Asset"
else
if ("Bal. Account Type" = const("IC Partner")) "IC Partner"
else
if ("Bal. Account Type" = const(Employee)) Employee;
}
/// <summary>
/// Currency code of the posted transaction amount.
/// </summary>
field(12; "Currency Code"; Code[10])
{
Caption = 'Currency Code';
ToolTip = 'Specifies the code of the currency for the amounts on the journal line.';
TableRelation = Currency;
}
/// <summary>
/// Transaction amount in the specified currency (positive for debits, negative for credits).
/// </summary>
field(13; Amount; Decimal)
{
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 1;
Caption = 'Amount';
ToolTip = 'Specifies the total amount (including VAT) that the journal line consists of.';
}
/// <summary>
/// Debit amount of the posted transaction (always positive when displayed).
/// </summary>
field(14; "Debit Amount"; Decimal)
{
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 1;
BlankZero = true;
Caption = 'Debit Amount';
ToolTip = 'Specifies the total amount (including VAT) that the journal line consists of, if it is a debit amount.';
}
/// <summary>
/// Credit amount for the posted transaction when using debit/credit presentation.
/// </summary>
field(15; "Credit Amount"; Decimal)
{
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 1;
BlankZero = true;
Caption = 'Credit Amount';
ToolTip = 'Specifies the total amount (including VAT) that the journal line consists of, if it is a credit amount.';
}
/// <summary>
/// Transaction amount converted to local currency using posting date exchange rate.
/// </summary>
field(16; "Amount (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Amount (LCY)';
}
/// <summary>
/// Running balance in local currency after posting this transaction.
/// </summary>
field(17; "Balance (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Balance (LCY)';
Editable = false;
}
/// <summary>
/// Exchange rate factor used for currency conversion at posting time.
/// </summary>
field(18; "Currency Factor"; Decimal)
{
AutoFormatType = 0;
Caption = 'Currency Factor';
DecimalPlaces = 0 : 15;
Editable = false;
MinValue = 0;
}
/// <summary>
/// Sales or purchase amount in local currency for statistical reporting.
/// </summary>
field(19; "Sales/Purch. (LCY)"; Decimal)
{
AutoFormatExpression = '';
AutoFormatType = 1;
Caption = 'Sales/Purch. (LCY)';
}
/// <summary>
/// Calculated profit amount in local currency for financial analysis.
/// </summary>
field(20; "Profit (LCY)"; Decimal)
{
AutoFormatExpression = '';
AutoFormatType = 1;
Caption = 'Profit (LCY)';
}
/// <summary>
/// Invoice discount amount in local currency applied during posting.
/// </summary>
field(21; "Inv. Discount (LCY)"; Decimal)
{
AutoFormatExpression = '';
AutoFormatType = 1;
Caption = 'Inv. Discount (LCY)';
}
/// <summary>
/// Bill-to customer number or pay-to vendor number for transaction tracking.
/// </summary>
field(22; "Bill-to/Pay-to No."; Code[20])
{
Caption = 'Bill-to/Pay-to No.';
Editable = false;
TableRelation = 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;
}
/// <summary>
/// Posting group used for G/L account determination (Customer, Vendor, or Fixed Asset).
/// </summary>
field(23; "Posting Group"; Code[20])
{
Caption = 'Posting Group';
Editable = false;
TableRelation = 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";
}
/// <summary>
/// Global dimension 1 code for reporting and analysis purposes.
/// </summary>
field(24; "Shortcut Dimension 1 Code"; Code[20])
{
CaptionClass = '1,2,1';
Caption = 'Shortcut Dimension 1 Code';
ToolTip = '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 = "Dimension Value".Code where("Global Dimension No." = const(1),
Blocked = const(false));
}
/// <summary>
/// Global dimension 2 code for reporting and analysis purposes.
/// </summary>
field(25; "Shortcut Dimension 2 Code"; Code[20])
{
CaptionClass = '1,2,2';
Caption = 'Shortcut Dimension 2 Code';
ToolTip = '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 = "Dimension Value".Code where("Global Dimension No." = const(2),
Blocked = const(false));
}
/// <summary>
/// Salesperson or purchaser code associated with the transaction.
/// </summary>
field(26; "Salespers./Purch. Code"; Code[20])
{
Caption = 'Salespers./Purch. Code';
TableRelation = "Salesperson/Purchaser";
}
/// <summary>
/// Source code identifying the origin of the posted transaction.
/// </summary>
field(29; "Source Code"; Code[10])
{
Caption = 'Source Code';
Editable = false;
TableRelation = "Source Code";
}
/// <summary>
/// Indicates whether the entry was created automatically by the system.
/// </summary>
field(30; "System-Created Entry"; Boolean)
{
Caption = 'System-Created Entry';
Editable = false;
}
/// <summary>
/// Hold code preventing payment processing for this transaction.
/// </summary>
field(34; "On Hold"; Code[3])
{
Caption = 'On Hold';
}
/// <summary>
/// Document type of the entry that was applied for payment settlement in the posted transaction.
/// </summary>
field(35; "Applies-to Doc. Type"; Enum "Gen. Journal Document Type")
{
Caption = 'Applies-to Doc. Type';
}
/// <summary>
/// Document number of the entry that was applied for payment settlement in the posted transaction.
/// </summary>
field(36; "Applies-to Doc. No."; Code[20])
{
Caption = 'Applies-to Doc. No.';
}
/// <summary>
/// Payment due date for the posted transaction.
/// </summary>
field(38; "Due Date"; Date)
{
Caption = 'Due Date';
}
/// <summary>
/// Date until which payment discount can be taken.
/// </summary>
field(39; "Pmt. Discount Date"; Date)
{
Caption = 'Pmt. Discount Date';
}
/// <summary>
/// Payment discount percentage available for early payment.
/// </summary>
field(40; "Payment Discount %"; Decimal)
{
AutoFormatType = 0;
Caption = 'Payment Discount %';
DecimalPlaces = 0 : 5;
MaxValue = 100;
MinValue = 0;
}
/// <summary>
/// Project number for project-related transactions and cost allocation.
/// </summary>
field(42; "Job No."; Code[20])
{
Caption = 'Project No.';
TableRelation = Job;
}
/// <summary>
/// Quantity associated with the posted transaction for unit-based calculations and reporting.
/// </summary>
field(43; Quantity; Decimal)
{
AutoFormatType = 0;
Caption = 'Quantity';
ToolTip = 'Specifies the quantity of items to be included on the journal line.';
DecimalPlaces = 0 : 5;
}
/// <summary>
/// VAT amount calculated and posted for the transaction.
/// </summary>
field(44; "VAT Amount"; Decimal)
{
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 1;
Caption = 'VAT Amount';
ToolTip = 'Specifies the amount of VAT included in the total amount.';
}
/// <summary>
/// VAT posting method used (Automatic or Manual VAT Entry).
/// </summary>
field(45; "VAT Posting"; Option)
{
Caption = 'VAT Posting';
Editable = false;
OptionCaption = 'Automatic VAT Entry,Manual VAT Entry';
OptionMembers = "Automatic VAT Entry","Manual VAT Entry";
}
/// <summary>
/// Payment terms code defining payment conditions for the transaction.
/// </summary>
field(47; "Payment Terms Code"; Code[10])
{
Caption = 'Payment Terms Code';
TableRelation = "Payment Terms";
}
/// <summary>
/// Application identifier for grouping entries that apply to each other.
/// </summary>
field(48; "Applies-to ID"; Code[50])
{
Caption = 'Applies-to ID';
}
/// <summary>
/// Business unit code for decentralized organization reporting.
/// </summary>
field(50; "Business Unit Code"; Code[20])
{
Caption = 'Business Unit Code';
TableRelation = "Business Unit";
}
/// <summary>
/// Journal batch name where the original transaction was entered.
/// </summary>
field(51; "Journal Batch Name"; Code[10])
{
Caption = 'Journal Batch Name';
ToolTip = 'Specifies the name of the journal batch.';
TableRelation = "Posted Gen. Journal Batch".Name where("Journal Template Name" = field("Journal Template Name"));
}
/// <summary>
/// Reason code explaining the purpose or cause of the transaction.
/// </summary>
field(52; "Reason Code"; Code[10])
{
Caption = 'Reason Code';
TableRelation = "Reason Code";
}
/// <summary>
/// Recurring posting method for repeating transactions.
/// </summary>
field(53; "Recurring Method"; Enum "Gen. Journal Recurring Method")
{
BlankZero = true;
Caption = 'Recurring Method';
}
/// <summary>
/// Expiration date for recurring journal transactions.
/// </summary>
field(54; "Expiration Date"; Date)
{
Caption = 'Expiration Date';
}
/// <summary>
/// Frequency formula for recurring transaction intervals.
/// </summary>
field(55; "Recurring Frequency"; DateFormula)
{
Caption = 'Recurring Frequency';
}
/// <summary>
/// General posting type for G/L account transactions (Purchase, Sale, Settlement).
/// </summary>
field(57; "Gen. Posting Type"; Enum "General Posting Type")
{
Caption = 'Gen. Posting Type';
ToolTip = 'Specifies the general posting type that will be used when you post the entry on this journal line.';
}
/// <summary>
/// General business posting group for posting setup determination.
/// </summary>
field(58; "Gen. Bus. Posting Group"; Code[20])
{
Caption = 'Gen. Bus. Posting Group';
ToolTip = '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 = "Gen. Business Posting Group";
}
/// <summary>
/// General product posting group for posting setup determination.
/// </summary>
field(59; "Gen. Prod. Posting Group"; Code[20])
{
Caption = 'Gen. Prod. Posting Group';
ToolTip = '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 = "Gen. Product Posting Group";
}
/// <summary>
/// VAT calculation type method used for tax calculation.
/// </summary>
field(60; "VAT Calculation Type"; Enum "Tax Calculation Type")
{
Caption = 'VAT Calculation Type';
Editable = false;
}
/// <summary>
/// Indicates if transaction involves European Union 3-party trade.
/// </summary>
field(61; "EU 3-Party Trade"; Boolean)
{
Caption = 'EU 3-Party Trade';
Editable = false;
}
/// <summary>
/// Indicates whether the entry can be applied to other entries.
/// </summary>
field(62; "Allow Application"; Boolean)
{
Caption = 'Allow Application';
InitValue = true;
}
/// <summary>
/// Balance account type used for automatic balancing (G/L Account, Customer, Vendor, Bank Account).
/// </summary>
field(63; "Bal. Account Type"; Enum "Gen. Journal Account Type")
{
Caption = 'Bal. Account Type';
ToolTip = 'Specifies the code for the balancing account type that should be used in this journal line.';
}
/// <summary>
/// General posting type for balancing account transactions.
/// </summary>
field(64; "Bal. Gen. Posting Type"; Enum "General Posting Type")
{
Caption = 'Bal. Gen. Posting Type';
ToolTip = 'Specifies the general posting type associated with the balancing account that will be used when you post the entry on the journal line.';
}
/// <summary>
/// General business posting group for balancing account posting setup.
/// </summary>
field(65; "Bal. Gen. Bus. Posting Group"; Code[20])
{
Caption = 'Bal. Gen. Bus. Posting Group';
ToolTip = 'Specifies the general business posting group code associated with the balancing account that will be used when you post the entry.';
TableRelation = "Gen. Business Posting Group";
}
/// <summary>
/// General product posting group for balancing account posting setup.
/// </summary>
field(66; "Bal. Gen. Prod. Posting Group"; Code[20])
{
Caption = 'Bal. Gen. Prod. Posting Group';
ToolTip = 'Specifies the general product posting group code associated with the balancing account that will be used when you post the entry.';
TableRelation = "Gen. Product Posting Group";
}
/// <summary>
/// VAT calculation type for balancing account VAT processing.
/// </summary>
field(67; "Bal. VAT Calculation Type"; Enum "Tax Calculation Type")
{
Caption = 'Bal. VAT Calculation Type';
Editable = false;
}
/// <summary>
/// VAT percentage rate for balancing account transactions.
/// </summary>
field(68; "Bal. VAT %"; Decimal)
{
AutoFormatType = 0;
Caption = 'Bal. VAT %';
DecimalPlaces = 0 : 5;
Editable = false;
MaxValue = 100;
MinValue = 0;
}
/// <summary>
/// VAT amount calculated for balancing account transactions.
/// </summary>
field(69; "Bal. VAT Amount"; Decimal)
{
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 1;
Caption = 'Bal. VAT Amount';
}
/// <summary>
/// Bank payment type for electronic banking transactions.
/// </summary>
field(70; "Bank Payment Type"; Enum "Bank Payment Type")
{
AccessByPermission = TableData "Bank Account" = R;
Caption = 'Bank Payment Type';
}
/// <summary>
/// VAT base amount for the posted transaction on which VAT calculations were performed.
/// </summary>
field(71; "VAT Base Amount"; Decimal)
{
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 1;
Caption = 'VAT Base Amount';
}
/// <summary>
/// VAT base amount for the balancing account on which VAT calculations were performed.
/// </summary>
field(72; "Bal. VAT Base Amount"; Decimal)
{
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 1;
Caption = 'Bal. VAT Base Amount';
}
/// <summary>
/// Indicates whether the entry is a correction of a previously posted entry.
/// </summary>
field(73; Correction; Boolean)
{
Caption = 'Correction';
}
/// <summary>
/// Indicates whether posted documents should be printed automatically.
/// </summary>
field(74; "Print Posted Documents"; Boolean)
{
Caption = 'Print Posted Documents';
}
/// <summary>
/// Indicates whether a check has been printed for this payment transaction.
/// </summary>
field(75; "Check Printed"; Boolean)
{
AccessByPermission = TableData "Check Ledger Entry" = R;
Caption = 'Check Printed';
Editable = false;
}
/// <summary>
/// Document date from the original source document.
/// </summary>
field(76; "Document Date"; Date)
{
Caption = 'Document Date';
ClosingDates = true;
}
/// <summary>
/// External document number reference from vendor invoice or customer statement.
/// </summary>
field(77; "External Document No."; Code[35])
{
Caption = 'External Document No.';
}
/// <summary>
/// Source type indicating the origin of the journal line (Customer, Vendor, Bank Account, etc.).
/// </summary>
field(78; "Source Type"; Enum "Gen. Journal Source Type")
{
Caption = 'Source Type';
}
/// <summary>
/// Source number corresponding to the source type (Customer No., Vendor No., etc.).
/// </summary>
field(79; "Source No."; Code[20])
{
Caption = 'Source No.';
TableRelation = 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;
}
/// <summary>
/// Number series used for posting document numbering.
/// </summary>
field(80; "Posting No. Series"; Code[20])
{
Caption = 'Posting No. Series';
TableRelation = "No. Series";
}
/// <summary>
/// Tax area code for sales tax jurisdiction determination.
/// </summary>
field(82; "Tax Area Code"; Code[20])
{
Caption = 'Tax Area Code';
TableRelation = "Tax Area";
}
/// <summary>
/// Indicates whether the transaction is subject to sales tax.
/// </summary>
field(83; "Tax Liable"; Boolean)
{
Caption = 'Tax Liable';
}
/// <summary>
/// Tax group code for determining applicable tax rates and calculation rules.
/// </summary>
field(84; "Tax Group Code"; Code[20])
{
Caption = 'Tax Group Code';
TableRelation = "Tax Group";
}
/// <summary>
/// Indicates whether use tax applies to this transaction.
/// </summary>
field(85; "Use Tax"; Boolean)
{
Caption = 'Use Tax';
}
/// <summary>
/// Tax area code for balancing account tax jurisdiction determination.
/// </summary>
field(86; "Bal. Tax Area Code"; Code[20])
{
Caption = 'Bal. Tax Area Code';
TableRelation = "Tax Area";
}
/// <summary>
/// Indicates whether the balancing account transaction is subject to sales tax.
/// </summary>
field(87; "Bal. Tax Liable"; Boolean)
{
Caption = 'Bal. Tax Liable';
}
/// <summary>
/// Tax group code for balancing account tax calculation rules.
/// </summary>
field(88; "Bal. Tax Group Code"; Code[20])
{
Caption = 'Bal. Tax Group Code';
TableRelation = "Tax Group";
}
/// <summary>
/// Indicates whether use tax applies to the balancing account transaction.
/// </summary>
field(89; "Bal. Use Tax"; Boolean)
{
Caption = 'Bal. Use Tax';
}
/// <summary>
/// VAT business posting group for VAT setup determination.
/// </summary>
field(90; "VAT Bus. Posting Group"; Code[20])
{
Caption = 'VAT Bus. Posting Group';
ToolTip = 'Specifies the VAT business posting group code that will be used when you post the entry on the journal line.';
TableRelation = "VAT Business Posting Group";
}
/// <summary>
/// VAT product posting group for VAT setup determination.
/// </summary>
field(91; "VAT Prod. Posting Group"; Code[20])
{
Caption = 'VAT Prod. Posting Group';
ToolTip = '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 = "VAT Product Posting Group";
}
/// <summary>
/// VAT business posting group for balancing account VAT setup.
/// </summary>
field(92; "Bal. VAT Bus. Posting Group"; Code[20])
{
Caption = 'Bal. VAT Bus. Posting Group';
TableRelation = "VAT Business Posting Group";
}
/// <summary>
/// VAT product posting group for balancing account VAT setup.
/// </summary>
field(93; "Bal. VAT Prod. Posting Group"; Code[20])
{
Caption = 'Bal. VAT Prod. Posting Group';
TableRelation = "VAT Product Posting Group";
}
/// <summary>
/// Additional currency posting method for multi-currency reporting.
/// </summary>
field(95; "Additional-Currency Posting"; Option)
{
Caption = 'Additional-Currency Posting';
Editable = false;
OptionCaption = 'None,Amount Only,Additional-Currency Amount Only';
OptionMembers = "None","Amount Only","Additional-Currency Amount Only";
}
/// <summary>
/// Fixed asset additional currency conversion factor.
/// </summary>
field(98; "FA Add.-Currency Factor"; Decimal)
{
AutoFormatType = 0;
Caption = 'FA Add.-Currency Factor';
DecimalPlaces = 0 : 15;
MinValue = 0;
}
/// <summary>
/// Currency code of the source document before conversion.
/// </summary>
field(99; "Source Currency Code"; Code[10])
{
Caption = 'Source Currency Code';
Editable = false;
TableRelation = Currency;
}
/// <summary>
/// Transaction amount in source currency before conversion.
/// </summary>
field(100; "Source Currency Amount"; Decimal)
{
AccessByPermission = TableData Currency = R;
AutoFormatType = 1;
AutoFormatExpression = "Source Currency Code";
Caption = 'Source Currency Amount';
Editable = false;
}
/// <summary>
/// VAT base amount in source currency before conversion.
/// </summary>
field(101; "Source Curr. VAT Base Amount"; Decimal)
{
AccessByPermission = TableData Currency = R;
AutoFormatType = 1;
AutoFormatExpression = "Source Currency Code";
Caption = 'Source Curr. VAT Base Amount';
Editable = false;
}
/// <summary>
/// VAT amount in source currency before conversion.
/// </summary>
field(102; "Source Curr. VAT Amount"; Decimal)
{
AccessByPermission = TableData Currency = R;
AutoFormatType = 1;
AutoFormatExpression = "Source Currency Code";
Caption = 'Source Curr. VAT Amount';
Editable = false;
}
/// <summary>
/// VAT base discount percentage applied to the transaction.
/// </summary>
field(103; "VAT Base Discount %"; Decimal)
{
AutoFormatType = 0;
Caption = 'VAT Base Discount %';
DecimalPlaces = 0 : 5;
Editable = false;
MaxValue = 100;
MinValue = 0;
}
/// <summary>
/// VAT amount converted to local currency for posting.
/// </summary>
field(104; "VAT Amount (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'VAT Amount (LCY)';
Editable = false;
}
/// <summary>
/// VAT base amount converted to local currency for posting.
/// </summary>
field(105; "VAT Base Amount (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'VAT Base Amount (LCY)';
Editable = false;
}
/// <summary>
/// Balancing account VAT amount converted to local currency for posting.
/// </summary>
field(106; "Bal. VAT Amount (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Bal. VAT Amount (LCY)';
Editable = false;
}
/// <summary>
/// Balancing account VAT base amount converted to local currency for posting.
/// </summary>
field(107; "Bal. VAT Base Amount (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Bal. VAT Base Amount (LCY)';
Editable = false;
}
/// <summary>
/// Indicates whether this is a reversing entry that will be automatically reversed.
/// </summary>
field(108; "Reversing Entry"; Boolean)
{
Caption = 'Reversing Entry';
Editable = false;
}
/// <summary>
/// Indicates whether posting zero amounts is allowed for this transaction.
/// </summary>
field(109; "Allow Zero-Amount Posting"; Boolean)
{
Caption = 'Allow Zero-Amount Posting';
Editable = false;
}
/// <summary>
/// Ship-to address code for customer transactions or order address code for vendor transactions.
/// </summary>
field(110; "Ship-to/Order Address Code"; Code[10])
{
Caption = 'Ship-to/Order Address Code';
TableRelation = 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 where("Customer No." = field("Bill-to/Pay-to No."))
else
if ("Bal. Account Type" = const(Vendor)) "Order Address".Code where("Vendor No." = field("Bill-to/Pay-to No."));
}
/// <summary>
/// VAT amount difference allowed for manual VAT correction.
/// </summary>
field(111; "VAT Difference"; Decimal)
{
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 1;
Caption = 'VAT Difference';
Editable = false;
}
/// <summary>
/// Balancing account VAT amount difference allowed for manual VAT correction.
/// </summary>
field(112; "Bal. VAT Difference"; Decimal)
{
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 1;
Caption = 'Bal. VAT Difference';
Editable = false;
}
/// <summary>
/// Intercompany partner code for intercompany transaction processing.
/// </summary>
field(113; "IC Partner Code"; Code[20])
{
Caption = 'IC Partner Code';
Editable = false;
TableRelation = "IC Partner";
}
/// <summary>
/// Intercompany transaction direction (Outgoing or Incoming).
/// </summary>
field(114; "IC Direction"; Enum "IC Direction Type")
{
Caption = 'IC Direction';
}
#if not CLEANSCHEMA25
/// <summary>
/// Intercompany partner G/L account number used for intercompany transactions (obsolete field replaced by IC Account No.).
/// </summary>
field(116; "IC Partner G/L Acc. No."; Code[20])
{
Caption = 'IC Partner G/L Acc. No.';
TableRelation = "IC G/L Account";
ObsoleteReason = 'Replaced by IC Account No.';
ObsoleteState = Removed;
ObsoleteTag = '25.0';
}
#endif
/// <summary>
/// Intercompany partner transaction number for cross-reference tracking.
/// </summary>
field(117; "IC Partner Transaction No."; Integer)
{
Caption = 'IC Partner Transaction No.';
Editable = false;
}
/// <summary>
/// Sell-to customer number or buy-from vendor number for the transaction.
/// </summary>
field(118; "Sell-to/Buy-from No."; Code[20])
{
Caption = 'Sell-to/Buy-from No.';
TableRelation = 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;
}
/// <summary>
/// VAT registration number for tax reporting and compliance verification.
/// </summary>
field(119; "VAT Registration No."; Text[20])
{
Caption = 'VAT Registration No.';
}
/// <summary>
/// Country or region code for geographic reporting and tax determination.
/// </summary>
field(120; "Country/Region Code"; Code[10])
{
Caption = 'Country/Region Code';
TableRelation = "Country/Region";
}
/// <summary>
/// Indicates whether the transaction is related to a prepayment.
/// </summary>
field(121; Prepayment; Boolean)
{
Caption = 'Prepayment';
}
/// <summary>
/// Indicates whether the entry has been financially voided.
/// </summary>
field(122; "Financial Void"; Boolean)
{
Caption = 'Financial Void';
Editable = false;
}
/// <summary>
/// Indicates whether VAT setup should be copied to journal lines.
/// </summary>
field(123; "Copy VAT Setup to Jnl. Lines"; Boolean)
{
Caption = 'Copy VAT Setup to Jnl. Lines';
Editable = false;
InitValue = true;
}
/// <summary>
/// VAT base amount before payment discount application.
/// </summary>
field(125; "VAT Base Before Pmt. Disc."; Decimal)
{
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 1;
Caption = 'VAT Base Before Pmt. Disc.';
Editable = false;
}
/// <summary>
/// Original payment discount amount possible before any adjustments.
/// </summary>
field(126; "Orig. Pmt. Disc. Possible"; Decimal)
{
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 1;
Caption = 'Original Pmt. Disc. Possible';
Editable = false;
}
/// <summary>
/// Original payment discount amount possible in local currency at the time of posting.
/// </summary>
field(127; "Orig. Pmt. Disc. Possible(LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Orig. Pmt. Disc. Possible (LCY)';
Editable = false;
}
/// <summary>
/// Intercompany account type for intercompany transactions and postings.
/// </summary>
field(130; "IC Account Type"; Enum "IC Journal Account Type")
{
Caption = 'IC Account Type';
}
/// <summary>
/// Intercompany account number for intercompany transactions and reconciliation.
/// </summary>
field(131; "IC Account No."; Code[20])
{
Caption = 'IC Account No.';
TableRelation =
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(false))
else
if ("Account Type" = const(Vendor), "IC Account Type" = const("Bank Account")) "IC Bank Account" where("IC Partner Code" = field("IC Partner Code"), Blocked = const(false))
else
if ("Account Type" = const("IC Partner"), "IC Account Type" = const("Bank Account")) "IC Bank Account" where("IC Partner Code" = field("Account No."), Blocked = const(false))
else
if ("Bal. Account Type" = const(Customer), "IC Account Type" = const("Bank Account")) "IC Bank Account" where("IC Partner Code" = field("IC Partner Code"), Blocked = const(false))
else
if ("Bal. Account Type" = const(Vendor), "IC Account Type" = const("Bank Account")) "IC Bank Account" where("IC Partner Code" = field("IC Partner Code"), Blocked = const(false))
else
if ("Bal. Account Type" = const("IC Partner"), "IC Account Type" = const("Bank Account")) "IC Bank Account" where("IC Partner Code" = field("Bal. Account No."), Blocked = const(false));
}
/// <summary>
/// Specifies the spend request that this journal line relates to.
/// </summary>
field(146; "Spend Request No."; Code[20])
{
Caption = 'Spend Request No.';
ToolTip = 'Specifies the spend request that this journal line relates to.';
TableRelation = "Spend Request";
DataClassification = CustomerContent;
}
/// <summary>
/// Specifies that the spend request will be closed when the journal line is posted.
/// </summary>
field(147; "Spend Request Close"; Boolean)
{
Caption = 'Spend Request Close';
ToolTip = 'Specifies that the spend request will be closed when the journal line is posted.';
DataClassification = CustomerContent;
}
/// <summary>
/// Job queue status for background processing and automated journal posting operations.
/// </summary>
field(160; "Job Queue Status"; Enum "Document Job Queue Status")
{
Caption = 'Job Queue Status';
Editable = false;
}
/// <summary>
/// Job queue entry unique identifier for tracking background processing tasks and automation status.
/// </summary>
field(161; "Job Queue Entry ID"; Guid)
{
Caption = 'Job Queue Entry ID';
Editable = false;
}
/// <summary>
/// Incoming document entry number linking posted journal entries to source documents for audit trail and workflow tracking.
/// </summary>
field(165; "Incoming Document Entry No."; Integer)
{
Caption = 'Incoming Document Entry No.';
TableRelation = "Incoming Document";
}
/// <summary>
/// Creditor number for creditor identification in payment processing and vendor management workflows.
/// </summary>
field(170; "Creditor No."; Code[20])
{
Caption = 'Creditor No.';
}
/// <summary>
/// Payment reference for transaction tracking and bank reconciliation in electronic payment processing.
/// </summary>
field(171; "Payment Reference"; Code[50])
{
Caption = 'Payment Reference';
}
/// <summary>
/// Payment method code defining the payment type and processing rules for transaction execution.
/// </summary>
field(172; "Payment Method Code"; Code[10])
{
Caption = 'Payment Method Code';
TableRelation = "Payment Method";
}
/// <summary>
/// External document number for application tracking and cross-reference with external systems.
/// </summary>
field(173; "Applies-to Ext. Doc. No."; Code[35])
{
Caption = 'Applies-to Ext. Doc. No.';
}
/// <summary>
/// Invoice received date for tracking invoice receipt timing and processing workflow management.
/// </summary>
field(175; "Invoice Received Date"; Date)
{
}
/// <summary>
/// Recipient bank account for payment processing and electronic funds transfer operations.
/// </summary>
field(288; "Recipient Bank Account"; Code[20])
{
Caption = 'Recipient Bank Account';
TableRelation = 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. Filter" = field("Account No."))
else
if ("Bal. Account Type" = const(Customer)) "Customer Bank Account".Code where("Customer No." = field("Bal. Account No."))
else
if ("Bal. Account Type" = const(Vendor)) "Vendor Bank Account".Code where("Vendor No." = field("Bal. Account No."))
else
if ("Bal. Account Type" = const(Employee)) Employee."No." where("Employee No. Filter" = field("Bal. Account No."));
}
/// <summary>
/// Message to recipient for payment communication and remittance advice in electronic payment processing.
/// </summary>
field(289; "Message to Recipient"; Text[140])
{
Caption = 'Message to Recipient';
}
/// <summary>
/// Indicates whether payment data has been exported to external payment file for electronic payment processing.
/// </summary>
field(290; "Exported to Payment File"; Boolean)
{
Caption = 'Exported to Payment File';
Editable = false;
}
/// <summary>
/// Dimension set identifier linking posted entries to dimension combinations for analytical reporting and financial analysis.
/// </summary>
field(480; "Dimension Set ID"; Integer)
{
Caption = 'Dimension Set ID';
Editable = false;
TableRelation = "Dimension Set Entry";
}
/// <summary>
/// Project task number for job-specific transactions linking posted entries to specific project tasks and work breakdown structure.
/// </summary>
field(1001; "Job Task No."; Code[20])
{
Caption = 'Project Task No.';
TableRelation = "Job Task"."Job Task No." where("Job No." = field("Job No."));
}
/// <summary>
/// Project unit price in local currency for job costing and project profitability calculations.
/// </summary>
field(1002; "Job Unit Price (LCY)"; Decimal)
{
AccessByPermission = TableData Job = R;
AutoFormatType = 2;
AutoFormatExpression = '';
Caption = 'Project Unit Price (LCY)';
Editable = false;
}
/// <summary>
/// Project total price in local currency for job revenue tracking and project financial analysis.
/// </summary>
field(1003; "Job Total Price (LCY)"; Decimal)
{
AccessByPermission = TableData Job = R;
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Project Total Price (LCY)';
Editable = false;
}
/// <summary>
/// Project quantity for job consumption tracking and resource utilization calculations.
/// </summary>
field(1004; "Job Quantity"; Decimal)
{
AccessByPermission = TableData Job = R;
AutoFormatType = 0;
Caption = 'Project Quantity';
DecimalPlaces = 0 : 5;
}
/// <summary>
/// Project unit cost in local currency for job cost accounting and project profitability analysis.
/// </summary>
field(1005; "Job Unit Cost (LCY)"; Decimal)
{
AccessByPermission = TableData Job = R;
AutoFormatType = 2;
AutoFormatExpression = '';
Caption = 'Project Unit Cost (LCY)';
Editable = false;
}
/// <summary>
/// Project line discount percentage for job pricing adjustments and contract-based discounting.
/// </summary>
field(1006; "Job Line Discount %"; Decimal)
{
AccessByPermission = TableData Job = R;
AutoFormatType = 0;
Caption = 'Project Line Discount %';
}
/// <summary>
/// Project line discount amount in local currency for job cost and revenue calculations with contract adjustments.
/// </summary>
field(1007; "Job Line Disc. Amount (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Project Line Disc. Amount (LCY)';
Editable = false;
}
/// <summary>
/// Project unit of measure code for job quantity tracking and resource measurement standardization.
/// </summary>
field(1008; "Job Unit Of Measure Code"; Code[10])
{
Caption = 'Project Unit Of Measure Code';
TableRelation = "Unit of Measure";
}
/// <summary>
/// Project line type defining the nature of job transaction for project classification and billing purposes.
/// </summary>
field(1009; "Job Line Type"; Enum "Job Line Type")
{
AccessByPermission = TableData Job = R;
Caption = 'Project Line Type';
}
/// <summary>
/// Project unit price in job currency for multi-currency project pricing and international project management.
/// </summary>
field(1010; "Job Unit Price"; Decimal)
{
AccessByPermission = TableData Job = R;
AutoFormatExpression = "Job Currency Code";
AutoFormatType = 2;
Caption = 'Project Unit Price';
}
/// <summary>
/// Project total price in job currency for multi-currency project revenue tracking and financial reporting.
/// </summary>
field(1011; "Job Total Price"; Decimal)
{
AccessByPermission = TableData Job = R;
AutoFormatExpression = "Job Currency Code";
AutoFormatType = 1;
Caption = 'Project Total Price';
Editable = false;
}
/// <summary>
/// Project unit cost in job currency for multi-currency project cost accounting and international project analysis.
/// </summary>
field(1012; "Job Unit Cost"; Decimal)
{
AccessByPermission = TableData Job = R;
AutoFormatExpression = "Job Currency Code";
AutoFormatType = 2;
Caption = 'Project Unit Cost';
Editable = false;
}
/// <summary>
/// Project total cost in job currency for multi-currency project expense tracking and cost management.
/// </summary>
field(1013; "Job Total Cost"; Decimal)
{
AccessByPermission = TableData Job = R;
AutoFormatExpression = "Job Currency Code";
AutoFormatType = 1;
Caption = 'Project Total Cost';
Editable = false;
}
/// <summary>
/// Project line discount amount in job currency for contract-based pricing adjustments and international project discounting.
/// </summary>
field(1014; "Job Line Discount Amount"; Decimal)
{
AccessByPermission = TableData Job = R;
AutoFormatExpression = "Job Currency Code";
AutoFormatType = 1;
Caption = 'Project Line Discount Amount';
}
/// <summary>
/// Project line amount in job currency for multi-currency project revenue and billing calculations.
/// </summary>
field(1015; "Job Line Amount"; Decimal)
{
AccessByPermission = TableData Job = R;
AutoFormatExpression = "Job Currency Code";
AutoFormatType = 1;
Caption = 'Project Line Amount';
}
/// <summary>
/// Project total cost in local currency for comprehensive job cost tracking and profitability analysis.
/// </summary>
field(1016; "Job Total Cost (LCY)"; Decimal)
{
AccessByPermission = TableData Job = R;
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Project Total Cost (LCY)';
Editable = false;
}
/// <summary>
/// Project line amount in local currency for consolidated job revenue reporting and financial analysis.
/// </summary>
field(1017; "Job Line Amount (LCY)"; Decimal)
{
AccessByPermission = TableData Job = R;
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Project Line Amount (LCY)';
Editable = false;
}
/// <summary>
/// Project currency factor for multi-currency job calculations and exchange rate tracking in international projects.
/// </summary>
field(1018; "Job Currency Factor"; Decimal)
{
AutoFormatType = 0;
Caption = 'Project Currency Factor';
}
/// <summary>
/// Project currency code for multi-currency job transactions and international project financial management.
/// </summary>
field(1019; "Job Currency Code"; Code[10])
{
Caption = 'Project Currency Code';
}
/// <summary>
/// Project planning line number linking posted entries to specific job planning lines for project progress tracking.
/// </summary>
field(1020; "Job Planning Line No."; Integer)
{
AccessByPermission = TableData Job = R;
BlankZero = true;
Caption = 'Project Planning Line No.';
}
/// <summary>
/// Project remaining quantity for job completion tracking and resource planning calculations.
/// </summary>
field(1030; "Job Remaining Qty."; Decimal)
{
AccessByPermission = TableData Job = R;
AutoFormatType = 0;
Caption = 'Project Remaining Qty.';
DecimalPlaces = 0 : 5;
}
/// <summary>
/// Direct debit mandate ID for SEPA direct debit processing and automated payment collections from customer accounts.
/// </summary>
field(1200; "Direct Debit Mandate ID"; Code[35])
{
Caption = 'Direct Debit Mandate ID';
TableRelation = if ("Account Type" = const(Customer)) "SEPA Direct Debit Mandate" where("Customer No." = field("Account No."));
}
/// <summary>
/// Data exchange entry number linking posted entries to external data import processes and bank statement reconciliation.
/// </summary>
field(1220; "Data Exch. Entry No."; Integer)
{
Caption = 'Data Exch. Entry No.';
Editable = false;
TableRelation = "Data Exch.";
}
/// <summary>
/// Payer information from imported bank statements and electronic payment processing for transaction identification.
/// </summary>
field(1221; "Payer Information"; Text[50])
{
Caption = 'Payer Information';
}
/// <summary>
/// Transaction information from electronic payment processing and bank statement imports for detailed payment tracking.
/// </summary>
field(1222; "Transaction Information"; Text[100])
{
Caption = 'Transaction Information';
}
/// <summary>
/// Data exchange line number for tracking specific lines within imported bank statement and payment files.
/// </summary>
field(1223; "Data Exch. Line No."; Integer)
{
Caption = 'Data Exch. Line No.';
Editable = false;
}
/// <summary>
/// Applied automatically flag indicating whether the posted entry was matched and applied through automated payment matching processes.
/// </summary>
field(1224; "Applied Automatically"; Boolean)
{
Caption = 'Applied Automatically';
}
/// <summary>
/// Deferral code for revenue and expense deferral processing linking posted entries to deferral templates and schedules.
/// </summary>
field(1700; "Deferral Code"; Code[10])
{
Caption = 'Deferral Code';
ToolTip = '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 = "Deferral Template"."Deferral Code";
}
/// <summary>
/// Deferral line number for tracking specific lines within deferral schedules and multi-period revenue/expense recognition.
/// </summary>
field(1701; "Deferral Line No."; Integer)
{
Caption = 'Deferral Line No.';
}
/// <summary>
/// Campaign number for marketing campaign tracking and sales/purchase transaction analysis by promotional activities.
/// </summary>
field(5050; "Campaign No."; Code[20])
{
Caption = 'Campaign No.';
TableRelation = Campaign;
}
/// <summary>
/// Production order number for manufacturing cost allocation and work-in-process tracking in production-related transactions.
/// </summary>
field(5400; "Prod. Order No."; Code[20])
{
Caption = 'Prod. Order No.';
Editable = false;
}
/// <summary>
/// Fixed asset posting date for FA-specific transaction dating and depreciation calculation in asset management entries.
/// </summary>
field(5600; "FA Posting Date"; Date)
{
AccessByPermission = TableData "Fixed Asset" = R;
Caption = 'FA Posting Date';
}
/// <summary>
/// Fixed asset posting type defining the nature of FA transaction for depreciation, acquisition, disposal, and maintenance operations.
/// </summary>
field(5601; "FA Posting Type"; Enum "Gen. Journal Line FA Posting Type")
{
AccessByPermission = TableData "Fixed Asset" = R;
Caption = 'FA Posting Type';
}
/// <summary>
/// Depreciation book code for fixed asset depreciation tracking and multiple depreciation method management.
/// </summary>
field(5602; "Depreciation Book Code"; Code[10])
{
Caption = 'Depreciation Book Code';
TableRelation = "Depreciation Book";
}
/// <summary>
/// Salvage value for fixed asset depreciation calculations representing the estimated residual value at end of asset life.
/// </summary>
field(5603; "Salvage Value"; Decimal)
{
AccessByPermission = TableData "Fixed Asset" = R;
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Salvage Value';
}
/// <summary>
/// Number of depreciation days for fixed asset depreciation calculation and pro-rated depreciation in partial periods.
/// </summary>
field(5604; "No. of Depreciation Days"; Integer)
{
AccessByPermission = TableData "Fixed Asset" = R;
BlankZero = true;
Caption = 'No. of Depreciation Days';
}
/// <summary>
/// Depreciate until FA posting date flag controlling whether depreciation should be calculated up to the FA posting date.
/// </summary>
field(5605; "Depr. until FA Posting Date"; Boolean)
{
AccessByPermission = TableData "Fixed Asset" = R;
Caption = 'Depr. until FA Posting Date';
}
/// <summary>
/// Depreciate acquisition cost flag controlling whether the acquisition cost should be subject to depreciation calculations.
/// </summary>
field(5606; "Depr. Acquisition Cost"; Boolean)
{
AccessByPermission = TableData "Fixed Asset" = R;
Caption = 'Depr. Acquisition Cost';
}
/// <summary>
/// Maintenance code for fixed asset maintenance tracking and service history documentation in asset management systems.
/// </summary>
field(5609; "Maintenance Code"; Code[10])
{
Caption = 'Maintenance Code';
TableRelation = Maintenance;
}
/// <summary>
/// Insurance number linking fixed asset entries to insurance policies for asset protection and risk management tracking.
/// </summary>
field(5610; "Insurance No."; Code[20])
{
Caption = 'Insurance No.';
TableRelation = Insurance;
}
/// <summary>
/// Budgeted fixed asset number for budget tracking and planned asset acquisition management in financial planning processes.
/// </summary>
field(5611; "Budgeted FA No."; Code[20])
{
Caption = 'Budgeted FA No.';
TableRelation = "Fixed Asset";
}
/// <summary>
/// Duplicate in depreciation book code for cross-book depreciation posting and multi-book asset management synchronization.
/// </summary>
field(5612; "Duplicate in Depreciation Book"; Code[10])
{
Caption = 'Duplicate in Depreciation Book';
TableRelation = "Depreciation Book";
}
/// <summary>
/// Use duplication list flag controlling whether the duplication list should be used for cross-book depreciation posting.
/// </summary>
field(5613; "Use Duplication List"; Boolean)
{
AccessByPermission = TableData "Fixed Asset" = R;
Caption = 'Use Duplication List';
}
/// <summary>
/// Fixed asset reclassification entry flag indicating whether this entry represents an asset reclassification transaction.
/// </summary>
field(5614; "FA Reclassification Entry"; Boolean)
{
AccessByPermission = TableData "Fixed Asset" = R;
Caption = 'FA Reclassification Entry';
}
/// <summary>
/// Fixed asset error entry number linking to FA ledger entry for error correction and audit trail purposes.
/// </summary>
field(5615; "FA Error Entry No."; Integer)
{
BlankZero = true;
Caption = 'FA Error Entry No.';
TableRelation = "FA Ledger Entry";
}
/// <summary>
/// Index entry flag indicating whether this entry represents an indexed transaction for inflation adjustment calculations.
/// </summary>
field(5616; "Index Entry"; Boolean)
{
Caption = 'Index Entry';
}
/// <summary>
/// Source line number tracking the original journal line number for audit trail and transaction traceability.
/// </summary>
field(5617; "Source Line No."; Integer)
{
Caption = 'Source Line No.';
}
/// <summary>
/// Comment field for additional notes and documentation related to the posted journal line transaction.
/// </summary>
field(5618; Comment; Text[250])
{
Caption = 'Comment';
}
/// <summary>
/// Check exported flag indicating whether the check payment has been exported to the bank payment processing system.
/// </summary>
field(5701; "Check Exported"; Boolean)
{
Caption = 'Check Exported';
}
/// <summary>
/// Check transmitted flag indicating whether the check payment has been successfully transmitted to the bank.
/// </summary>
field(5702; "Check Transmitted"; Boolean)
{
Caption = 'Check Transmitted';
}
/// <summary>
/// Non-deductible VAT percentage for tax calculations where only part of the VAT can be deducted per tax regulations.
/// </summary>
field(6200; "Non-Deductible VAT %"; Decimal)
{
AutoFormatType = 0;
Caption = 'Non-Deductible VAT %';
DecimalPlaces = 0 : 5;
}
/// <summary>
/// Non-deductible VAT base amount in transaction currency for calculating non-deductible VAT portions per tax legislation.
/// </summary>
field(6201; "Non-Deductible VAT Base"; Decimal)
{
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 1;
Caption = 'Non-Deductible VAT Base';
}
/// <summary>
/// Non-deductible VAT amount in transaction currency representing the portion of VAT that cannot be deducted.
/// </summary>
field(6202; "Non-Deductible VAT Amount"; Decimal)
{
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 1;
Caption = 'Non-Deductible VAT Amount';
}
/// <summary>
/// Non-deductible VAT base amount in local currency for standardized non-deductible VAT reporting and accounting.
/// </summary>
field(6203; "Non-Deductible VAT Base LCY"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Non-Deductible VAT Base LCY';
}
/// <summary>
/// Non-deductible VAT amount in local currency for consolidated non-deductible VAT reporting and financial analysis.
/// </summary>
field(6204; "Non-Deductible VAT Amount LCY"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Non-Deductible VAT Amount LCY';
}
/// <summary>
/// Non-deductible VAT base amount in additional currency for multi-currency non-deductible VAT tracking and reporting.
/// </summary>
field(6205; "Non-Deductible VAT Base ACY"; Decimal)
{
AutoFormatExpression = GetAdditionalReportingCurrencyCode();
AutoFormatType = 1;
Caption = 'Non-Deductible VAT Base ACY';
}
/// <summary>
/// Non-deductible VAT amount in additional currency for comprehensive multi-currency non-deductible VAT management.
/// </summary>
field(6206; "Non-Deductible VAT Amount ACY"; Decimal)
{
AutoFormatExpression = GetAdditionalReportingCurrencyCode();
AutoFormatType = 1;
Caption = 'Non-Deductible VAT Amount ACY';
}
/// <summary>
/// Non-deductible VAT difference for handling variances in non-deductible VAT calculations and adjustments.
/// </summary>
field(6208; "Non-Deductible VAT Diff."; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = Rec."Currency Code";
Caption = 'Non-Deductible VAT Difference';
}
/// <summary>
/// Account ID for API integration providing GUID-based account identification for external system connectivity.
/// </summary>
field(8001; "Account Id"; Guid)
{
Caption = 'Account Id';
TableRelation = "G/L Account".SystemId;
}
/// <summary>
/// Customer ID for API integration providing GUID-based customer identification for external system connectivity.
/// </summary>
field(8002; "Customer Id"; Guid)
{
Caption = 'Customer Id';
TableRelation = Customer.SystemId;
}
/// <summary>
/// Applies-to invoice ID for API integration providing GUID-based invoice identification for external application matching.
/// </summary>
field(8003; "Applies-to Invoice Id"; Guid)
{
Caption = 'Applies-to Invoice Id';
TableRelation = "Sales Invoice Header".SystemId;
}
/// <summary>
/// Contact graph ID for Microsoft Graph API integration enabling contact synchronization with external systems.
/// </summary>
field(8004; "Contact Graph Id"; Text[250])
{
Caption = 'Contact Graph Id';
}
/// <summary>
/// Last modified date time for API integration tracking when the posted journal line was last updated.
/// </summary>
field(8005; "Last Modified DateTime"; DateTime)
{
Caption = 'Last Modified DateTime';
}
/// <summary>
/// Journal batch ID for API integration providing GUID-based batch identification for external system connectivity.
/// </summary>
field(8006; "Journal Batch Id"; Guid)
{
Caption = 'Journal Batch Id';
TableRelation = "Gen. Journal Batch".SystemId;
}
/// <summary>
/// Payment method ID for API integration providing GUID-based payment method identification for external systems.
/// </summary>
field(8007; "Payment Method Id"; Guid)
{
Caption = 'Payment Method Id';
TableRelation = "Payment Method".SystemId;
}
/// <summary>
/// General ledger register number linking posted entries to specific G/L register for audit trail and batch tracking.
/// </summary>
field(8010; "G/L Register No."; Integer)
{
Caption = 'G/L Register No.';
ToolTip = 'Specifies the number of the general ledger register.';
TableRelation = "G/L Register";
}
/// <summary>
/// Indentation level for hierarchical display of posted journal lines in reports and user interface presentations.
/// </summary>
field(8011; Indentation; Integer)
{
Caption = 'Indentation';
}
}
keys
{
key(Key1; "Line No.")
{
}
key(Key2; "Journal Template Name", "Journal Batch Name", "Line No.")
{
Clustered = true;
}
key(Key3; "G/L Register No.")
{
}
key(Key4; "Document No.", "Posting Date")
{
}
}
fieldgroups
{
fieldgroup(DropDown; "Journal Template Name", "Journal Batch Name", "Line No.")
{
}
fieldgroup(Brick; "Journal Template Name", "Journal Batch Name", "Line No.")
{
}
}
protected var
GeneralLedgerSetup: Record "General Ledger Setup";
GeneralLedgerSetupRead: Boolean;
local procedure GetAdditionalReportingCurrencyCode(): Code[10]
begin
if not GeneralLedgerSetupRead then begin
GeneralLedgerSetup.Get();
GeneralLedgerSetupRead := true;
end;
exit(GeneralLedgerSetup."Additional Reporting Currency")
end;
/// <summary>
/// Creates a posted general journal line record from a general journal line during the posting process.
/// </summary>
/// <param name="GenJournalLine">The source general journal line record to create posted entry from.</param>
/// <param name="GLRegNo">The G/L register number for linking to the posting batch.</param>
/// <param name="FirstLine">Indicates whether this is the first line in the posting batch.</param>
procedure InsertFromGenJournalLine(GenJournalLine: Record "Gen. Journal Line"; GLRegNo: Integer; FirstLine: Boolean)
var
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeInsertFromGenJournalLine(GenJournalLine, IsHandled);
if IsHandled then
exit;
Init();
TransferFields(GenJournalLine);
"Line No." := 0;
"G/L Register No." := GLRegNo;
if not FirstLine then
Indentation := 1;
Insert();
Rec.CopyLinks(GenJournalLine);
OnAfterInsertFromGenJournalLine(GenJournalLine, Rec);
end;
/// <summary>
/// Integration event triggered before creating a posted general journal line record from a general journal line.
/// </summary>
/// <param name="GenJournalLine">The source general journal line record.</param>
/// <param name="IsHandled">Set to true to skip the default insertion logic.</param>
[IntegrationEvent(true, false)]
local procedure OnBeforeInsertFromGenJournalLine(GenJournalLine: Record "Gen. Journal Line"; var IsHandled: Boolean)
begin
end;
/// <summary>
/// Integration event triggered after successfully creating a posted general journal line record from a general journal line.
/// </summary>
/// <param name="GenJournalLine">The source general journal line record that was used for creation.</param>
/// <param name="PostedGenJournalLine">The created posted general journal line record.</param>
[IntegrationEvent(true, false)]
local procedure OnAfterInsertFromGenJournalLine(GenJournalLine: Record "Gen. Journal Line"; var PostedGenJournalLine: Record "Posted Gen. Journal Line")
begin
end;
}