iVend Database Database : RptZReport Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

0

Data Space Used

0.00 KB

Index Space Used

0.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

ReportKey

System table column. Do not modify.

VarWChar

50

TillKey

System table column. Do not modify.

VarWChar

50

TillDate

System table column. Do not modify.

DBTimeStamp

4

POSId

System table column. Do not modify.

VarWChar

50

TillId

System table column. Do not modify.

VarWChar

50

BusinessDate

System table column. Do not modify.

DBTimeStamp

4

Advances

System table column. Do not modify.

Numeric

9 (20,5)

((0))

GiftCardSales

System table column. Do not modify.

Numeric

9 (20,5)

((0))

PreviousPayments

System table column. Do not modify.

Numeric

9 (20,5)

((0))

CreditSales

System table column. Do not modify.

Numeric

9 (20,5)

((0))

PaidByGiftCard

System table column. Do not modify.

Numeric

9 (20,5)

((0))

PaidByStoreCredit

System table column. Do not modify.

Numeric

9 (20,5)

((0))

SalesReturns

System table column. Do not modify.

Numeric

9 (20,5)

((0))

SalesReturnsTax

System table column. Do not modify.

Numeric

9 (20,5)

((0))

TaxableInvoices

System table column. Do not modify.

Numeric

9 (20,5)

((0))

SalesTax

System table column. Do not modify.

Numeric

9 (20,5)

((0))

SalesNonTaxable

System table column. Do not modify.

Numeric

9 (20,5)

((0))

TotalSales

System table column. Do not modify.

Numeric

9 (20,5)

((0))

SalesReturnsNonTaxable

System table column. Do not modify.

Numeric

9 (20,5)

((0))

TotalTaxable

System table column. Do not modify.

Numeric

9 (20,5)

((0))

TotalSalesTax

System table column. Do not modify.

Numeric

9 (20,5)

((0))

TotalNonTaxable

System table column. Do not modify.

Numeric

9 (20,5)

((0))

Index

Description

Primary

Unique

PK__RptZRepo__0261CF2C1486F2C8

Database Object

Object Type

Description

Dep Level

ZTapeReport

Stored Procedure

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[RptZReport](

[ReportKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[TillKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[TillDate] [datetime] NOT NULL,

[POSId] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[TillId] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[BusinessDate] [datetime] NOT NULL,

[Advances] [decimal](20, 5) NOT NULL,

[GiftCardSales] [decimal](20, 5) NOT NULL,

[PreviousPayments] [decimal](20, 5) NOT NULL,

[CreditSales] [decimal](20, 5) NOT NULL,

[PaidByGiftCard] [decimal](20, 5) NOT NULL,

[PaidByStoreCredit] [decimal](20, 5) NOT NULL,

[SalesReturns] [decimal](20, 5) NOT NULL,

[SalesReturnsTax] [decimal](20, 5) NOT NULL,

[TaxableInvoices] [decimal](20, 5) NOT NULL,

[SalesTax] [decimal](20, 5) NOT NULL,

[SalesNonTaxable] [decimal](20, 5) NOT NULL,

[TotalSales] [decimal](20, 5) NOT NULL,

[SalesReturnsNonTaxable] [decimal](20, 5) NOT NULL,

[TotalTaxable] [decimal](20, 5) NOT NULL,

[TotalSalesTax] [decimal](20, 5) NOT NULL,

[TotalNonTaxable] [decimal](20, 5) NOT NULL,

CONSTRAINT [PK__RptZRepo__0261CF2C1486F2C8] PRIMARY KEY CLUSTERED

(

[ReportKey] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

ALTER TABLE [dbo].[RptZReport] ADD CONSTRAINT [DF_RptZReport_Advances] DEFAULT ((0)) FOR [Advances]

ALTER TABLE [dbo].[RptZReport] ADD CONSTRAINT [DF_RptZReport_GiftCardSales] DEFAULT ((0)) FOR [GiftCardSales]

ALTER TABLE [dbo].[RptZReport] ADD CONSTRAINT [DF_RptZReport_PreviousPayments] DEFAULT ((0)) FOR [PreviousPayments]

ALTER TABLE [dbo].[RptZReport] ADD CONSTRAINT [DF_RptZReport_CreditSales] DEFAULT ((0)) FOR [CreditSales]

ALTER TABLE [dbo].[RptZReport] ADD CONSTRAINT [DF_RptZReport_PaidByGiftCard] DEFAULT ((0)) FOR [PaidByGiftCard]

ALTER TABLE [dbo].[RptZReport] ADD CONSTRAINT [DF_RptZReport_PaidByStoreCredit] DEFAULT ((0)) FOR [PaidByStoreCredit]

ALTER TABLE [dbo].[RptZReport] ADD CONSTRAINT [DF_RptZReport_SalesReturns] DEFAULT ((0)) FOR [SalesReturns]

ALTER TABLE [dbo].[RptZReport] ADD CONSTRAINT [DF_RptZReport_SalesReturnsTax] DEFAULT ((0)) FOR [SalesReturnsTax]

ALTER TABLE [dbo].[RptZReport] ADD CONSTRAINT [DF_RptZReport_TaxableInvoices] DEFAULT ((0)) FOR [TaxableInvoices]

ALTER TABLE [dbo].[RptZReport] ADD CONSTRAINT [DF_RptZReport_SalesTax] DEFAULT ((0)) FOR [SalesTax]

ALTER TABLE [dbo].[RptZReport] ADD CONSTRAINT [DF_RptZReport_SalesNonTaxable] DEFAULT ((0)) FOR [SalesNonTaxable]

ALTER TABLE [dbo].[RptZReport] ADD CONSTRAINT [DF_RptZReport_TotalSales] DEFAULT ((0)) FOR [TotalSales]

ALTER TABLE [dbo].[RptZReport] ADD CONSTRAINT [DF_RptZReport_SalesReturnsNonTaxable] DEFAULT ((0)) FOR [SalesReturnsNonTaxable]

ALTER TABLE [dbo].[RptZReport] ADD CONSTRAINT [DF_RptZReport_TotalTaxable] DEFAULT ((0)) FOR [TotalTaxable]

ALTER TABLE [dbo].[RptZReport] ADD CONSTRAINT [DF_RptZReport_TotalSalesTax] DEFAULT ((0)) FOR [TotalSalesTax]

ALTER TABLE [dbo].[RptZReport] ADD CONSTRAINT [DF_RptZReport_TotalNonTaxable] DEFAULT ((0)) FOR [TotalNonTaxable]