XmlPort 99000751 Mfg. Export Item Data, source in 29
Source29
src/Layers/W1/BaseApp/Manufacturing/Inventory/Item/MfgExportItemData.XmlPort.al2695 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.Inventory.Item;
using Microsoft.Finance.GeneralLedger.Setup;
using Microsoft.Finance.VAT.Setup;
using Microsoft.Foundation.AuditCodes;
using Microsoft.Foundation.Period;
using Microsoft.Foundation.UOM;
using Microsoft.Inventory.Costing;
using Microsoft.Inventory.Ledger;
using Microsoft.Inventory.Location;
using Microsoft.Inventory.Setup;
using Microsoft.Inventory.Tracking;
using Microsoft.Manufacturing.Capacity;
using Microsoft.Manufacturing.Document;
xmlport 99000751 "Mfg. Export Item Data"
{
Caption = 'Export/Import Item Data';
DefaultFieldsValidation = false;
FieldDelimiter = '<~>';
FieldSeparator = '<;>';
Format = VariableText;
TextEncoding = UTF16;
UseRequestPage = true;
Direction = Both;
FormatEvaluate = Xml;
Permissions = tabledata "Item Ledger Entry" = rimd,
tabledata "Item Application Entry" = rimd,
tabledata "Production Order" = rimd,
tabledata "Prod. Order Line" = rimd,
tabledata "Value Entry" = rimd,
tabledata "Item Application Entry History" = rimd,
tabledata "Capacity Ledger Entry" = rimd,
tabledata "Avg. Cost Adjmt. Entry Point" = rimd,
tabledata "Item Tracking Code" = rimd,
tabledata "Post Value Entry to G/L" = rimd,
tabledata "Inventory Period" = rimd,
tabledata "Item Register" = rimd,
tabledata "Inventory Adjmt. Entry (Order)" = rimd;
schema
{
textelement(root)
{
XmlName = 'Root';
tableelement(item; Item)
{
AutoSave = false;
AutoUpdate = false;
RequestFilterFields = "No.";
XmlName = 'Item';
fieldelement(Item_No; Item."No.")
{
}
fieldelement(Item_No2; Item."No. 2")
{
}
fieldelement(Item_BaseUnitofMeasure; Item."Base Unit of Measure")
{
}
fieldelement(Item_PriceUnitConversion; Item."Price Unit Conversion")
{
}
textelement(ItemType)
{
XmlName = 'Item_Type';
}
fieldelement(Item_InventoryPostingGroup; Item."Inventory Posting Group")
{
}
fieldelement(Item_UnitPrice; Item."Unit Price")
{
}
fieldelement(Item_PriceProfitCalculation; Item."Price/Profit Calculation")
{
}
fieldelement(Item_Profit; Item."Profit %")
{
}
fieldelement(Item_CostingMethod; Item."Costing Method")
{
}
fieldelement(Item_UnitCost; Item."Unit Cost")
{
}
fieldelement(Item_StandardCost; Item."Standard Cost")
{
}
fieldelement(Item_LastDirectCost; Item."Last Direct Cost")
{
}
fieldelement(Item_IndirectCost; Item."Indirect Cost %")
{
}
fieldelement(Item_CostisAdjusted; Item."Cost is Adjusted")
{
}
fieldelement(Item_AllowOnlineAdjustment; Item."Allow Online Adjustment")
{
}
fieldelement(Item_VendorNo; Item."Vendor No.")
{
}
fieldelement(Item_VendorItemNo; Item."Vendor Item No.")
{
}
fieldelement(Item_LeadTimeCalculation; Item."Lead Time Calculation")
{
}
fieldelement(Item_ReorderPoint; Item."Reorder Point")
{
}
fieldelement(Item_MaximumInventory; Item."Maximum Inventory")
{
}
fieldelement(Item_ReorderQuantity; Item."Reorder Quantity")
{
}
fieldelement(Item_UnitListPrice; Item."Unit List Price")
{
}
fieldelement(Item_DutyDue; Item."Duty Due %")
{
}
fieldelement(Item_DutyCode; Item."Duty Code")
{
}
fieldelement(Item_GrossWeight; Item."Gross Weight")
{
}
fieldelement(Item_NetWeight; Item."Net Weight")
{
}
fieldelement(Item_UnitsperParcel; Item."Units per Parcel")
{
}
fieldelement(Item_UnitVolume; Item."Unit Volume")
{
}
fieldelement(Item_Durability; Item.Durability)
{
}
fieldelement(Item_FreightType; Item."Freight Type")
{
}
fieldelement(Item_TariffNo; Item."Tariff No.")
{
}
fieldelement(Item_DutyUnitConversion; Item."Duty Unit Conversion")
{
}
fieldelement(Item_CountryRegionPurchasedCode; Item."Country/Region Purchased Code")
{
}
fieldelement(Item_BudgetQuantity; Item."Budget Quantity")
{
}
fieldelement(Item_BudgetedAmount; Item."Budgeted Amount")
{
}
fieldelement(Item_BudgetProfit; Item."Budget Profit")
{
}
fieldelement(Item_Blocked; Item.Blocked)
{
}
fieldelement(Item_SalesBlocked; Item."Sales Blocked")
{
}
fieldelement(Item_ServiceBlocked; Item."Service Blocked")
{
}
fieldelement(Item_PurchasingBlocked; Item."Purchasing Blocked")
{
}
fieldelement(Item_LastDateModified; Item."Last Date Modified")
{
}
fieldelement(Item_PriceIncludesVAT; Item."Price Includes VAT")
{
}
fieldelement(Item_VATBusPostingGrPrice; Item."VAT Bus. Posting Gr. (Price)")
{
}
fieldelement(Item_GenProdPostingGroup; Item."Gen. Prod. Posting Group")
{
}
fieldelement(Item_CountryRegionofOriginCode; Item."Country/Region of Origin Code")
{
}
fieldelement(Item_AutomaticExtTexts; Item."Automatic Ext. Texts")
{
}
fieldelement(Item_NoSeries; Item."No. Series")
{
}
fieldelement(Item_TaxGroupCode; Item."Tax Group Code")
{
}
fieldelement(Item_VATProdPostingGroup; Item."VAT Prod. Posting Group")
{
}
fieldelement(Item_Reserve; Item.Reserve)
{
}
fieldelement(Item_GlobalDimension1Code; Item."Global Dimension 1 Code")
{
}
fieldelement(Item_GlobalDimension2Code; Item."Global Dimension 2 Code")
{
}
fieldelement(Item_AssemblyPolicy; Item."Assembly Policy")
{
}
fieldelement(Item_LowLevelCode; Item."Low-Level Code")
{
}
fieldelement(Item_LotSize; Item."Lot Size")
{
}
fieldelement(Item_SerialNos; Item."Serial Nos.")
{
}
fieldelement(Item_LastUnitCostCalcDate; Item."Last Unit Cost Calc. Date")
{
}
fieldelement(Item_RolledupMaterialCost; Item."Rolled-up Material Cost")
{
}
fieldelement(Item_RolledupCapacityCost; Item."Rolled-up Capacity Cost")
{
}
fieldelement(Item_Scrap; Item."Scrap %")
{
}
fieldelement(Item_InventoryValueZero; Item."Inventory Value Zero")
{
}
fieldelement(Item_DiscreteOrderQuantity; Item."Discrete Order Quantity")
{
}
fieldelement(Item_MinimumOrderQuantity; Item."Minimum Order Quantity")
{
}
fieldelement(Item_MaximumOrderQuantity; Item."Maximum Order Quantity")
{
}
fieldelement(Item_SafetyStockQuantity; Item."Safety Stock Quantity")
{
}
fieldelement(Item_OrderMultiple; Item."Order Multiple")
{
}
fieldelement(Item_SafetyLeadTime; Item."Safety Lead Time")
{
}
fieldelement(Item_FlushingMethod; Item."Flushing Method")
{
}
fieldelement(Item_ReplenishmentSystem; Item."Replenishment System")
{
}
fieldelement(Item_RoundingPrecision; Item."Rounding Precision")
{
}
fieldelement(Item_SalesUnitofMeasure; Item."Sales Unit of Measure")
{
}
fieldelement(Item_PurchUnitofMeasure; Item."Purch. Unit of Measure")
{
}
fieldelement(Item_TimeBucket; Item."Time Bucket")
{
}
fieldelement(Item_LotAccumulationPeriod; Item."Lot Accumulation Period")
{
}
fieldelement(Item_ReschedulingPeriod; Item."Rescheduling Period")
{
}
fieldelement(Item_DampenerPeriod; Item."Dampener Period")
{
}
fieldelement(Item_DampenerQuantity; Item."Dampener Quantity")
{
}
fieldelement(Item_OverflowLevel; Item."Overflow Level")
{
}
fieldelement(Item_ReorderingPolicy; Item."Reordering Policy")
{
}
fieldelement(Item_IncludeInventory; Item."Include Inventory")
{
}
fieldelement(Item_ManufacturingPolicy; Item."Manufacturing Policy")
{
}
fieldelement(Item_ManufacturerCode; Item."Manufacturer Code")
{
}
fieldelement(Item_ItemCategoryCode; Item."Item Category Code")
{
}
fieldelement(Item_CreatedFromNonstockItem; Item."Created From Nonstock Item")
{
}
fieldelement(Item_ItemTrackingCode; Item."Item Tracking Code")
{
}
fieldelement(Item_LotNos; Item."Lot Nos.")
{
}
fieldelement(Item_ExpirationCalculation; Item."Expiration Calculation")
{
}
fieldelement(Item_SpecialEquipmentCode; Item."Special Equipment Code")
{
}
fieldelement(Item_PutawayTemplateCode; Item."Put-away Template Code")
{
}
fieldelement(Item_PutawayUnitofMeasureCode; Item."Put-away Unit of Measure Code")
{
}
fieldelement(Item_PhysInvtCountingPeriodCode; Item."Phys Invt Counting Period Code")
{
}
fieldelement(Item_LastCountingPeriodUpdate; Item."Last Counting Period Update")
{
}
fieldelement(Item_UseCrossDocking; Item."Use Cross-Docking")
{
}
fieldelement(Item_RoutingNo; Item."Routing No.")
{
}
fieldelement(Item_ProductionBOMNo; Item."Production BOM No.")
{
}
fieldelement(Item_SingleLevelMaterialCost; Item."Single-Level Material Cost")
{
}
fieldelement(Item_SingleLevelCapacityCost; Item."Single-Level Capacity Cost")
{
}
fieldelement(Item_SingleLevelSubcontrdCost; Item."Single-Level Subcontrd. Cost")
{
}
fieldelement(Item_SingleLevelCapOvhdCost; Item."Single-Level Cap. Ovhd Cost")
{
}
fieldelement(Item_SingleLevelMfgOvhdCost; Item."Single-Level Mfg. Ovhd Cost")
{
}
fieldelement(Item_OverheadRate; Item."Overhead Rate")
{
}
fieldelement(Item_OrderTrackingPolicy; Item."Order Tracking Policy")
{
}
fieldelement(Item_ProdForecastQuantityBase; Item."Prod. Forecast Quantity (Base)")
{
}
fieldelement(Item_ProductionForecastName; Item."Production Forecast Name")
{
}
fieldelement(Item_ComponentForecast; Item."Component Forecast")
{
}
fieldelement(Item_Critical; Item.Critical)
{
}
fieldelement(Item_CommonItemNo; Item."Common Item No.")
{
}
fieldelement(Item_VariantMandatoryIfExists; Item."Variant Mandatory if Exists")
{
}
trigger OnAfterGetRecord()
begin
Item.Description := CopyStr(Item.Description, 1, MaxStrLen(Item.Description));
Item."Search Description" := CopyStr(Item."Search Description", 1, MaxStrLen(Item."Search Description"));
if ItemTypeFieldExists then begin
ItemRecRef.GetTable(Item);
TypeFieldRef := ItemRecRef.Field(10);
ItemTypeInt := TypeFieldRef.Value();
ItemType := Format(ItemTypeInt);
Clear(ItemRecRef);
end;
end;
trigger OnPreXmlItem()
begin
if not currXMLport.ImportFile() then begin
if Item.Count <> 1 then
Error(SingleItemExportOnlyErr);
Item.FindFirst();
Item.Reset();
Item.SetRecFilter();
FilteredItem.Copy(Item);
end;
end;
trigger OnAfterInsertRecord()
begin
if not Item.Insert() then
Item.Modify();
end;
trigger OnBeforeInsertRecord()
begin
if currXMLport.ImportFile() then begin
Item.Reset();
Item.SetRecFilter();
FilteredItem.Copy(Item);
end;
if ItemTypeFieldExists and (ItemType <> '') then begin
ItemRecRef.GetTable(Item);
TypeFieldRef := ItemRecRef.Field(10);
Evaluate(ItemTypeInt, ItemType);
TypeFieldRef.Value := ItemTypeInt;
ItemRecRef.SetTable(Item);
Clear(ItemRecRef);
end;
end;
}
tableelement(unitofmeasure; "Unit of Measure")
{
AutoSave = true;
AutoUpdate = true;
XmlName = 'UnitOfMeasure';
SourceTableView = sorting(Code);
fieldelement(UnitOfMeasure_Code; UnitOfMeasure.Code)
{
}
fieldelement(UnitOfMeasure_Description; UnitOfMeasure.Description)
{
}
trigger OnAfterGetRecord()
begin
if not ItemUnitOfMeasure.Get(FilteredItem."No.", UnitOfMeasure.Code) then
currXMLport.Skip();
end;
}
tableelement(itemunitofmeasure; "Item Unit of Measure")
{
AutoSave = true;
AutoUpdate = true;
XmlName = 'ItemUnitOfMeasure';
SourceTableView = sorting("Item No.", Code);
fieldelement(ItemUnitOfMeasure_ItemNo; ItemUnitOfMeasure."Item No.")
{
}
fieldelement(ItemUnitOfMeasure_Code; ItemUnitOfMeasure.Code)
{
}
fieldelement(ItemUnitOfMeasure_QtyperUnitofMeasure; ItemUnitOfMeasure."Qty. per Unit of Measure")
{
}
fieldelement(ItemUnitOfMeasure_Length; ItemUnitOfMeasure.Length)
{
}
fieldelement(ItemUnitOfMeasure_Width; ItemUnitOfMeasure.Width)
{
}
fieldelement(ItemUnitOfMeasure_Height; ItemUnitOfMeasure.Height)
{
}
fieldelement(ItemUnitOfMeasure_Cubage; ItemUnitOfMeasure.Cubage)
{
}
fieldelement(ItemUnitOfMeasure_Weight; ItemUnitOfMeasure.Weight)
{
}
trigger OnPreXmlItem()
begin
ItemUnitOfMeasure.SetRange("Item No.", FilteredItem."No.");
end;
}
tableelement(genprodpostinggroup; "Gen. Product Posting Group")
{
AutoSave = true;
AutoUpdate = true;
XmlName = 'GenProdPostingGroup';
SourceTableView = sorting(Code);
fieldelement(GenProdPostingGroup_Code; GenProdPostingGroup.Code)
{
}
fieldelement(GenProdPostingGroup_Description; GenProdPostingGroup.Description)
{
}
fieldelement(GenProdPostingGroup_DefVATProdPostingGroup; GenProdPostingGroup."Def. VAT Prod. Posting Group")
{
}
fieldelement(GenProdPostingGroup_AutoInsertDefault; GenProdPostingGroup."Auto Insert Default")
{
}
}
tableelement(genpostingsetup; "General Posting Setup")
{
AutoSave = true;
AutoUpdate = true;
XmlName = 'GenPostingSetup';
SourceTableView = sorting("Gen. Bus. Posting Group", "Gen. Prod. Posting Group");
fieldelement(GenPostingSetup_GenBusPostingGroup; GenPostingSetup."Gen. Bus. Posting Group")
{
}
fieldelement(GenPostingSetup_GenProdPostingGroup; GenPostingSetup."Gen. Prod. Posting Group")
{
}
}
tableelement(genbuspostinggroup; "Gen. Business Posting Group")
{
AutoSave = true;
AutoUpdate = true;
XmlName = 'GenBusPostingGroup';
SourceTableView = sorting(Code);
fieldelement(GenBusPostingGroup_Code; GenBusPostingGroup.Code)
{
}
fieldelement(GenBusPostingGroup_Description; GenBusPostingGroup.Description)
{
}
fieldelement(GenBusPostingGroup_DefVATBusPostingGroup; GenBusPostingGroup."Def. VAT Bus. Posting Group")
{
}
fieldelement(GenBusPostingGroup_AutoInsertDefault; GenBusPostingGroup."Auto Insert Default")
{
}
}
tableelement(vatprodpostinggroup; "VAT Product Posting Group")
{
AutoSave = true;
AutoUpdate = true;
XmlName = 'VatProdPostingGroup';
SourceTableView = sorting(Code);
fieldelement(VatProdPostingGroup_Code; VATProdPostingGroup.Code)
{
}
fieldelement(VatProdPostingGroup_Description; VATProdPostingGroup.Description)
{
}
}
tableelement(vatpostingsetup; "VAT Posting Setup")
{
AutoSave = true;
AutoUpdate = true;
XmlName = 'VATPostingSetup';
SourceTableView = sorting("VAT Bus. Posting Group", "VAT Prod. Posting Group");
fieldelement(VATPostingSetup_VATBusPostingGroup; VATPostingSetup."VAT Bus. Posting Group")
{
}
fieldelement(VATPostingSetup_VATProdPostingGroup; VATPostingSetup."VAT Prod. Posting Group")
{
}
}
tableelement(inventorypostinggroup; "Inventory Posting Group")
{
AutoSave = true;
AutoUpdate = true;
XmlName = 'InventoryPostingGroup';
SourceTableView = sorting(Code);
fieldelement(InventoryPostingGroup_Code; InventoryPostingGroup.Code)
{
}
fieldelement(InventoryPostingGroup_Description; InventoryPostingGroup.Description)
{
}
}
tableelement(inventorypostingsetup; "Inventory Posting Setup")
{
AutoSave = true;
AutoUpdate = true;
XmlName = 'InventoryPostingSetup';
SourceTableView = sorting("Location Code", "Invt. Posting Group Code");
fieldelement(InventoryPostingSetup_LocationCode; InventoryPostingSetup."Location Code")
{
}
fieldelement(InventoryPostingSetup_InvtPostingGroupCode; InventoryPostingSetup."Invt. Posting Group Code")
{
}
trigger OnAfterGetRecord()
var
ItemLedgEntry2: Record "Item Ledger Entry";
begin
ItemLedgEntry2.SetCurrentKey("Item No.");
ItemLedgEntry2.SetRange("Item No.", FilteredItem."No.");
ItemLedgEntry2.SetRange("Location Code", InventoryPostingSetup."Location Code");
if ItemLedgEntry2.IsEmpty() then
currXMLport.Skip();
end;
}
tableelement(itemledgentry; "Item Ledger Entry")
{
AutoSave = true;
AutoUpdate = true;
XmlName = 'ItemLedgEntry';
SourceTableView = sorting("Item No.");
fieldelement(ItemLedgEntry_EntryNo; ItemLedgEntry."Entry No.")
{
}
fieldelement(ItemLedgEntry_ItemNo; ItemLedgEntry."Item No.")
{
}
fieldelement(ItemLedgEntry_PostingDate; ItemLedgEntry."Posting Date")
{
}
fieldelement(ItemLedgEntry_EntryType; ItemLedgEntry."Entry Type")
{
}
fieldelement(ItemLedgEntry_SourceNo; ItemLedgEntry."Source No.")
{
}
fieldelement(ItemLedgEntry_DocumentNo; ItemLedgEntry."Document No.")
{
}
fieldelement(ItemLedgEntry_Description; ItemLedgEntry.Description)
{
}
fieldelement(ItemLedgEntry_LocationCode; ItemLedgEntry."Location Code")
{
}
fieldelement(ItemLedgEntry_Quantity; ItemLedgEntry.Quantity)
{
}
fieldelement(ItemLedgEntry_RemainingQuantity; ItemLedgEntry."Remaining Quantity")
{
}
fieldelement(ItemLedgEntry_InvoicedQuantity; ItemLedgEntry."Invoiced Quantity")
{
}
fieldelement(ItemLedgEntry_AppliestoEntry; ItemLedgEntry."Applies-to Entry")
{
}
fieldelement(ItemLedgEntry_Open; ItemLedgEntry.Open)
{
}
fieldelement(ItemLedgEntry_GlobalDimension1Code; ItemLedgEntry."Global Dimension 1 Code")
{
}
fieldelement(ItemLedgEntry_GlobalDimension2Code; ItemLedgEntry."Global Dimension 2 Code")
{
}
fieldelement(ItemLedgEntry_Positive; ItemLedgEntry.Positive)
{
}
fieldelement(ItemLedgEntry_SourceType; ItemLedgEntry."Source Type")
{
}
fieldelement(ItemLedgEntry_DropShipment; ItemLedgEntry."Drop Shipment")
{
}
fieldelement(ItemLedgEntry_TransactionType; ItemLedgEntry."Transaction Type")
{
}
fieldelement(ItemLedgEntry_TransportMethod; ItemLedgEntry."Transport Method")
{
}
fieldelement(ItemLedgEntry_CountryRegionCode; ItemLedgEntry."Country/Region Code")
{
}
fieldelement(ItemLedgEntry_EntryExitPoint; ItemLedgEntry."Entry/Exit Point")
{
}
fieldelement(ItemLedgEntry_DocumentDate; ItemLedgEntry."Document Date")
{
}
fieldelement(ItemLedgEntry_ExternalDocumentNo; ItemLedgEntry."External Document No.")
{
}
fieldelement(ItemLedgEntry_Area; ItemLedgEntry."Area")
{
}
fieldelement(ItemLedgEntry_TransactionSpecification; ItemLedgEntry."Transaction Specification")
{
}
fieldelement(ItemLedgEntry_NoSeries; ItemLedgEntry."No. Series")
{
}
fieldelement(ItemLedgEntry_ReservedQuantity; ItemLedgEntry."Reserved Quantity")
{
}
fieldelement(ItemLedgEntry_DocumentType; ItemLedgEntry."Document Type")
{
}
fieldelement(ItemLedgEntry_DocumentLineNo; ItemLedgEntry."Document Line No.")
{
}
fieldelement(ItemLedgEntry_OrderType; ItemLedgEntry."Order Type")
{
}
fieldelement(ItemLedgEntry_OrderNo; ItemLedgEntry."Order No.")
{
}
fieldelement(ItemLedgEntry_OrderLineNo; ItemLedgEntry."Order Line No.")
{
}
fieldelement(ItemLedgEntry_AssembleToOrder; ItemLedgEntry."Assemble to Order")
{
}
fieldelement(ItemLedgEntry_VariantCode; ItemLedgEntry."Variant Code")
{
}
fieldelement(ItemLedgEntry_QtyperUnitofMeasure; ItemLedgEntry."Qty. per Unit of Measure")
{
}
fieldelement(ItemLedgEntry_UnitofMeasureCode; ItemLedgEntry."Unit of Measure Code")
{
}
fieldelement(ItemLedgEntry_DerivedfromBlanketOrder; ItemLedgEntry."Derived from Blanket Order")
{
}
fieldelement(ItemLedgEntry_ItemReferenceNo; ItemLedgEntry."Item Reference No.")
{
}
fieldelement(ItemLedgEntry_OriginallyOrderedNo; ItemLedgEntry."Originally Ordered No.")
{
}
fieldelement(ItemLedgEntry_OriginallyOrderedVarCode; ItemLedgEntry."Originally Ordered Var. Code")
{
}
fieldelement(ItemLedgEntry_OutofStockSubstitution; ItemLedgEntry."Out-of-Stock Substitution")
{
}
fieldelement(ItemLedgEntry_ItemCategoryCode; ItemLedgEntry."Item Category Code")
{
}
fieldelement(ItemLedgEntry_Nonstock; ItemLedgEntry.Nonstock)
{
}
fieldelement(ItemLedgEntry_PurchasingCode; ItemLedgEntry."Purchasing Code")
{
}
fieldelement(ItemLedgEntry_CompletelyInvoiced; ItemLedgEntry."Completely Invoiced")
{
}
fieldelement(ItemLedgEntry_LastInvoiceDate; ItemLedgEntry."Last Invoice Date")
{
}
fieldelement(ItemLedgEntry_AppliedEntrytoAdjust; ItemLedgEntry."Applied Entry to Adjust")
{
}
fieldelement(ItemLedgEntry_Correction; ItemLedgEntry.Correction)
{
}
fieldelement(ItemLedgEntry_ProdOrderCompLineNo; ItemLedgEntry."Prod. Order Comp. Line No.")
{
}
fieldelement(ItemLedgEntry_SerialNo; ItemLedgEntry."Serial No.")
{
}
fieldelement(ItemLedgEntry_LotNo; ItemLedgEntry."Lot No.")
{
}
fieldelement(ItemLedgEntry_WarrantyDate; ItemLedgEntry."Warranty Date")
{
}
fieldelement(ItemLedgEntry_ExpirationDate; ItemLedgEntry."Expiration Date")
{
}
fieldelement(ItemLedgEntry_ReturnReasonCode; ItemLedgEntry."Return Reason Code")
{
}
fieldelement(ItemLedgEntry_DocumentType; ItemLedgEntry."Document Type")
{
}
fieldelement(ItemLedgEntry_DocumentLineNo; ItemLedgEntry."Document Line No.")
{
}
trigger OnAfterGetRecord()
begin
CollectItemApplnEntry(ItemLedgEntry."Entry No.");
CollectItemApplnEntryHist(ItemLedgEntry."Entry No.");
if ItemLedgEntry."Order Type" = ItemLedgEntry."Order Type"::Production then
CollectProdOrder(ItemLedgEntry."Order No.");
end;
trigger OnPreXmlItem()
begin
ItemLedgEntry.SetRange("Item No.", FilteredItem."No.");
end;
trigger OnBeforeInsertRecord()
var
ItemLedgEntry2: Record "Item Ledger Entry";
begin
if ItemLedgEntry2.Get(ItemLedgEntry."Entry No.") and (ItemLedgEntry2."Item No." <> ItemLedgEntry."Item No.") then
Error(ItemLedgEntryNoExistErr, ItemLedgEntry."Entry No.");
end;
}
tableelement(tempitemapplnentry; "Item Application Entry")
{
AutoSave = true;
AutoUpdate = true;
XmlName = 'ItemApplnEntry';
SourceTableView = sorting("Entry No.");
UseTemporary = true;
fieldelement(ItemApplnEntry_EntryNo; TempItemApplnEntry."Entry No.")
{
}
fieldelement(ItemApplnEntry_ItemLedgerEntryNo; TempItemApplnEntry."Item Ledger Entry No.")
{
}
fieldelement(ItemApplnEntry_InboundItemEntryNo; TempItemApplnEntry."Inbound Item Entry No.")
{
}
fieldelement(ItemApplnEntry_OutboundItemEntryNo; TempItemApplnEntry."Outbound Item Entry No.")
{
}
fieldelement(ItemApplnEntry_Quantity; TempItemApplnEntry.Quantity)
{
}
fieldelement(ItemApplnEntry_PostingDate; TempItemApplnEntry."Posting Date")
{
}
fieldelement(ItemApplnEntry_TransferredFromEntryNo; TempItemApplnEntry."Transferred-from Entry No.")
{
}
fieldelement(ItemApplnEntry_CreationDate; TempItemApplnEntry."Creation Date")
{
}
fieldelement(ItemApplnEntry_LastModifiedDate; TempItemApplnEntry."Last Modified Date")
{
}
fieldelement(ItemApplnEntry_CostApplication; TempItemApplnEntry."Cost Application")
{
}
fieldelement(ItemApplnEntry_OutputCompletelyInvdDate; TempItemApplnEntry."Output Completely Invd. Date")
{
}
fieldelement(ItemApplnEntry_OutputEntryIsUpdated; TempItemApplnEntry."Outbound Entry is Updated")
{
}
trigger OnAfterInsertRecord()
var
ItemApplnEntry2: Record "Item Application Entry";
begin
ItemApplnEntry2 := TempItemApplnEntry;
if not ItemApplnEntry2.Insert() then
ItemApplnEntry2.Modify();
end;
}
tableelement(valueentry; "Value Entry")
{
AutoSave = true;
AutoUpdate = true;
XmlName = 'ValueEntry';
SourceTableView = sorting("Item No.");
fieldelement(ValueEntry_EntryNo; ValueEntry."Entry No.")
{
}
fieldelement(ValueEntry_ItemNo; ValueEntry."Item No.")
{
}
fieldelement(ValueEntry_PostingDate; ValueEntry."Posting Date")
{
}
fieldelement(ValueEntry_ItemLedgerEntryType; ValueEntry."Item Ledger Entry Type")
{
}
fieldelement(ValueEntry_SourceNo; ValueEntry."Source No.")
{
}
fieldelement(ValueEntry_DocumentNo; ValueEntry."Document No.")
{
}
fieldelement(ValueEntry_Description; ValueEntry.Description)
{
}
fieldelement(ValueEntry_LocationCode; ValueEntry."Location Code")
{
}
fieldelement(ValueEntry_InventoryPostingGroup; ValueEntry."Inventory Posting Group")
{
}
fieldelement(ValueEntry_SourcePostingGroup; ValueEntry."Source Posting Group")
{
}
fieldelement(ValueEntry_ItemLedgerEntryNo; ValueEntry."Item Ledger Entry No.")
{
}
fieldelement(ValueEntry_ValuedQuantity; ValueEntry."Valued Quantity")
{
}
fieldelement(ValueEntry_ItemLedgerEntryQuantity; ValueEntry."Item Ledger Entry Quantity")
{
}
fieldelement(ValueEntry_InvoicedQuantity; ValueEntry."Invoiced Quantity")
{
}
fieldelement(ValueEntry_CostperUnit; ValueEntry."Cost per Unit")
{
}
fieldelement(ValueEntry_SalesAmountActual; ValueEntry."Sales Amount (Actual)")
{
}
fieldelement(ValueEntry_DiscountAmount; ValueEntry."Discount Amount")
{
}
fieldelement(ValueEntry_SourceCode; ValueEntry."Source Code")
{
}
fieldelement(ValueEntry_AppliestoEntry; ValueEntry."Applies-to Entry")
{
}
fieldelement(ValueEntry_GlobalDimension1Code; ValueEntry."Global Dimension 1 Code")
{
}
fieldelement(ValueEntry_GlobalDimension2Code; ValueEntry."Global Dimension 2 Code")
{
}
fieldelement(ValueEntry_SourceType; ValueEntry."Source Type")
{
}
fieldelement(ValueEntry_CostAmountActual; ValueEntry."Cost Amount (Actual)")
{
}
fieldelement(ValueEntry_CostPostedtoGL; ValueEntry."Cost Posted to G/L")
{
}
fieldelement(ValueEntry_ReasonCode; ValueEntry."Reason Code")
{
}
fieldelement(ValueEntry_DropShipment; ValueEntry."Drop Shipment")
{
}
fieldelement(ValueEntry_JournalBatchName; ValueEntry."Journal Batch Name")
{
}
fieldelement(ValueEntry_GenBusPostingGroup; ValueEntry."Gen. Bus. Posting Group")
{
}
fieldelement(ValueEntry_GenProdPostingGroup; ValueEntry."Gen. Prod. Posting Group")
{
}
fieldelement(ValueEntry_DocumentDate; ValueEntry."Document Date")
{
}
fieldelement(ValueEntry_ExternalDocumentNo; ValueEntry."External Document No.")
{
}
fieldelement(ValueEntry_CostAmountActualACY; ValueEntry."Cost Amount (Actual) (ACY)")
{
}
fieldelement(ValueEntry_CostPostedtoGLACY; ValueEntry."Cost Posted to G/L (ACY)")
{
}
fieldelement(ValueEntry_CostperUnitACY; ValueEntry."Cost per Unit (ACY)")
{
}
fieldelement(ValueEntry_DocumentType; ValueEntry."Document Type")
{
}
fieldelement(ValueEntry_DocumentLineNo; ValueEntry."Document Line No.")
{
}
fieldelement(ValueEntry_OrderType; ValueEntry."Order Type")
{
}
fieldelement(ValueEntry_OrderNo; ValueEntry."Order No.")
{
}
fieldelement(ValueEntry_OrderLineNo; ValueEntry."Order Line No.")
{
}
fieldelement(ValueEntry_ExpectedCost; ValueEntry."Expected Cost")
{
}
fieldelement(ValueEntry_ItemChargeNo; ValueEntry."Item Charge No.")
{
}
fieldelement(ValueEntry_ValuedByAverageCost; ValueEntry."Valued By Average Cost")
{
}
fieldelement(ValueEntry_PartialRevaluation; ValueEntry."Partial Revaluation")
{
}
fieldelement(ValueEntry_Inventoriable; ValueEntry.Inventoriable)
{
}
fieldelement(ValueEntry_ValuationDate; ValueEntry."Valuation Date")
{
}
fieldelement(ValueEntry_EntryType; ValueEntry."Entry Type")
{
}
fieldelement(ValueEntry_VarianceType; ValueEntry."Variance Type")
{
}
fieldelement(ValueEntry_PurchaseAmountActual; ValueEntry."Purchase Amount (Actual)")
{
}
fieldelement(ValueEntry_PurchaseAmountExpected; ValueEntry."Purchase Amount (Expected)")
{
}
fieldelement(ValueEntry_SalesAmountExpected; ValueEntry."Sales Amount (Expected)")
{
}
fieldelement(ValueEntry_CostAmountExpected; ValueEntry."Cost Amount (Expected)")
{
}
fieldelement(ValueEntry_CostAmountNonInvtbl; ValueEntry."Cost Amount (Non-Invtbl.)")
{
}
fieldelement(ValueEntry_CostAmountExpectedACY; ValueEntry."Cost Amount (Expected) (ACY)")
{
}
fieldelement(ValueEntry_CostAmountNonInvtblACY; ValueEntry."Cost Amount (Non-Invtbl.)(ACY)")
{
}
fieldelement(ValueEntry_ExpectedCostPostedtoGL; ValueEntry."Expected Cost Posted to G/L")
{
}
fieldelement(ValueEntry_ExpCostPostedtoGLACY; ValueEntry."Exp. Cost Posted to G/L (ACY)")
{
}
fieldelement(ValueEntry_VariantCode; ValueEntry."Variant Code")
{
}
fieldelement(ValueEntry_Adjustment; ValueEntry.Adjustment)
{
}
fieldelement(ValueEntry_CapacityLedgerEntryNo; ValueEntry."Capacity Ledger Entry No.")
{
}
fieldelement(ValueEntry_Type; ValueEntry.Type)
{
trigger OnAfterAssignField()
begin
if ValueEntry.Type = ValueEntry.Type::"Work Center" then
if not (ValueEntry."Item Ledger Entry Type" in [ValueEntry."Item Ledger Entry Type"::Output,
ValueEntry."Item Ledger Entry Type"::" "])
then
ValueEntry.Type := ValueEntry.Type::" ";
end;
}
fieldelement(ValueEntry_No; ValueEntry."No.")
{
}
fieldelement(ValueEntry_ReturnReasonCode; ValueEntry."Return Reason Code")
{
}
fieldelement(ValueEntry_DocumentType; ValueEntry."Document Type")
{
}
fieldelement(ValueEntry_DocumentLineNo; ValueEntry."Document Line No.")
{
}
fieldelement(ValueEntry_CapacityLedgerEntryNo; ValueEntry."Capacity Ledger Entry No.")
{
}
trigger OnPreXmlItem()
begin
ValueEntry.SetRange("Item No.", FilteredItem."No.");
end;
}
tableelement(location; Location)
{
AutoSave = true;
AutoUpdate = true;
MinOccurs = Zero;
XmlName = 'Location';
SourceTableView = sorting(Code);
fieldelement(Location_Code; Location.Code)
{
}
fieldelement(Location_Name; Location.Name)
{
}
fieldelement(Location_CountryRegionCode; Location."Country/Region Code")
{
}
fieldelement(Location_UseAsInTransit; Location."Use As In-Transit")
{
}
fieldelement(Location_RequirePutaway; Location."Require Put-away")
{
}
fieldelement(Location_RequirePick; Location."Require Pick")
{
}
fieldelement(Location_CrossDockDueDateCalc; Location."Cross-Dock Due Date Calc.")
{
}
fieldelement(Location_UseCrossDocking; Location."Use Cross-Docking")
{
}
fieldelement(Location_RequireReceive; Location."Require Receive")
{
}
fieldelement(Location_RequireShipment; Location."Require Shipment")
{
}
fieldelement(Location_BinMandatory; Location."Bin Mandatory")
{
}
fieldelement(Location_DirectedPutawayandPick; Location."Directed Put-away and Pick")
{
}
fieldelement(Location_DefaultBinSelection; Location."Default Bin Selection")
{
}
fieldelement(Location_OutboundWhseHandlingTime; Location."Outbound Whse. Handling Time")
{
}
fieldelement(Location_InboundWhseHandlingTime; Location."Inbound Whse. Handling Time")
{
}
trigger OnAfterGetRecord()
var
ItemLedgEntry2: Record "Item Ledger Entry";
begin
ItemLedgEntry2.SetCurrentKey("Item No.");
ItemLedgEntry2.SetRange("Item No.", FilteredItem."No.");
ItemLedgEntry2.SetRange("Location Code", Location.Code);
if ItemLedgEntry2.IsEmpty() then
currXMLport.Skip();
end;
}
tableelement(itemvariant; "Item Variant")
{
AutoSave = true;
AutoUpdate = true;
MinOccurs = Zero;
XmlName = 'ItemVariant';
SourceTableView = sorting("Item No.", Code);
fieldelement(ItemVariant_Code; ItemVariant.Code)
{
}
fieldelement(ItemVariant_ItemNo; ItemVariant."Item No.")
{
}
fieldelement(ItemVariant_Description; ItemVariant.Description)
{
}
fieldelement(ItemVariant_Blocked; ItemVariant.Blocked)
{
}
fieldelement(ItemVariant_SalesBlocked; ItemVariant."Sales Blocked")
{
}
fieldelement(ItemVariant_ServiceBlocked; ItemVariant."Service Blocked")
{
}
fieldelement(ItemVariant_PurchasingBlocked; ItemVariant."Purchasing Blocked")
{
}
trigger OnPreXmlItem()
begin
ItemVariant.SetRange("Item No.", FilteredItem."No.");
end;
}
tableelement(avgcostadjmtentrypoint; "Avg. Cost Adjmt. Entry Point")
{
AutoSave = false;
AutoUpdate = false;
MinOccurs = Zero;
XmlName = 'AvgCostAdjmtEntryPoint';
SourceTableView = sorting("Item No.");
fieldelement(AvgCostAdjmtEntryPoint_ItemNo; AvgCostAdjmtEntryPoint."Item No.")
{
}
fieldelement(AvgCostAdjmtEntryPoint_VariantCode; AvgCostAdjmtEntryPoint."Variant Code")
{
}
fieldelement(AvgCostAdjmtEntryPoint_LocationCode; AvgCostAdjmtEntryPoint."Location Code")
{
}
fieldelement(AvgCostAdjmtEntryPoint_ValuationDate; AvgCostAdjmtEntryPoint."Valuation Date")
{
}
fieldelement(AvgCostAdjmtEntryPoint_CostIsAdjusted; AvgCostAdjmtEntryPoint."Cost Is Adjusted")
{
}
trigger OnPreXmlItem()
begin
AvgCostAdjmtEntryPoint.SetRange("Item No.", FilteredItem."No.");
end;
trigger OnBeforeInsertRecord()
begin
if not AvgCostAdjmtEntryPoint.Insert() then
AvgCostAdjmtEntryPoint.Modify();
end;
}
tableelement(itemtrackingcode; "Item Tracking Code")
{
AutoSave = true;
AutoUpdate = true;
MinOccurs = Zero;
XmlName = 'ItemTrackingCode';
SourceTableView = sorting(Code);
fieldelement(ItemTrackingCode_Code; ItemTrackingCode.Code)
{
}
fieldelement(ItemTrackingCode_Description; ItemTrackingCode.Description)
{
}
fieldelement(ItemTrackingCode_WarrantyDateFormula; ItemTrackingCode."Warranty Date Formula")
{
}
fieldelement(ItemTrackingCode_ManWarrantyDateEntryReqd; ItemTrackingCode."Man. Warranty Date Entry Reqd.")
{
}
fieldelement(ItemTrackingCode_ManExpirDateEntryReqd; ItemTrackingCode."Man. Expir. Date Entry Reqd.")
{
}
fieldelement(ItemTrackingCode_StrictExpirationPosting; ItemTrackingCode."Strict Expiration Posting")
{
}
fieldelement(ItemTrackingCode_SNSpecificTracking; ItemTrackingCode."SN Specific Tracking")
{
}
fieldelement(ItemTrackingCode_SNInfoInboundMustExist; ItemTrackingCode."SN Info. Inbound Must Exist")
{
}
fieldelement(ItemTrackingCode_SNInfoOutboundMustExist; ItemTrackingCode."SN Info. Outbound Must Exist")
{
}
fieldelement(ItemTrackingCode_SNWarehouseTracking; ItemTrackingCode."SN Warehouse Tracking")
{
}
fieldelement(ItemTrackingCode_SNPurchaseInboundTracking; ItemTrackingCode."SN Purchase Inbound Tracking")
{
}
fieldelement(ItemTrackingCode_SNPurchaseOutboundTracking; ItemTrackingCode."SN Purchase Outbound Tracking")
{
}
fieldelement(ItemTrackingCode_SNSalesInboundTracking; ItemTrackingCode."SN Sales Inbound Tracking")
{
}
fieldelement(ItemTrackingCode_SNSalesOutboundTracking; ItemTrackingCode."SN Sales Outbound Tracking")
{
}
fieldelement(ItemTrackingCode_SNPosAdjmtInbTracking; ItemTrackingCode."SN Pos. Adjmt. Inb. Tracking")
{
}
fieldelement(ItemTrackingCode_SNPosAdjmtOutbTracking; ItemTrackingCode."SN Pos. Adjmt. Outb. Tracking")
{
}
fieldelement(ItemTrackingCode_SNNegAdjmtInbTracking; ItemTrackingCode."SN Neg. Adjmt. Inb. Tracking")
{
}
fieldelement(ItemTrackingCode_SNNegAdjmtOutbTracking; ItemTrackingCode."SN Neg. Adjmt. Outb. Tracking")
{
}
fieldelement(ItemTrackingCode_SNTransferTracking; ItemTrackingCode."SN Transfer Tracking")
{
}
fieldelement(ItemTrackingCode_SNManufInboundTracking; ItemTrackingCode."SN Manuf. Inbound Tracking")
{
}
fieldelement(ItemTrackingCode_SNManufOutboundTracking; ItemTrackingCode."SN Manuf. Outbound Tracking")
{
}
fieldelement(ItemTrackingCode_SNAssemblyInboundTracking; ItemTrackingCode."SN Assembly Inbound Tracking")
{
}
fieldelement(ItemTrackingCode_SNAssemblyOutboundTracking; ItemTrackingCode."SN Assembly Outbound Tracking")
{
}
fieldelement(ItemTrackingCode_LotSpecificTracking; ItemTrackingCode."Lot Specific Tracking")
{
}
fieldelement(ItemTrackingCode_LotInfoInboundMustExist; ItemTrackingCode."Lot Info. Inbound Must Exist")
{
}
fieldelement(ItemTrackingCode_LotInfoOutboundMustExist; ItemTrackingCode."Lot Info. Outbound Must Exist")
{
}
fieldelement(ItemTrackingCode_LotWarehouseTracking; ItemTrackingCode."Lot Warehouse Tracking")
{
}
fieldelement(ItemTrackingCode_LotPurchaseInboundTracking; ItemTrackingCode."Lot Purchase Inbound Tracking")
{
}
fieldelement(ItemTrackingCode_LotPurchaseOutboundTracking; ItemTrackingCode."Lot Purchase Outbound Tracking")
{
}
fieldelement(ItemTrackingCode_LotSalesInboundTracking; ItemTrackingCode."Lot Sales Inbound Tracking")
{
}
fieldelement(ItemTrackingCode_LotSalesOutboundTracking; ItemTrackingCode."Lot Sales Outbound Tracking")
{
}
fieldelement(ItemTrackingCode_LotPosAdjmtInbTracking; ItemTrackingCode."Lot Pos. Adjmt. Inb. Tracking")
{
}
fieldelement(ItemTrackingCode_LotPosAdjmtOutbTracking; ItemTrackingCode."Lot Pos. Adjmt. Outb. Tracking")
{
}
fieldelement(ItemTrackingCode_LotNegAdjmtInbTracking; ItemTrackingCode."Lot Neg. Adjmt. Inb. Tracking")
{
}
fieldelement(ItemTrackingCode_LotNegAdjmtOutbTracking; ItemTrackingCode."Lot Neg. Adjmt. Outb. Tracking")
{
}
fieldelement(ItemTrackingCode_LotTransferTracking; ItemTrackingCode."Lot Transfer Tracking")
{
}
fieldelement(ItemTrackingCode_LotManufInboundTracking; ItemTrackingCode."Lot Manuf. Inbound Tracking")
{
}
fieldelement(ItemTrackingCode_LotManufOutboundTracking; ItemTrackingCode."Lot Manuf. Outbound Tracking")
{
}
fieldelement(ItemTrackingCode_LotAssemblyInboundTracking; ItemTrackingCode."Lot Assembly Inbound Tracking")
{
}
fieldelement(ItemTrackingCode_LotAssemblyOutboundTracking; ItemTrackingCode."Lot Assembly Outbound Tracking")
{
}
trigger OnPreXmlItem()
begin
ItemTrackingCode.SetRange(Code, FilteredItem."Item Tracking Code");
end;
}
tableelement(inventorysetup; "Inventory Setup")
{
AutoSave = true;
AutoUpdate = true;
XmlName = 'InventorySetup';
SourceTableView = sorting("Primary Key");
fieldelement(InventorySetup_PrimaryKey; InventorySetup."Primary Key")
{
}
fieldelement(InventorySetup_AutomaticCostPosting; InventorySetup."Automatic Cost Posting")
{
}
fieldelement(InventorySetup_LocationMandatory; InventorySetup."Location Mandatory")
{
}
fieldelement(InventorySetup_VariantMandatoryIfExists; InventorySetup."Variant Mandatory if Exists")
{
}
fieldelement(InventorySetup_AutomaticCostAdjustment; InventorySetup."Automatic Cost Adjustment")
{
}
fieldelement(InventorySetup_OutboundWhseHandlingTime; InventorySetup."Outbound Whse. Handling Time")
{
}
fieldelement(InventorySetup_InboundWhseHandlingTime; InventorySetup."Inbound Whse. Handling Time")
{
}
fieldelement(InventorySetup_ExpectedCostPostingtoGL; InventorySetup."Expected Cost Posting to G/L")
{
}
fieldelement(InventorySetup_AverageCostCalcType; InventorySetup."Average Cost Calc. Type")
{
}
fieldelement(InventorySetup_AverageCostPeriod; InventorySetup."Average Cost Period")
{
}
}
tableelement(prodorder; "Production Order")
{
AutoSave = true;
AutoUpdate = true;
MinOccurs = Zero;
XmlName = 'ProdOrder';
SourceTableView = sorting("No.", Status);
trigger OnAfterGetRecord()
begin
CollectProdOrder(ProdOrder."No.");
currXMLport.Skip();
end;
trigger OnPreXmlItem()
begin
ProdOrder.SetRange("Source No.", FilteredItem."No.");
ProdOrder.SetRange("Source Type", ProdOrder."Source Type"::Item);
end;
}
tableelement(tempprodorder; "Production Order")
{
AutoSave = true;
AutoUpdate = true;
MinOccurs = Zero;
XmlName = 'ProdOrder2';
SourceTableView = sorting("No.", Status);
UseTemporary = true;
fieldelement(ProdOrder2_Status; TempProdOrder.Status)
{
}
fieldelement(ProdOrder2_No; TempProdOrder."No.")
{
}
fieldelement(ProdOrder2_Description; TempProdOrder.Description)
{
}
fieldelement(ProdOrder2_SearchDescription; TempProdOrder."Search Description")
{
}
fieldelement(ProdOrder2_Description2; TempProdOrder."Description 2")
{
}
fieldelement(ProdOrder2_CreationDate; TempProdOrder."Creation Date")
{
}
fieldelement(ProdOrder2_LastDateModified; TempProdOrder."Last Date Modified")
{
}
fieldelement(ProdOrder2_SourceType; TempProdOrder."Source Type")
{
}
fieldelement(ProdOrder2_SourceNo; TempProdOrder."Source No.")
{
}
fieldelement(ProdOrder2_RoutingNo; TempProdOrder."Routing No.")
{
}
fieldelement(ProdOrder2_InventoryPostingGroup; TempProdOrder."Inventory Posting Group")
{
}
fieldelement(ProdOrder2_GenProdPostingGroup; TempProdOrder."Gen. Prod. Posting Group")
{
}
fieldelement(ProdOrder2_GenBusPostingGroup; TempProdOrder."Gen. Bus. Posting Group")
{
}
fieldelement(ProdOrder2_StartingTime; TempProdOrder."Starting Time")
{
}
fieldelement(ProdOrder2_StartingDate; TempProdOrder."Starting Date")
{
}
fieldelement(ProdOrder2_EndingTime; TempProdOrder."Ending Time")
{
}
fieldelement(ProdOrder2_EndingDate; TempProdOrder."Ending Date")
{
}
fieldelement(ProdOrder2_DueDate; TempProdOrder."Due Date")
{
}
fieldelement(ProdOrder2_FinishedDate; TempProdOrder."Finished Date")
{
}
fieldelement(ProdOrder2_Blocked; TempProdOrder.Blocked)
{
}
fieldelement(ProdOrder2_ShortcutDimension1Code; TempProdOrder."Shortcut Dimension 1 Code")
{
}
fieldelement(ProdOrder2_ShortcutDimension2Code; TempProdOrder."Shortcut Dimension 2 Code")
{
}
fieldelement(ProdOrder2_LocationCode; TempProdOrder."Location Code")
{
}
fieldelement(ProdOrder2_BinCode; TempProdOrder."Bin Code")
{
}
fieldelement(ProdOrder2_ReplanRefNo; TempProdOrder."Replan Ref. No.")
{
}
fieldelement(ProdOrder2_ReplanRefStatus; TempProdOrder."Replan Ref. Status")
{
}
fieldelement(ProdOrder2_LowLevelCode; TempProdOrder."Low-Level Code")
{
}
fieldelement(ProdOrder2_Quantity; TempProdOrder.Quantity)
{
}
fieldelement(ProdOrder2_UnitCost; TempProdOrder."Unit Cost")
{
}
fieldelement(ProdOrder2_CostAmount; TempProdOrder."Cost Amount")
{
}
fieldelement(ProdOrder2_ExpectedOperationCostAmt; TempProdOrder."Expected Operation Cost Amt.")
{
}
fieldelement(ProdOrder2_ExpectedComponentCostAmt; TempProdOrder."Expected Component Cost Amt.")
{
}
fieldelement(ProdOrder2_ActualTimeUsed; TempProdOrder."Actual Time Used")
{
}
fieldelement(ProdOrder2_AllocatedCapacityNeed; TempProdOrder."Allocated Capacity Need")
{
}
fieldelement(ProdOrder2_ExpectedCapacityNeed; TempProdOrder."Expected Capacity Need")
{
}
fieldelement(ProdOrder2_NoSeries; TempProdOrder."No. Series")
{
}
fieldelement(ProdOrder2_PlannedOrderNo; TempProdOrder."Planned Order No.")
{
}
fieldelement(ProdOrder2_FirmPlannedOrderNo; TempProdOrder."Firm Planned Order No.")
{
}
fieldelement(ProdOrder2_SimulatedOrderNo; TempProdOrder."Simulated Order No.")
{
}
fieldelement(ProdOrder2_ExpectedMaterialOvhdCost; TempProdOrder."Expected Material Ovhd. Cost")
{
}
fieldelement(ProdOrder2_ExpectedCapacityOvhdCost; TempProdOrder."Expected Capacity Ovhd. Cost")
{
}
fieldelement(ProdOrder2_StartingDateTime; TempProdOrder."Starting Date-Time")
{
}
fieldelement(ProdOrder2_EndingDateTime; TempProdOrder."Ending Date-Time")
{
}
trigger OnAfterInsertRecord()
var
ProdOrder2: Record "Production Order";
begin
ProdOrder2 := TempProdOrder;
if not ProdOrder2.Insert() then
ProdOrder2.Modify();
end;
}
tableelement(tempprodorderline; "Prod. Order Line")
{
AutoSave = true;
AutoUpdate = true;
MinOccurs = Zero;
XmlName = 'ProdOrderLine';
SourceTableView = sorting("Prod. Order No.", "Line No.", Status);
UseTemporary = true;
fieldelement(ProdOrderLine_Status; TempProdOrderLine.Status)
{
}
fieldelement(ProdOrderLine_ProdOrderNo; TempProdOrderLine."Prod. Order No.")
{
}
fieldelement(ProdOrderLine_LineNo; TempProdOrderLine."Line No.")
{
}
fieldelement(ProdOrderLine_ItemNo; TempProdOrderLine."Item No.")
{
}
fieldelement(ProdOrderLine_VariantCode; TempProdOrderLine."Variant Code")
{
}
fieldelement(ProdOrderLine_Description; TempProdOrderLine.Description)
{
}
fieldelement(ProdOrderLine_Description2; TempProdOrderLine."Description 2")
{
}
fieldelement(ProdOrderLine_LocationCode; TempProdOrderLine."Location Code")
{
}
fieldelement(ProdOrderLine_ShortcutDimension1Code; TempProdOrderLine."Shortcut Dimension 1 Code")
{
}
fieldelement(ProdOrderLine_ShortcutDimension2Code; TempProdOrderLine."Shortcut Dimension 2 Code")
{
}
fieldelement(ProdOrderLine_BinCode; TempProdOrderLine."Bin Code")
{
}
fieldelement(ProdOrderLine_Quantity; TempProdOrderLine.Quantity)
{
}
fieldelement(ProdOrderLine_FinishedQuantity; TempProdOrderLine."Finished Quantity")
{
}
fieldelement(ProdOrderLine_RemainingQuantity; TempProdOrderLine."Remaining Quantity")
{
}
fieldelement(ProdOrderLine_ScrapPct; TempProdOrderLine."Scrap %")
{
}
fieldelement(ProdOrderLine_DueDate; TempProdOrderLine."Due Date")
{
}
fieldelement(ProdOrderLine_StartingDate; TempProdOrderLine."Starting Date")
{
}
fieldelement(ProdOrderLine_StartingTime; TempProdOrderLine."Starting Time")
{
}
fieldelement(ProdOrderLine_EndingDate; TempProdOrderLine."Ending Date")
{
}
fieldelement(ProdOrderLine_EndingTime; TempProdOrderLine."Ending Time")
{
}
fieldelement(ProdOrderLine_PlanningLevelCode; TempProdOrderLine."Planning Level Code")
{
}
fieldelement(ProdOrderLine_Priority; TempProdOrderLine.Priority)
{
}
fieldelement(ProdOrderLine_ProductionBomNo; TempProdOrderLine."Production BOM No.")
{
}
fieldelement(ProdOrderLine_RoutingNo; TempProdOrderLine."Routing No.")
{
}
fieldelement(ProdOrderLine_InventoryPostingGroup; TempProdOrderLine."Inventory Posting Group")
{
}
fieldelement(ProdOrderLine_RoutingReferenceNo; TempProdOrderLine."Routing Reference No.")
{
}
fieldelement(ProdOrderLine_UnitCost; TempProdOrderLine."Unit Cost")
{
}
fieldelement(ProdOrderLine_CostAmount; TempProdOrderLine."Cost Amount")
{
}
fieldelement(ProdOrderLine_ReservedQuantity; TempProdOrderLine."Reserved Quantity")
{
}
fieldelement(ProdOrderLine_UnitOfMeasureCode; TempProdOrderLine."Unit of Measure Code")
{
}
fieldelement(ProdOrderLine_QuantityBase; TempProdOrderLine."Quantity (Base)")
{
}
fieldelement(ProdOrderLine_FinishedQtyBase; TempProdOrderLine."Finished Qty. (Base)")
{
}
fieldelement(ProdOrderLine_RemainingQtyBase; TempProdOrderLine."Remaining Qty. (Base)")
{
}
fieldelement(ProdOrderLine_ReservedQtyBase; TempProdOrderLine."Reserved Qty. (Base)")
{
}
fieldelement(ProdOrderLine_ExpectedOperationCostAmt; TempProdOrderLine."Expected Operation Cost Amt.")
{
}
fieldelement(ProdOrderLine_TotalExpOperOutputQty; TempProdOrderLine."Total Exp. Oper. Output (Qty.)")
{
}
fieldelement(ProdOrderLine_ExpectedComponentCostAmt; TempProdOrderLine."Expected Component Cost Amt.")
{
}
fieldelement(ProdOrderLine_StartingDateTime; TempProdOrderLine."Starting Date-Time")
{
}
fieldelement(ProdOrderLine_EndingDateTime; TempProdOrderLine."Ending Date-Time")
{
}
fieldelement(ProdOrderLine_CostAmountACY; TempProdOrderLine."Cost Amount (ACY)")
{
}
fieldelement(ProdOrderLine_UnitCostACY; TempProdOrderLine."Unit Cost (ACY)")
{
}
fieldelement(ProdOrderLine_ProductionBomVersionCode; TempProdOrderLine."Production BOM Version Code")
{
}
fieldelement(ProdOrderLine_RoutingVersionCode; TempProdOrderLine."Routing Version Code")
{
}
fieldelement(ProdOrderLine_RoutingType; TempProdOrderLine."Routing Type")
{
}
fieldelement(ProdOrderLine_QtyPerUnitOfMeasure; TempProdOrderLine."Qty. per Unit of Measure")
{
}
fieldelement(ProdOrderLine_MpsOrder; TempProdOrderLine."MPS Order")
{
}
fieldelement(ProdOrderLine_PlanningFlexibility; TempProdOrderLine."Planning Flexibility")
{
}
fieldelement(ProdOrderLine_IndirectCostPct; TempProdOrderLine."Indirect Cost %")
{
}
fieldelement(ProdOrderLine_OverheadRate; TempProdOrderLine."Overhead Rate")
{
}
trigger OnAfterInsertRecord()
var
ProdOrderLine2: Record "Prod. Order Line";
begin
ProdOrderLine2 := TempProdOrderLine;
if not ProdOrderLine2.Insert() then
ProdOrderLine2.Modify();
end;
}
tableelement(capledgentry; "Capacity Ledger Entry")
{
AutoSave = true;
AutoUpdate = true;
MinOccurs = Zero;
XmlName = 'CapLedgEntry';
SourceTableView = sorting("Entry No.");
fieldelement(CapLedgEntry_EntryNo; CapLedgEntry."Entry No.")
{
}
fieldelement(CapLedgEntry_No; CapLedgEntry."No.")
{
}
fieldelement(CapLedgEntry_PostingDate; CapLedgEntry."Posting Date")
{
}
fieldelement(CapLedgEntry_Type; CapLedgEntry.Type)
{
}
fieldelement(CapLedgEntry_DocumentNo; CapLedgEntry."Document No.")
{
}
fieldelement(CapLedgEntry_Description; CapLedgEntry.Description)
{
}
fieldelement(CapLedgEntry_OperationNo; CapLedgEntry."Operation No.")
{
}
fieldelement(CapLedgEntry_WorkCenterNo; CapLedgEntry."Work Center No.")
{
}
fieldelement(CapLedgEntry_Quantity; CapLedgEntry.Quantity)
{
}
fieldelement(CapLedgEntry_SetupTime; CapLedgEntry."Setup Time")
{
}
fieldelement(CapLedgEntry_RunTime; CapLedgEntry."Run Time")
{
}
fieldelement(CapLedgEntry_StopTime; CapLedgEntry."Stop Time")
{
}
fieldelement(CapLedgEntry_InvoicedQuantity; CapLedgEntry."Invoiced Quantity")
{
}
fieldelement(CapLedgEntry_OutputQuantity; CapLedgEntry."Output Quantity")
{
}
fieldelement(CapLedgEntry_ScrapQuantity; CapLedgEntry."Scrap Quantity")
{
}
fieldelement(CapLedgEntry_ConcurrentCapacity; CapLedgEntry."Concurrent Capacity")
{
}
fieldelement(CapLedgEntry_CapUnitofMeasureCode; CapLedgEntry."Cap. Unit of Measure Code")
{
}
fieldelement(CapLedgEntry_QtyperCapUnitofMeasure; CapLedgEntry."Qty. per Cap. Unit of Measure")
{
}
fieldelement(CapLedgEntry_GlobalDimension1Code; CapLedgEntry."Global Dimension 1 Code")
{
}
fieldelement(CapLedgEntry_GlobalDimension2Code; CapLedgEntry."Global Dimension 2 Code")
{
}
fieldelement(CapLedgEntry_LastOutputLine; CapLedgEntry."Last Output Line")
{
}
fieldelement(CapLedgEntry_CompletelyInvoiced; CapLedgEntry."Completely Invoiced")
{
}
fieldelement(CapLedgEntry_StartingTime; CapLedgEntry."Starting Time")
{
}
fieldelement(CapLedgEntry_EndingTime; CapLedgEntry."Ending Time")
{
}
fieldelement(CapLedgEntry_RoutingNo; CapLedgEntry."Routing No.")
{
}
fieldelement(CapLedgEntry_RoutingReferenceNo; CapLedgEntry."Routing Reference No.")
{
}
fieldelement(CapLedgEntry_ItemNo; CapLedgEntry."Item No.")
{
}
fieldelement(CapLedgEntry_VariantCode; CapLedgEntry."Variant Code")
{
}
fieldelement(CapLedgEntry_UnitofMeasureCode; CapLedgEntry."Unit of Measure Code")
{
}
fieldelement(CapLedgEntry_QtyperUnitofMeasure; CapLedgEntry."Qty. per Unit of Measure")
{
}
fieldelement(CapLedgEntry_DocumentDate; CapLedgEntry."Document Date")
{
}
fieldelement(CapLedgEntry_ExternalDocumentNo; CapLedgEntry."External Document No.")
{
}
fieldelement(CapLedgEntry_StopCode; CapLedgEntry."Stop Code")
{
}
fieldelement(CapLedgEntry_ScrapCode; CapLedgEntry."Scrap Code")
{
}
fieldelement(CapLedgEntry_WorkCenterGroupCode; CapLedgEntry."Work Center Group Code")
{
}
fieldelement(CapLedgEntry_WorkShiftCode; CapLedgEntry."Work Shift Code")
{
}
fieldelement(CapLedgEntry_DirectCost; CapLedgEntry."Direct Cost")
{
}
fieldelement(CapLedgEntry_OverheadCost; CapLedgEntry."Overhead Cost")
{
}
fieldelement(CapLedgEntry_DirectCostACY; CapLedgEntry."Direct Cost (ACY)")
{
}
fieldelement(CapLedgEntry_OverheadCostACY; CapLedgEntry."Overhead Cost (ACY)")
{
}
fieldelement(CapLedgEntry_Subcontracting; CapLedgEntry.Subcontracting)
{
}
fieldelement(CapLedgEntry_OrderType; CapLedgEntry."Order Type")
{
}
fieldelement(CapLedgEntry_OrderNo; CapLedgEntry."Order No.")
{
}
fieldelement(CapLedgEntry_OrderLineNo; CapLedgEntry."Order Line No.")
{
}
trigger OnAfterGetRecord()
begin
CollectCapValueEntry(CapLedgEntry."Entry No.");
end;
trigger OnPreXmlItem()
begin
CapLedgEntry.SetRange("Item No.", FilteredItem."No.");
end;
}
tableelement(tempcapvalueentry; "Value Entry")
{
AutoSave = true;
AutoUpdate = true;
MinOccurs = Zero;
XmlName = 'CapValueEntry';
SourceTableView = sorting("Entry No.");
UseTemporary = true;
fieldelement(CapValueEntry_EntryNo; TempCapValueEntry."Entry No.")
{
}
fieldelement(CapValueEntry_ItemNo; TempCapValueEntry."Item No.")
{
}
fieldelement(CapValueEntry_PostingDate; TempCapValueEntry."Posting Date")
{
}
fieldelement(CapValueEntry_ItemLedgerEntryType; TempCapValueEntry."Item Ledger Entry Type")
{
}
fieldelement(CapValueEntry_SourceNo; TempCapValueEntry."Source No.")
{
}
fieldelement(CapValueEntry_DocumentNo; TempCapValueEntry."Document No.")
{
}
fieldelement(CapValueEntry_Description; TempCapValueEntry.Description)
{
}
fieldelement(CapValueEntry_LocationCode; TempCapValueEntry."Location Code")
{
}
fieldelement(CapValueEntry_InventoryPostingGroup; TempCapValueEntry."Inventory Posting Group")
{
}
fieldelement(CapValueEntry_SourcePostingGroup; TempCapValueEntry."Source Posting Group")
{
}
fieldelement(CapValueEntry_ItemLedgerEntryNo; TempCapValueEntry."Item Ledger Entry No.")
{
}
fieldelement(CapValueEntry_ValuedQuantity; TempCapValueEntry."Valued Quantity")
{
}
fieldelement(CapValueEntry_ItemLedgerEntryQuantity; TempCapValueEntry."Item Ledger Entry Quantity")
{
}
fieldelement(CapValueEntry_InvoicedQuantity; TempCapValueEntry."Invoiced Quantity")
{
}
fieldelement(CapValueEntry_CostperUnit; TempCapValueEntry."Cost per Unit")
{
}
fieldelement(CapValueEntry_SalesAmountActual; TempCapValueEntry."Sales Amount (Actual)")
{
}
fieldelement(CapValueEntry_DiscountAmount; TempCapValueEntry."Discount Amount")
{
}
fieldelement(CapValueEntry_SourceCode; TempCapValueEntry."Source Code")
{
}
fieldelement(CapValueEntry_AppliestoEntry; TempCapValueEntry."Applies-to Entry")
{
}
fieldelement(CapValueEntry_GlobalDimension1Code; TempCapValueEntry."Global Dimension 1 Code")
{
}
fieldelement(CapValueEntry_GlobalDimension2Code; TempCapValueEntry."Global Dimension 2 Code")
{
}
fieldelement(CapValueEntry_SourceType; TempCapValueEntry."Source Type")
{
}
fieldelement(CapValueEntry_CostAmountActual; TempCapValueEntry."Cost Amount (Actual)")
{
}
fieldelement(CapValueEntry_CostPostedtoGL; TempCapValueEntry."Cost Posted to G/L")
{
}
fieldelement(CapValueEntry_ReasonCode; TempCapValueEntry."Reason Code")
{
}
fieldelement(CapValueEntry_DropShipment; TempCapValueEntry."Drop Shipment")
{
}
fieldelement(CapValueEntry_JournalBatchName; TempCapValueEntry."Journal Batch Name")
{
}
fieldelement(CapValueEntry_GenBusPostingGroup; TempCapValueEntry."Gen. Bus. Posting Group")
{
}
fieldelement(CapValueEntry_GenProdPostingGroup; TempCapValueEntry."Gen. Prod. Posting Group")
{
}
fieldelement(CapValueEntry_DocumentDate; TempCapValueEntry."Document Date")
{
}
fieldelement(CapValueEntry_ExternalDocumentNo; TempCapValueEntry."External Document No.")
{
}
fieldelement(CapValueEntry_CostAmountActualACY; TempCapValueEntry."Cost Amount (Actual) (ACY)")
{
}
fieldelement(CapValueEntry_CostPostedtoGLACY; TempCapValueEntry."Cost Posted to G/L (ACY)")
{
}
fieldelement(CapValueEntry_CostperUnitACY; TempCapValueEntry."Cost per Unit (ACY)")
{
}
fieldelement(CapValueEntry_DocumentType; TempCapValueEntry."Document Type")
{
}
fieldelement(CapValueEntry_DocumentLineNo; TempCapValueEntry."Document Line No.")
{
}
fieldelement(CapValueEntry_OrderType; TempCapValueEntry."Order Type")
{
}
fieldelement(CapValueEntry_OrderNo; TempCapValueEntry."Order No.")
{
}
fieldelement(CapValueEntry_OrderLineNo; TempCapValueEntry."Order Line No.")
{
}
fieldelement(CapValueEntry_ExpectedCost; TempCapValueEntry."Expected Cost")
{
}
fieldelement(CapValueEntry_ItemChargeNo; TempCapValueEntry."Item Charge No.")
{
}
fieldelement(CapValueEntry_ValuedByAverageCost; TempCapValueEntry."Valued By Average Cost")
{
}
fieldelement(CapValueEntry_PartialRevaluation; TempCapValueEntry."Partial Revaluation")
{
}
fieldelement(CapValueEntry_Inventoriable; TempCapValueEntry.Inventoriable)
{
}
fieldelement(CapValueEntry_ValuationDate; TempCapValueEntry."Valuation Date")
{
}
fieldelement(CapValueEntry_EntryType; TempCapValueEntry."Entry Type")
{
}
fieldelement(CapValueEntry_VarianceType; TempCapValueEntry."Variance Type")
{
}
fieldelement(CapValueEntry_PurchaseAmountActual; TempCapValueEntry."Purchase Amount (Actual)")
{
}
fieldelement(CapValueEntry_PurchaseAmountExpected; TempCapValueEntry."Purchase Amount (Expected)")
{
}
fieldelement(CapValueEntry_SalesAmountExpected; TempCapValueEntry."Sales Amount (Expected)")
{
}
fieldelement(CapValueEntry_CostAmountExpected; TempCapValueEntry."Cost Amount (Expected)")
{
}
fieldelement(CapValueEntry_CostAmountNonInvtbl; TempCapValueEntry."Cost Amount (Non-Invtbl.)")
{
}
fieldelement(CapValueEntry_CostAmountExpectedACY; TempCapValueEntry."Cost Amount (Expected) (ACY)")
{
}
fieldelement(CapValueEntry_CostAmountNonInvtblACY; TempCapValueEntry."Cost Amount (Non-Invtbl.)(ACY)")
{
}
fieldelement(CapValueEntry_ExpectedCostPostedtoGL; TempCapValueEntry."Expected Cost Posted to G/L")
{
}
fieldelement(CapValueEntry_ExpCostPostedtoGLACY; TempCapValueEntry."Exp. Cost Posted to G/L (ACY)")
{
}
fieldelement(CapValueEntry_VariantCode; TempCapValueEntry."Variant Code")
{
}
fieldelement(CapValueEntry_Adjustment; TempCapValueEntry.Adjustment)
{
}
fieldelement(CapValueEntry_CapacityLedgerEntryNo; TempCapValueEntry."Capacity Ledger Entry No.")
{
}
fieldelement(CapValueEntry_Type; TempCapValueEntry.Type)
{
}
fieldelement(CapValueEntry_No; TempCapValueEntry."No.")
{
}
fieldelement(CapValueEntry_ReturnReasonCode; TempCapValueEntry."Return Reason Code")
{
}
fieldelement(CapValueEntry_DocumentType; TempCapValueEntry."Document Type")
{
}
fieldelement(CapValueEntry_DocumentLineNo; TempCapValueEntry."Document Line No.")
{
}
fieldelement(CapValueEntry_CapacityLedgerEntryNo; TempCapValueEntry."Capacity Ledger Entry No.")
{
}
trigger OnPreXmlItem()
begin
ValueEntry.SetRange("Item No.", FilteredItem."No.");
end;
trigger OnAfterInsertRecord()
var
CapValueEntry2: Record "Value Entry";
begin
CapValueEntry2 := TempCapValueEntry;
CapValueEntry2."Item Ledger Entry Type" := CapValueEntry2."Item Ledger Entry Type"::" "; // otherwise Capacity Value entries state Purchase as ILE Type
if not CapValueEntry2.Insert() then
CapValueEntry2.Modify();
end;
}
tableelement(generalledgsetup; "General Ledger Setup")
{
AutoSave = true;
AutoUpdate = true;
XmlName = 'GeneralLedgSetup';
SourceTableView = sorting("Primary Key");
fieldelement(GeneralLedgSetup_PrimaryKey; GeneralLedgSetup."Primary Key")
{
}
fieldelement(GeneralLedgSetup_AllowPostingFrom; GeneralLedgSetup."Allow Posting From")
{
}
fieldelement(GeneralLedgSetup_AllowPostingTo; GeneralLedgSetup."Allow Posting To")
{
}
fieldelement(GeneralLedgSetup_RegisterTime; GeneralLedgSetup."Register Time")
{
}
fieldelement(GeneralLedgSetup_PmtDiscExclVAT; GeneralLedgSetup."Pmt. Disc. Excl. VAT")
{
}
fieldelement(GeneralLedgSetup_DateFilter; GeneralLedgSetup."Date Filter")
{
}
fieldelement(GeneralLedgSetup_GlobalDimension1Filter; GeneralLedgSetup."Global Dimension 1 Filter")
{
}
fieldelement(GeneralLedgSetup_GlobalDimension2Filter; GeneralLedgSetup."Global Dimension 2 Filter")
{
}
fieldelement(GeneralLedgSetup_CustBalancesDue; GeneralLedgSetup."Cust. Balances Due")
{
}
fieldelement(GeneralLedgSetup_VendorBalancesDue; GeneralLedgSetup."Vendor Balances Due")
{
}
fieldelement(GeneralLedgSetup_UnrealizedVAT; GeneralLedgSetup."Unrealized VAT")
{
}
fieldelement(GeneralLedgSetup_AdjustforPaymentDisc; GeneralLedgSetup."Adjust for Payment Disc.")
{
}
fieldelement(GeneralLedgSetup_InvRoundingPrecisionLCY; GeneralLedgSetup."Inv. Rounding Precision (LCY)")
{
}
fieldelement(GeneralLedgSetup_InvRoundingTypeLCY; GeneralLedgSetup."Inv. Rounding Type (LCY)")
{
}
fieldelement(GeneralLedgSetup_LocalContAddrFormat; GeneralLedgSetup."Local Cont. Addr. Format")
{
}
fieldelement(GeneralLedgSetup_AmountDecimalPlaces; GeneralLedgSetup."Amount Decimal Places")
{
}
fieldelement(GeneralLedgSetup_UnitAmountDecimalPlaces; GeneralLedgSetup."Unit-Amount Decimal Places")
{
}
fieldelement(GeneralLedgSetup_AdditionalReportingCurrency; GeneralLedgSetup."Additional Reporting Currency")
{
}
fieldelement(GeneralLedgSetup_AmountRoundingPrecision; GeneralLedgSetup."Amount Rounding Precision")
{
}
fieldelement(GeneralLedgSetup_UnitAmountRoundingPrecision; GeneralLedgSetup."Unit-Amount Rounding Precision")
{
}
fieldelement(GeneralLedgSetup_ApplnRoundingPrecision; GeneralLedgSetup."Appln. Rounding Precision")
{
}
fieldelement(GeneralLedgSetup_GlobalDimension1Code; GeneralLedgSetup."Global Dimension 1 Code")
{
}
fieldelement(GeneralLedgSetup_GlobalDimension2Code; GeneralLedgSetup."Global Dimension 2 Code")
{
}
}
tableelement(accountingperiod; "Accounting Period")
{
AutoSave = false;
AutoUpdate = false;
XmlName = 'AccountingPeriod';
SourceTableView = sorting("Starting Date");
fieldelement(AccountingPeriod_StartingDate; AccountingPeriod."Starting Date")
{
}
fieldelement(AccountingPeriod_Name; AccountingPeriod.Name)
{
}
fieldelement(AccountingPeriod_NewFiscalYear; AccountingPeriod."New Fiscal Year")
{
}
fieldelement(AccountingPeriod_Closed; AccountingPeriod.Closed)
{
}
fieldelement(AccountingPeriod_DateLocked; AccountingPeriod."Date Locked")
{
}
fieldelement(AccountingPeriod_AverageCostCalcType; AccountingPeriod."Average Cost Calc. Type")
{
}
fieldelement(AccountingPeriod_AverageCostPeriod; AccountingPeriod."Average Cost Period")
{
}
trigger OnBeforeInsertRecord()
begin
if not AccountingPeriod.Insert() then
AccountingPeriod.Modify();
end;
}
tableelement(postvalueentrytogl; "Post Value Entry to G/L")
{
AutoSave = true;
AutoUpdate = true;
MinOccurs = Zero;
XmlName = 'PostValueEntryToGl';
SourceTableView = sorting("Item No.", "Posting Date");
fieldelement(PostValueEntryToGl_ValueEntryNo; PostValueEntryToGl."Value Entry No.")
{
}
fieldelement(PostValueEntryToGl_ItemNo; PostValueEntryToGl."Item No.")
{
}
fieldelement(PostValueEntryToGl_PostingDate; PostValueEntryToGl."Posting Date")
{
}
trigger OnPreXmlItem()
begin
PostValueEntryToGl.SetRange("Item No.", FilteredItem."No.");
end;
}
tableelement(tempitemapplnentryhistory; "Item Application Entry History")
{
AutoSave = true;
AutoUpdate = true;
MinOccurs = Zero;
XmlName = 'ItemApplnEntryHistory';
SourceTableView = sorting("Primary Entry No.");
UseTemporary = true;
fieldelement(ItemApplnEntryHist_EntryNo; TempItemApplnEntryHistory."Entry No.")
{
}
fieldelement(ItemApplnEntryHist_ItemLedgerEntryNo; TempItemApplnEntryHistory."Item Ledger Entry No.")
{
}
fieldelement(ItemApplnEntryHist_InboundItemEntryNo; TempItemApplnEntryHistory."Inbound Item Entry No.")
{
}
fieldelement(ItemApplnEntryHist_OutboundItemEntryNo; TempItemApplnEntryHistory."Outbound Item Entry No.")
{
}
fieldelement(ItemApplnEntryHist_Quantity; TempItemApplnEntryHistory.Quantity)
{
}
fieldelement(ItemApplnEntryHist_PostingDate; TempItemApplnEntryHistory."Posting Date")
{
}
fieldelement(ItemApplnEntryHist_TransferredFromEntryNo; TempItemApplnEntryHistory."Transferred-from Entry No.")
{
}
fieldelement(ItemApplnEntryHist_CreationDate; TempItemApplnEntryHistory."Creation Date")
{
}
fieldelement(ItemApplnEntryHist_LastModifiedDate; TempItemApplnEntryHistory."Last Modified Date")
{
}
fieldelement(ItemApplnEntryHist_DeletedDate; TempItemApplnEntryHistory."Deleted Date")
{
}
fieldelement(ItemApplnEntryHist_CostApplication; TempItemApplnEntryHistory."Cost Application")
{
}
fieldelement(ItemApplnEntryHist_OutputCompletelyInvdDate; TempItemApplnEntryHistory."Output Completely Invd. Date")
{
}
fieldelement(ItemApplnEntryHist_OutputEntryIsUpdated; TempItemApplnEntryHistory."Primary Entry No.")
{
}
trigger OnAfterInsertRecord()
var
ItemApplnEntryHistory2: Record "Item Application Entry History";
begin
ItemApplnEntryHistory2 := TempItemApplnEntryHistory;
if not ItemApplnEntryHistory2.Insert() then
ItemApplnEntryHistory2.Modify();
end;
}
tableelement(inventoryperiod; "Inventory Period")
{
AutoSave = true;
AutoUpdate = true;
MinOccurs = Zero;
XmlName = 'InventoryPeriod';
SourceTableView = sorting("Ending Date");
fieldelement(InventoryPeriod_EndingDate; InventoryPeriod."Ending Date")
{
}
fieldelement(InventoryPeriod_Name; InventoryPeriod.Name)
{
}
fieldelement(InventoryPeriod_Closed; InventoryPeriod.Closed)
{
}
}
tableelement(itemregister; "Item Register")
{
AutoSave = true;
AutoUpdate = true;
MinOccurs = Zero;
XmlName = 'ItemRegister';
SourceTableView = sorting("Source Code");
fieldelement(ItemRegister_No; ItemRegister."No.")
{
}
fieldelement(ItemRegister_FromEntryNo; ItemRegister."From Entry No.")
{
}
fieldelement(ItemRegister_ToEntryNo; ItemRegister."To Entry No.")
{
}
fieldelement(ItemRegister_CreationDate; ItemRegister."Creation Date")
{
}
fieldelement(ItemRegister_SourceCode; ItemRegister."Source Code")
{
}
fieldelement(ItemRegister_JournalBatchName; ItemRegister."Journal Batch Name")
{
}
fieldelement(ItemRegister_FromPhysInventoryEntryNo; ItemRegister."From Phys. Inventory Entry No.")
{
}
fieldelement(ItemRegister_ToPhysInventoryEntryNo; ItemRegister."To Phys. Inventory Entry No.")
{
}
fieldelement(ItemRegister_FromValueEntryNo; ItemRegister."From Value Entry No.")
{
}
fieldelement(ItemRegister_ToValueEntryNo; ItemRegister."To Value Entry No.")
{
}
fieldelement(ItemRegister_FromCapacityEntryNo; ItemRegister."From Capacity Entry No.")
{
}
fieldelement(ItemRegister_ToCapacityEntryNo; ItemRegister."To Capacity Entry No.")
{
}
trigger OnPreXmlItem()
var
SourceCodeSetup: Record "Source Code Setup";
begin
SourceCodeSetup.Get();
ItemRegister.SetRange("Source Code", SourceCodeSetup."Adjust Cost");
end;
}
tableelement(stockkeepingunit; "Stockkeeping Unit")
{
AutoSave = true;
AutoUpdate = true;
MinOccurs = Zero;
XmlName = 'StockkeepingUnit';
SourceTableView = sorting("Item No.");
fieldelement(StockkeepingUnit_ItemNo; StockkeepingUnit."Item No.")
{
}
fieldelement(StockkeepingUnit_VariantCode; StockkeepingUnit."Variant Code")
{
}
fieldelement(StockkeepingUnit_LocationCode; StockkeepingUnit."Location Code")
{
}
fieldelement(StockkeepingUnit_ShelfNo; StockkeepingUnit."Shelf No.")
{
}
fieldelement(StockkeepingUnit_UnitCost; StockkeepingUnit."Unit Cost")
{
}
fieldelement(StockkeepingUnit_StandardCost; StockkeepingUnit."Standard Cost")
{
}
fieldelement(StockkeepingUnit_LastDirectCost; StockkeepingUnit."Last Direct Cost")
{
}
fieldelement(StockkeepingUnit_VendorNo; StockkeepingUnit."Vendor No.")
{
}
fieldelement(StockkeepingUnit_VendorItemNo; StockkeepingUnit."Vendor Item No.")
{
}
fieldelement(StockkeepingUnit_LeadTimeCalculation; StockkeepingUnit."Lead Time Calculation")
{
}
fieldelement(StockkeepingUnit_ReorderPoint; StockkeepingUnit."Reorder Point")
{
}
fieldelement(StockkeepingUnit_MaximumInventory; StockkeepingUnit."Maximum Inventory")
{
}
fieldelement(StockkeepingUnit_ReorderQuantity; StockkeepingUnit."Reorder Quantity")
{
}
fieldelement(StockkeepingUnit_AssemblyPolicy; StockkeepingUnit."Assembly Policy")
{
}
fieldelement(StockkeepingUnit_TransferLevelCode; StockkeepingUnit."Transfer-Level Code")
{
}
fieldelement(StockkeepingUnit_LotSize; StockkeepingUnit."Lot Size")
{
}
fieldelement(StockkeepingUnit_DiscreteOrderQuantity; StockkeepingUnit."Discrete Order Quantity")
{
}
fieldelement(StockkeepingUnit_MinimumOrderQuantity; StockkeepingUnit."Minimum Order Quantity")
{
}
fieldelement(StockkeepingUnit_MaximumOrderQuantity; StockkeepingUnit."Maximum Order Quantity")
{
}
fieldelement(StockkeepingUnit_SafetyStockQuantity; StockkeepingUnit."Safety Stock Quantity")
{
}
fieldelement(StockkeepingUnit_OrderMultiple; StockkeepingUnit."Order Multiple")
{
}
fieldelement(StockkeepingUnit_SafetyLeadTime; StockkeepingUnit."Safety Lead Time")
{
}
fieldelement(StockkeepingUnit_ComponentsatLocation; StockkeepingUnit."Components at Location")
{
}
fieldelement(StockkeepingUnit_FlushingMethod; StockkeepingUnit."Flushing Method")
{
}
fieldelement(StockkeepingUnit_ReplenishmentSystem; StockkeepingUnit."Replenishment System")
{
}
fieldelement(StockkeepingUnit_TimeBucket; StockkeepingUnit."Time Bucket")
{
}
fieldelement(StockkeepingUnit_ReorderingPolicy; StockkeepingUnit."Reordering Policy")
{
}
fieldelement(StockkeepingUnit_IncludeInventory; StockkeepingUnit."Include Inventory")
{
}
fieldelement(StockkeepingUnit_ManufacturingPolicy; StockkeepingUnit."Manufacturing Policy")
{
}
fieldelement(StockkeepingUnit_LotAccumulationPeriod; StockkeepingUnit."Lot Accumulation Period")
{
}
fieldelement(StockkeepingUnit_ReschedulingPeriod; StockkeepingUnit."Rescheduling Period")
{
}
fieldelement(StockkeepingUnit_DampenerPeriod; StockkeepingUnit."Dampener Period")
{
}
fieldelement(StockkeepingUnit_DampenerQuantity; StockkeepingUnit."Dampener Quantity")
{
}
fieldelement(StockkeepingUnit_OverflowLevel; StockkeepingUnit."Overflow Level")
{
}
fieldelement(StockkeepingUnit_TransferfromCode; StockkeepingUnit."Transfer-from Code")
{
}
fieldelement(StockkeepingUnit_PutawayTemplateCode; StockkeepingUnit."Put-away Template Code")
{
}
fieldelement(StockkeepingUnit_PutawayUnitofMeasureCode; StockkeepingUnit."Put-away Unit of Measure Code")
{
}
fieldelement(StockkeepingUnit_PhysInvtCountingPeriodCode; StockkeepingUnit."Phys Invt Counting Period Code")
{
}
trigger OnPreXmlItem()
begin
StockkeepingUnit.SetRange("Item No.", FilteredItem."No.");
end;
}
tableelement(invadjmentry; "Inventory Adjmt. Entry (Order)")
{
AutoUpdate = true;
MinOccurs = Zero;
XmlName = 'InvAdjmEntry';
SourceTableView = sorting("Order Type", "Order No.", "Order Line No.");
fieldelement(InvAdjmEntry_OrderType; InvAdjmEntry."Order Type")
{
}
fieldelement(InvAdjmEntry_OrderNo; InvAdjmEntry."Order No.")
{
}
fieldelement(InvAdjmEntry_OrderLineNo; InvAdjmEntry."Order Line No.")
{
}
fieldelement(InvAdjmEntry_ItemNo; InvAdjmEntry."Item No.")
{
}
fieldelement("InvAdjmEntry_RoutingNo."; InvAdjmEntry."Routing No.")
{
}
fieldelement("InvAdjmEntry_RoutingReferenceNo."; InvAdjmEntry."Routing Reference No.")
{
}
fieldelement(InvAdjmEntry_IndirectCostPercentage; InvAdjmEntry."Indirect Cost %")
{
}
fieldelement(InvAdjmEntry_OverheadRate; InvAdjmEntry."Overhead Rate")
{
}
fieldelement(InvAdjmEntry_CostisAdjusted; InvAdjmEntry."Cost is Adjusted")
{
}
fieldelement(InvAdjmEntry_AllowOnlineAdjustment; InvAdjmEntry."Allow Online Adjustment")
{
}
fieldelement(InvAdjmEntry_UnitCost; InvAdjmEntry."Unit Cost")
{
}
fieldelement(InvAdjmEntry_DirectCost; InvAdjmEntry."Direct Cost")
{
}
fieldelement(InvAdjmEntry_IndirectCost; InvAdjmEntry."Indirect Cost")
{
}
fieldelement("InvAdjmEntry_Single-LevelMaterialCost"; InvAdjmEntry."Single-Level Material Cost")
{
}
fieldelement("InvAdjmEntry_Single-LevelCapacityCost"; InvAdjmEntry."Single-Level Capacity Cost")
{
}
fieldelement("InvAdjmEntry_Single-LevelSubcontrd.Cost"; InvAdjmEntry."Single-Level Subcontrd. Cost")
{
}
fieldelement("InvAdjmEntry_Single-LevelCap.OvhdCost"; InvAdjmEntry."Single-Level Cap. Ovhd Cost")
{
}
fieldelement("InvAdjmEntry_Single-LevelMfg.OvhdCost"; InvAdjmEntry."Single-Level Mfg. Ovhd Cost")
{
}
fieldelement(InvAdjmEntry_CompletelyInvoiced; InvAdjmEntry."Completely Invoiced")
{
}
fieldelement(InvAdjmEntry_IsFinished; InvAdjmEntry."Is Finished")
{
}
trigger OnPreXmlItem()
begin
InvAdjmEntry.SetRange("Item No.", FilteredItem."No.");
end;
}
}
}
requestpage
{
layout
{
}
actions
{
}
}
trigger OnPostXmlPort()
begin
if currXMLport.ImportFile() then begin
FinishImport();
Message(ImportOKMsg, FilteredItem."No.", Format(CurrentDateTime - StartTime));
end else
Message(ExportOKMsg, FilteredItem."No.", Format(CurrentDateTime - StartTime));
end;
trigger OnPreXmlPort()
begin
StartTime := CurrentDateTime();
ItemRecRef.Open(Database::Item);
ItemTypeFieldExists := ItemRecRef.FieldExist(10);
ItemRecRef.Close();
end;
var
FilteredItem: Record Item;
ItemRecRef: RecordRef;
TypeFieldRef: FieldRef;
StartTime: DateTime;
ItemTypeFieldExists: Boolean;
ItemTypeInt: Integer;
SingleItemExportOnlyErr: Label 'Select just one item to export.';
ItemLedgEntryNoExistErr: Label 'Item Ledger Entry %1 already exists in the database.\You must delete all entries before continue.', Comment = '%1 = Entry No.';
ExportOKMsg: Label 'Item %1 has been successfully exported in %2.', Comment = '%1 = Item No., %2 = Duration';
ImportOKMsg: Label 'Item %1 has been successfully imported in %2.', Comment = '%1 = Item No., %2 = Duration';
procedure FinishImport()
var
GenPostingSetup2: Record "General Posting Setup";
VATPostingSetup2: Record "VAT Posting Setup";
InvtPostingSetup2: Record "Inventory Posting Setup";
BusinessGroupCode: Code[20];
ProductGroupCode: Code[20];
LocationCode: Code[10];
begin
GenPostingSetup2.SetFilter("Sales Account", '<>%1', '');
GenPostingSetup2.SetFilter("COGS Account", '<>%1', '');
if GenPostingSetup2.FindFirst() then;
VATPostingSetup2.SetFilter("Sales VAT Account", '<>%1', '');
if VATPostingSetup2.FindFirst() then;
InvtPostingSetup2.SetFilter("Inventory Account", '<>%1', '');
if InvtPostingSetup2.FindFirst() then;
GenPostingSetup.FindSet();
repeat
if (GenPostingSetup."Sales Account" = '') and (GenPostingSetup."COGS Account" = '') then begin
BusinessGroupCode := GenPostingSetup."Gen. Bus. Posting Group";
ProductGroupCode := GenPostingSetup."Gen. Prod. Posting Group";
GenPostingSetup.TransferFields(GenPostingSetup2);
GenPostingSetup."Gen. Bus. Posting Group" := BusinessGroupCode;
GenPostingSetup."Gen. Prod. Posting Group" := ProductGroupCode;
GenPostingSetup.Modify();
end;
until GenPostingSetup.Next() = 0;
VatPostingSetup.FindSet();
repeat
if VatPostingSetup."VAT Identifier" = '' then begin
BusinessGroupCode := VatPostingSetup."VAT Bus. Posting Group";
ProductGroupCode := VatPostingSetup."VAT Prod. Posting Group";
VatPostingSetup.TransferFields(VATPostingSetup2);
VatPostingSetup."VAT Bus. Posting Group" := BusinessGroupCode;
VatPostingSetup."VAT Prod. Posting Group" := ProductGroupCode;
VatPostingSetup.Modify();
end;
until VatPostingSetup.Next() = 0;
InventoryPostingSetup.FindSet();
repeat
if InventoryPostingSetup."Inventory Account" = '' then begin
LocationCode := InventoryPostingSetup."Location Code";
ProductGroupCode := InventoryPostingSetup."Invt. Posting Group Code";
InventoryPostingSetup.TransferFields(InvtPostingSetup2);
InventoryPostingSetup."Location Code" := LocationCode;
InventoryPostingSetup."Invt. Posting Group Code" := ProductGroupCode;
InventoryPostingSetup.Modify();
end;
until InventoryPostingSetup.Next() = 0;
end;
procedure CollectItemApplnEntry(ItemLedgEntryNo: Integer)
var
ItemApplnEntry: Record "Item Application Entry";
begin
ItemApplnEntry.SetCurrentKey("Item Ledger Entry No.");
ItemApplnEntry.SetRange("Item Ledger Entry No.", ItemLedgEntryNo);
if ItemApplnEntry.FindSet() then
repeat
TempItemApplnEntry := ItemApplnEntry;
TempItemApplnEntry.Insert();
until ItemApplnEntry.Next() = 0;
end;
procedure CollectItemApplnEntryHist(ItemLedgEntryNo: Integer)
var
ItemApplnEntryHistory: Record "Item Application Entry History";
begin
ItemApplnEntryHistory.SetRange("Item Ledger Entry No.", ItemLedgEntryNo);
if ItemApplnEntryHistory.FindSet() then
repeat
TempItemApplnEntryHistory := ItemApplnEntryHistory;
TempItemApplnEntryHistory.Insert();
until ItemApplnEntryHistory.Next() = 0;
end;
procedure CollectProdOrder(ProdOrderNo: Code[20])
var
ProdOrder: Record "Production Order";
ProdOrderLine: Record "Prod. Order Line";
begin
if ProdOrderNo = '' then
exit;
ProdOrder.SetCurrentKey("No.");
ProdOrder.SetRange("No.", ProdOrderNo);
if ProdOrder.FindFirst() then begin
TempProdOrder := ProdOrder;
if TempProdOrder.Insert() then;
end;
ProdOrderLine.SetCurrentKey("Prod. Order No.");
ProdOrderLine.SetRange("Prod. Order No.", ProdOrderNo);
if ProdOrderLine.FindSet() then
repeat
TempProdOrderLine := ProdOrderLine;
if TempProdOrderLine.Insert() then;
until ProdOrderLine.Next() = 0;
end;
procedure CollectCapValueEntry(CapEntryNo: Integer)
var
ValueEntry: Record "Value Entry";
begin
ValueEntry.SetCurrentKey("Capacity Ledger Entry No.");
ValueEntry.SetRange("Capacity Ledger Entry No.", CapEntryNo);
if ValueEntry.FindSet() then
repeat
TempCapValueEntry := ValueEntry;
TempCapValueEntry.Insert();
until ValueEntry.Next() = 0;
end;
}