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

StockTransferDetailKey

Primary Key

VarWChar

50

StockTransferKey

Reference key of the stock transfer. See also Stock Transfer

VarWChar

50

ToWarehouseKey

Reference key of the warehouse to which the stock is transferred. See also Warehouse

VarWChar

50

LineNumber

Line number of item in detail

Integer

4

ProductKey

Reference Key of Product. See also Product

VarWChar

50

Description

Description of Product

VarWChar

100

Quantity

Total quantity of stock transfer

Numeric

9 (20,5)

QuantityOpen

Quantity left to shipped or received

Numeric

9 (20,5)

QuantityReceived

Total quantity received

Numeric

9 (20,5)

QuantityShipped

Total quantity shipped

Numeric

9 (20,5)

Status

Status of Stock Transfer detail item

Valid values are:

Open = 0

Close = 1

Integer

4

SourceKey

Value is the key of the source selected.

VarWChar

50

((0))

IsReceiptRequired

Value is true if the receipt is required

Boolean

1

((1))

UOMKey

Reference Key of UOM Product. See also UOM Product

VarWChar

50

((0))

UOMQuantity

Total UOM quantity of stock transfer

Numeric

9 (20,5)

UOMQuantityOpen

UOM Quantity left to shipped or received

Numeric

9 (20,5)

UOMQuantityReceived

Total quantity received

Numeric

9 (20,5)

UOMQuantityShipped

Total quantity shipped

Numeric

9 (20,5)

ReasonCodeKey

Reference key of reason code of stock transfer.

VarWChar

50

((0))

Price

Stores the Price for the Items.

Numeric

9 (20,5)

((0))

ShortQuantityReceived

Hold the short received quantity while receiving the stock transfer.

Numeric

9 (20,5)

UniqueLineNumber

Hold GUID for Line

VarWChar

50

FromLocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

OriginalDocumentSourceKey

Value is the Source Key from where the Stock transfer has been Initiated

VarWChar

50

StockTransferTransactionNumber

Integer

4

((0))

StockTransferDocumentNumber

VarWChar

50

Index

Description

Primary

Unique

PK_InvStockTransferDetail

Trigger

Description

TrgInvStockTransferDetail

Database Object

Object Type

Description

Dep Level

CancelStockTransfer

Stored Procedure

1

Integration_GoodsReceipt

Stored Procedure

1

Integration_GoodsReceiptSerialBatchShortReceived

Stored Procedure

1

Integration_StockTransfer

Stored Procedure

1

Integration_StockTransferSerialBatch

Stored Procedure

1

Rpt_ItemWithoutSale

User Defined Function

2

rptOpeningBalance

User Defined Function

1

rptOpeningBalance_dailyClosingBal

User Defined Function

1

rptOpeningBalance_Location

User Defined Function

1

StockTransferReport

Stored Procedure

1

vw_InventoryCost

View

1

vw_InventoryMovement

View

1

vwAnalytics_OpenStockTransferReceipt

View

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvStockTransferDetail](

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

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

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

[LineNumber] [int] NOT NULL,

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

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

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

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

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

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

[Status] [int] NOT NULL,

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

[IsReceiptRequired] [bit] NOT NULL,

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

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

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

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

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

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

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

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

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

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

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

[StockTransferTransactionNumber] [int] NOT NULL,

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

CONSTRAINT [PK_InvStockTransferDetail] PRIMARY KEY CLUSTERED

(

[StockTransferDetailKey] 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].[InvStockTransferDetail] ADD CONSTRAINT [DF_InvStockTransferDetail_SourceKey] DEFAULT ((0)) FOR [SourceKey]

ALTER TABLE [dbo].[InvStockTransferDetail] ADD CONSTRAINT [DF_InvStockTransferDetail_IsReceiptRequired] DEFAULT ((1)) FOR [IsReceiptRequired]

ALTER TABLE [dbo].[InvStockTransferDetail] ADD CONSTRAINT [DF_InvStockTransferDetail_UOMKey] DEFAULT ((0)) FOR [UOMKey]

ALTER TABLE [dbo].[InvStockTransferDetail] ADD CONSTRAINT [DF_InvStockTransferDetail_ReasonCodeKey] DEFAULT ((0)) FOR [ReasonCodeKey]

ALTER TABLE [dbo].[InvStockTransferDetail] ADD CONSTRAINT [DF_InvStockTransferDetail_Price] DEFAULT ((0)) FOR [Price]

ALTER TABLE [dbo].[InvStockTransferDetail] ADD CONSTRAINT [DF__InvStockT__Stock__534E2C48] DEFAULT ((0)) FOR [StockTransferTransactionNumber]