Inventory Counting Draft - Rows

Table Name: ICD1

Table Description: Inventory Counting Draft - Rows

Field	Description	Type	Size	Related	Default Value	Constraints
DocEntry	Internal Number	Int	11	OICD
LineNum	Row Number	Int	11	-
ItemCode	Item Code	nVarChar	50	OITM
ItemDesc	Item Description	nVarChar	200	-
Freeze	Item Freeze Status	VarChar	1	-	N	Y	Yes
						N	No
WhsCode	Warehouse Code	nVarChar	8	OWHS
InWhsQty	In-Whse Qty on Count Date	Num	19.6	-
Counted	Counted	VarChar	1	-	N	Y	Yes
						N	No
CountQty	Counted Quantity	Num	19.6	-
CountQtyT1	Counter 1 - Counted Quantity	Num	19.6	-
CountQtyT2	-	Num	19.6	-
Remark	Remarks	nVarChar	254	-
BarCode	Bar Code	nVarChar	254	-
InvUoM	Inventory UoM	VarChar	1	-	Y	Y	Yes
						N	No
Difference	Difference	Num	19.6	-
DiffPercen	Difference %	Num	19.6	-
CountDate	Count Date	Date	8	-
CountTime	Count Time	Int	11	-
TargetRef	Target Document Reference	nVarChar	16	-
TargetType	Target Document Type	Int	11	-	-1	-1
						0
						10000071	Inventory Posting
TargetEntr	Target Document Internal ID	Int	11	-
TargetLine	Target Document Row	Int	11	-
ProjCode	Project Code	nVarChar	20	OPRJ
OcrCode	Distribution Rule Code	nVarChar	8	OOCR
LineStatus	Row Status	VarChar	1	-	O	O	Open
						C	Closed
BinEntry	Bin Location Entry	Int	11	OBIN
VisOrder	Visual Order	Int	11	-
OcrCode2	Distribution Rule 2	nVarChar	8	OOCR
OcrCode3	Distribution Rule 3	nVarChar	8	OOCR
OcrCode4	Distribution Rule 4	nVarChar	8	OOCR
OcrCode5	Distribution Rule 5	nVarChar	8	OOCR
FirmCode	Manufacturer	Int	6	OMRC
SuppCatNum	Mfr Catalog No.	nVarChar	50	-
PrefVendor	Preferred Vendor	nVarChar	15	OCRD
LogIns	Log Instance - History	Int	11	-
UgpEntry	UoM Group Entry	Int	11	OUGP
IUomEntry	Inventory UoM Entry	nVarChar	20	OUOM
CountDiff	Counters' Diff.	Num	19.6	-
CountDiffP	Counters' Diff. (%)	Num	19.6	-
UomCode	UoM Code for DI	nVarChar	20	-
UomQty	UoM Counted Qty for DI	Num	19.6	-
PPTaxExRe	Plastic Packaging Tax Exemption Reason	nVarChar	2	-
PlPaWght	Plastic Packaging Weight	Num	19.6	-

Key	Unique	Field
PRIMARY	Yes	DocEntry
		LineNum