CREATE TABLE [dbo].[1 TEMPLATE$Item](
	[timestamp] [timestamp] NOT NULL,
	[No_] [nvarchar](20) NOT NULL,
	[No_ 2] [nvarchar](20) NOT NULL,
	[Description] [nvarchar](50) NOT NULL,
	[Search Description] [nvarchar](50) NOT NULL,
	[Description 2] [nvarchar](50) NOT NULL,
	[Base Unit of Measure] [nvarchar](10) NOT NULL,
	[Price Unit Conversion] [int] NOT NULL,
	[Type] [int] NOT NULL,
	[Inventory Posting Group] [nvarchar](20) NOT NULL,
	[Shelf No_] [nvarchar](10) NOT NULL,
	[Item Disc_ Group] [nvarchar](20) NOT NULL,
	[Allow Invoice Disc_] [tinyint] NOT NULL,
	[Statistics Group] [int] NOT NULL,
	[Commission Group] [int] NOT NULL,
	[Unit Price] [decimal](38, 20) NOT NULL,
	[Price_Profit Calculation] [int] NOT NULL,
	[Profit _] [decimal](38, 20) NOT NULL,
	[Costing Method] [int] NOT NULL,
	[Unit Cost] [decimal](38, 20) NOT NULL,
	[Standard Cost] [decimal](38, 20) NOT NULL,
	[Last Direct Cost] [decimal](38, 20) NOT NULL,
	[Indirect Cost _] [decimal](38, 20) NOT NULL,
	[Cost is Adjusted] [tinyint] NOT NULL,
	[Allow Online Adjustment] [tinyint] NOT NULL,
	[Vendor No_] [nvarchar](20) NOT NULL,
	[Vendor Item No_] [nvarchar](20) NOT NULL,
	[Lead Time Calculation] [varchar](32) NOT NULL,
	[Reorder Point] [decimal](38, 20) NOT NULL,
	[Maximum Inventory] [decimal](38, 20) NOT NULL,
	[Reorder Quantity] [decimal](38, 20) NOT NULL,
	[Alternative Item No_] [nvarchar](20) NOT NULL,
	[Unit List Price] [decimal](38, 20) NOT NULL,
	[Duty Due _] [decimal](38, 20) NOT NULL,
	[Duty Code] [nvarchar](10) NOT NULL,
	[Gross Weight] [decimal](38, 20) NOT NULL,
	[Net Weight] [decimal](38, 20) NOT NULL,
	[Units per Parcel] [decimal](38, 20) NOT NULL,
	[Unit Volume] [decimal](38, 20) NOT NULL,
	[Durability] [nvarchar](10) NOT NULL,
	[Freight Type] [nvarchar](10) NOT NULL,
	[Tariff No_] [nvarchar](20) NOT NULL,
	[Duty Unit Conversion] [decimal](38, 20) NOT NULL,
	[Country_Region Purchased Code] [nvarchar](10) NOT NULL,
	[Budget Quantity] [decimal](38, 20) NOT NULL,
	[Budgeted Amount] [decimal](38, 20) NOT NULL,
	[Budget Profit] [decimal](38, 20) NOT NULL,
	[Blocked] [tinyint] NOT NULL,
	[Last Date Modified] [datetime] NOT NULL,
	[Last Time Modified] [datetime] NOT NULL,
	[Price Includes VAT] [tinyint] NOT NULL,
	[VAT Bus_ Posting Gr_ (Price)] [nvarchar](20) NOT NULL,
	[Gen_ Prod_ Posting Group] [nvarchar](20) NOT NULL,
	[Picture] [uniqueidentifier] NOT NULL,
	[Country_Region of Origin Code] [nvarchar](10) NOT NULL,
	[Automatic Ext_ Texts] [tinyint] NOT NULL,
	[No_ Series] [nvarchar](20) NOT NULL,
	[Tax Group Code] [nvarchar](20) NOT NULL,
	[VAT Prod_ Posting Group] [nvarchar](20) NOT NULL,
	[Reserve] [int] NOT NULL,
	[Global Dimension 1 Code] [nvarchar](20) NOT NULL,
	[Global Dimension 2 Code] [nvarchar](20) NOT NULL,
	[Stockout Warning] [int] NOT NULL,
	[Prevent Negative Inventory] [int] NOT NULL,
	[Application Wksh_ User ID] [nvarchar](128) NOT NULL,
	[Assembly Policy] [int] NOT NULL,
	[GTIN] [nvarchar](14) NOT NULL,
	[Default Deferral Template Code] [nvarchar](10) NOT NULL,
	[Low-Level Code] [int] NOT NULL,
	[Lot Size] [decimal](38, 20) NOT NULL,
	[Serial Nos_] [nvarchar](20) NOT NULL,
	[Last Unit Cost Calc_ Date] [datetime] NOT NULL,
	[Rolled-up Material Cost] [decimal](38, 20) NOT NULL,
	[Rolled-up Capacity Cost] [decimal](38, 20) NOT NULL,
	[Scrap _] [decimal](38, 20) NOT NULL,
	[Inventory Value Zero] [tinyint] NOT NULL,
	[Discrete Order Quantity] [int] NOT NULL,
	[Minimum Order Quantity] [decimal](38, 20) NOT NULL,
	[Maximum Order Quantity] [decimal](38, 20) NOT NULL,
	[Safety Stock Quantity] [decimal](38, 20) NOT NULL,
	[Order Multiple] [decimal](38, 20) NOT NULL,
	[Safety Lead Time] [varchar](32) NOT NULL,
	[Flushing Method] [int] NOT NULL,
	[Replenishment System] [int] NOT NULL,
	[Rounding Precision] [decimal](38, 20) NOT NULL,
	[Sales Unit of Measure] [nvarchar](10) NOT NULL,
	[Purch_ Unit of Measure] [nvarchar](10) NOT NULL,
	[Time Bucket] [varchar](32) NOT NULL,
	[Reordering Policy] [int] NOT NULL,
	[Include Inventory] [tinyint] NOT NULL,
	[Manufacturing Policy] [int] NOT NULL,
	[Rescheduling Period] [varchar](32) NOT NULL,
	[Lot Accumulation Period] [varchar](32) NOT NULL,
	[Dampener Period] [varchar](32) NOT NULL,
	[Dampener Quantity] [decimal](38, 20) NOT NULL,
	[Overflow Level] [decimal](38, 20) NOT NULL,
	[Manufacturer Code] [nvarchar](10) NOT NULL,
	[Item Category Code] [nvarchar](20) NOT NULL,
	[Created From Nonstock Item] [tinyint] NOT NULL,
	[Product Group Code] [nvarchar](10) NOT NULL,
	[Service Item Group] [nvarchar](10) NOT NULL,
	[Item Tracking Code] [nvarchar](10) NOT NULL,
	[Lot Nos_] [nvarchar](20) NOT NULL,
	[Expiration Calculation] [varchar](32) NOT NULL,
	[Warehouse Class Code] [nvarchar](10) NOT NULL,
	[Special Equipment Code] [nvarchar](10) NOT NULL,
	[Put-away Template Code] [nvarchar](10) NOT NULL,
	[Put-away Unit of Measure Code] [nvarchar](10) NOT NULL,
	[Phys Invt Counting Period Code] [nvarchar](10) NOT NULL,
	[Last Counting Period Update] [datetime] NOT NULL,
	[Use Cross-Docking] [tinyint] NOT NULL,
	[Next Counting Start Date] [datetime] NOT NULL,
	[Next Counting End Date] [datetime] NOT NULL,
	[Routing No_] [nvarchar](20) NOT NULL,
	[Production BOM No_] [nvarchar](20) NOT NULL,
	[Single-Level Material Cost] [decimal](38, 20) NOT NULL,
	[Single-Level Capacity Cost] [decimal](38, 20) NOT NULL,
	[Single-Level Subcontrd_ Cost] [decimal](38, 20) NOT NULL,
	[Single-Level Cap_ Ovhd Cost] [decimal](38, 20) NOT NULL,
	[Single-Level Mfg_ Ovhd Cost] [decimal](38, 20) NOT NULL,
	[Overhead Rate] [decimal](38, 20) NOT NULL,
	[Rolled-up Subcontracted Cost] [decimal](38, 20) NOT NULL,
	[Rolled-up Mfg_ Ovhd Cost] [decimal](38, 20) NOT NULL,
	[Rolled-up Cap_ Overhead Cost] [decimal](38, 20) NOT NULL,
	[Order Tracking Policy] [int] NOT NULL,
	[Critical] [tinyint] NOT NULL,
	[Common Item No_] [nvarchar](20) NOT NULL,
	[Block Reason] [nvarchar](250) NOT NULL,
	[Last DateTime Modified] [datetime] NOT NULL,
	[Id] [uniqueidentifier] NOT NULL,
	[Unit of Measure Id] [uniqueidentifier] NOT NULL,
	[Tax Group Id] [uniqueidentifier] NOT NULL,
 CONSTRAINT [1 TEMPLATE$Item$0] PRIMARY KEY CLUSTERED 
(
	[No_] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Data Filegroup 1]
) ON [Data Filegroup 1]

CREATE TABLE [dbo].[1 TEMPLATE$Item Ledger Entry](
	[timestamp] [timestamp] NOT NULL,
	[Entry No_] [int] NOT NULL,
	[Item No_] [nvarchar](20) NOT NULL,
	[Posting Date] [datetime] NOT NULL,
	[Entry Type] [int] NOT NULL,
	[Source No_] [nvarchar](20) NOT NULL,
	[Document No_] [nvarchar](20) NOT NULL,
	[Description] [nvarchar](50) NOT NULL,
	[Location Code] [nvarchar](10) NOT NULL,
	[Quantity] [decimal](38, 20) NOT NULL,
	[Remaining Quantity] [decimal](38, 20) NOT NULL,
	[Invoiced Quantity] [decimal](38, 20) NOT NULL,
	[Applies-to Entry] [int] NOT NULL,
	[Open] [tinyint] NOT NULL,
	[Global Dimension 1 Code] [nvarchar](20) NOT NULL,
	[Global Dimension 2 Code] [nvarchar](20) NOT NULL,
	[Positive] [tinyint] NOT NULL,
	[Source Type] [int] NOT NULL,
	[Drop Shipment] [tinyint] NOT NULL,
	[Transaction Type] [nvarchar](10) NOT NULL,
	[Transport Method] [nvarchar](10) NOT NULL,
	[Country_Region Code] [nvarchar](10) NOT NULL,
	[Entry_Exit Point] [nvarchar](10) NOT NULL,
	[Document Date] [datetime] NOT NULL,
	[External Document No_] [nvarchar](35) NOT NULL,
	[Area] [nvarchar](10) NOT NULL,
	[Transaction Specification] [nvarchar](10) NOT NULL,
	[No_ Series] [nvarchar](20) NOT NULL,
	[Document Type] [int] NOT NULL,
	[Document Line No_] [int] NOT NULL,
	[Order Type] [int] NOT NULL,
	[Order No_] [nvarchar](20) NOT NULL,
	[Order Line No_] [int] NOT NULL,
	[Dimension Set ID] [int] NOT NULL,
	[Assemble to Order] [tinyint] NOT NULL,
	[Job No_] [nvarchar](20) NOT NULL,
	[Job Task No_] [nvarchar](20) NOT NULL,
	[Job Purchase] [tinyint] NOT NULL,
	[Variant Code] [nvarchar](10) NOT NULL,
	[Qty_ per Unit of Measure] [decimal](38, 20) NOT NULL,
	[Unit of Measure Code] [nvarchar](10) NOT NULL,
	[Derived from Blanket Order] [tinyint] NOT NULL,
	[Cross-Reference No_] [nvarchar](20) NOT NULL,
	[Originally Ordered No_] [nvarchar](20) NOT NULL,
	[Originally Ordered Var_ Code] [nvarchar](10) NOT NULL,
	[Out-of-Stock Substitution] [tinyint] NOT NULL,
	[Item Category Code] [nvarchar](20) NOT NULL,
	[Nonstock] [tinyint] NOT NULL,
	[Purchasing Code] [nvarchar](10) NOT NULL,
	[Product Group Code] [nvarchar](10) NOT NULL,
	[Completely Invoiced] [tinyint] NOT NULL,
	[Last Invoice Date] [datetime] NOT NULL,
	[Applied Entry to Adjust] [tinyint] NOT NULL,
	[Correction] [tinyint] NOT NULL,
	[Shipped Qty_ Not Returned] [decimal](38, 20) NOT NULL,
	[Prod_ Order Comp_ Line No_] [int] NOT NULL,
	[Serial No_] [nvarchar](20) NOT NULL,
	[Lot No_] [nvarchar](20) NOT NULL,
	[Warranty Date] [datetime] NOT NULL,
	[Expiration Date] [datetime] NOT NULL,
	[Item Tracking] [int] NOT NULL,
	[Return Reason Code] [nvarchar](10) NOT NULL,
 CONSTRAINT [1 TEMPLATE$Item Ledger Entry$0] PRIMARY KEY CLUSTERED 
(
	[Entry No_] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Data Filegroup 1]
) ON [Data Filegroup 1]