Tables [dbo].[ClaimItemDueFromPayment]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count (~)0
Created6:24:47 PM Monday, April 16, 2007
Last Modified10:37:48 AM Monday, March 30, 2015
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Primary Key PK_ClaimItemDueFromPayment: ClaimItemDueFromPaymentIDClaimItemDueFromPaymentIDint4
No
1 - 1
Foreign Keys FK_ClaimItemDueFromPayment_ClaimItemDueFrom: [dbo].[ClaimItemDueFrom].ClaimItemDueFromFIDIndexes IX_ClaimItemDueFromPayment_ClaimItemDueFromFID_ClaimPaymentDetailFID: ClaimItemDueFromFID\ClaimPaymentDetailFIDClaimItemDueFromFIDint4
No
Foreign Keys FK_ClaimItemDueFromPayment_ClaimPaymentDetail: [dbo].[ClaimPaymentDetail].ClaimPaymentDetailFIDIndexes IX_ClaimItemDueFromPayment_ClaimItemDueFromFID_ClaimPaymentDetailFID: ClaimItemDueFromFID\ClaimPaymentDetailFIDClaimPaymentDetailFIDint4
No
ApplyAmountmoney8
No
DocDatedatetime8
Yes
JournalDatedatetime8
Yes
Foreign Keys FK_ClaimItemDueFromPayment_AccountingNote: [dbo].[AccountingNote].AccountingNoteFIDAccountingNoteFIDint4
Yes
Foreign Keys FK_ClaimItemDueFromPayment_SysUser: [dbo].[Sysuser].PostedBySysuserFIDIndexes IX_ClaimItemDueFromPayment_PostedBySysuserFID: PostedBySysuserFIDPostedBySysuserFIDint4
Yes
PostedDatedatetime8
Yes
DocumentNumbervarchar(21)21
Yes
Indexes Indexes
NameColumnsUniqueFill Factor
Primary Key PK_ClaimItemDueFromPayment: ClaimItemDueFromPaymentIDPK_ClaimItemDueFromPaymentClaimItemDueFromPaymentID
Yes
80
IX_ClaimItemDueFromPayment_ClaimItemDueFromFID_ClaimPaymentDetailFIDClaimItemDueFromFID, ClaimPaymentDetailFID
Yes
80
IX_ClaimItemDueFromPayment_PostedBySysuserFIDPostedBySysuserFID
Foreign Keys Foreign Keys
NameColumns
FK_ClaimItemDueFromPayment_AccountingNoteAccountingNoteFID->[dbo].[AccountingNote].[ANPriKey]
FK_ClaimItemDueFromPayment_ClaimItemDueFromClaimItemDueFromFID->[dbo].[ClaimItemDueFrom].[ClaimItemDueFromID]
FK_ClaimItemDueFromPayment_ClaimPaymentDetailClaimPaymentDetailFID->[dbo].[ClaimPaymentDetail].[ClaimPaymentDetailID]
FK_ClaimItemDueFromPayment_SysUserPostedBySysuserFID->[dbo].[Sysuser].[SysUserID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[ClaimItemDueFromPayment]
(
[ClaimItemDueFromPaymentID] [int] NOT NULL IDENTITY(1, 1),
[ClaimItemDueFromFID] [int] NOT NULL,
[ClaimPaymentDetailFID] [int] NOT NULL,
[ApplyAmount] [money] NOT NULL,
[DocDate] [datetime] NULL,
[JournalDate] [datetime] NULL,
[AccountingNoteFID] [int] NULL,
[PostedBySysuserFID] [int] NULL,
[PostedDate] [datetime] NULL,
[DocumentNumber] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ClaimItemDueFromPayment] ADD CONSTRAINT [PK_ClaimItemDueFromPayment] PRIMARY KEY NONCLUSTERED  ([ClaimItemDueFromPaymentID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ClaimItemDueFromPayment] ADD CONSTRAINT [IX_ClaimItemDueFromPayment_ClaimItemDueFromFID_ClaimPaymentDetailFID] UNIQUE NONCLUSTERED  ([ClaimItemDueFromFID], [ClaimPaymentDetailFID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ClaimItemDueFromPayment_PostedBySysuserFID] ON [dbo].[ClaimItemDueFromPayment] ([PostedBySysuserFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ClaimItemDueFromPayment] ADD CONSTRAINT [FK_ClaimItemDueFromPayment_AccountingNote] FOREIGN KEY ([AccountingNoteFID]) REFERENCES [dbo].[AccountingNote] ([ANPriKey])
GO
ALTER TABLE [dbo].[ClaimItemDueFromPayment] ADD CONSTRAINT [FK_ClaimItemDueFromPayment_ClaimItemDueFrom] FOREIGN KEY ([ClaimItemDueFromFID]) REFERENCES [dbo].[ClaimItemDueFrom] ([ClaimItemDueFromID])
GO
ALTER TABLE [dbo].[ClaimItemDueFromPayment] ADD CONSTRAINT [FK_ClaimItemDueFromPayment_ClaimPaymentDetail] FOREIGN KEY ([ClaimPaymentDetailFID]) REFERENCES [dbo].[ClaimPaymentDetail] ([ClaimPaymentDetailID])
GO
ALTER TABLE [dbo].[ClaimItemDueFromPayment] ADD CONSTRAINT [FK_ClaimItemDueFromPayment_SysUser] FOREIGN KEY ([PostedBySysuserFID]) REFERENCES [dbo].[Sysuser] ([SysUserID])
GO
GRANT SELECT ON  [dbo].[ClaimItemDueFromPayment] TO [MssExec]
GRANT INSERT ON  [dbo].[ClaimItemDueFromPayment] TO [MssExec]
GRANT DELETE ON  [dbo].[ClaimItemDueFromPayment] TO [MssExec]
GRANT UPDATE ON  [dbo].[ClaimItemDueFromPayment] TO [MssExec]
GO
Uses