iVend Database Database : PmtLayawayPlan Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

1

Data Space Used

8.00 KB

Index Space Used

8.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

LayawayPlanKey

System generated Primary key of the table.

VarWChar

50

Id

Refers to the layaway plan's Id

VarWChar

20

Description

Refers to the layaway plan's description.

VarWChar

100

IsActive

Flag to check whether the plan is active or not.

Boolean

1

InstallmentCount

Default number of installments in which the amount is to be returned.

Integer

4

MinInstallmentCount

Minimum number of installments in which the amount is to be returned.

Integer

4

MaxInstallmentCount

Maximum number of installments in which the amount is to be returned.

Integer

4

DurationType

Refers to the duration type

Valid values are:

Weekly = 0

Monthly = 1

Quarterly = 2

Halfyearly = 3

Yearly = 4

Duration = 5

Integer

4

InstallmentDuration

If DurationType has been specified as Duration, then the field stores installment duration time in days.

Integer

4

FirstInstallmentDue

Days in which the first installment is due.

Integer

4

TolerenceDays

For future use

Integer

4

InstallmentTaxMethod

For future use

Integer

4

InventoryAllocationMethod

Speicifies the method as per which the inventory is allocated.

Valid values are:

Sale = 0

Delivery = 1

Integer

4

DepositType

Specifies whether whether the initial deposit is in amount or percentage.

Valid values are:

Amount = 0

Percentage = 1

Integer

4

Deposit

Refers to the deposit value.

Numeric

9 (20,5)

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

MinimumDeliveryPercentage

Stores the value as minimum percentage of amount that is required for the delivery of product.

Numeric

9 (20,5)

((0))

SubsidiaryKey

Reference key of the Subsidiary. See also Subsidiary

VarWChar

50

Index

Description

Primary

Unique

PK_PmtLayawayPlan

Database Object

Object Type

Description

Dep Level

GetMobileReplicationData

Stored Procedure

1

TrxGenerateLayawayInstallments

Stored Procedure

Generates Layaway installments for the Layaway transaction

1

TrxGenerateLayawayInstallmentsForSaleLevel

Stored Procedure

Generates Layaway installments for the Layaway transaction

1

TrxGetLaybyInstallmentPlan

Stored Procedure

Computes the Layaway details like Duration, Starting Date etc for the layaway depending on the Layaway Plan

1

TrxInventoryUpdateLaybyItem

Stored Procedure

2

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[PmtLayawayPlan](

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

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

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

[IsActive] [bit] NOT NULL,

[InstallmentCount] [int] NOT NULL,

[MinInstallmentCount] [int] NOT NULL,

[MaxInstallmentCount] [int] NOT NULL,

[DurationType] [int] NOT NULL,

[InstallmentDuration] [int] NOT NULL,

[FirstInstallmentDue] [int] NOT NULL,

[TolerenceDays] [int] NOT NULL,

[InstallmentTaxMethod] [int] NOT NULL,

[InventoryAllocationMethod] [int] NOT NULL,

[DepositType] [int] NULL,

[Deposit] [numeric](20, 5) 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,

[MinimumDeliveryPercentage] [numeric](20, 5) NOT NULL,

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

CONSTRAINT [PK_PmtLayawayPlan] PRIMARY KEY CLUSTERED

(

[LayawayPlanKey] 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].[PmtLayawayPlan] ADD CONSTRAINT [DF_PmtLayawayPlan_MinimumDeliveryPercentage] DEFAULT ((0)) FOR [MinimumDeliveryPercentage]