iVend Database Database : TrxTransactionSaleItem 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.

Valid values are:

Sale = 0

Refund = 1

Exchange = 2

DeliveryAgainstSpecialOrder = 3

DeliveryAgainstSale = 4

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

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

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.

Valid values are:

None = 0

System = 1

Manual = 2

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.

Valid values are:

None = 0

Amount = 1

Percent = 2

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)

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

DeliveryWarehouseKey

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

VarWChar

50

((0))

BookingStoreKey

Stores the StoreKey of the Store from where the transaction is being done

VarWChar

50

((0))

BookingWarehouseKey

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

VarWChar

50

((0))

TotalTaxableAmount

Stores the amount on which the tax would be calculated

Numeric

9 (20,5)

((0))

ParentTransactionItemKey

Stores the TransactionItem Key against which these items are added in the transaction.

VarWChar

50

((0))

IsUpsellItem

Specifies if the item is added as an upsell item in the transaction.

Boolean

1

((0))

UpsellProductKey

Stores the product key of the item against which these items are added in the transaction.

VarWChar

50

((0))

IsTaxInclusive

This setting is copied from product setup while doing the transaction. Setting specifies if the item is marked as TaxInclusive item.

Boolean

1

((0))

IgnoreDiscountItemsForSaleDiscount

Value is true if the sale discount should not be applied on already discounted items.

Boolean

1

((0))

ManualDiscountType

Stores manual Discount type

Integer

4

((0))

ManualDiscountAmount

Stores the Discount amount applied manually in a transaction

Numeric

9 (20,5)

((0))

ManualDiscountPercent

Stores the Discount percent applied manually in a transaction

Numeric

9 (20,5)

((0))

CouponDiscountAmount

Stores the Discount amount applied using Coupon

Numeric

9 (20,5)

((0))

SystemDiscountAmount

Stores the Discount amount applied at System level.

Numeric

9 (20,5)

((0))

PromotionalDiscountAmount

Stores the Discount amount applied on promotion

Numeric

9 (20,5)

((0))

SystemDiscountPercent

Stores the value of System discount in percent

Numeric

9 (20,5)

((0))

SystemDiscountType

Stores System Discount type

Numeric

9 (20,5)

((0))

UOMQuantity

Stores the quantity of an item on transaction

Numeric

9 (20,5)

UOMBaseQuantity

In case the item has UoM selected on transaction, then this field store the converion of the quantity between base and sold UoM. For e.g if the sold UoM is dozen then this field will have the value as 12

Numeric

9 (20,5)

UOMGroupDetailKey

Contains the key

VarWChar

50

AverageCost

Stores the Average Cost

Numeric

9 (20,5)

ScannedBarcode

Stores the Scanned bar Code

LongVarWChar

16

ScannedBarcodeSource

Stores the Scanned BarCode Source.

Valid values are:

BarcodeScan = 0,

ManualScan = 1,

Upsell = 2,

Promotion =3,

ProductSearch =4,

AlternateProductView= 5

Integer

4

((0))

PaymentDiscount

Store the Discount provided during a Sale Transaction

Numeric

9 (20,5)

IsDeliveryPackage

Identifies if the delivery is done against a mobile delivery package

Boolean

1

DeliveryLocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

HasCostMarginOverride

Value is True if the Cost Margin Overrride has been applied on the Sale Item

Boolean

1

((0))

ExchangeRate

Stores the Exchange rate for the Currency used for the Sale Item

Numeric

9 (20,5)

((1))

PriceEC

Price of an Item in Enterprise Currency

Numeric

9 (38,7)

([Price]*[ExchangeRate])

AverageCostEC

Stores the Average Cost for the sale item with respect to Enterprise Currency.

Numeric

9 (38,7)

([AverageCost]*[ExchangeRate])

TotalEC

Stores the Enterprise Currency for the Total of transaction sale item

Numeric

9 (38,7)

([Total]*[ExchangeRate])

TaxEC

Stores the Enterprise Currency for the Tax on transaction sale item

Numeric

9 (38,7)

([Tax]*[ExchangeRate])

TotalPostSaleDiscountEC

Stores the Enterprise Currency for the Post Sale Discount for a transaction.

Numeric

9 (38,7)

([TotalPostSaleDiscount]*[ExchangeRate])

SubTotalEC

SubTotal of an Item in Enterprise Currency

Numeric

9 (38,7)

([SubTotal]*[ExchangeRate])

IsTaxFree

Value is True if the added item is Tax Free

Boolean

1

((0))

OriginalTaxCodeKey

Value is the Reference for the Tax code key. See Tax code

VarWChar

50

((0))

OriginalTaxRate

Value is the Original Tax rate for the Sale Item

Numeric

9 (20,5)

((0))

OriginalTax

Value is the Original Tax applied on the Sale Item

Numeric

9 (20,5)

((0))

IsDonationItem

Value is true if the Item added in the Transaction is Donation Item

Boolean

1

((0))

Comments

Stores comments

VarWChar

4000

Integration1

Additional Field for ERP Integration - Alpha numeric type

VarWChar

100

Integration2

Additional Field for ERP Integration - Alpha numeric type

VarWChar

100

Integration3

Additional Field for ERP Integration - Alpha numeric type

VarWChar

100

Integration4

Additional Field for ERP Integration - Alpha numeric type

VarWChar

100

Integration5

Additional Field for ERP Integration - Alpha numeric type

VarWChar

100

Integration6

Additional Field for ERP Integration - Numeric type

Numeric

9 (20,5)

Integration7

Additional Field for ERP Integration - Numeric type

Numeric

9 (20,5)

Integration8

Additional Field for ERP Integration - Numeric type

Numeric

9 (20,5)

Integration9

Additional Field for ERP Integration - Numeric type

Numeric

9 (20,5)

Integration10

Additional Field for ERP Integration - Numeric type

Numeric

9 (20,5)

Index

Description

Primary

Unique

IX_TrxTransactionSaleItem

IX_TrxTransactionSaleItem_1

IX_TrxTransactionSaleItem_2

PK_TrxTransactionSaleItem

Database Object

Object Type

Description

Dep Level

DailySaleSummary

User Defined Function

1

Forecast

Stored Procedure

1

GetTransactionLinkDocument

Stored Procedure

1

Integration_funcTransaction

User Defined Function

1

Integration_TransactionSurcharge

Stored Procedure

1

Loy_GetLayawayPlanKey

Stored Procedure

1

Loy_GetTransactionLineItem

Stored Procedure

1

RPT_ABCAnalysis

Stored Procedure

1

Rpt_ItemWithoutSale

User Defined Function

1

RPT_StoreAnalysis

Stored Procedure

1

rptClosingBalanceQuantity

User Defined Function

1

rptOpeningBalance_dailyClosingBal

User Defined Function

1

rptOpeningBalance_Location

User Defined Function

1

rptSalesData

User Defined Function

1

rptSalesTransactionData

User Defined Function

1

rptSalesTransactionDataWithSalesPerson

User Defined Function

1

SalesAnalysisbySalesPersons

Stored Procedure

2

SalesDetail

User Defined Function

1

TrxCompleteTransactionUpdates

Stored Procedure

1

TrxInventoryUpdateBatchNumber

Stored Procedure

1

TrxInventoryUpdateCheckNegativeInventory

Stored Procedure

1

TrxInventoryUpdateOrder

Stored Procedure

Handles updates related to Order item

1

TrxInventoryUpdatePaymentDiscount

Stored Procedure

Handles updates related to sale item

1

TrxInventoryUpdateQuotation

Stored Procedure

Handles updates related to Quotation item

1

TrxInventoryUpdateSaleDelivery

Stored Procedure

Handles updates related to delivery of a Sale item

1

TrxInventoryUpdateSaleItem

Stored Procedure

Handles updates related to sale item

1

TrxInventoryUpdateSerialNumber

Stored Procedure

1

TrxInventoryUpdatesSaleRefund

Stored Procedure

Handles updates related to On Account payments

1

TrxUpdateCustomerBalance

Stored Procedure

1

uspTapeReport

Stored Procedure

1

vw_GrossProfit

View

1

vw_InventoryCost

View

1

vw_InventoryMovement

View

1

vw_SalesReportData

View

1

vwAnalytics_GiftCertificates

View

1

vwAnalytics_MerchandisePromotionSales

View

1

vwAnalytics_MerchandiseSales

View

1

vwAnalytics_NetSales

View

1

vwAnalytics_PromotionSales

View

1

vwAnalytics_Sales

View

1

vwAnalytics_SalesPerson

View

1

vwAnalytics_UpSellSales

View

1

XTapeReport

Stored Procedure

Generates the XTape report for a particular till

1

ZTapeReport

Stored Procedure

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[TrxTransactionSaleItem](

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

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

[Type] [int] NOT 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 NOT NULL,

[HasSerialNumber] [bit] NOT NULL,

[HasBatchNumber] [bit] NOT NULL,

[HasFulfillment] [bit] NOT NULL,

[HasSurcharges] [bit] NOT NULL,

[HasDiscounts] [bit] NOT NULL,

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

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

[HasTaxCodeOverride] [bit] NOT NULL,

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

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

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

[PriceSource] [int] NOT NULL,

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

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

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

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

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

[DiscountType] [int] NOT NULL,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

[IsPromotionApplied] [bit] NOT NULL,

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

[HasDiscountOverride] [bit] NOT NULL,

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

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

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

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

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

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

[IsUpsellItem] [bit] NOT NULL,

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

[IsTaxInclusive] [bit] NOT NULL,

[IgnoreDiscountItemsForSaleDiscount] [bit] NOT NULL,

[ManualDiscountType] [int] NOT NULL,

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

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

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

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

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

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

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

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

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

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

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

[ScannedBarcode] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ScannedBarcodeSource] [int] NULL,

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

[IsDeliveryPackage] [bit] NULL,

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

[HasCostMarginOverride] [bit] NULL,

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

[PriceEC] AS ([Price]*[ExchangeRate]),

[AverageCostEC] AS ([AverageCost]*[ExchangeRate]),

[TotalEC] AS ([Total]*[ExchangeRate]),

[TaxEC] AS ([Tax]*[ExchangeRate]),

[TotalPostSaleDiscountEC] AS ([TotalPostSaleDiscount]*[ExchangeRate]),

[SubTotalEC] AS ([SubTotal]*[ExchangeRate]),

[IsTaxFree] [bit] NOT NULL,

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

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

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

[IsDonationItem] [bit] NULL,

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

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

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

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

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

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

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

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

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

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

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

CONSTRAINT [PK_TrxTransactionSaleItem] 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] TEXTIMAGE_ON [PRIMARY]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_DeliveryWarehouseKey] DEFAULT ((0)) FOR [DeliveryWarehouseKey]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_BookingStoreKey] DEFAULT ((0)) FOR [BookingStoreKey]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_BookingWarehouseKey] DEFAULT ((0)) FOR [BookingWarehouseKey]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_TotalTaxableAmount] DEFAULT ((0)) FOR [TotalTaxableAmount]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_ParentTransactionItemKey] DEFAULT ((0)) FOR [ParentTransactionItemKey]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_IsUpsellItem] DEFAULT ((0)) FOR [IsUpsellItem]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_UpsellProductKey] DEFAULT ((0)) FOR [UpsellProductKey]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_IsTaxInclusive] DEFAULT ((0)) FOR [IsTaxInclusive]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_IgnoreDiscountItemsForSaleDiscount] DEFAULT ((0)) FOR [IgnoreDiscountItemsForSaleDiscount]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_ManualDiscountType] DEFAULT ((0)) FOR [ManualDiscountType]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_ManualDiscountAmount] DEFAULT ((0)) FOR [ManualDiscountAmount]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_ManualDiscountPercent] DEFAULT ((0)) FOR [ManualDiscountPercent]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_CouponDiscountAmount] DEFAULT ((0)) FOR [CouponDiscountAmount]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_SystemDiscountAmount] DEFAULT ((0)) FOR [SystemDiscountAmount]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_PromotionalDiscountAmount] DEFAULT ((0)) FOR [PromotionalDiscountAmount]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_SystemDiscountPercent] DEFAULT ((0)) FOR [SystemDiscountPercent]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_SystemDiscountType] DEFAULT ((0)) FOR [SystemDiscountType]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_ScannedBarcodeSource] DEFAULT ((0)) FOR [ScannedBarcodeSource]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_HasCostMarginOverride] DEFAULT ((0)) FOR [HasCostMarginOverride]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_ExchangeRate] DEFAULT ((1)) FOR [ExchangeRate]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_IsTaxFree] DEFAULT ((0)) FOR [IsTaxFree]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_OriginalTaxCodeKey] DEFAULT ((0)) FOR [OriginalTaxCodeKey]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_OriginalTaxRate] DEFAULT ((0)) FOR [OriginalTaxRate]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF_TrxTransactionSaleItem_OriginalTax] DEFAULT ((0)) FOR [OriginalTax]

ALTER TABLE [dbo].[TrxTransactionSaleItem] ADD CONSTRAINT [DF__TrxTransa__IsDon__72A6DC10] DEFAULT ((0)) FOR [IsDonationItem]