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

PurchaseOrderKey

Primary Key

VarWChar

50

AccountingId

Maps with the Unique Id of the ERP system

VarWChar

50

SiteId

Site Id of the store where the record was created

Integer

4

TaxCodeKey

Reference Key of Tax Code, which is applied on Purchase Order. See also TaxCode

VarWChar

50

VendorKey

Reference Key of Vendor for whom Purchase order will be made. See also Vendor

VarWChar

50

VendorName

Name of vendor

VarWChar

100

DeliveryDate

Date of delivery of Purchase Order

DBTimeStamp

4

DiscountType

Discount type applicable.

Valid values are:

None = 0

Amount = 1

Percent = 2

Integer

4

DiscountAmount

Discount Amount

Numeric

9 (20,5)

DiscountPercentage

Discount Percentage

Numeric

9 (20,5)

SubTotal

Sub Total

Numeric

9 (20,5)

TotalTaxableAmount

Amount on which Tax is calculated

Numeric

9 (20,5)

Tax

Tax Amount

Numeric

9 (20,5)

SurchargesTotal

Total surcharges applied on purchase order

Numeric

9 (20,5)

Total

Net Total of purchase order

Numeric

9 (20,5)

PurchaseOrderId

Reference Id of purchase order

VarWChar

20

Status

Staus of Purchase Order.

Valid values are:

Open = 0

Closed = 1

Integer

4

CreatedBy

Reference of user who has created this record. See also Security User

VarWChar

50

Created

Date of creation of this record

DBTimeStamp

4

ModifiedBy

Reference of user who has modified this record. See also Security User

VarWChar

50

Modified

Date of last modification of this record

DBTimeStamp

4

IsDeleted

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

Boolean

1

CommentKey

Reference Key of Comment for Purchase order. See also Comment

VarWChar

50

ReferenceNumber

Reference number of the Purchase Order

VarWChar

100

IsAuthorized

Check whether this purchase order requires authorization

Boolean

1

BusinessDate

Date of Business

DBTimeStamp

4

ReasonCodeKey

Reference Key for the Reason Code

VarWChar

50

StoreCurrencyKey

Value is the Currency Key for the Store

VarWChar

50

StoreCurrencyExchangeRate

Value is the Exchange Rate for the defined currency at Store

Numeric

9 (20,5)

DocumentCurrencyKey

Reference Key of Currency. See also PmtCurrency.

VarWChar

50

((0))

LocalCurrencyKey

Reference Key of Currency. See also PmtCurrency.

VarWChar

50

((0))

ExchangeRate

Value is the Exchange Rate used for the purchase Order.

Numeric

9 (20,5)

((0))

RowRevision

Rowversion is used as a mechanism for version-stamping table rows.

Binary

8

Comments

Stores comments.

VarWChar

4000

Id

VarWChar

20

Description

VarWChar

100

Index

Description

Primary

Unique

PK_PurPurchaseOrder

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

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

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

[SiteId] [int] NOT NULL,

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

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

[VendorName] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[DeliveryDate] [datetime] NOT NULL,

[DiscountType] [int] NOT NULL,

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

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

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

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

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

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

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

[PurchaseOrderId] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Status] [int] NOT NULL,

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

[Created] [datetime] NOT NULL,

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

[Modified] [datetime] NOT NULL,

[IsDeleted] [bit] NOT NULL,

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

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

[IsAuthorized] [bit] NULL,

[BusinessDate] [datetime] NULL,

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

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

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

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

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

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

[RowRevision] [timestamp] NOT NULL,

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

[Id] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

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

CONSTRAINT [PK_PurPurchaseOrder] PRIMARY KEY CLUSTERED

(

[PurchaseOrderKey] 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].[PurPurchaseOrder] ADD CONSTRAINT [DF_PurPurchaseOrder_DocumentCurrencyKey] DEFAULT ((0)) FOR [DocumentCurrencyKey]

ALTER TABLE [dbo].[PurPurchaseOrder] ADD CONSTRAINT [DF_PurPurchaseOrder_LocalCurrencyKey] DEFAULT ((0)) FOR [LocalCurrencyKey]

ALTER TABLE [dbo].[PurPurchaseOrder] ADD CONSTRAINT [DF_PurPurchaseOrder_ExchangeRate] DEFAULT ((0)) FOR [ExchangeRate]