/****** Object:  Table [dbo].[SendBoxInvoice]    Script Date: 26.02.2021 22:28:44 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SendBoxInvoice]') AND type in (N'U'))
DROP TABLE [dbo].[SendBoxInvoice]
GO

/****** Object:  Table [dbo].[SendBoxTaxSubtotal]    Script Date: 26.02.2021 22:29:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SendBoxTaxSubtotal]') AND type in (N'U'))
DROP TABLE [dbo].[SendBoxTaxSubtotal]
GO

/****** Object:  Table [dbo].[SendBoxTaxSubtotal]    Script Date: 26.02.2021 22:29:13 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SendBoxTaxSubtotal](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[InvoiceId] [int] NOT NULL,
	[InvoiceItemId] [int] NOT NULL,
	[CalculationSequenceNumeric] [decimal](18, 0) NULL,
	[Percent_] [decimal](20, 2) NULL,
	[PerUnitAmountcurrencyID] [nvarchar](50) NULL,
	[PerUnitAmount] [decimal](20, 2) NULL,
	[TaxableAmountcurrencyID] [nvarchar](50) NULL,
	[TaxableAmount] [decimal](20, 2) NULL,
	[TaxAmountcurrencyID] [nvarchar](50) NULL,
	[TaxAmount] [decimal](20, 2) NULL,
	[TaxCategoryName] [nvarchar](255) NULL,
	[TaxExemptionReason] [nvarchar](255) NULL,
	[TaxExemptionReasonCode] [nvarchar](50) NULL,
	[TaxSchemeID] [nvarchar](50) NULL,
	[TaxSchemeName] [nvarchar](250) NULL,
	[TaxTypeCode] [nvarchar](50) NULL,
 CONSTRAINT [PK_SendBoxTaxSubtotal] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO



/****** Object:  Table [dbo].[SendBoxInvoiceLineType]    Script Date: 26.02.2021 22:29:01 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SendBoxInvoiceLineType]') AND type in (N'U'))
DROP TABLE [dbo].[SendBoxInvoiceLineType]
GO

/****** Object:  Table [dbo].[SendBoxInvoiceLineType]    Script Date: 26.02.2021 22:29:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SendBoxInvoiceLineType](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[InvoiceId] [int] NULL,
	[IID] [nvarchar](50) NULL,
	[InvoicedQuantityunitCode] [nvarchar](50) NULL,
	[InvoicedQuantity] [decimal](20, 2) NULL,
	[AdditionalItemIdentification] [nvarchar](50) NULL,
	[BrandName] [nvarchar](255) NULL,
	[BuyersItemIdentification] [nvarchar](50) NULL,
	[CommodityClassification] [nvarchar](50) NULL,
	[Description] [nvarchar](max) NULL,
	[Keyword] [nvarchar](50) NULL,
	[ManufacturersItemIdentification] [nvarchar](50) NULL,
	[ModelName] [nvarchar](max) NULL,
	[Name] [nvarchar](max) NULL,
	[OriginCountry] [nvarchar](50) NULL,
	[SellersItemIdentification] [nvarchar](50) NULL,
	[LineExtensionAmount] [decimal](20, 2) NULL,
	[Note] [nvarchar](max) NULL,
	[CurrencyCode] [nvarchar](50) NULL,
	[PriceAmount] [decimal](20, 2) NULL,
	[TaxAmountcurrencyID] [nvarchar](50) NULL,
	[TaxAmount] [decimal](20, 2) NULL,
	[SerrialId] [nvarchar](50) NULL,
 CONSTRAINT [PK_SendBoxInvoiceLineType] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


