iVend Database Database : RtlDocumentNumberSeries 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

DocumentNumberSeriesDetail

Stores the detail for Document

VarWChar

50

SiteId

Stores the Site id for Document

Integer

4

PurchaseOrderSeriesKey

Stores the Purchase order series key for Document

VarWChar

50

StockTransferSeriesKey

Stores the Stock transfer series key for Document

VarWChar

50

GoodsReceiptSeriesKey

Stores the Goods receipt series key for Document

VarWChar

50

GoodsIssueSeriesKey

Stores the Goods issue series key for Document

VarWChar

50

StockRequisitionSeriesKey

Stores the Stock requisition series key for Document

VarWChar

50

SaleSeriesKey

Stores the Sale series key for Document

VarWChar

50

RefundSeriesKey

Stores the Refund series key for Document

VarWChar

50

ExchangeSeriesKey

Stores the Exchange series key for Document

VarWChar

50

SpecialOrderSeriesKey

Stores the Special order series key for Document

VarWChar

50

QuotationSeriesKey

Stores the Quotation series key for Document

VarWChar

50

ARPaymentSeriesKey

Stores the AR Payment series key for Document

VarWChar

50

LayawaySeriesKey

Stores the Layaway series key for Document

VarWChar

50

DeliverySeriesKey

Stores the Delivery series key for Document

VarWChar

50

DefaultSeriesKey

Stores the Default series key for Document

VarWChar

50

GoodsReceiptPOSeriesKey

Stores the Goods receipt pos series key for Document

VarWChar

50

((0))

GoodsReceiptSTSeriesKey

Stores the Goods receipt st series key for Document

VarWChar

50

((0))

Index

Description

Primary

Unique

IX_RtlDocumentNumberSeries

PK_CfgDocumentNumberSeriesDetail

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[RtlDocumentNumberSeries](

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

[SiteId] [int] NOT NULL,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

CONSTRAINT [PK_CfgDocumentNumberSeriesDetail] PRIMARY KEY CLUSTERED

(

[DocumentNumberSeriesDetail] 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].[RtlDocumentNumberSeries] ADD CONSTRAINT [DF_RtlDocumentNumberSeries_GoodsReceiptPOSeriesKey] DEFAULT ((0)) FOR [GoodsReceiptPOSeriesKey]

ALTER TABLE [dbo].[RtlDocumentNumberSeries] ADD CONSTRAINT [DF_RtlDocumentNumberSeries_GoodsReceiptSTSeriesKey] DEFAULT ((0)) FOR [GoodsReceiptSTSeriesKey]