[dbo].[XLedgerJournalEntryBatchItem]

Property	Value
Row Count (~)	0
Created	10:13:22 PM Sunday, March 30, 2025
Last Modified	10:13:22 PM Sunday, March 30, 2025

	Name	Data Type	Max Length (Bytes)	Identity
	XLedgerJournalEntryBatchItemId	int	4	1 - 1
$Indexes IX_XLedgerJournalEntryBatchFid_AcctTransactionFid: XLedgerJournalEntryBatchFid\AcctTransactionFid$	XLedgerJournalEntryBatchFid	int	4
$Indexes IX_XLedgerJournalEntryBatchFid_AcctTransactionFid: XLedgerJournalEntryBatchFid\AcctTransactionFid$	AcctTransactionFid	int	4
	XglFid	int	4
	BranchFid	int	4
	AccountingAccountFid	int	4
	AccountingCustomerFid	int	4

	Name	Columns	Unique
	PK_XLedgerJournalEntryBatchItem	XLedgerJournalEntryBatchItemId
	IX_XLedgerJournalEntryBatchFid_AcctTransactionFid	XLedgerJournalEntryBatchFid, AcctTransactionFid

Name	Columns
FK_XLedgerJournalEntryBatchItem_AccountingAccount	AccountingAccountFid->[dbo].[AccountingAccount].[AccountingAccountId]
FK_XLedgerJournalEntryBatchItem_AccountingCustomer	AccountingCustomerFid->[dbo].[AccountingCustomer].[AccountingCustomerId]
FK_XLedgerJournalEntryBatchItem_Branch	BranchFid->[dbo].[Branch].[BranchPriKey]
FK_XLedgerJournalEntryBatchItem_Xgl	XglFid->[dbo].[Xgl].[XglId]
FK_XLedgerJournalEntryBatchItem_AcctTransactions	XLedgerJournalEntryBatchFid->[dbo].[AcctTransactions].[ATPriKey]
FK_XLedgerJournalEntryBatchItem_XLedgerJournalEntryBatch	XLedgerJournalEntryBatchFid->[dbo].[XLedgerJournalEntryBatch].[XLedgerJournalEntryBatchId]

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

SQL Script

CREATE TABLE [dbo].[XLedgerJournalEntryBatchItem]
(
[XLedgerJournalEntryBatchItemId] [int] NOT NULL IDENTITY(1, 1),
[XLedgerJournalEntryBatchFid] [int] NOT NULL,
[AcctTransactionFid] [int] NOT NULL,
[XglFid] [int] NOT NULL,
[BranchFid] [int] NOT NULL,
[AccountingAccountFid] [int] NOT NULL,
[AccountingCustomerFid] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [PK_XLedgerJournalEntryBatchItem] PRIMARY KEY CLUSTERED  ([XLedgerJournalEntryBatchItemId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [IX_XLedgerJournalEntryBatchFid_AcctTransactionFid] UNIQUE NONCLUSTERED  ([XLedgerJournalEntryBatchFid], [AcctTransactionFid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [FK_XLedgerJournalEntryBatchItem_AccountingAccount] FOREIGN KEY ([AccountingAccountFid]) REFERENCES [dbo].[AccountingAccount] ([AccountingAccountId])
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [FK_XLedgerJournalEntryBatchItem_AccountingCustomer] FOREIGN KEY ([AccountingCustomerFid]) REFERENCES [dbo].[AccountingCustomer] ([AccountingCustomerId])
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [FK_XLedgerJournalEntryBatchItem_Branch] FOREIGN KEY ([BranchFid]) REFERENCES [dbo].[Branch] ([BranchPriKey])
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [FK_XLedgerJournalEntryBatchItem_Xgl] FOREIGN KEY ([XglFid]) REFERENCES [dbo].[Xgl] ([XglId])
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [FK_XLedgerJournalEntryBatchItem_AcctTransactions] FOREIGN KEY ([XLedgerJournalEntryBatchFid]) REFERENCES [dbo].[AcctTransactions] ([ATPriKey])
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [FK_XLedgerJournalEntryBatchItem_XLedgerJournalEntryBatch] FOREIGN KEY ([XLedgerJournalEntryBatchFid]) REFERENCES [dbo].[XLedgerJournalEntryBatch] ([XLedgerJournalEntryBatchId])
GO
GRANT SELECT ON  [dbo].[XLedgerJournalEntryBatchItem] TO [MssExec]
GRANT INSERT ON  [dbo].[XLedgerJournalEntryBatchItem] TO [MssExec]
GRANT DELETE ON  [dbo].[XLedgerJournalEntryBatchItem] TO [MssExec]
GRANT UPDATE ON  [dbo].[XLedgerJournalEntryBatchItem] TO [MssExec]
GO