Tables [dbo].[PMImportHeader]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:05:54 PM Monday, January 28, 2013
Last Modified7:32:27 PM Tuesday, June 11, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_PMImportHeader: PMImportHeaderIDPMImportHeaderIDint4
No
1 - 1
Foreign Keys FK_PMImportHeader_XmlInterface: [dbo].[XmlInterface].XmlInterfaceFIDXmlInterfaceFIDint4
No
Descriptionvarchar(30)30
Yes
JournalDatedatetime8
Yes
Amountmoney8
Yes
Foreign Keys FK_PMImportHeader_Agent: [dbo].[Agent].AgentFIDAgentFIDint4
Yes
Foreign Keys FK_PMImportHeader_Branch: [dbo].[Branch].BranchFIDBranchFIDint4
Yes
IsCRBatchsmallint2
Yes
Filenamevarchar(64)64
Yes
FilePathvarchar(256)256
Yes
IsVanLineStatementbit1
No
((0))
AutoApplyFlagbit1
No
((0))
VanlineGroupExternalCodevarchar(10)10
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_PMImportHeader: PMImportHeaderIDPK_PMImportHeaderPMImportHeaderID
Yes
Foreign Keys Foreign Keys
NameColumns
FK_PMImportHeader_AgentAgentFID->[dbo].[Agent].[AgentPriKey]
FK_PMImportHeader_BranchBranchFID->[dbo].[Branch].[BranchPriKey]
FK_PMImportHeader_XmlInterfaceXmlInterfaceFID->[dbo].[XmlInterface].[XmlInterfaceID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[PMImportHeader]
(
[PMImportHeaderID] [int] NOT NULL IDENTITY(1, 1),
[XmlInterfaceFID] [int] NOT NULL,
[Description] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[JournalDate] [datetime] NULL,
[Amount] [money] NULL,
[AgentFID] [int] NULL,
[BranchFID] [int] NULL,
[IsCRBatch] [smallint] NULL,
[Filename] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FilePath] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsVanLineStatement] [bit] NOT NULL CONSTRAINT [DF_PMImportHeader_IsVanLineStatement] DEFAULT ((0)),
[AutoApplyFlag] [bit] NOT NULL CONSTRAINT [DF_PMImportHEader_AutoApplyFlag] DEFAULT ((0)),
[VanlineGroupExternalCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PMImportHeader] ADD CONSTRAINT [PK_PMImportHeader] PRIMARY KEY CLUSTERED  ([PMImportHeaderID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PMImportHeader] ADD CONSTRAINT [FK_PMImportHeader_Agent] FOREIGN KEY ([AgentFID]) REFERENCES [dbo].[Agent] ([AgentPriKey])
GO
ALTER TABLE [dbo].[PMImportHeader] ADD CONSTRAINT [FK_PMImportHeader_Branch] FOREIGN KEY ([BranchFID]) REFERENCES [dbo].[Branch] ([BranchPriKey])
GO
ALTER TABLE [dbo].[PMImportHeader] ADD CONSTRAINT [FK_PMImportHeader_XmlInterface] FOREIGN KEY ([XmlInterfaceFID]) REFERENCES [dbo].[XmlInterface] ([XmlInterfaceID])
GO
GRANT SELECT ON  [dbo].[PMImportHeader] TO [MssExec]
GRANT INSERT ON  [dbo].[PMImportHeader] TO [MssExec]
GRANT DELETE ON  [dbo].[PMImportHeader] TO [MssExec]
GRANT UPDATE ON  [dbo].[PMImportHeader] TO [MssExec]
GO
Uses
Used By