iVend Database Database : TrxTransactionDynamicAssemblyItem Table

Creation Date

6/20/2017 11:04 AM

File Group

PRIMARY

Text File Group

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

TransactionDynamicAssemblyItemKey

Primary key for the table

VarWChar

50

TransactionKey

Stores the TransactionKey of the transaction in which this assembly item is sold.

VarWChar

50

SourceType

Captures the package detail source type. Valid values are :

Sale = 0,

Refund = 1,

Exchange = 2,

DeliveryAgainstSpecialOrder = 3,

DeliveryAgainstSale = 4,

DeliveryAgainstLayaway = 5

Integer

4

SourceKey

Captures the transaction item detail key

VarWChar

50

ParentProductKey

Stores the Product Key of the Parent Assembly Item which is sold on POS.

VarWChar

50

ProductKey

Stores the Product Key of the Dynamic Constituent Item.

VarWChar

50

Quantity

Keeps the quantity of the Assembly Constituent

Numeric

9 (20,5)

ProductDetailKey

Stores the Serial/Batch key of the item in case the consituent item is serial or batch tracked.

VarWChar

50

Index

Description

Primary

Unique

IX_TrxTransactionDynamicAssemblyItem

IX_TrxTransactionDynamicAssemblyItem_1

PK__TrxTrans__D26510921A15AEEC

Database Object

Object Type

Description

Dep Level

TrxCompleteTransactionUpdates

Stored Procedure

2

TrxInventoryUpdateSaleDelivery

Stored Procedure

Handles updates related to delivery of a Sale item

1

TrxInventoryUpdateSaleItem

Stored Procedure

Handles updates related to sale item

1

TrxInventoryUpdatesSaleRefund

Stored Procedure

Handles updates related to On Account payments

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[TrxTransactionDynamicAssemblyItem](

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

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

[SourceType] [int] NOT NULL,

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

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

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

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

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

CONSTRAINT [PK__TrxTrans__D26510921A15AEEC] PRIMARY KEY CLUSTERED

(

[TransactionDynamicAssemblyItemKey] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]