Table Constrains and Indexes

ALTER TABLE [dbo].[D_GLBudget] ADD
CONSTRAINT [DF__D_GLBudge__rowgu__2180FB33] DEFAULT (newid()) FOR [rowguid],
CONSTRAINT [aaaaaD_GLBudget_PK] PRIMARY KEY NONCLUSTERED
(
[DocSite],
[DocUID]
) ON [PRIMARY]

CREATE INDEX [AutoUID] ON [dbo].[D_GLBudget]([AutoUID]) ON [PRIMARY]

CREATE INDEX [DocPeriod] ON [dbo].[D_GLBudget]([DocPeriod]) ON [PRIMARY]

CREATE INDEX [Module] ON [dbo].[D_GLBudget]([Module]) ON [PRIMARY]

CREATE INDEX [Source] ON [dbo].[D_GLBudget]([Source]) ON [PRIMARY]

CREATE INDEX [TaxCode] ON [dbo].[D_GLBudget]([TaxCode]) ON [PRIMARY]

CREATE INDEX [TransDate] ON [dbo].[D_GLBudget]([TransDate]) ON [PRIMARY]

CREATE UNIQUE INDEX [index_197575742] ON [dbo].[D_GLBudget]([rowguid]) ON [PRIMARY]

ALTER TABLE [dbo].[D_GLBudgetItem] ADD
CONSTRAINT [DF__D_GLBudge__rowgu__2739D489] DEFAULT (newid()) FOR [rowguid],
CONSTRAINT [aaaaaD_GLBudgetItem_PK] PRIMARY KEY NONCLUSTERED
(
[DocItemUID]
) ON [PRIMARY]

CREATE INDEX [AcctCode] ON [dbo].[D_GLBudgetItem]([AcctCode]) ON [PRIMARY]

CREATE INDEX [AllocPeriod] ON [dbo].[D_GLBudgetItem]([AllocPeriod]) ON [PRIMARY]

CREATE UNIQUE INDEX [AutoItemUID] ON [dbo].[D_GLBudgetItem]([AutoItemUID]) ON [PRIMARY]

CREATE INDEX [CurrencyCode] ON [dbo].[D_GLBudgetItem]([CurrencyCode]) ON [PRIMARY]

CREATE INDEX [DeptCode] ON [dbo].[D_GLBudgetItem]([DeptCode]) ON [PRIMARY]

CREATE INDEX [DocDate] ON [dbo].[D_GLBudgetItem]([DocDate]) ON [PRIMARY]

CREATE INDEX [DocNo] ON [dbo].[D_GLBudgetItem]([DocNo]) ON [PRIMARY]

CREATE INDEX [DocUID] ON [dbo].[D_GLBudgetItem]([DocUID]) ON [PRIMARY]

CREATE INDEX [JobCode] ON [dbo].[D_GLBudgetItem]([JobCode]) ON [PRIMARY]

CREATE INDEX [Reason] ON [dbo].[D_GLBudgetItem]([Reason]) ON [PRIMARY]

CREATE UNIQUE INDEX [index_277576027] ON [dbo].[D_GLBudgetItem]([rowguid]) ON [PRIMARY]

ALTER TABLE [dbo].[D_GLJournal] ADD
CONSTRAINT [DF__D_GLJourn__rowgu__2CF2ADDF] DEFAULT (newid()) FOR [rowguid],
CONSTRAINT [aaaaaD_GLJournal_PK] PRIMARY KEY NONCLUSTERED
(
[DocSite],
[DocUID]
) ON [PRIMARY]

CREATE INDEX [_F9FF1AF4_406B_11D3_93DD_00201] ON [dbo].[D_GLJournal]([Module], [Source]) ON [PRIMARY]

CREATE INDEX [_F9FF1AF5_406B_11D3_93DD_00201] ON [dbo].[D_GLJournal]([TaxCode]) ON [PRIMARY]

CREATE INDEX [_F9FF1AFB_406B_11D3_93DD_00201] ON [dbo].[D_GLJournal]([DocPeriod]) ON [PRIMARY]

CREATE INDEX [AutoUID] ON [dbo].[D_GLJournal]([AutoUID]) ON [PRIMARY]

CREATE INDEX [DocPeriod] ON [dbo].[D_GLJournal]([DocPeriod]) ON [PRIMARY]

CREATE INDEX [Module] ON [dbo].[D_GLJournal]([Module]) ON [PRIMARY]

CREATE INDEX [Source] ON [dbo].[D_GLJournal]([Source]) ON [PRIMARY]

CREATE INDEX [TaxCode] ON [dbo].[D_GLJournal]([TaxCode]) ON [PRIMARY]

CREATE INDEX [TransDate] ON [dbo].[D_GLJournal]([TransDate]) ON [PRIMARY]

CREATE UNIQUE INDEX [index_1701581100] ON [dbo].[D_GLJournal]([rowguid]) ON [PRIMARY]

ALTER TABLE [dbo].[D_GLJournalItem] ADD
CONSTRAINT [DF__D_GLJourn__rowgu__32AB8735] DEFAULT (newid()) FOR [rowguid],
CONSTRAINT [aaaaaD_GLJournalItem_PK] PRIMARY KEY NONCLUSTERED
(
[DocItemUID]
) ON [PRIMARY]

CREATE INDEX [_F9FF1AE7_406B_11D3_93DD_00201] ON [dbo].[D_GLJournalItem]([DocSite], [DocUID]) ON [PRIMARY]

CREATE INDEX [_F9FF1AE8_406B_11D3_93DD_00201] ON [dbo].[D_GLJournalItem]([CurrencyCode]) ON [PRIMARY]

CREATE INDEX [_F9FF1AEA_406B_11D3_93DD_00201] ON [dbo].[D_GLJournalItem]([AcctCode]) ON [PRIMARY]

CREATE INDEX [_F9FF1AF0_406B_11D3_93DD_00201] ON [dbo].[D_GLJournalItem]([DeptCode]) ON [PRIMARY]

CREATE INDEX [_F9FF1AF1_406B_11D3_93DD_00201] ON [dbo].[D_GLJournalItem]([JobCode]) ON [PRIMARY]

CREATE INDEX [_F9FF1AFC_406B_11D3_93DD_00201] ON [dbo].[D_GLJournalItem]([AllocPeriod]) ON [PRIMARY]

CREATE INDEX [AcctCode] ON [dbo].[D_GLJournalItem]([AcctCode]) ON [PRIMARY]

CREATE INDEX [AllocPeriod] ON [dbo].[D_GLJournalItem]([AllocPeriod]) ON [PRIMARY]

CREATE UNIQUE INDEX [AutoItemUID] ON [dbo].[D_GLJournalItem]([AutoItemUID]) ON [PRIMARY]

CREATE INDEX [CurrencyCode] ON [dbo].[D_GLJournalItem]([CurrencyCode]) ON [PRIMARY]

CREATE INDEX [DeptCode] ON [dbo].[D_GLJournalItem]([DeptCode]) ON [PRIMARY]

CREATE INDEX [DocDate] ON [dbo].[D_GLJournalItem]([DocDate]) ON [PRIMARY]

CREATE INDEX [DocNo] ON [dbo].[D_GLJournalItem]([DocNo]) ON [PRIMARY]

CREATE INDEX [DocUID] ON [dbo].[D_GLJournalItem]([DocUID]) ON [PRIMARY]

CREATE INDEX [JobCode] ON [dbo].[D_GLJournalItem]([JobCode]) ON [PRIMARY]

CREATE INDEX [Reason] ON [dbo].[D_GLJournalItem]([Reason]) ON [PRIMARY]

CREATE UNIQUE INDEX [index_1765581328] ON [dbo].[D_GLJournalItem]([rowguid]) ON [PRIMARY]

ALTER TABLE [dbo].[D_GLSum] ADD
CONSTRAINT [DF__D_GLSum__rowguid__3864608B] DEFAULT (newid()) FOR [rowguid],
CONSTRAINT [aaaaaD_GLSum_PK] PRIMARY KEY NONCLUSTERED
(
[DocPeriod],
[AcctCode],
[DeptCode],
[CurrencyCode]
) ON [PRIMARY]

CREATE INDEX [_F9FF1AFD_406B_11D3_93DD_00201] ON [dbo].[D_GLSum]([DocPeriod]) ON [PRIMARY]

CREATE INDEX [_F9FF1B04_406B_11D3_93DD_00201] ON [dbo].[D_GLSum]([CurrencyCode]) ON [PRIMARY]

CREATE INDEX [_F9FF1B06_406B_11D3_93DD_00201] ON [dbo].[D_GLSum]([AcctCode]) ON [PRIMARY]

CREATE INDEX [_F9FF1B07_406B_11D3_93DD_00201] ON [dbo].[D_GLSum]([DeptCode]) ON [PRIMARY]

CREATE INDEX [AcctCode] ON [dbo].[D_GLSum]([AcctCode]) ON [PRIMARY]

CREATE UNIQUE INDEX [index_1109578991] ON [dbo].[D_GLSum]([rowguid]) ON [PRIMARY]

ALTER TABLE [dbo].[D_Period] ADD
CONSTRAINT [DF__D_Period__rowgui__3E1D39E1] DEFAULT (newid()) FOR [rowguid],
CONSTRAINT [aaaaaD_Period_PK] PRIMARY KEY NONCLUSTERED
(
[DocPeriod]
) ON [PRIMARY]

CREATE UNIQUE INDEX [index_581577110] ON [dbo].[D_Period]([rowguid]) ON [PRIMARY]

ALTER TABLE [dbo].[K_Company] ADD
CONSTRAINT [DF__K_Company__rowgu__43D61337] DEFAULT (newid()) FOR [rowguid],
CONSTRAINT [aaaaaK_Company_PK] PRIMARY KEY NONCLUSTERED
(
[DefaultCounter]
) ON [PRIMARY]

CREATE UNIQUE INDEX [index_853578079] ON [dbo].[K_Company]([rowguid]) ON [PRIMARY]

ALTER TABLE [dbo].[K_Parameter] ADD
CONSTRAINT [DF__K_Paramet__rowgu__498EEC8D] DEFAULT (newid()) FOR [rowguid],
CONSTRAINT [aaaaaK_Parameter_PK] PRIMARY KEY NONCLUSTERED
(
[LCounter]
) ON [PRIMARY]

CREATE UNIQUE INDEX [index_917578307] ON [dbo].[K_Parameter]([rowguid]) ON [PRIMARY]

ALTER TABLE [dbo].[L_Country] ADD
CONSTRAINT [DF__L_Country__rowgu__4F47C5E3] DEFAULT (newid()) FOR [rowguid],
CONSTRAINT [aaaaaL_Country_PK] PRIMARY KEY NONCLUSTERED
(
[CountryCode]
) ON [PRIMARY]

CREATE UNIQUE INDEX [CountryCode] ON [dbo].[L_Country]([CountryCode]) ON [PRIMARY]

CREATE UNIQUE INDEX [index_981578535] ON [dbo].[L_Country]([rowguid]) ON [PRIMARY]

ALTER TABLE [dbo].[L_Currency] ADD
CONSTRAINT [DF__L_Currenc__rowgu__55009F39] DEFAULT (newid()) FOR [rowguid],
CONSTRAINT [aaaaaL_Currency_PK] PRIMARY KEY NONCLUSTERED
(
[CurrencyCode]
) ON [PRIMARY]

CREATE UNIQUE INDEX [index_485576768] ON [dbo].[L_Currency]([rowguid]) ON [PRIMARY]

ALTER TABLE [dbo].[L_GLAccount] ADD
CONSTRAINT [DF__L_GLAccou__rowgu__5AB9788F] DEFAULT (newid()) FOR [rowguid],
CONSTRAINT [aaaaaL_GLAccount_PK] PRIMARY KEY NONCLUSTERED
(
[AcctCode]
) ON [PRIMARY]

CREATE INDEX [Description] ON [dbo].[L_GLAccount]([Description]) ON [PRIMARY]

CREATE UNIQUE INDEX [index_661577395] ON [dbo].[L_GLAccount]([rowguid]) ON [PRIMARY]

ALTER TABLE [dbo].[L_GLAccountOrg] ADD
CONSTRAINT [DF__L_GLAccou__rowgu__607251E5] DEFAULT (newid()) FOR [rowguid],
CONSTRAINT [aaaaaL_GLAccountOrg_PK] PRIMARY KEY NONCLUSTERED
(
[ACCTCODE],
[LocationCode]
) ON [PRIMARY]

CREATE INDEX [_F9FF1AEB_406B_11D3_93DD_00201] ON [dbo].[L_GLAccountOrg]([ACCTCODE]) ON [PRIMARY]

CREATE INDEX [PaymentModeID] ON [dbo].[L_GLAccountOrg]([PaymentModeID]) ON [PRIMARY]

CREATE INDEX [PaymentTermID] ON [dbo].[L_GLAccountOrg]([PaymentTermID]) ON [PRIMARY]

CREATE INDEX [TaxCode] ON [dbo].[L_GLAccountOrg]([TaxCode]) ON [PRIMARY]

CREATE UNIQUE INDEX [index_1189579276] ON [dbo].[L_GLAccountOrg]([rowguid]) ON [PRIMARY]

ALTER TABLE [dbo].[L_GLDept] ADD
CONSTRAINT [DF__L_GLDept__rowgui__662B2B3B] DEFAULT (newid()) FOR [rowguid],
CONSTRAINT [aaaaaL_GLDept_PK] PRIMARY KEY NONCLUSTERED
(
[DeptCode]
) ON [PRIMARY]

CREATE UNIQUE INDEX [index_1045578763] ON [dbo].[L_GLDept]([rowguid]) ON [PRIMARY]

ALTER TABLE [dbo].[L_GLJob] ADD
CONSTRAINT [DF__L_GLJob__rowguid__6BE40491] DEFAULT (newid()) FOR [rowguid],
CONSTRAINT [aaaaaL_GLJob_PK] PRIMARY KEY NONCLUSTERED
(
[JobCode]
) ON [PRIMARY]

CREATE INDEX [AcctCode] ON [dbo].[L_GLJob]([AcctCode]) ON [PRIMARY]

CREATE INDEX [DeptCode] ON [dbo].[L_GLJob]([DeptCode]) ON [PRIMARY]

CREATE UNIQUE INDEX [index_1301579675] ON [dbo].[L_GLJob]([rowguid]) ON [PRIMARY]

ALTER TABLE [dbo].[L_GLJournalDesc] ADD
CONSTRAINT [DF__L_GLJourn__rowgu__719CDDE7] DEFAULT (newid()) FOR [rowguid],
CONSTRAINT [aaaaaL_GLJournalDesc_PK] PRIMARY KEY NONCLUSTERED
(
[Description]
) ON [PRIMARY]

CREATE UNIQUE INDEX [index_1445580188] ON [dbo].[L_GLJournalDesc]([rowguid]) ON [PRIMARY]

ALTER TABLE [dbo].[L_GLJournalReason] ADD
CONSTRAINT [DF__L_GLJourn__rowgu__7755B73D] DEFAULT (newid()) FOR [rowguid],
CONSTRAINT [aaaaaL_GLJournalReason_PK] PRIMARY KEY NONCLUSTERED
(
[Reason]
) ON [PRIMARY]

CREATE UNIQUE INDEX [index_1509580416] ON [dbo].[L_GLJournalReason]([rowguid]) ON [PRIMARY]

ALTER TABLE [dbo].[L_GLReport] ADD
CONSTRAINT [DF__L_GLRepor__rowgu__7D0E9093] DEFAULT (newid()) FOR [rowguid],
CONSTRAINT [aaaaaL_GLReport_PK] PRIMARY KEY NONCLUSTERED
(
[ReportID]
) ON [PRIMARY]

CREATE UNIQUE INDEX [index_1573580644] ON [dbo].[L_GLReport]([rowguid]) ON [PRIMARY]

ALTER TABLE [dbo].[L_GLReportItem] ADD
CONSTRAINT [DF__L_GLRepor__rowgu__02C769E9] DEFAULT (newid()) FOR [rowguid],
CONSTRAINT [aaaaaL_GLReportItem_PK] PRIMARY KEY NONCLUSTERED
(
[ReportID],
[ReportLineID]
) ON [PRIMARY]

CREATE INDEX [_F9FF1AF2_406B_11D3_93DD_00201] ON [dbo].[L_GLReportItem]([ReportID]) ON [PRIMARY]

CREATE UNIQUE INDEX [index_1637580872] ON [dbo].[L_GLReportItem]([rowguid]) ON [PRIMARY]

ALTER TABLE [dbo].[L_GLSource] ADD
CONSTRAINT [DF__L_GLSourc__rowgu__0880433F] DEFAULT (newid()) FOR [rowguid],
CONSTRAINT [aaaaaL_GLSource_PK] PRIMARY KEY NONCLUSTERED
(
[Module],
[Source]
) ON [PRIMARY]

CREATE UNIQUE INDEX [index_421576540] ON [dbo].[L_GLSource]([rowguid]) ON [PRIMARY]

ALTER TABLE [dbo].[L_GLTax] ADD
CONSTRAINT [DF__L_GLTax__rowguid__0E391C95] DEFAULT (newid()) FOR [rowguid],
CONSTRAINT [aaaaaL_GLTax_PK] PRIMARY KEY NONCLUSTERED
(
[TaxCode]
) ON [PRIMARY]

CREATE UNIQUE INDEX [index_1381579960] ON [dbo].[L_GLTax]([rowguid]) ON [PRIMARY]

Updated On: 05.03.31