iVend Database Database : InvLocationStockTransferDetail Table

Creation Date

9/18/2015 10:05 AM

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

LocationStockTransferDetailKey

Primary Key

VarWChar

50

LocationStockTransferKey

Reference Key of LocationStockTransfer. See also InvLocationStockTransfer.

VarWChar

50

ToLocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

LineNumber

Line number of item in detail

Integer

4

ProductKey

Reference Key of Product. See also InvProduct.

VarWChar

50

Description

Description of Product

VarWChar

100

Quantity

Total quantity of location 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)

SourceKey

For future use

VarWChar

50

((0))

IsReceiptRequired

True if you want to get receipt

Boolean

1

((1))

UOMKey

Reference Key of UOM. See also InvUOM.

VarWChar

50

((0))

UOMQuantity

Uom quantity of location stock transfer

Numeric

9 (20,5)

UOMQuantityOpen

Uom Quantity left to shipped or received

Numeric

9 (20,5)

UOMQuantityReceived

Uom quantity received

Numeric

9 (20,5)

UOMQuantityShipped

Uom quantity shipped

Numeric

9 (20,5)

ReasonCodeKey

Reference Key of ReasonCode. See also CfgReasonCode.

VarWChar

50

((0))

Price

Hold the price of the product

Numeric

9 (20,5)

((0))

FromLocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

Index

Description

Primary

Unique

PK_InvLocationStockTransferDetail

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvLocationStockTransferDetail](

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

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

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

[LineNumber] [int] NOT NULL,

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

[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,

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

CONSTRAINT [PK_InvLocationStockTransferDetail] PRIMARY KEY CLUSTERED

(

[LocationStockTransferDetailKey] 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].[InvLocationStockTransferDetail] ADD CONSTRAINT [DF_InvLocationStockTransferDetail_SourceKey] DEFAULT ((0)) FOR [SourceKey]

ALTER TABLE [dbo].[InvLocationStockTransferDetail] ADD CONSTRAINT [DF_InvLocationStockTransferDetail_IsReceiptRequired] DEFAULT ((1)) FOR [IsReceiptRequired]

ALTER TABLE [dbo].[InvLocationStockTransferDetail] ADD CONSTRAINT [DF_InvLocationStockTransferDetail_UOMKey] DEFAULT ((0)) FOR [UOMKey]

ALTER TABLE [dbo].[InvLocationStockTransferDetail] ADD CONSTRAINT [DF_InvLocationStockTransferDetail_ReasonCodeKey] DEFAULT ((0)) FOR [ReasonCodeKey]

ALTER TABLE [dbo].[InvLocationStockTransferDetail] ADD CONSTRAINT [DF_InvLocationStockTransferDetail_Price] DEFAULT ((0)) FOR [Price]