C11/System/NAVISION/SQL/schema/NAVISION_BYD/tables/import.User_Setup.sql

CREATE TABLE [import].[User_Setup] (
   [timestamp] [timestamp] NOT NULL,
   [User ID] [varchar](20) NOT NULL,
   [Allow Posting From] [datetime] NOT NULL,
   [Allow Posting To] [datetime] NOT NULL,
   [Register Time] [tinyint] NOT NULL,
   [Main Menu ID] [int] NOT NULL,
   [Allow FA Posting From] [datetime] NOT NULL,
   [Allow FA Posting To] [datetime] NOT NULL,
   [Template Code] [varchar](20) NOT NULL,
   [Check for Internal Customer] [int] NOT NULL,
   [Check if Time below Used Time] [int] NOT NULL,
   [Check for Empty Price Fields] [int] NOT NULL,
   [Charging Price Changeable] [tinyint] NOT NULL,
   [Edit Radio Codes] [tinyint] NOT NULL,
   [Change Vehicle Status] [tinyint] NOT NULL,
   [Cash Register Access] [tinyint] NOT NULL,
   [Employee No_] [varchar](20) NOT NULL,
   [Cash Register Password] [varchar](20) NOT NULL,
   [Cash Reg_ Access Permitted] [tinyint] NOT NULL,
   [TM in Service Orders Enabled] [tinyint] NOT NULL,
   [Select Document Status] [tinyint] NOT NULL,
   [TimeClock Jrnl_Correction Mode] [tinyint] NOT NULL,
   [Post Receipt] [tinyint] NOT NULL,
   [Post Purchase Invoice] [tinyint] NOT NULL,
   [Show G_L Entries] [tinyint] NOT NULL,
   [Post Shipment] [tinyint] NOT NULL,
   [Post Sales Invoice] [tinyint] NOT NULL,
   [Ship Service Item] [tinyint] NOT NULL,
   [Ship Service Labor] [tinyint] NOT NULL,
   [Ship Service Ext_ Services] [tinyint] NOT NULL,
   [Ship Service G_L Account] [tinyint] NOT NULL,
   [Time Management Access] [tinyint] NOT NULL,
   [TimeClockCorr_Mode Password] [varchar](20) NOT NULL,
   [Update Information] [tinyint] NOT NULL,
   [SA3 Enabled] [tinyint] NOT NULL,
   [SAM2 Enabled] [tinyint] NOT NULL,
   [APAS Enabled] [tinyint] NOT NULL,
   [EPC Enabled] [tinyint] NOT NULL,
   [Phys_ Inventory Password] [varchar](20) NOT NULL,
   [CRM Enabled] [tinyint] NOT NULL,
   [CRM Dealer Admin] [tinyint] NOT NULL,
   [CRM Complaint Manager] [tinyint] NOT NULL,
   [CRM Complaint Resolution Role] [tinyint] NOT NULL,
   [CRM Campaign Manager] [tinyint] NOT NULL,
   [CRM Campaign List Responsible] [tinyint] NOT NULL,
   [CRM Lead Manager] [tinyint] NOT NULL,
   [CRM Lead Response Recorder] [tinyint] NOT NULL,
   [CRM - CSM Manager] [tinyint] NOT NULL,
   [CRM Data Admin] [tinyint] NOT NULL,
   [Bulk Customer data management] [tinyint] NOT NULL,
   [Salesperson] [varchar](20) NOT NULL,
   [Salesperson Role] [int] NOT NULL,
   [Delete prospect] [tinyint] NOT NULL,
   [Outlook Integration] [tinyint] NOT NULL,
   [Outlook Reminder] [int] NOT NULL,
   [Insert Foreign Contacts] [tinyint] NOT NULL,
   [Delete closed Contacts] [int] NOT NULL,
   [Delete User specific] [varchar](10) NOT NULL,
   [Customercard Access] [tinyint] NOT NULL,
   [Prospectcard Access] [tinyint] NOT NULL,
   [Vehiclecard Access] [tinyint] NOT NULL,
   [Customercard editable] [tinyint] NOT NULL,
   [Prospectcard editable] [tinyint] NOT NULL,
   [Vehiclecard editable] [tinyint] NOT NULL,
   [Delete closed Contact allowed] [tinyint] NOT NULL,
   [Open Contacts automatically] [tinyint] NOT NULL,
   [Periode Post_ auto_ maintain] [tinyint] NOT NULL,
   [Labor Price Group] [tinyint] NOT NULL,
   [Ext_ Service Price Group] [tinyint] NOT NULL,
   [Vehicle Sales Price Group] [tinyint] NOT NULL,
   [Option Sales Price Group] [tinyint] NOT NULL,
   [Item Sales Price Group] [tinyint] NOT NULL,
   [Gen_ Bus_ Posting Group] [tinyint] NOT NULL,
   [VAT Bus_ Posting Group] [tinyint] NOT NULL,
   [Payment Method Code (Cust_)] [tinyint] NOT NULL,
   [Payment Terms Code (Cust_)] [tinyint] NOT NULL,
   [Item Purch_ Price Group] [tinyint] NOT NULL,
   [Vehicle Purch_ Price Group] [tinyint] NOT NULL,
   [Option Purch_ Price Group] [tinyint] NOT NULL,
   [Payment Method Code (Vend_)] [tinyint] NOT NULL,
   [Payment Terms Code (Vend_)] [tinyint] NOT NULL,
   [Vendorcard Access] [tinyint] NOT NULL,
   [Vendorcard editable] [tinyint] NOT NULL,
   [Blocking (Customer)] [tinyint] NOT NULL,
   [Blocking (Vendor)] [tinyint] NOT NULL,
   [Service Advisor No_] [varchar](10) NOT NULL,
   [TimeClock OrderFilter] [tinyint] NOT NULL,
   [Background Posting Priority] [int] NOT NULL,
   [Reposting Priority] [int] NOT NULL,
   [Background Posting Admin] [tinyint] NOT NULL,
   [Bgr_Idle Period] [varchar](30) NOT NULL,
   [Open Report for Print] [tinyint] NOT NULL,
   [Release Work Completed allowed] [tinyint] NOT NULL,
   [ServiceOrderDefaultType] [int] NOT NULL,
   [AUDATEX Login Name] [varchar](30) NOT NULL,
   [AUDATEX Password] [varchar](30) NOT NULL,
   [Allow Item Journal Posting] [tinyint] NOT NULL,
   [Set Not Accident Free Allowed] [tinyint] NOT NULL,
   [Show Only Own Data] [tinyint] NOT NULL,
   [Undo Shop Service Item] [tinyint] NOT NULL,
   [Credit Memo without Invoice] [tinyint] NOT NULL,
   [Defaults Changed Manually] [tinyint] NOT NULL,
   [Default Service Advisor No_] [tinyint] NOT NULL,
   [Default Salespers__Purch_ Code] [tinyint] NOT NULL,
   [Salespers__Purch_ Code] [varchar](10) NOT NULL,
   [Man_ Serv_ Adv_] [tinyint] NOT NULL,
   [Man_ Salesp__Purch_] [tinyint] NOT NULL,
   [Change Retention Period] [tinyint] NOT NULL,
   [Allow Anonymization] [tinyint] NOT NULL,
   [Allow RSP SetupMig] [tinyint] NOT NULL,
   [Allow ISPA Setup] [tinyint] NOT NULL,
   [RSP View deactivate] [tinyint] NOT NULL,
   [GMB Show Dialogs] [tinyint] NOT NULL,
   [Goods Invoice posting allowed] [tinyint] NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

   ,CONSTRAINT [User_Setup$0] PRIMARY KEY CLUSTERED ([User ID], [Client_DB])
)


GO