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

GoodsReceiptDetailKey

Primary Key

VarWChar

50

GoodsReceiptKey

Reference Key of Goods Receipt . See also Goods Receipt

VarWChar

50

LineNumber

Line number of detail

Integer

4

SourceKey

Reference Key of Source of Goods receipt

VarWChar

50

SourceDetailKey

Reference Key of Source Detail

VarWChar

50

ProductKey

Reference Key of product. See also Product

VarWChar

50

QuantityOrdered

Quantity ordered for goods receipt

Numeric

9 (20,5)

QuantityReceived

Total quantity received through goods receipt

Numeric

9 (20,5)

Price

Price of product on which goods will be received

Numeric

9 (20,5)

TaxKey

Reference of the tax code. See also Tax

VarWChar

50

TaxRate

Refers to the tax rate.

Numeric

9 (20,5)

CommentKey

Reference key of Comment. See also Comment

VarWChar

50

ScannedSequence

Stores the Scan sequence for the Good receipt

Integer

4

((0))

ItemsPerUnit

Specifies the Price per unit for the item

Numeric

9 (20,5)

((1))

UOMKey

Reference key of UOM.

VarWChar

50

UOMQuantityReceived

Specifies count of received UOM quantity.

Numeric

9 (20,5)

UOMQuantityOrdered

Specifies count of ordered UOM quantity.

Numeric

9 (20,5)

ReasonCodeKey

Reference key of reason code.

VarWChar

50

((0))

QuantityReturned

Specifies count of returned quantity.

Numeric

9 (20,5)

UOMQuantityReturned

Specifies count of returned UOM quantity.

Numeric

9 (20,5)

UnitCost

Value is the Unit Cost for the Good Receipt

Numeric

9 (20,5)

Total

Value is the total for the goods received

Numeric

9 (20,5)

((0))

UniqueLineNumber

Hold GUID for Line

VarWChar

50

FromLocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

ToLocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

SourceDetailUniqueLineNumber

Hold GUID for Source Line

VarWChar

100

ToWarehouseKey

Reference Key of Warehouse. See also InvWarehouse.

VarWChar

50

((0))

Comments

Stores comments.

VarWChar

4000

SurchargeTotal

Numeric

9 (20,5)

((0))

DiscountType

Integer

4

DiscountAmount

Numeric

9 (20,5)

DiscountPercentage

Numeric

9 (20,5)

Tax

Numeric

9 (20,5)

TotalTaxableAmount

Numeric

9 (20,5)

Index

Description

Primary

Unique

PK_InvGoodReceiptDetail

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

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

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

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

[LineNumber] [int] NOT NULL,

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

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

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

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

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

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

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

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

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

[ScannedSequence] [int] NOT NULL,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

[DiscountType] [int] NULL,

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

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

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

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

CONSTRAINT [PK_InvGoodReceiptDetail] PRIMARY KEY CLUSTERED

(

[GoodsReceiptDetailKey] 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].[InvGoodReceiptDetail] ADD CONSTRAINT [DF_InvGoodReceiptDetail_ScannedSequence] DEFAULT ((0)) FOR [ScannedSequence]

ALTER TABLE [dbo].[InvGoodReceiptDetail] ADD CONSTRAINT [DF_InvGoodReceiptDetail_ItemsPerUnit] DEFAULT ((1)) FOR [ItemsPerUnit]

ALTER TABLE [dbo].[InvGoodReceiptDetail] ADD CONSTRAINT [DF_InvGoodReceiptDetail_ReasonCodeKey] DEFAULT ((0)) FOR [ReasonCodeKey]

ALTER TABLE [dbo].[InvGoodReceiptDetail] ADD CONSTRAINT [DF_InvGoodReceiptDetail_Total] DEFAULT ((0)) FOR [Total]

ALTER TABLE [dbo].[InvGoodReceiptDetail] ADD CONSTRAINT [DF__InvGoodRe__ToWar__3C2ACFCE] DEFAULT ((0)) FOR [ToWarehouseKey]

ALTER TABLE [dbo].[InvGoodReceiptDetail] ADD CONSTRAINT [DF_InvGoodReceiptDetail_SurchargeTotal] DEFAULT ((0)) FOR [SurchargeTotal]