C11/System/ARI/SQL/schema/GC_ETL_ARI/views/xtract.Item.sql

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[Item] AS
SELECT [timestamp]
     , [No_]
--      , [No_ 2]
     , [Description]
--      , [Search Description]
--      , [Description 2]
--      , [Class]
--      , [Base Unit of Measure]
--      , [Price Unit Conversion]
--      , [Inventory Posting Group]
--      , [Shelf No_]
--      , [Sales Qty_ Disc_ Code]
--      , [Cust__Item Disc_ Gr_]
--      , [Allow Invoice Disc_]
--      , [Statistics Group]
--      , [Commission Group]
--      , [Unit Price]
--      , [Price_Profit Calculation]
--      , [Profit _]
--      , [Costing Method]
--      , [Unit Cost]
--      , [Standard Cost]
--      , [Last Direct Cost]
--      , [Average Cost]
--      , [Minimum Unit Price]
--      , [Indirect Cost _]
--      , [Cost is Adjusted]
--      , [Vendor No_]
--      , [Vendor Item No_]
--      , [Lead Time Calculation]
--      , [Reorder Point]
--      , [Maximum Inventory]
--      , [Reorder Quantity]
--      , [Alternative Item No_]
--      , [Unit List Price]
--      , [Duty Due _]
--      , [Duty Code]
--      , [Gross Weight]
--      , [Net Weight]
--      , [Units per Parcel]
--      , [Unit Volume]
--      , [Durability]
--      , [Freight Type]
--      , [Tariff No_]
--      , [Duty Unit Conversion]
--      , [Country Purchased Code]
--      , [Budget Quantity]
--      , [Budgeted Amount]
--      , [Budget Profit]
--      , [Blocked]
--      , [Last Date Modified]
--      , [Price Includes VAT]
--      , [VAT Bus_ Posting Gr_ (Price)]
--      , [Gen_ Prod_ Posting Group]
--      , [Picture]
--      , [Country of Origin Code]
--      , [Automatic Ext_ Texts]
--      , [No_ Series]
--      , [Tax Group Code]
--      , [VAT Prod_ Posting Group]
--      , [Reserve]
--      , [Average Cost (Add_ Curr_)]
--      , [Global Dimension 1 Code]
--      , [Stockout Warning]
--      , [Prevent Negative Inventory]
--      , [Application Wksh_ User ID]
--      , [Low-Level Code]
--      , [Lot Size]
--      , [Serial Nos_]
--      , [Last Unit Cost Calc_ Date]
--      , [Material Cost per Unit]
--      , [Labor Cost per Unit]
--      , [Indirect Cost per Unit]
--      , [Scrap _]
--      , [Requisition Method Code]
--      , [Inventory Value Zero]
--      , [Combine No_ of Cycles]
--      , [Minimum Order Quantity]
--      , [Maximum Order Quantity]
--      , [Inventory Buffer Quantity]
--      , [Order Multiple]
--      , [Safety Lead Time]
--      , [Posting Method]
--      , [Requisition System]
--      , [Rounding Precision]
--      , [Sales Unit of Measure Code]
--      , [Purch_ Unit of Measure Code]
--      , [Reorder Cycle]
--      , [No Inventory Tracking]
--      , [List Price (LCY)]
--      , [Item Group Code]
--      , [Manual Price Calculation]
--      , [Unit Price incl_ VAT]
--      , [Deposit for Main Item]
--      , [Item Type]
--      , [Make Code]
--      , [Vehicle Type Code]
--      , [Vehicle Category Code]
--      , [Emissions Test Category Code]
--      , [Engine Code]
--      , [Model Code]
--      , [Warranty Percentage]
--      , [Valid-From Date]
--      , [Engine Type Code]
--      , [Transmission Type Code]
--      , [Cylinder Capacity (ccm)]
--      , [No_ of Cylinders]
--      , [Power (kW)]
--      , [Power (hp)]
--      , [Tires]
--      , [Empty Weight (kg)]
--      , [Total Weight (kg)]
--      , [Roof Load (kg)]
--      , [Trailer Load (kg)]
--      , [Trailer Tongue Load (kg)]
--      , [4WD]
--      , [No_ of Axles]
--      , [Wheelbase (mm)]
--      , [Front Axle Load (kg)]
--      , [Rear Axle Load (kg)]
--      , [Market Segment Code]
--      , [No_ of Doors]
--      , [Vehicle Type]
--      , [Minimum Purchase Qty_ (Base)]
--      , [Manufacturer Req_ Status]
--      , [Requisition Status]
--      , [Requisition Group]
--      , [Manual Requisition]
--      , [Blocked Qty_]
--      , [Main Group Code]
--      , [Subgroup Code]
--      , [Line Group Code]
--      , [Labor Type]
--      , [Replacement Status]
--      , [Old Replacement Status]
--      , [Update Description]
--      , [Allow Discount]
--      , [List Price incl_ VAT (LCY)]
--      , [Labor Charging Code]
--      , [Rpl_ Status Reset User ID]
--      , [Rpl_ Status Reset Date]
--      , [Sending Required]
--      , [Option Class]
--      , [No Service Surcharge]
--      , [Last Time Modified]
--      , [Creation Date]
--      , [Creation Time]
--      , [Deposit Validity in Days]
--      , [Print Options]
--      , [Print Unit Price]
--      , [Valid-To Date]
--      , [Not Available for New Sales]
--      , [Coded Part Type]
--      , [Model Year]
--      , [Top Speed]
--      , [Acceleration]
--      , [Desc_ Trans_ to Vehicle Option]
--      , [Last Landed Unit Cost]
--      , [Duty Due Amount]
--      , [Freight _]
--      , [Freight Amount]
--      , [Supply Req_ Worksheet Template]
--      , [Ext_ Warehouse Inventory]
--      , [ABC Code]
--      , [Pick Release Code]
--      , [Special Waste]
--      , [Special Waste Group Code]
--      , [Dangerous Goods Indicator]
--      , [Dangerous Goods Code]
--      , [No_ of Seats]
--      , [Dangerous Goods Class]
--      , [UN No_]
--      , [Seasonal Factor]
--      , [Manual Requisition from Date]
--      , [Min_ Packaging Qty_ (Base)]
--      , [Replenishment Flag Code]
--      , [Manufacturer Line Count]
--      , [Manufacturer Req_ from Date]
--      , [Bulk Pack Quantity (Base)]
--      , [Manufacturer Req_ Remark]
--      , [Update Alternative Parts Prio_]
--      , [Original Part]
--      , [Quality]
--      , [Proposal for Alternative Part]
--      , [Manufacturer No_]
--      , [Select Unit Price]
--      , [Accept posting group from Veh_]
--      , [e-Part]
--      , [Bonus Code]
--      , [Ship Proposal Transfer Prio]
--      , [Check of Serial No_]
--      , [National Tariff No_]
--      , [Parts Category]
--      , [Parts Family]
--      , [Container Package Qty_ (Base)]
--      , [Distribution Code]
--      , [Maximum Inventory Limit]
--      , [Manuf_ Replacement Status]
--      , [Emission Standard Code]
--      , [Diesel Particulate Filter]
--      , [Template Code]
--      , [Tire Item]
--      , [EU Tire Data Code]
--      , [Inverse Item No_]
--      , [Drive]
--      , [Engine Speed Rate Output]
--      , [Maximum Torque]
--      , [Axle -3 Load (kg)]
--      , [Axle -4 Load (kg)]
--      , [Length (mm)]
--      , [Width (mm)]
--      , [Height (mm)]
--      , [Common Item No_]
     , [Client_DB]
FROM [GC_TRANSIT_ARI].[import].[Item]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO