/****** Object:  Table [dbo].[CSAPP_RATE_TYPES]    Script Date: 26.08.2019 09:21:18 ******/

CREATE TABLE [dbo].[CSAPP_RATE_TYPES](
[TYPE] [varchar](255) NULL,
[TYPE_DESCRIPTION] [varchar](255) NULL,
[STANDARD] [bit] NULL
) ON [PRIMARY]


CREATE TABLE [dbo].[CSAPP_RENTAL_TPYES](
[PRICELIST_PK] [varchar](255) NULL,
[RENTALTYPE_DESCRIPTION] [varchar](255) NULL,
[CUSTOMER_DESCRIPTION_MANDATORY] [bit] NULL
) ON [PRIMARY]


INSERT [dbo].[CSAPP_RATE_TYPES] ([TYPE], [TYPE_DESCRIPTION], [STANDARD]) VALUES (N'FLEX', N'', NULL)

INSERT [dbo].[CSAPP_RATE_TYPES] ([TYPE], [TYPE_DESCRIPTION], [STANDARD]) VALUES (N'KOMFORT', N'', NULL)

INSERT [dbo].[CSAPP_RENTAL_TPYES] ([PRICELIST_PK], [RENTALTYPE_DESCRIPTION], [CUSTOMER_DESCRIPTION_MANDATORY]) VALUES (N'GESCHÄFTLICH', N'Mein Arbeitgeber', 1)

INSERT [dbo].[CSAPP_RENTAL_TPYES] ([PRICELIST_PK], [RENTALTYPE_DESCRIPTION], [CUSTOMER_DESCRIPTION_MANDATORY]) VALUES (N'PRIVAT', N'Ich selbst', 0)

