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

TransactionLayawayKey

System generated Primary key of the table.

VarWChar

50

((0))

TransactionKey

Refers to the key of the transaction. See also Transaction

VarWChar

50

Type

Refers to the type of the transaction.

Valid values are:

Layaway = 0

Cancel = 1

Integer

4

WareHouseKey

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

VarWChar

50

ProductKey

Refers to the key of the product.See also Product

VarWChar

50

InventoryItemKey

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

VarWChar

50

Description

Refers to the item description.

VarWChar

100

LayawayPlanKey

Refers to the key of the Layaway plan. See also Layaway Plan

VarWChar

50

OriginalPrice

Refers to the original price that had been set for the product.

Numeric

9 (20,5)

BasePrice

Refers to the price of the product considering whether it is TaxInclusive or not.

Numeric

9 (20,5)

Price

Refers to the overridden price of the product.

Numeric

9 (20,5)

PriceSource

Refers to the price source.

Valid values are:

None =0

System = 1

Manual = 2

Integer

4

InstallmentCount

Number of installments in which the amount is to be returned.

Integer

4

HasInstallmentOverride

Flag to specify whether user has manually changed the installment count or not

Boolean

1

Quantity

Quantity of the product which is being given on Layaway.

Numeric

9 (20,5)

OpenQuantity

Quantity that remains to be fulfilled.

Numeric

9 (20,5)

FullfilledQuantity

Quantity of the product on Layaway which has been fulfilled.

Numeric

9 (20,5)

RefundedQuantity

Quantity of the product on Layaway which has been refunded.

Numeric

9 (20,5)

Tax

Total taxes aaplicable on the Layaway.

Numeric

9 (20,5)

SurchargeTotal

Total surcharges aaplicable on the Layaway plan.

Numeric

9 (20,5)

DiscountType

Discount type applicable.

Valid values are:

None = 0

Amount = 1

Percent = 2

Integer

4

DiscountAmount

Total amount of discount aaplicableon the Layaway plan.

Numeric

9 (20,5)

DiscountPercent

Total percentage of discount applicable on the Layaway plan.

Numeric

9 (20,5)

SaleDiscountAmount

Total amount of discount applicable at the sale level.

Numeric

9 (20,5)

ExclusiveDiscountPercent

Discount percentage applied on the Line item on exclusive price

Numeric

9 (20,5)

HasSerialNumber

Flag to check whether the product has a serial no or not.

Boolean

1

HasBatchNumber

Flag to check whether the product has a batch no or not.

Boolean

1

HasFulfillment

Flag to Check whether the Lawaway plan has a fulfillment plan attached to it or not.

Boolean

1

HasSurcharges

Flag to Check whether the Lawaway plan has a surchrges attached to it or not.

Boolean

1

HasDiscounts

Flag to Check whether the Lawaway plan has discounts or not.

Boolean

1

TaxCodeKey

Refers to the tax code key applicable on the line item. See also Tax Code

VarWChar

50

TaxRate

Refers to the Tax percentage.

Numeric

9 (20,5)

SubTotal

Refers to the price of the product.

Numeric

9 (20,5)

HasTaxCodeOverride

Flag to check whether the tax code can be overriden or not.(Not being updated)

Boolean

1

PostTaxDiscount

For future use

Numeric

9 (20,5)

PostTaxDiscountLiability

For future use

Numeric

9 (20,5)

PostTaxDiscountStoreLiability

For future use

Numeric

9 (20,5)

TaxableDiscountAmount

For future use

Numeric

9 (20,5)

StoreTaxableDiscountAmount

For future use

Numeric

9 (20,5)

Total

Is the sum of SubTotal + Tax

Numeric

9 (20,5)

TotalBeforeSaleDiscount

Refers to the total before the sale level discount has been applied.

Numeric

9 (20,5)

TotalPostSaleDiscount

Refers to the total after the sale level discount has been applied.

Numeric

9 (20,5)

Status

Refers to the status of the layaway.

Valid values are:

Open = 0

Closed = 1

Cancelled = 2

Integer

4

CommentKey

Refers to the key of the comments added to the layway.

VarWChar

50

InstallmentStartDate

Refers to date on which the first installment begins.

DBTimeStamp

4

ProductDetailKey

Refers to the Serial or the Batchkey from the InvSerial or InvBatch table.

VarWChar

50

Deposit

Total amount supposed to be deposited by the customer according to the layaway plan.

Numeric

9 (20,5)

DepositType

Whether the initial deposit has been given in amount or percentage.

Valid values are:

Amount = 0

Percentage = 1

Integer

4

OriginalDetailKey

Refers to the TransactionLayawayKey in case of layway cancellation.

VarWChar

50

OriginalDocumentKey

Refers to the TransactionKey in case of layway cancellation.

VarWChar

50

DepositAmount

Total amount deposited by the customer at the beginning.

Numeric

9 (20,5)

FulfillmentSurchargeTotal

Total surcharge amount on the fulfillment plan attached to the layaways.

Numeric

9 (20,5)

TotalPayableAmount

Total amount to be paid by the customer.

Numeric

9 (20,5)

PaidAmount

Total amount actually paid by the customer.

Numeric

9 (20,5)

BalanceAmount

Is the amount that remains to be paid by the customer (TotalPayableAmount - PaidAmount)

Numeric

9 (20,5)

InventoryAllocationMethod

Refers to the inventory allocation method.

Valid values are:

Sale = 0

Delivery = 1

Integer

4

IsPromotionApplied

Flag to check whther the promotion is applied or not

Boolean

1

PromotionalQuantity

Refers to the quantity on which the promotion is applied

Numeric

9 (20,5)

HasDiscountOverride

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

Boolean

1

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))

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

Flag to mark if the sale discount is to be ignored for this product when line discount is applied at the time of transaction

Boolean

1

((0))

ManualDiscountType

Manual Discount type applicable

Valid values are:

None = 0

Amount = 1

Percent = 2

Integer

4

((0))

ManualDiscountAmount

Stores the manual Discount Amount based on Discount Type chosen

Numeric

9 (20,5)

((0))

ManualDiscountPercent

Stores the manual Discount percent based on Discount type chosen

Numeric

9 (20,5)

((0))

CouponDiscountAmount

Stores the Coupon Discount Amount

Numeric

9 (20,5)

((0))

SystemDiscountAmount

Stores the System Discount Amount

Numeric

9 (20,5)

((0))

PromotionalDiscountAmount

Stores the applied Promotion Discount Amount

Numeric

9 (20,5)

((0))

SystemDiscountPercent

Stores the System Discount percent

Numeric

9 (20,5)

((0))

SystemDiscountType

System Discount type applicable

Valid values are:

None = 0

Amount = 1

Percent = 2

Numeric

9 (20,5)

((0))

UOMQuantity

Stores the UOM quantity

Numeric

9 (20,5)

((1))

UOMBaseQuantity

Stores the Base UOM quantity

Numeric

9 (20,5)

((1))

UOMGroupDetailKey

Reference Key for the UOM Group Detail

VarWChar

50

((0))

AverageCost

Stores the average cost for the Transaction layaway

Numeric

9 (20,5)

ScannedBarcode

Stores the current Scanned Barcode value

VarWChar

50

ScannedBarcodeSource

Value is the source from where the product barcode has been entered. The valid values are:

BarcodeScan = 0,

ManualScan = 1,

Upsell = 2,

Promotion =3,

ProductSearch =4,

AlternateProductView= 5

Integer

4

((0))

HasCostMarginOverride

Value is True if the Cost Margin Overrride has been applied on item for the transaction order

Boolean

1

((0))

DeliveryLocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

ExchangeRate

Stores the Exchange rate for the Currency used in transaction laywawy

Numeric

9 (20,5)

((1))

TotalEC

Stores the Enterprise Currency for the Total of a Transaction layaway order

Numeric

9 (38,7)

([Total]*[ExchangeRate])

SubTotalEC

Stores the Enterprise Currency for the Sub total for a transaction layaway order

Numeric

9 (38,7)

([SubTotal]*[ExchangeRate])

PriceEC

Stores the Enterprise Currency for the price of an item in Layaway transaction

Numeric

9 (38,7)

([Price]*[ExchangeRate])

TotalPostSaleDiscountEC

Stores the Enterprise Currency for the Total Post Sale Discount for layaway order

Numeric

9 (38,7)

([TotalPostSaleDiscount]*[ExchangeRate])

TaxEC

Stores the Enterprise Currency for the Tax on transaction layaway order

Numeric

9 (38,7)

([Tax]*[ExchangeRate])

AverageCostEC

Stores the Enterprise Currency for the Average Cost for the Layway transaction

Numeric

9 (38,7)

([AverageCost]*[ExchangeRate])

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_TrxTransactionLayaway

IX_TrxTransactionlayaway_1

PK_TrxTransactionLayaway

Database Object

Object Type

Description

Dep Level

DailySaleSummary

User Defined Function

1

Integration_ARPayment

Stored Procedure

1

Integration_funcTransaction

User Defined Function

1

Integration_TransactionSurcharge

Stored Procedure

1

Loy_GetLayawayPlanKey

Stored Procedure

1

RPT_ABCAnalysis

Stored Procedure

1

rpt_LayAway

Stored Procedure

1

RPT_StoreAnalysis

Stored Procedure

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

2

TrxGenerateLayawayInstallments

Stored Procedure

Generates Layaway installments for the Layaway transaction

1

TrxGenerateLayawayInstallmentsForSaleLevel

Stored Procedure

Generates Layaway installments for the Layaway transaction

1

TrxInventoryUpdateBatchNumber

Stored Procedure

1

TrxInventoryUpdateCheckNegativeInventory

Stored Procedure

1

TrxInventoryUpdateLaybyCancellationItem

Stored Procedure

1

TrxInventoryUpdateLaybyItem

Stored Procedure

1

TrxInventoryUpdateSaleDelivery

Stored Procedure

Handles updates related to delivery of a Sale item

1

TrxInventoryUpdateSerialNumber

Stored Procedure

1

TrxUpdateCustomerBalance

Stored Procedure

1

vw_InventoryMovement

View

1

vw_SalesReportData

View

1

XTapeReport

Stored Procedure

Generates the XTape report for a particular till

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[TrxTransactionLayaway](

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

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

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

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

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

[PriceSource] [int] NOT NULL,

[InstallmentCount] [int] NOT NULL,

[HasInstallmentOverride] [bit] 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,

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

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

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

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

[HasTaxCodeOverride] [bit] NOT NULL,

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

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

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

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

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

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

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

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

[Status] [int] NOT NULL,

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

[InstallmentStartDate] [datetime] NOT NULL,

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

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

[DepositType] [int] NOT NULL,

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

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

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

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

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

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

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

[InventoryAllocationMethod] [int] NOT NULL,

[IsPromotionApplied] [bit] NOT NULL,

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

[HasDiscountOverride] [bit] NOT 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,

[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) NOT NULL,

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

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

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

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

[ScannedBarcodeSource] [int] NULL,

[HasCostMarginOverride] [bit] NULL,

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

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

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

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

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

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

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

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

[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_TrxTransactionLayaway] PRIMARY KEY CLUSTERED

(

[TransactionLayawayKey] 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].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_TransactionLayawayKey] DEFAULT ((0)) FOR [TransactionLayawayKey]

ALTER TABLE [dbo].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_DeliveryWarehouseKey] DEFAULT ((0)) FOR [DeliveryWarehouseKey]

ALTER TABLE [dbo].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_BookingStoreKey] DEFAULT ((0)) FOR [BookingStoreKey]

ALTER TABLE [dbo].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_BookingWarehouseKey] DEFAULT ((0)) FOR [BookingWarehouseKey]

ALTER TABLE [dbo].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_TotalTaxableAmount] DEFAULT ((0)) FOR [TotalTaxableAmount]

ALTER TABLE [dbo].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_IsTaxInclusive] DEFAULT ((0)) FOR [IsTaxInclusive]

ALTER TABLE [dbo].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_IgnoreDiscountItemsForSaleDiscount] DEFAULT ((0)) FOR [IgnoreDiscountItemsForSaleDiscount]

ALTER TABLE [dbo].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_ManualDiscountType] DEFAULT ((0)) FOR [ManualDiscountType]

ALTER TABLE [dbo].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_ManualDiscountAmount] DEFAULT ((0)) FOR [ManualDiscountAmount]

ALTER TABLE [dbo].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_ManualDiscountPercent] DEFAULT ((0)) FOR [ManualDiscountPercent]

ALTER TABLE [dbo].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_CouponDiscountAmount] DEFAULT ((0)) FOR [CouponDiscountAmount]

ALTER TABLE [dbo].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_SystemDiscountAmount] DEFAULT ((0)) FOR [SystemDiscountAmount]

ALTER TABLE [dbo].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_PromotionalDiscountAmount] DEFAULT ((0)) FOR [PromotionalDiscountAmount]

ALTER TABLE [dbo].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_SystemDiscountPercent] DEFAULT ((0)) FOR [SystemDiscountPercent]

ALTER TABLE [dbo].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_SystemDiscountType] DEFAULT ((0)) FOR [SystemDiscountType]

ALTER TABLE [dbo].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_UOMQuantity] DEFAULT ((1)) FOR [UOMQuantity]

ALTER TABLE [dbo].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_UOMBaseQuantity] DEFAULT ((1)) FOR [UOMBaseQuantity]

ALTER TABLE [dbo].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_UOMGroupDetailKey] DEFAULT ((0)) FOR [UOMGroupDetailKey]

ALTER TABLE [dbo].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_ScannedBarcodeSource] DEFAULT ((0)) FOR [ScannedBarcodeSource]

ALTER TABLE [dbo].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_HasCostMarginOverride] DEFAULT ((0)) FOR [HasCostMarginOverride]

ALTER TABLE [dbo].[TrxTransactionLayaway] ADD CONSTRAINT [DF_TrxTransactionLayaway_ExchangeRate] DEFAULT ((1)) FOR [ExchangeRate]