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

50

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.

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)

SystemDiscount

System-calculated discount. (the discount applied on PriceLists/Promotion)

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

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

Comments

VarWChar

4000

Index

Description

Primary

Unique

PK_ConTrxTransaction

Database Object

Object Type

Description

Dep Level

Integration_Consolidated_Transaction

Stored Procedure

1

Integration_Consolidated_TransactionPayment

Stored Procedure

1

Integration_Consolidated_TransactionSurcharge

Stored Procedure

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[ConTrxTransaction](

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

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

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

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

[ActualDate] [datetime] NULL,

[BusinessDate] [datetime] NULL,

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

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

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

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

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

[IsTaxExempt] [bit] NULL,

[HasSignature] [bit] NULL,

[HasTaxCodeOverride] [bit] NULL,

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

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

[DiscountType] [int] NULL,

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

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

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

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

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

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

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

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

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

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

[AgeVerificationDate] [datetime] NULL,

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

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

[IsSuspended] [bit] NULL,

[HasSurcharges] [bit] NULL,

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

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

[HasManagerOverride] [bit] NULL,

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

[HasLayaways] [bit] NULL,

[HasLayawaysCancellations] [bit] NULL,

[HasSales] [bit] NULL,

[HasSaleExchanges] [bit] NULL,

[HasDeliveries] [bit] NULL,

[HasRefunds] [bit] NULL,

[HasOrders] [bit] NULL,

[HasFulFillments] [bit] NULL,

[HasARPayments] [bit] NULL,

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

[Created] [datetime] NULL,

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

[Modified] [datetime] NULL,

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

[HasQuotations] [bit] NULL,

[QuotationValidityDate] [datetime] NULL,

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

[HasGiftCertificates] [bit] NULL,

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

CONSTRAINT [PK_ConTrxTransaction] 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]