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

ARPaymentKey

System - generated Primary Key

VarWChar

50

TransactionKey

Reference Key of Transaction

VarWChar

50

CustomerKey

Reference key of customer. Also see Customer

VarWChar

50

Amount

Refers to the amount being settled

Numeric

9 (20,5)

CommentKey

Reference key of Comment. Also see Comment

VarWChar

50

PaymentType

Type of tender type in which AR payment accepted

Integer

4

DetailKey

Reference key of AR Payment. See also AR Payment.

VarWChar

50

Comments

VarWChar

4000

Index

Description

Primary

Unique

PK_ConTrxARPayment

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[ConTrxARPayment](

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

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

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

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

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

[PaymentType] [int] NOT NULL,

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

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

CONSTRAINT [PK_ConTrxARPayment] PRIMARY KEY CLUSTERED

(

[ARPaymentKey] ASC

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

) ON [PRIMARY]