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

TransactionItemKey

System generated Primary Key

VarWChar

50

TransactionKey

Reference Key of Transaction. See also Transaction

VarWChar

50

Type

The sale item type of transaction made in the transaction.

Integer

4

WarehouseKey

The warehouse associated with the store. See also Warehouse

VarWChar

50

ProductKey

Reference key of the product. See also Product

VarWChar

50

InventoryItemKey

Reference Key of InventoryItem. See also Inventory Item

VarWChar

50

Description

Refers to the description for the Transaction Sale item

VarWChar

100

HasSerialNumber

This flag checks If the product is of serial item, then that item contains the serial numbers or not

Boolean

1

HasBatchNumber

Specifies whether the line item has a valid batch number attached to it

Boolean

1

HasFulfillment

Specifies whether the line item has a valid fulfillment attached to it

Boolean

1

HasSurcharges

Specifies whether the line item has a valid surcharges attached to it

Boolean

1

HasDiscounts

Specifies whether any discounts have been applied on the line item

Boolean

1

TaxCodeKey

Reference Key of TaxCode if given at the line-level. See also Tax

VarWChar

50

TaxRate

The rate of the TaxCode

Numeric

9 (20,5)

HasTaxCodeOverride

This flag checks if the tax code has been overrided by the user

Boolean

1

OriginalPrice

The original price of the sale item

Numeric

9 (20,5)

BasePrice

The price which is tax exclusive

Numeric

9 (20,5)

Price

The overriden price of the sale item

Numeric

9 (20,5)

PriceSource

Value is the price source of the order item.

Integer

4

Quantity

Quantity of the line item

Numeric

9 (20,5)

OpenQuantity

The quantity which remains to be fulfilled (in case of fulfillment attached)

Numeric

9 (20,5)

FullfilledQuantity

The actual quantity that has been fulfilled/delivered (in case of fulfillment attached)

Numeric

9 (20,5)

RefundedQuantity

The quantity which has been refunded

Numeric

9 (20,5)

SubTotal

This amount is the BasePrice * Quantity

Numeric

9 (20,5)

DiscountType

Discount type applicable.

Integer

4

DiscountAmount

Value is the discount amount applied to the line item.

Numeric

9 (20,5)

DiscountPercent

The % of discount been given at the line-level

Numeric

9 (20,5)

SaleDiscountAmount

The discount amount applicable to the sale-level

Numeric

9 (20,5)

SystemDiscount

System-calculated discount

Numeric

9 (20,5)

ExclusiveDiscountPercent

Discount percentage applied on the Line item on exclusive price

Numeric

9 (20,5)

TaxableDiscountAmount

For future use

Numeric

9 (20,5)

StoreTaxableDiscountAmount

For future use

Numeric

9 (20,5)

Tax

Tax of the line-level item

Numeric

9 (20,5)

SurchargeTotal

The surcharge amount given at the line level

Numeric

9 (20,5)

PostTaxDiscount

For future use

Numeric

9 (20,5)

PostTaxDiscountLiability

For future use

Numeric

9 (20,5)

PostTaxDiscountStoreLiability

For future use

Numeric

9 (20,5)

Total

Value is the total amount of the line item.

Numeric

9 (20,5)

TotalBeforeSaleDiscount

Value is the total amount before any sale discount had been applied.

Numeric

9 (20,5)

TotalPostSaleDiscount

Value is the total amount after any sale discount applied.

Numeric

9 (20,5)

OriginalDocumentKey

References to the original transaction key, used in case of refund, deliveries

VarWChar

50

OriginalDetailKey

References to the original detail key, used in case of refund, deliveries

VarWChar

50

CommentKey

Refers to the comment key. See also Comment

VarWChar

50

ProductDetailKey

References to the SerialKey/BatchKey of Serial/Batch, in case you made the transaction for serial/batch product

VarWChar

50

IsExchange

Flag to mark the sale-item entry as exchangeable

Boolean

1

IsPromotionApplied

Flag to check whether promotion is applied or not

Boolean

1

PromotionalQuantity

Refers to the promotional quantity

Numeric

9 (20,5)

HasDiscountOverride

This flag checks if the discounts has been overrided by the user

Boolean

1

TransactionQuotationKey

Stores the Key of the Quotation from which this item is converted to sale item.

VarWChar

50

UserKey

Reference Key of User who made this transaction. See also User

VarWChar

50

DeliveryWarehouseKey

Stores the WarehouseKey of the warehouse from where the delivery is requested for this item

VarWChar

50

((0))

BookingWarehouseKey

Stores the WarehouseKey of the warehouse from where the transaction is being done

VarWChar

50

((0))

UOMQuantity

Stores the UOM quantity

Numeric

9 (20,5)

UOMGroupDetailKey

Reference Key for the UOM group detail

VarWChar

50

Comments

VarWChar

4000

Index

Description

Primary

Unique

IX_ConTrxTransactionSaleItem

PK_ConTrxTransactionSaleItem

Database Object

Object Type

Description

Dep Level

Integration_Consolidated_Transaction

Stored Procedure

1

Integration_Consolidated_TransactionSurcharge

Stored Procedure

1

TrxConsolidateTransaction

Stored Procedure

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[ConTrxTransactionSaleItem](

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

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

[Type] [int] NULL,

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

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

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

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

[HasSerialNumber] [bit] NULL,

[HasBatchNumber] [bit] NULL,

[HasFulfillment] [bit] NULL,

[HasSurcharges] [bit] NULL,

[HasDiscounts] [bit] NULL,

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

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

[HasTaxCodeOverride] [bit] NULL,

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

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

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

[PriceSource] [int] NULL,

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

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

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

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

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

[DiscountType] [int] NULL,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

[IsExchange] [bit] NULL,

[IsPromotionApplied] [bit] NULL,

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

[HasDiscountOverride] [bit] NULL,

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

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

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

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

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

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

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

CONSTRAINT [PK_ConTrxTransactionSaleItem] PRIMARY KEY CLUSTERED

(

[TransactionItemKey] 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].[ConTrxTransactionSaleItem] ADD CONSTRAINT [DF_ConTrxTransactionSaleItem_DeliveryStoreKey] DEFAULT ((0)) FOR [DeliveryWarehouseKey]

ALTER TABLE [dbo].[ConTrxTransactionSaleItem] ADD CONSTRAINT [DF_ConTrxTransactionSaleItem_BookingWarehouseKey] DEFAULT ((0)) FOR [BookingWarehouseKey]