Tables [dbo].[PMTempImport]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count (~)0
Created4:57:09 PM Thursday, September 7, 2006
Last Modified5:01:53 PM Tuesday, November 4, 2008
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
PMTPriKeyint4
No
1 - 1
PMSessionIDvarchar(50)50
Yes
PaymentCodePriKeyint4
Yes
OrderControlvarchar(30)30
Yes
OrderPriKeyint4
Yes
Descriptionvarchar(35)35
Yes
Amountmoney8
Yes
BranchPriKeyint4
Yes
TransactionDatedatetime8
Yes
ServiceCodevarchar(3)3
Yes
DrvNovarchar(7)7
Yes
SortByvarchar(128)128
Yes
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[PMTempImport]
(
[PMTPriKey] [int] NOT NULL IDENTITY(1, 1),
[PMSessionID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PaymentCodePriKey] [int] NULL,
[OrderControl] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OrderPriKey] [int] NULL,
[Description] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Amount] [money] NULL,
[BranchPriKey] [int] NULL,
[TransactionDate] [datetime] NULL,
[ServiceCode] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DrvNo] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SortBy] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[PMTempImport] TO [MssExec]
GRANT INSERT ON  [dbo].[PMTempImport] TO [MssExec]
GRANT DELETE ON  [dbo].[PMTempImport] TO [MssExec]
GRANT UPDATE ON  [dbo].[PMTempImport] TO [MssExec]
GO
Uses