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

GoodsReturnDetailKey

Primary key

VarWChar

50

GoodsReturnKey

Reference Key of Goods Return. See also Goods Return.

VarWChar

50

LineNumber

Line number of detail

Integer

4

ProductKey

Refers to the product. See also Product

VarWChar

50

InventoryItemKey

Refers to the key the inventory item. See also Inventory Item

VarWChar

50

SourceKey

Value is the source type against which the item is returned Valid values are: Transaction = 0 SpecialOrder = 1 Layaway = 2 Rental = 3 SaleItem = 4 Payments = 6 Fulfillment =7

VarWChar

50

SourceDetailKey

Refers to the Source Detail key based on the Source type chosen

VarWChar

50

TaxKey

Reference of the tax code. See also Tax

VarWChar

50

TaxRate

Tax rate applied of selected Tax Code

Numeric

9 (20,5)

Price

Purchase price of the line item

Numeric

9 (20,5)

Quantity

Quantity of the product

Numeric

9 (20,5)

SubTotal

Total of all the line level totals + Line-level surcharges (excluding the line-level taxes)

Numeric

9 (20,5)

TotalTaxableAmount

Stores the amount on which the tax would be calculated

Numeric

9 (20,5)

Tax

Total of all the taxes for the transaction (like line-level taxes, surcharge taxes, layaway taxes)

Numeric

9 (20,5)

DiscountType

Discount type applicable. Valid values are: None = 0 Amount = 1 Percent = 2

Integer

4

DiscountAmount

Specifies the Discount amount

Numeric

9 (20,5)

DiscountPercentage

Specifies the Discount percentage

Numeric

9 (20,5)

Total

Value is the total amount of the order line item.

Numeric

9 (20,5)

CommentKey

Value is the Comment key. See also Comment

VarWChar

50

ReasonKey

Reference key of reason code. See also Reason Code

VarWChar

50

ItemsPerUnit

Specifies the unit price of item

Numeric

9 (20,5)

((1))

UOMKey

Refers to the UOM key. See InvUOM

VarWChar

50

UOMQuantity

Refers to the UOM Qunatity of the product

Numeric

9 (20,5)

UniqueLineNumber

Hold GUID for Line

VarWChar

50

LocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

Comments

Stores comments.

VarWChar

4000

Index

Description

Primary

Unique

PK_InvGoodsReturnDetail

Database Object

Object Type

Description

Dep Level

Integration_GoodsReturn

Stored Procedure

1

Integration_GoodsReturnSerialBatch

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

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

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

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

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

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

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

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

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

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

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

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

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

[DiscountType] [int] NOT NULL,

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

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

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

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

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

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

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

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

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

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

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

CONSTRAINT [PK_InvGoodsReturnDetail] PRIMARY KEY CLUSTERED

(

[GoodsReturnDetailKey] 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].[InvGoodsReturnDetail] ADD CONSTRAINT [DF_InvGoodsReturnDetail_ItemsPerUnit] DEFAULT ((1)) FOR [ItemsPerUnit]