SADPL · Shri Arihant Distributors Pvt. Ltd.

dbo.tbl_sw_Settings

743 rows · 14 columns

ready

Export CSV

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

All tables

dbo.tbl_sw_Settings

743 rows · 14 columns

ready

Export CSV

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

FldId	FldNme	FldYN	FldYN_Def	ValueEditable	FldValue	FldValue_Def	FldValDataType	RowHeight	UseIn	FldDesc	FldHelp
4211	ProdKeepCond_3	true	true	true	30	30	N	300	PRODUCT	KWS 3 For X Order In Last 60 Days	—
4212	ProdKeepCond_Ord_1	true	true	true	7	7	N	300	PRODUCT	If KWS 1 Than X Days Extra Order	—
4213	ProdKeepCond_Ord_2	true	true	true	5	5	N	300	PRODUCT	If KWS 2 Than X Days Extra Order	—
4214	ProdKeepCond_Ord_3	true	true	true	3	3	N	300	PRODUCT	If KWS 3 Than X Days Extra Order	—
4251	SetPwdExp	true	true	true	″	medica	T	300	EXPORT DATA	Set Password For Excel/Access Report Export	—
4301	AllowPrinterChange	true	true	false	″	—	—	300	PRINTER	Allow To Change Printer In Sales Invoice / Sales Challan / S…	—
4351	PDCSelectionOrder	true	true	true	1	5	N	300	PDC	In Slip Book Select Pdc As Below Order	—
4352	PDCSelectionOrderValue	true	false	false	″	″	″	300	VALUE	1. ChqDate + As Entered 2. ChqDate + ChqAmt 3. ChqDate + C…	—
4354	AllowPdcAnyDays	true	false	true	1,9,37,44, 47,48,55,60,61,59,2,56,62,28	1	T	300	PDC	Allow To Enter PDC Up To Any Day (To Selected User)	—
4401	StateSIValueOn	true	true	true	2	1	N	300	STK ST	Show Default Value Method For Sale Value	—
4402	StateSIValueOnSub	true	false	false	″	″	″	300	VALUE	1. Rate 2. Gross 3. Net 4.Taxable	—
4403	StateSIRateType	true	true	true	7	1	N	300	STK ST	Show Default RateType For Sales Value	—
4404	StateSIRateTypeSub	true	false	false	″	″	″	300	VALUE	1. CP 2. TCP 3. PTR 4. TPTR 5. NPR 6. TNPR 7. PTS 8. …	—
4405	StatePIValueOn	true	true	true	2	1	N	300	STK ST	Show Default Value Method For Purchase Value (If Rate RateTy…	—
4406	StatePIValueOnSub	true	false	false	″	″	″	300	VALUE	1. NRV 2. Gross 3. Net 4. Taxable	—
4407	StateCLRateType	true	true	true	1	1	N	300	STK ST	Show Default RateType For Stock Value	—
4408	StateCLRateTypeSub	true	false	false	″	″	″	300	VALUE	1. CP 2. TCP 3. PTR 4. TPTR 5. NPR 6. TNPR 7. PTS 8. …	—
4409	StockStatAll	false	false	false	″	—	—	300	STK ST	Show All Product In Stock Statement	—
4410	StockStatPI	false	true	true	″	—	—	300	STK ST	Stock Statement In Footer Print Purchase Invoice Detail	—
4411	StockStatDN	true	true	true	″	—	—	300	STK ST	Stock Statement In Footer Print Debit Note Detail	—
4412	StockStatOS	true	true	true	″	—	—	300	STK ST	Stock Statement In Footer Print Outstanding Sales Invoice Th…	—
4441	StkRecoFill	true	true	true	1	″	N	300	STK RECO	Fill & Print Order 1) PMfgr + PName 2) DMfgr + PName 3) Lo…	—
4501	ShowAllProductInPO	false	false	false	″	″	—	300	PORD	Show Product With 0 Order Qty	—
4502	ShowSuppProduct	false	true	true	″	″	—	300	PORD	If Only Supplier Selected Then Show Only Supplied Product by…	—
4503	POSaveWithoutQty	false	false	false	″	″	—	300	PORD	If Order Qty Is Zero Then Also Save Item In Order	—
4504	DonotShowAllPO	false	true	true	″	″	—	300	PORD	Don't Show In Purchase Order If In Last Three Month No Sales…	—
4505	PrintPOInSaving	false	false	false	″	—	—	300	PORD	In Saving Print Purchase Order	—
4506	PrintConfirmPO	false	false	false	″	″	—	300	PORD	In New Purchase Order Saving Show Printing Confirmation Scre…	—
4507	PrintConfirmPOEdit	false	false	false	″	—	—	300	PORD	In Edit Purchase Order Saving Show Printing Confirmation Scr…	—
4508	POOnSale	true	true	true	3	1	N	300	PORD	POrd On 1) Retail Sale 2) Retail + Wholesale Sale 3) All S…	—
4510	POShortStockBook	true	true	true	″	″	—	300	PORD	Show Short Order Book With Current Stock Detail	—
4511	POrdTrackDay	true	true	true	7	7	N	300	PORD	Track Last X Days Order	—
4512	POrdAutoScheme	true	true	false	″	—	—	300	PORD	Auto Process Scheme Qty	—
4513	POPIShow	true	true	true	3	10	N	300	PORD	Show No. of Purchase Invoice History	—
4514	POFreezeOld	true	true	false	″	″	—	300	PORD	Once New Order Generated Freeze All Pending Order Of that It…	—
4515	AllProductInPO	false	false	false	″	″	—	300	PORD	Show All Product	—
4516	AddLSQPer	true	true	true	25	50	N	300	PORD	Add Loss of Sale Qty In Purchase Order	—
4517	PoFillOrder	true	true	true	″	2	N	300	PORD	Purchase Order Fill Order	—
4518	PoFillOrderId	true	false	false	″	″	″	300	VALUE	1. Product Code 2. Product Name 3. DMfgr + PName 4. PMfgr + …	—
4519	PODays	true	true	true	15	15	N	300	PORD	In Purchase Order Days Order on X Days	—
4520	FreezePOrder	false	true	true	″	45	N	300	PORD	Freeze Purchase Order If Older Than X Days	—
4521	PODaysUser	true	true	true	1,2,28	1	T	300	PORD	Allow to Change Purchase Order X Days (to Selected User)	—
4522	POAddOrd	true	true	true	″	25	N	300	PORD	Set quantity tolerance limit to X%	—
4523	POAddOrdUser	true	true	true	1	1	T	300	PORD	Allow up to tolerance limit orders to (selected user)	—
4524	POAddOrdUserMax	true	true	true	1,2	1	T	300	PORD	Allow above tolerance limit orders to (selected user)	—
4551	SalesOrderFormat	true	true	true	1	1	N	300	SORD	Default Sales Order Import Format	—
4552	SalesOrderFormatValue	true	true	false	″	″	N	300	VALUE	1) Medica 2) Anand 3) Wellness 4) Export	—
4553	MRPCompuIsoryInSO	false	true	false	″	—	—	300	SORD	Sale Order MRP Is Compulsory	—
4554	ImportOrderTakeSameOrderNo	true	true	false	″	—	—	300	SORD	Sale Order Import Take Order No From Import File	—
4555	SOTOLossofsale	false	false	false	″	—	—	300	SORD	Once Order is Converted To Sales Invoice Add Balance Item To…	—

451–500 of 743 rows

FldId	FldNme	FldYN	FldYN_Def	ValueEditable	FldValue	FldValue_Def	FldValDataType	RowHeight	UseIn	FldDesc	FldHelp
4211	ProdKeepCond_3	true	true	true	30	30	N	300	PRODUCT	KWS 3 For X Order In Last 60 Days	—
4212	ProdKeepCond_Ord_1	true	true	true	7	7	N	300	PRODUCT	If KWS 1 Than X Days Extra Order	—
4213	ProdKeepCond_Ord_2	true	true	true	5	5	N	300	PRODUCT	If KWS 2 Than X Days Extra Order	—
4214	ProdKeepCond_Ord_3	true	true	true	3	3	N	300	PRODUCT	If KWS 3 Than X Days Extra Order	—
4251	SetPwdExp	true	true	true	″	medica	T	300	EXPORT DATA	Set Password For Excel/Access Report Export	—
4301	AllowPrinterChange	true	true	false	″	—	—	300	PRINTER	Allow To Change Printer In Sales Invoice / Sales Challan / S…	—
4351	PDCSelectionOrder	true	true	true	1	5	N	300	PDC	In Slip Book Select Pdc As Below Order	—
4352	PDCSelectionOrderValue	true	false	false	″	″	″	300	VALUE	1. ChqDate + As Entered 2. ChqDate + ChqAmt 3. ChqDate + C…	—
4354	AllowPdcAnyDays	true	false	true	1,9,37,44, 47,48,55,60,61,59,2,56,62,28	1	T	300	PDC	Allow To Enter PDC Up To Any Day (To Selected User)	—
4401	StateSIValueOn	true	true	true	2	1	N	300	STK ST	Show Default Value Method For Sale Value	—
4402	StateSIValueOnSub	true	false	false	″	″	″	300	VALUE	1. Rate 2. Gross 3. Net 4.Taxable	—
4403	StateSIRateType	true	true	true	7	1	N	300	STK ST	Show Default RateType For Sales Value	—
4404	StateSIRateTypeSub	true	false	false	″	″	″	300	VALUE	1. CP 2. TCP 3. PTR 4. TPTR 5. NPR 6. TNPR 7. PTS 8. …	—
4405	StatePIValueOn	true	true	true	2	1	N	300	STK ST	Show Default Value Method For Purchase Value (If Rate RateTy…	—
4406	StatePIValueOnSub	true	false	false	″	″	″	300	VALUE	1. NRV 2. Gross 3. Net 4. Taxable	—
4407	StateCLRateType	true	true	true	1	1	N	300	STK ST	Show Default RateType For Stock Value	—
4408	StateCLRateTypeSub	true	false	false	″	″	″	300	VALUE	1. CP 2. TCP 3. PTR 4. TPTR 5. NPR 6. TNPR 7. PTS 8. …	—
4409	StockStatAll	false	false	false	″	—	—	300	STK ST	Show All Product In Stock Statement	—
4410	StockStatPI	false	true	true	″	—	—	300	STK ST	Stock Statement In Footer Print Purchase Invoice Detail	—
4411	StockStatDN	true	true	true	″	—	—	300	STK ST	Stock Statement In Footer Print Debit Note Detail	—
4412	StockStatOS	true	true	true	″	—	—	300	STK ST	Stock Statement In Footer Print Outstanding Sales Invoice Th…	—
4441	StkRecoFill	true	true	true	1	″	N	300	STK RECO	Fill & Print Order 1) PMfgr + PName 2) DMfgr + PName 3) Lo…	—
4501	ShowAllProductInPO	false	false	false	″	″	—	300	PORD	Show Product With 0 Order Qty	—
4502	ShowSuppProduct	false	true	true	″	″	—	300	PORD	If Only Supplier Selected Then Show Only Supplied Product by…	—
4503	POSaveWithoutQty	false	false	false	″	″	—	300	PORD	If Order Qty Is Zero Then Also Save Item In Order	—
4504	DonotShowAllPO	false	true	true	″	″	—	300	PORD	Don't Show In Purchase Order If In Last Three Month No Sales…	—
4505	PrintPOInSaving	false	false	false	″	—	—	300	PORD	In Saving Print Purchase Order	—
4506	PrintConfirmPO	false	false	false	″	″	—	300	PORD	In New Purchase Order Saving Show Printing Confirmation Scre…	—
4507	PrintConfirmPOEdit	false	false	false	″	—	—	300	PORD	In Edit Purchase Order Saving Show Printing Confirmation Scr…	—
4508	POOnSale	true	true	true	3	1	N	300	PORD	POrd On 1) Retail Sale 2) Retail + Wholesale Sale 3) All S…	—
4510	POShortStockBook	true	true	true	″	″	—	300	PORD	Show Short Order Book With Current Stock Detail	—
4511	POrdTrackDay	true	true	true	7	7	N	300	PORD	Track Last X Days Order	—
4512	POrdAutoScheme	true	true	false	″	—	—	300	PORD	Auto Process Scheme Qty	—
4513	POPIShow	true	true	true	3	10	N	300	PORD	Show No. of Purchase Invoice History	—
4514	POFreezeOld	true	true	false	″	″	—	300	PORD	Once New Order Generated Freeze All Pending Order Of that It…	—
4515	AllProductInPO	false	false	false	″	″	—	300	PORD	Show All Product	—
4516	AddLSQPer	true	true	true	25	50	N	300	PORD	Add Loss of Sale Qty In Purchase Order	—
4517	PoFillOrder	true	true	true	″	2	N	300	PORD	Purchase Order Fill Order	—
4518	PoFillOrderId	true	false	false	″	″	″	300	VALUE	1. Product Code 2. Product Name 3. DMfgr + PName 4. PMfgr + …	—
4519	PODays	true	true	true	15	15	N	300	PORD	In Purchase Order Days Order on X Days	—
4520	FreezePOrder	false	true	true	″	45	N	300	PORD	Freeze Purchase Order If Older Than X Days	—
4521	PODaysUser	true	true	true	1,2,28	1	T	300	PORD	Allow to Change Purchase Order X Days (to Selected User)	—
4522	POAddOrd	true	true	true	″	25	N	300	PORD	Set quantity tolerance limit to X%	—
4523	POAddOrdUser	true	true	true	1	1	T	300	PORD	Allow up to tolerance limit orders to (selected user)	—
4524	POAddOrdUserMax	true	true	true	1,2	1	T	300	PORD	Allow above tolerance limit orders to (selected user)	—
4551	SalesOrderFormat	true	true	true	1	1	N	300	SORD	Default Sales Order Import Format	—
4552	SalesOrderFormatValue	true	true	false	″	″	N	300	VALUE	1) Medica 2) Anand 3) Wellness 4) Export	—
4553	MRPCompuIsoryInSO	false	true	false	″	—	—	300	SORD	Sale Order MRP Is Compulsory	—
4554	ImportOrderTakeSameOrderNo	true	true	false	″	—	—	300	SORD	Sale Order Import Take Order No From Import File	—
4555	SOTOLossofsale	false	false	false	″	—	—	300	SORD	Once Order is Converted To Sales Invoice Add Balance Item To…	—

451–500 of 743 rows