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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[Service_Header] AS
SELECT [timestamp]
     , [Document Type]
     , [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]
     , [Order Date]
--      , [Posting Date]
--      , [Posting Description]
--      , [Payment Terms Code]
--      , [Due Date]
--      , [Payment Discount _]
--      , [Pmt_ Discount Date]
--      , [Shipment Method Code]
     , [Location Code]
     , [Department Code]
     , [Make Code]
--      , [Customer Posting Group]
--      , [Currency Code]
--      , [Currency Factor]
--      , [Price Group Code]
--      , [Prices Including VAT]
--      , [Allow Quantity Disc_]
--      , [Cust__Item Disc_ Gr_]
--      , [Language Code]
--      , [Salesperson Code]
--      , [Order Class]
--      , [No_ Printed]
--      , [On Hold]
--      , [Bal_ Account No_]
--      , [Shipping No_]
--      , [Posting No_]
--      , [Last Shipping No_]
--      , [Last Posting No_]
--      , [VAT Registration No_]
--      , [Combine Shipments]
--      , [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 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_]
--      , [No_ Series]
--      , [Posting No_ Series]
--      , [Shipping No_ Series]
--      , [Tax Area Code]
--      , [Tax Liable]
--      , [VAT Bus_ Posting Group]
--      , [Reserve]
--      , [Applies-to ID]
--      , [VAT Base Discount _]
--      , [Option Code]
--      , [Dimension Set ID]
--      , [Last Changed]
--      , [Message Notification]
--      , [Messaging App Type]
--      , [Message Type]
--      , [Service Posting Group]
     , [VIN]
--      , [License No_]
--      , [Mileage]
--      , [Model Code]
--      , [Model No_]
--      , [Prod_ Year]
     , [Model]
--      , [Type]
--      , [Initial Registration]
--      , [Gen_ Prod_ Posting Group]
--      , [Order Limit]
--      , [Time of Order]
     , [Pickup Date]
--      , [Pickup Time]
--      , [Sell-to Home Phone No_]
--      , [Sell-to Phone No_]
--      , [Sell-to Mobile Phone No_]
     , [Service Advisor No_]
--      , [Invoice Copies]
--      , [Completion Date]
--      , [Completion Time]
--      , [Sell-to Home Mobile Phone No_]
--      , [Engine Code]
--      , [Engine No_]
--      , [Customer Registration Date]
--      , [Engine Type Code]
--      , [No_ of Cylinders]
--      , [Cylinder Capacity (ccm)]
--      , [Power (kW)]
--      , [Power (hp)]
--      , [Transmission Type Code]
--      , [Tires]
--      , [No_ of Doors]
--      , [No_ of Axles]
--      , [4WD]
--      , [Market Segment Code]
--      , [Vehicle Category Code]
--      , [Vehicle Type Code]
--      , [Emissions Test Category Code]
--      , [Labor Type]
--      , [Labor Charging Code]
--      , [Labor Price Group]
--      , [Ext_ Service Price Group]
--      , [WIP Posting]
--      , [Book No_]
--      , [Branch Book No_]
--      , [Item Sales Price Group]
--      , [Show Discount]
--      , [Sales Department Code]
--      , [Copy Header Text to Next Doc_]
--      , [Copy Footer Text to Next Doc_]
--      , [Add Service Surcharges]
--      , [Post with Book No_]
--      , [Color Class]
--      , [Upholstery Class]
--      , [Fixed Date]
--      , [Fixed Instruction]
--      , [Current Instruction Type]
--      , [Branch Code]
--      , [Work Completed]
--      , [Status Code]
--      , [Internal Document No_ Series]
--      , [Internal Document No_]
--      , [Service Advisor No__Pick-Up]
--      , [Use Inventory Buffer Quantity]
--      , [Sales Branch Code]
--      , [Fabrication Code]
--      , [Purch_ Document Type]
--      , [Purch_ Document No_]
--      , [Purch_ Document Line No_]
--      , [Mileage At Order Creation]
--      , [Running Time]
--      , [Running Time At Order Creation]
--      , [No_ of Seats]
--      , [Disable for Requisition]
--      , [Req_ Wksh_ Template Name]
--      , [Requisition Wksh_ Name]
--      , [Mobile Service]
--      , [Proposal for Alternative Part]
--      , [Time Control activated]
--      , [Sell-to Contact No_]
--      , [Bill-to Contact No_]
--      , [First Shipment Date]
--      , [Last Shipment Date]
--      , [FilterLineNo]
--      , [Update Labor Clocking in Order]
--      , [Message Created from Batch]
--      , [Guide No_]
--      , [Warranty Status Code]
--      , [No_ of Warr_ Claims expected]
--      , [Vehicle Sell-to Customer No_]
--      , [Created by User ID]
--      , [Customer is waiting]
--      , [Fuel Level]
--      , [Liters]
--      , [Battery Voltage]
--      , [Document Chain No_]
--      , [Pickup DateTime]
--      , [Print Fixed Unit Price]
--      , [Show Fair Deal]
--      , [Show No-Charge Lines]
--      , [Customer for No-Charge Lines]
--      , [Text 1]
--      , [Text 2]
--      , [Text 3]
--      , [Text 4]
--      , [Text 5]
--      , [Text 6]
--      , [Extra Code 1]
--      , [Extra Code 2]
--      , [Extra Code 3]
--      , [Boolean 1]
--      , [Boolean 2]
--      , [Date 1]
--      , [Date 2]
--      , [Decimal 1]
--      , [Decimal 2]
--      , [Integer 1]
--      , [Integer 2]
--      , [Integer 3]
--      , [Integer 4]
--      , [Task Type]
--      , [Work Status Code]
--      , [Creation Date]
--      , [Creation Time]
--      , [Resource Time Split Type]
--      , [Drive]
--      , [Driver Address No_]
--      , [Vehicle in House]
--      , [Print Service Job Fixed Price]
--      , [Valid-to Date]
--      , [Appointment Date]
--      , [Appointment Time]
--      , [Do Not Sync To Web Apps]
--      , [VAT Calculation Logic]
--      , [Virtual Record]
--      , [EU Fuel Cons_ Rept_ Refusal]
     , [Client_DB]
FROM [GC_TRANSIT_ARI].[import].[Service_Header]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO