Tables [dbo].[ARHReceipts]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:56:46 AM Thursday, March 21, 2019
Last Modified1:10:12 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_ARHReceipts: HReceiptIDHReceiptIDint4
False
HReceiptNumbervarchar(255)255
True
Typechar(2)2
True
SubTypechar(4)4
True
Foreign Keys FK_ARHReceipts_CustomerID_ARCustomers: [dbo].[ARCustomers].CustomerIDCustomerIDint4
True
CustomerNamevarchar(255)255
True
Datedatetime8
True
DatePeriodint4
True
Periodint4
True
Descriptionvarchar(255)255
True
Methodchar(4)4
True
CheckNumbervarchar(30)30
True
CheckDatedatetime8
True
CardNumbervarchar(255)255
True
CardExpDatedatetime8
True
EFTReferencevarchar(255)255
True
Amountmoney8
True
Unappliedmoney8
True
OpenAmountmoney8
True
Feemoney8
True
Foreign Keys FK_ARHReceipts_HAppliedID_ARHReceipts: [dbo].[ARHReceipts].HAppliedIDHAppliedIDint4
True
HAppliedReceiptNumbervarchar(255)255
True
Modulechar(4)4
True
Sourcevarchar(255)255
True
Referencevarchar(255)255
True
Foreign Keys FK_ARHReceipts_HVoidID_ARHReceipts: [dbo].[ARHReceipts].HVoidIDHVoidIDint4
True
HVoidReceiptNumbervarchar(255)255
True
TransactionTypeIDint4
True
TransactionTypevarchar(64)64
True
ChargeAccountInfovarchar(64)64
True
Foreign Keys FK_ARHReceipts_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
True
BranchNamevarchar(50)50
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_ARHReceipts: HReceiptIDPK_ARHReceiptsHReceiptID
True
80
NameColumns
FK_ARHReceipts_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_ARHReceipts_CustomerID_ARCustomersCustomerID->[dbo].[ARCustomers].[CustomerID]
FK_ARHReceipts_HAppliedID_ARHReceiptsHAppliedID->[dbo].[ARHReceipts].[HReceiptID]
FK_ARHReceipts_HVoidID_ARHReceiptsHVoidID->[dbo].[ARHReceipts].[HReceiptID]
CREATE TABLE [dbo].[ARHReceipts]
(
[HReceiptID] [int] NOT NULL,
[HReceiptNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Type] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SubType] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerID] [int] NULL,
[CustomerName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Date] [datetime] NULL,
[DatePeriod] [int] NULL,
[Period] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Method] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CheckNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CheckDate] [datetime] NULL,
[CardNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CardExpDate] [datetime] NULL,
[EFTReference] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Amount] [money] NULL,
[Unapplied] [money] NULL,
[OpenAmount] [money] NULL,
[Fee] [money] NULL,
[HAppliedID] [int] NULL,
[HAppliedReceiptNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Module] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Source] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Reference] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HVoidID] [int] NULL,
[HVoidReceiptNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TransactionTypeID] [int] NULL,
[TransactionType] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ChargeAccountInfo] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BranchID] [int] NULL,
[BranchName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARHReceipts] ADD CONSTRAINT [PK_ARHReceipts] PRIMARY KEY CLUSTERED  ([HReceiptID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARHReceipts] ADD CONSTRAINT [FK_ARHReceipts_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ARHReceipts] ADD CONSTRAINT [FK_ARHReceipts_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[ARHReceipts] ADD CONSTRAINT [FK_ARHReceipts_HAppliedID_ARHReceipts] FOREIGN KEY ([HAppliedID]) REFERENCES [dbo].[ARHReceipts] ([HReceiptID])
GO
ALTER TABLE [dbo].[ARHReceipts] ADD CONSTRAINT [FK_ARHReceipts_HVoidID_ARHReceipts] FOREIGN KEY ([HVoidID]) REFERENCES [dbo].[ARHReceipts] ([HReceiptID])
GO