--WICHTIG!
--UNBEDINGT SALONNUMMER,CLIENT_ID und DIRECT_URL austauschen 

--INSERT CANCEL_PAYMENT_REASONS
INSERT INTO CANCEL_PAYMENT_REASONS
SELECT TENANT_NO, COMPANY_NO, DEPARTMENT_NO, BUSINESSUNIT_NO, '1', 'falsche Zahlart'
FROM BUSINESSUNITS;
INSERT INTO CANCEL_PAYMENT_REASONS
SELECT TENANT_NO, COMPANY_NO, DEPARTMENT_NO, BUSINESSUNIT_NO, '2', 'falscher Betrag'
FROM BUSINESSUNITS;

--INSERT CANCEL_NOTE_REASONS
INSERT INTO CANCEL_NOTE_REASONS
SELECT TENANT_NO, COMPANY_NO, DEPARTMENT_NO, BUSINESSUNIT_NO, '1', 'Reklamation'
FROM BUSINESSUNITS;
INSERT INTO CANCEL_NOTE_REASONS
SELECT TENANT_NO, COMPANY_NO, DEPARTMENT_NO, BUSINESSUNIT_NO, '2', 'falscher Mitarbeiter'
FROM BUSINESSUNITS;
INSERT INTO CANCEL_NOTE_REASONS
SELECT TENANT_NO, COMPANY_NO, DEPARTMENT_NO, BUSINESSUNIT_NO, '3', 'falsches Produkt'
FROM BUSINESSUNITS;

--INSERT BUSINESSUNIT_PROPERTIES
INSERT INTO BUSINESSUNIT_PROPERTIES 
SELECT TENANT_NO, COMPANY_NO, DEPARTMENT_NO, BUSINESSUNIT_NO, 'CRS_Saloon_No', '1'
FROM BUSINESSUNITS;
INSERT INTO BUSINESSUNIT_PROPERTIES 
SELECT TENANT_NO, COMPANY_NO, DEPARTMENT_NO, BUSINESSUNIT_NO, 'Hide_Customer_Export', '0'
FROM BUSINESSUNITS;
INSERT INTO BUSINESSUNIT_PROPERTIES 
SELECT TENANT_NO, COMPANY_NO, DEPARTMENT_NO, BUSINESSUNIT_NO, 'Disable_CheckIn_CheckOut', '0'
FROM BUSINESSUNITS;
INSERT INTO BUSINESSUNIT_PROPERTIES 
SELECT TENANT_NO, COMPANY_NO, DEPARTMENT_NO, BUSINESSUNIT_NO, 'Sales_Payment_Transfer_Deactivated', '0'
FROM BUSINESSUNITS;
INSERT INTO BUSINESSUNIT_PROPERTIES 
SELECT TENANT_NO, COMPANY_NO, DEPARTMENT_NO, BUSINESSUNIT_NO, 'CRS_Direct_Url', 'https://www.time-globe-crs.de/crs-websrv-J4809/service'
FROM BUSINESSUNITS;
INSERT INTO BUSINESSUNIT_PROPERTIES 
SELECT TENANT_NO, COMPANY_NO, DEPARTMENT_NO, BUSINESSUNIT_NO, 'CRS_Client_Id', '480'
FROM BUSINESSUNITS;
INSERT INTO BUSINESSUNIT_PROPERTIES 
SELECT TENANT_NO, COMPANY_NO, DEPARTMENT_NO, BUSINESSUNIT_NO, 'Protocol_For_DayClosure_Required', '0'
FROM BUSINESSUNITS;
INSERT INTO BUSINESSUNIT_PROPERTIES 
SELECT TENANT_NO, COMPANY_NO, DEPARTMENT_NO, BUSINESSUNIT_NO, 'SORT_ITEMS', 'BY_ITEM_NAME'
FROM BUSINESSUNITS;
INSERT INTO BUSINESSUNIT_PROPERTIES 
SELECT TENANT_NO, COMPANY_NO, DEPARTMENT_NO, BUSINESSUNIT_NO, 'SALES_PRINT_OPTION', 'IMMEDIATE_PRINT'
FROM BUSINESSUNITS;

INSERT INTO EMPLOYEE_GROUPS
SELECT TENANT_NO, COMPANY_NO, 'Umsatzbarometer','Umsatzbarometer'
FROM BUSINESSUNITS;
INSERT INTO EMPLOYEE_GROUPS
SELECT TENANT_NO, COMPANY_NO, 'Statistiken','Statistiken'
FROM BUSINESSUNITS;

INSERT INTO EMPLOYEE_GROUP_PERMISSIONS
SELECT TENANT_NO, COMPANY_NO, 'Umsatzbarometer','P_REV_DASHBOARD','Umsatzbarometer'
FROM BUSINESSUNITS;
INSERT INTO EMPLOYEE_GROUP_PERMISSIONS
SELECT TENANT_NO, COMPANY_NO, 'Statistiken','P_STATISTICS','Statistiken'
FROM BUSINESSUNITS;


