Explorer · Kyoora Data Lake

SADPL · Shri Arihant Distributors Pvt. Ltd.

Synced just now

tblName	FldName	ixClust	ixUnq	DBName	PKey
tbl_ACCs	UsrDate	true	false	—	false
tbl_ACCs	Id, IdItemNo	false	false	—	false
tbl_ACCs	Dr_LedId	false	false	—	false
tbl_ACCs	Cr_LedId	false	false	—	false
tbl_ACCs	CompanyId, YearId	false	false	—	false
tbl_ACCs_Hdr	V_UsrDate	false	false	—	false
tbl_ACCs_Hdr	V_Id	true	true	—	true
tbl_ACCs_Hdr	Type, V_UsrId, Acc_LedId, BrchId, CompanyId, YearId	false	true	—	false
tbl_ACCs_Hdr	Type, V_Id, V_UsrId	false	false	—	false
tbl_ACCsChallan	UsrDate	false	false	—	false
tbl_ACCsChallan	MyType, MyId, UsrId, MyItemNo	false	false	—	false
tbl_AddLessTax	ALT_Id	true	true	—	true
tbl_BankCash_Adj	LedId_Party	false	false	—	false
tbl_BankCash_Adj	AdjToUsrDate	false	false	—	false
tbl_BankCash_Adj	AdjToId	false	false	—	false
tbl_BankCash_Adj	AdjFromUsrDate	false	false	—	false
tbl_BankCash_Adj	AdjFromId, AdjFromItemNo	false	false	—	false
tbl_Batch_History	ItemDetailId, BatchNo	false	false	—	false
tbl_Batch_History_Previous	ItemDetailId	true	false	—	false
tbl_BatchSel	UsrDate	false	false	—	false
tbl_BatchSel	MyId, MyItemNo, MyType	true	true	—	false
tbl_BatchSel	ItemUsrCode	false	false	—	false
tbl_BatchSel	ItemDetailId	false	false	—	false
tbl_BatchSel	Barcode	false	false	—	false
tbl_BitMaster	BitId	true	true	—	true
tbl_Cash_Dtl	V_Id, ItemNo	false	false	—	false
tbl_Cash_Dtl	UsrId, ItemNo, MyType, LedId_Trading, CompanyId, YearId	false	true	—	false
tbl_Cash_Dtl	UsrDate	true	false	—	false
tbl_Cash_Dtl	MyType, UsrId, CompanyId	false	false	—	false
tbl_Cash_Dtl	MyType, Narr	false	false	—	false
tbl_Cash_Dtl	EditUpdate	false	false	—	false
tbl_Cash_Dtl	CS_LedId	false	false	—	false
tbl_Claim_Dtl	GCNoteUsrDate	false	false	—	false
tbl_CollectedRs	RecdDate	true	false	—	false
tbl_CollectedRs	LedId_SP	false	false	—	false
tbl_Company	CompanyName	false	false	—	false
tbl_Company	CompanyId	true	true	—	true
tbl_DailyDelivery	DDType, DDNo, GrpId_Cost, CompanyId, YearId	false	true	—	false
tbl_DailyDelivery	DDId	true	false	—	true
tbl_DailyDeliveryDtl	SIH_ID, CompanyId, YearId	false	false	—	false
tbl_DailyDeliveryDtl	DDId, DDType, DDItemNo	true	false	—	false
tbl_DailyReturnedSold	DeliveredDate	false	false	—	false
tbl_DailyReturns	SIH_Id, MyItemNo	true	false	—	false
tbl_DailyReturns	ReturnedOn	false	false	—	false
tbl_DayTask	TaskId	true	true	—	true
tbl_Diary	DiaryDate	false	false	—	false
tbl_DisSetUp_Party	LedId_Party, LedId_Mfg	false	false	—	false
tbl_DisSetUp_Party	LedId_Mfg	false	false	—	false
tbl_DisSetUp_Turnover	GrpId_TODis	false	false	—	false
tbl_Emp_Log_Hst	LogIn	false	false	—	false

tblName

FldName

ixClust

ixUnq

DBName

PKey

tbl_ACCs

UsrDate

true

false

—

false

tbl_ACCs

Id, IdItemNo

false

—

false

tbl_ACCs

Dr_LedId

false

—

false

tbl_ACCs

Cr_LedId

false

—

false

tbl_ACCs

CompanyId, YearId

false

—

false

tbl_ACCs_Hdr

V_UsrDate

false

—

false

tbl_ACCs_Hdr

V_Id

true

—

true

tbl_ACCs_Hdr

Type, V_UsrId, Acc_LedId, BrchId, CompanyId, YearId

false

true

—

false

tbl_ACCs_Hdr

Type, V_Id, V_UsrId

false

—

false

tbl_ACCsChallan

UsrDate

false

—

false

tbl_ACCsChallan

MyType, MyId, UsrId, MyItemNo

false

—

false

tbl_AddLessTax

ALT_Id

true

—

true

tbl_BankCash_Adj

LedId_Party

false

—

false

tbl_BankCash_Adj

AdjToUsrDate

false

—

false

tbl_BankCash_Adj

AdjToId

false

—

false

tbl_BankCash_Adj

AdjFromUsrDate

false

—

false

tbl_BankCash_Adj

AdjFromId, AdjFromItemNo

false

—

false

tbl_Batch_History

ItemDetailId, BatchNo

false

—

false

tbl_Batch_History_Previous

ItemDetailId

true

false

—

false

tbl_BatchSel

UsrDate

false

—

false

tbl_BatchSel

MyId, MyItemNo, MyType

true

—

false

tbl_BatchSel

ItemUsrCode

false

—

false

tbl_BatchSel

ItemDetailId

false

—

false

tbl_BatchSel

Barcode

false

—

false

tbl_BitMaster

BitId

true

—

true

tbl_Cash_Dtl

V_Id, ItemNo

false

—

false

tbl_Cash_Dtl

UsrId, ItemNo, MyType, LedId_Trading, CompanyId, YearId

false

true

—

false

tbl_Cash_Dtl

UsrDate

true

false

—

false

tbl_Cash_Dtl

MyType, UsrId, CompanyId

false

—

false

tbl_Cash_Dtl

MyType, Narr

false

—

false

tbl_Cash_Dtl

EditUpdate

false

—

false

tbl_Cash_Dtl

CS_LedId

false

—

false

tbl_Claim_Dtl

GCNoteUsrDate

false

—

false

tbl_CollectedRs

RecdDate

true

false

—

false

tbl_CollectedRs

LedId_SP

false

—

false

tbl_Company

CompanyName

false

—

false

tbl_Company

CompanyId

true

—

true

tbl_DailyDelivery

DDType, DDNo, GrpId_Cost, CompanyId, YearId

false

true

—

false

tbl_DailyDelivery

DDId

true

false

—

true

tbl_DailyDeliveryDtl

SIH_ID, CompanyId, YearId

false

—

false

tbl_DailyDeliveryDtl

DDId, DDType, DDItemNo

true

false

—

false

tbl_DailyReturnedSold

DeliveredDate

false

—

false

tbl_DailyReturns

SIH_Id, MyItemNo

true

false

—

false

tbl_DailyReturns

ReturnedOn

false

—

false

tbl_DayTask

TaskId

true

—

true

tbl_Diary

DiaryDate

false

—

false

tbl_DisSetUp_Party

LedId_Party, LedId_Mfg

false

—

false

tbl_DisSetUp_Party

LedId_Mfg

false

—

false

tbl_DisSetUp_Turnover

GrpId_TODis

false

—

false

tbl_Emp_Log_Hst

false

—

false

tblName	FldName	ixClust	ixUnq	DBName	PKey
tbl_ACCs	UsrDate	true	false	—	false
tbl_ACCs	Id, IdItemNo	false	false	—	false
tbl_ACCs	Dr_LedId	false	false	—	false
tbl_ACCs	Cr_LedId	false	false	—	false
tbl_ACCs	CompanyId, YearId	false	false	—	false
tbl_ACCs_Hdr	V_UsrDate	false	false	—	false
tbl_ACCs_Hdr	V_Id	true	true	—	true
tbl_ACCs_Hdr	Type, V_UsrId, Acc_LedId, BrchId, CompanyId, YearId	false	true	—	false
tbl_ACCs_Hdr	Type, V_Id, V_UsrId	false	false	—	false
tbl_ACCsChallan	UsrDate	false	false	—	false
tbl_ACCsChallan	MyType, MyId, UsrId, MyItemNo	false	false	—	false
tbl_AddLessTax	ALT_Id	true	true	—	true
tbl_BankCash_Adj	LedId_Party	false	false	—	false
tbl_BankCash_Adj	AdjToUsrDate	false	false	—	false
tbl_BankCash_Adj	AdjToId	false	false	—	false
tbl_BankCash_Adj	AdjFromUsrDate	false	false	—	false
tbl_BankCash_Adj	AdjFromId, AdjFromItemNo	false	false	—	false
tbl_Batch_History	ItemDetailId, BatchNo	false	false	—	false
tbl_Batch_History_Previous	ItemDetailId	true	false	—	false
tbl_BatchSel	UsrDate	false	false	—	false
tbl_BatchSel	MyId, MyItemNo, MyType	true	true	—	false
tbl_BatchSel	ItemUsrCode	false	false	—	false
tbl_BatchSel	ItemDetailId	false	false	—	false
tbl_BatchSel	Barcode	false	false	—	false
tbl_BitMaster	BitId	true	true	—	true
tbl_Cash_Dtl	V_Id, ItemNo	false	false	—	false
tbl_Cash_Dtl	UsrId, ItemNo, MyType, LedId_Trading, CompanyId, YearId	false	true	—	false
tbl_Cash_Dtl	UsrDate	true	false	—	false
tbl_Cash_Dtl	MyType, UsrId, CompanyId	false	false	—	false
tbl_Cash_Dtl	MyType, Narr	false	false	—	false
tbl_Cash_Dtl	EditUpdate	false	false	—	false
tbl_Cash_Dtl	CS_LedId	false	false	—	false
tbl_Claim_Dtl	GCNoteUsrDate	false	false	—	false
tbl_CollectedRs	RecdDate	true	false	—	false
tbl_CollectedRs	LedId_SP	false	false	—	false
tbl_Company	CompanyName	false	false	—	false
tbl_Company	CompanyId	true	true	—	true
tbl_DailyDelivery	DDType, DDNo, GrpId_Cost, CompanyId, YearId	false	true	—	false
tbl_DailyDelivery	DDId	true	false	—	true
tbl_DailyDeliveryDtl	SIH_ID, CompanyId, YearId	false	false	—	false
tbl_DailyDeliveryDtl	DDId, DDType, DDItemNo	true	false	—	false
tbl_DailyReturnedSold	DeliveredDate	false	false	—	false
tbl_DailyReturns	SIH_Id, MyItemNo	true	false	—	false
tbl_DailyReturns	ReturnedOn	false	false	—	false
tbl_DayTask	TaskId	true	true	—	true
tbl_Diary	DiaryDate	false	false	—	false
tbl_DisSetUp_Party	LedId_Party, LedId_Mfg	false	false	—	false
tbl_DisSetUp_Party	LedId_Mfg	false	false	—	false
tbl_DisSetUp_Turnover	GrpId_TODis	false	false	—	false
tbl_Emp_Log_Hst	LogIn	false	false	—	false

tblName

FldName

ixClust

ixUnq

DBName

PKey

tbl_ACCs

UsrDate

true

false

—

false

tbl_ACCs

Id, IdItemNo

false

—

false

tbl_ACCs

Dr_LedId

false

—

false

tbl_ACCs

Cr_LedId

false

—

false

tbl_ACCs

CompanyId, YearId

false

—

false

tbl_ACCs_Hdr

V_UsrDate

false

—

false

tbl_ACCs_Hdr

V_Id

true

—

true

tbl_ACCs_Hdr

Type, V_UsrId, Acc_LedId, BrchId, CompanyId, YearId

false

true

—

false

tbl_ACCs_Hdr

Type, V_Id, V_UsrId

false

—

false

tbl_ACCsChallan

UsrDate

false

—

false

tbl_ACCsChallan

MyType, MyId, UsrId, MyItemNo

false

—

false

tbl_AddLessTax

ALT_Id

true

—

true

tbl_BankCash_Adj

LedId_Party

false

—

false

tbl_BankCash_Adj

AdjToUsrDate

false

—

false

tbl_BankCash_Adj

AdjToId

false

—

false

tbl_BankCash_Adj

AdjFromUsrDate

false

—

false

tbl_BankCash_Adj

AdjFromId, AdjFromItemNo

false

—

false

tbl_Batch_History

ItemDetailId, BatchNo

false

—

false

tbl_Batch_History_Previous

ItemDetailId

true

false

—

false

tbl_BatchSel

UsrDate

false

—

false

tbl_BatchSel

MyId, MyItemNo, MyType

true

—

false

tbl_BatchSel

ItemUsrCode

false

—

false

tbl_BatchSel

ItemDetailId

false

—

false

tbl_BatchSel

Barcode

false

—

false

tbl_BitMaster

BitId

true

—

true

tbl_Cash_Dtl

V_Id, ItemNo

false

—

false

tbl_Cash_Dtl

UsrId, ItemNo, MyType, LedId_Trading, CompanyId, YearId

false

true

—

false

tbl_Cash_Dtl

UsrDate

true

false

—

false

tbl_Cash_Dtl

MyType, UsrId, CompanyId

false

—

false

tbl_Cash_Dtl

MyType, Narr

false

—

false

tbl_Cash_Dtl

EditUpdate

false

—

false

tbl_Cash_Dtl

CS_LedId

false

—

false

tbl_Claim_Dtl

GCNoteUsrDate

false

—

false

tbl_CollectedRs

RecdDate

true

false

—

false

tbl_CollectedRs

LedId_SP

false

—

false

tbl_Company

CompanyName

false

—

false

tbl_Company

CompanyId

true

—

true

tbl_DailyDelivery

DDType, DDNo, GrpId_Cost, CompanyId, YearId

false

true

—

false

tbl_DailyDelivery

DDId

true

false

—

true

tbl_DailyDeliveryDtl

SIH_ID, CompanyId, YearId

false

—

false

tbl_DailyDeliveryDtl

DDId, DDType, DDItemNo

true

false

—

false

tbl_DailyReturnedSold

DeliveredDate

false

—

false

tbl_DailyReturns

SIH_Id, MyItemNo

true

false

—

false

tbl_DailyReturns

ReturnedOn

false

—

false

tbl_DayTask

TaskId

true

—

true

tbl_Diary

DiaryDate

false

—

false

tbl_DisSetUp_Party

LedId_Party, LedId_Mfg

false

—

false

tbl_DisSetUp_Party

LedId_Mfg

false

—

false

tbl_DisSetUp_Turnover

GrpId_TODis

false

—

false

tbl_Emp_Log_Hst

false

—

false

dbo.tbl_sw_IndexKeys