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

GoodsReturnKey

Primary Key

VarWChar

50

AccountingId

Maps to the ERP system unique id. It is a system generated number.

VarWChar

50

SiteId

Value is the site id of the store.

Integer

4

WarehouseKey

Refers to the key of the warehouse from where the product has been selected.See also Warehouse.

VarWChar

50

ReferenceNumber

Reference number of the inventory transaction

VarWChar

20

VendorKey

Refers to the vendor. See also Vendor

VarWChar

50

ReturnDate

Refers to the Return Date of the Item

DBTimeStamp

4

SourceType

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

Integer

4

SourceKey

Value is the key of the source Warehouse

VarWChar

50

DiscountType

Discount type applicable.

Integer

4

DiscountAmount

Refers to the Discout Amount

Numeric

9 (20,5)

DiscountPercentage

Refers to the Discount Percentage

Numeric

9 (20,5)

TaxCodeKey

Reference Key of Tax. See also Tax

VarWChar

50

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

Specifies the Tax for the Item

Numeric

9 (20,5)

SurchargeTotal

The surcharge amount given at the line level

Numeric

9 (20,5)

Total

Value is the total amount of the line item.

Numeric

9 (20,5)

CommentKey

Value is the Comment key. See also Comment

VarWChar

50

ReasonKey

Reference key of the reason code. 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

POSDocumentNumberSeriesKey

Reference Key of POSDocumentNumberSeriesKey. See RtlPosDocumentNumberSeries

VarWChar

50

((0))

StoreCurrencyKey

Reference for the store currency

VarWChar

50

StoreCurrencyExchangeRate

Value is the Exchange rate for the currency at store

Numeric

9 (20,5)

LocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

DocumentCurrencyKey

Reference Key of Currency. See also PmtCurrency.

VarWChar

50

((0))

ExchangeRate

Value is the Exchange Rate used for the Good Receipt.

Numeric

9 (20,5)

RowRevision

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

Binary

8

Comments

Stores comments.

VarWChar

4000

Id

VarWChar

20

Description

VarWChar

100

PurchaseOrderId

VarWChar

20

IsDeleted

Boolean

1

Index

Description

Primary

Unique

PK_InvGoodsReturn

Database Object

Object Type

Description

Dep Level

Integration_GoodsReturn

Stored Procedure

1

Integration_GoodsReturnSerialBatch

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

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

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

[SiteId] [int] NOT NULL,

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

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

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

[ReturnDate] [datetime] NOT NULL,

[SourceType] [int] NOT NULL,

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

[DiscountType] [int] NOT NULL,

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

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

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

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

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

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

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

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

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

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

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

[RowRevision] [timestamp] NOT NULL,

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

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

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

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

[IsDeleted] [bit] NULL,

CONSTRAINT [PK_InvGoodsReturn] PRIMARY KEY CLUSTERED

(

[GoodsReturnKey] 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].[InvGoodsReturn] ADD CONSTRAINT [DF_InvGoodsReturn_POSDocumentNumberSeriesKey] DEFAULT ((0)) FOR [POSDocumentNumberSeriesKey]

ALTER TABLE [dbo].[InvGoodsReturn] ADD CONSTRAINT [DF_InvGoodsReturn_DocumentCurrencyKey] DEFAULT ((0)) FOR [DocumentCurrencyKey]