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

PurchaseOrderDetailKey

Primary Key

VarWChar

50

PurchaseOrderKey

Reference Key of Purchase Order. See also PurchaseOrder

VarWChar

50

LineNumber

Detail line number

Integer

4

WarehouseKey

Reference Key of Warehouse for which purchase order will be made. See also Warehouse

VarWChar

50

ProductKey

Reference Key of Product. See also Product

VarWChar

50

Description

Product Description

VarWChar

100

TaxKey

Reference Key of tax code which is applied on the line. See also TaxCode

VarWChar

50

TaxRate

Tax rate applied of selected Tax Code

Numeric

9 (20,5)

PriceOverriden

For future use

Boolean

1

TaxOverridden

For future use

Boolean

1

Price

Purchase price of the line item

Numeric

9 (20,5)

Quantity

Quantity of product ordered

Numeric

9 (20,4)

QuantityReceived

Quantity which has already been received against the line item

Numeric

9 (20,4)

QuantityOnHold

For future use

Numeric

9 (20,4)

SubTotal

Line item Sub Total

Numeric

9 (20,5)

TotalTaxableAmount

Total amount on which tax is computed for the line

Numeric

9 (20,5)

Tax

Tax amount

Numeric

9 (20,5)

DiscountType

Type of Discount appllied on detail level Discount type applicable.

Valid values are:

None = 0

Amount = 1

Percent = 2

Integer

4

DiscountAmount

Discount amont

Numeric

9 (20,5)

DiscountPercentage

Discount percentage

Numeric

9 (20,5)

Total

Net total of detail item

Numeric

9 (20,5)

Status

Line item Staus.

Valid values are:

Open = 0

Closed = 1

Integer

4

IsDeleted

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

Boolean

1

ItemsPerUnit

Stores the per unit price of the product

Numeric

9 (20,5)

((1))

UOMKey

Refers to the UOM key. See InvUOM

VarWChar

50

UOMQuantity

Refers to the UOM Qunatity of the product

Numeric

9 (20,5)

UOMQuantityReceived

Refers to the UOM Quantity Received for the product

Numeric

9 (20,4)

ReasonCodeKey

Reference Key for the Reason Code

VarWChar

50

((0))

UniqueLineNumber

Hold GUID for Line

VarWChar

50

IsTaxOnly

Value is True if the added item is Tax Free

Boolean

1

((0))

Comments

Stores comments.

VarWChar

4000

Index

Description

Primary

Unique

PK_PurPurchaseOrderDetail

Database Object

Object Type

Description

Dep Level

GoodsReceiptPOReport

Stored Procedure

1

Integration_GoodsReceipt

Stored Procedure

1

Integration_PurchaseOrder

Stored Procedure

1

PurchaseOrderReport

Stored Procedure

1

vwAnalytics_OpenPO_Snapshot

View

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[PurPurchaseOrderDetail](

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

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

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

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

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

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

[PriceOverriden] [bit] NOT NULL,

[TaxOverridden] [bit] NOT NULL,

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

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

[QuantityReceived] [decimal](20, 4) NOT NULL,

[QuantityOnHold] [decimal](20, 4) NOT NULL,

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

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

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

[DiscountType] [int] NOT NULL,

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

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

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

[Status] [int] NOT NULL,

[IsDeleted] [bit] NOT NULL,

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

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

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

[UOMQuantityReceived] [decimal](20, 4) NULL,

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

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

[IsTaxOnly] [bit] NULL,

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

CONSTRAINT [PK_PurPurchaseOrderDetail] PRIMARY KEY CLUSTERED

(

[PurchaseOrderDetailKey] 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].[PurPurchaseOrderDetail] ADD CONSTRAINT [DF_PurPurchaseOrderDetail_ItemsPerUnit] DEFAULT ((1)) FOR [ItemsPerUnit]

ALTER TABLE [dbo].[PurPurchaseOrderDetail] ADD CONSTRAINT [DF_PurPurchaseOrderDetail_ReasonCodeKey] DEFAULT ((0)) FOR [ReasonCodeKey]

ALTER TABLE [dbo].[PurPurchaseOrderDetail] ADD CONSTRAINT [DF_PurPurchaseOrderDetail_IsTaxOnly] DEFAULT ((0)) FOR [IsTaxOnly]