INSERT INTO `s_viison_datev_accounts` (`number`, `name`, `invoiceText`, `isRevenueAccount`, `postingKey`) VALUES
(8120, 'Steuerfreie Umsätze §4 Nr. 1a UStG', 'taxFreeExport', 1, NULL),
(8125, 'Steuerfreie innergemeinschaftliche Lieferungen §4 Nr. 1b UStG', 'taxFreeEU', 1, NULL),
(8150, 'Sonstige steuerfreie Umsätze (z.B. §4 Nr. 2-7 UStG, 1, NULL)', 'taxFreeParagraph2To7UStG', 1, NULL),
(8200, 'Erlöse', 'taxFreeOrganschaft', 1, NULL),
(8300, 'Erlöse 7% USt.', NULL, 1, NULL),
(8305, 'Erlöse 7% USt. Ladengeschäft', NULL, 1, NULL),
(8310, 'Erlöse aus im Inland steuerpflichtigen EU-Lieferungen 7% USt', NULL, 1, NULL),
(8315, 'Erlöse aus im Inland steuerpflichtigen EU-Lieferungen 19% USt', NULL, 1, NULL),
(8331, 'Erlöse aus im anderen EU-Land steuerpflichtigen elektronischen Dienstleistungen', NULL, 1, 44),
(8336, 'Erlöse aus im anderen EU-Land steuerpflichtigen sonstigen Leistungen für die der Leistungsempfänger die Umsatzsteuer schuldet', 'beneficiaryOwesTax', 1, NULL),
(8338, 'Erlöse aus im Drittland steuerbaren Leistungen, im Inland nicht steuerbare Umsätze', NULL, 1, NULL),
(8400, 'Erlöse 19% USt.', NULL, 1, NULL),
(8405, 'Erlöse 19% USt. Ladengeschäft', NULL, 1, NULL);

INSERT INTO `s_viison_datev_account_assignments` (`invoiceCountry`, `customerHasVatId`, `otherServiceParagraphOneOrTwo`, `otherServiceMOSS`, `physicalShipmentFromGermany`, `taxFree`, `shippingCountry`, `tax`, `localRetailStore`, `accountNumber`) VALUES
('DE', 1, 0, 0, 1, '0', 'DE', 'Standard', 0, 8400),
('DE', 1, 0, 0, 1, '0', 'DE', 'Reduced', 0, 8300),
('DE', 0, 0, 0, 1, '0', 'DE', 'Standard', 0, 8400),
('DE', 0, 0, 0, 1, '0', 'DE', 'Reduced', 0, 8300),
('DE', 1, 0, 0, 1, '0', 'EU', 'N/A', 0, 8125),
('DE', 0, 0, 0, 1, '0', 'EU', 'Standard', 0, 8315),
('DE', 0, 0, 0, 1, '0', 'EU', 'Reduced', 0, 8310),
('DE', 1, 0, 0, 1, '0', 'non-EU', 'N/A', 0, 8120),
('DE', 0, 0, 0, 1, '0', 'non-EU', 'N/A', 0, 8120),
('EU', 1, 0, 0, 1, '0', 'EU', 'N/A', 0, 8125),
('EU', 0, 0, 0, 1, '0', 'EU', 'Standard', 0, 8315),
('EU', 0, 0, 0, 1, '0', 'EU', 'Reduced', 0, 8310),
('EU', 1, 0, 0, 1, '0', 'DE', 'Standard', 0, 8400),
('EU', 1, 0, 0, 1, '0', 'DE', 'Reduced', 0, 8300),
('EU', 0, 0, 0, 1, '0', 'DE', 'Standard', 0, 8400),
('EU', 0, 0, 0, 1, '0', 'DE', 'Reduced', 0, 8300),
('EU', 1, 0, 0, 1, '0', 'non-EU', 'N/A', 0, 8120),
('EU', 0, 0, 0, 1, '0', 'non-EU', 'N/A', 0, 8120),
('non-EU', 1, 0, 0, 1, '0', 'non-EU', 'N/A', 0, 8120),
('non-EU', 0, 0, 0, 1, '0', 'non-EU', 'N/A', 0, 8120),
('non-EU', 1, 0, 0, 1, '0', 'DE', 'Standard', 0, 8400),
('non-EU', 1, 0, 0, 1, '0', 'DE', 'Reduced', 0, 8300),
('non-EU', 0, 0, 0, 1, '0', 'DE', 'Standard', 0, 8400),
('non-EU', 0, 0, 0, 1, '0', 'DE', 'Reduced', 0, 8300),
('non-EU', 1, 0, 0, 1, '0', 'EU', 'N/A', 0, 8125),
('non-EU', 0, 0, 0, 1, '0', 'EU', 'Standard', 0, 8315),
('non-EU', 0, 0, 0, 1, '0', 'EU', 'Reduced', 0, 8310),
('DE', 0, 0, 0, 1, '§4 Nr. 2-7 UStG', 'DE', 'N/A', 0, 8150),
('DE', 0, 0, 0, 1, '§4 Nr. 2-7 UStG', 'EU', 'N/A', 0, 8150),
('DE', 0, 0, 0, 1, '§4 Nr. 2-7 UStG', 'non-EU', 'N/A', 0, 8150),
('EU', 0, 0, 0, 1, '§4 Nr. 2-7 UStG', 'DE', 'N/A', 0, 8150),
('EU', 0, 0, 0, 1, '§4 Nr. 2-7 UStG', 'EU', 'N/A', 0, 8150),
('EU', 0, 0, 0, 1, '§4 Nr. 2-7 UStG', 'non-EU', 'N/A', 0, 8150),
('non-EU', 0, 0, 0, 1, '§4 Nr. 2-7 UStG', 'DE', 'N/A', 0, 8150),
('non-EU', 0, 0, 0, 1, '§4 Nr. 2-7 UStG', 'EU', 'N/A', 0, 8150),
('non-EU', 0, 0, 0, 1, '§4 Nr. 2-7 UStG', 'non-EU', 'N/A', 0, 8150),
('DE', 0, 0, 0, 1, '§4 Nr. 2-7 UStG', 'DE', 'Standard', 0, 8400),
('DE', 0, 0, 0, 1, '§4 Nr. 2-7 UStG', 'DE', 'Reduced', 0, 8300),
('EU', 0, 0, 0, 1, '§4 Nr. 2-7 UStG', 'DE', 'Standard', 0, 8400),
('EU', 0, 0, 0, 1, '§4 Nr. 2-7 UStG', 'DE', 'Reduced', 0, 8300),
('non-EU', 0, 0, 0, 1, '§4 Nr. 2-7 UStG', 'DE', 'Standard', 0, 8400),
('non-EU', 0, 0, 0, 1, '§4 Nr. 2-7 UStG', 'DE', 'Reduced', 0, 8300),
('DE', 0, 1, 0, 0, '§4 Nr. 2-7 UStG', 'DE', 'N/A', 0, 8150),
('DE', 0, 1, 0, 0, '§4 Nr. 2-7 UStG', 'EU', 'N/A', 0, 8150),
('DE', 0, 1, 0, 0, '§4 Nr. 2-7 UStG', 'non-EU', 'N/A', 0, 8150),
('EU', 0, 1, 0, 0, '§4 Nr. 2-7 UStG', 'DE', 'N/A', 0, 8150),
('EU', 0, 1, 0, 0, '§4 Nr. 2-7 UStG', 'EU', 'N/A', 0, 8150),
('EU', 0, 1, 0, 0, '§4 Nr. 2-7 UStG', 'non-EU', 'N/A', 0, 8150),
('non-EU', 0, 1, 0, 0, '§4 Nr. 2-7 UStG', 'DE', 'N/A', 0, 8150),
('non-EU', 0, 1, 0, 0, '§4 Nr. 2-7 UStG', 'EU', 'N/A', 0, 8150),
('non-EU', 0, 1, 0, 0, '§4 Nr. 2-7 UStG', 'non-EU', 'N/A', 0, 8150),
('DE', 1, 0, 0, 1, 'Organkreis', 'DE', 'N/A', 0, 8200),
('DE', 0, 0, 0, 1, 'Organkreis', 'DE', 'N/A', 0, 8200),
('DE', 1, 1, 0, 0, 'Organkreis', 'DE', 'N/A', 0, 8200),
('DE', 0, 1, 0, 0, 'Organkreis', 'DE', 'N/A', 0, 8200),
('EU', 1, 0, 0, 1, 'Organkreis', 'EU', 'N/A', 0, 8125),
('EU', 0, 0, 0, 1, 'Organkreis', 'EU', 'Standard', 0, 8315),
('EU', 0, 0, 0, 1, 'Organkreis', 'EU', 'Reduced', 0, 8310),
('EU', 1, 1, 0, 0, 'Organkreis', 'EU', 'N/A', 0, 8336),
('EU', 0, 1, 0, 0, 'Organkreis', 'EU', 'Standard', 0, 8400),
('EU', 0, 1, 0, 0, 'Organkreis', 'EU', 'Reduced', 0, 8300),
('non-EU', 1, 0, 0, 1, 'Organkreis', 'non-EU', 'N/A', 0, 8120),
('non-EU', 0, 0, 0, 1, 'Organkreis', 'non-EU', 'N/A', 0, 8120),
('non-EU', 1, 1, 0, 0, 'Organkreis', 'non-EU', 'N/A', 0, 8338),
('non-EU', 0, 1, 0, 0, 'Organkreis', 'non-EU', 'Standard', 0, 8400),
('non-EU', 0, 1, 0, 0, 'Organkreis', 'non-EU', 'Reduced', 0, 8300),
('DE', 1, 1, 0, 0, '0', 'DE', 'Standard', 0, 8400),
('DE', 1, 1, 0, 0, '0', 'DE', 'Reduced', 0, 8300),
('DE', 0, 1, 0, 0, '0', 'DE', 'Standard', 0, 8400),
('DE', 0, 1, 0, 0, '0', 'DE', 'Reduced', 0, 8300),
('EU', 1, 1, 0, 0, '0', 'EU', 'N/A', 0, 8336),
('EU', 0, 1, 0, 0, '0', 'EU', 'Standard', 0, 8400),
('EU', 0, 1, 0, 0, '0', 'EU', 'Reduced', 0, 8300),
('non-EU', 1, 1, 0, 0, '0', 'non-EU', 'N/A', 0, 8338),
('non-EU', 0, 1, 0, 0, '0', 'non-EU', 'Standard', 0, 8400),
('non-EU', 0, 1, 0, 0, '0', 'non-EU', 'Reduced', 0, 8300),
('DE', 0, 0, 1, 0, '0', 'DE', 'Standard', 0, 8400),
('DE', 0, 0, 1, 0, '0', 'DE', 'Reduced', 0, 8300),
('EU', 0, 0, 1, 0, '0', 'EU', 'N/A', 0, 8331),
('non-EU', 0, 0, 1, 0, '0', 'non-EU', 'N/A', 0, 8338),
('N/A', 0, 0, 0, 0, '0', 'N/A', 'Reduced', 1, 8305),
('N/A', 0, 0, 0, 0, '0', 'N/A', 'Standard', 1, 8405);
