[dbo].[BATProcess]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count (~)	4
Created	4:57:06 PM Thursday, September 7, 2006
Last Modified	1:52:16 PM Wednesday, April 10, 2024

	Name	Columns	Unique	Fill Factor
	PK_BATProcess	BATProcessPriKey		80
	IX_BATProcess_DocumentNumber_BATSessionID	DocumentNumber, BATSessionID		80

Type	Action	Owning Principal
Grant	Delete	MssExec
Grant	Insert	MssExec
Grant	Select	MssExec
Grant	Update	MssExec

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

	Name	Data Type	Max Length (Bytes)	Identity	Default
	BATProcessPriKey	int	4	1 - 1
$Indexes IX_BATProcess_DocumentNumber_BATSessionID: DocumentNumber\BATSessionID$	BATSessionID	varchar(50)	50
	PostingDocNumber	int	4
	GLNumber	varchar(66)	66
	OpposingGLNumber	varchar(66)	66
$Indexes IX_BATProcess_DocumentNumber_BATSessionID: DocumentNumber\BATSessionID$	DocumentNumber	varchar(21)	21
	VoucherNumber	varchar(17)	17
	ApplyToDocument	varchar(21)	21
	TransactionType	varchar(30)	30
	TransactionAmount	money	8
	InvoicePayment	money	8
	InvoicePaymentAccount	varchar(50)	50
	DocumentDate	datetime	8
	JournalDate	datetime	8
	AcctDBName	varchar(50)	50
	ShipperName	varchar(50)	50
	ItemDescription	varchar(128)	128
	CustomerNumber	varchar(15)	15
	VendorNumber	varchar(15)	15
	PostingUserName	varchar(50)	50
	TransactionDate	datetime	8
	AccountingPostDate	datetime	8
	CustomerName	varchar(65)	65
	VendorName	varchar(65)	65
	PONumber	varchar(50)	50
	VendorInvoiceNumber	varchar(21)	21
	ICPriKey	int	4
	OrdPriKey	int	4
	BatchNumber	varchar(15)	15
	CustomerNumber2	varchar(15)	15
	OrderNo	varchar(23)	23
	Authority	varchar(30)	30
	NANumber	varchar(15)	15
	Driver	varchar(43)	43
	SalesPerson	varchar(43)	43
	ItemCode	int	4
	Source	varchar(50)	50
	SourceRecord	int	4
	AcctNote	text	max
	BranchID	varchar(5)	5
	InvoiceNumber	varchar(64)	64
	InvoiceDate	datetime	8
	1099Flag	bit	1		((0))
	OnHoldFlag	bit	1
	TempForeignID	int	4
	StatementHeaderID	varchar(15)	15