dbo.tbl_sw_IndexKeys

288 rows · 6 columns

ready

Read-only. Up to 100 rows a page, 5,000 in an export.

tblName	FldName	ixClust	ixUnq	DBName	PKey
tbl_Emp_Track	TUpdate	false	false	—	false
tbl_FastMoving	RefId	true	true	—	true
tbl_FastMoving	OrdNo	false	false	—	false
tbl_FastMoving	ItemDetailId	false	false	—	false
tbl_FutureTrans	PymtDate, FxdId_PMode, LedId_Customer	false	false	—	false
tbl_GdwnIn	StkFrom, StkFromId, StkFromItemNo	false	false	—	false
tbl_GdwnIn	ItemDetailId	false	false	—	false
tbl_GdwnIn	GdnUsrId, GrpId_Cost, GdnItemNo, CompanyId, YearId	true	true	—	false
tbl_GdwnIn	GdnUsrId, GrpId_Cost, CompanyId, YearId	false	false	—	false
tbl_GdwnIn	GdnId	false	false	—	false
tbl_GdwnOut	StkFrom, StkFromId, StkFromItemNo	false	false	—	false
tbl_GdwnOut	GdnUsrId, GrpId_Cost, GdnItemNo, CompanyId, YearId	true	true	—	false
tbl_GdwnOut	GdnUsrId, GrpId_Cost, CompanyId, YearId	false	false	—	false
tbl_GdwnOut	GdnId	false	false	—	false
tbl_GenCrNote	NoteUsrDate	false	false	—	false
tbl_GenCrNote	NoteId	true	true	—	true
tbl_GenCrNote	MyType, NoteUsrId	false	false	—	false
tbl_GenCrNote	MyType, BrchId, TypeId, NoteUsrId, CompanyId, YearId	false	true	—	false
tbl_GenCrNote	EditUpdate	false	false	—	false
tbl_GenDrNote	SP_LedId, SP_CollectnDate	false	false	—	false
tbl_GenDrNote	SP_CollectnPymtDate	false	false	—	false
tbl_GenDrNote	NoteUsrDate	false	false	—	false
tbl_GenDrNote	NoteId	true	true	—	true
tbl_GenDrNote	MyType, NoteUsrId	false	false	—	false
tbl_GenDrNote	MyType, BrchId, TypeId, NoteUsrId, CompanyId, YearId	false	true	—	false
tbl_GenDrNote	EditUpdate	false	false	—	false
tbl_GradeChange	TaskDt	true	false	—	false
tbl_GridFilterHistory	GridId	true	false	—	false
tbl_GridPrn	GridId	true	true	—	true
tbl_GroupDetail	Type_Id	false	false	—	false
tbl_GroupDetail	GrpName	false	false	—	false
tbl_GroupDetail	GrpId	true	true	—	true
tbl_GST_EInv	MyId, MyType	true	false	—	false
tbl_HoliDay	HDDate	false	false	—	false
tbl_ImportPI_Dtl	LedId_Party, Party_InvNo	false	false	—	false
tbl_ImportPI_Hdr	LedId_Party, Party_InvNo	false	false	—	false
tbl_ImportPI_Map	MfgrId, MfgrSuppId, Mfgr_Code, ItemDetailId	true	true	—	false
tbl_INClauseIDs	UsrId, SPName	true	false	—	false
tbl_Inventory	LedId_Mfg	false	false	—	false
tbl_Inventory	ItemUsrCode	false	false	—	false
tbl_Inventory	ItemDetailId	true	false	—	false
tbl_Inward	UsrDate	true	false	—	false
tbl_Inward	MyId, MyItemNo, MyType	false	true	—	false
tbl_Inward	LedId_Party, ItemDetailId	false	false	—	false
tbl_Inward	ItemDetailId	false	false	—	false
tbl_Inward	EditUpdate	false	false	—	false
tbl_ItemBranch	GrpId_Cost	true	false	—	false
tbl_ItemMaster	ItemUsrCode	false	false	—	false
tbl_ItemMaster	ItemName	false	false	—	false
tbl_ItemMaster	ItemDetailId	true	true	—	true

51–100 of 288 rows

tblName	FldName	ixClust	ixUnq	DBName	PKey
tbl_Emp_Track	TUpdate	false	false	—	false
tbl_FastMoving	RefId	true	true	—	true
tbl_FastMoving	OrdNo	false	false	—	false
tbl_FastMoving	ItemDetailId	false	false	—	false
tbl_FutureTrans	PymtDate, FxdId_PMode, LedId_Customer	false	false	—	false
tbl_GdwnIn	StkFrom, StkFromId, StkFromItemNo	false	false	—	false
tbl_GdwnIn	ItemDetailId	false	false	—	false
tbl_GdwnIn	GdnUsrId, GrpId_Cost, GdnItemNo, CompanyId, YearId	true	true	—	false
tbl_GdwnIn	GdnUsrId, GrpId_Cost, CompanyId, YearId	false	false	—	false
tbl_GdwnIn	GdnId	false	false	—	false
tbl_GdwnOut	StkFrom, StkFromId, StkFromItemNo	false	false	—	false
tbl_GdwnOut	GdnUsrId, GrpId_Cost, GdnItemNo, CompanyId, YearId	true	true	—	false
tbl_GdwnOut	GdnUsrId, GrpId_Cost, CompanyId, YearId	false	false	—	false
tbl_GdwnOut	GdnId	false	false	—	false
tbl_GenCrNote	NoteUsrDate	false	false	—	false
tbl_GenCrNote	NoteId	true	true	—	true
tbl_GenCrNote	MyType, NoteUsrId	false	false	—	false
tbl_GenCrNote	MyType, BrchId, TypeId, NoteUsrId, CompanyId, YearId	false	true	—	false
tbl_GenCrNote	EditUpdate	false	false	—	false
tbl_GenDrNote	SP_LedId, SP_CollectnDate	false	false	—	false
tbl_GenDrNote	SP_CollectnPymtDate	false	false	—	false
tbl_GenDrNote	NoteUsrDate	false	false	—	false
tbl_GenDrNote	NoteId	true	true	—	true
tbl_GenDrNote	MyType, NoteUsrId	false	false	—	false
tbl_GenDrNote	MyType, BrchId, TypeId, NoteUsrId, CompanyId, YearId	false	true	—	false
tbl_GenDrNote	EditUpdate	false	false	—	false
tbl_GradeChange	TaskDt	true	false	—	false
tbl_GridFilterHistory	GridId	true	false	—	false
tbl_GridPrn	GridId	true	true	—	true
tbl_GroupDetail	Type_Id	false	false	—	false
tbl_GroupDetail	GrpName	false	false	—	false
tbl_GroupDetail	GrpId	true	true	—	true
tbl_GST_EInv	MyId, MyType	true	false	—	false
tbl_HoliDay	HDDate	false	false	—	false
tbl_ImportPI_Dtl	LedId_Party, Party_InvNo	false	false	—	false
tbl_ImportPI_Hdr	LedId_Party, Party_InvNo	false	false	—	false
tbl_ImportPI_Map	MfgrId, MfgrSuppId, Mfgr_Code, ItemDetailId	true	true	—	false
tbl_INClauseIDs	UsrId, SPName	true	false	—	false
tbl_Inventory	LedId_Mfg	false	false	—	false
tbl_Inventory	ItemUsrCode	false	false	—	false
tbl_Inventory	ItemDetailId	true	false	—	false
tbl_Inward	UsrDate	true	false	—	false
tbl_Inward	MyId, MyItemNo, MyType	false	true	—	false
tbl_Inward	LedId_Party, ItemDetailId	false	false	—	false
tbl_Inward	ItemDetailId	false	false	—	false
tbl_Inward	EditUpdate	false	false	—	false
tbl_ItemBranch	GrpId_Cost	true	false	—	false
tbl_ItemMaster	ItemUsrCode	false	false	—	false
tbl_ItemMaster	ItemName	false	false	—	false
tbl_ItemMaster	ItemDetailId	true	true	—	true

51–100 of 288 rows