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

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