IV50200 - Stock Count Assignment Temp | Prospr

IV50200 - Stock Count Assignment Temp

Select * from IV50200

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
INCLUDEITEM	Include Item	Boolean	2	View
ITEMNMBR	Item Number	String	32	View
LOCNCODE	Location Code	String	12	View
BINNMBR	Bin Number	String	22	View
ITMCLSCD	Item Class Code	String	12	View
ABCCODE	ABC Code 1 – (None) 2 – A 3 – B 4 – C	Integer	2	View
ITMGEDSC	Item Generic Description	String	12	View
ITEMDESC	Item Description	String	102	View
LSTCNTDT	Last Count Date	Date	4	View
STCKCNTINTRVL	Stock Count Interval	Integer	2	View
NXTCNTDT	Next Count Date	Date	4	View
NXTCNTTM	Next Count Time	Time	4	View
UPDATED	Updated	Boolean	2	View
ITEMTYPE	Item Type 1. Sales Inventory (For SBM, this type is Stock Item.) 2. Discontinued 3. Kit 4. Misc Charges 5. Services 6. Flat Fee (For SBM, this type is Labor.)	Integer	2	View
USERID	User ID	String	16	View
IntegerValue	IntegerValue	Integer	2	View