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

StockTransferKey

Primary Key

VarWChar

50

FromWarehouseKey

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

VarWChar

50

ToWarehouseKey

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

VarWChar

50

SiteId

Refers to the Site Id

Integer

4

BusinessDate

Refers to the date on which the stock transfer is done

DBTimeStamp

4

RequestNumber

Reference number of stock transfer

VarWChar

50

RequestedDate

Requested date for stock transfer, on which stock transfer will be done

DBTimeStamp

4

ReferenceNumber1

Refers to the reference no 1

VarWChar

50

ReferenceNumber2

Refers to the reference no 2

VarWChar

50

Status

Status of Stock Transfer

Valid values are:

Open = 0

Closed = 1

Integer

4

CommentKey

Reference key of the comment. See also Comment

VarWChar

50

BranchCode

For future use

VarWChar

50

AccountingID

Maps to the unique id in the ERP system

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

SalesPersonKey

Reference key of the Sales Person. See also Employee

VarWChar

50

SourceType

Value which denotes the source of Current Stock Transfer

Integer

4

SourceKey

Value is the key of the source selected.

VarWChar

50

((0))

EventKey

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

VarWChar

50

((0))

POSDocumentNumberSeriesKey

Reference Key of POSDocumentNumberSeriesKey. See RtlPosDocumentNumberSeries

VarWChar

50

((0))

BusinessPartnerType

Valid values are:

None = 0,

Customer = 1,

Vendor = 2

Integer

4

BusinessPartnerKey

Reference key for the Business Partner

VarWChar

50

ReasonCodeKey

Reference key of reason code of stock transfer.

VarWChar

50

((0))

FromLocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

ToLocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

RowRevision

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

Binary

8

PriceListKey

Reference Key for the Price List. See PrcPriceList

VarWChar

50

Comments

Stores comments.

LongVarWChar

16

SurchargeTotal

Stores total surcharge on stock transfer.

Integer

4

Id

VarWChar

20

Description

VarWChar

100

IsDeleted

Boolean

1

Index

Description

Primary

Unique

PK_InvStockTransfer

Database Object

Object Type

Description

Dep Level

CancelStockTransfer

Stored Procedure

1

Integration_GoodsReceipt

Stored Procedure

1

Integration_StockTransfer

Stored Procedure

1

Integration_StockTransferSerialBatch

Stored Procedure

1

ReplicationRecordsToSend

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

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

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

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

[SiteId] [int] NOT NULL,

[BusinessDate] [datetime] NOT NULL,

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

[RequestedDate] [datetime] NOT NULL,

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

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

[Status] [int] NOT NULL,

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

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

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

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

[SourceType] [int] NOT NULL,

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

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

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

[BusinessPartnerType] [int] NULL,

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

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

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

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

[RowRevision] [timestamp] NOT NULL,

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

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

[SurchargeTotal] [int] 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_InvStockTransfer] PRIMARY KEY CLUSTERED

(

[StockTransferKey] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

ALTER TABLE [dbo].[InvStockTransfer] ADD CONSTRAINT [DF_InvStockTransfer_SourceKey] DEFAULT ((0)) FOR [SourceKey]

ALTER TABLE [dbo].[InvStockTransfer] ADD CONSTRAINT [DF_InvStockTransfer_EventKey] DEFAULT ((0)) FOR [EventKey]

ALTER TABLE [dbo].[InvStockTransfer] ADD CONSTRAINT [DF_InvStockTransfer_POSDocumentNumberSeriesKey] DEFAULT ((0)) FOR [POSDocumentNumberSeriesKey]

ALTER TABLE [dbo].[InvStockTransfer] ADD CONSTRAINT [DF_InvStockTransfer_ReasonCodeKey] DEFAULT ((0)) FOR [ReasonCodeKey]