ETL_DWH_ARI/schema/GC_ETL_ARI/views/xtract.Sales_Invoice_Header.sql

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[Sales_Invoice_Header] AS
SELECT [timestamp]
     , [No_]
     , [Sell-to Customer No_]
     , [Bill-to Customer No_]
--      , [Bill-to Name]
--      , [Bill-to Name 2]
--      , [Bill-to Address]
--      , [Bill-to Address 2]
--      , [Bill-to City]
--      , [Bill-to Contact]
--      , [Your Reference]
--      , [Ship-to Code]
--      , [Ship-to Name]
--      , [Ship-to Name 2]
--      , [Ship-to Address]
--      , [Ship-to Address 2]
--      , [Ship-to City]
--      , [Ship-to Contact]
--      , [Order Date]
     , [Posting Date]
--      , [Shipment Date]
--      , [Posting Description]
--      , [Payment Terms Code]
--      , [Due Date]
--      , [Payment Discount _]
--      , [Pmt_ Discount Date]
--      , [Shipment Method Code]
     , [Location Code]
--      , [Shortcut Dimension 1 Code]
     , [Shortcut Dimension 2 Code]
     , [Customer Posting Group]
--      , [Currency Code]
--      , [Currency Factor]
--      , [Price Group Code]
--      , [Prices Including VAT]
--      , [Allow Quantity Disc_]
--      , [Invoice Disc_ Code]
--      , [Cust__Item Disc_ Gr_]
--      , [Language Code]
     , [Salesperson Code]
     , [Order No_]
--      , [No_ Printed]
--      , [On Hold]
--      , [Applies-to Doc_ Type]
--      , [Applies-to Doc_ No_]
--      , [Bal_ Account No_]
--      , [VAT Registration No_]
--      , [Reason Code]
--      , [Gen_ Bus_ Posting Group]
--      , [EU 3-Party Trade]
--      , [Transaction Type]
--      , [Transport Method]
--      , [VAT Country Code]
--      , [Sell-to Customer Name]
--      , [Sell-to Customer Name 2]
--      , [Sell-to Address]
--      , [Sell-to Address 2]
--      , [Sell-to City]
--      , [Sell-to Contact]
--      , [Bill-to Post Code]
--      , [Bill-to County]
--      , [Bill-to Country Code]
--      , [Sell-to Post Code]
--      , [Sell-to County]
--      , [Sell-to Country Code]
--      , [Ship-to Post Code]
--      , [Ship-to County]
--      , [Ship-to Country Code]
--      , [Bal_ Account Type]
--      , [Exit Point]
--      , [Correction]
--      , [Document Date]
--      , [External Document No_]
--      , [Area]
--      , [Transaction Specification]
--      , [Payment Method Code]
--      , [Shipping Agent Code]
--      , [Package Tracking No_]
--      , [Pre-Assigned No_ Series]
     , [No_ Series]
     , [Order No_ Series]
--      , [Pre-Assigned No_]
     , [User ID]
--      , [Source Code]
--      , [Tax Area Code]
--      , [Tax Liable]
--      , [VAT Bus_ Posting Group]
--      , [VAT Base Discount _]
--      , [Payment Reference]
--      , [Dimension Set ID]
--      , [Document Exchange Identifier]
--      , [Document Exchange Status]
--      , [Doc_ Exch_ Original Identifier]
--      , [Direct Debit Mandate ID]
--      , [Sell-to Contact No_]
--      , [Bill-to Contact No_]
--      , [Opportunity No_]
--      , [Order Type]
--      , [Customer Confirmation Date]
--      , [Price Freeze Until]
     , [Service Order No_]
--      , [Item Sales Price Group]
--      , [Show Discount]
--      , [Purch_ Order Type]
--      , [Inv_ Discount _]
--      , [Sell-to Salutation Code]
--      , [Bill-to Salutation Code]
--      , [Ship-to Addr_ Salutation Code]
--      , [Vehicle Sales Price Group]
--      , [Option Sales Price Group]
--      , [Copy Header Text to Next Doc_]
--      , [Copy Footer Text to Next Doc_]
--      , [Customer Group Code]
--      , [Cockpit Entry No_]
--      , [Service Order No_ 2]
     , [Service Order Line No_]
--      , [Cockpit Posting Entry No_]
--      , [Transfer Method]
--      , [First Shipment Date]
--      , [Last Shipment Date]
--      , [Main Shipment Date]
--      , [Branch Code]
--      , [Vehicle Unit Price Date]
--      , [Dealer Code]
--      , [Dealer Confirmed]
--      , [Dealer Confirmed Date]
--      , [Dealer Confirmed Time]
--      , [Dealer Confirmed User Code]
--      , [Dealer Reason Code]
--      , [Authorisation  No_]
     , [Supply VIN]
--      , [Reference License No_]
--      , [Cash Payment]
--      , [Cash Payment Document Type]
--      , [Cash Register Receipt]
--      , [Activities Created]
--      , [Disable for Requisition]
--      , [Warranty Lock]
--      , [Customer Contact Program]
--      , [Mobile Service]
--      , [Proposal for Alternative Part]
--      , [Service Contract Lock]
--      , [OPP Payment Bank Code]
--      , [OPP Mandate ID]
--      , [OPP QR Code]
     , [Service Advisor No_]
--      , [Service Advisor No__Pick-Up]
--      , [Prepayment]
--      , [Prepayment Order No_]
--      , [Prepayment Assignment]
--      , [Salesperson Code 2]
--      , [Messaging App Type]
--      , [Message Type]
--      , [Message Notification]
--      , [Document Chain No_]
--      , [External Purch_ Order Date]
--      , [OPP Installment Template]
--      , [OPP Installment Template Type]
--      , [VAT Calculation Logic]
--      , [General Document]
--      , [Doc_ Unique Id]
     , [Client_DB]
FROM [GC_TRANSIT_ARI].[import].[Sales_Invoice_Header]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO