iVend Database Database : RptZReportDetail Table

Creation Date

10/8/2018 5:57 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

ZReportDetailKey

VarWChar

50

ReportKey

VarWChar

50

PaymentId

VarWChar

50

Type

Integer

4

PaidIn

Numeric

9 (20,5)

((0))

PaidOut

Numeric

9 (20,5)

((0))

NetAmount

Numeric

9 (20,5)

((0))

Index

Description

Primary

Unique

PK__RptZRepo__849C010717635F73

Database Object

Object Type

Description

Dep Level

ZTapeReport

Stored Procedure

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[RptZReportDetail](

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

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

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

[Type] [int] NOT NULL,

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

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

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

CONSTRAINT [PK__RptZRepo__849C010717635F73] PRIMARY KEY CLUSTERED

(

[ZReportDetailKey] 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].[RptZReportDetail] ADD CONSTRAINT [DF_RptZReportDetails_PaidIn] DEFAULT ((0)) FOR [PaidIn]

ALTER TABLE [dbo].[RptZReportDetail] ADD CONSTRAINT [DF_RptZReportDetails_PaidOut] DEFAULT ((0)) FOR [PaidOut]

ALTER TABLE [dbo].[RptZReportDetail] ADD CONSTRAINT [DF_RptZReportDetails_NetAmount] DEFAULT ((0)) FOR [NetAmount]