IV40700 - Site Setup | Prospr - Dynamics GP Table Reference

IV40700 - Site Setup

Query Builder

Select * from IV40700

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
LOCNCODE	Location Code	String	12	View
LOCNDSCR	Location Description	String	32	View
NOTEINDX	Note Index	Currency	10	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
ADDRESS3	Address 3	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIPCODE	Zip Code	String	12	View
COUNTRY	Country	String	62	View
PHONE1	Phone 1	String	22	View
PHONE2	Phone 2	String	22	View
PHONE3	Phone 3	String	22	View
FAXNUMBR	Fax Number	String	22	View
Location_Segment	Location Segment	String	68	View
STAXSCHD	Sales Tax Schedule	String	16	View
PCTAXSCH	Purchases Tax Schedule	String	16	View
INCLDDINPLNNNG	Included in Planning	Boolean	2	View
PORECEIPTBIN	Purchase Receipt Bin	String	16	View
PORETRNBIN	Purchase Returns Bin	String	16	View
SOFULFILLMENTBIN	SO Fulfillment Bin	String	16	View
SORETURNBIN	SO Return Bin	String	16	View
BOMRCPTBIN	BOM Receipt Bin	String	16	View
MATERIALISSUEBIN	Material Issues Bin	String	16	View
MORECEIPTBIN	MO Receipt Bin	String	16	View
REPAIRISSUESBIN	Repair Issues Bin	String	16	View
WMSINT	WMS Integration	Boolean	2	View
PICKTICKETSITEOPT	Picking Ticket Site Option	Integer	2	View
BINBREAK	Bin Break	Integer	2	View
CCode	Country Code	String	8	View
DECLID	Declarant ID	String	16	View
INACTIVE	Inactive	Boolean	2	View