iVend Database Database : InvInventoryTransaction Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

PRIMARY

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

InventoryTransactionKey

Primary Key

VarWChar

50

ReferenceNumber

Reference number of the inventory transaction

VarWChar

50

EntryDate

Date on which the transaction was captured

DBTimeStamp

4

BusinessDate

Date of Business

DBTimeStamp

4

CommentKey

Reference Key of Comment. See also Comment

VarWChar

50

ReasonKey

Reference key of reason code. See also Reason Code

VarWChar

50

SiteId

Site id where the inventory transaction is done

Integer

4

WarehouseKey

Reference Key of the warehouse. See also Warehouse

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

BusinessPartnerType

If the Inventory Transaction is done for a Business partner then the type of the Business Partner.

Valid values are:

None = 0

Customer = 1

Vendor = 2

Integer

4

BusinessPartnerKey

Source key of the business partner depending on the business partner type

VarWChar

50

EventKey

Stores the key associated with an event such as Goods Sales.

VarWChar

50

((0))

SourceType

Stores source type as the value of the Good Issue

Valid Values are

Good Issue = 0

Integer

4

((0))

POSDocumentNumberSeriesKey

Reference Key for the POS Document number series

VarWChar

50

((0))

LocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

RowRevision

Rowversion is used as a mechanism for version-stamping table rows.

Binary

8

Comments

Stores comments.

VarWChar

4000

IsAdjustmentEntry

Value is true, this transaction is created to adjust the inventory only.

Boolean

1

((0))

Id

VarWChar

20

Description

VarWChar

100

IsDeleted

Boolean

1

Index

Description

Primary

Unique

PK_InvInventoryTransaction

Database Object

Object Type

Description

Dep Level

GoodsIssueReport

Stored Procedure

1

Integration_GoodsIssue

Stored Procedure

1

Rpt_ItemWithoutSale

User Defined Function

2

rptClosingBalanceQuantity

User Defined Function

1

rptOpeningBalance

User Defined Function

1

rptOpeningBalance_dailyClosingBal

User Defined Function

1

rptOpeningBalance_Location

User Defined Function

1

rptOpeningBalance_Stock

User Defined Function

1

vw_InventoryCost

View

1

vw_InventoryMovement

View

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvInventoryTransaction](

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

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

[EntryDate] [datetime] NOT NULL,

[BusinessDate] [datetime] NOT NULL,

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

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

[SiteId] [int] NOT NULL,

[WarehouseKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT 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,

[BusinessPartnerType] [int] NOT NULL,

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

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

[SourceType] [int] NOT NULL,

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

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

[RowRevision] [timestamp] NOT NULL,

[Comments] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[IsAdjustmentEntry] [bit] NOT NULL,

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

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

[IsDeleted] [bit] NULL,

CONSTRAINT [PK_InvInventoryTransaction] PRIMARY KEY CLUSTERED

(

[InventoryTransactionKey] 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].[InvInventoryTransaction] ADD CONSTRAINT [DF_InvInventoryTransaction_EventKey] DEFAULT ((0)) FOR [EventKey]

ALTER TABLE [dbo].[InvInventoryTransaction] ADD CONSTRAINT [DF_InvInventoryTransaction_SourceType] DEFAULT ((0)) FOR [SourceType]

ALTER TABLE [dbo].[InvInventoryTransaction] ADD CONSTRAINT [DF_InvInventoryTransaction_POSDocumentNumberSeriesKey] DEFAULT ((0)) FOR [POSDocumentNumberSeriesKey]

ALTER TABLE [dbo].[InvInventoryTransaction] ADD CONSTRAINT [DF_InvInventoryTransaction_IsAdjustmentEntry] DEFAULT ((0)) FOR [IsAdjustmentEntry]