Details:Company

TABLE DETAIL REFERENCE: Company

(POS VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
Id	4	INTEGER	4	True	False	False	False	FQID
IsSampleCompany	-7	BIT	1	True	False	False	False	1 0 true false
CompanyName	12	VARCHAR	100	True	False	False	False	%s
AddressStreet	12	VARCHAR	100	True	False	False	False	%s
CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Misc1	12	VARCHAR	100	True	False	False	False	%s
Misc2	12	VARCHAR	100	True	False	False	False	%s
Misc3	12	VARCHAR	100	True	False	False	False	%s
QuickBooksCompanyFile	12	VARCHAR	500	True	False	False	False	%s
StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store01StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
Store01StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store01StoreName	12	VARCHAR	100	True	False	False	False	%s
Store01AddressStreet	12	VARCHAR	100	True	False	False	False	%s
Store01CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Store01Misc1	12	VARCHAR	100	True	False	False	False	%s
Store01Misc2	12	VARCHAR	100	True	False	False	False	%s
Store01Misc3	12	VARCHAR	100	True	False	False	False	%s
Store02StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
Store02StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store02StoreName	12	VARCHAR	100	True	False	False	False	%s
Store02AddressStreet	12	VARCHAR	100	True	False	False	False	%s
Store02CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Store02Misc1	12	VARCHAR	100	True	False	False	False	%s
Store02Misc2	12	VARCHAR	100	True	False	False	False	%s
Store02Misc3	12	VARCHAR	100	True	False	False	False	%s
Store03StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
Store03StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store03StoreName	12	VARCHAR	100	True	False	False	False	%s
Store03AddressStreet	12	VARCHAR	100	True	False	False	False	%s
Store03CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Store03Misc1	12	VARCHAR	100	True	False	False	False	%s
Store03Misc2	12	VARCHAR	100	True	False	False	False	%s
Store03Misc3	12	VARCHAR	100	True	False	False	False	%s
Store04StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
Store04StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store04StoreName	12	VARCHAR	100	True	False	False	False	%s
Store04AddressStreet	12	VARCHAR	100	True	False	False	False	%s
Store04CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Store04Misc1	12	VARCHAR	100	True	False	False	False	%s
Store04Misc2	12	VARCHAR	100	True	False	False	False	%s
Store04Misc3	12	VARCHAR	100	True	False	False	False	%s
Store05StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
Store05StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store05StoreName	12	VARCHAR	100	True	False	False	False	%s
Store05AddressStreet	12	VARCHAR	100	True	False	False	False	%s
Store05CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Store05Misc1	12	VARCHAR	100	True	False	False	False	%s
Store05Misc2	12	VARCHAR	100	True	False	False	False	%s
Store05Misc3	12	VARCHAR	100	True	False	False	False	%s
Store06StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
Store06StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store06StoreName	12	VARCHAR	100	True	False	False	False	%s
Store06AddressStreet	12	VARCHAR	100	True	False	False	False	%s
Store06CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Store06Misc1	12	VARCHAR	100	True	False	False	False	%s
Store06Misc2	12	VARCHAR	100	True	False	False	False	%s
Store06Misc3	12	VARCHAR	100	True	False	False	False	%s
Store07StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
Store07StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store07StoreName	12	VARCHAR	100	True	False	False	False	%s
Store07AddressStreet	12	VARCHAR	100	True	False	False	False	%s
Store07CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Store07Misc1	12	VARCHAR	100	True	False	False	False	%s
Store07Misc2	12	VARCHAR	100	True	False	False	False	%s
Store07Misc3	12	VARCHAR	100	True	False	False	False	%s
Store08StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
Store08StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store08StoreName	12	VARCHAR	100	True	False	False	False	%s
Store08AddressStreet	12	VARCHAR	100	True	False	False	False	%s
Store08CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Store08Misc1	12	VARCHAR	100	True	False	False	False	%s
Store08Misc2	12	VARCHAR	100	True	False	False	False	%s
Store08Misc3	12	VARCHAR	100	True	False	False	False	%s
Store09StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
Store09StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store09StoreName	12	VARCHAR	100	True	False	False	False	%s
Store09AddressStreet	12	VARCHAR	100	True	False	False	False	%s
Store09CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Store09Misc1	12	VARCHAR	100	True	False	False	False	%s
Store09Misc2	12	VARCHAR	100	True	False	False	False	%s
Store09Misc3	12	VARCHAR	100	True	False	False	False	%s
Store10StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
Store10StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store10StoreName	12	VARCHAR	100	True	False	False	False	%s
Store10AddressStreet	12	VARCHAR	100	True	False	False	False	%s
Store10CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Store10Misc1	12	VARCHAR	100	True	False	False	False	%s
Store10Misc2	12	VARCHAR	100	True	False	False	False	%s
Store10Misc3	12	VARCHAR	100	True	False	False	False	%s
PriceLevel1Name	12	VARCHAR	100	True	False	False	False	%s
PriceLevel1Markdown	3	DECIMAL	15	True	False	False	False	%7.5f
PriceLevel2Name	12	VARCHAR	100	True	False	False	False	%s
PriceLevel2Markdown	3	DECIMAL	15	True	False	False	False	%7.5f
PriceLevel3Name	12	VARCHAR	100	True	False	False	False	%s
PriceLevel3Markdown	3	DECIMAL	15	True	False	False	False	%7.5f
PriceLevel4Name4	12	VARCHAR	100	True	False	False	False	%s
PriceLevel4Markdown	3	DECIMAL	15	True	False	False	False	%7.5f
PurchaseOrderStatusInfoStatusType	12	VARCHAR	6	True	False	False	False	Open Closed Custom
PurchaseOrderStatusInfoStatusDescription	12	VARCHAR	100	True	False	False	False	%s
LayawayStatusInfoStatusType	12	VARCHAR	6	True	False	False	False	Open Closed Custom
LayawayStatusInfoStatusDescription	12	VARCHAR	100	True	False	False	False	%s
SalesOrderStatusInfoStatusType	12	VARCHAR	6	True	False	False	False	Open Closed Custom
SalesOrderStatusInfoStatusDescription	12	VARCHAR	100	True	False	False	False	%s
WorkOrderStatusInfoStatusType	12	VARCHAR	6	True	False	False	False	Open Closed Custom
WorkOrderStatusInfoStatusDescription	12	VARCHAR	100	True	False	False	False	%s

QODBC.com Tools for QuickBooks