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
DATABASEVERSION	ALTERCOMMAND	blob sub_type 1	0	√	null
PRICINGRULE	DESCRIPTION	blob sub_type 1	0	√	null
REPORT	DESCRIPTION	blob sub_type 1	0	√	null
PART	DETAILS	blob sub_type 1	0	√	null
PRODUCT	DETAILS	blob sub_type 1	0	√	null
FBSCHEDULEHISTORY	ERROR	blob sub_type 1	0	√	null
BOMITEM	INSTRUCTIONNOTE	blob sub_type 1	0	√	null
MOITEM	INSTRUCTIONNOTE	blob sub_type 1	0	√	null
MEMO	MEMO	blob sub_type 1	0	√	null
POSTRANSACTION	MISCCREDITCARD	blob sub_type 1	0	√	null
BOM	NOTE	blob sub_type 1	0	√	null
CALEVENT	NOTE	blob sub_type 1	0	√	null
KITITEM	NOTE	blob sub_type 1	0	√	null
MO	NOTE	blob sub_type 1	0	√	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
WO	NOTE	blob sub_type 1	0	√	null
XO	NOTE	blob sub_type 1	0	√	null
XOITEM	NOTE	blob sub_type 1	0	√	null
INVLOGTRACKINGSUMMARY	TRACKVALUE	blob sub_type 1	0	√	null
USERPROPERTIES	USERVALUE	blob sub_type 1	0
SHIPPINGIMPORT	CARTONCOST	decimal	10,2	√	null
UOMCONVERSION	FACTOR	decimal	10,4	√	0
UOMCONVERSION	MULTIPLY	decimal	10,4	√	1
PAYMENTTERMS	DISCOUNT	decimal	12,5	√	0
SOITEM	ADJUSTAMOUNT	double precision	15	√	0
SOITEM	ADJUSTPERCENTAGE	double precision	15	√	0
WATCH	ALERTLEVEL	double precision	15	√	0
ITEMADJUST	AMOUNT	double precision	15	√	0
POST	AMOUNT	double precision	15	√	0
POSTRANSACTION	AMOUNT	double precision	15	√	0
PARTCOST	AVGCOST	double precision	15	√	0
RECEIPTITEM	BILLEDTOTALCOST	double precision	15	√	0
SHIPPINGIMPORT	CARTONWEIGHT	double precision	15	√	0
POSTRANSACTION	CHANGE	double precision	15	√	0
INVENTORYLOG	CHANGEQTY	double precision	15	√	0
SHIPUPSCARTONDETAILS	CODAMOUNT	double precision	15	√	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
CUSTOMER	CREDITLIMIT	double precision	15	√	0
VENDOR	CREDITLIMIT	double precision	15	√	0
WATCH	CRITICALLEVEL	double precision	15	√	0
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
PART	CYCLECOUNTTOL	double precision	15	√	0
KITITEM	DEFAULTQTY	double precision	15	√	0
SHIPCARTON	FREIGHTAMOUNT	double precision	15	√	0
SHIPCARTON	FREIGHTWEIGHT	double precision	15	√	0
PART	HEIGHT	double precision	15	√	0
PRODUCT	HEIGHT	double precision	15	√	0
SHIPCARTON	HEIGHT	double precision	15	√	0
SHIPUPSCARTONDETAILS	ICEWEIGHT	double precision	15	√	0
CUSTOMDECIMAL	INFO	double precision	15	√	0
TRACKDECIMAL	INFO	double precision	15	√	null
TRACKINGDECIMAL	INFO	double precision	15
TIINVENTORYLOG	INFODOUBLE	double precision	15	√	0
TRACKINGINFO	INFODOUBLE	double precision	15	√	0
SHIPCARTON	INSUREDVALUE	double precision	15	√	0
SHIP	INVOICEAMOUNT	double precision	15	√	0
SHIP	INVOICEAMOUNTPAID	double precision	15	√	0
RECEIPTITEM	LANDEDTOTALCOST	double precision	15	√	0
VENDORPARTS	LASTCOST	double precision	15	√	0
CUSTOMERPARTS	LASTPRICE	double precision	15	√	0
PART	LEN	double precision	15	√	0
PRODUCT	LEN	double precision	15	√	0
SHIPCARTON	LEN	double precision	15	√	0
BOMITEM	MAXQTY	double precision	15	√	null
KITITEM	MAXQTY	double precision	15	√	0
SOITEM	MCTOTALPRICE	double precision	15	√	0
VENDOR	MINORDERAMOUNT	double precision	15	√	0
BOMITEM	MINQTY	double precision	15	√	null
KITITEM	MINQTY	double precision	15	√	0
PARTREORDER	ORDERUPTOLEVEL	double precision	15	√	0
COSTLAYER	ORGQTY	double precision	15	√	0
COSTLAYER	ORGTOTALCOST	double precision	15	√	0
PRICINGRULE	PAAMOUNT	double precision	15	√	0
PRICINGRULE	PAPERCENT	double precision	15	√	0
ITEMADJUST	PERCENTAGE	double precision	15	√	0
POSTPOITEM	POSTEDTOTALCOST	double precision	15	√	0
POSTSOITEM	POSTEDTOTALCOST	double precision	15	√	0
POSTXOITEM	POSTEDTOTALCOST	double precision	15	√	0
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
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
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
POITEM	QTYPICKED	double precision	15	√	0
SOITEM	QTYPICKED	double precision	15	√	0
XOITEM	QTYPICKED	double precision	15	√	0
KITITEM	QTYPRICEADJUSTMENT	double precision	15	√	0
WOITEM	QTYSCRAPPED	double precision	15		0
SHIPITEM	QTYSHIPPED	double precision	15	√	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
PART	RECEIVINGTOL	double precision	15	√	0
PARTREORDER	REORDERPOINT	double precision	15	√	0
PRICINGRULE	RNDPMAMOUNT	double precision	15	√	0
PRICINGRULE	RNDTOAMOUNT	double precision	15	√	0
PART	STDCOST	double precision	15	√	0
POSTPOITEM	STDCOST	double precision	15	√	0
POITEM	TAXRATE	double precision	15	√	0
RECEIPTITEM	TAXRATE	double precision	15	√	0
SO	TAXRATE	double precision	15	√	0
SOITEM	TAXRATE	double precision	15	√	null
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
SOITEM	TOTALPRICE	double precision	15	√	0
PO	TOTALTAX	double precision	15	√	null
SO	TOTALTAX	double precision	15	√	0
POITEM	UNITCOST	double precision	15	√	0
TAXRATE	UNITCOST	double precision	15	√	0
VENDORCOSTRULE	UNITCOST	double precision	15	√	0
SOITEM	UNITPRICE	double precision	15	√	0
FEDEXVIEW	WEIGHT	double precision	15	√	null
PART	WEIGHT	double precision	15	√	0
PRODUCT	WEIGHT	double precision	15	√	0
PART	WIDTH	double precision	15	√	0
PRODUCT	WIDTH	double precision	15	√	0
SHIPCARTON	WIDTH	double precision	15	√	0
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
FBSCHEDULE	ACTIONTYPEID	integer	10
CONTACT	ADDRESSID	integer	10	√	null
PART	ADJUSTMENTACCOUNTID	integer	10	√	0
ASSOCPRICE	ASSOCPRICETYPEID	integer	10
BOM	AUTOCREATETYPEID	integer	10	√	null
INVENTORYLOG	BEGLOCATIONID	integer	10
INVENTORYLOG	BEGTAGNUM	integer	10	√	0
SO	BILLTOCOUNTRYID	integer	10	√	null
SO	BILLTOSTATEID	integer	10	√	null
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
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
FEDEXVIEW	CARTONCOUNT	integer	10	√	null
SHIP	CARTONCOUNT	integer	10	√	0
FEDEXVIEW	CARTONID	integer	10	√	null
SHIPCARTON	CARTONNUM	integer	10
SHIPCARTON	CARTONTYPEID	integer	10	√	0
USERPROPERTIES	CATEGORYID	integer	10
CUSTOMFIELDVIEW	CFID	integer	10	√	null
CUSTOMFIELDVIEW	CFSORTORDER	integer	10	√	null
CUSTOMFIELDVIEW	CFTABLEID	integer	10	√	null
CUSTOMFIELDVIEW	CFTYPEID	integer	10	√	null
SHIPUPSCARTONDETAILS	CODFUNDS	integer	10	√	null
PART	COGSACCOUNTID	integer	10	√	0
WATCH	COMPARISON	integer	10		0
INVENTORYLOGTOCOSTLAYER	COSTLAYERID	integer	10
STATECONST	COUNTRYCONSTID	integer	10
ADDRESS	COUNTRYID	integer	10	√	null
ADDRESSMULTILINEVIEW	COUNTRYID	integer	10	√	null
CUSTOMER	CURRENCYID	integer	10	√	null
PO	CURRENCYID	integer	10	√	null
SO	CURRENCYID	integer	10	√	null
VENDOR	CURRENCYID	integer	10	√	null
CUSTOMERCONTACTVIEW	CUSTID	integer	10	√	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
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	DEFAULTBOMID	integer	10	√	10
COMPANY	DEFAULTCARRIERID	integer	10
CUSTOMER	DEFAULTCARRIERID	integer	10	√	0
VENDOR	DEFAULTCARRIERID	integer	10
LOCATION	DEFAULTCUSTOMERID	integer	10	√	null
CUSTOMER	DEFAULTPAYMENTTERMSID	integer	10
VENDOR	DEFAULTPAYMENTTERMSID	integer	10
PART	DEFAULTPRODUCTID	integer	10	√	null
CUSTOMER	DEFAULTSALESMANID	integer	10	√	0
CUSTOMER	DEFAULTSHIPSERVICEID	integer	10	√	null
CUSTOMER	DEFAULTSHIPTERMSID	integer	10
VENDOR	DEFAULTSHIPTERMSID	integer	10
PRODUCT	DEFAULTSOITEMTYPE	integer	10	√	10
LOCATION	DEFAULTVENDORID	integer	10	√	null
SHIPCARTON	DELIVERYCONFIRMATIONID	integer	10		4
POSTRANSACTION	DEPOSITTOACCOUNTID	integer	10	√	0
PICKITEM	DESTTAGID	integer	10	√	0
PAYMENTTERMS	DISCOUNTDAYS	integer	10	√	0
KITITEM	DISCOUNTID	integer	10	√	null
PRODUCT	DISPLAYTYPEID	integer	10	√	10
INVENTORYLOG	ENDLOCATIONID	integer	10
INVENTORYLOG	ENDTAGNUM	integer	10	√	0
BOM	ESTIMATEDDURATION	integer	10	√	0
SOITEM	EXCHANGESOLINEITEM	integer	10	√	0
ITEMADJUST	EXPENSEASACCOUNTID	integer	10	√	0
POSTPO	EXTTXNNUMBER	integer	10	√	null
POSTSO	EXTTXNNUMBER	integer	10	√	null
POSTWO	EXTTXNNUMBER	integer	10	√	null
POSTXO	EXTTXNNUMBER	integer	10	√	null
PO	FOBPOINTID	integer	10
SHIP	FOBPOINTID	integer	10
SO	FOBPOINTID	integer	10
XO	FROMCOUNTRYID	integer	10	√	null
XO	FROMLGID	integer	10
XO	FROMSTATEID	integer	10	√	null
UOMCONVERSION	FROMUOMID	integer	10
ACCOUNTGROUPRELATION	GROUPID	integer	10	√	null
USERACCESS	GROUPID	integer	10
USERGROUPREL	GROUPID	integer	10
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
PRODUCT	INCOMEACCOUNTID	integer	10	√	0
ITEMADJUST	INCOMEASACCOUNTID	integer	10	√	0
CUSTOMINTEGER	INFO	integer	10		0
TRACKINGINTEGER	INFO	integer	10
TRACKINTEGER	INFO	integer	10	√	null
TIINVENTORYLOG	INFOINTEGER	integer	10	√	0
TRACKINGINFO	INFOINTEGER	integer	10	√	0
PART	INVENTORYACCOUNTID	integer	10	√	0
INVENTORYLOGTOCOSTLAYER	INVENTORYLOGID	integer	10
TIINVENTORYLOG	INVENTORYLOGID	integer	10
INVLOGTRACKINGSUMMARY	INVLOGID	integer	10	√	null
SHIP	INVOICEID	integer	10	√	null
RMAITEM	ISSUEID	integer	10	√	null
SOITEM	ITEMADJUSTID	integer	10	√	null
SHIPITEM	ITEMID	integer	10	√	0
WATCH	ITEMID	integer	10
CUSTOMER	JOBDEPTH	integer	10	√	1
KITOPTION	KITITEMID	integer	10
KITITEM	KITITEMTYPEID	integer	10
KITITEM	KITPRODUCTID	integer	10
KITITEM	KITTYPEID	integer	10
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
PART	LEADTIME	integer	10	√	0
VENDOR	LEADTIME	integer	10	√	0
VENDORPARTS	LEADTIME	integer	10	√	0
PART	LEADTIMETOFULFILL	integer	10	√	0
WATCH	LGSUMTYPEID	integer	10	√	null
XOITEM	LINEITEM	integer	10
RMAITEM	LINENUM	integer	10
CUSTOMFIELD	LISTID	integer	10	√	null
CUSTOMLISTITEM	LISTID	integer	10	√	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
REPORTTOMODULE	MODULEID	integer	10
MOITEM	MOID	integer	10	√	null
WOMOVIEW	MOID	integer	10	√	null
SOITEMTOMOITEM	MOITEMID	integer	10
WO	MOITEMID	integer	10
WOITEM	MOITEMID	integer	10
PAYMENTTERMS	NETDAYS	integer	10	√	0
PAYMENTTERMS	NEXTMONTH	integer	10	√	0
TAG	NUM	integer	10
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
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
RECEIPTITEM	PACKAGECOUNT	integer	10	√	1
SHIPCARTON	PACKAGETYPEID	integer	10		2
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
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
POSTRANSACTION	PAYMENTMETHODID	integer	10
PO	PAYMENTTERMSID	integer	10
SO	PAYMENTTERMSID	integer	10
SHIPUPSDETAILS	PAYMENTTYPE	integer	10
PICKITEM	PICKID	integer	10
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
POSTPOITEM	POSTPOID	integer	10
POSTSOITEM	POSTSOID	integer	10
POSTWOITEM	POSTWOID	integer	10
POSTXOITEM	POSTXOID	integer	10
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
RMAITEM	PRODUCTSUBID	integer	10	√	null
PRODUCTTOTREE	PRODUCTTREEID	integer	10
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
WO	QTYORDERED	integer	10	√	0
WO	QTYSCRAPPED	integer	10	√	0
WO	QTYTARGET	integer	10	√	0
RECEIPTITEM	RECEIPTID	integer	10
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
POST	REFID	integer	10	√	0
POST	REFITEMID	integer	10	√	0
SO	REGISTERID	integer	10	√	0
PO	REMITCOUNTRYID	integer	10	√	null
PO	REMITSTATEID	integer	10	√	null
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
RMAITEM	RESOLUTIONID	integer	10	√	null
RECEIPTITEM	RESPONSIBILITYID	integer	10	√	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
RMAITEM	RMAID	integer	10
FBSCHEDULEHISTORY	SCHEDULEID	integer	10
FBSCHEDULEREPORTPARAMETER	SCHEDULEID	integer	10
PART	SCRAPACCOUNTID	integer	10	√	0
SERIALNUM	SERIALID	integer	10
TAGSERIALVIEW	SERIALID	integer	10	√	null
TAGSERIALVIEW	SERIALNUMID	integer	10	√	null
SHIPCARTONPOVIEW	SHIPCARTONID	integer	10	√	null
SHIPCARTONSOVIEW	SHIPCARTONID	integer	10	√	null
SHIPCARTONXOVIEW	SHIPCARTONID	integer	10	√	null
SHIPITEM	SHIPCARTONID	integer	10
SHIPUPSCARTONDETAILS	SHIPCARTONID	integer	10
SHIPCARTON	SHIPID	integer	10
SHIPITEM	SHIPID	integer	10
SHIPUPSDETAILS	SHIPID	integer	10
UPSRETURNSHIPMENT	SHIPID	integer	10
RECEIPTITEM	SHIPITEMID	integer	10	√	null
SHIP	SHIPPEDBY	integer	10	√	null
PO	SHIPTERMSID	integer	10
SO	SHIPTERMSID	integer	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	SHIPTOSTATEID	integer	10	√	null
SO	SHIPTOSTATEID	integer	10	√	null
XO	SHIPTOSTATEID	integer	10	√	null
PART	SIZEUOMID	integer	10	√	2
PRODUCT	SIZEUOMID	integer	10	√	2
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	SPCBUYX	integer	10	√	0
PRICINGRULE	SPCGETYFREE	integer	10	√	0
PICKITEM	SRCLOCATIONID	integer	10	√	null
PICKITEM	SRCTAGID	integer	10	√	null
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
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
CURRENCY	SYMBOL	integer	10	√	NULL
CUSTOMER	SYSUSERID	integer	10	√	null
VENDOR	SYSUSERID	integer	10	√	null
WATCH	SYSUSERID	integer	10
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
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
TAXRATE	TAXACCOUNTID	integer	10	√	0
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
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
TIINVENTORYLOGSN	TIINVENTORYLOGID	integer	10
UOMCONVERSION	TOUOMID	integer	10
TRACKINGINFOSN	TRACKINGINFOID	integer	10
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
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
SHIP	UPSSERVICEID	integer	10	√	null
SO	UPSSERVICEID	integer	10	√	null
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
PART	VARIANCEACCOUNTID	integer	10	√	0
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
DATABASEVERSION	VERSION	integer	10
PART	WEIGHTUOMID	integer	10	√	1
PRODUCT	WEIGHTUOMID	integer	10	√	3
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
ADDRESSMULTILINEXOVIEW	XOID	integer	10	√	null
POSTXO	XOID	integer	10
SHIPCARTONXOVIEW	XOID	integer	10	√	null
XOITEM	XOID	integer	10
POSTXOITEM	XOITEMID	integer	10	√	null
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
BOMITEM	ADDTOSERVICE	smallint	5	√	0
MOITEM	ADDTOSERVICE	smallint	5	√	0
CALEVENT	ALLDAY	smallint	5		0
REPORTSECURITY	ALLOW	smallint	5	√	1
PART	ALWAYSMANUFACTURE	smallint	5	√	0
INTEGRATEDAPP	AUTHORIZED	smallint	5		0
RECEIPTITEM	BILLVENDORFLAG	smallint	5	√	1
CUSTOMFIELDVIEW	CFREQUIRED	smallint	5	√	null
SHIPUPSCARTONDETAILS	COD	smallint	5		0
SERIAL	COMMITTEDFLAG	smallint	5	√	0
TAGSERIALVIEW	COMMITTEDFLAG	smallint	5	√	null
BOM	CONFIGURABLE	smallint	5	√	0
PART	CONFIGUREABLE	smallint	5	√	0
PART	CONTROLLEDFLAG	smallint	5	√	0
LOCATION	COUNTEDASAVAILABLE	smallint	5	√	1
RMAITEM	CROSSSHIPFLAG	smallint	5	√	0
PRICINGRULE	CUSTOMERINCLTYPEID	smallint	5
PRICINGRULE	DATEAPPLIES	smallint	5	√	0
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
UOM	DEFAULTRECORD	smallint	5	√	0
PAYMENTTERMS	DEFAULTTERM	smallint	5	√	0
SHIPUPSDETAILS	DOCUMENTSONLY	smallint	5	√	0
SHIPUPSCARTONDETAILS	DRYICE	smallint	5	√	0
PAYMENTMETHOD	EDITABLE	smallint	5		1
BOMITEM	GROUPDEFAULT	smallint	5	√	1
UOM	INTEGRAL	smallint	5	√	0
SHIP	INVOICEDFLAG	smallint	5	√	0
PRICINGRULE	ISACTIVE	smallint	5	√	1
PRICINGRULE	ISAUTOAPPLY	smallint	5	√	1
USERLOG	ISLOGIN	smallint	5	√	0
MODULE	ISMODULE	smallint	5
PRICINGRULE	ISTIER2	smallint	5	√	0
PRODUCT	KITFLAG	smallint	5		0
PRODUCT	KITGROUPEDFLAG	smallint	5	√	0
SHIPUPSCARTONDETAILS	MEDICAL	smallint	5	√	0
USERACCESS	MODIFYFLAG	smallint	5	√	0
BOMITEM	ONETIMEITEM	smallint	5	√	0
MOITEM	ONETIMEITEM	smallint	5	√	0
SHIP	OWNERISFROM	smallint	5	√	1
XO	OWNERISFROM	smallint	5	√	1
PRICINGRULE	PAAPPLIES	smallint	5	√	1
PRICINGRULE	PABASEAMOUNTTYPEID	smallint	5	√	3
PRICINGRULE	PATYPEID	smallint	5	√	1
LOCATION	PICKABLE	smallint	5	√	1
BOM	PICKFROMLOCATION	smallint	5	√	0
PART	PICKINUOMOFPART	smallint	5	√	0
PARTTOTRACKING	PRIMARYFLAG	smallint	5	√	0
PRICINGRULE	PRODUCTINCLTYPEID	smallint	5
PRICINGRULE	QTYAPPLIES	smallint	5	√	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
LOCATION	RECEIVABLE	smallint	5	√	1
POITEM	REPAIRFLAG	smallint	5	√	0
CUSTOMFIELD	REQUIRED	smallint	5	√	0
ADDRESS	RESIDENTIALFLAG	smallint	5	√	0
ADDRESSMULTILINEVIEW	RESIDENTIALFLAG	smallint	5	√	null
SO	RESIDENTIALFLAG	smallint	5	√	0
RMAITEM	RETURNFLAG	smallint	5	√	0
PRICINGRULE	RNDAPPLIES	smallint	5	√	0
PRICINGRULE	RNDISMINUS	smallint	5	√	1
PRICINGRULE	RNDTYPEID	smallint	5	√	2
SHIPUPSDETAILS	SATURDAYDELIVERY	smallint	5	√	0
PRODUCT	SELLABLEINOTHERUOMS	smallint	5	√	1
PART	SERIALIZEDFLAG	smallint	5	√	0
TAG	SERIALIZEDFLAG	smallint	5	√	0
RMAITEM	SHIPFLAG	smallint	5	√	0
SHIPCARTON	SHIPPERRELEASE	smallint	5	√	null
SOITEM	SHOWITEMFLAG	smallint	5		1
PRODUCT	SHOWSOCOMBOFLAG	smallint	5		1
PRICINGRULE	SPCAPPLIES	smallint	5	√	0
BOMITEM	STAGE	smallint	5	√	0
MOITEM	STAGE	smallint	5	√	0
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
COMPANY	TAXEXEMPT	smallint	5	√	0
CUSTOMER	TAXEXEMPT	smallint	5	√	0
POITEM	TBDCOSTFLAG	smallint	5	√	0
PO	TOTALINCLUDESTAX	smallint	5	√	0
SO	TOTALINCLUDESTAX	smallint	5	√	0
PART	TRACKINGFLAG	smallint	5	√	0
COUNTRYCONST	UPS	smallint	5		1
TAG	USEDFLAG	smallint	5	√	0
BOMITEM	USEITEMLOCATION	smallint	5	√	0
PRODUCT	USEPRICEFLAG	smallint	5		1
BOMITEM	VARIABLEQTY	smallint	5	√	0
SHIPUPSCARTONDETAILS	VERBALCONFIRMATION	smallint	5		0
USERACCESS	VIEWFLAG	smallint	5	√	0
SYSPROPERTIES	WRITEALLOWED	smallint	5	√	1
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
INVENTORYLOG	EVENTDATE	timestamp	19	√	'NOW'
USERLOG	EVENTDATE	timestamp	19	√	'NOW'
POSTRANSACTION	EXPDATE	timestamp	19	√	null
CUSTOMTIMESTAMP	INFO	timestamp	19
TRACKDATE	INFO	timestamp	19	√	null
TRACKINGDATE	INFO	timestamp	19
TIINVENTORYLOG	INFODATE	timestamp	19	√	null
TRACKINGINFO	INFODATE	timestamp	19	√	null
INTEGRATEDAPP	LASTACTIVITY	timestamp	19	√	null
VENDORPARTS	LASTDATE	timestamp	19	√	null
FBSCHEDULEHISTORY	LASTRUNTIME	timestamp	19	√	null
POSTPO	POSTDATE	timestamp	19	√	null
POSTSO	POSTDATE	timestamp	19	√	null
POSTWO	POSTDATE	timestamp	19	√	null
POSTXO	POSTDATE	timestamp	19	√	null
PART	ABCCODE	varchar	1	√	'N'
SHIPPINGIMPORT	CARTONVOID	varchar	1	√	'N'
CARRIER	SCAC	varchar	4	√	null
TAXRATE	CODE	varchar	5	√	null
SYSUSER	INITIALS	varchar	5	√	null
UPSSERVICES	ORIGINATINGCOUNTRY	varchar	5
SHIPUPSCARTONDETAILS	REGULATIONSET	varchar	5
SO	SALESMANINITIALS	varchar	5	√	null
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
SHIPUPSDETAILS	ACCOUNTNUMBER	varchar	10	√	null
SO	BILLTOZIP	varchar	10	√	null
UOM	CODE	varchar	10
XO	FROMZIP	varchar	10	√	null
PO	REMITZIP	varchar	10	√	null
FEDEXVIEW	SHIPTOCOUNTRY	varchar	10	√	null
FEDEXVIEW	SHIPTOZIP	varchar	10	√	null
PO	SHIPTOZIP	varchar	10	√	null
SO	SHIPTOZIP	varchar	10	√	null
XO	SHIPTOZIP	varchar	10	√	null
ADDRESS	ZIP	varchar	10	√	null
ADDRESSMULTILINEVIEW	ZIP	varchar	10	√	null
SHIPUPSDETAILS	ZIP	varchar	10	√	null
COMPANY	ABN	varchar	14	√	null
INTEGRATEDAPP	APPKEY	varchar	15
COMPANY	EANUCCPREFIX	varchar	15	√	null
SYSUSER	FIRSTNAME	varchar	15	√	null
SHIP	INVOICENO	varchar	15	√	null
COMPANY	LASTCHANGEDUSER	varchar	15	√	null
CUSTOMER	LASTCHANGEDUSER	varchar	15	√	null
PART	LASTCHANGEDUSER	varchar	15	√	null
VENDOR	LASTCHANGEDUSER	varchar	15	√	null
SYSUSER	LASTNAME	varchar	15	√	null
ACCOUNTTYPE	NAME	varchar	15
ADDRESSTYPE	NAME	varchar	15
CONTACTTYPE	NAME	varchar	15
COSTLAYERSTATUS	NAME	varchar	15
CUSTOMERSTATUS	NAME	varchar	15
FOBPOINT	NAME	varchar	15
LOCATIONTYPE	NAME	varchar	15
ORDERTYPE	NAME	varchar	15
POITEMSTATUS	NAME	varchar	15
POITEMTYPE	NAME	varchar	15
POSTATUS	NAME	varchar	15
POSTSTATUS	NAME	varchar	15
RECEIPTITEMSTATUS	NAME	varchar	15
RECEIPTITEMTYPE	NAME	varchar	15
RECEIPTSTATUS	NAME	varchar	15
RECEIPTTYPE	NAME	varchar	15
REGISTER	NAME	varchar	15
RESPONSIBILITY	NAME	varchar	15
SHIPSTATUS	NAME	varchar	15
SOITEMSTATUS	NAME	varchar	15
SOSTATUS	NAME	varchar	15
UOMTYPE	NAME	varchar	15
VENDORSTATUS	NAME	varchar	15
WATCHTYPE	NAME	varchar	15
WOSTATUS	NAME	varchar	15
XOITEMSTATUS	NAME	varchar	15
XOITEMTYPE	NAME	varchar	15
PART	REV	varchar	15	√	null
POITEM	REVLEVEL	varchar	15	√	null
SOITEM	REVLEVEL	varchar	15	√	null
MEMO	USERNAME	varchar	15	√	null
PO	USERNAME	varchar	15	√	null
SO	USERNAME	varchar	15	√	null
SYSUSER	USERNAME	varchar	15
SHIPUPSCARTONDETAILS	VERBALCONFIRMATIONPHONE	varchar	15	√	null
POST	EDITSEQUENCE	varchar	16	√	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
POSTRANSACTION	AUTHCODE	varchar	20	√	null
SHIP	BILLOFLADING	varchar	20	√	null
POSTRANSACTION	MERCHANTACTNUM	varchar	20	√	null
LGSUMTYPE	NAME	varchar	20
PARTTRACKINGTYPE	NAME	varchar	20
XOSTATUS	NAME	varchar	20
RECEIPTITEM	REFNO	varchar	20	√	null
POST	REFNUMBER	varchar	20	√	null
SHIPCARTON	SSCC	varchar	20	√	null
POSTRANSACTION	TRANSACTIONID	varchar	20	√	null
STATECONST	CODE	varchar	21	√	null
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
FEDEXVIEW	SHIPTOSTATE	varchar	21	√	null
SO	CUSTOMERPO	varchar	25	√	null
PO	CUSTOMERSO	varchar	25	√	null
MO	NUM	varchar	25
PO	NUM	varchar	25
RMA	NUM	varchar	25
SO	NUM	varchar	25
XO	NUM	varchar	25
FEDEXVIEW	ORDERNUM	varchar	25	√	null
UPSVIEW	ORDERNUM	varchar	25	√	null
FEDEXVIEW	PONUM	varchar	25	√	null
SO	VENDORPO	varchar	25	√	null
RMAITEM	VENDORRMA	varchar	25	√	null
PO	VENDORSO	varchar	25	√	null
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
VENDOR	ACCOUNTNUM	varchar	30	√	null
SO	BILLTOCITY	varchar	30	√	null
PO	BUYER	varchar	30	√	null
ADDRESS	CITY	varchar	30	√	null
ADDRESSMULTILINEVIEW	CITY	varchar	30	√	null
SHIPUPSDETAILS	CITY	varchar	30	√	null
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
SO	CUSTOMERCONTACT	varchar	30	√	null
PO	DELIVERTO	varchar	30	√	null
RECEIPTITEM	DELIVERTO	varchar	30	√	null
FBSCHEDULE	FILEMASK	varchar	30	√	null
FBSCHEDULE	FILENAME	varchar	30	√	null
XO	FROMATTN	varchar	30	√	null
XO	FROMCITY	varchar	30	√	null
CUSTOMVARCHAR	INFO	varchar	30
ACCOUNTGROUP	NAME	varchar	30
BOMAUTOCREATETYPE	NAME	varchar	30
BOMITEMTYPE	NAME	varchar	30
CUSTOMERINCLTYPE	NAME	varchar	30
FBSCHEDULE	NAME	varchar	30
FBSCHEDULEACTIONTYPE	NAME	varchar	30
INVENTORYLOGTYPE	NAME	varchar	30
ITEMADJUSTTYPE	NAME	varchar	30
KITDISPLAYTYPE	NAME	varchar	30
KITITEMTYPE	NAME	varchar	30
KITTYPE	NAME	varchar	30
LOCATION	NAME	varchar	30
LOCATIONGROUP	NAME	varchar	30
MOITEMSTATUS	NAME	varchar	30
MOSTATUS	NAME	varchar	30
OBJECTTOOBJECTTYPE	NAME	varchar	30
PABASEAMOUNTTYPE	NAME	varchar	30
PARTCATEGORY	NAME	varchar	30
PARTTYPE	NAME	varchar	30
PATYPE	NAME	varchar	30
PAYMENTTERMSTYPE	NAME	varchar	30
PAYMENTTYPE	NAME	varchar	30
PICKITEMSTATUS	NAME	varchar	30
PICKITEMTYPE	NAME	varchar	30
PICKSTATUS	NAME	varchar	30
PICKTYPE	NAME	varchar	30
POSTORDERSTATUS	NAME	varchar	30
POSTTYPE	NAME	varchar	30
POTYPE	NAME	varchar	30
PRIORITY	NAME	varchar	30
PRODUCTINCLTYPE	NAME	varchar	30
PRODUCTTREE	NAME	varchar	30
QUICKLIST	NAME	varchar	30
RMAITEMTYPE	NAME	varchar	30
RMASTATUS	NAME	varchar	30
RNDTYPE	NAME	varchar	30
SHIPTERMS	NAME	varchar	30
SOITEMTYPE	NAME	varchar	30
SOTYPE	NAME	varchar	30
STATECONST	NAME	varchar	30	√	null
TAGTYPE	NAME	varchar	30
TAXRATETYPE	NAME	varchar	30
UOM	NAME	varchar	30
USERGROUP	NAME	varchar	30
XOTYPE	NAME	varchar	30
OBJECTTOOBJECT	NOTE	varchar	30	√	null
WO	NUM	varchar	30
CUSTOMER	NUMBER	varchar	30
SYSPROPERTIES	OWNER	varchar	30	√	null
PO	REMITCITY	varchar	30	√	null
SO	SALESMAN	varchar	30	√	null
POST	SERIALNUM	varchar	30	√	null
SHIPPINGIMPORT	SHIPCARTONID	varchar	30	√	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
SHIPCARTON	SIZEUOM	varchar	30	√	null
WATCH	STRID	varchar	30	√	null
SYSPROPERTIES	SYSKEY	varchar	30
TABLEREFERENCE	TABLEREFNAME	varchar	30
COMPANY	TAXEXEMPTNUMBER	varchar	30	√	null
CUSTOMER	TAXEXEMPTNUMBER	varchar	30	√	null
TAG	TRACKINGENCODING	varchar	30		''
RECEIPTITEM	TRACKINGNUM	varchar	30	√	null
SHIPCARTON	TRACKINGNUM	varchar	30	√	null
SHIPPINGIMPORT	TRACKINGNUM	varchar	30	√	null
SYSUSER	USERPWD	varchar	30
PO	VENDORCONTACT	varchar	30	√	null
ASACCOUNTTYPE	NAME	varchar	31
ITEMADJUST	NAME	varchar	31
PAYMENTMETHOD	NAME	varchar	31
QBCLASS	NAME	varchar	31
TAXRATE	NAME	varchar	31
PRODUCT	SKU	varchar	31	√	null
PO	TAXRATENAME	varchar	31	√	null
SO	TAXRATENAME	varchar	31	√	'None'
PART	UPC	varchar	31	√	null
PRODUCT	UPC	varchar	31	√	null
CALCATEGORY	COLOR	varchar	32
SHIP	SHIPMENTIDENTIFICATIONNUMBER	varchar	32	√	null
UPSRETURNSHIPMENT	SHIPMENTIDENTIFICATIONNUMBER	varchar	32	√	null
PICK	NUM	varchar	35
SHIP	NUM	varchar	35
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
ASACCOUNT	ACCOUNTNUMBER	varchar	36	√	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
POST	TXNID	varchar	36	√	null
POST	TXNLINEID	varchar	36	√	null
CUSTOMFIELDVIEW	CFNAME	varchar	41	√	null
CUSTOMERCONTACTVIEW	CUSTNAME	varchar	41	√	null
XO	FROMNAME	varchar	41	√	null
CUSTOMSET	INFO	varchar	41	√	null
PARTTRACKINGVIEW	INFO	varchar	41	√	null
TAGTRACKINGVIEW	INFO	varchar	41	√	null
TIINVENTORYLOG	INFO	varchar	41	√	null
TRACKINGINFO	INFO	varchar	41	√	null
TRACKINGTEXT	INFO	varchar	41
TRACKTEXT	INFO	varchar	41	√	null
PARTTRACKINGVIEW	INFOFORMATTED	varchar	41	√	null
TAGTRACKINGVIEW	INFOFORMATTED	varchar	41	√	null
ASSOCPRICETYPE	NAME	varchar	41
CUSTOMER	NAME	varchar	41
CUSTOMFIELD	NAME	varchar	41
CUSTOMFIELDTYPE	NAME	varchar	41
CUSTOMLIST	NAME	varchar	41
CUSTOMLISTITEM	NAME	varchar	41
INTEGRATEDAPP	NAME	varchar	41
MODULE	NAME	varchar	41
PARTTRACKING	NAME	varchar	41
PARTTRACKINGVIEW	NAME	varchar	41	√	null
PRICINGRULE	NAME	varchar	41
PROPERTYCATEGORY	NAME	varchar	41
TAGSERIALVIEW	NAME	varchar	41	√	null
TAGTRACKINGVIEW	NAME	varchar	41	√	null
VENDOR	NAME	varchar	41
QOHVIEW	SERIALNUM	varchar	41	√	null
SERIALNUM	SERIALNUM	varchar	41
TAGSERIALVIEW	SERIALNUM	varchar	41	√	null
TIINVENTORYLOGSN	SERIALNUM	varchar	41	√	null
TRACKINGINFOSN	SERIALNUM	varchar	41	√	null
XO	SHIPTONAME	varchar	41	√	null
BOM	STATISTICSDATERANGE	varchar	41	√	null
USERPROPERTIES	SUBCATEGORY2	varchar	41	√	null
USERPROPERTIES	SYSPROPERTY	varchar	41	√	null
USERPROPERTIES	USERKEY	varchar	41
VENDORCONTACTVIEW	VENDORNAME	varchar	41	√	null
SO	BILLTONAME	varchar	60	√	null
WATCH	COLUMNNAME	varchar	60	√	'qtyOnHand'
FEDEXVIEW	COMPANYNAME	varchar	60	√	null
ADDRESS	NAME	varchar	60
ADDRESSMULTILINEVIEW	NAME	varchar	60	√	null
CARRIER	NAME	varchar	60
COMPANY	NAME	varchar	60
PAYMENTTERMS	NAME	varchar	60
POSTRANSACTION	REFERENCE	varchar	60	√	null
PO	REMITTONAME	varchar	60	√	null
FEDEXVIEW	SERVICETYPE	varchar	60	√	null
PO	SHIPTONAME	varchar	60	√	null
SO	SHIPTONAME	varchar	60	√	null
CUSTOMERCONTACTVIEW	CONTACTNUM	varchar	64	√	null
VENDORCONTACTVIEW	CONTACTNUM	varchar	64	√	null
CONTACT	DATUS	varchar	64	√	'true'
INTEGRATIONPROPERTIES	KEY	varchar	64
COUNTRYCONST	NAME	varchar	64	√	null
FBSCHEDULEREPORTPARAMETER	NAME	varchar	64
INTEGRATEDAPPSTATUS	NAME	varchar	64
INTEGRATIONTYPE	NAME	varchar	64
REPORT	NAME	varchar	64
REPORTPARAMETER	NAME	varchar	64
REPORTTREE	NAME	varchar	64
FEDEXVIEW	PHONE	varchar	64	√	null
SOITEM	CUSTOMERPARTNUM	varchar	70	√	null
CUSTOMERPARTS	CUSTOMERPARTNUMBER	varchar	70
BOMITEMGROUP	NAME	varchar	70
VENDORCOSTRULE	NAME	varchar	70
BOM	NUM	varchar	70
PART	NUM	varchar	70
PRODUCT	NUM	varchar	70
POITEM	PARTNUM	varchar	70
XOITEM	PARTNUM	varchar	70
SOITEM	PRODUCTNUM	varchar	70
POITEM	VENDORPARTNUM	varchar	70
VENDORPARTS	VENDORPARTNUMBER	varchar	70
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
ADDRESS	ADDRESSNAME	varchar	90	√	null
PART	ALERTNOTE	varchar	90	√	null
PRODUCT	ALERTNOTE	varchar	90	√	null
SO	BILLTOADDRESS	varchar	90	√	null
ORDERHISTORY	COMMENT	varchar	90	√	null
FBSCHEDULE	CRONSTRING	varchar	90	√	null
XO	FROMADDRESS	varchar	90	√	null
ADDRESSMULTILINEXOVIEW	FROMADDRESS1	varchar	90	√	null
ADDRESSMULTILINEXOVIEW	FROMADDRESS2	varchar	90	√	null
ADDRESSMULTILINEXOVIEW	FROMADDRESS3	varchar	90	√	null
WATCH	ITEMDESC	varchar	90	√	null
CUSTOMER	NOTE	varchar	90	√	null
VENDOR	NOTE	varchar	90	√	null
RECEIPTITEM	REASON	varchar	90	√	null
PO	REMITADDRESS	varchar	90	√	null
ADDRESSMULTILINEPOVIEW	REMITADDRESS1	varchar	90	√	null
ADDRESSMULTILINEPOVIEW	REMITADDRESS2	varchar	90	√	null
ADDRESSMULTILINEPOVIEW	REMITADDRESS3	varchar	90	√	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
FBSCHEDULE	ACTIONSUBTYPE	varchar	100	√	null
TABLEREFERENCE	CLASSNAME	varchar	100
INVENTORYLOG	INFO	varchar	100	√	null
CUSTOMFIELDVIEW	INFO	varchar	128	√	null
CUSTOMVARCHARLONG	INFO	varchar	128
CUSTOMFIELDVIEW	INFOFORMATTED	varchar	128	√	null
CALEVENT	LOCATION	varchar	128	√	null
CALCATEGORY	NAME	varchar	128
CALEVENT	NAME	varchar	128
ASACCOUNT	NAME	varchar	155
SHIPUPSDETAILS	DELIVERYEMAILS	varchar	250	√	null
SHIPUPSDETAILS	EXCEPTIONEMAILS	varchar	250	√	null
SHIPUPSDETAILS	NOTIFICATIONEMAILS	varchar	250	√	null
SHIPUPSDETAILS	PHONE	varchar	250	√	null
BOM	DESCRIPTION	varchar	252
LOCATION	DESCRIPTION	varchar	252	√	null
PART	DESCRIPTION	varchar	252	√	null
PARTCATEGORY	DESCRIPTION	varchar	252	√	null
POITEM	DESCRIPTION	varchar	252	√	null
PRODUCT	DESCRIPTION	varchar	252	√	null
PRODUCTTREE	DESCRIPTION	varchar	252	√	null
SOITEM	DESCRIPTION	varchar	252	√	null
UOM	DESCRIPTION	varchar	252
UOMCONVERSION	DESCRIPTION	varchar	252
VENDORCOSTRULE	DESCRIPTION	varchar	252	√	null
USERPROPERTIES	SUBCATEGORY1	varchar	252	√	null
DCOPTIONS	CODE	varchar	254
PACKAGETYPES	CODE	varchar	254
UPSSERVICES	CODE	varchar	254
DCOPTIONS	DESCRIPTION	varchar	254
PACKAGETYPES	DESCRIPTION	varchar	254
UPSSERVICES	DESCRIPTION	varchar	254
UPSCOD	NAME	varchar	254
UPSPAYMENTTYPE	NAME	varchar	254
SHIPUPSCARTONDETAILS	VERBALCONFIRMATIONNAME	varchar	254	√	null
SHIPCARTON	WEIGHTUOM	varchar	254	√	null
CURRENCY	CODE	varchar	255	√	null
FBSCHEDULE	DIRECTORY	varchar	255	√	null
FBSCHEDULE	EMAIL	varchar	255	√	null
FBSCHEDULE	EMAILREPORT	varchar	255	√	null
SHIPPINGIMPORT	IGNORE	varchar	255	√	null
INTEGRATIONPROPERTIES	INFO	varchar	255
FBSCHEDULE	JAVACLASS	varchar	255	√	null
CURRENCY	NAME	varchar	255	√	null
UPSACCOUNT	NUMBER	varchar	255
FBSCHEDULE	PARAMETERS	varchar	255	√	null
CUSTOMFIELDVIEW	CFDESCRIPTION	varchar	256	√	null
ASSOCPRICETYPE	DESCRIPTION	varchar	256	√	null
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
FBSCHEDULE	DESCRIPTION	varchar	256
INTEGRATEDAPP	DESCRIPTION	varchar	256	√	null
INVENTORYLOGTYPE	DESCRIPTION	varchar	256
ITEMADJUST	DESCRIPTION	varchar	256	√	null
KITITEM	DESCRIPTION	varchar	256	√	null
MOITEM	DESCRIPTION	varchar	256
OBJECTTOOBJECTTYPE	DESCRIPTION	varchar	256
PARTTRACKING	DESCRIPTION	varchar	256	√	null
PARTTRACKINGVIEW	DESCRIPTION	varchar	256	√	null
TAGSERIALVIEW	DESCRIPTION	varchar	256	√	null
TAGTRACKINGVIEW	DESCRIPTION	varchar	256	√	null
TAXRATE	DESCRIPTION	varchar	256	√	null
WOITEM	DESCRIPTION	varchar	256	√	null
XOITEM	DESCRIPTION	varchar	256	√	null
BOMITEM	INSTRUCTIONURL	varchar	256
MOITEM	INSTRUCTIONURL	varchar	256
USERACCESS	MODULENAME	varchar	256
FBSCHEDULEREPORTPARAMETER	PARAMVALUE	varchar	256	√	null
REPORTPARAMETER	PARAMVALUE	varchar	256	√	null
REPORT	PATH	varchar	256
BOMITEMGROUP	PROMPT	varchar	256	√	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
SYSPROPERTIES	SYSVALUE	varchar	1024