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

TransactionKey

System generated Primary Key

VarWChar

50

StoreKey

Reference Key of Store at which the POS is connected. See also Store

VarWChar

50

POSKey

Reference Key of POS at which the transaction is made. See also POS

VarWChar

50

UserKey

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

VarWChar

50

ActualDate

The date on which the transaction is done.

DBTimeStamp

4

BusinessDate

Business date of the store

DBTimeStamp

4

TransactionId

A number is generated according to the Transaction Numbering Settings at RetailProfile

VarWChar

50

CustomerRefNumber

Any reference number that needs to be stored against the transaction

VarWChar

100

CustomerKey

Reference Key of Customer for which the transaction is made. See also Customer

VarWChar

50

ContactKey

Reference Key of Contact. If the customer is the company, then the contact for the company is stored. See also Contact

VarWChar

50

DepartmentKey

Reference Key of Department. See also Department

VarWChar

50

IsTaxExempt

If the TaxCode is of the exempt type for the transaction, then this flag set to true

Boolean

1

HasSignature

For future use

Boolean

1

HasTaxCodeOverride

If the tax is overriden at the transaction level, then this flag is true, else false

Boolean

1

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)

DiscountType

Discount type applicable.

Valid values are:

None = 0

Amount = 1

Percent = 2

Integer

4

DiscountAmount

Discount in amount given at the transaction level

Numeric

9 (20,5)

DiscountPercent

Discount in percentage given at the transaction level

Numeric

9 (20,5)

TaxableDiscountAmount

For future use

Numeric

9 (20,5)

StoreTaxableDiscountAmount

For future use

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)

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

Subtotal + Sale- level surcharges + Tax - Sale-level discount

Numeric

9 (20,5)

AgeVerificationDate

This is the DOB of customer who buys the product (having the check of age verification) in the transaction

DBTimeStamp

4

EventKey

Reference Key of Event. See also Event

VarWChar

50

CommentKey

Reference Key of Comment. The comment given at the SaleEdit screen. See also Comment

VarWChar

50

IsSuspended

Signifies whether the transaction is a suspended transaction or not

Boolean

1

HasSurcharges

Flag for checking the surcharges has been given at the transaction, if given this flag will be true

Boolean

1

SurchargesTotal

Total of the sale-level surcharges after discount & tax

Numeric

9 (20,5)

PayableAmount

The amount which needs to be paid by the customer.

Numeric

9 (20,5)

HasManagerOverride

Whether manager override was done during this transaction or not

Boolean

1

ManagerKey

Reference Key of Manager in case of manager override. See also Security User

VarWChar

50

HasLayaways

Whether any layaway type of item is added to this transaction

Boolean

1

HasLayawaysCancellations

Whether any layaway cancellation type of item is added to this transaction

Boolean

1

HasSales

Whether any sales type of item is added to this transaction

Boolean

1

HasSaleExchanges

Whether any sales exchange type of item is added to this transaction

Boolean

1

HasDeliveries

Whether any delivery type of item is added to this transaction

Boolean

1

HasRefunds

Whether any refund type of item is added to this transaction

Boolean

1

HasOrders

Whether any order type of item is added to this transaction

Boolean

1

HasFulFillments

Whether any fulfillment type of item is added to this transaction

Boolean

1

HasARPayments

Whether any AR payment type of item is added to this transaction

Boolean

1

TillKey

Refers to the till. See also Till

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

HasQuotations

Whether any quotation item is added to this transaction

Boolean

1

((0))

QuotationValidityDate

Quotation validity date.

DBTimeStamp

4

ActualDiscountPercent

Discount in percentage given at the transaction level

Numeric

9 (20,5)

HasGiftCertificates

Whether any Gift certificates type of item is added to this transaction

Boolean

1

HasLostSaleItems

Signifies if the transaction has any Sales Lost items recorded in the current transaction. These details will be found in the TrxTransactionLostSaleItem table.

Boolean

1

((0))

TotalTaxableAmount

Stores the amount on which the tax would be calculated

Numeric

9 (20,5)

((0))

SaleDiscountAfterTax

This setting is copied from Enterprise setup while doing the transaction. If this flag is checked then system will apply the same level discount on the Sale Total After Tax else the system will apply the same discount on Sale Total Before Tax

Boolean

1

((0))

IgnoreDiscountItemsForSaleDiscount

This setting is copied from Enterprise setup while doing the transaction. If this flag is checked then sale discount is not be applied on the items for which the line level discount is given.

Boolean

1

((0))

FiscalDocumentNumber

Stores the Document Number of the Fiscal printer for this transaction

VarWChar

50

TransactionCustomerName

Stores the Customer Name for which the transaction has been made

VarWChar

255

HasCouponIssueItems

Value is true if the transacation has coupon included

Boolean

1

((0))

TrackingNumber

Stores the Shipping tracking number for the transaction

VarWChar

255

ShippingTypeKey

Refers to the shipping type.

VarWChar

50

((0))

LoyaltyPointsAllocationFailed

Value is true if the loyalty points are not allocated to the transaction

Boolean

1

((0))

HasCancelledSalesOrder

Value is true if the Sales order has been cancelled

Boolean

1

((0))

HasDiscountOverride

Value is true if the Discount has been overridden in this transaction

Boolean

1

((0))

TransactionCustomerEmail

Stores the Email id of the customer in the transaction

VarWChar

255

LoyaltyId

Stores the Loyalty Id of the customer in transaction

VarWChar

50

GenerateEInvoice

Not in Use

Boolean

1

((0))

EInvoiceGenerated

Value is True if the Electronic Invoice is generated (For Chile Localization)

Boolean

1

((0))

IsARBill

Value is True if DTE is Generated.

Boolean

1

((0))

ShowFolioNumber

Value is true if the pre-printed folio number is used - this field is used for Chile localization

Boolean

1

FiscalTransactionType

FiscalTransactionType

Integer

4

((0))

IsVoided

Value is true if the transaction is Voided

Boolean

1

((0))

POSDocumentNumberSeriesKey

Reference Key of POSDocumentNumberSeriesKey. See RtlPosDocumentNumberSeries

VarWChar

50

((0))

CurrencyKey

Reference key for the currency

VarWChar

50

ExchangeRate

Value is the Exchange Rate for the currency in the transaction

Numeric

9 (20,5)

((1))

PassIssued

Captures if a Digital pass has been issued for this transaction.

Boolean

1

((0))

SubsidiaryKey

Reference key of the Subsidiary. See also Subsidiary

VarWChar

50

((0))

SubTotalEC

Stores the Transaction Sub Total in Enterprise Currency

Numeric

9 (38,7)

([SubTotal]*[ExchangeRate])

PayableAmountEC

Stores the Enterprise Currency for the paybale amount for a Transaction

Numeric

9 (38,7)

([PayableAmount]*[ExchangeRate])

TotalTaxableAmountEC

Stores the Enterprise Currency for the Total taxable amount for the transaction

Numeric

9 (38,7)

([TotalTaxableAmount]*[ExchangeRate])

SurchargesTotalEC

Stores the Enterprise Currency for the Surcharges in Transaction

Numeric

9 (38,7)

([SurchargesTotal]*[ExchangeRate])

TaxEC

Stores the Enterprise Currency for the tax of Transaction

Numeric

9 (38,7)

([Tax]*[ExchangeRate])

TaxableDiscountAmountEC

Stores the Enterprise Currency for the taxable discount amount for the transaction

Numeric

9 (38,7)

([TaxableDiscountAmount]*[ExchangeRate])

DiscountAmountEC

Stores the Discount Amount in Enterprise Currency

Numeric

9 (38,7)

([DiscountAmount]*[ExchangeRate])

TotalEC

Stores the Enterprise Currency for the Total of Transaction

Numeric

9 (38,7)

([Total]*[ExchangeRate])

Comments

Stores comments.

VarWChar

4000

ApprovalStatus

Stores Approval status. Possible value: NotRequired = 0, Pending = 1, Approved = 2,Rejected = 3

Integer

4

ApprovalTime

Stores Approved/Rejected date and time.

DBTimeStamp

4

ApprovedBy

Reference of user who Approved/Rejected transaction. See also Security User

VarWChar

50

ApproverComment

Stores approver comments.

LongVarWChar

16

IsDeleted

Value is True if the record has been deleted from the system. Record is always Soft Deleted

Boolean

1

((0))

StartDate

Stores transaction start date and time.

DBTimeStamp

4

LineItemCount

Stores the number of line item in transaction.

Integer

4

((0))

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_TrxTransaction

IX_TrxTransaction_1

IX_TrxTransaction_2

PK_TrxTransaction

Database Object

Object Type

Description

Dep Level

BarCodeResolution

Stored Procedure

1

CreateTillCount

Stored Procedure

1

DailySaleSummary

User Defined Function

1

DeleteSuspendedTransactionDetails

Stored Procedure

1

EnableRollup

Stored Procedure

1

Forecast

Stored Procedure

1

GetDeliveryPackages

Stored Procedure

1

GetTransactionLinkDocument

Stored Procedure

1

Integration_ARPayment

Stored Procedure

1

Integration_DisplayNegativeInventory

Stored Procedure

1

Integration_funcTransaction

User Defined Function

1

Integration_TransactionPayment

Stored Procedure

1

Integration_TransactionSurcharge

Stored Procedure

1

Loy_GetTransactionHeader

Stored Procedure

1

Loyalty_ActiveBillValue

View

1

Loyalty_ActiveTransactionCount

View

1

Loyalty_GenderInfo

View

1

RPT_ABCAnalysis

Stored Procedure

1

Rpt_ActiveLoyalty

User Defined Function

1

Rpt_ItemWithoutSale

User Defined Function

1

rpt_LayAway

Stored Procedure

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

TrxConsolidateTransaction

Stored Procedure

1

TrxConsolidateTransactionForCreditCustomers

Stored Procedure

1

TrxGenerateLayawayInstallmentsForSaleLevel

Stored Procedure

Generates Layaway installments for the Layaway transaction

1

TrxHandleARPayments

Stored Procedure

Handles updates related to On Account payments

1

TrxInventoryUpdateBatchNumber

Stored Procedure

1

TrxInventoryUpdateCheckNegativeInventory

Stored Procedure

1

TrxInventoryUpdateLaybyCancellationItem

Stored Procedure

1

TrxInventoryUpdateLaybyItem

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

vw_TrxTransaction

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_SalesTransaction

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

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

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

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

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

[ActualDate] [datetime] NOT NULL,

[BusinessDate] [datetime] NOT NULL,

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

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

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

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

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

[IsTaxExempt] [bit] NOT NULL,

[HasSignature] [bit] NOT NULL,

[HasTaxCodeOverride] [bit] NOT NULL,

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

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

[DiscountType] [int] NOT NULL,

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

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

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

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

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

[AgeVerificationDate] [datetime] NULL,

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

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

[IsSuspended] [bit] NOT NULL,

[HasSurcharges] [bit] NOT NULL,

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

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

[HasManagerOverride] [bit] NOT NULL,

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

[HasLayaways] [bit] NOT NULL,

[HasLayawaysCancellations] [bit] NOT NULL,

[HasSales] [bit] NOT NULL,

[HasSaleExchanges] [bit] NOT NULL,

[HasDeliveries] [bit] NOT NULL,

[HasRefunds] [bit] NOT NULL,

[HasOrders] [bit] NOT NULL,

[HasFulFillments] [bit] NOT NULL,

[HasARPayments] [bit] NOT NULL,

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

[HasQuotations] [bit] NOT NULL,

[QuotationValidityDate] [datetime] NULL,

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

[HasGiftCertificates] [bit] NOT NULL,

[HasLostSaleItems] [bit] NOT NULL,

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

[SaleDiscountAfterTax] [bit] NOT NULL,

[IgnoreDiscountItemsForSaleDiscount] [bit] NOT NULL,

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

[TransactionCustomerName] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[HasCouponIssueItems] [bit] NOT NULL,

[TrackingNumber] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

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

[LoyaltyPointsAllocationFailed] [bit] NOT NULL,

[HasCancelledSalesOrder] [bit] NOT NULL,

[HasDiscountOverride] [bit] NOT NULL,

[TransactionCustomerEmail] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

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

[GenerateEInvoice] [bit] NULL,

[EInvoiceGenerated] [bit] NULL,

[IsARBill] [bit] NULL,

[ShowFolioNumber] [bit] NULL,

[FiscalTransactionType] [int] NOT NULL,

[IsVoided] [bit] NULL,

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

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

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

[PassIssued] [bit] NULL,

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

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

[PayableAmountEC] AS ([PayableAmount]*[ExchangeRate]),

[TotalTaxableAmountEC] AS ([TotalTaxableAmount]*[ExchangeRate]),

[SurchargesTotalEC] AS ([SurchargesTotal]*[ExchangeRate]),

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

[TaxableDiscountAmountEC] AS ([TaxableDiscountAmount]*[ExchangeRate]),

[DiscountAmountEC] AS ([DiscountAmount]*[ExchangeRate]),

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

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

[ApprovalStatus] [int] NULL,

[ApprovalTime] [datetime] NULL,

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

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

[IsDeleted] [bit] NULL,

[StartDate] [datetime] NULL,

[LineItemCount] [int] 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_TrxTransaction] PRIMARY KEY CLUSTERED

(

[TransactionKey] 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].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_HasQuotations] DEFAULT ((0)) FOR [HasQuotations]

ALTER TABLE [dbo].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_HasLostSaleItems] DEFAULT ((0)) FOR [HasLostSaleItems]

ALTER TABLE [dbo].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_TotalTaxableAmount] DEFAULT ((0)) FOR [TotalTaxableAmount]

ALTER TABLE [dbo].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_SaleDiscountAfterTax] DEFAULT ((0)) FOR [SaleDiscountAfterTax]

ALTER TABLE [dbo].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_IgnoreDiscountItemsForSaleDiscount] DEFAULT ((0)) FOR [IgnoreDiscountItemsForSaleDiscount]

ALTER TABLE [dbo].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_HasCouponIssueItems] DEFAULT ((0)) FOR [HasCouponIssueItems]

ALTER TABLE [dbo].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_ShippingTypeKey] DEFAULT ((0)) FOR [ShippingTypeKey]

ALTER TABLE [dbo].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_LoyaltyPointsAllocationFailed] DEFAULT ((0)) FOR [LoyaltyPointsAllocationFailed]

ALTER TABLE [dbo].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_HasOrderCanellations] DEFAULT ((0)) FOR [HasCancelledSalesOrder]

ALTER TABLE [dbo].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_HasDiscountOverride] DEFAULT ((0)) FOR [HasDiscountOverride]

ALTER TABLE [dbo].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_GenerateEInvoice] DEFAULT ((0)) FOR [GenerateEInvoice]

ALTER TABLE [dbo].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_EInvoiceGenerated] DEFAULT ((0)) FOR [EInvoiceGenerated]

ALTER TABLE [dbo].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_IsARBill] DEFAULT ((0)) FOR [IsARBill]

ALTER TABLE [dbo].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_FiscalTransactionType] DEFAULT ((0)) FOR [FiscalTransactionType]

ALTER TABLE [dbo].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_IsVoided] DEFAULT ((0)) FOR [IsVoided]

ALTER TABLE [dbo].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_POSDocumentNumberSeriesKey] DEFAULT ((0)) FOR [POSDocumentNumberSeriesKey]

ALTER TABLE [dbo].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_ExchangeRate] DEFAULT ((1)) FOR [ExchangeRate]

ALTER TABLE [dbo].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_PassIssued] DEFAULT ((0)) FOR [PassIssued]

ALTER TABLE [dbo].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_SubsidiaryKey] DEFAULT ((0)) FOR [SubsidiaryKey]

ALTER TABLE [dbo].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]

ALTER TABLE [dbo].[TrxTransaction] ADD CONSTRAINT [DF_TrxTransaction_LineItemCount] DEFAULT ((0)) FOR [LineItemCount]