Tables [dbo].[BATProcess]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)4
Created4:57:06 PM Thursday, September 7, 2006
Last Modified9:10:52 AM Thursday, May 23, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_BATProcess: BATProcessPriKeyBATProcessPriKeyint4
No
1 - 1
Indexes IX_BATProcess_DocumentNumber_BATSessionID: DocumentNumber\BATSessionIDBATSessionIDvarchar(50)50
Yes
PostingDocNumberint4
Yes
GLNumbervarchar(66)66
No
OpposingGLNumbervarchar(66)66
No
Indexes IX_BATProcess_DocumentNumber_BATSessionID: DocumentNumber\BATSessionIDDocumentNumbervarchar(21)21
No
VoucherNumbervarchar(17)17
Yes
ApplyToDocumentvarchar(21)21
Yes
TransactionTypevarchar(30)30
No
TransactionAmountmoney8
No
InvoicePaymentmoney8
Yes
InvoicePaymentAccountvarchar(50)50
Yes
DocumentDatedatetime8
No
JournalDatedatetime8
No
AcctDBNamevarchar(50)50
No
ShipperNamevarchar(50)50
Yes
ItemDescriptionvarchar(128)128
Yes
CustomerNumbervarchar(15)15
Yes
VendorNumbervarchar(15)15
Yes
PostingUserNamevarchar(50)50
Yes
TransactionDatedatetime8
Yes
AccountingPostDatedatetime8
Yes
CustomerNamevarchar(65)65
Yes
VendorNamevarchar(65)65
Yes
PONumbervarchar(50)50
Yes
VendorInvoiceNumbervarchar(21)21
Yes
ICPriKeyint4
Yes
OrdPriKeyint4
Yes
BatchNumbervarchar(15)15
Yes
CustomerNumber2varchar(15)15
Yes
OrderNovarchar(23)23
Yes
Authorityvarchar(30)30
Yes
NANumbervarchar(15)15
Yes
Drivervarchar(43)43
Yes
SalesPersonvarchar(43)43
Yes
ItemCodeint4
Yes
Sourcevarchar(50)50
No
SourceRecordint4
No
AcctNotetextmax
Yes
BranchIDvarchar(5)5
Yes
InvoiceNumbervarchar(64)64
Yes
InvoiceDatedatetime8
Yes
1099Flagbit1
No
((0))
OnHoldFlagbit1
Yes
TempForeignIDint4
Yes
StatementHeaderIDvarchar(15)15
Yes
Indexes Indexes
NameColumnsUniqueFill Factor
Cluster Primary Key PK_BATProcess: BATProcessPriKeyPK_BATProcessBATProcessPriKey
Yes
80
IX_BATProcess_DocumentNumber_BATSessionIDDocumentNumber, BATSessionID80
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[BATProcess]
(
[BATProcessPriKey] [int] NOT NULL IDENTITY(1, 1),
[BATSessionID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PostingDocNumber] [int] NULL,
[GLNumber] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[OpposingGLNumber] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DocumentNumber] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[VoucherNumber] [varchar] (17) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ApplyToDocument] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TransactionType] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TransactionAmount] [money] NOT NULL,
[InvoicePayment] [money] NULL,
[InvoicePaymentAccount] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DocumentDate] [datetime] NOT NULL,
[JournalDate] [datetime] NOT NULL,
[AcctDBName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipperName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ItemDescription] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VendorNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PostingUserName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TransactionDate] [datetime] NULL,
[AccountingPostDate] [datetime] NULL,
[CustomerName] [varchar] (65) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VendorName] [varchar] (65) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PONumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VendorInvoiceNumber] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ICPriKey] [int] NULL,
[OrdPriKey] [int] NULL,
[BatchNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerNumber2] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OrderNo] [varchar] (23) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Authority] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NANumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Driver] [varchar] (43) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SalesPerson] [varchar] (43) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ItemCode] [int] NULL,
[Source] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SourceRecord] [int] NOT NULL,
[AcctNote] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BranchID] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InvoiceNumber] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InvoiceDate] [datetime] NULL,
[1099Flag] [bit] NOT NULL CONSTRAINT [DF_BATProcess_1099Flag] DEFAULT ((0)),
[OnHoldFlag] [bit] NULL,
[TempForeignID] [int] NULL,
[StatementHeaderID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[BATProcess] ADD CONSTRAINT [PK_BATProcess] PRIMARY KEY CLUSTERED  ([BATProcessPriKey]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_BATProcess_DocumentNumber_BATSessionID] ON [dbo].[BATProcess] ([DocumentNumber], [BATSessionID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[BATProcess] TO [MssExec]
GRANT INSERT ON  [dbo].[BATProcess] TO [MssExec]
GRANT DELETE ON  [dbo].[BATProcess] TO [MssExec]
GRANT UPDATE ON  [dbo].[BATProcess] TO [MssExec]
GO
Uses