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

InvInventoryTransactionDetailKey

Primary Key

VarWChar

50

InventoryTransactionKey

Reference Key of inventory transaction. See also Goods Issue

VarWChar

50

InventoryItemKey

Reference Key of the inventory item.

VarWChar

50

ProductKey

Reference Key of the product. See also Product

VarWChar

50

Description

Description of the product

VarWChar

100

Quantity

Quantity of the product

Numeric

9 (20,5)

Type

Type of the product

Integer

4

((0))

ReasonKey

Reference key of the reason code. See also Reason Code

VarWChar

50

CommentKey

Reference key of the comment. See also Comment

VarWChar

50

UOMKey

Reference key for the UOM

VarWChar

50

UOMQuantity

Count is the UOM quantity

Numeric

9 (20,5)

UniqueLineNumber

Hold GUID for Line

VarWChar

50

LocationKey

Reference Key for the location. See Location

VarWChar

50

SourceKey

Refers to the source document key

VarWChar

50

SourceDetailKey

Refers to the source document detail key

VarWChar

50

Comments

Stores comments.

VarWChar

4000

Index

Description

Primary

Unique

PK_InvInventoryTransactionDetailKey

Database Object

Object Type

Description

Dep Level

GoodsIssueReport

Stored Procedure

1

Integration_GoodsIssue

Stored Procedure

1

Integration_GoodsIssue_SerialBatch

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].[InvInventoryTransactionDetail](

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

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

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

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

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

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

[Type] [int] NOT NULL,

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

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

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

[UOMQuantity] [decimal](20, 5) NULL,

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

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

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

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

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

CONSTRAINT [PK_InvInventoryTransactionDetailKey] PRIMARY KEY CLUSTERED

(

[InvInventoryTransactionDetailKey] 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].[InvInventoryTransactionDetail] ADD CONSTRAINT [DF_InvInventoryTransactionDetail_Type] DEFAULT ((0)) FOR [Type]