Table 1102 Cost Journal Batch
src/Layers/W1/BaseApp/CostAccounting/Journal/CostJournalBatch.Table.al111 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.CostAccounting.Journal;using Microsoft.CostAccounting.Account;using Microsoft.Foundation.AuditCodes;table 1102 "Cost Journal Batch"{ Caption = 'Cost Journal Batch'; DataClassification = CustomerContent; fields { field(1; "Journal Template Name"; Code[10]) { Caption = 'Journal Template Name'; NotBlank = false; TableRelation = "Cost Journal Template"; } field(2; Name; Code[10]) { Caption = 'Name'; NotBlank = true; } field(3; Description; Text[100]) { Caption = 'Description'; } field(4; "Reason Code"; Code[10]) { Caption = 'Reason Code'; TableRelation = "Reason Code"; } field(9; "Bal. Cost Type No."; Code[20]) { Caption = 'Bal. Cost Type No.'; TableRelation = "Cost Type"; trigger OnValidate() begin if CostType.Get("Bal. Cost Type No.") then begin CostType.TestField(Blocked, false); CostType.TestField(Type, CostType.Type::"Cost Type"); "Bal. Cost Center Code" := CostType."Cost Center Code"; "Bal. Cost Object Code" := CostType."Cost Object Code"; end; end; } field(10; "Bal. Cost Center Code"; Code[20]) { Caption = 'Bal. Cost Center Code'; TableRelation = "Cost Center"; } field(11; "Bal. Cost Object Code"; Code[20]) { Caption = 'Bal. Cost Object Code'; TableRelation = "Cost Object"; } field(12; "Delete after Posting"; Boolean) { Caption = 'Delete after Posting'; InitValue = true; } field(40; "No. of Lines"; Integer) { CalcFormula = count("Cost Journal Line" where("Journal Template Name" = field("Journal Template Name"), "Journal Batch Name" = field(Name))); Caption = 'No. of Lines'; Editable = false; FieldClass = FlowField; ToolTip = 'Specifies the number of lines in this journal batch.'; } } keys { key(Key1; "Journal Template Name", Name) { Clustered = true; } } fieldgroups { } trigger OnDelete() var CostJnlLine: Record "Cost Journal Line"; begin CostJnlLine.SetRange("Journal Template Name", "Journal Template Name"); CostJnlLine.SetRange("Journal Batch Name", Name); CostJnlLine.DeleteAll(); end; trigger OnInsert() var CostJnlTemplate: Record "Cost Journal Template"; begin LockTable(); TestField(Name); CostJnlTemplate.Get("Journal Template Name"); end; var CostType: Record "Cost Type";}