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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[Customer] AS
SELECT [timestamp]
     , [No_]
     , [Name]
--      , [Search Name]
--      , [Name 2]
--      , [Address]
--      , [Address 2]
--      , [City]
--      , [Contact]
--      , [Phone No_]
--      , [Telex No_]
--      , [Document Sending Profile]
--      , [Our Account No_]
--      , [Territory Code]
--      , [Global Dimension 1 Code]
--      , [Global Dimension 2 Code]
--      , [Chain Name]
--      , [Budgeted Amount]
--      , [Credit Limit (LCY)]
--      , [Customer Posting Group]
--      , [Currency Code]
--      , [Customer Price Group]
--      , [Language Code]
--      , [Statistics Group]
--      , [Payment Terms Code]
--      , [Fin_ Charge Terms Code]
--      , [Salesperson Code]
--      , [Shipment Method Code]
--      , [Shipping Agent Code]
--      , [Place of Export]
--      , [Invoice Disc_ Code]
--      , [Customer Disc_ Group]
--      , [Country_Region Code]
--      , [Collection Method]
--      , [Amount]
--      , [Blocked]
--      , [Invoice Copies]
--      , [Last Statement No_]
--      , [Print Statements]
--      , [Bill-to Customer No_]
--      , [Priority]
--      , [Payment Method Code]
--      , [Last Date Modified]
--      , [Application Method]
--      , [Prices Including VAT]
--      , [Location Code]
--      , [Fax No_]
--      , [Telex Answer Back]
--      , [VAT Registration No_]
--      , [Combine Shipments]
     , [Gen_ Bus_ Posting Group]
--      , [Picture]
--      , [GLN]
--      , [Post Code]
--      , [County]
--      , [E-Mail]
--      , [Home Page]
--      , [Reminder Terms Code]
--      , [No_ Series]
--      , [Tax Area Code]
--      , [Tax Liable]
--      , [VAT Bus_ Posting Group]
--      , [Reserve]
--      , [Block Payment Tolerance]
--      , [IC Partner Code]
--      , [Prepayment _]
--      , [Partner Type]
--      , [Preferred Bank Account]
--      , [Cash Flow Payment Terms Code]
--      , [Primary Contact No_]
--      , [Responsibility Center]
--      , [Shipping Advice]
--      , [Shipping Time]
--      , [Shipping Agent Service Code]
--      , [Service Zone Code]
--      , [Allow Line Disc_]
--      , [Base Calendar Code]
--      , [Copy Sell-to Addr_ to Qte From]
--      , [Home Phone No_]
--      , [Mobile Phone No_]
--      , [Service Advisor No_]
--      , [Branch Posting Group]
--      , [Address No_]
--      , [Date of Update]
--      , [Time of Update]
--      , [Updated by User ID]
--      , [Update Company]
     , [Last Name]
     , [First Name]
--      , [Address Salutation Code]
--      , [Letter Salutation Code]
--      , [Bulk Customer No_]
--      , [Title Code]
--      , [Customer Type]
--      , [Labor Price Group]
--      , [Ext_ Service Price Group]
--      , [Vehicle Sales Price Group]
--      , [Item Sales Price Group]
--      , [Employee No_]
--      , [Home Fax No_]
--      , [Home Mobile Phone No_]
--      , [Home E-Mail]
--      , [Home Page 2]
--      , [Date 1]
--      , [Date 2]
--      , [Extra Code 1]
--      , [Extra Code 2]
--      , [Extra Code 3]
--      , [Text 1]
--      , [Text 2]
--      , [Text 3]
--      , [Text 4]
--      , [Text 5]
--      , [Text 6]
--      , [Distribute Blocked Field]
--      , [Show Discount]
--      , [Inv_ Discount _]
--      , [Option Sales Price Group]
     , [Customer Group Code]
--      , [Add Service Surcharges]
--      , [Creation Date]
--      , [Respect Inv_ Buffer Quantity]
--      , [Transfer Method]
--      , [Partner Code]
--      , [Proposal for Alternative Part]
--      , [Date of Birth]
--      , [Disable Applies-to Doc_ No_]
--      , [EU Business Customer]
--      , [Search Result Ranking]
--      , [Action triggered by Card Page]
--      , [Disable for Requisition]
--      , [Messaging App ID]
--      , [Messaging App Type]
--      , [Message Type]
--      , [Message Notification]
--      , [Message Notification App Type]
--      , [OPP DD Follow Up Letter Code]
--      , [OPP Association No_]
--      , [OPP Association Sort Code]
--      , [OPP Balance Acknowledgmt_ Code]
--      , [OPP Last Posting at]
--      , [OPP Bal_ Ack_ Shipping Address]
--      , [OPP Bal_ Ack_ Shipping Type]
--      , [OPP Advice Shipping Type]
--      , [OPP Advice Shipping Address]
--      , [Traffic Light]
--      , [Traffic Light Value]
--      , [Template Code]
--      , [Type]
--      , [Apply Remaining Cust_ Amount]
--      , [Consider Price Calculation]
--      , [Credit Limit After Sales (LCY)]
--      , [Credit Limit Vehicles (LCY)]
--      , [Main Area Filter]
--      , [Disable Remarks]
--      , [Tour Code]
--      , [eDoc_ Exchange Profile]
--      , [OPP Installment Template]
--      , [OPP Installment Template Type]
--      , [OPP Value Date Calculation]
--      , [VAT Calculation Logic]
     , [Client_DB]
FROM [GC_TRANSIT_ARI].[import].[Customer]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO