iVend Database Database : RtlSubsidiary Table

Creation Date

2/12/2016 6:40 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

SubsidiaryKey

System generated Primary key of the table.

VarWChar

50

Id

Id for Subsidiary

VarWChar

20

Description

Description for Subsidiary

VarWChar

100

LocalCurrencyKey

Currency for the Subsidiary. Reference key of the Currency. See also Currency

VarWChar

50

AddressKey

Address for the Subsidiary. Reference key of the Address. See also Address

VarWChar

50

Created

Date of creation of this record

DBTimeStamp

4

CreatedBy

Reference of user who has created this record. See also Security User

VarWChar

50

Modified

Date of last modification of this record

DBTimeStamp

4

ModifiedBy

Reference of user who has modified this record. See also Security User

VarWChar

50

IsDeleted

Value is True if the record has been deleted from the system. Record is always Soft Deleted

Boolean

1

IsTaxInclusive

Value is true if new products from this Subsidiary are tax inclusive

Boolean

1

TimeZoneId

Descriptive information about the Time Zone

VarWChar

100

CultureInfo

Descriptive information about culture

VarWChar

40

IsDefault

Value is True if the Subsidiary is default one.

Boolean

1

Index

Description

Primary

Unique

PK__RtlSubsi__4930FEDB2B6A5820

Database Object

Object Type

Description

Dep Level

CreateTillCount

Stored Procedure

1

Daily_ProductCost

User Defined Function

1

DailySaleSummary

User Defined Function

1

GetMobileReplicationData

Stored Procedure

1

Loyalty_ActiveBillValue

View

1

Loyalty_GenderInfo

View

1

Rpt_ActiveLoyalty

User Defined Function

1

Rpt_ItemWithoutSale

User Defined Function

1

rpt_LayAway

Stored Procedure

1

RPT_StoreAnalysis

Stored Procedure

1

rptSalesData

User Defined Function

1

rptSalesTransactionData

User Defined Function

1

rptSalesTransactionDataWithSalesPerson

User Defined Function

1

vw_GrossProfit

View

1

vw_InventoryCost

View

1

vw_SalesReportData

View

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[RtlSubsidiary](

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

[Id] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Description] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

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

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

[Created] [datetime] NOT NULL,

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

[Modified] [datetime] NOT NULL,

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

[IsDeleted] [bit] NOT NULL,

[IsTaxInclusive] [bit] NOT NULL,

[TimeZoneId] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[CultureInfo] [nvarchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[IsDefault] [bit] NULL,

CONSTRAINT [PK__RtlSubsi__4930FEDB2B6A5820] PRIMARY KEY CLUSTERED

(

[SubsidiaryKey] ASC

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

) ON [PRIMARY]