Tables [dbo].[APVouchers]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:55:49 AM Thursday, March 21, 2019
Last Modified1:13:39 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_APVouchers: VoucherIDVoucherIDint4
False
VoucherNumbervarchar(15)15
False
Typechar(4)4
False
Foreign Keys FK_APVouchers_VendorID_APVendors: [dbo].[APVendors].VendorIDVendorIDint4
False
Foreign Keys FK_APVouchers_ApplyToID_APVouchers: [dbo].[APVouchers].ApplyToIDApplyToIDint4
True
InvoiceNumbervarchar(32)32
False
Datedatetime8
False
DatePeriodint4
False
Periodint4
False
Descriptionvarchar(255)255
False
PONumbervarchar(32)32
False
Foreign Keys FK_APVouchers_TermID_ShTerms: [dbo].[ShTerms].TermIDTermIDint4
True
TermDiscountRatefloat8
False
TermDiscountDatedatetime8
True
TermDiscountmoney8
False
((0))
DueDatedatetime8
False
Foreign Keys FK_APVouchers_PurchaserID_APPurchasers: [dbo].[APPurchasers].PurchaserIDPurchaserIDint4
True
Remarksvarchar(1024)1024
False
Foreign Keys FK_APVouchers_GLID_GLAccounts1: [dbo].[GLAccounts1].GLIDGLIDint4
False
Foreign Keys FK_APVouchers_JobID_APJobs: [dbo].[APJobs].JobIDJobIDint4
True
Totalmoney8
False
((0))
AdjTotalmoney8
False
((0))
Duemoney8
False
((0))
Checksmoney8
False
((0))
Modulechar(4)4
False
Sourcevarchar(15)15
False
Referencevarchar(15)15
False
TransactionTypeIDint4
False
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
Foreign Keys FK_APVouchers_VoidID_APVouchers: [dbo].[APVouchers].VoidIDVoidIDint4
True
Foreign Keys FK_APVouchers_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
True
Foreign Keys FK_APVouchers_APBranchID_GLBranches: [dbo].[GLBranches].APBranchIDAPBranchIDint4
False
Foreign Keys FK_APVouchers_OnHoldCodeID_SHOnHoldCodes: [dbo].[ShOnHoldCodes].OnHoldCodeIDOnHoldCodeIDint4
True
Foreign Keys FK_APVouchers_NoteID_APVoucherNotes: [dbo].[APVoucherNotes].NoteIDNoteIDint4
True
NoteFlagint4
False
((0))
Foreign Keys FK_APVouchers_ReceivablePayableID_ARAPReceivablePayables: [dbo].[ARAPReceivablePayables].ReceivablePayableIDReceivablePayableIDint4
True
NoteCountint4
False
((0))
Batchvarchar(64)64
False
('')
Subtypevarchar(4)4
False
('')
Foreign Keys FK_APVouchers_TaxCodeID_ShTaxCodes: [dbo].[ShTaxCodes].TaxCodeIDTaxCodeIDint4
True
Foreign Keys FK_APVouchers_TaxExemptCodeID_ShTaxExemptCodes: [dbo].[SHTaxExemptCodes].TaxExemptCodeIDTaxExemptCodeIDint4
True
Taxmoney8
False
((0))
Taxablebit1
False
((0))
CoverageFromDatedatetime8
True
CoverageToDatedatetime8
True
Foreign Keys FK_APVouchers_TaxUtilityConsumptionTypeID_ShTaxConsumptionTypes: [dbo].[ShTaxConsumptionTypes].TaxUtilityConsumptionTypeIDTaxUtilityConsumptionTypeIDint4
True
DBFileHeaderIDint4
False
((1))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_APVouchers: VoucherIDPK_APVouchersVoucherID
True
80
NameColumns
FK_APVouchers_APBranchID_GLBranchesAPBranchID->[dbo].[GLBranches].[BranchID]
FK_APVouchers_ApplyToID_APVouchersApplyToID->[dbo].[APVouchers].[VoucherID]
FK_APVouchers_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_APVouchers_GLID_GLAccounts1GLID->[dbo].[GLAccounts1].[AccountID]
FK_APVouchers_JobID_APJobsJobID->[dbo].[APJobs].[JobID]
FK_APVouchers_NoteID_APVoucherNotesNoteID->[dbo].[APVoucherNotes].[NoteID]
FK_APVouchers_OnHoldCodeID_SHOnHoldCodesOnHoldCodeID->[dbo].[ShOnHoldCodes].[OnHoldCodeID]
FK_APVouchers_PurchaserID_APPurchasersPurchaserID->[dbo].[APPurchasers].[PurchaserID]
FK_APVouchers_ReceivablePayableID_ARAPReceivablePayablesReceivablePayableID->[dbo].[ARAPReceivablePayables].[ReceivablePayableID]
FK_APVouchers_TaxCodeID_ShTaxCodesTaxCodeID->[dbo].[ShTaxCodes].[TaxCodeID]
FK_APVouchers_TaxExemptCodeID_ShTaxExemptCodesTaxExemptCodeID->[dbo].[SHTaxExemptCodes].[TaxExemptCodeID]
FK_APVouchers_TaxUtilityConsumptionTypeID_ShTaxConsumptionTypesTaxUtilityConsumptionTypeID->[dbo].[ShTaxConsumptionTypes].[TaxConsumptionTypeID]
FK_APVouchers_TermID_ShTermsTermID->[dbo].[ShTerms].[TermID]
FK_APVouchers_VendorID_APVendorsVendorID->[dbo].[APVendors].[VendorID]
FK_APVouchers_VoidID_APVouchersVoidID->[dbo].[APVouchers].[VoucherID]
CREATE TABLE [dbo].[APVouchers]
(
[VoucherID] [int] NOT NULL,
[VoucherNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Type] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[VendorID] [int] NOT NULL,
[ApplyToID] [int] NULL,
[InvoiceNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Date] [datetime] NOT NULL,
[DatePeriod] [int] NOT NULL,
[Period] [int] NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PONumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TermID] [int] NULL,
[TermDiscountRate] [float] NOT NULL,
[TermDiscountDate] [datetime] NULL,
[TermDiscount] [money] NOT NULL CONSTRAINT [DF_APVouchers_TermDiscount] DEFAULT ((0)),
[DueDate] [datetime] NOT NULL,
[PurchaserID] [int] NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[GLID] [int] NOT NULL,
[JobID] [int] NULL,
[Total] [money] NOT NULL CONSTRAINT [DF_APVouchers_Total] DEFAULT ((0)),
[AdjTotal] [money] NOT NULL CONSTRAINT [DF_APVouchers_AdjTotal] DEFAULT ((0)),
[Due] [money] NOT NULL CONSTRAINT [DF_APVouchers_Due] DEFAULT ((0)),
[Checks] [money] NOT NULL CONSTRAINT [DF_APVouchers_Checks] DEFAULT ((0)),
[Module] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Source] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Reference] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TransactionTypeID] [int] NOT NULL,
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_APVouchers_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_APVouchers_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[VoidID] [int] NULL,
[BranchID] [int] NULL,
[APBranchID] [int] NOT NULL,
[OnHoldCodeID] [int] NULL,
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_APVouchers_NoteFlag] DEFAULT ((0)),
[ReceivablePayableID] [int] NULL,
[NoteCount] [int] NOT NULL CONSTRAINT [DF_APVouchers_NoteCount] DEFAULT ((0)),
[Batch] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_APVouchers_Batch] DEFAULT (''),
[Subtype] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_APVouchers_Subtype] DEFAULT (''),
[TaxCodeID] [int] NULL,
[TaxExemptCodeID] [int] NULL,
[Tax] [money] NOT NULL CONSTRAINT [DF_APVouchers_Tax] DEFAULT ((0)),
[Taxable] [bit] NOT NULL CONSTRAINT [DF_APVouchers_Taxable] DEFAULT ((0)),
[CoverageFromDate] [datetime] NULL,
[CoverageToDate] [datetime] NULL,
[TaxUtilityConsumptionTypeID] [int] NULL,
[DBFileHeaderID] [int] NOT NULL CONSTRAINT [DF_APVouchers_DBFileHeaderID] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[APVouchers] ADD CONSTRAINT [PK_APVouchers] PRIMARY KEY CLUSTERED  ([VoucherID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[APVouchers] ADD CONSTRAINT [FK_APVouchers_APBranchID_GLBranches] FOREIGN KEY ([APBranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[APVouchers] ADD CONSTRAINT [FK_APVouchers_ApplyToID_APVouchers] FOREIGN KEY ([ApplyToID]) REFERENCES [dbo].[APVouchers] ([VoucherID])
GO
ALTER TABLE [dbo].[APVouchers] ADD CONSTRAINT [FK_APVouchers_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[APVouchers] ADD CONSTRAINT [FK_APVouchers_GLID_GLAccounts1] FOREIGN KEY ([GLID]) REFERENCES [dbo].[GLAccounts1] ([AccountID])
GO
ALTER TABLE [dbo].[APVouchers] ADD CONSTRAINT [FK_APVouchers_JobID_APJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[APJobs] ([JobID])
GO
ALTER TABLE [dbo].[APVouchers] ADD CONSTRAINT [FK_APVouchers_NoteID_APVoucherNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[APVoucherNotes] ([NoteID])
GO
ALTER TABLE [dbo].[APVouchers] ADD CONSTRAINT [FK_APVouchers_OnHoldCodeID_SHOnHoldCodes] FOREIGN KEY ([OnHoldCodeID]) REFERENCES [dbo].[ShOnHoldCodes] ([OnHoldCodeID])
GO
ALTER TABLE [dbo].[APVouchers] ADD CONSTRAINT [FK_APVouchers_PurchaserID_APPurchasers] FOREIGN KEY ([PurchaserID]) REFERENCES [dbo].[APPurchasers] ([PurchaserID])
GO
ALTER TABLE [dbo].[APVouchers] ADD CONSTRAINT [FK_APVouchers_ReceivablePayableID_ARAPReceivablePayables] FOREIGN KEY ([ReceivablePayableID]) REFERENCES [dbo].[ARAPReceivablePayables] ([ReceivablePayableID])
GO
ALTER TABLE [dbo].[APVouchers] ADD CONSTRAINT [FK_APVouchers_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[APVouchers] ADD CONSTRAINT [FK_APVouchers_TaxExemptCodeID_ShTaxExemptCodes] FOREIGN KEY ([TaxExemptCodeID]) REFERENCES [dbo].[SHTaxExemptCodes] ([TaxExemptCodeID])
GO
ALTER TABLE [dbo].[APVouchers] ADD CONSTRAINT [FK_APVouchers_TaxUtilityConsumptionTypeID_ShTaxConsumptionTypes] FOREIGN KEY ([TaxUtilityConsumptionTypeID]) REFERENCES [dbo].[ShTaxConsumptionTypes] ([TaxConsumptionTypeID])
GO
ALTER TABLE [dbo].[APVouchers] ADD CONSTRAINT [FK_APVouchers_TermID_ShTerms] FOREIGN KEY ([TermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO
ALTER TABLE [dbo].[APVouchers] ADD CONSTRAINT [FK_APVouchers_VendorID_APVendors] FOREIGN KEY ([VendorID]) REFERENCES [dbo].[APVendors] ([VendorID])
GO
ALTER TABLE [dbo].[APVouchers] ADD CONSTRAINT [FK_APVouchers_VoidID_APVouchers] FOREIGN KEY ([VoidID]) REFERENCES [dbo].[APVouchers] ([VoucherID])
GO