Z:\\Dropbox\\git\\FishbowlDataDictionary\\data\\FishbowlDB_Latest.FDB contains 1740 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
ACCOUNT	ID	integer	10
ACCOUNT	TYPEID	integer	10	√		null
ACCOUNTGROUP	ID	integer	10
ACCOUNTGROUP	NAME	varchar	30
ACCOUNTGROUPRELATION	ACCOUNTID	integer	10	√		null
ACCOUNTGROUPRELATION	GROUPID	integer	10	√		null
ACCOUNTGROUPRELATION	ID	integer	10
ACCOUNTTYPE	ID	integer	10
ACCOUNTTYPE	NAME	varchar	15
ADDRESS	ACCOUNTID	integer	10
ADDRESS	ADDRESS	varchar	90	√		null
ADDRESS	ADDRESSNAME	varchar	90	√		null
ADDRESS	CITY	varchar	30	√		null
ADDRESS	COUNTRYID	integer	10	√		null
ADDRESS	DEFAULTFLAG	smallint	5	√		0
ADDRESS	ID	integer	10
ADDRESS	LOCATIONGROUPID	integer	10	√		NULL
ADDRESS	NAME	varchar	60
ADDRESS	PIPELINECONTACTNUM	integer	10	√		NULL
ADDRESS	RESIDENTIALFLAG	smallint	5	√		0
ADDRESS	STATEID	integer	10	√		null
ADDRESS	TYPEID	integer	10
ADDRESS	ZIP	varchar	10	√		null
ADDRESSMULTILINEPOVIEW	POID	integer	10	√		null
ADDRESSMULTILINEPOVIEW	REMITADDRESS1	varchar	90	√		null
ADDRESSMULTILINEPOVIEW	REMITADDRESS2	varchar	90	√		null
ADDRESSMULTILINEPOVIEW	REMITADDRESS3	varchar	90	√		null
ADDRESSMULTILINEPOVIEW	SHIPTOADDRESS1	varchar	90	√		null
ADDRESSMULTILINEPOVIEW	SHIPTOADDRESS2	varchar	90	√		null
ADDRESSMULTILINEPOVIEW	SHIPTOADDRESS3	varchar	90	√		null
ADDRESSMULTILINESOVIEW	SHIPTOADDRESS1	varchar	90	√		null
ADDRESSMULTILINESOVIEW	SHIPTOADDRESS2	varchar	90	√		null
ADDRESSMULTILINESOVIEW	SHIPTOADDRESS3	varchar	90	√		null
ADDRESSMULTILINESOVIEW	SOID	integer	10	√		null
ADDRESSMULTILINEVIEW	ACCOUNTID	integer	10	√		null
ADDRESSMULTILINEVIEW	ADDRESS1	varchar	90	√		null
ADDRESSMULTILINEVIEW	ADDRESS2	varchar	90	√		null
ADDRESSMULTILINEVIEW	ADDRESS3	varchar	90	√		null
ADDRESSMULTILINEVIEW	CITY	varchar	30	√		null
ADDRESSMULTILINEVIEW	COUNTRYID	integer	10	√		null
ADDRESSMULTILINEVIEW	DEFAULTFLAG	smallint	5	√		null
ADDRESSMULTILINEVIEW	ID	integer	10	√		null
ADDRESSMULTILINEVIEW	NAME	varchar	60	√		null
ADDRESSMULTILINEVIEW	RESIDENTIALFLAG	smallint	5	√		null
ADDRESSMULTILINEVIEW	STATEID	integer	10	√		null
ADDRESSMULTILINEVIEW	TYPEID	integer	10	√		null
ADDRESSMULTILINEVIEW	ZIP	varchar	10	√		null
ADDRESSMULTILINEXOVIEW	FROMADDRESS1	varchar	90	√		null
ADDRESSMULTILINEXOVIEW	FROMADDRESS2	varchar	90	√		null
ADDRESSMULTILINEXOVIEW	FROMADDRESS3	varchar	90	√		null
ADDRESSMULTILINEXOVIEW	SHIPTOADDRESS1	varchar	90	√		null
ADDRESSMULTILINEXOVIEW	SHIPTOADDRESS2	varchar	90	√		null
ADDRESSMULTILINEXOVIEW	SHIPTOADDRESS3	varchar	90	√		null
ADDRESSMULTILINEXOVIEW	XOID	integer	10	√		null
ADDRESSTYPE	ID	integer	10
ADDRESSTYPE	NAME	varchar	15
ASACCOUNT	ACCOUNTINGHASH	varchar	30	√		null
ASACCOUNT	ACCOUNTINGID	varchar	36	√		null
ASACCOUNT	ACCOUNTNUMBER	varchar	36	√		NULL
ASACCOUNT	ACTIVEFLAG	smallint	5	√		1
ASACCOUNT	DATECREATED	timestamp	19	√		null
ASACCOUNT	DATELASTMODIFIED	timestamp	19	√		null
ASACCOUNT	ID	integer	10
ASACCOUNT	NAME	varchar	155
ASACCOUNT	TYPEID	integer	10	√		null
ASACCOUNTTYPE	ID	integer	10
ASACCOUNTTYPE	NAME	varchar	31
ASSOCPRICE	ASSOCPRICETYPEID	integer	10
ASSOCPRICE	ID	integer	10
ASSOCPRICE	PRICE	double precision	15	√		0
ASSOCPRICE	PRODUCTID	integer	10
ASSOCPRICETYPE	ACCOUNTID	integer	10	√		0
ASSOCPRICETYPE	DESCRIPTION	varchar	256	√		null
ASSOCPRICETYPE	ID	integer	10
ASSOCPRICETYPE	NAME	varchar	41
ASSOCPRICETYPE	TAXABLEFLAG	smallint	5	√		1
BOM	ACTIVEFLAG	smallint	5	√		1
BOM	AUTOCREATETYPEID	integer	10	√		null
BOM	CONFIGURABLE	smallint	5	√		0
BOM	DATECREATED	timestamp	19	√		null
BOM	DATELASTMODIFIED	timestamp	19	√		null
BOM	DESCRIPTION	varchar	252
BOM	ESTIMATEDDURATION	integer	10	√		0
BOM	ID	integer	10
BOM	NOTE	blob sub_type 1	0	√		null
BOM	NUM	varchar	70
BOM	PICKFROMLOCATION	smallint	5	√		0
BOM	QBCLASSID	integer	10	√		1
BOM	REVISION	integer	10			1
BOM	STATISTICSDATERANGE	varchar	41	√		null
BOM	TYPEID	integer	10	√		null
BOM	URL	varchar	256
BOM	USERID	integer	10			1
BOMAUTOCREATETYPE	ID	integer	10
BOMAUTOCREATETYPE	NAME	varchar	30
BOMITEM	ADDTOSERVICE	smallint	5	√		0
BOMITEM	BOMID	integer	10
BOMITEM	BOMITEMGROUPID	integer	10	√		null
BOMITEM	DESCRIPTION	varchar	256
BOMITEM	GROUPDEFAULT	smallint	5	√		1
BOMITEM	ID	integer	10
BOMITEM	INSTRUCTIONNOTE	blob sub_type 1	0	√		null
BOMITEM	INSTRUCTIONURL	varchar	256
BOMITEM	MAXQTY	double precision	15	√		null
BOMITEM	MINQTY	double precision	15	√		null
BOMITEM	ONETIMEITEM	smallint	5	√		0
BOMITEM	PARTID	integer	10	√		null
BOMITEM	PRICEADJUSTMENT	double precision	15	√		0
BOMITEM	PRODUCTID	integer	10	√		null
BOMITEM	QUANTITY	double precision	15			1
BOMITEM	SORTIDCONFIG	integer	10			1
BOMITEM	SORTIDINSTRUCT	integer	10			1
BOMITEM	STAGE	smallint	5	√		0
BOMITEM	STAGEBOMID	integer	10	√		null
BOMITEM	TYPEID	integer	10
BOMITEM	UOMID	integer	10	√		null
BOMITEM	USEITEMLOCATION	smallint	5	√		0
BOMITEM	VARIABLEQTY	smallint	5	√		0
BOMITEMGROUP	BOMID	integer	10
BOMITEMGROUP	ID	integer	10
BOMITEMGROUP	NAME	varchar	70
BOMITEMGROUP	PROMPT	varchar	256	√		null
BOMITEMGROUP	SORTORDER	integer	10			1
BOMITEMTOLOCATION	BOMITEMID	integer	10
BOMITEMTOLOCATION	ID	integer	10
BOMITEMTOLOCATION	LOCATIONGROUPID	integer	10
BOMITEMTOLOCATION	LOCATIONID	integer	10
BOMITEMTYPE	ID	integer	10
BOMITEMTYPE	NAME	varchar	30
BOMTOLOCATION	BOMID	integer	10
BOMTOLOCATION	ID	integer	10
BOMTOLOCATION	LOCATIONGROUPID	integer	10
BOMTOLOCATION	LOCATIONID	integer	10
CALCATEGORY	COLOR	varchar	32
CALCATEGORY	DATECREATED	timestamp	19	√		null
CALCATEGORY	DATELASTMODIFIED	timestamp	19	√		null
CALCATEGORY	ID	integer	10
CALCATEGORY	LASTCHANGEDUSERID	integer	10	√		1
CALCATEGORY	NAME	varchar	128
CALCATEGORY	PARENTID	integer	10	√		null
CALCATEGORY	READONLY	smallint	5	√		0
CALEVENT	ALLDAY	smallint	5			0
CALEVENT	CALCATEGORYID	integer	10	√		null
CALEVENT	DATECREATED	timestamp	19	√		null
CALEVENT	DATEEND	timestamp	19
CALEVENT	DATELASTMODIFIED	timestamp	19	√		null
CALEVENT	DATESTART	timestamp	19
CALEVENT	ID	integer	10
CALEVENT	LASTCHANGEDUSERID	integer	10	√		1
CALEVENT	LOCATION	varchar	128	√		null
CALEVENT	NAME	varchar	128
CALEVENT	NOTE	blob sub_type 1	0	√		null
CARRIER	ACTIVEFLAG	smallint	5	√		1
CARRIER	DESCRIPTION	varchar	256	√		null
CARRIER	ID	integer	10
CARRIER	NAME	varchar	60
CARRIER	READONLY	smallint	5	√		0
CARRIER	SCAC	varchar	4	√		null
COMPANY	ABN	varchar	14	√		null
COMPANY	ACCOUNTID	integer	10
COMPANY	DATEENTERED	timestamp	19	√		null
COMPANY	DATELASTMODIFIED	timestamp	19	√		null
COMPANY	DEFAULTCARRIERID	integer	10
COMPANY	DEFAULTFLAG	smallint	5	√		0
COMPANY	EANUCCPREFIX	varchar	15	√		null
COMPANY	ID	integer	10
COMPANY	LASTCHANGEDUSER	varchar	15	√		null
COMPANY	NAME	varchar	60
COMPANY	TAXEXEMPT	smallint	5	√		0
COMPANY	TAXEXEMPTNUMBER	varchar	30	√		null
CONTACT	ACCOUNTID	integer	10
CONTACT	ADDRESSID	integer	10	√		null
CONTACT	CONTACTNAME	varchar	30	√		null
CONTACT	DATUS	varchar	64	√		'true'
CONTACT	DEFAULTFLAG	smallint	5	√		0
CONTACT	ID	integer	10
CONTACT	TYPEID	integer	10
CONTACTTYPE	ID	integer	10
CONTACTTYPE	NAME	varchar	15
COSTLAYER	DATECREATED	timestamp	19			'NOW'
COSTLAYER	DATELASTMODIFIED	timestamp	19	√		null
COSTLAYER	ID	integer	10
COSTLAYER	ORGQTY	double precision	15	√		0
COSTLAYER	ORGTOTALCOST	double precision	15	√		0
COSTLAYER	PARTID	integer	10
COSTLAYER	QTY	double precision	15	√		0
COSTLAYER	RECORDID	integer	10	√		0
COSTLAYER	STATUSID	integer	10			10
COSTLAYER	TABLEID	integer	10	√		null
COSTLAYER	TOTALCOST	double precision	15	√		0
COSTLAYERSTATUS	ID	integer	10
COSTLAYERSTATUS	NAME	varchar	15
COUNTRYCONST	ABBREVIATION	varchar	10	√		null
COUNTRYCONST	ID	integer	10
COUNTRYCONST	NAME	varchar	64	√		null
COUNTRYCONST	UPS	smallint	5			1
CURRENCY	ACTIVEFLAG	smallint	5	√		0
CURRENCY	CODE	varchar	255	√		null
CURRENCY	DATECREATED	timestamp	19	√		null
CURRENCY	DATELASTMODIFIED	timestamp	19	√		null
CURRENCY	ID	integer	10
CURRENCY	LASTCHANGEDUSERID	integer	10
CURRENCY	NAME	varchar	255	√		null
CURRENCY	RATE	double precision	15	√		0
CURRENCY	SYMBOL	integer	10	√		NULL
CUSTOMDECIMAL	CUSTOMFIELDID	integer	10
CUSTOMDECIMAL	ID	integer	10
CUSTOMDECIMAL	INFO	double precision	15	√		0
CUSTOMDECIMAL	RECORDID	integer	10
CUSTOMER	ACCOUNTID	integer	10
CUSTOMER	ACCOUNTINGHASH	varchar	30	√		null
CUSTOMER	ACCOUNTINGID	varchar	36	√		null
CUSTOMER	ACTIVEFLAG	smallint	5	√		1
CUSTOMER	CREDITLIMIT	double precision	15	√		0
CUSTOMER	CURRENCYID	integer	10	√		null
CUSTOMER	CURRENCYRATE	double precision	15	√		0
CUSTOMER	DATECREATED	timestamp	19	√		null
CUSTOMER	DATELASTMODIFIED	timestamp	19	√		null
CUSTOMER	DEFAULTCARRIERID	integer	10	√		0
CUSTOMER	DEFAULTPAYMENTTERMSID	integer	10
CUSTOMER	DEFAULTSALESMANID	integer	10	√		0
CUSTOMER	DEFAULTSHIPSERVICEID	integer	10	√		null
CUSTOMER	DEFAULTSHIPTERMSID	integer	10
CUSTOMER	ID	integer	10
CUSTOMER	JOBDEPTH	integer	10	√		1
CUSTOMER	LASTCHANGEDUSER	varchar	15	√		null
CUSTOMER	NAME	varchar	41
CUSTOMER	NOTE	varchar	90	√		null
CUSTOMER	NUMBER	varchar	30
CUSTOMER	PARENTID	integer	10	√		null
CUSTOMER	PIPELINEACCOUNTNUM	integer	10	√		NULL
CUSTOMER	STATUSID	integer	10
CUSTOMER	SYSUSERID	integer	10	√		null
CUSTOMER	TAXEXEMPT	smallint	5	√		0
CUSTOMER	TAXEXEMPTNUMBER	varchar	30	√		null
CUSTOMER	TAXRATEID	integer	10	√		null
CUSTOMER	URL	varchar	256	√		null
CUSTOMERCONTACTVIEW	CONTACTNAME	varchar	30	√		null
CUSTOMERCONTACTVIEW	CONTACTNUM	varchar	64	√		null
CUSTOMERCONTACTVIEW	CUSTID	integer	10	√		null
CUSTOMERCONTACTVIEW	CUSTNAME	varchar	41	√		null
CUSTOMERINCLTYPE	ID	integer	10
CUSTOMERINCLTYPE	NAME	varchar	30
CUSTOMERPARTS	CUSTOMERID	integer	10
CUSTOMERPARTS	CUSTOMERPARTNUMBER	varchar	70
CUSTOMERPARTS	DATECREATED	timestamp	19	√		null
CUSTOMERPARTS	DATELASTMODIFIED	timestamp	19	√		null
CUSTOMERPARTS	DATELASTPURCHASED	timestamp	19	√		NULL
CUSTOMERPARTS	ID	integer	10
CUSTOMERPARTS	LASTCHANGEDUSERID	integer	10			1
CUSTOMERPARTS	LASTPRICE	double precision	15	√		0
CUSTOMERPARTS	PRODUCTID	integer	10
CUSTOMERSTATUS	ID	integer	10
CUSTOMERSTATUS	NAME	varchar	15
CUSTOMFIELD	ACTIVEFLAG	smallint	5	√		1
CUSTOMFIELD	CUSTOMFIELDTYPEID	integer	10
CUSTOMFIELD	DESCRIPTION	varchar	256	√		null
CUSTOMFIELD	ID	integer	10
CUSTOMFIELD	LISTID	integer	10	√		null
CUSTOMFIELD	NAME	varchar	41
CUSTOMFIELD	REQUIRED	smallint	5	√		0
CUSTOMFIELD	SORTORDER	integer	10			1
CUSTOMFIELD	TABLEID	integer	10
CUSTOMFIELDTYPE	DESCRIPTION	varchar	256	√		null
CUSTOMFIELDTYPE	ID	integer	10
CUSTOMFIELDTYPE	NAME	varchar	41
CUSTOMFIELDTYPE	TABLEID	integer	10
CUSTOMFIELDVIEW	CFDESCRIPTION	varchar	256	√		null
CUSTOMFIELDVIEW	CFID	integer	10	√		null
CUSTOMFIELDVIEW	CFNAME	varchar	41	√		null
CUSTOMFIELDVIEW	CFREQUIRED	smallint	5	√		null
CUSTOMFIELDVIEW	CFSORTORDER	integer	10	√		null
CUSTOMFIELDVIEW	CFTABLEID	integer	10	√		null
CUSTOMFIELDVIEW	CFTYPEID	integer	10	√		null
CUSTOMFIELDVIEW	INFO	varchar	128	√		null
CUSTOMFIELDVIEW	INFOFORMATTED	varchar	128	√		null
CUSTOMFIELDVIEW	RECORDID	integer	10	√		null
CUSTOMINTEGER	CUSTOMFIELDID	integer	10
CUSTOMINTEGER	ID	integer	10
CUSTOMINTEGER	INFO	integer	10			0
CUSTOMINTEGER	RECORDID	integer	10
CUSTOMLIST	DESCRIPTION	varchar	256	√		null
CUSTOMLIST	ID	integer	10
CUSTOMLIST	NAME	varchar	41
CUSTOMLISTITEM	DESCRIPTION	varchar	256	√		null
CUSTOMLISTITEM	ID	integer	10
CUSTOMLISTITEM	LISTID	integer	10	√		null
CUSTOMLISTITEM	NAME	varchar	41
CUSTOMSET	CUSTOMFIELDID	integer	10
CUSTOMSET	ID	integer	10
CUSTOMSET	INFO	varchar	41	√		null
CUSTOMSET	RECORDID	integer	10
CUSTOMTIMESTAMP	CUSTOMFIELDID	integer	10
CUSTOMTIMESTAMP	ID	integer	10
CUSTOMTIMESTAMP	INFO	timestamp	19
CUSTOMTIMESTAMP	RECORDID	integer	10
CUSTOMVARCHAR	CUSTOMFIELDID	integer	10
CUSTOMVARCHAR	ID	integer	10
CUSTOMVARCHAR	INFO	varchar	30
CUSTOMVARCHAR	RECORDID	integer	10
CUSTOMVARCHARLONG	CUSTOMFIELDID	integer	10
CUSTOMVARCHARLONG	ID	integer	10
CUSTOMVARCHARLONG	INFO	varchar	128
CUSTOMVARCHARLONG	RECORDID	integer	10
DATABASEVERSION	ALTERCOMMAND	blob sub_type 1	0	√		null
DATABASEVERSION	DATEUPDATED	timestamp	19	√		null
DATABASEVERSION	ID	integer	10
DATABASEVERSION	VERSION	integer	10
DCOPTIONS	CODE	varchar	254
DCOPTIONS	DESCRIPTION	varchar	254
DCOPTIONS	ID	integer	10
DEFAULTLOCATION	ID	integer	10	√		null
DEFAULTLOCATION	LOCATIONGROUPID	integer	10
DEFAULTLOCATION	LOCATIONID	integer	10
DEFAULTLOCATION	PARTID	integer	10
FBSCHEDULE	ACTIONSUBTYPE	varchar	100	√		null
FBSCHEDULE	ACTIONTYPEID	integer	10
FBSCHEDULE	ACTIVEFLAG	smallint	5	√		1
FBSCHEDULE	CRONSTRING	varchar	90	√		null
FBSCHEDULE	DATECREATED	timestamp	19	√		NULL
FBSCHEDULE	DATELASTMODIFIED	timestamp	19	√		NULL
FBSCHEDULE	DATENEXTSCHEDULED	timestamp	19	√		NULL
FBSCHEDULE	DESCRIPTION	varchar	256
FBSCHEDULE	DIRECTORY	varchar	255	√		null
FBSCHEDULE	EMAIL	varchar	255	√		null
FBSCHEDULE	EMAILREPORT	varchar	255	√		null
FBSCHEDULE	FILEMASK	varchar	30	√		null
FBSCHEDULE	FILENAME	varchar	30	√		null
FBSCHEDULE	ID	integer	10
FBSCHEDULE	JAVACLASS	varchar	255	√		null
FBSCHEDULE	LASTCHANGEDUSERID	integer	10	√		1
FBSCHEDULE	NAME	varchar	30
FBSCHEDULE	PARAMETERS	varchar	255	√		null
FBSCHEDULE	REPORTID	integer	10	√		null
FBSCHEDULEACTIONTYPE	ID	integer	10
FBSCHEDULEACTIONTYPE	NAME	varchar	30
FBSCHEDULEHISTORY	ERROR	blob sub_type 1	0	√		null
FBSCHEDULEHISTORY	ID	integer	10
FBSCHEDULEHISTORY	LASTRUNTIME	timestamp	19	√		null
FBSCHEDULEHISTORY	SCHEDULEID	integer	10
FBSCHEDULEREPORTPARAMETER	ID	integer	10
FBSCHEDULEREPORTPARAMETER	NAME	varchar	64
FBSCHEDULEREPORTPARAMETER	PARAMVALUE	varchar	256	√		null
FBSCHEDULEREPORTPARAMETER	SCHEDULEID	integer	10
FEDEXVIEW	CARTONCOUNT	integer	10	√		null
FEDEXVIEW	CARTONID	integer	10	√		null
FEDEXVIEW	COMPANYNAME	varchar	60	√		null
FEDEXVIEW	CONTACTNAME	varchar	30	√		null
FEDEXVIEW	ID	integer	10	√		null
FEDEXVIEW	ORDERNUM	varchar	25	√		null
FEDEXVIEW	PHONE	varchar	64	√		null
FEDEXVIEW	PONUM	varchar	25	√		null
FEDEXVIEW	SERVICETYPE	varchar	60	√		null
FEDEXVIEW	SHIPTOADDRESS	varchar	90	√		null
FEDEXVIEW	SHIPTOCITY	varchar	30	√		null
FEDEXVIEW	SHIPTOCOUNTRY	varchar	10	√		null
FEDEXVIEW	SHIPTOSTATE	varchar	21	√		null
FEDEXVIEW	SHIPTOZIP	varchar	10	√		null
FEDEXVIEW	WEIGHT	double precision	15	√		null
FOBPOINT	ID	integer	10
FOBPOINT	NAME	varchar	15
INTEGRATEDAPP	APPKEY	varchar	15
INTEGRATEDAPP	AUTHORIZED	smallint	5			0
INTEGRATEDAPP	DESCRIPTION	varchar	256	√		null
INTEGRATEDAPP	ID	integer	10
INTEGRATEDAPP	LASTACTIVITY	timestamp	19	√		null
INTEGRATEDAPP	NAME	varchar	41
INTEGRATEDAPP	STATUSID	integer	10	√		1
INTEGRATEDAPPSTATUS	ID	integer	10
INTEGRATEDAPPSTATUS	NAME	varchar	64
INTEGRATIONPROPERTIES	ID	integer	10
INTEGRATIONPROPERTIES	INFO	varchar	255
INTEGRATIONPROPERTIES	KEY	varchar	64
INTEGRATIONPROPERTIES	TYPEID	integer	10
INTEGRATIONTYPE	ID	integer	10
INTEGRATIONTYPE	NAME	varchar	64
INVENTORYLOG	BEGLOCATIONID	integer	10
INVENTORYLOG	BEGTAGNUM	integer	10	√		0
INVENTORYLOG	CHANGEQTY	double precision	15	√		0
INVENTORYLOG	COST	double precision	15	√		0
INVENTORYLOG	DATECREATED	timestamp	19	√		NULL
INVENTORYLOG	ENDLOCATIONID	integer	10
INVENTORYLOG	ENDTAGNUM	integer	10	√		0
INVENTORYLOG	EVENTDATE	timestamp	19	√		'NOW'
INVENTORYLOG	ID	integer	10
INVENTORYLOG	INFO	varchar	100	√		null
INVENTORYLOG	LOCATIONGROUPID	integer	10	√		null
INVENTORYLOG	PARTID	integer	10
INVENTORYLOG	PARTTRACKINGID	integer	10	√		null
INVENTORYLOG	QTYONHAND	double precision	15	√		0
INVENTORYLOG	RECORDID	integer	10	√		0
INVENTORYLOG	TABLEID	integer	10	√		0
INVENTORYLOG	TYPEID	integer	10	√		1
INVENTORYLOG	USERID	integer	10	√		1
INVENTORYLOGTOCOSTLAYER	COSTLAYERID	integer	10
INVENTORYLOGTOCOSTLAYER	ID	integer	10
INVENTORYLOGTOCOSTLAYER	INVENTORYLOGID	integer	10
INVENTORYLOGTOCOSTLAYER	QTY	double precision	15	√		0
INVENTORYLOGTYPE	DESCRIPTION	varchar	256
INVENTORYLOGTYPE	ID	integer	10
INVENTORYLOGTYPE	NAME	varchar	30
INVLOGTRACKINGSUMMARY	INVLOGID	integer	10	√		null
INVLOGTRACKINGSUMMARY	TRACKVALUE	blob sub_type 1	0	√		null
ITEMADJUST	ACTIVEFLAG	smallint	5			1
ITEMADJUST	AMOUNT	double precision	15	√		0
ITEMADJUST	DESCRIPTION	varchar	256	√		null
ITEMADJUST	EXPENSEASACCOUNTID	integer	10	√		0
ITEMADJUST	ID	integer	10
ITEMADJUST	INCOMEASACCOUNTID	integer	10	√		0
ITEMADJUST	NAME	varchar	31
ITEMADJUST	PERCENTAGE	double precision	15	√		0
ITEMADJUST	TAXABLEFLAG	smallint	5	√		1
ITEMADJUST	TAXRATEID	integer	10	√		null
ITEMADJUST	TYPEID	integer	10
ITEMADJUSTTYPE	ID	integer	10
ITEMADJUSTTYPE	NAME	varchar	30
KITDISPLAYTYPE	ID	integer	10
KITDISPLAYTYPE	NAME	varchar	30
KITITEM	DATECREATED	timestamp	19	√		null
KITITEM	DATELASTMODIFIED	timestamp	19	√		null
KITITEM	DEFAULTQTY	double precision	15	√		0
KITITEM	DESCRIPTION	varchar	256	√		null
KITITEM	DISCOUNTID	integer	10	√		null
KITITEM	ID	integer	10
KITITEM	KITITEMTYPEID	integer	10
KITITEM	KITPRODUCTID	integer	10
KITITEM	KITTYPEID	integer	10
KITITEM	MAXQTY	double precision	15	√		0
KITITEM	MINQTY	double precision	15	√		0
KITITEM	NOTE	blob sub_type 1	0	√		null
KITITEM	PRODUCTID	integer	10	√		null
KITITEM	QTYPRICEADJUSTMENT	double precision	15	√		0
KITITEM	SOITEMTYPEID	integer	10	√		null
KITITEM	SORTORDER	integer	10	√		0
KITITEM	TAXRATEID	integer	10	√		null
KITITEM	UOMID	integer	10	√		null
KITITEMTYPE	ID	integer	10
KITITEMTYPE	NAME	varchar	30
KITOPTION	DATECREATED	timestamp	19	√		null
KITOPTION	DATELASTMODIFIED	timestamp	19	√		null
KITOPTION	DEFAULTFLAG	smallint	5	√		0
KITOPTION	ID	integer	10
KITOPTION	KITITEMID	integer	10
KITOPTION	PRICEADJUSTMENT	double precision	15	√		0
KITOPTION	PRODUCTID	integer	10
KITTYPE	ID	integer	10
KITTYPE	NAME	varchar	30
LGSUMTYPE	ID	integer	10
LGSUMTYPE	NAME	varchar	20
LOCATION	ACTIVEFLAG	smallint	5	√		1
LOCATION	COUNTEDASAVAILABLE	smallint	5	√		1
LOCATION	DATELASTMODIFIED	timestamp	19	√		null
LOCATION	DEFAULTCUSTOMERID	integer	10	√		null
LOCATION	DEFAULTFLAG	smallint	5	√		0
LOCATION	DEFAULTVENDORID	integer	10	√		null
LOCATION	DESCRIPTION	varchar	252	√		null
LOCATION	ID	integer	10
LOCATION	LOCATIONGROUPID	integer	10
LOCATION	NAME	varchar	30
LOCATION	PARENTID	integer	10	√		0
LOCATION	PICKABLE	smallint	5	√		1
LOCATION	RECEIVABLE	smallint	5	√		1
LOCATION	SORTORDER	integer	10	√		0
LOCATION	TYPEID	integer	10
LOCATIONGROUP	ACTIVEFLAG	smallint	5	√		1
LOCATIONGROUP	DATELASTMODIFIED	timestamp	19	√		NULL
LOCATIONGROUP	ID	integer	10
LOCATIONGROUP	NAME	varchar	30
LOCATIONGROUP	QBCLASSID	integer	10	√		1
LOCATIONTYPE	ID	integer	10
LOCATIONTYPE	NAME	varchar	15
MEMO	DATECREATED	timestamp	19	√		null
MEMO	ID	integer	10
MEMO	MEMO	blob sub_type 1	0	√		null
MEMO	RECORDID	integer	10
MEMO	TABLEID	integer	10
MEMO	USERNAME	varchar	15	√		null
MO	DATECOMPLETED	timestamp	19	√		null
MO	DATECREATED	timestamp	19	√		null
MO	DATEISSUED	timestamp	19	√		null
MO	DATELASTMODIFIED	timestamp	19	√		null
MO	DATESCHEDULED	timestamp	19	√		null
MO	ID	integer	10
MO	LOCATIONGROUPID	integer	10
MO	NOTE	blob sub_type 1	0	√		null
MO	NUM	varchar	25
MO	QBCLASSID	integer	10	√		1
MO	REVISION	integer	10			1
MO	SOID	integer	10	√		null
MO	STATUSID	integer	10
MO	TYPEID	integer	10	√		null
MO	USERID	integer	10			1
MODULE	ID	integer	10
MODULE	ISMODULE	smallint	5
MODULE	NAME	varchar	41
MODULE	REPORTID	integer	10	√		null
MOITEM	ADDTOSERVICE	smallint	5	√		0
MOITEM	BOMID	integer	10	√		null
MOITEM	BOMITEMID	integer	10	√		null
MOITEM	DATESCHEDULED	timestamp	19	√		null
MOITEM	DATESCHEDULEDTOSTART	timestamp	19	√		null
MOITEM	DESCRIPTION	varchar	256
MOITEM	ID	integer	10
MOITEM	INSTRUCTIONNOTE	blob sub_type 1	0	√		null
MOITEM	INSTRUCTIONURL	varchar	256
MOITEM	MOID	integer	10	√		null
MOITEM	ONETIMEITEM	smallint	5	√		0
MOITEM	PARENTID	integer	10	√		null
MOITEM	PARTID	integer	10	√		null
MOITEM	PRICEADJUSTMENT	double precision	15	√		0
MOITEM	PRIORITYID	integer	10	√		null
MOITEM	QBCLASSID	integer	10	√		1
MOITEM	QTYFULFILLED	double precision	15	√		0
MOITEM	QTYTOFULFILL	double precision	15	√		0
MOITEM	SORTIDINSTRUCT	integer	10			1
MOITEM	STAGE	smallint	5	√		0
MOITEM	STAGELEVEL	integer	10	√		1
MOITEM	STATUSID	integer	10
MOITEM	TOTALCOST	double precision	15	√		0
MOITEM	TYPEID	integer	10
MOITEM	UOMID	integer	10	√		null
MOITEMSTATUS	ID	integer	10
MOITEMSTATUS	NAME	varchar	30
MOSTATUS	ID	integer	10
MOSTATUS	NAME	varchar	30
OBJECTTOOBJECT	ID	integer	10
OBJECTTOOBJECT	NOTE	varchar	30	√		null
OBJECTTOOBJECT	RECORDID1	integer	10
OBJECTTOOBJECT	RECORDID2	integer	10
OBJECTTOOBJECT	TABLEID1	integer	10
OBJECTTOOBJECT	TABLEID2	integer	10
OBJECTTOOBJECT	TYPEID	integer	10			1
OBJECTTOOBJECTTYPE	DESCRIPTION	varchar	256
OBJECTTOOBJECTTYPE	ID	integer	10
OBJECTTOOBJECTTYPE	NAME	varchar	30
ORDERHISTORY	COMMENT	varchar	90	√		null
ORDERHISTORY	DATECREATED	timestamp	19	√		null
ORDERHISTORY	ID	integer	10
ORDERHISTORY	ORDERID	integer	10	√		0
ORDERHISTORY	ORDERTYPEID	integer	10
ORDERHISTORY	RECORDID	integer	10	√		null
ORDERHISTORY	TABLEID	integer	10	√		null
ORDERHISTORY	USERID	integer	10			1
ORDERTYPE	ID	integer	10
ORDERTYPE	NAME	varchar	15
PABASEAMOUNTTYPE	ID	integer	10
PABASEAMOUNTTYPE	NAME	varchar	30
PACKAGETYPES	CODE	varchar	254
PACKAGETYPES	DESCRIPTION	varchar	254
PACKAGETYPES	ID	integer	10
PART	ABCCODE	varchar	1	√		'N'
PART	ACCOUNTINGHASH	varchar	30	√		null
PART	ACCOUNTINGID	varchar	36	√		null
PART	ACTIVEFLAG	smallint	5	√		0
PART	ADJUSTMENTACCOUNTID	integer	10	√		0
PART	ALERTNOTE	varchar	90	√		null
PART	ALWAYSMANUFACTURE	smallint	5	√		0
PART	COGSACCOUNTID	integer	10	√		0
PART	CONFIGUREABLE	smallint	5	√		0
PART	CONTROLLEDFLAG	smallint	5	√		0
PART	CYCLECOUNTTOL	double precision	15	√		0
PART	DATECREATED	timestamp	19	√		null
PART	DATELASTISSUED	timestamp	19	√		null
PART	DATELASTMODIFIED	timestamp	19	√		null
PART	DEFAULTBOMID	integer	10	√		10
PART	DEFAULTPRODUCTID	integer	10	√		null
PART	DESCRIPTION	varchar	252	√		null
PART	DETAILS	blob sub_type 1	0	√		null
PART	HEIGHT	double precision	15	√		0
PART	ID	integer	10
PART	INVENTORYACCOUNTID	integer	10	√		0
PART	LASTCHANGEDUSER	varchar	15	√		null
PART	LEADTIME	integer	10	√		0
PART	LEADTIMETOFULFILL	integer	10	√		0
PART	LEN	double precision	15	√		0
PART	NUM	varchar	70
PART	PARTCLASSID	integer	10	√		null
PART	PICKINUOMOFPART	smallint	5	√		0
PART	RECEIVINGTOL	double precision	15	√		0
PART	REV	varchar	15	√		null
PART	SCRAPACCOUNTID	integer	10	√		0
PART	SERIALIZEDFLAG	smallint	5	√		0
PART	SIZEUOMID	integer	10	√		2
PART	STDCOST	double precision	15	√		0
PART	TAXABLEFLAG	smallint	5	√		0
PART	TAXID	integer	10	√		null
PART	TRACKINGFLAG	smallint	5	√		0
PART	TYPEID	integer	10			0
PART	UOMID	integer	10
PART	UPC	varchar	31	√		null
PART	URL	varchar	256	√		null
PART	VARIANCEACCOUNTID	integer	10	√		0
PART	WEIGHT	double precision	15	√		0
PART	WEIGHTUOMID	integer	10	√		1
PART	WIDTH	double precision	15	√		0
PARTCATEGORY	DESCRIPTION	varchar	252	√		null
PARTCATEGORY	ID	integer	10
PARTCATEGORY	NAME	varchar	30
PARTCOST	AVGCOST	double precision	15	√		0
PARTCOST	DATECREATED	timestamp	19
PARTCOST	DATELASTMODIFIED	timestamp	19	√		NULL
PARTCOST	ID	integer	10
PARTCOST	PARTID	integer	10
PARTCOST	QTY	double precision	15	√		0
PARTCOST	TOTALCOST	double precision	15	√		0
PARTREORDER	ID	integer	10
PARTREORDER	LOCATIONGROUPID	integer	10	√		null
PARTREORDER	ORDERUPTOLEVEL	double precision	15	√		0
PARTREORDER	PARTID	integer	10
PARTREORDER	REORDERPOINT	double precision	15	√		0
PARTTOTRACKING	ID	integer	10
PARTTOTRACKING	PARTID	integer	10
PARTTOTRACKING	PARTTRACKINGID	integer	10
PARTTOTRACKING	PRIMARYFLAG	smallint	5	√		0
PARTTRACKING	ABBR	varchar	10
PARTTRACKING	ACTIVEFLAG	smallint	5	√		1
PARTTRACKING	DESCRIPTION	varchar	256	√		null
PARTTRACKING	ID	integer	10
PARTTRACKING	NAME	varchar	41
PARTTRACKING	SORTORDER	integer	10
PARTTRACKING	TYPEID	integer	10
PARTTRACKINGTYPE	ID	integer	10
PARTTRACKINGTYPE	NAME	varchar	20
PARTTRACKINGVIEW	ABBR	varchar	10	√		null
PARTTRACKINGVIEW	ACTIVEFLAG	smallint	5	√		null
PARTTRACKINGVIEW	DESCRIPTION	varchar	256	√		null
PARTTRACKINGVIEW	INFO	varchar	41	√		null
PARTTRACKINGVIEW	INFOFORMATTED	varchar	41	√		null
PARTTRACKINGVIEW	NAME	varchar	41	√		null
PARTTRACKINGVIEW	PARTTRACKINGID	integer	10	√		null
PARTTRACKINGVIEW	SORTORDER	integer	10	√		null
PARTTRACKINGVIEW	TAGID	integer	10	√		null
PARTTRACKINGVIEW	TYPEID	integer	10	√		null
PARTTYPE	ID	integer	10
PARTTYPE	NAME	varchar	30
PATYPE	ID	integer	10
PATYPE	NAME	varchar	30
PAYMENTMETHOD	ACTIVE	smallint	5			1
PAYMENTMETHOD	EDITABLE	smallint	5			1
PAYMENTMETHOD	ID	integer	10
PAYMENTMETHOD	NAME	varchar	31
PAYMENTMETHOD	TYPEID	integer	10
PAYMENTTERMS	ACCOUNTINGHASH	varchar	30	√		null
PAYMENTTERMS	ACCOUNTINGID	varchar	36	√		null
PAYMENTTERMS	ACTIVEFLAG	smallint	5	√		1
PAYMENTTERMS	DATECREATED	timestamp	19	√		null
PAYMENTTERMS	DATELASTMODIFIED	timestamp	19	√		null
PAYMENTTERMS	DEFAULTTERM	smallint	5	√		0
PAYMENTTERMS	DISCOUNT	decimal	12,5	√		0
PAYMENTTERMS	DISCOUNTDAYS	integer	10	√		0
PAYMENTTERMS	ID	integer	10
PAYMENTTERMS	NAME	varchar	60
PAYMENTTERMS	NETDAYS	integer	10	√		0
PAYMENTTERMS	NEXTMONTH	integer	10	√		0
PAYMENTTERMS	READONLY	smallint	5	√		0
PAYMENTTERMS	TYPEID	integer	10
PAYMENTTERMSTYPE	ID	integer	10
PAYMENTTERMSTYPE	NAME	varchar	30
PAYMENTTYPE	ID	integer	10
PAYMENTTYPE	NAME	varchar	30
PICK	DATECREATED	timestamp	19	√		null
PICK	DATEFINISHED	timestamp	19	√		null
PICK	DATELASTMODIFIED	timestamp	19	√		null
PICK	DATESCHEDULED	timestamp	19	√		null
PICK	DATESTARTED	timestamp	19	√		null
PICK	ID	integer	10
PICK	LOCATIONGROUPID	integer	10
PICK	NUM	varchar	35
PICK	PRIORITY	integer	10			30
PICK	STATUSID	integer	10	√		10
PICK	TYPEID	integer	10	√		10
PICK	USERID	integer	10	√		1
PICKITEM	DESTTAGID	integer	10	√		0
PICKITEM	ID	integer	10
PICKITEM	ORDERID	integer	10
PICKITEM	ORDERITEMID	integer	10
PICKITEM	ORDERTYPEID	integer	10
PICKITEM	PARTID	integer	10
PICKITEM	PICKID	integer	10
PICKITEM	QTY	double precision	15	√		0
PICKITEM	SLOTNUM	integer	10	√		1
PICKITEM	SRCLOCATIONID	integer	10	√		null
PICKITEM	SRCTAGID	integer	10	√		null
PICKITEM	STATUSID	integer	10
PICKITEM	TAGID	integer	10	√		0
PICKITEM	TYPEID	integer	10	√		10
PICKITEM	UOMID	integer	10
PICKITEMSTATUS	ID	integer	10
PICKITEMSTATUS	NAME	varchar	30
PICKITEMTYPE	ID	integer	10
PICKITEMTYPE	NAME	varchar	30
PICKSTATUS	ID	integer	10
PICKSTATUS	NAME	varchar	30
PICKTYPE	ID	integer	10
PICKTYPE	NAME	varchar	30
PO	BUYER	varchar	30	√		null
PO	CARRIERID	integer	10
PO	CURRENCYID	integer	10	√		null
PO	CURRENCYRATE	double precision	15	√		1
PO	CUSTOMERSO	varchar	25	√		null
PO	DATECOMPLETED	timestamp	19	√		null
PO	DATECONFIRMED	timestamp	19	√		null
PO	DATECREATED	timestamp	19	√		null
PO	DATEFIRSTSHIP	timestamp	19	√		null
PO	DATEISSUED	timestamp	19	√		null
PO	DATELASTMODIFIED	timestamp	19	√		null
PO	DATEREVISION	timestamp	19	√		null
PO	DELIVERTO	varchar	30	√		null
PO	FOBPOINTID	integer	10
PO	ID	integer	10
PO	LOCATIONGROUPID	integer	10
PO	NOTE	blob sub_type 1	0	√		null
PO	NUM	varchar	25
PO	PAYMENTTERMSID	integer	10
PO	QBCLASSID	integer	10	√		1
PO	REMITADDRESS	varchar	90	√		null
PO	REMITCITY	varchar	30	√		null
PO	REMITCOUNTRYID	integer	10	√		null
PO	REMITSTATEID	integer	10	√		null
PO	REMITTONAME	varchar	60	√		null
PO	REMITZIP	varchar	10	√		null
PO	REVISIONNUM	integer	10	√		0
PO	SHIPTERMSID	integer	10
PO	SHIPTOADDRESS	varchar	90	√		null
PO	SHIPTOCITY	varchar	30	√		null
PO	SHIPTOCOUNTRYID	integer	10	√		null
PO	SHIPTONAME	varchar	60	√		null
PO	SHIPTOSTATEID	integer	10	√		null
PO	SHIPTOZIP	varchar	10	√		null
PO	STATUSID	integer	10
PO	TAXRATEID	integer	10	√		null
PO	TAXRATENAME	varchar	31	√		null
PO	TOTALINCLUDESTAX	smallint	5	√		0
PO	TOTALTAX	double precision	15	√		null
PO	TYPEID	integer	10
PO	URL	varchar	256	√		null
PO	USERNAME	varchar	15	√		null
PO	VENDORCONTACT	varchar	30	√		null
PO	VENDORID	integer	10
PO	VENDORSO	varchar	25	√		null
POITEM	CUSTOMERID	integer	10	√		null
POITEM	DATELASTFULFILLMENT	timestamp	19	√		null
POITEM	DATESCHEDULEDFULFILLMENT	timestamp	19			'NOW'
POITEM	DESCRIPTION	varchar	252	√		null
POITEM	ID	integer	10
POITEM	NOTE	blob sub_type 1	0	√		null
POITEM	PARTID	integer	10	√		null
POITEM	PARTNUM	varchar	70
POITEM	POID	integer	10
POITEM	POLINEITEM	integer	10
POITEM	QBCLASSID	integer	10	√		1
POITEM	QTYFULFILLED	double precision	15	√		0
POITEM	QTYPICKED	double precision	15	√		0
POITEM	QTYTOFULFILL	double precision	15	√		0
POITEM	REPAIRFLAG	smallint	5	√		0
POITEM	REVLEVEL	varchar	15	√		null
POITEM	STATUSID	integer	10
POITEM	TAXID	integer	10	√		null
POITEM	TAXRATE	double precision	15	√		0
POITEM	TBDCOSTFLAG	smallint	5	√		0
POITEM	TOTALCOST	double precision	15	√		0
POITEM	TYPEID	integer	10
POITEM	UNITCOST	double precision	15	√		0
POITEM	UOMID	integer	10	√		null
POITEM	VENDORPARTNUM	varchar	70
POITEMSTATUS	ID	integer	10
POITEMSTATUS	NAME	varchar	15
POITEMTYPE	ID	integer	10
POITEMTYPE	NAME	varchar	15
POST	AMOUNT	double precision	15	√		0
POST	CUSTOMERID	integer	10	√		null
POST	DATECREATED	timestamp	19	√		'NOW'
POST	DATEPOSTED	timestamp	19	√		null
POST	EDITSEQUENCE	varchar	16	√		null
POST	ID	integer	10
POST	ORDERID	integer	10	√		0
POST	ORDERTYPEID	integer	10
POST	QUANTITY	double precision	15	√		0
POST	REFID	integer	10	√		0
POST	REFITEMID	integer	10	√		0
POST	REFNUMBER	varchar	20	√		null
POST	SERIALNUM	varchar	30	√		null
POST	STATUSID	integer	10
POST	TXNID	varchar	36	√		null
POST	TXNLINEID	varchar	36	√		null
POST	TYPEID	integer	10
POSTATUS	ID	integer	10
POSTATUS	NAME	varchar	15
POSTORDERSTATUS	ID	integer	10
POSTORDERSTATUS	NAME	varchar	30
POSTPO	DATECREATED	timestamp	19			'NOW'
POSTPO	DATELASTMODIFIED	timestamp	19	√		null
POSTPO	DATEPOSTED	timestamp	19	√		null
POSTPO	EXTREFNUMBER	varchar	21	√		null
POSTPO	EXTTXNHASH	varchar	16	√		null
POSTPO	EXTTXNID	varchar	36	√		null
POSTPO	EXTTXNNUMBER	integer	10	√		null
POSTPO	ID	integer	10
POSTPO	POID	integer	10
POSTPO	POSTDATE	timestamp	19	√		null
POSTPO	STATUSID	integer	10			10
POSTPOITEM	DATECREATED	timestamp	19			'NOW'
POSTPOITEM	DATELASTMODIFIED	timestamp	19	√		null
POSTPOITEM	EXTREFNUMBER	varchar	21	√		null
POSTPOITEM	EXTTXNHASH	varchar	16	√		null
POSTPOITEM	EXTTXNID	varchar	36	√		null
POSTPOITEM	EXTTXNLINEID	varchar	36	√		null
POSTPOITEM	ID	integer	10
POSTPOITEM	POITEMID	integer	10	√		null
POSTPOITEM	POSTEDTOTALCOST	double precision	15	√		0
POSTPOITEM	POSTPOID	integer	10
POSTPOITEM	QTY	double precision	15	√		0
POSTPOITEM	RECORDID	integer	10	√		null
POSTPOITEM	STDCOST	double precision	15	√		0
POSTRANSACTION	AMOUNT	double precision	15	√		0
POSTRANSACTION	AUTHCODE	varchar	20	√		null
POSTRANSACTION	CHANGE	double precision	15	√		0
POSTRANSACTION	CONFIRMATION	varchar	30	√		null
POSTRANSACTION	CURRENCYRATE	double precision	15	√		1
POSTRANSACTION	DATETIME	timestamp	19	√		null
POSTRANSACTION	DEPOSITTOACCOUNTID	integer	10	√		0
POSTRANSACTION	EXPDATE	timestamp	19	√		null
POSTRANSACTION	ID	integer	10
POSTRANSACTION	MERCHANTACTNUM	varchar	20	√		null
POSTRANSACTION	MISCCREDITCARD	blob sub_type 1	0	√		null
POSTRANSACTION	PAYMENTMETHODID	integer	10
POSTRANSACTION	REFERENCE	varchar	60	√		null
POSTRANSACTION	SOID	integer	10
POSTRANSACTION	TRANSACTIONID	varchar	20	√		null
POSTRANSACTION	USERID	integer	10	√		null
POSTSO	DATECREATED	timestamp	19			'NOW'
POSTSO	DATELASTMODIFIED	timestamp	19	√		null
POSTSO	DATEPOSTED	timestamp	19	√		null
POSTSO	EXTREFNUMBER	varchar	21	√		null
POSTSO	EXTTXNHASH	varchar	16	√		null
POSTSO	EXTTXNID	varchar	36	√		null
POSTSO	EXTTXNNUMBER	integer	10	√		null
POSTSO	ID	integer	10
POSTSO	POSTDATE	timestamp	19	√		null
POSTSO	SOID	integer	10
POSTSO	STATUSID	integer	10			10
POSTSOITEM	DATECREATED	timestamp	19			'NOW'
POSTSOITEM	DATELASTMODIFIED	timestamp	19	√		null
POSTSOITEM	EXTREFNUMBER	varchar	21	√		null
POSTSOITEM	EXTTXNHASH	varchar	16	√		null
POSTSOITEM	EXTTXNID	varchar	36	√		null
POSTSOITEM	EXTTXNLINEID	varchar	36	√		null
POSTSOITEM	ID	integer	10
POSTSOITEM	POSTEDTOTALCOST	double precision	15	√		0
POSTSOITEM	POSTSOID	integer	10
POSTSOITEM	QTY	double precision	15	√		0
POSTSOITEM	RECORDID	integer	10	√		null
POSTSOITEM	SOITEMID	integer	10
POSTSTATUS	ID	integer	10
POSTSTATUS	NAME	varchar	15
POSTTYPE	ID	integer	10
POSTTYPE	NAME	varchar	30
POSTWO	DATECREATED	timestamp	19			'NOW'
POSTWO	DATELASTMODIFIED	timestamp	19	√		null
POSTWO	DATEPOSTED	timestamp	19	√		null
POSTWO	EXTREFNUMBER	varchar	21	√		null
POSTWO	EXTTXNHASH	varchar	16	√		null
POSTWO	EXTTXNID	varchar	36	√		null
POSTWO	EXTTXNNUMBER	integer	10	√		null
POSTWO	ID	integer	10
POSTWO	POSTDATE	timestamp	19	√		null
POSTWO	STATUSID	integer	10			10
POSTWO	WOID	integer	10
POSTWOITEM	DATECREATED	timestamp	19			'NOW'
POSTWOITEM	DATELASTMODIFIED	timestamp	19	√		null
POSTWOITEM	EXTREFNUMBER	varchar	21	√		null
POSTWOITEM	EXTTXNHASH	varchar	16	√		null
POSTWOITEM	EXTTXNID	varchar	36	√		null
POSTWOITEM	EXTTXNLINEID	varchar	36	√		null
POSTWOITEM	ID	integer	10
POSTWOITEM	POSTWOID	integer	10
POSTWOITEM	WOITEMID	integer	10	√		null
POSTXO	DATECREATED	timestamp	19			'NOW'
POSTXO	DATELASTMODIFIED	timestamp	19	√		null
POSTXO	DATEPOSTED	timestamp	19	√		null
POSTXO	EXTREFNUMBER	varchar	21	√		null
POSTXO	EXTTXNHASH	varchar	16	√		null
POSTXO	EXTTXNID	varchar	36	√		null
POSTXO	EXTTXNNUMBER	integer	10	√		null
POSTXO	ID	integer	10
POSTXO	POSTDATE	timestamp	19	√		null
POSTXO	STATUSID	integer	10			10
POSTXO	XOID	integer	10
POSTXOITEM	DATECREATED	timestamp	19			'NOW'
POSTXOITEM	DATELASTMODIFIED	timestamp	19	√		null
POSTXOITEM	EXTTXNLINEID	varchar	36	√		null
POSTXOITEM	ID	integer	10
POSTXOITEM	POSTEDTOTALCOST	double precision	15	√		0
POSTXOITEM	POSTXOID	integer	10
POSTXOITEM	QTY	double precision	15	√		0
POSTXOITEM	RECORDID	integer	10	√		null
POSTXOITEM	XOITEMID	integer	10	√		null
POTYPE	ID	integer	10
POTYPE	NAME	varchar	30
PRICINGRULE	CUSTOMERINCLID	integer	10	√		0
PRICINGRULE	CUSTOMERINCLTYPEID	smallint	5
PRICINGRULE	DATEAPPLIES	smallint	5	√		0
PRICINGRULE	DATEBEGIN	timestamp	19	√		null
PRICINGRULE	DATECREATED	timestamp	19	√		'NOW'
PRICINGRULE	DATEEND	timestamp	19	√		null
PRICINGRULE	DATELASTMODIFIED	timestamp	19	√		'NOW'
PRICINGRULE	DESCRIPTION	blob sub_type 1	0	√		null
PRICINGRULE	ID	integer	10
PRICINGRULE	ISACTIVE	smallint	5	√		1
PRICINGRULE	ISAUTOAPPLY	smallint	5	√		1
PRICINGRULE	ISTIER2	smallint	5	√		0
PRICINGRULE	NAME	varchar	41
PRICINGRULE	PAAMOUNT	double precision	15	√		0
PRICINGRULE	PAAPPLIES	smallint	5	√		1
PRICINGRULE	PABASEAMOUNTTYPEID	smallint	5	√		3
PRICINGRULE	PAPERCENT	double precision	15	√		0
PRICINGRULE	PATYPEID	smallint	5	√		1
PRICINGRULE	PRODUCTINCLID	integer	10	√		0
PRICINGRULE	PRODUCTINCLTYPEID	smallint	5
PRICINGRULE	QTYAPPLIES	smallint	5	√		0
PRICINGRULE	QTYMAX	double precision	15	√		0
PRICINGRULE	QTYMIN	double precision	15	√		0
PRICINGRULE	RNDAPPLIES	smallint	5	√		0
PRICINGRULE	RNDISMINUS	smallint	5	√		1
PRICINGRULE	RNDPMAMOUNT	double precision	15	√		0
PRICINGRULE	RNDTOAMOUNT	double precision	15	√		0
PRICINGRULE	RNDTYPEID	smallint	5	√		2
PRICINGRULE	SPCAPPLIES	smallint	5	√		0
PRICINGRULE	SPCBUYX	integer	10	√		0
PRICINGRULE	SPCGETYFREE	integer	10	√		0
PRICINGRULE	USERID	integer	10			1
PRIORITY	ID	integer	10
PRIORITY	NAME	varchar	30
PRODUCT	ACCOUNTINGHASH	varchar	30	√		null
PRODUCT	ACCOUNTINGID	varchar	36	√		null
PRODUCT	ACTIVEFLAG	smallint	5	√		1
PRODUCT	ALERTNOTE	varchar	90	√		null
PRODUCT	DATECREATED	timestamp	19	√		null
PRODUCT	DATELASTMODIFIED	timestamp	19	√		null
PRODUCT	DEFAULTSOITEMTYPE	integer	10	√		10
PRODUCT	DESCRIPTION	varchar	252	√		null
PRODUCT	DETAILS	blob sub_type 1	0	√		null
PRODUCT	DISPLAYTYPEID	integer	10	√		10
PRODUCT	HEIGHT	double precision	15	√		0
PRODUCT	ID	integer	10
PRODUCT	INCOMEACCOUNTID	integer	10	√		0
PRODUCT	KITFLAG	smallint	5			0
PRODUCT	KITGROUPEDFLAG	smallint	5	√		0
PRODUCT	LEN	double precision	15	√		0
PRODUCT	NUM	varchar	70
PRODUCT	PARTID	integer	10	√		null
PRODUCT	PRICE	double precision	15	√		0
PRODUCT	QBCLASSID	integer	10	√		null
PRODUCT	SELLABLEINOTHERUOMS	smallint	5	√		1
PRODUCT	SHOWSOCOMBOFLAG	smallint	5			1
PRODUCT	SIZEUOMID	integer	10	√		2
PRODUCT	SKU	varchar	31	√		null
PRODUCT	TAXABLEFLAG	smallint	5	√		1
PRODUCT	TAXID	integer	10	√		null
PRODUCT	UOMID	integer	10
PRODUCT	UPC	varchar	31	√		null
PRODUCT	URL	varchar	256	√		null
PRODUCT	USEPRICEFLAG	smallint	5			1
PRODUCT	WEIGHT	double precision	15	√		0
PRODUCT	WEIGHTUOMID	integer	10	√		3
PRODUCT	WIDTH	double precision	15	√		0
PRODUCTINCLTYPE	ID	integer	10
PRODUCTINCLTYPE	NAME	varchar	30
PRODUCTTOTREE	ID	integer	10
PRODUCTTOTREE	PRODUCTID	integer	10
PRODUCTTOTREE	PRODUCTTREEID	integer	10
PRODUCTTREE	DESCRIPTION	varchar	252	√		null
PRODUCTTREE	ID	integer	10
PRODUCTTREE	NAME	varchar	30
PRODUCTTREE	PARENTID	integer	10
PROPERTYCATEGORY	ID	integer	10
PROPERTYCATEGORY	NAME	varchar	41
QBCLASS	ACCOUNTINGHASH	varchar	30	√		null
QBCLASS	ACCOUNTINGID	varchar	36	√		null
QBCLASS	ACTIVEFLAG	smallint	5	√		1
QBCLASS	DATECREATED	timestamp	19	√		null
QBCLASS	DATELASTMODIFIED	timestamp	19	√		null
QBCLASS	ID	integer	10
QBCLASS	NAME	varchar	31
QBCLASS	PARENTID	integer	10			1
QOHVIEW	LOCATIONGROUPID	integer	10	√		null
QOHVIEW	LOCATIONID	integer	10	√		null
QOHVIEW	PARTID	integer	10	√		null
QOHVIEW	QTY	double precision	15	√		null
QOHVIEW	SERIALNUM	varchar	41	√		null
QOHVIEW	TAGNUM	integer	10	√		null
QTYALLOCATED	LOCATIONGROUPID	integer	10	√		null
QTYALLOCATED	PARTID	integer	10	√		null
QTYALLOCATED	QTY	double precision	15	√		null
QTYALLOCATEDMO	LOCATIONGROUPID	integer	10	√		null
QTYALLOCATEDMO	PARTID	integer	10	√		null
QTYALLOCATEDMO	QTY	double precision	15	√		null
QTYALLOCATEDPO	LOCATIONGROUPID	integer	10	√		null
QTYALLOCATEDPO	PARTID	integer	10	√		null
QTYALLOCATEDPO	QTY	double precision	15	√		null
QTYALLOCATEDSO	LOCATIONGROUPID	integer	10	√		null
QTYALLOCATEDSO	PARTID	integer	10	√		null
QTYALLOCATEDSO	QTY	double precision	15	√		null
QTYALLOCATEDTORECEIVE	LOCATIONGROUPID	integer	10	√		null
QTYALLOCATEDTORECEIVE	PARTID	integer	10	√		null
QTYALLOCATEDTORECEIVE	QTY	double precision	15	√		null
QTYALLOCATEDTOSEND	LOCATIONGROUPID	integer	10	√		null
QTYALLOCATEDTOSEND	PARTID	integer	10	√		null
QTYALLOCATEDTOSEND	QTY	double precision	15	√		null
QTYCOMMITTED	LOCATIONGROUPID	integer	10	√		null
QTYCOMMITTED	PARTID	integer	10	√		null
QTYCOMMITTED	QTY	double precision	15	√		null
QTYDROPSHIP	LOCATIONGROUPID	integer	10	√		null
QTYDROPSHIP	PARTID	integer	10	√		null
QTYDROPSHIP	QTY	double precision	15	√		null
QTYINVENTORY	LOCATIONGROUPID	integer	10	√		null
QTYINVENTORY	PARTID	integer	10	√		null
QTYINVENTORY	QTYALLOCATEDMO	double precision	15	√		null
QTYINVENTORY	QTYALLOCATEDPO	double precision	15	√		null
QTYINVENTORY	QTYALLOCATEDSO	double precision	15	√		null
QTYINVENTORY	QTYALLOCATEDTO	double precision	15	√		null
QTYINVENTORY	QTYDROPSHIP	double precision	15	√		null
QTYINVENTORY	QTYNOTAVAILABLE	double precision	15	√		null
QTYINVENTORY	QTYNOTAVAILABLETOPICK	double precision	15	√		null
QTYINVENTORY	QTYONHAND	double precision	15	√		null
QTYINVENTORY	QTYONORDERMO	double precision	15	√		null
QTYINVENTORY	QTYONORDERPO	double precision	15	√		null
QTYINVENTORY	QTYONORDERSO	double precision	15	√		null
QTYINVENTORY	QTYONORDERTO	double precision	15	√		null
QTYINVENTORYTOTALS	LOCATIONGROUPID	integer	10	√		null
QTYINVENTORYTOTALS	PARTID	integer	10	√		null
QTYINVENTORYTOTALS	QTYALLOCATED	double precision	15	√		null
QTYINVENTORYTOTALS	QTYDROPSHIP	double precision	15	√		null
QTYINVENTORYTOTALS	QTYNOTAVAILABLE	double precision	15	√		null
QTYINVENTORYTOTALS	QTYNOTAVAILABLETOPICK	double precision	15	√		null
QTYINVENTORYTOTALS	QTYONHAND	double precision	15	√		null
QTYINVENTORYTOTALS	QTYONORDER	double precision	15	√		null
QTYNOTAVAILABLE	LOCATIONGROUPID	integer	10	√		null
QTYNOTAVAILABLE	PARTID	integer	10	√		null
QTYNOTAVAILABLE	QTY	double precision	15	√		null
QTYNOTAVAILABLETOPICK	LOCATIONGROUPID	integer	10	√		null
QTYNOTAVAILABLETOPICK	PARTID	integer	10	√		null
QTYNOTAVAILABLETOPICK	QTY	double precision	15	√		null
QTYONHAND	LOCATIONGROUPID	integer	10	√		null
QTYONHAND	PARTID	integer	10	√		null
QTYONHAND	QTY	double precision	15	√		null
QTYONORDER	LOCATIONGROUPID	integer	10	√		null
QTYONORDER	PARTID	integer	10	√		null
QTYONORDER	QTY	double precision	15	√		null
QTYONORDERMO	LOCATIONGROUPID	integer	10	√		null
QTYONORDERMO	PARTID	integer	10	√		null
QTYONORDERMO	QTY	double precision	15	√		null
QTYONORDERPO	LOCATIONGROUPID	integer	10	√		null
QTYONORDERPO	PARTID	integer	10	√		null
QTYONORDERPO	QTY	double precision	15	√		null
QTYONORDERSO	LOCATIONGROUPID	integer	10	√		null
QTYONORDERSO	PARTID	integer	10	√		null
QTYONORDERSO	QTY	double precision	15	√		null
QTYONORDERTORECEIVE	LOCATIONGROUPID	integer	10	√		null
QTYONORDERTORECEIVE	PARTID	integer	10	√		null
QTYONORDERTORECEIVE	QTY	double precision	15	√		null
QTYONORDERTOSEND	LOCATIONGROUPID	integer	10	√		null
QTYONORDERTOSEND	PARTID	integer	10	√		null
QTYONORDERTOSEND	QTY	double precision	15	√		null
QUICKLIST	CUSTOMERID	integer	10
QUICKLIST	ID	integer	10
QUICKLIST	NAME	varchar	30
QUICKLISTITEM	ID	integer	10
QUICKLISTITEM	PRODUCTID	integer	10
QUICKLISTITEM	QLISTID	integer	10
QUICKLISTITEM	QUANTITY	double precision	15	√		0
RECEIPT	ID	integer	10
RECEIPT	LOCATIONGROUPID	integer	10
RECEIPT	ORDERID	integer	10	√		null
RECEIPT	ORDERTYPEID	integer	10
RECEIPT	STATUSID	integer	10
RECEIPT	TYPEID	integer	10			10
RECEIPT	USERID	integer	10			1
RECEIPTITEM	BILLEDTOTALCOST	double precision	15	√		0
RECEIPTITEM	BILLVENDORFLAG	smallint	5	√		1
RECEIPTITEM	CARRIERID	integer	10	√		null
RECEIPTITEM	CUSTOMERID	integer	10	√		null
RECEIPTITEM	DATEBILLED	timestamp	19	√		null
RECEIPTITEM	DATELASTMODIFIED	timestamp	19	√		null
RECEIPTITEM	DATERECEIVED	timestamp	19	√		null
RECEIPTITEM	DATERECONCILED	timestamp	19	√		null
RECEIPTITEM	DELIVERTO	varchar	30	√		null
RECEIPTITEM	ID	integer	10
RECEIPTITEM	LANDEDTOTALCOST	double precision	15	√		0
RECEIPTITEM	LOCATIONID	integer	10	√		null
RECEIPTITEM	ORDERITEMID	integer	10	√		null
RECEIPTITEM	PACKAGECOUNT	integer	10	√		1
RECEIPTITEM	PARTID	integer	10	√		null
RECEIPTITEM	PARTTYPEID	integer	10
RECEIPTITEM	QTY	double precision	15	√		0
RECEIPTITEM	REASON	varchar	90	√		null
RECEIPTITEM	RECEIPTID	integer	10
RECEIPTITEM	REFNO	varchar	20	√		null
RECEIPTITEM	RESPONSIBILITYID	integer	10	√		null
RECEIPTITEM	SHIPITEMID	integer	10	√		null
RECEIPTITEM	STATUSID	integer	10			10
RECEIPTITEM	TAGID	integer	10	√		null
RECEIPTITEM	TAXID	integer	10	√		null
RECEIPTITEM	TAXRATE	double precision	15	√		0
RECEIPTITEM	TRACKINGNUM	varchar	30	√		null
RECEIPTITEM	TYPEID	integer	10
RECEIPTITEM	UOMID	integer	10
RECEIPTITEMSTATUS	ID	integer	10
RECEIPTITEMSTATUS	NAME	varchar	15
RECEIPTITEMTYPE	ID	integer	10
RECEIPTITEMTYPE	NAME	varchar	15
RECEIPTSTATUS	ID	integer	10
RECEIPTSTATUS	NAME	varchar	15
RECEIPTTYPE	ID	integer	10
RECEIPTTYPE	NAME	varchar	15
REGISTER	ID	integer	10
REGISTER	NAME	varchar	15
REPORT	ACTIVEFLAG	smallint	5	√		1
REPORT	DATECREATED	timestamp	19	√		null
REPORT	DATELASTMODIFIED	timestamp	19	√		null
REPORT	DESCRIPTION	blob sub_type 1	0	√		null
REPORT	ID	integer	10
REPORT	LASTCHANGEDUSERID	integer	10	√		1
REPORT	NAME	varchar	64
REPORT	PATH	varchar	256
REPORT	READONLY	smallint	5	√		0
REPORT	REPORTTREEID	integer	10
REPORT	USERID	integer	10	√		NULL
REPORTPARAMETER	ID	integer	10
REPORTPARAMETER	NAME	varchar	64
REPORTPARAMETER	PARAMVALUE	varchar	256	√		null
REPORTPARAMETER	REPORTID	integer	10
REPORTSECURITY	ALLOW	smallint	5	√		1
REPORTSECURITY	ID	integer	10
REPORTSECURITY	REPORTID	integer	10
REPORTSECURITY	USERGROUPID	integer	10
REPORTTOMODULE	MODULEID	integer	10
REPORTTOMODULE	REPORTID	integer	10
REPORTTREE	ID	integer	10
REPORTTREE	NAME	varchar	64
REPORTTREE	PARENTID	integer	10	√		null
REPORTTREE	READONLY	smallint	5	√		0
REPORTTREE	USERID	integer	10	√		NULL
RESPONSIBILITY	ID	integer	10
RESPONSIBILITY	NAME	varchar	15
RMA	CUSTOMERID	integer	10
RMA	DATECREATED	timestamp	19	√		null
RMA	DATEEXPIRES	timestamp	19	√		null
RMA	DATELASTMODIFIED	timestamp	19	√		null
RMA	ID	integer	10
RMA	LOCATIONGROUPID	integer	10
RMA	NUM	varchar	25
RMA	STATUSID	integer	10			10
RMA	USERID	integer	10			1
RMAITEM	CROSSSHIPFLAG	smallint	5	√		0
RMAITEM	DATERESOLVED	timestamp	19	√		null
RMAITEM	ID	integer	10
RMAITEM	ISSUEID	integer	10	√		null
RMAITEM	LINENUM	integer	10
RMAITEM	NOTE	blob sub_type 1	0	√		null
RMAITEM	PRODUCTID	integer	10
RMAITEM	PRODUCTSUBID	integer	10	√		null
RMAITEM	QTY	double precision	15	√		0
RMAITEM	RESOLUTIONID	integer	10	√		null
RMAITEM	RETURNFLAG	smallint	5	√		0
RMAITEM	RMAID	integer	10
RMAITEM	SHIPFLAG	smallint	5	√		0
RMAITEM	TYPEID	integer	10
RMAITEM	UOMID	integer	10
RMAITEM	VENDORID	integer	10	√		null
RMAITEM	VENDORRMA	varchar	25	√		null
RMAITEMTYPE	ACTIVEFLAG	smallint	5	√		1
RMAITEMTYPE	ID	integer	10
RMAITEMTYPE	NAME	varchar	30
RMASTATUS	ID	integer	10
RMASTATUS	NAME	varchar	30
RNDTYPE	ID	integer	10
RNDTYPE	NAME	varchar	30
SERIAL	COMMITTEDFLAG	smallint	5	√		0
SERIAL	ID	integer	10
SERIAL	TAGID	integer	10
SERIALNUM	ID	integer	10
SERIALNUM	PARTTRACKINGID	integer	10
SERIALNUM	SERIALID	integer	10
SERIALNUM	SERIALNUM	varchar	41
SHIP	BILLOFLADING	varchar	20	√		null
SHIP	CARRIERID	integer	10
SHIP	CARTONCOUNT	integer	10	√		0
SHIP	DATECREATED	timestamp	19	√		null
SHIP	DATELASTMODIFIED	timestamp	19	√		NULL
SHIP	DATESHIPPED	timestamp	19	√		null
SHIP	FOBPOINTID	integer	10
SHIP	ID	integer	10
SHIP	INVOICEAMOUNT	double precision	15	√		0
SHIP	INVOICEAMOUNTPAID	double precision	15	√		0
SHIP	INVOICEDFLAG	smallint	5	√		0
SHIP	INVOICEID	integer	10	√		null
SHIP	INVOICENO	varchar	15	√		null
SHIP	LOCATIONGROUPID	integer	10
SHIP	NOTE	blob sub_type 1	0	√		null
SHIP	NUM	varchar	35
SHIP	ORDERID	integer	10	√		0
SHIP	ORDERTYPEID	integer	10
SHIP	OWNERISFROM	smallint	5	√		1
SHIP	SHIPMENTIDENTIFICATIONNUMBER	varchar	32	√		null
SHIP	SHIPPEDBY	integer	10	√		null
SHIP	SHIPTOID	integer	10	√		0
SHIP	STATUSID	integer	10
SHIP	UPSSERVICEID	integer	10	√		null
SHIPCARTON	ADDITIONALHANDLING	smallint	5	√		null
SHIPCARTON	CARRIERID	integer	10
SHIPCARTON	CARTONNUM	integer	10
SHIPCARTON	CARTONTYPEID	integer	10	√		0
SHIPCARTON	DATECREATED	timestamp	19	√		null
SHIPCARTON	DELIVERYCONFIRMATIONID	integer	10			4
SHIPCARTON	FREIGHTAMOUNT	double precision	15	√		0
SHIPCARTON	FREIGHTWEIGHT	double precision	15	√		0
SHIPCARTON	HEIGHT	double precision	15	√		0
SHIPCARTON	ID	integer	10
SHIPCARTON	INSUREDVALUE	double precision	15	√		0
SHIPCARTON	LEN	double precision	15	√		0
SHIPCARTON	ORDERID	integer	10	√		0
SHIPCARTON	ORDERTYPEID	integer	10
SHIPCARTON	PACKAGETYPEID	integer	10			2
SHIPCARTON	SHIPID	integer	10
SHIPCARTON	SHIPPERRELEASE	smallint	5	√		null
SHIPCARTON	SIZEUOM	varchar	30	√		null
SHIPCARTON	SSCC	varchar	20	√		null
SHIPCARTON	TRACKINGNUM	varchar	30	√		null
SHIPCARTON	WEIGHTUOM	varchar	254	√		null
SHIPCARTON	WIDTH	double precision	15	√		0
SHIPCARTONPOVIEW	POID	integer	10	√		null
SHIPCARTONPOVIEW	SHIPCARTONID	integer	10	√		null
SHIPCARTONSOVIEW	SHIPCARTONID	integer	10	√		null
SHIPCARTONSOVIEW	SOID	integer	10	√		null
SHIPCARTONXOVIEW	SHIPCARTONID	integer	10	√		null
SHIPCARTONXOVIEW	XOID	integer	10	√		null
SHIPITEM	DATELASTMODIFIED	timestamp	19	√		NULL
SHIPITEM	ID	integer	10
SHIPITEM	ITEMID	integer	10	√		0
SHIPITEM	ORDERID	integer	10	√		0
SHIPITEM	ORDERITEMID	integer	10	√		0
SHIPITEM	ORDERTYPEID	integer	10
SHIPITEM	QTYSHIPPED	double precision	15	√		0
SHIPITEM	SHIPCARTONID	integer	10
SHIPITEM	SHIPID	integer	10
SHIPITEM	TAGID	integer	10	√		0
SHIPITEM	TOTALCOST	double precision	15	√		0
SHIPITEM	UOMID	integer	10
SHIPPINGIMPORT	CARTONCOST	decimal	10,2	√		null
SHIPPINGIMPORT	CARTONVOID	varchar	1	√		'N'
SHIPPINGIMPORT	CARTONWEIGHT	double precision	15	√		0
SHIPPINGIMPORT	ID	integer	10	√		null
SHIPPINGIMPORT	IGNORE	varchar	255	√		null
SHIPPINGIMPORT	SHIPCARTONID	varchar	30	√		null
SHIPPINGIMPORT	TRACKINGNUM	varchar	30	√		null
SHIPSTATUS	ID	integer	10
SHIPSTATUS	NAME	varchar	15
SHIPTERMS	ACTIVEFLAG	smallint	5			1
SHIPTERMS	ID	integer	10
SHIPTERMS	NAME	varchar	30
SHIPUPSCARTONDETAILS	COD	smallint	5			0
SHIPUPSCARTONDETAILS	CODAMOUNT	double precision	15	√		0
SHIPUPSCARTONDETAILS	CODFUNDS	integer	10	√		null
SHIPUPSCARTONDETAILS	DRYICE	smallint	5	√		0
SHIPUPSCARTONDETAILS	ICEWEIGHT	double precision	15	√		0
SHIPUPSCARTONDETAILS	ID	integer	10
SHIPUPSCARTONDETAILS	MEDICAL	smallint	5	√		0
SHIPUPSCARTONDETAILS	REGULATIONSET	varchar	5
SHIPUPSCARTONDETAILS	SHIPCARTONID	integer	10
SHIPUPSCARTONDETAILS	VERBALCONFIRMATION	smallint	5			0
SHIPUPSCARTONDETAILS	VERBALCONFIRMATIONNAME	varchar	254	√		null
SHIPUPSCARTONDETAILS	VERBALCONFIRMATIONPHONE	varchar	15	√		null
SHIPUPSDETAILS	ACCOUNTNUMBER	varchar	10	√		null
SHIPUPSDETAILS	ADDRESS	varchar	90	√		null
SHIPUPSDETAILS	CITY	varchar	30	√		null
SHIPUPSDETAILS	DELIVERYEMAILS	varchar	250	√		null
SHIPUPSDETAILS	DOCUMENTSONLY	smallint	5	√		0
SHIPUPSDETAILS	EXCEPTIONEMAILS	varchar	250	√		null
SHIPUPSDETAILS	ID	integer	10
SHIPUPSDETAILS	NOTIFICATIONEMAILS	varchar	250	√		null
SHIPUPSDETAILS	PAYMENTTYPE	integer	10
SHIPUPSDETAILS	PHONE	varchar	250	√		null
SHIPUPSDETAILS	SATURDAYDELIVERY	smallint	5	√		0
SHIPUPSDETAILS	SHIPID	integer	10
SHIPUPSDETAILS	STATEID	integer	10	√		null
SHIPUPSDETAILS	ZIP	varchar	10	√		null
SO	BILLTOADDRESS	varchar	90	√		null
SO	BILLTOCITY	varchar	30	√		null
SO	BILLTOCOUNTRYID	integer	10	√		null
SO	BILLTONAME	varchar	60	√		null
SO	BILLTOSTATEID	integer	10	√		null
SO	BILLTOZIP	varchar	10	√		null
SO	CARRIERID	integer	10	√		null
SO	COST	double precision	15	√		0
SO	CURRENCYID	integer	10	√		null
SO	CURRENCYRATE	double precision	15	√		1
SO	CUSTOMERCONTACT	varchar	30	√		null
SO	CUSTOMERID	integer	10
SO	CUSTOMERPO	varchar	25	√		null
SO	DATECOMPLETED	timestamp	19	√		null
SO	DATECREATED	timestamp	19	√		null
SO	DATEFIRSTSHIP	timestamp	19	√		null
SO	DATEISSUED	timestamp	19	√		null
SO	DATELASTMODIFIED	timestamp	19	√		null
SO	DATEREVISION	timestamp	19	√		null
SO	FOBPOINTID	integer	10
SO	ID	integer	10
SO	LOCATIONGROUPID	integer	10
SO	NOTE	blob sub_type 1	0	√		null
SO	NUM	varchar	25
SO	PAYMENTTERMSID	integer	10
SO	PRIORITYID	integer	10	√		null
SO	QBCLASSID	integer	10	√		1
SO	REGISTERID	integer	10	√		0
SO	RESIDENTIALFLAG	smallint	5	√		0
SO	REVISIONNUM	integer	10	√		0
SO	SALESMAN	varchar	30	√		null
SO	SALESMANINITIALS	varchar	5	√		null
SO	SHIPTERMSID	integer	10	√		null
SO	SHIPTOADDRESS	varchar	90	√		null
SO	SHIPTOCITY	varchar	30	√		null
SO	SHIPTOCOUNTRYID	integer	10	√		null
SO	SHIPTONAME	varchar	60	√		null
SO	SHIPTOSTATEID	integer	10	√		null
SO	SHIPTOZIP	varchar	10	√		null
SO	STATUSID	integer	10
SO	TAXRATE	double precision	15	√		0
SO	TAXRATEID	integer	10	√		null
SO	TAXRATENAME	varchar	31	√		'None'
SO	TOTALINCLUDESTAX	smallint	5	√		0
SO	TOTALTAX	double precision	15	√		0
SO	TYPEID	integer	10
SO	UPSSERVICEID	integer	10	√		null
SO	URL	varchar	256	√		null
SO	USERNAME	varchar	15	√		null
SO	VENDORPO	varchar	25	√		null
SOITEM	ADJUSTAMOUNT	double precision	15	√		0
SOITEM	ADJUSTPERCENTAGE	double precision	15	√		0
SOITEM	CUSTOMERPARTNUM	varchar	70	√		null
SOITEM	DATELASTFULFILLMENT	timestamp	19	√		null
SOITEM	DATELASTMODIFIED	timestamp	19	√		NULL
SOITEM	DATESCHEDULEDFULFILLMENT	timestamp	19			'NOW'
SOITEM	DESCRIPTION	varchar	252	√		null
SOITEM	EXCHANGESOLINEITEM	integer	10	√		0
SOITEM	ID	integer	10
SOITEM	ITEMADJUSTID	integer	10	√		null
SOITEM	MCTOTALPRICE	double precision	15	√		0
SOITEM	NOTE	blob sub_type 1	0	√		null
SOITEM	PRODUCTID	integer	10	√		null
SOITEM	PRODUCTNUM	varchar	70
SOITEM	QBCLASSID	integer	10	√		1
SOITEM	QTYFULFILLED	double precision	15	√		0
SOITEM	QTYPICKED	double precision	15	√		0
SOITEM	QTYTOFULFILL	double precision	15	√		0
SOITEM	REVLEVEL	varchar	15	√		null
SOITEM	SHOWITEMFLAG	smallint	5			1
SOITEM	SOID	integer	10
SOITEM	SOLINEITEM	integer	10
SOITEM	STATUSID	integer	10
SOITEM	TAXABLEFLAG	smallint	5	√		0
SOITEM	TAXID	integer	10	√		null
SOITEM	TAXRATE	double precision	15	√		null
SOITEM	TOTALCOST	double precision	15	√		0
SOITEM	TOTALPRICE	double precision	15	√		0
SOITEM	TYPEID	integer	10
SOITEM	UNITPRICE	double precision	15	√		0
SOITEM	UOMID	integer	10	√		null
SOITEMSTATUS	ID	integer	10
SOITEMSTATUS	NAME	varchar	15
SOITEMTOMOITEM	ID	integer	10
SOITEMTOMOITEM	MOITEMID	integer	10
SOITEMTOMOITEM	SOITEMID	integer	10
SOITEMTYPE	ID	integer	10
SOITEMTYPE	NAME	varchar	30
SOSTATUS	ID	integer	10
SOSTATUS	NAME	varchar	15
SOTYPE	ID	integer	10
SOTYPE	NAME	varchar	30
STATECONST	CODE	varchar	21	√		null
STATECONST	COUNTRYCONSTID	integer	10
STATECONST	ID	integer	10
STATECONST	NAME	varchar	30	√		null
SYSPROPERTIES	DATELASTMODIFIED	timestamp	19	√		NULL
SYSPROPERTIES	ID	integer	10
SYSPROPERTIES	OWNER	varchar	30	√		null
SYSPROPERTIES	READALLOWED	smallint	5	√		1
SYSPROPERTIES	SYSKEY	varchar	30
SYSPROPERTIES	SYSVALUE	varchar	1024
SYSPROPERTIES	WRITEALLOWED	smallint	5	√		1
SYSUSER	ACTIVEFLAG	smallint	5	√		1
SYSUSER	FIRSTNAME	varchar	15	√		null
SYSUSER	ID	integer	10
SYSUSER	INITIALS	varchar	5	√		null
SYSUSER	LASTNAME	varchar	15	√		null
SYSUSER	USERNAME	varchar	15
SYSUSER	USERPWD	varchar	30
TABLEREFERENCE	CLASSNAME	varchar	100
TABLEREFERENCE	ID	integer	10
TABLEREFERENCE	TABLEID	integer	10
TABLEREFERENCE	TABLEREFNAME	varchar	30
TAG	ACCOUNTID	integer	10			1
TAG	DATECREATED	timestamp	19	√		null
TAG	DATELASTCYCLECOUNT	timestamp	19	√		null
TAG	DATELASTMODIFIED	timestamp	19	√		null
TAG	ID	integer	10
TAG	LOCATIONID	integer	10
TAG	NUM	integer	10
TAG	PARTID	integer	10
TAG	QTY	double precision	15	√		0
TAG	QTYCOMMITTED	double precision	15	√		0
TAG	SERIALIZEDFLAG	smallint	5	√		0
TAG	TRACKINGENCODING	varchar	30			''
TAG	TYPEID	integer	10			30
TAG	USEDFLAG	smallint	5	√		0
TAG	WOITEMID	integer	10	√		null
TAGSERIALVIEW	ABBR	varchar	10	√		null
TAGSERIALVIEW	ACTIVEFLAG	smallint	5	√		null
TAGSERIALVIEW	COMMITTEDFLAG	smallint	5	√		null
TAGSERIALVIEW	DESCRIPTION	varchar	256	√		null
TAGSERIALVIEW	NAME	varchar	41	√		null
TAGSERIALVIEW	PARTTRACKINGID	integer	10	√		null
TAGSERIALVIEW	SERIALID	integer	10	√		null
TAGSERIALVIEW	SERIALNUM	varchar	41	√		null
TAGSERIALVIEW	SERIALNUMID	integer	10	√		null
TAGSERIALVIEW	SORTORDER	integer	10	√		null
TAGSERIALVIEW	TAGID	integer	10	√		null
TAGSERIALVIEW	TYPEID	integer	10	√		null
TAGTRACKINGVIEW	ABBR	varchar	10	√		null
TAGTRACKINGVIEW	ACTIVEFLAG	smallint	5	√		null
TAGTRACKINGVIEW	DESCRIPTION	varchar	256	√		null
TAGTRACKINGVIEW	INFO	varchar	41	√		null
TAGTRACKINGVIEW	INFOFORMATTED	varchar	41	√		null
TAGTRACKINGVIEW	NAME	varchar	41	√		null
TAGTRACKINGVIEW	PARTID	integer	10	√		null
TAGTRACKINGVIEW	PARTTRACKINGID	integer	10	√		null
TAGTRACKINGVIEW	SORTORDER	integer	10	√		null
TAGTRACKINGVIEW	TAGID	integer	10	√		null
TAGTRACKINGVIEW	TYPEID	integer	10	√		null
TAGTYPE	ID	integer	10
TAGTYPE	NAME	varchar	30
TAXRATE	ACCOUNTINGHASH	varchar	30	√		null
TAXRATE	ACCOUNTINGID	varchar	36	√		null
TAXRATE	ACTIVEFLAG	smallint	5	√		1
TAXRATE	CODE	varchar	5	√		null
TAXRATE	DATECREATED	timestamp	19	√		null
TAXRATE	DATELASTMODIFIED	timestamp	19	√		null
TAXRATE	DEFAULTFLAG	smallint	5	√		null
TAXRATE	DESCRIPTION	varchar	256	√		null
TAXRATE	ID	integer	10
TAXRATE	NAME	varchar	31
TAXRATE	ORDERTYPEID	integer	10	√		null
TAXRATE	RATE	double precision	15	√		0
TAXRATE	TAXACCOUNTID	integer	10	√		0
TAXRATE	TYPEID	integer	10	√		null
TAXRATE	UNITCOST	double precision	15	√		0
TAXRATE	VENDORID	integer	10	√		null
TAXRATETYPE	ID	integer	10
TAXRATETYPE	NAME	varchar	30
TIINVENTORYLOG	ID	integer	10
TIINVENTORYLOG	INFO	varchar	41	√		null
TIINVENTORYLOG	INFODATE	timestamp	19	√		null
TIINVENTORYLOG	INFODOUBLE	double precision	15	√		0
TIINVENTORYLOG	INFOINTEGER	integer	10	√		0
TIINVENTORYLOG	INVENTORYLOGID	integer	10
TIINVENTORYLOG	PARTTRACKINGID	integer	10
TIINVENTORYLOG	QTY	double precision	15	√		0
TIINVENTORYLOGSN	ID	integer	10
TIINVENTORYLOGSN	PARTTRACKINGID	integer	10
TIINVENTORYLOGSN	SERIALNUM	varchar	41	√		null
TIINVENTORYLOGSN	TIINVENTORYLOGID	integer	10
TRACKDATE	ABBR	varchar	10	√		null
TRACKDATE	INFO	timestamp	19	√		null
TRACKDATE	TAGID	integer	10	√		null
TRACKDECIMAL	ABBR	varchar	10	√		null
TRACKDECIMAL	INFO	double precision	15	√		null
TRACKDECIMAL	TAGID	integer	10	√		null
TRACKINGDATE	ID	integer	10
TRACKINGDATE	INFO	timestamp	19
TRACKINGDATE	PARTTRACKINGID	integer	10
TRACKINGDATE	TAGID	integer	10
TRACKINGDECIMAL	ID	integer	10
TRACKINGDECIMAL	INFO	double precision	15
TRACKINGDECIMAL	PARTTRACKINGID	integer	10
TRACKINGDECIMAL	TAGID	integer	10
TRACKINGINFO	ID	integer	10
TRACKINGINFO	INFO	varchar	41	√		null
TRACKINGINFO	INFODATE	timestamp	19	√		null
TRACKINGINFO	INFODOUBLE	double precision	15	√		0
TRACKINGINFO	INFOINTEGER	integer	10	√		0
TRACKINGINFO	PARTTRACKINGID	integer	10
TRACKINGINFO	QTY	double precision	15	√		0
TRACKINGINFO	RECORDID	integer	10
TRACKINGINFO	TABLEID	integer	10
TRACKINGINFOSN	ID	integer	10
TRACKINGINFOSN	PARTTRACKINGID	integer	10
TRACKINGINFOSN	SERIALNUM	varchar	41	√		null
TRACKINGINFOSN	TRACKINGINFOID	integer	10
TRACKINGINTEGER	ID	integer	10
TRACKINGINTEGER	INFO	integer	10
TRACKINGINTEGER	PARTTRACKINGID	integer	10
TRACKINGINTEGER	TAGID	integer	10
TRACKINGTEXT	ID	integer	10
TRACKINGTEXT	INFO	varchar	41
TRACKINGTEXT	PARTTRACKINGID	integer	10
TRACKINGTEXT	TAGID	integer	10
TRACKINTEGER	ABBR	varchar	10	√		null
TRACKINTEGER	INFO	integer	10	√		null
TRACKINTEGER	TAGID	integer	10	√		null
TRACKTEXT	ABBR	varchar	10	√		null
TRACKTEXT	INFO	varchar	41	√		null
TRACKTEXT	TAGID	integer	10	√		null
UOM	ACTIVEFLAG	smallint	5			1
UOM	CODE	varchar	10
UOM	DEFAULTRECORD	smallint	5	√		0
UOM	DESCRIPTION	varchar	252
UOM	ID	integer	10
UOM	INTEGRAL	smallint	5	√		0
UOM	NAME	varchar	30
UOM	READONLY	smallint	5	√		0
UOM	UOMTYPE	integer	10
UOMCONVERSION	DESCRIPTION	varchar	252
UOMCONVERSION	FACTOR	decimal	10,4	√		0
UOMCONVERSION	FROMUOMID	integer	10
UOMCONVERSION	ID	integer	10
UOMCONVERSION	MULTIPLY	decimal	10,4	√		1
UOMCONVERSION	TOUOMID	integer	10
UOMTYPE	ID	integer	10
UOMTYPE	NAME	varchar	15
UPSACCOUNT	DEFAULTFLAG	smallint	5	√		0
UPSACCOUNT	ID	integer	10
UPSACCOUNT	NUMBER	varchar	255
UPSCOD	ID	integer	10
UPSCOD	NAME	varchar	254
UPSPAYMENTTYPE	ID	integer	10
UPSPAYMENTTYPE	NAME	varchar	254
UPSRETURNSHIPMENT	ID	integer	10
UPSRETURNSHIPMENT	SHIPID	integer	10
UPSRETURNSHIPMENT	SHIPMENTIDENTIFICATIONNUMBER	varchar	32	√		null
UPSSERVICES	CODE	varchar	254
UPSSERVICES	DESCRIPTION	varchar	254
UPSSERVICES	ID	integer	10
UPSSERVICES	ORIGINATINGCOUNTRY	varchar	5
UPSVIEW	CARRIERID	integer	10	√		null
UPSVIEW	ID	integer	10	√		null
UPSVIEW	ORDERID	integer	10	√		null
UPSVIEW	ORDERNUM	varchar	25	√		null
USERACCESS	GROUPID	integer	10
USERACCESS	ID	integer	10
USERACCESS	MODIFYFLAG	smallint	5	√		0
USERACCESS	MODULENAME	varchar	256
USERACCESS	VIEWFLAG	smallint	5	√		0
USERGROUP	ID	integer	10
USERGROUP	NAME	varchar	30
USERGROUPREL	GROUPID	integer	10
USERGROUPREL	ID	integer	10
USERGROUPREL	USERID	integer	10
USERLOG	EVENTDATE	timestamp	19	√		'NOW'
USERLOG	ID	integer	10
USERLOG	ISLOGIN	smallint	5	√		0
USERLOG	USERID	integer	10			1
USERPROPERTIES	CATEGORYID	integer	10
USERPROPERTIES	ID	integer	10
USERPROPERTIES	SUBCATEGORY1	varchar	252	√		null
USERPROPERTIES	SUBCATEGORY2	varchar	41	√		null
USERPROPERTIES	SYSPROPERTY	varchar	41	√		null
USERPROPERTIES	USERID	integer	10
USERPROPERTIES	USERKEY	varchar	41
USERPROPERTIES	USERVALUE	blob sub_type 1	0
USERTOLG	DEFAULTFLAG	smallint	5	√		0
USERTOLG	ID	integer	10
USERTOLG	LOCATIONGROUPID	integer	10	√		null
USERTOLG	USERID	integer	10
VENDOR	ACCOUNTID	integer	10
VENDOR	ACCOUNTINGHASH	varchar	30	√		null
VENDOR	ACCOUNTINGID	varchar	36	√		null
VENDOR	ACCOUNTNUM	varchar	30	√		null
VENDOR	ACTIVEFLAG	smallint	5	√		1
VENDOR	CREDITLIMIT	double precision	15	√		0
VENDOR	CURRENCYID	integer	10	√		null
VENDOR	CURRENCYRATE	double precision	15	√		0
VENDOR	DATEENTERED	timestamp	19	√		null
VENDOR	DATELASTMODIFIED	timestamp	19	√		null
VENDOR	DEFAULTCARRIERID	integer	10
VENDOR	DEFAULTPAYMENTTERMSID	integer	10
VENDOR	DEFAULTSHIPTERMSID	integer	10
VENDOR	ID	integer	10
VENDOR	LASTCHANGEDUSER	varchar	15	√		null
VENDOR	LEADTIME	integer	10	√		0
VENDOR	MINORDERAMOUNT	double precision	15	√		0
VENDOR	NAME	varchar	41
VENDOR	NOTE	varchar	90	√		null
VENDOR	STATUSID	integer	10
VENDOR	SYSUSERID	integer	10	√		null
VENDOR	TAXRATEID	integer	10	√		null
VENDOR	URL	varchar	256	√		null
VENDORCONTACTVIEW	CONTACTNAME	varchar	30	√		null
VENDORCONTACTVIEW	CONTACTNUM	varchar	64	√		null
VENDORCONTACTVIEW	VENDORID	integer	10	√		null
VENDORCONTACTVIEW	VENDORNAME	varchar	41	√		null
VENDORCOSTRULE	DATECREATED	timestamp	19	√		null
VENDORCOSTRULE	DATELASTMODIFIED	timestamp	19	√		null
VENDORCOSTRULE	DESCRIPTION	varchar	252	√		null
VENDORCOSTRULE	ID	integer	10
VENDORCOSTRULE	NAME	varchar	70
VENDORCOSTRULE	PARTID	integer	10
VENDORCOSTRULE	QTY	double precision	15	√		0
VENDORCOSTRULE	UNITCOST	double precision	15	√		0
VENDORCOSTRULE	USERID	integer	10			1
VENDORCOSTRULE	VENDORID	integer	10
VENDORPARTS	DATECREATED	timestamp	19	√		NULL
VENDORPARTS	DATELASTMODIFIED	timestamp	19	√		NULL
VENDORPARTS	DEFAULTFLAG	smallint	5	√		0
VENDORPARTS	ID	integer	10
VENDORPARTS	LASTCOST	double precision	15	√		0
VENDORPARTS	LASTDATE	timestamp	19	√		null
VENDORPARTS	LEADTIME	integer	10	√		0
VENDORPARTS	PARTID	integer	10
VENDORPARTS	QTYMAX	double precision	15	√		0
VENDORPARTS	QTYMIN	double precision	15	√		0
VENDORPARTS	UOMID	integer	10
VENDORPARTS	USERID	integer	10			1
VENDORPARTS	VENDORID	integer	10
VENDORPARTS	VENDORPARTNUMBER	varchar	70
VENDORSTATUS	ID	integer	10
VENDORSTATUS	NAME	varchar	15
WATCH	ALERTLEVEL	double precision	15	√		0
WATCH	COLUMNNAME	varchar	60	√		'qtyOnHand'
WATCH	COMPARISON	integer	10			0
WATCH	CRITICALLEVEL	double precision	15	√		0
WATCH	ID	integer	10
WATCH	ITEMDESC	varchar	90	√		null
WATCH	ITEMID	integer	10
WATCH	LGSUMTYPEID	integer	10	√		null
WATCH	LOCATIONGROUPID	integer	10	√		null
WATCH	STRID	varchar	30	√		null
WATCH	SYSUSERID	integer	10
WATCH	TABLEID	integer	10
WATCH	TYPEID	integer	10			10
WATCHTYPE	ID	integer	10
WATCHTYPE	NAME	varchar	15
WO	COST	double precision	15	√		0
WO	CUSTOMERID	integer	10	√		null
WO	DATECREATED	timestamp	19	√		null
WO	DATEFINISHED	timestamp	19	√		null
WO	DATELASTMODIFIED	timestamp	19	√		null
WO	DATESCHEDULED	timestamp	19	√		null
WO	DATESCHEDULEDTOSTART	timestamp	19	√		null
WO	DATESTARTED	timestamp	19	√		null
WO	ID	integer	10
WO	LOCATIONGROUPID	integer	10	√		null
WO	LOCATIONID	integer	10	√		null
WO	MOITEMID	integer	10
WO	NOTE	blob sub_type 1	0	√		null
WO	NUM	varchar	30
WO	PRIORITYID	integer	10	√		null
WO	QBCLASSID	integer	10	√		1
WO	QTYORDERED	integer	10	√		0
WO	QTYSCRAPPED	integer	10	√		0
WO	QTYTARGET	integer	10	√		0
WO	STATUSID	integer	10
WO	TYPEID	integer	10	√		null
WO	USERID	integer	10			1
WOASSIGNEDUSERS	ID	integer	10
WOASSIGNEDUSERS	USERID	integer	10			1
WOASSIGNEDUSERS	WOID	integer	10			1
WOITEM	COST	double precision	15	√		0
WOITEM	DESCRIPTION	varchar	256	√		null
WOITEM	ID	integer	10
WOITEM	MOITEMID	integer	10
WOITEM	PARTID	integer	10	√		null
WOITEM	QTYSCRAPPED	double precision	15			0
WOITEM	QTYTARGET	double precision	15			0
WOITEM	QTYUSED	double precision	15			0
WOITEM	SORTID	integer	10			1
WOITEM	TYPEID	integer	10	√		10
WOITEM	UOMID	integer	10	√		null
WOITEM	WOID	integer	10
WOMOVIEW	MOID	integer	10	√		null
WOMOVIEW	WOID	integer	10	√		null
WOSTATUS	ID	integer	10
WOSTATUS	NAME	varchar	15
XO	CARRIERID	integer	10
XO	DATECOMPLETED	timestamp	19	√		null
XO	DATECONFIRMED	timestamp	19	√		null
XO	DATECREATED	timestamp	19	√		null
XO	DATEFIRSTSHIP	timestamp	19	√		null
XO	DATEISSUED	timestamp	19	√		null
XO	DATELASTMODIFIED	timestamp	19	√		null
XO	DATESCHEDULED	timestamp	19	√		null
XO	FROMADDRESS	varchar	90	√		null
XO	FROMATTN	varchar	30	√		null
XO	FROMCITY	varchar	30	√		null
XO	FROMCOUNTRYID	integer	10	√		null
XO	FROMLGID	integer	10
XO	FROMNAME	varchar	41	√		null
XO	FROMSTATEID	integer	10	√		null
XO	FROMZIP	varchar	10	√		null
XO	ID	integer	10
XO	MAINLOCATIONTAGID	integer	10	√		null
XO	NOTE	blob sub_type 1	0	√		null
XO	NUM	varchar	25
XO	OWNERISFROM	smallint	5	√		1
XO	REVISIONNUM	integer	10	√		0
XO	SHIPTOADDRESS	varchar	90	√		null
XO	SHIPTOATTN	varchar	30	√		null
XO	SHIPTOCITY	varchar	30	√		null
XO	SHIPTOCOUNTRYID	integer	10	√		null
XO	SHIPTOLGID	integer	10
XO	SHIPTONAME	varchar	41	√		null
XO	SHIPTOSTATEID	integer	10	√		null
XO	SHIPTOZIP	varchar	10	√		null
XO	STATUSID	integer	10			10
XO	TYPEID	integer	10			10
XO	USERID	integer	10			1
XOITEM	DATELASTFULFILLMENT	timestamp	19	√		null
XOITEM	DATESCHEDULEDFULFILLMENT	timestamp	19			'NOW'
XOITEM	DESCRIPTION	varchar	256	√		null
XOITEM	ID	integer	10
XOITEM	LINEITEM	integer	10
XOITEM	NOTE	blob sub_type 1	0	√		null
XOITEM	PARTID	integer	10	√		null
XOITEM	PARTNUM	varchar	70
XOITEM	QTYFULFILLED	double precision	15	√		0
XOITEM	QTYPICKED	double precision	15	√		0
XOITEM	QTYTOFULFILL	double precision	15	√		0
XOITEM	REVISIONNUM	integer	10	√		0
XOITEM	STATUSID	integer	10			10
XOITEM	TOTALCOST	double precision	15	√		0
XOITEM	TYPEID	integer	10			10
XOITEM	UOMID	integer	10	√		null
XOITEM	XOID	integer	10
XOITEMSTATUS	ID	integer	10
XOITEMSTATUS	NAME	varchar	15
XOITEMTYPE	ID	integer	10
XOITEMTYPE	NAME	varchar	15
XOSTATUS	ID	integer	10
XOSTATUS	NAME	varchar	20
XOTYPE	ID	integer	10
XOTYPE	NAME	varchar	30