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

StockTransferRequestDetailKey

Primary key

VarWChar

50

StockTransferRequestKey

Reference Key of Stock Transfer Request. See also Stock Transfer Request

VarWChar

50

ToWarehouseKey

Reference key of Warehouse where goods are received. See also Warehouse

VarWChar

50

LineNumber

Line number of the product

Integer

4

ProductKey

Reference key of product to Request belongs. See also Product.

VarWChar

50

Description

Refers to the description for the Stock Transfer Detail

VarWChar

100

Quantity

Value is the quantity of the order item added for transfer

Numeric

9 (20,5)

QuantityOpen

Value is the quantity of the order item is still open

Numeric

9 (20,5)

QuantityShipped

Value is the quantity of the order item shipped

Numeric

9 (20,5)

Status

Refers to the status of the Stock transfer

Valid values are:

Open = 0

Closed = 1

Cancelled = 2

Integer

4

UOMKey

Refers to the UOM key. See InvUOM

VarWChar

50

UOMQuantity

Refers to the UOM Qunatity of the product

Numeric

9 (20,5)

BaseUOMQuantity

Value is the Base UOM Qty of the product

Numeric

9 (20,5)

((1))

UOMQuantityOpen

Refers to the UOM Quantity Open for the product

Numeric

9 (20,5)

UOMQuantityShipped

Refers to the UOM Quantity Shipped for the product

Numeric

9 (20,5)

ReasonCodeKey

Refers to reason code of stock transfer request.

VarWChar

50

((0))

UniqueLineNumber

Hold GUID for Line

VarWChar

50

ToLocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

AcceptedQuantity

Value is the quantity accepted by the user

Numeric

9 (20,5)

SenderReasonCodeKey

Reference Key for Reason code. See cfgReasonCode

VarWChar

50

SenderCommentKey

Reference Key for Comment. See cfgComment

VarWChar

50

ReceiverReasonCodeKey

Reference Key for Reason code. See cfgReasonCode

VarWChar

50

ReceiverCommentKey

Reference Key for Comment. See cfgComment

VarWChar

50

Comments

Stores comments.

VarWChar

4000

SenderComments

Stores comments.

VarWChar

4000

ReceiverComments

Stores comments.

VarWChar

4000

Index

Description

Primary

Unique

PK_InvStockTransferRequestDetail

Database Object

Object Type

Description

Dep Level

CancelStockTransfer

Stored Procedure

1

vwAnalytics_OpenStockTransferRequest

View

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvStockTransferRequestDetail](

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

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

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

[Status] [int] NOT NULL,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

CONSTRAINT [PK_InvStockTransferRequestDetail] PRIMARY KEY CLUSTERED

(

[StockTransferRequestDetailKey] 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].[InvStockTransferRequestDetail] ADD CONSTRAINT [DF_InvStockTransferRequestDetail_BaseUOMQuantity] DEFAULT ((1)) FOR [BaseUOMQuantity]

ALTER TABLE [dbo].[InvStockTransferRequestDetail] ADD CONSTRAINT [DF_InvStockTransferRequestDetail_ReasonCodeKey] DEFAULT ((0)) FOR [ReasonCodeKey]