SchemaSpy - Z:\\Dropbox\\git\\FishbowlDataDictionary\\data\\FishbowlDB_Latest.FDB

Community Fishbowl Inventory Data Dictionary

Generated by SchemaSpy on Sat Mar 01 08:31 PST 2014

Legend:

Primary key columns

Columns with indexes

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

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