Tables [dbo].[POHReceipts]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:58:27 AM Thursday, March 21, 2019
Last Modified1:12:46 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_POHReceipts: HReceiptIDHReceiptIDint4
False
HReceiptNumbervarchar(32)32
True
Foreign Keys FK_POHReceipts_VendorID_APVendors: [dbo].[APVendors].VendorIDVendorIDint4
True
VendorNamevarchar(50)50
True
Foreign Keys FK_POHReceipts_JobID_ICJobs: [dbo].[ICJobs].JobIDJobIDint4
True
JobNumbervarchar(15)15
True
Datedatetime8
True
DatePeriodint4
True
Periodint4
True
Descriptionvarchar(255)255
True
Remarksvarchar(1024)1024
True
Totalmoney8
True
UnVoucheredmoney8
True
TransactionTypeIDint4
True
TransactionTypevarchar(64)64
True
Reversalbit1
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_POHReceipts: HReceiptIDPK_POHReceiptsHReceiptID
True
80
NameColumns
FK_POHReceipts_JobID_ICJobsJobID->[dbo].[ICJobs].[JobID]
FK_POHReceipts_VendorID_APVendorsVendorID->[dbo].[APVendors].[VendorID]
CREATE TABLE [dbo].[POHReceipts]
(
[HReceiptID] [int] NOT NULL,
[HReceiptNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VendorID] [int] NULL,
[VendorName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[JobID] [int] NULL,
[JobNumber] [varchar] (15) 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,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Total] [money] NULL,
[UnVouchered] [money] NULL,
[TransactionTypeID] [int] NULL,
[TransactionType] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Reversal] [bit] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POHReceipts] ADD CONSTRAINT [PK_POHReceipts] PRIMARY KEY CLUSTERED  ([HReceiptID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POHReceipts] ADD CONSTRAINT [FK_POHReceipts_JobID_ICJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ICJobs] ([JobID])
GO
ALTER TABLE [dbo].[POHReceipts] ADD CONSTRAINT [FK_POHReceipts_VendorID_APVendors] FOREIGN KEY ([VendorID]) REFERENCES [dbo].[APVendors] ([VendorID])
GO