SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW [xtract].[Value_Entry] AS SELECT [timestamp] -- , [Entry No_] -- , [Item No_] -- , [Posting Date] -- , [Item Ledger Entry Type] -- , [Source No_] , [Document No_] -- , [Description] -- , [Location Code] -- , [Inventory Posting Group] -- , [Source Posting Group] -- , [Item Ledger Entry No_] -- , [Valued Quantity] -- , [Item Ledger Entry Quantity] , [Invoiced Quantity] -- , [Cost per Unit] -- , [Amount] -- , [Salespers__Purch_ Code] -- , [Discount Amount] -- , [User ID] -- , [Source Code] -- , [Applies-to Entry] -- , [Global Dimension 1 Code] -- , [Global Dimension 2 Code] -- , [Source Type] -- , [Adjusted Cost] -- , [Cost Posted to G_L] -- , [Reason Code] -- , [Drop Shipment] -- , [Journal Batch Name] -- , [Gen_ Bus_ Posting Group] -- , [Gen_ Prod_ Posting Group] -- , [Document Date] -- , [External Document No_] -- , [Adjusted Cost (ACY)] -- , [Cost Posted to G_L (ACY)] -- , [Cost per Unit (ACY)] -- , [Document Line No_] -- , [Order Line No_] -- , [Expected Cost] -- , [Item Charge No_] -- , [Valued by Average Cost] -- , [Partial Revaluation] -- , [Inventoriable] -- , [Valuation Date] -- , [Entry Type] -- , [Variance Type] -- , [G_L Entry No_ (Account)] -- , [G_L Entry No_ (Bal_ Account)] -- , [Dimension Set ID] -- , [Book No_] -- , [Prod_ Order No_] -- , [Variant Code] -- , [Bin Code] -- , [Adjustment] -- , [Capacity Ledger Entry No_] -- , [Type] -- , [No_] -- , [Prod_ Order Line No_] -- , [Return Reason Code] , [Item Type] -- , [Invoice Discount] -- , [Quantity Discount] -- , [Sales Discount] -- , [Sales Surcharge] -- , [Main Area] -- , [Source No_ (Payment)] -- , [Order No_] -- , [Deposit Item] -- , [Branch Code] -- , [Creation Date] -- , [Creation Time] -- , [VIN] -- , [Split Amount] -- , [Split Amount (ACY)] -- , [Division Code] -- , [ABC Rank] -- , [Purch__Sales Order Type] -- , [Purch__Sales Order No_] -- , [Factory No_] -- , [Int_ Customer Portion _] -- , [Vehicle Status] -- , [Salesperson Code 2] , [Client_DB] FROM [GC_TRANSIT_ARI].[import].[Value_Entry] GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO GO