dbo.tbl_sw_GridSettings

38,916 rows · 31 columns

ready

Read-only. Up to 100 rows a page, 5,000 in an export. 1 sensitive or binary columns are hidden.

GridId	IsHiddenP	ColOrder	ColFields	ColHeading	ColEditable	ColSize	IsHidden	ColDataType	ColDataFormat	ColMaxLength	NegAllow
aaAIA	false	76	Loct_Per	LBT/LOC%	true	900	true	P	0.00	0	false
aaAIA	false	77	LOCAmt	LBT/LOC Amt	true	1005	true	N	0.00	0	false
aaAIA	true	78	PendingQty	PendQty	true	615	true	N	0	0	false
aaAIA	true	79	BatchQty	Batch Qty	false	615	true	N	0	25	false
aaAIA	false	80	MMfgDate	MfgDate	false	1050	true	D	mm/yyyy	0	false
aaAIA	false	81	EExpDate	ExpDate	false	1020	true	D	mm/yyyy	0	false
aaAIA	false	82	CP	CP	false	900	true	N	0.00	0	false
aaAIA	false	83	PTR	PTR	false	1365	false	N	0.00	0	false
aaAIA	false	84	WIP	PTS	false	1275	true	N	0.00	0	false
aaAIA	false	85	MRP	MRP	false	1260	false	N	0.00	0	false
aaAIA	false	86	VNSR	TNSR	false	900	true	N	0.00	0	false
aaAIA	false	87	GP_Amt	GPAmt	false	1755	true	N	0.00	0	false
aaAIA	false	88	GP_Amt_Per	GP (Rs)	false	1335	true	N	0.00	0	false
aaAIA	false	89	GP_Per	GP%	false	1155	false	N	0.00	0	false
aaAIA	false	90	RMPer	RM (Rs)	false	900	false	N	0.00	0	false
aaAIA	false	91	RMSPer	RM%	false	900	false	N	0.00	0	false
aaAIA	false	92	OrderNo	OrderNo	true	2100	true	T	P	2000	false
aaAIA	false	93	Remark	Remark	true	2865	false	T	P	2000	false
aaAIA	false	94	Reason	Reason	true	960	true	L	″	0	false
aaAIA	true	95	DRet_Reason	Ret Reason	true	900	true	L	″	0	false
aaAIA	false	96	ClaimQty	Claim Qty	true	1080	true	N	0	0	false
aaAIA	false	97	Claim_Per	Claim Per	true	1095	true	N	0.00	0	false
aaAIA	false	98	ClaimPer	Claim%	true	1005	true	P	0.00	0	false
aaAIA	false	99	ClaimAmt	ClaimAmt	true	1095	true	N	0.00	0	false
aaAIA	false	100	ClaimNoteNo	Claim No	true	1785	true	N	0	0	false
aaAIA	false	101	ClaimDesc	Claim Description	true	2070	true	T	P	0	false
aaAIA	true	102	ETrack	ETrack	true	900	false	T	U	50	false
aaAIA	true	103	EShip	EShip	true	900	false	L	″	50	false
aaAIA	false	104	EOrdNo	EOrdNo	true	900	false	T	U	50	false
aaAIA	true	105	EInvRef	EInvRef	true	900	false	T	U	0	false
aaAIA	false	106	EProduct	EProduct	true	900	false	L	″	100	false
aaAIA	true	107	EMRP	EMRP	true	900	false	N	0.00	0	false
aaAIA	true	108	ECMeds	ECMeds	true	900	false	L	″	50	false
aaAIA	true	109	EDose	EDose	true	900	false	T	U	100	false
aaAIA	true	110	EDoctor	EDoctor	true	900	false	L	″	50	false
aaAIA	true	111	EPUrl	EPUrl	true	900	false	T	L	100	false
aaAIA	true	112	ECust	ECust	true	900	false	L	″	100	false
aaAIA	true	113	EAdd	EAdd	true	900	false	T	U	150	false
aaAIA	true	114	ECity	ECity	true	900	false	L	″	50	false
aaAIA	true	115	EState	EState	true	900	false	L	″	50	false
aaAIA	true	116	ECntry	ECntry	true	900	false	L	″	50	false
aaAIA	true	117	EZip	EZip	true	900	false	T	U	20	false
aaAIA	true	118	ETele	ETele	true	900	false	T	U	0	false
aaAIA	true	119	EMobile	EMobile	true	900	false	T	U	0	false
aaAIA	true	120	EEmail	EEmail	true	900	false	T	L	0	false
aaAIA	false	121	Constituents	Constituents	false	1815	true	T	″	0	false
aaAIA	false	122	ShowItem	ShowProduct	true	3765	true	T	U	0	false
aaAIA	false	123	ShowPack	ShowPack	true	1320	true	T	U	0	false
aaAIA	false	124	ShowBatch	ShowBatch	true	1275	true	L	U	0	false
aaAIA	false	125	ShowExp	ShowExp	true	1200	false	D	MM/YYYY	0	false

401–450 of 10,000+ rows

GridId	IsHiddenP	ColOrder	ColFields	ColHeading	ColEditable	ColSize	IsHidden	ColDataType	ColDataFormat	ColMaxLength	NegAllow
aaAIA	false	76	Loct_Per	LBT/LOC%	true	900	true	P	0.00	0	false
aaAIA	false	77	LOCAmt	LBT/LOC Amt	true	1005	true	N	0.00	0	false
aaAIA	true	78	PendingQty	PendQty	true	615	true	N	0	0	false
aaAIA	true	79	BatchQty	Batch Qty	false	615	true	N	0	25	false
aaAIA	false	80	MMfgDate	MfgDate	false	1050	true	D	mm/yyyy	0	false
aaAIA	false	81	EExpDate	ExpDate	false	1020	true	D	mm/yyyy	0	false
aaAIA	false	82	CP	CP	false	900	true	N	0.00	0	false
aaAIA	false	83	PTR	PTR	false	1365	false	N	0.00	0	false
aaAIA	false	84	WIP	PTS	false	1275	true	N	0.00	0	false
aaAIA	false	85	MRP	MRP	false	1260	false	N	0.00	0	false
aaAIA	false	86	VNSR	TNSR	false	900	true	N	0.00	0	false
aaAIA	false	87	GP_Amt	GPAmt	false	1755	true	N	0.00	0	false
aaAIA	false	88	GP_Amt_Per	GP (Rs)	false	1335	true	N	0.00	0	false
aaAIA	false	89	GP_Per	GP%	false	1155	false	N	0.00	0	false
aaAIA	false	90	RMPer	RM (Rs)	false	900	false	N	0.00	0	false
aaAIA	false	91	RMSPer	RM%	false	900	false	N	0.00	0	false
aaAIA	false	92	OrderNo	OrderNo	true	2100	true	T	P	2000	false
aaAIA	false	93	Remark	Remark	true	2865	false	T	P	2000	false
aaAIA	false	94	Reason	Reason	true	960	true	L	″	0	false
aaAIA	true	95	DRet_Reason	Ret Reason	true	900	true	L	″	0	false
aaAIA	false	96	ClaimQty	Claim Qty	true	1080	true	N	0	0	false
aaAIA	false	97	Claim_Per	Claim Per	true	1095	true	N	0.00	0	false
aaAIA	false	98	ClaimPer	Claim%	true	1005	true	P	0.00	0	false
aaAIA	false	99	ClaimAmt	ClaimAmt	true	1095	true	N	0.00	0	false
aaAIA	false	100	ClaimNoteNo	Claim No	true	1785	true	N	0	0	false
aaAIA	false	101	ClaimDesc	Claim Description	true	2070	true	T	P	0	false
aaAIA	true	102	ETrack	ETrack	true	900	false	T	U	50	false
aaAIA	true	103	EShip	EShip	true	900	false	L	″	50	false
aaAIA	false	104	EOrdNo	EOrdNo	true	900	false	T	U	50	false
aaAIA	true	105	EInvRef	EInvRef	true	900	false	T	U	0	false
aaAIA	false	106	EProduct	EProduct	true	900	false	L	″	100	false
aaAIA	true	107	EMRP	EMRP	true	900	false	N	0.00	0	false
aaAIA	true	108	ECMeds	ECMeds	true	900	false	L	″	50	false
aaAIA	true	109	EDose	EDose	true	900	false	T	U	100	false
aaAIA	true	110	EDoctor	EDoctor	true	900	false	L	″	50	false
aaAIA	true	111	EPUrl	EPUrl	true	900	false	T	L	100	false
aaAIA	true	112	ECust	ECust	true	900	false	L	″	100	false
aaAIA	true	113	EAdd	EAdd	true	900	false	T	U	150	false
aaAIA	true	114	ECity	ECity	true	900	false	L	″	50	false
aaAIA	true	115	EState	EState	true	900	false	L	″	50	false
aaAIA	true	116	ECntry	ECntry	true	900	false	L	″	50	false
aaAIA	true	117	EZip	EZip	true	900	false	T	U	20	false
aaAIA	true	118	ETele	ETele	true	900	false	T	U	0	false
aaAIA	true	119	EMobile	EMobile	true	900	false	T	U	0	false
aaAIA	true	120	EEmail	EEmail	true	900	false	T	L	0	false
aaAIA	false	121	Constituents	Constituents	false	1815	true	T	″	0	false
aaAIA	false	122	ShowItem	ShowProduct	true	3765	true	T	U	0	false
aaAIA	false	123	ShowPack	ShowPack	true	1320	true	T	U	0	false
aaAIA	false	124	ShowBatch	ShowBatch	true	1275	true	L	U	0	false
aaAIA	false	125	ShowExp	ShowExp	true	1200	false	D	MM/YYYY	0	false

401–450 of 10,000+ rows