Tables [dbo].[APHVouchers]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:56:35 AM Thursday, March 21, 2019
Last Modified1:12:46 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_APHVouchers: HVoucherIDHVoucherIDint4
False
HVoucherNumbervarchar(32)32
True
Typechar(4)4
True
Foreign Keys FK_APHVouchers_VendorID_APVendors: [dbo].[APVendors].VendorIDVendorIDint4
True
VendorNamevarchar(50)50
True
Foreign Keys FK_APHVouchers_HApplyToID_APHVouchers: [dbo].[APHVouchers].HApplyToIDHApplyToIDint4
True
HApplyToVoucherNumbervarchar(32)32
True
InvoiceNumbervarchar(32)32
True
Datedatetime8
True
DatePeriodint4
True
Periodint4
True
Descriptionvarchar(255)255
True
PONumbervarchar(32)32
True
Foreign Keys FK_APHVouchers_TermID_ShTerms: [dbo].[ShTerms].TermIDTermIDint4
True
Termvarchar(15)15
True
TermDiscountRatefloat8
True
TermDiscountDatedatetime8
True
TermDiscountmoney8
True
DueDatedatetime8
True
Foreign Keys FK_APHVouchers_PurchaserID_APPurchasers: [dbo].[APPurchasers].PurchaserIDPurchaserIDint4
True
Purchaservarchar(50)50
True
Remarksvarchar(1024)1024
True
Foreign Keys FK_APHVouchers_JobID_APJobs: [dbo].[APJobs].JobIDJobIDint4
True
JobNumbervarchar(15)15
True
Totalmoney8
True
AdjTotalmoney8
True
Duemoney8
True
Checksmoney8
True
Modulechar(4)4
True
Sourcevarchar(15)15
True
Referencevarchar(15)15
True
TransactionTypeIDint4
True
TransactionTypevarchar(64)64
True
Foreign Keys FK_APHVouchers_HVoidID_APHVouchers: [dbo].[APHVouchers].HVoidIDHVoidIDint4
True
HVoidVoucherNumbervarchar(15)15
True
Foreign Keys FK_APHVouchers_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
True
BranchNamevarchar(50)50
True
Foreign Keys FK_APHVouchers_APBranchID_GLBranches: [dbo].[GLBranches].APBranchIDAPBranchIDint4
True
APBranchNamevarchar(50)50
True
Foreign Keys FK_APHVouchers_OnHoldCodeID_ShOnHoldCodes: [dbo].[ShOnHoldCodes].OnHoldCodeIDOnHoldCodeIDint4
True
OnHoldCodevarchar(50)50
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_APHVouchers: HVoucherIDPK_APHVouchersHVoucherID
True
80
NameColumns
FK_APHVouchers_APBranchID_GLBranchesAPBranchID->[dbo].[GLBranches].[BranchID]
FK_APHVouchers_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_APHVouchers_HApplyToID_APHVouchersHApplyToID->[dbo].[APHVouchers].[HVoucherID]
FK_APHVouchers_HVoidID_APHVouchersHVoidID->[dbo].[APHVouchers].[HVoucherID]
FK_APHVouchers_JobID_APJobsJobID->[dbo].[APJobs].[JobID]
FK_APHVouchers_OnHoldCodeID_ShOnHoldCodesOnHoldCodeID->[dbo].[ShOnHoldCodes].[OnHoldCodeID]
FK_APHVouchers_PurchaserID_APPurchasersPurchaserID->[dbo].[APPurchasers].[PurchaserID]
FK_APHVouchers_TermID_ShTermsTermID->[dbo].[ShTerms].[TermID]
FK_APHVouchers_VendorID_APVendorsVendorID->[dbo].[APVendors].[VendorID]
CREATE TABLE [dbo].[APHVouchers]
(
[HVoucherID] [int] NOT NULL,
[HVoucherNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Type] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VendorID] [int] NULL,
[VendorName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HApplyToID] [int] NULL,
[HApplyToVoucherNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InvoiceNumber] [varchar] (32) 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,
[PONumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TermID] [int] NULL,
[Term] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TermDiscountRate] [float] NULL,
[TermDiscountDate] [datetime] NULL,
[TermDiscount] [money] NULL,
[DueDate] [datetime] NULL,
[PurchaserID] [int] NULL,
[Purchaser] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[JobID] [int] NULL,
[JobNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Total] [money] NULL,
[AdjTotal] [money] NULL,
[Due] [money] NULL,
[Checks] [money] NULL,
[Module] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Source] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Reference] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TransactionTypeID] [int] NULL,
[TransactionType] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HVoidID] [int] NULL,
[HVoidVoucherNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BranchID] [int] NULL,
[BranchName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[APBranchID] [int] NULL,
[APBranchName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OnHoldCodeID] [int] NULL,
[OnHoldCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[APHVouchers] ADD CONSTRAINT [PK_APHVouchers] PRIMARY KEY CLUSTERED  ([HVoucherID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[APHVouchers] ADD CONSTRAINT [FK_APHVouchers_APBranchID_GLBranches] FOREIGN KEY ([APBranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[APHVouchers] ADD CONSTRAINT [FK_APHVouchers_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[APHVouchers] ADD CONSTRAINT [FK_APHVouchers_HApplyToID_APHVouchers] FOREIGN KEY ([HApplyToID]) REFERENCES [dbo].[APHVouchers] ([HVoucherID])
GO
ALTER TABLE [dbo].[APHVouchers] ADD CONSTRAINT [FK_APHVouchers_HVoidID_APHVouchers] FOREIGN KEY ([HVoidID]) REFERENCES [dbo].[APHVouchers] ([HVoucherID])
GO
ALTER TABLE [dbo].[APHVouchers] ADD CONSTRAINT [FK_APHVouchers_JobID_APJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[APJobs] ([JobID])
GO
ALTER TABLE [dbo].[APHVouchers] ADD CONSTRAINT [FK_APHVouchers_OnHoldCodeID_ShOnHoldCodes] FOREIGN KEY ([OnHoldCodeID]) REFERENCES [dbo].[ShOnHoldCodes] ([OnHoldCodeID])
GO
ALTER TABLE [dbo].[APHVouchers] ADD CONSTRAINT [FK_APHVouchers_PurchaserID_APPurchasers] FOREIGN KEY ([PurchaserID]) REFERENCES [dbo].[APPurchasers] ([PurchaserID])
GO
ALTER TABLE [dbo].[APHVouchers] ADD CONSTRAINT [FK_APHVouchers_TermID_ShTerms] FOREIGN KEY ([TermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO
ALTER TABLE [dbo].[APHVouchers] ADD CONSTRAINT [FK_APHVouchers_VendorID_APVendors] FOREIGN KEY ([VendorID]) REFERENCES [dbo].[APVendors] ([VendorID])
GO