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

GoodsReceiptKey

Primary Key

VarWChar

50

FromWarehouseKey

Reference Key of the Originating warehouse. This value in updated only in case a receipt is done against a Stock Transfer. See also Warehouse

VarWChar

50

ToWarehouseKey

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

VarWChar

50

SourceType

Source Type of goods receipt.

Valid values are:

None = 0

PurchaseOrder = 1

StockTransfer = 2

Integer

4

SiteId

Site id where the goods receipt is done

Integer

4

ReceiptDate

Date of receiving of goods

DBTimeStamp

4

GoodsReceiptNumber

Reference number of goods receipt

VarWChar

20

ReasonCodeKey

Reference Key of Reason Code for goods receipt. See also Reason Code

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

BusinessPartnerType

If the goods receipt is done from a Business partner then the type of the Business Partner.

Valid values are:

None = 0

Customer = 1

Vendor = 2

Integer

4

BusinessPartnerKey

Source key of the business partner depending on the business partner type

VarWChar

50

SalesPersonKey

Reference key of the Sales person. See also Employee

VarWChar

50

CommentKey

Reference Key of Comment for goods receipt. See also Comment

VarWChar

50

EventKey

Reference Key of Event. See also Event

VarWChar

50

((0))

ReferenceNumber1

Specify the reference number of the Inventory Good Receipt transaction to be searched.

VarWChar

50

ReferenceNumber2

Specify the reference number of the Inventory Good Receipt transaction to be searched.

VarWChar

50

ReferenceNumber

Specify the reference number of the Inventory Good Receipt transaction to be searched.

VarWChar

100

BusinessDate

Date of Business

DBTimeStamp

4

POSDocumentNumberSeriesKey

Reference Key for the POS Document number series

VarWChar

50

StoreCurrencyKey

Reference for the Store currency key.

VarWChar

50

StoreCurrencyExchangeRate

Value is the currency exchange rate for store

Numeric

9 (20,5)

Total

Value is the total for the goods received

Numeric

9 (20,5)

((0))

FromLocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

ToLocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

ExchangeRate

Value is the Exchange Rate used for the Good Receipt.

Numeric

9 (20,5)

DocumentCurrencyKey

Reference Key of Currency. See also PmtCurrency.

VarWChar

50

PriceListKey

Reference Key of Price List. See also PrcPriceList.

VarWChar

50

RowRevision

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

Binary

8

IsDeleted

Value is True if the record has been deleted from the system. Record is always Hard Deleted

Boolean

1

((0))

Comments

Stores comments.

VarWChar

4000

IsAdjustmentEntry

Value is true, this transaction is created to adjust the inventory only.

Boolean

1

((0))

SurchargeTotal

Numeric

9 (20,5)

((0))

Id

VarWChar

20

Description

VarWChar

100

Index

Description

Primary

Unique

PK_InvGoodReceipt

Database Object

Object Type

Description

Dep Level

CancelStockTransfer

Stored Procedure

1

GoodsReceiptPOReport

Stored Procedure

1

GoodsReceiptReport

Stored Procedure

1

Integration_GoodsReceipt

Stored Procedure

1

Integration_GoodsReceiptSerialBatch

Stored Procedure

1

Integration_GoodsReceiptSerialBatchShortReceived

Stored Procedure

1

ReplicationRecordsToSend

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

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

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

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

[SourceType] [int] NOT NULL,

[SiteId] [int] NOT NULL,

[ReceiptDate] [datetime] NOT NULL,

[GoodsReceiptNumber] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

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

[BusinessPartnerType] [int] NOT NULL,

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

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

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

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

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

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

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

[BusinessDate] [datetime] NULL,

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

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

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

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

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

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

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

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

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

[RowRevision] [timestamp] NOT NULL,

[IsDeleted] [bit] NOT NULL,

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

[IsAdjustmentEntry] [bit] NOT NULL,

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

[Id] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

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

CONSTRAINT [PK_InvGoodReceipt] PRIMARY KEY CLUSTERED

(

[GoodsReceiptKey] 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].[InvGoodReceipt] ADD CONSTRAINT [DF_InvGoodReceipt_EventKey] DEFAULT ((0)) FOR [EventKey]

ALTER TABLE [dbo].[InvGoodReceipt] ADD CONSTRAINT [DF_InvGoodReceipt_Total] DEFAULT ((0)) FOR [Total]

ALTER TABLE [dbo].[InvGoodReceipt] ADD CONSTRAINT [DF_InvGoodReceipt_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]

ALTER TABLE [dbo].[InvGoodReceipt] ADD CONSTRAINT [DF_InvGoodReceipt_IsAdjustmentEntry] DEFAULT ((0)) FOR [IsAdjustmentEntry]

ALTER TABLE [dbo].[InvGoodReceipt] ADD CONSTRAINT [DF_InvGoodReceipt_SurchargeTotal] DEFAULT ((0)) FOR [SurchargeTotal]