iVend Database Database : ArrAccountsReceivable Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

205

Data Space Used

56.00 KB

Index Space Used

48.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

AccountsReceivableKey

System generated Primary key of the table.

VarWChar

50

CustomerKey

Refers to the customer.See also Customer

VarWChar

50

Balance

Refers to the balance remaining.

Numeric

9 (20,5)

CreditLimit

Refers to the credit limit of the customer.

Numeric

9 (20,5)

CreditWarningLevel

Amount at which the system would prompt a warning.

Numeric

9 (20,5)

BankCountry

Refers to the country in which the bank is located.

VarWChar

50

Bank

Refers to the bank.

VarWChar

50

BankAccount

Refers to the bank account.

VarWChar

50

BankBranch

Refers to the branch of the bank.

VarWChar

50

AgingAmount1

For future use

Numeric

9 (20,5)

AgingAmount2

For future use

Numeric

9 (20,5)

AgingAmount3

For future use

Numeric

9 (20,5)

AgingAmount4

For future use

Numeric

9 (20,5)

LastPaymentAmount

Refers to the last amount that was paid.

Numeric

9 (20,5)

LastPaymentDate

Refers to the date of the last payment made.

DBTimeStamp

4

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

IsDeleted

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

Boolean

1

OrderBalance

Value is the Sales Transaction Balance

Numeric

9 (20,5)

((0))

LayawayBalance

Value is the Layaway Transaction Balance

Numeric

9 (20,5)

SubsidiaryKey

Reference key of the Subsidiary. See also Subsidiary

VarWChar

50

SalesTaxCodeKey

Refers to the sales tax code key. See also Tax

VarWChar

50

PriceListKey

Refers to the pricelist applicable to the Customer, for particular Subsidiary.See also Price List

VarWChar

50

IsTaxExempt

Flag to check whether the customer is tax exempted or not for the Subsidiary Customer

Boolean

1

TaxNumber

Customer tax number or Federal tax id

VarWChar

40

ElectronicId

Customer Electronic Id

VarWChar

80

PaymentTypeKey

Refers to the preferred Payment Type for the Subsidiary Customer. See also Payment Type

VarWChar

50

((0))

IsActive

Value is True if the Customer is active for the Subsidiary Customer

Boolean

1

((1))

OnHold

Value is True if the Customer is on hold or not for the Subsidiary Customer

Boolean

1

((0))

IsTaxFree

Value is True if the Customer is TaxFree for the Subsidiary Customer

Boolean

1

((0))

Index

Description

Primary

Unique

IX_ArrAccountsReceivable

PK_ArrAccountsReceivable

Database Object

Object Type

Description

Dep Level

BarCodeResolution

Stored Procedure

1

RepUpdateCustomerBalance

Stored Procedure

Updates the customer balances in iVend Unplugged

1

Trg_ReplicationTransactionMobile

Trigger

1

TrxCompleteTransactionUpdates

Stored Procedure

2

TrxUpdateCustomerBalance

Stored Procedure

1

uspGetItemPrice

Stored Procedure

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[ArrAccountsReceivable](

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

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

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

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

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

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

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

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

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

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

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

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

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

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

[LastPaymentDate] [datetime] NULL,

[Created] [datetime] NOT NULL,

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

[Modified] [datetime] NOT NULL,

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

[IsDeleted] [bit] NOT NULL,

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

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

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

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

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

[IsTaxExempt] [bit] NULL,

[TaxNumber] [nvarchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ElectronicId] [nvarchar](80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

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

[IsActive] [bit] NOT NULL,

[OnHold] [bit] NOT NULL,

[IsTaxFree] [bit] NOT NULL,

CONSTRAINT [PK_ArrAccountsReceivable] PRIMARY KEY CLUSTERED

(

[AccountsReceivableKey] 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].[ArrAccountsReceivable] ADD CONSTRAINT [DF_ArrAccountsReceivable_OrderBalance] DEFAULT ((0)) FOR [OrderBalance]

ALTER TABLE [dbo].[ArrAccountsReceivable] ADD CONSTRAINT [DF__ArrAccoun__Payme__7933DE0E] DEFAULT ((0)) FOR [PaymentTypeKey]

ALTER TABLE [dbo].[ArrAccountsReceivable] ADD CONSTRAINT [DF__ArrAccoun__IsAct__025333F4] DEFAULT ((1)) FOR [IsActive]

ALTER TABLE [dbo].[ArrAccountsReceivable] ADD CONSTRAINT [DF__ArrAccoun__OnHol__0347582D] DEFAULT ((0)) FOR [OnHold]

ALTER TABLE [dbo].[ArrAccountsReceivable] ADD CONSTRAINT [DF_ArrAccountsReceivable_IsTaxFree] DEFAULT ((0)) FOR [IsTaxFree]