Matt Slay

Extracting Enum values from an assembly file using the Object Browser in FoxPro

2011-02-24T14:13:00.001-06:00

Thanks to a helpful comment from Doug Henning, I was able to learn how to use the Object Browser in Foxpro to extract Enum values from an assembly file right into a .h file inside of FoxPro. By an “assembly”, I mean a dll file that is installed on your machine when you install software or API tools to communicate with said software packages.

For instance, here is the Object Browser in FoxPro taking a look at a dll assembly from the QuickBook SDK ver 10:

I posted an article recently about communicating with QuickBooks from FoxPro, where I explained some problems I began having with the .h include file I was using, which had become out of date when we upgraded to the latest version of the QuickBooks SDK. You can see that post here if you’re interested in the original problem the I was having: http://mattslay.com/adding-custom-data-to-quickbooks-invoices-from-foxpro/

The problem was basically that I needed to have up-to-date Enum values (Constants in FoxPro) from the latest assembly that came with the new SDK. The Enums from a dll are exposed nicely when using Visual Studio, but there is no FoxPro .h Include file for FoxPro included in the QuickBooks SDK. I knew the information I needed was in that .dll file, I just didn’t know hot to get them out of there.

The bottom line is this…. With a few simple steps (shown below), I was able to drag-and-drop the Enum node from an assembly file right into a code file in FoxPro to get constants defines in a .h include file.

Doug pointed me to the Object Browser in FoxPro, which has some support for this, but not exactly what I wanted. So I Goodled around and stumbled upon the golden nugget that I needed to completely solved the problem to my liking. To dig into the solution I found, you can check it out here: http://www.dbmonster.com/Uwe/Forum.aspx/foxpro/7047/Utility-to-extract-print-all-enumerations. I am not going to repeat all the code and discussion from that thread here to avoid redundancy. There’s a lot to be learned from reading the thread yourself if you want to dig into the details, but that’s not necessary unless you want to explore the issue deeper. I followed the thread and picked out the various instructions and was able have it all working in just a few minutes. If you want, you can skip all the details in that post, and just follow these next few steps to get this enhanced version of the Object Browser:

Update Instructions for Object Browser Enum Extraction

Fortunately, the source code for many of the FoxPro tools like the Object Browser were release to the community a few year ago so that we could enhance them and keep the tools current. That’s what the guys in the dbmonster post did, and I’ve wrapped it all up here in an easy download..

Option 1 – Download the modified file right from me and start using it now:

If you do not want to modify the code yourself, you can download the .exe file that I built from here: http://mattslay.com/download-files/object-browser-modified-for-enums.exe

If you want a copy of the modified source code, you can download the whole project here: http://mattslay.com/download-files/object-browser-modified-for-enums.zip

Option 2 – Do it yourself – To update the FoxPro Object Browser with this expanded functionality, follow these steps…

1. Go to the VFPX site and download the Xsource code here: http://vfpx.codeplex.com/wikipage?title=XSource. Extract the ‘obrowser’ tool from the zip and open the project file in VFP.

2. Make these changes to the source code… (follow the discussion and see the code at this link: http://www.dbmonster.com/Uwe/Forum.aspx/foxpro/7047/Utility-to-extract-print-all-enumerations

3. Next, compile the project to an .exe (name and location is your choice).

4. Now you can run your new version of the Object Browser to accomplish this task and output shown above.

Results

Here is the output you’ll get. (Note: I manually added the top few lines of comments to record some notes about how the files was created and what version is.)

By the way, this output below is a complete list of the QBFC10Lib Enums, so I you are doing FoxPro work with QuickBooks SDK 10, you can cut-and-past these values right from here, and you’ll have a working .h file. If you’re working with a different version of the QB SDK, then you should extract the Enum from the correct dll for your version.

Here you go:

*** FoxPro constants from QuickBooks SDK assembly QBFC10Lib
***
*** To see the origin of this file, visit this link:
***   http://mattslay.com/adding-custom-data-to-quickbooks-invoices-from-foxpro/
***
**********************************************************************************

*--- Constant Group: ENOpenMode
#DEFINE omSingleUser    0
#DEFINE omMultiUser    1
#DEFINE omDontCare    2

*--- Constant Group: ENRqOnError
#DEFINE roeStop    0
#DEFINE roeContinue    1
#DEFINE roeRollback    2

*--- Constant Group: ENReleaseLevel
#DEFINE rlPreAlpha    0
#DEFINE rlAlpha    1
#DEFINE rlBeta    2
#DEFINE rlRelease    3

*--- Constant Group: ENRqResponseData
#DEFINE rdIncludeAll    0
#DEFINE rdIncludeNone    1

*--- Constant Group: ENConnectionType
#DEFINE ctUnknown    0
#DEFINE ctLocalQBD    1
#DEFINE ctRemoteQBD    2
#DEFINE ctLocalQBDLaunchUI    3
#DEFINE ctRemoteQBOE    4

*--- Constant Group: ENUnattendedModePrefType
#DEFINE umptRequired    1
#DEFINE umptOptional    2

*--- Constant Group: ENPersonalDataPrefType
#DEFINE pdptRequired    1
#DEFINE pdptOptional    2
#DEFINE pdptNotNeeded    3

*--- Constant Group: ENQuickBooksEdition
#DEFINE qbeUS    0
#DEFINE qbeOE    1
#DEFINE qbeCA    2
#DEFINE qbeUK    3
#DEFINE qbeAU    4

*--- Constant Group: ENORNameFilter
#DEFINE ornfNA    -1
#DEFINE ornfNameFilter    0
#DEFINE ornfNameRangeFilter    1

*--- Constant Group: ENORCurrencyFilter
#DEFINE orcfNA    -1
#DEFINE orcfListID    0
#DEFINE orcfFullName    1

*--- Constant Group: ENActiveStatus
#DEFINE asActiveOnly    0
#DEFINE asInactiveOnly    1
#DEFINE asAll    2

*--- Constant Group: ENAccountType
#DEFINE atAccountsPayable    0
#DEFINE atAccountsReceivable    1
#DEFINE atBank    2
#DEFINE atCostOfGoodsSold    3
#DEFINE atCreditCard    4
#DEFINE atEquity    5
#DEFINE atExpense    6
#DEFINE atFixedAsset    7
#DEFINE atIncome    8
#DEFINE atLongTermLiability    9
#DEFINE atNonPosting    10
#DEFINE atOtherAsset    11
#DEFINE atOtherCurrentAsset    12
#DEFINE atOtherCurrentLiability    13
#DEFINE atOtherExpense    14
#DEFINE atOtherIncome    15

*--- Constant Group: ENORAccountListQuery
#DEFINE oralqNA    -1
#DEFINE oralqListID    0
#DEFINE oralqFullName    1
#DEFINE oralqAccountListFilter    2

*--- Constant Group: ENmetaData
#DEFINE mdNoMetaData    0
#DEFINE mdMetaDataOnly    1
#DEFINE mdMetaDataAndResponseData    2

*--- Constant Group: ENORCustomerListQuery
#DEFINE orclqNA    -1
#DEFINE orclqListID    0
#DEFINE orclqFullName    1
#DEFINE orclqCustomerListFilter    2

*--- Constant Group: ENiterator
#DEFINE itStart    0
#DEFINE itContinue    1
#DEFINE itStop    2

*--- Constant Group: ENOREarnings
#DEFINE oreNA    -1
#DEFINE oreClearEarnings    0
#DEFINE oreEarnings    1

*--- Constant Group: ENORRate
#DEFINE orrNA    -1
#DEFINE orrRate    0
#DEFINE orrRatePercent    1

*--- Constant Group: ENORListQuery
#DEFINE orlqNA    -1
#DEFINE orlqListID    0
#DEFINE orlqFullName    1
#DEFINE orlqListFilter    2

*--- Constant Group: ENORVendorListQuery
#DEFINE orvlqNA    -1
#DEFINE orvlqListID    0
#DEFINE orvlqFullName    1
#DEFINE orvlqVendorListFilter    2

*--- Constant Group: ENPaymentMethodType
#DEFINE pmtAmericanExpress    0
#DEFINE pmtCash    1
#DEFINE pmtCheck    2
#DEFINE pmtDebitCard    3
#DEFINE pmtDiscover    4
#DEFINE pmtECheck    5
#DEFINE pmtGiftCard    6
#DEFINE pmtMasterCard    7
#DEFINE pmtOther    8
#DEFINE pmtOtherCreditCard    9
#DEFINE pmtVisa    10

*--- Constant Group: ENORPaymentMethodListQuery
#DEFINE orpmlqNA    -1
#DEFINE orpmlqListID    0
#DEFINE orpmlqFullName    1
#DEFINE orpmlqPaymentMethodListFilter    2

*--- Constant Group: ENDoneStatus
#DEFINE dsNotDoneOnly    0
#DEFINE dsDoneOnly    1
#DEFINE dsAll    2

*--- Constant Group: ENORToDoListQuery
#DEFINE ortdlqNA    -1
#DEFINE ortdlqListID    0
#DEFINE ortdlqToDoListFilter    1

*--- Constant Group: ENORSalesPurchase
#DEFINE orspNA    -1
#DEFINE orspSalesOrPurchase    0
#DEFINE orspSalesAndPurchase    1

*--- Constant Group: ENORPrice
#DEFINE orpNA    -1
#DEFINE orpPrice    0
#DEFINE orpPricePercent    1

*--- Constant Group: ENORSalesPurchaseMod
#DEFINE orspmNA    -1
#DEFINE orspmSalesOrPurchaseMod    0
#DEFINE orspmSalesAndPurchaseMod    1

*--- Constant Group: ENORItemInventoryAssemblyLine
#DEFINE oriialNA    -1
#DEFINE oriialClearItemsInGroup    0
#DEFINE oriialItemInventoryAssemblyLine    1

*--- Constant Group: ENORDiscountRate
#DEFINE ordrNA    -1
#DEFINE ordrDiscountRate    0
#DEFINE ordrDiscountRatePercent    1

*--- Constant Group: ENORItemGroupLine
#DEFINE origlNA    -1
#DEFINE origlClearItemsInGroup    0
#DEFINE origlItemGroupLine    1

*--- Constant Group: ENORPriceLevel
#DEFINE orplNA    -1
#DEFINE orplPriceLevelFixedPercentage    0
#DEFINE orplPriceLevelPerItemCurrency    1

*--- Constant Group: ENAdjustRelativeTo
#DEFINE artStandardPrice    0
#DEFINE artCost    1
#DEFINE artCurrentCustomPrice    2

*--- Constant Group: ENORPriceLevelPrice
#DEFINE orplpNA    -1
#DEFINE orplpORCustomPrice    0
#DEFINE orplpPriceLevelAdjustment    1

*--- Constant Group: ENORORCustomPrice
#DEFINE ororcpNA    -1
#DEFINE ororcpCustomPrice    0
#DEFINE ororcpCustomPricePercent    1

*--- Constant Group: ENORPriceLevelQuery
#DEFINE orplqNA    -1
#DEFINE orplqListID    0
#DEFINE orplqFullName    1
#DEFINE orplqPriceLevelFilter    2

*--- Constant Group: ENORBillingRate
#DEFINE orbrNA    -1
#DEFINE orbrFixedBillingRate    0
#DEFINE orbrBillingRatePerItem    1

*--- Constant Group: ENAdjustBillingRateRelativeTo
#DEFINE abrrtStandardRate    0
#DEFINE abrrtCurrentCustomRate    1

*--- Constant Group: ENORBillingRateItem
#DEFINE orbriNA    -1
#DEFINE orbriORCustomRate    0
#DEFINE orbriBillingRateAdjustment    1

*--- Constant Group: ENORORCustomRate
#DEFINE ororcrNA    -1
#DEFINE ororcrCustomRate    0
#DEFINE ororcrCustomRatePercent    1

*--- Constant Group: ENORBillingRateQuery
#DEFINE orbrqNA    -1
#DEFINE orbrqListID    0
#DEFINE orbrqFullName    1
#DEFINE orbrqBillingRateFilter    2

*--- Constant Group: ENORWorkersCompCodeQuery
#DEFINE orwccqNA    -1
#DEFINE orwccqListID    0
#DEFINE orwccqFullName    1
#DEFINE orwccqWorkersCompCodeFilter    2

*--- Constant Group: ENMappingCategory
#DEFINE mcBOX1    0
#DEFINE mcBOX2    1
#DEFINE mcBOX3    2
#DEFINE mcBOX4    3
#DEFINE mcBOX5    4
#DEFINE mcBOX6    5
#DEFINE mcBOX7    6
#DEFINE mcBOX8    7
#DEFINE mcBOX9    8
#DEFINE mcBOX10    9
#DEFINE mcBOX13    10
#DEFINE mcBOX14    11

*--- Constant Group: ENORInventorySiteQuery
#DEFINE orisqNA    -1
#DEFINE orisqListID    0
#DEFINE orisqFullName    1
#DEFINE orisqInventorySiteFilter    2

*--- Constant Group: ENORInvoiceLineAdd
#DEFINE orila1NA    -1
#DEFINE orilaInvoiceLineAdd    0
#DEFINE orilaInvoiceLineGroupAdd    1

*--- Constant Group: ENORRatePriceLevel
#DEFINE orrplNA    -1
#DEFINE orrplRate    0
#DEFINE orrplRatePercent    1
#DEFINE orrplPriceLevelRef    2

*--- Constant Group: ENORDiscountLineAdd
#DEFINE ordlaNA    -1
#DEFINE ordlaAmount    0
#DEFINE ordlaRatePercent    1

*--- Constant Group: ENORSalesTaxLineAdd
#DEFINE orstlaNA    -1
#DEFINE orstlaAmount    0
#DEFINE orstlaRatePercent    1

*--- Constant Group: ENORInvoiceLineMod
#DEFINE orilmNA    -1
#DEFINE orilmInvoiceLineMod    0
#DEFINE orilmInvoiceLineGroupMod    1

*--- Constant Group: ENDateMacro
#DEFINE dmAll    0
#DEFINE dmToday    1
#DEFINE dmThisWeek    2
#DEFINE dmThisWeekToDate    3
#DEFINE dmThisMonth    4
#DEFINE dmThisMonthToDate    5
#DEFINE dmThisCalendarQuarter    6
#DEFINE dmThisCalendarQuarterToDate    7
#DEFINE dmThisFiscalQuarter    8
#DEFINE dmThisFiscalQuarterToDate    9
#DEFINE dmThisCalendarYear    10
#DEFINE dmThisCalendarYearToDate    11
#DEFINE dmThisFiscalYear    12
#DEFINE dmThisFiscalYearToDate    13
#DEFINE dmYesterday    14
#DEFINE dmLastWeek    15
#DEFINE dmLastWeekToDate    16
#DEFINE dmLastMonth    17
#DEFINE dmLastMonthToDate    18
#DEFINE dmLastCalendarQuarter    19
#DEFINE dmLastCalendarQuarterToDate    20
#DEFINE dmLastFiscalQuarter    21
#DEFINE dmLastFiscalQuarterToDate    22
#DEFINE dmLastCalendarYear    23
#DEFINE dmLastCalendarYearToDate    24
#DEFINE dmLastFiscalYear    25
#DEFINE dmLastFiscalYearToDate    26
#DEFINE dmNextWeek    27
#DEFINE dmNextFourWeeks    28
#DEFINE dmNextMonth    29
#DEFINE dmNextCalendarQuarter    30
#DEFINE dmNextCalendarYear    31
#DEFINE dmNextFiscalQuarter    32
#DEFINE dmNextFiscalYear    33

*--- Constant Group: ENORTxnDateRangeFilter
#DEFINE ortdrfNA    -1
#DEFINE ortdrfTxnDateFilter    0
#DEFINE ortdrfDateMacro    1

*--- Constant Group: ENOREntityFilter
#DEFINE orefNA    -1
#DEFINE orefListID    0
#DEFINE orefFullName    1
#DEFINE orefListIDWithChildren    2
#DEFINE orefFullNameWithChildren    3

*--- Constant Group: ENORAccountFilter
#DEFINE orafNA    -1
#DEFINE orafListID    0
#DEFINE orafFullName    1
#DEFINE orafListIDWithChildren    2
#DEFINE orafFullNameWithChildren    3

*--- Constant Group: ENORDateRangeFilter
#DEFINE ordrfNA    -1
#DEFINE ordrfModifiedDateRangeFilter    0
#DEFINE ordrfTxnDateRangeFilter    1

*--- Constant Group: ENORRefNumberFilter
#DEFINE orrnfNA    -1
#DEFINE orrnfRefNumberFilter    0
#DEFINE orrnfRefNumberRangeFilter    1

*--- Constant Group: ENPaidStatus
#DEFINE psAll    0
#DEFINE psPaidOnly    1
#DEFINE psNotPaidOnly    2

*--- Constant Group: ENORInvoiceQuery
#DEFINE oriqNA    -1
#DEFINE oriqTxnID    0
#DEFINE oriqRefNumber    1
#DEFINE oriqRefNumberCaseSensitive    2
#DEFINE oriqInvoiceFilter    3

*--- Constant Group: ENOREstimateLineAdd
#DEFINE orelaNA    -1
#DEFINE orelaEstimateLineAdd    0
#DEFINE orelaEstimateLineGroupAdd    1

*--- Constant Group: ENORMarkupRatePriceLevel
#DEFINE ormrplNA    -1
#DEFINE ormrplMarkupRate    0
#DEFINE ormrplMarkupRatePercent    1
#DEFINE ormrplPriceLevelRef    2

*--- Constant Group: ENOREstimateLineMod
#DEFINE orelmNA    -1
#DEFINE orelmEstimateLineMod    0
#DEFINE orelmEstimateLineGroupMod    1

*--- Constant Group: ENORTxnQuery
#DEFINE ortqNA    -1
#DEFINE ortqTxnID    0
#DEFINE ortqRefNumber    1
#DEFINE ortqRefNumberCaseSensitive    2
#DEFINE ortqTxnFilter    3

*--- Constant Group: ENORSalesOrderLineAdd
#DEFINE orsolaNA    -1
#DEFINE orsolaSalesOrderLineAdd    0
#DEFINE orsolaSalesOrderLineGroupAdd    1

*--- Constant Group: ENORSalesOrderLineMod
#DEFINE orsolmNA    -1
#DEFINE orsolmSalesOrderLineMod    0
#DEFINE orsolmSalesOrderLineGroupMod    1

*--- Constant Group: ENORTxnNoAccountQuery
#DEFINE ortnaqNA    -1
#DEFINE ortnaqTxnID    0
#DEFINE ortnaqRefNumber    1
#DEFINE ortnaqRefNumberCaseSensitive    2
#DEFINE ortnaqTxnFilterNoAccount    3

*--- Constant Group: ENORSalesReceiptLineAdd
#DEFINE orsrlaNA    -1
#DEFINE orsrlaSalesReceiptLineAdd    0
#DEFINE orsrlaSalesReceiptLineGroupAdd    1

*--- Constant Group: ENORSalesReceiptLineMod
#DEFINE orsrlmNA    -1
#DEFINE orsrlmSalesReceiptLineMod    0
#DEFINE orsrlmSalesReceiptLineGroupMod    1

*--- Constant Group: ENORCreditMemoLineAdd
#DEFINE orcmlaNA    -1
#DEFINE orcmlaCreditMemoLineAdd    0
#DEFINE orcmlaCreditMemoLineGroupAdd    1

*--- Constant Group: ENORCreditMemoLineMod
#DEFINE orcmlmNA    -1
#DEFINE orcmlmCreditMemoLineMod    0
#DEFINE orcmlmCreditMemoLineGroupMod    1

*--- Constant Group: ENORApplyPayment
#DEFINE orapNA    -1
#DEFINE orapIsAutoApply    0
#DEFINE orapAppliedToTxnAdd    1

*--- Constant Group: ENORChargeTxnQuery
#DEFINE orctqNA    -1
#DEFINE orctqTxnID    0
#DEFINE orctqRefNumber    1
#DEFINE orctqRefNumberCaseSensitive    2
#DEFINE orctqChargeFilter    3

*--- Constant Group: ENORInventorySiteORShipToEntity
#DEFINE orisorsteNA    -1
#DEFINE orisorsteInventorySiteRef    0
#DEFINE orisorsteShipToEntityRef    1

*--- Constant Group: ENORPurchaseOrderLineAdd
#DEFINE orpolaNA    -1
#DEFINE orpolaPurchaseOrderLineAdd    0
#DEFINE orpolaPurchaseOrderLineGroupAdd    1

*--- Constant Group: ENORPurchaseOrderLineMod
#DEFINE orpolmNA    -1
#DEFINE orpolmPurchaseOrderLineMod    0
#DEFINE orpolmPurchaseOrderLineGroupMod    1

*--- Constant Group: ENORItemLineAdd
#DEFINE orilaNA    -1
#DEFINE orilaItemLineAdd    0
#DEFINE orilaItemGroupLineAdd    1

*--- Constant Group: ENORItemLineMod
#DEFINE orilmmNA    -1
#DEFINE orilmmItemLineMod    0
#DEFINE orilmmItemGroupLineMod    1

*--- Constant Group: ENORBillQuery
#DEFINE orbqNA    -1
#DEFINE orbqTxnID    0
#DEFINE orbqRefNumber    1
#DEFINE orbqRefNumberCaseSensitive    2
#DEFINE orbqBillFilter    3

*--- Constant Group: ENORCheckPrint
#DEFINE orcpNA    -1
#DEFINE orcpIsToBePrinted    0
#DEFINE orcpRefNumber    1

*--- Constant Group: ENORItemFilter
#DEFINE orifNA    -1
#DEFINE orifListID    0
#DEFINE orifFullName    1
#DEFINE orifListIDWithChildren    2
#DEFINE orifFullNameWithChildren    3

*--- Constant Group: ENORSalesTaxPaymentCheckQuery
#DEFINE orstpcqNA    -1
#DEFINE orstpcqTxnID    0
#DEFINE orstpcqRefNumber    1
#DEFINE orstpcqRefNumberCaseSensitive    2
#DEFINE orstpcqTxnFilterWithItemFilter    3

*--- Constant Group: ENORTypeAdjustment
#DEFINE ortaNA    -1
#DEFINE ortaQuantityAdjustment    0
#DEFINE ortaValueAdjustment    1

*--- Constant Group: ENORQuantityAdjustment
#DEFINE orqaNA    -1
#DEFINE orqaNewQuantity    0
#DEFINE orqaQuantityDifference    1

*--- Constant Group: ENORValueAdjustment
#DEFINE orvaNA    -1
#DEFINE orvaNewValue    0
#DEFINE orvaValueDifference    1

*--- Constant Group: ENORInventoryAdjustmentQuery
#DEFINE oriaqNA    -1
#DEFINE oriaqTxnID    0
#DEFINE oriaqRefNumber    1
#DEFINE oriaqRefNumberCaseSensitive    2
#DEFINE oriaqTxnFilterWithItemFilter    3

*--- Constant Group: ENORTimeTrackingEntityFilter
#DEFINE orttefNA    -1
#DEFINE orttefListID    0
#DEFINE orttefFullName    1

*--- Constant Group: ENORTimeTrackingTxnQuery
#DEFINE ortttqNA    -1
#DEFINE ortttqTxnID    0
#DEFINE ortttqTimeTrackingTxnFilter    1

*--- Constant Group: ENORHomeCurrencyAdjustment
#DEFINE orhcaNA    -1
#DEFINE orhcaIsHomeCurrencyAdjustment    0
#DEFINE orhcaCurrencyExchangeRate    1

*--- Constant Group: ENORJournalLine
#DEFINE orjlNA    -1
#DEFINE orjlJournalDebitLine    0
#DEFINE orjlJournalCreditLine    1

*--- Constant Group: ENORDepositLineAdd
#DEFINE ordladdNA    -1
#DEFINE ordladdPaymentLine    0
#DEFINE ordladdDepositInfo    1

*--- Constant Group: ENORDepositLineMod
#DEFINE ordlmNA    -1
#DEFINE ordlmPaymentLine    0
#DEFINE ordlmDepositInfoMod    1

*--- Constant Group: ENORDepositQuery
#DEFINE ordqNA    -1
#DEFINE ordqTxnID    0
#DEFINE ordqDepositFilter    1

*--- Constant Group: ENListDelType
#DEFINE ldtAccount    0
#DEFINE ldtBillingRate    1
#DEFINE ldtClass    2
#DEFINE ldtCurrency    3
#DEFINE ldtCustomer    4
#DEFINE ldtCustomerMsg    5
#DEFINE ldtCustomerType    6
#DEFINE ldtDateDrivenTerms    7
#DEFINE ldtEmployee    8
#DEFINE ldtInventorySite    9
#DEFINE ldtItemDiscount    10
#DEFINE ldtItemFixedAsset    11
#DEFINE ldtItemGroup    12
#DEFINE ldtItemInventory    13
#DEFINE ldtItemInventoryAssembly    14
#DEFINE ldtItemNonInventory    15
#DEFINE ldtItemOtherCharge    16
#DEFINE ldtItemPayment    17
#DEFINE ldtItemSalesTax    18
#DEFINE ldtItemSalesTaxGroup    19
#DEFINE ldtItemService    20
#DEFINE ldtItemSubtotal    21
#DEFINE ldtJobType    22
#DEFINE ldtOtherName    23
#DEFINE ldtPaymentMethod    24
#DEFINE ldtPayrollItemNonWage    25
#DEFINE ldtPayrollItemWage    26
#DEFINE ldtPriceLevel    27
#DEFINE ldtSalesRep    28
#DEFINE ldtSalesTaxCode    29
#DEFINE ldtShipMethod    30
#DEFINE ldtStandardTerms    31
#DEFINE ldtToDo    32
#DEFINE ldtUnitOfMeasureSet    33
#DEFINE ldtVehicle    34
#DEFINE ldtVendor    35
#DEFINE ldtVendorType    36
#DEFINE ldtWorkersCompCode    37

*--- Constant Group: ENListMergeType
#DEFINE lmtAccount    0
#DEFINE lmtClass    1
#DEFINE lmtCustomer    2
#DEFINE lmtItemDiscount    3
#DEFINE lmtItemGroup    4
#DEFINE lmtItemInventory    5
#DEFINE lmtItemNonInventory    6
#DEFINE lmtItemOtherCharge    7
#DEFINE lmtItemPayment    8
#DEFINE lmtItemSalesTax    9
#DEFINE lmtItemSalesTaxGroup    10
#DEFINE lmtItemService    11
#DEFINE lmtItemSubtotal    12
#DEFINE lmtVendor    13

*--- Constant Group: ENTxnDelType
#DEFINE tdtARRefundCreditCard    0
#DEFINE tdtBill    1
#DEFINE tdtBillPaymentCheck    2
#DEFINE tdtBillPaymentCreditCard    3
#DEFINE tdtBuildAssembly    4
#DEFINE tdtCharge    5
#DEFINE tdtCheck    6
#DEFINE tdtCreditCardCharge    7
#DEFINE tdtCreditCardCredit    8
#DEFINE tdtCreditMemo    9
#DEFINE tdtDeposit    10
#DEFINE tdtEstimate    11
#DEFINE tdtInventoryAdjustment    12
#DEFINE tdtInvoice    13
#DEFINE tdtItemReceipt    14
#DEFINE tdtJournalEntry    15
#DEFINE tdtPurchaseOrder    16
#DEFINE tdtReceivePayment    17
#DEFINE tdtSalesOrder    18
#DEFINE tdtSalesReceipt    19
#DEFINE tdtSalesTaxPaymentCheck    20
#DEFINE tdtTimeTracking    21
#DEFINE tdtTransferInventory    22
#DEFINE tdtVehicleMileage    23
#DEFINE tdtVendorCredit    24

*--- Constant Group: ENTxnVoidType
#DEFINE tvtARRefundCreditCard    0
#DEFINE tvtBill    1
#DEFINE tvtBillPaymentCheck    2
#DEFINE tvtBillPaymentCreditCard    3
#DEFINE tvtCharge    4
#DEFINE tvtCheck    5
#DEFINE tvtCreditCardCharge    6
#DEFINE tvtCreditCardCredit    7
#DEFINE tvtCreditMemo    8
#DEFINE tvtDeposit    9
#DEFINE tvtInventoryAdjustment    10
#DEFINE tvtInvoice    11
#DEFINE tvtItemReceipt    12
#DEFINE tvtJournalEntry    13
#DEFINE tvtSalesReceipt    14
#DEFINE tvtVendorCredit    15

*--- Constant Group: ENListDisplayAddType
#DEFINE ldatAccount    0
#DEFINE ldatCustomer    1
#DEFINE ldatEmployee    2
#DEFINE ldatItem    3
#DEFINE ldatOtherName    4
#DEFINE ldatVendor    5

*--- Constant Group: ENListDisplayModType
#DEFINE ldmtAccount    0
#DEFINE ldmtCustomer    1
#DEFINE ldmtEmployee    2
#DEFINE ldmtItem    3
#DEFINE ldmtOtherName    4
#DEFINE ldmtVendor    5

*--- Constant Group: ENTxnDisplayAddType
#DEFINE tdatBill    0
#DEFINE tdatBillPayment    1
#DEFINE tdatBuildAssembly    2
#DEFINE tdatCharge    3
#DEFINE tdatCheck    4
#DEFINE tdatCreditCardCharge    5
#DEFINE tdatCreditCardCredit    6
#DEFINE tdatCreditMemo    7
#DEFINE tdatDeposit    8
#DEFINE tdatEstimate    9
#DEFINE tdatInventoryAdjustment    10
#DEFINE tdatInvoice    11
#DEFINE tdatItemReceipt    12
#DEFINE tdatJournalEntry    13
#DEFINE tdatPurchaseOrder    14
#DEFINE tdatReceivePayment    15
#DEFINE tdatSalesOrder    16
#DEFINE tdatSalesReceipt    17
#DEFINE tdatSalesTaxPaymentCheck    18
#DEFINE tdatVendorCredit    19

*--- Constant Group: ENTxnDisplayModType
#DEFINE tdmtBill    0
#DEFINE tdmtBillPaymentCheck    1
#DEFINE tdmtBillPaymentCreditCard    2
#DEFINE tdmtBuildAssembly    3
#DEFINE tdmtCharge    4
#DEFINE tdmtCheck    5
#DEFINE tdmtCreditCardCharge    6
#DEFINE tdmtCreditCardCredit    7
#DEFINE tdmtCreditMemo    8
#DEFINE tdmtDeposit    9
#DEFINE tdmtEstimate    10
#DEFINE tdmtInventoryAdjustment    11
#DEFINE tdmtInvoice    12
#DEFINE tdmtItemReceipt    13
#DEFINE tdmtJournalEntry    14
#DEFINE tdmtPurchaseOrder    15
#DEFINE tdmtReceivePayment    16
#DEFINE tdmtSalesOrder    17
#DEFINE tdmtSalesReceipt    18
#DEFINE tdmtSalesTaxPaymentCheck    19
#DEFINE tdmtVendorCredit    20

*--- Constant Group: ENORProgCLSID
#DEFINE orpclsidNA    -1
#DEFINE orpclsidProgID    0
#DEFINE orpclsidCLSID    1

*--- Constant Group: ENORTransactionModifiedDateRangeFilter
#DEFINE ortmdrfNA    -1
#DEFINE ortmdrfModifiedDateRange    0
#DEFINE ortmdrfDateMacro    1

*--- Constant Group: ENORTransactionDateRangeFilter
#DEFINE ortdrffNA    -1
#DEFINE ortdrffTxnDateRange    0
#DEFINE ortdrffDateMacro    1

*--- Constant Group: ENEntityTypeFilter
#DEFINE etfCustomer    0
#DEFINE etfEmployee    1
#DEFINE etfOtherName    2
#DEFINE etfVendor    3

*--- Constant Group: ENORTransactionEntityFilter
#DEFINE ortefNA    -1
#DEFINE ortefEntityTypeFilter    0
#DEFINE ortefListID    1
#DEFINE ortefFullName    2
#DEFINE ortefListIDWithChildren    3
#DEFINE ortefFullNameWithChildren    4

*--- Constant Group: ENAccountTypeFilter
#DEFINE atfAccountsPayable    0
#DEFINE atfAccountsReceivable    1
#DEFINE atfAllowedFor1099    2
#DEFINE atfAPAndSalesTax    3
#DEFINE atfAPOrCreditCard    4
#DEFINE atfARAndAP    5
#DEFINE atfAsset    6
#DEFINE atfBalanceSheet    7
#DEFINE atfBank    8
#DEFINE atfBankAndARAndAPAndUF    9
#DEFINE atfBankAndUF    10
#DEFINE atfCostOfSales    11
#DEFINE atfCreditCard    12
#DEFINE atfCurrentAsset    13
#DEFINE atfCurrentAssetAndExpense    14
#DEFINE atfCurrentLiability    15
#DEFINE atfEquity    16
#DEFINE atfEquityAndIncomeAndExpense    17
#DEFINE atfExpenseAndOtherExpense    18
#DEFINE atfFixedAsset    19
#DEFINE atfIncomeAndExpense    20
#DEFINE atfIncomeAndOtherIncome    21
#DEFINE atfLiability    22
#DEFINE atfLiabilityAndEquity    23
#DEFINE atfLongTermLiability    24
#DEFINE atfNonPosting    25
#DEFINE atfOrdinaryExpense    26
#DEFINE atfOrdinaryIncome    27
#DEFINE atfOrdinaryIncomeAndCOGS    28
#DEFINE atfOrdinaryIncomeAndExpense    29
#DEFINE atfOtherAsset    30
#DEFINE atfOtherCurrentAsset    31
#DEFINE atfOtherCurrentLiability    32
#DEFINE atfOtherExpense    33
#DEFINE atfOtherIncome    34
#DEFINE atfOtherIncomeOrExpense    35

*--- Constant Group: ENORTransactionAccountFilter
#DEFINE ortafNA    -1
#DEFINE ortafAccountTypeFilter    0
#DEFINE ortafListID    1
#DEFINE ortafFullName    2
#DEFINE ortafListIDWithChildren    3
#DEFINE ortafFullNameWithChildren    4

*--- Constant Group: ENItemTypeFilter
#DEFINE itfAllExceptFixedAsset    0
#DEFINE itfAssembly    1
#DEFINE itfDiscount    2
#DEFINE itfFixedAsset    3
#DEFINE itfInventory    4
#DEFINE itfInventoryAndAssembly    5
#DEFINE itfNonInventory    6
#DEFINE itfOtherCharge    7
#DEFINE itfPayment    8
#DEFINE itfSales    9
#DEFINE itfSalesTax    10
#DEFINE itfService    11

*--- Constant Group: ENORTransactionItemFilter
#DEFINE ortifNA    -1
#DEFINE ortifItemTypeFilter    0
#DEFINE ortifListID    1
#DEFINE ortifFullName    2
#DEFINE ortifListIDWithChildren    3
#DEFINE ortifFullNameWithChildren    4

*--- Constant Group: ENORTransactionClassFilter
#DEFINE ortcfNA    -1
#DEFINE ortcfListID    0
#DEFINE ortcfFullName    1
#DEFINE ortcfListIDWithChildren    2
#DEFINE ortcfFullNameWithChildren    3

*--- Constant Group: ENORTransactionRefNumberFilter
#DEFINE ortrnfNA    -1
#DEFINE ortrnfRefNumber    0
#DEFINE ortrnfRefNumberCaseSensitive    1
#DEFINE ortrnfRefNumberFilter    2
#DEFINE ortrnfRefNumberRangeFilter    3

*--- Constant Group: ENTransactionDetailLevelFilter
#DEFINE tdlfAll    0
#DEFINE tdlfSummaryOnly    1
#DEFINE tdlfAllExceptSummary    2

*--- Constant Group: ENTransactionPostingStatusFilter
#DEFINE tpsfEither    0
#DEFINE tpsfNonPosting    1
#DEFINE tpsfPosting    2

*--- Constant Group: ENTransactionPaidStatusFilter
#DEFINE tpsffEither    0
#DEFINE tpsffClosed    1
#DEFINE tpsffOpen    2

*--- Constant Group: ENORTransactionQuery
#DEFINE ortqqNA    -1
#DEFINE ortqqTxnID    0
#DEFINE ortqqTransactionFilter    1

*--- Constant Group: ENPendingStatus
#DEFINE pensAll    0
#DEFINE pensPendingOnly    1
#DEFINE pensNotPendingOnly    2

*--- Constant Group: ENORBuildAssemblyQuery
#DEFINE orbaqNA    -1
#DEFINE orbaqTxnID    0
#DEFINE orbaqRefNumber    1
#DEFINE orbaqRefNumberCaseSensitive    2
#DEFINE orbaqBuildAssemblyFilter    3

*--- Constant Group: ENORARRefundCreditCardQuery
#DEFINE orarrccqNA    -1
#DEFINE orarrccqTxnID    0
#DEFINE orarrccqRefNumber    1
#DEFINE orarrccqRefNumberCaseSensitive    2
#DEFINE orarrccqARRefundCreditCardFilter    3

*--- Constant Group: ENORVehicleMileageAdd
#DEFINE orvmaNA    -1
#DEFINE orvmaOdometerReadingAdd    0
#DEFINE orvmaTotalMiles    1

*--- Constant Group: ENORVehicleMileageQuery
#DEFINE orvmqNA    -1
#DEFINE orvmqTxnID    0
#DEFINE orvmqVehicleMileageFilter    1

*--- Constant Group: ENORTransferInventoryQuery
#DEFINE ortiqNA    -1
#DEFINE ortiqTxnID    0
#DEFINE ortiqRefNumber    1
#DEFINE ortiqRefNumberCaseSensitive    2
#DEFINE ortiqTxnFilterNoCurrency    3

*--- Constant Group: ENORReportAccountFilter
#DEFINE orrafNA    -1
#DEFINE orrafAccountTypeFilter    0
#DEFINE orrafListID    1
#DEFINE orrafFullName    2
#DEFINE orrafListIDWithChildren    3
#DEFINE orrafFullNameWithChildren    4

*--- Constant Group: ENORReportEntityFilter
#DEFINE orrefNA    -1
#DEFINE orrefEntityTypeFilter    0
#DEFINE orrefListID    1
#DEFINE orrefFullName    2
#DEFINE orrefListIDWithChildren    3
#DEFINE orrefFullNameWithChildren    4

*--- Constant Group: ENORReportItemFilter
#DEFINE orrifNA    -1
#DEFINE orrifItemTypeFilter    0
#DEFINE orrifListID    1
#DEFINE orrifFullName    2
#DEFINE orrifListIDWithChildren    3
#DEFINE orrifFullNameWithChildren    4

*--- Constant Group: ENORReportClassFilter
#DEFINE orrcfNA    -1
#DEFINE orrcfListID    0
#DEFINE orrcfFullName    1
#DEFINE orrcfListIDWithChildren    2
#DEFINE orrcfFullNameWithChildren    3

*--- Constant Group: ENReportDateMacro
#DEFINE rdmAll    0
#DEFINE rdmToday    1
#DEFINE rdmThisWeek    2
#DEFINE rdmThisWeekToDate    3
#DEFINE rdmThisMonth    4
#DEFINE rdmThisMonthToDate    5
#DEFINE rdmThisQuarter    6
#DEFINE rdmThisQuarterToDate    7
#DEFINE rdmThisYear    8
#DEFINE rdmThisYearToDate    9
#DEFINE rdmYesterday    10
#DEFINE rdmLastWeek    11
#DEFINE rdmLastWeekToDate    12
#DEFINE rdmLastMonth    13
#DEFINE rdmLastMonthToDate    14
#DEFINE rdmLastQuarter    15
#DEFINE rdmLastQuarterToDate    16
#DEFINE rdmLastYear    17
#DEFINE rdmLastYearToDate    18
#DEFINE rdmNextWeek    19
#DEFINE rdmNextFourWeeks    20
#DEFINE rdmNextMonth    21
#DEFINE rdmNextQuarter    22
#DEFINE rdmNextYear    23

*--- Constant Group: ENORReportPeriod
#DEFINE orrpNA    -1
#DEFINE orrpReportPeriod    0
#DEFINE orrpReportDateMacro    1

*--- Constant Group: ENReportModifiedDateRangeMacro
#DEFINE rmdrmAll    0
#DEFINE rmdrmToday    1
#DEFINE rmdrmThisWeek    2
#DEFINE rmdrmThisWeekToDate    3
#DEFINE rmdrmThisMonth    4
#DEFINE rmdrmThisMonthToDate    5
#DEFINE rmdrmThisQuarter    6
#DEFINE rmdrmThisQuarterToDate    7
#DEFINE rmdrmThisYear    8
#DEFINE rmdrmThisYearToDate    9
#DEFINE rmdrmYesterday    10
#DEFINE rmdrmLastWeek    11
#DEFINE rmdrmLastWeekToDate    12
#DEFINE rmdrmLastMonth    13
#DEFINE rmdrmLastMonthToDate    14
#DEFINE rmdrmLastQuarter    15
#DEFINE rmdrmLastQuarterToDate    16
#DEFINE rmdrmLastYear    17
#DEFINE rmdrmLastYearToDate    18
#DEFINE rmdrmNextWeek    19
#DEFINE rmdrmNextFourWeeks    20
#DEFINE rmdrmNextMonth    21
#DEFINE rmdrmNextQuarter    22
#DEFINE rmdrmNextYear    23

*--- Constant Group: ENORReportModifiedDate
#DEFINE orrmdNA    -1
#DEFINE orrmdReportModifiedDateRangeFilter    0
#DEFINE orrmdReportModifiedDateRangeMacro    1

*--- Constant Group: ENGeneralSummaryReportType
#DEFINE gsrtBalanceSheetPrevYearComp    0
#DEFINE gsrtBalanceSheetStandard    1
#DEFINE gsrtBalanceSheetSummary    2
#DEFINE gsrtCustomerBalanceSummary    3
#DEFINE gsrtExpenseByVendorSummary    4
#DEFINE gsrtIncomeByCustomerSummary    5
#DEFINE gsrtInventoryStockStatusByItem    6
#DEFINE gsrtInventoryStockStatusByVendor    7
#DEFINE gsrtIncomeTaxSummary    8
#DEFINE gsrtInventoryValuationSummary    9
#DEFINE gsrtPhysicalInventoryWorksheet    10
#DEFINE gsrtProfitAndLossByClass    11
#DEFINE gsrtProfitAndLossByJob    12
#DEFINE gsrtProfitAndLossPrevYearComp    13
#DEFINE gsrtProfitAndLossStandard    14
#DEFINE gsrtProfitAndLossYTDComp    15
#DEFINE gsrtPurchaseByItemSummary    16
#DEFINE gsrtPurchaseByVendorSummary    17
#DEFINE gsrtSalesByCustomerSummary    18
#DEFINE gsrtSalesByItemSummary    19
#DEFINE gsrtSalesByRepSummary    20
#DEFINE gsrtSalesTaxLiability    21
#DEFINE gsrtSalesTaxRevenueSummary    22
#DEFINE gsrtTrialBalance    23
#DEFINE gsrtVendorBalanceSummary    24

*--- Constant Group: ENReportDetailLevelFilter
#DEFINE rdlfAll    0
#DEFINE rdlfAllExceptSummary    1
#DEFINE rdlfSummaryOnly    2

*--- Constant Group: ENReportPostingStatusFilter
#DEFINE rpsfEither    0
#DEFINE rpsfNonPosting    1
#DEFINE rpsfPosting    2

*--- Constant Group: ENSummarizeColumnsBy
#DEFINE scbAccount    0
#DEFINE scbBalanceSheet    1
#DEFINE scbClass    2
#DEFINE scbCustomer    3
#DEFINE scbCustomerType    4
#DEFINE scbDay    5
#DEFINE scbEmployee    6
#DEFINE scbFourWeek    7
#DEFINE scbHalfMonth    8
#DEFINE scbIncomeStatement    9
#DEFINE scbItemDetail    10
#DEFINE scbItemType    11
#DEFINE scbMonth    12
#DEFINE scbPayee    13
#DEFINE scbPaymentMethod    14
#DEFINE scbPayrollItemDetail    15
#DEFINE scbPayrollYtdDetail    16
#DEFINE scbQuarter    17
#DEFINE scbSalesRep    18
#DEFINE scbSalesTaxCode    19
#DEFINE scbShipMethod    20
#DEFINE scbTerms    21
#DEFINE scbTotalOnly    22
#DEFINE scbTwoWeek    23
#DEFINE scbVendor    24
#DEFINE scbVendorType    25
#DEFINE scbWeek    26
#DEFINE scbYear    27

*--- Constant Group: ENReportCalendar
#DEFINE rcCalendarYear    0
#DEFINE rcFiscalYear    1
#DEFINE rcTaxYear    2

*--- Constant Group: ENReturnRows
#DEFINE rrActiveOnly    0
#DEFINE rrNonZero    1
#DEFINE rrAll    2

*--- Constant Group: ENReturnColumns
#DEFINE rcActiveOnly    0
#DEFINE rcNonZero    1
#DEFINE rcAll    2

*--- Constant Group: ENReportBasis
#DEFINE rbAccrual    0
#DEFINE rbCash    1
#DEFINE rbNone    2

*--- Constant Group: ENJobReportType
#DEFINE jrtItemEstimatesVsActuals    0
#DEFINE jrtItemProfitability    1
#DEFINE jrtJobEstimatesVsActualsDetail    2
#DEFINE jrtJobEstimatesVsActualsSummary    3
#DEFINE jrtJobProfitabilityDetail    4
#DEFINE jrtJobProfitabilitySummary    5
#DEFINE jrt    6

*--- Constant Group: ENTimeReportType
#DEFINE trtTimeByItem    0
#DEFINE trtTimeByJobDetail    1
#DEFINE trtTimeByJobSummary    2
#DEFINE trtTimeByName    3

*--- Constant Group: ENAgingReportType
#DEFINE artAPAgingDetail    0
#DEFINE artAPAgingSummary    1
#DEFINE artARAgingDetail    2
#DEFINE artARAgingSummary    3
#DEFINE artCollectionsReport    4

*--- Constant Group: ENIncludeColumn
#DEFINE icAccount    0
#DEFINE icAging    1
#DEFINE icAmount    2
#DEFINE icAmountDifference    3
#DEFINE icAverageCost    4
#DEFINE icBilledDate    5
#DEFINE icBillingStatus    6
#DEFINE icCalculatedAmount    7
#DEFINE icClass    8
#DEFINE icClearedStatus    9
#DEFINE icCostPrice    10
#DEFINE icCredit    11
#DEFINE icDate    12
#DEFINE icDebit    13
#DEFINE icDeliveryDate    14
#DEFINE icDueDate    15
#DEFINE icEstimateActive    16
#DEFINE icFOB    17
#DEFINE icIncomeSubjectToTax    18
#DEFINE icInvoiced    19
#DEFINE icItem    20
#DEFINE icItemDesc    21
#DEFINE icLastModifiedBy    22
#DEFINE icLatestOrPriorState    23
#DEFINE icMemo    24
#DEFINE icModifiedTime    25
#DEFINE icName    26
#DEFINE icNameAccountNumber    27
#DEFINE icNameAddress    28
#DEFINE icNameCity    29
#DEFINE icNameContact    30
#DEFINE icNameEmail    31
#DEFINE icNameFax    32
#DEFINE icNamePhone    33
#DEFINE icNameState    34
#DEFINE icNameZip    35
#DEFINE icOpenBalance    36
#DEFINE icOriginalAmount    37
#DEFINE icPaidAmount    38
#DEFINE icPaidStatus    39
#DEFINE icPaidThroughDate    40
#DEFINE icPaymentMethod    41
#DEFINE icPayrollItem    42
#DEFINE icPONumber    43
#DEFINE icPrintStatus    44
#DEFINE icProgressAmount    45
#DEFINE icProgressPercent    46
#DEFINE icQuantity    47
#DEFINE icQuantityAvailable    48
#DEFINE icQuantityOnHand    49
#DEFINE icQuantityOnSalesOrder    50
#DEFINE icReceivedQuantity    51
#DEFINE icRefNumber    52
#DEFINE icRunningBalance    53
#DEFINE icSalesRep    54
#DEFINE icSalesTaxCode    55
#DEFINE icShipDate    56
#DEFINE icShipMethod    57
#DEFINE icSourceName    58
#DEFINE icSplitAccount    59
#DEFINE icSSNOrTaxID    60
#DEFINE icTaxLine    61
#DEFINE icTaxTableVersion    62
#DEFINE icTerms    63
#DEFINE icTxnID    64
#DEFINE icTxnNumber    65
#DEFINE icTxnType    66
#DEFINE icUnitPrice    67
#DEFINE icUserEdit    68
#DEFINE icValueOnHand    69
#DEFINE icWageBase    70
#DEFINE icWageBaseTips    71

*--- Constant Group: ENIncludeAccounts
#DEFINE iaAll    0
#DEFINE iaInUse    1

*--- Constant Group: ENReportAgingAsOf
#DEFINE raaoReportEndDate    0
#DEFINE raaoToday    1

*--- Constant Group: ENBudgetSummaryReportType
#DEFINE bsrtBalanceSheetBudgetOverview    0
#DEFINE bsrtBalanceSheetBudgetVsActual    1
#DEFINE bsrtProfitAndLossBudgetOverview    2
#DEFINE bsrtProfitAndLossBudgetPerformance    3
#DEFINE bsrtProfitAndLossBudgetVsActual    4

*--- Constant Group: ENBudgetCriterion
#DEFINE bcAccounts    0
#DEFINE bcAccountsAndClasses    1
#DEFINE bcAccountsAndCustomers    2

*--- Constant Group: ENSummarizeBudgetColumnsBy
#DEFINE sbcbClass    0
#DEFINE sbcbCustomer    1
#DEFINE sbcbDate    2

*--- Constant Group: ENSummarizeBudgetRowsBy
#DEFINE sbrbAccount    0
#DEFINE sbrbClass    1
#DEFINE sbrbCustomer    2

*--- Constant Group: ENGeneralDetailReportType
#DEFINE gdrt1099Detail    0
#DEFINE gdrtAuditTrail    1
#DEFINE gdrtBalanceSheetDetail    2
#DEFINE gdrtCheckDetail    3
#DEFINE gdrtCustomerBalanceDetail    4
#DEFINE gdrtDepositDetail    5
#DEFINE gdrtEstimatesByJob    6
#DEFINE gdrtExpenseByVendorDetail    7
#DEFINE gdrtGeneralLedger    8
#DEFINE gdrtIncomeByCustomerDetail    9
#DEFINE gdrtIncomeTaxDetail    10
#DEFINE gdrtInventoryValuationDetail    11
#DEFINE gdrtJobProgressInvoicesVsEstimates    12
#DEFINE gdrtJournal    13
#DEFINE gdrtMissingChecks    14
#DEFINE gdrtOpenInvoices    15
#DEFINE gdrtOpenPOs    16
#DEFINE gdrtOpenPOsByJob    17
#DEFINE gdrtOpenSalesOrderByCustomer    18
#DEFINE gdrtOpenSalesOrderByItem    19
#DEFINE gdrtPendingSales    20
#DEFINE gdrtProfitAndLossDetail    21
#DEFINE gdrtPurchaseByItemDetail    22
#DEFINE gdrtPurchaseByVendorDetail    23
#DEFINE gdrtSalesByCustomerDetail    24
#DEFINE gdrtSalesByItemDetail    25
#DEFINE gdrtSalesByRepDetail    26
#DEFINE gdrtTxnDetailByAccount    27
#DEFINE gdrtTxnListByCustomer    28
#DEFINE gdrtTxnListByDate    29
#DEFINE gdrtTxnListByVendor    30
#DEFINE gdrtUnpaidBillsDetail    31
#DEFINE gdrtUnbilledCostsByJob    32
#DEFINE gdrtVendorBalanceDetail    33

*--- Constant Group: ENSummarizeRowsBy
#DEFINE srbAccount    0
#DEFINE srbBalanceSheet    1
#DEFINE srbClass    2
#DEFINE srbCustomer    3
#DEFINE srbCustomerType    4
#DEFINE srbDay    5
#DEFINE srbEmployee    6
#DEFINE srbFourWeek    7
#DEFINE srbHalfMonth    8
#DEFINE srbIncomeStatement    9
#DEFINE srbItemDetail    10
#DEFINE srbItemType    11
#DEFINE srbMonth    12
#DEFINE srbPayee    13
#DEFINE srbPaymentMethod    14
#DEFINE srbPayrollItemDetail    15
#DEFINE srbPayrollYtdDetail    16
#DEFINE srbQuarter    17
#DEFINE srbSalesRep    18
#DEFINE srbSalesTaxCode    19
#DEFINE srbShipMethod    20
#DEFINE srbTaxLine    21
#DEFINE srbTerms    22
#DEFINE srbTotalOnly    23
#DEFINE srbTwoWeek    24
#DEFINE srbVendor    25
#DEFINE srbVendorType    26
#DEFINE srbWeek    27
#DEFINE srbYear    28

*--- Constant Group: ENReportOpenBalanceAsOf
#DEFINE robaoReportEndDate    0
#DEFINE robaoToday    1

*--- Constant Group: ENCustomDetailReportType
#DEFINE cdrtCustomTxnDetail    0

*--- Constant Group: ENCustomSummaryReportType
#DEFINE csrtCustomSummary    0

*--- Constant Group: ENPayrollDetailReportType
#DEFINE pdrtEmployeeStateTaxesDetail    0
#DEFINE pdrtPayrollItemDetail    1
#DEFINE pdrtPayrollReviewDetail    2
#DEFINE pdrtPayrollTransactionDetail    3
#DEFINE pdrtPayrollTransactionsByPayee    4

*--- Constant Group: ENPayrollSummaryReportType
#DEFINE psrtEmployeeEarningsSummary    0
#DEFINE psrtPayrollLiabilityBalances    1
#DEFINE psrtPayrollSummary    2

*--- Constant Group: ENAssignToObject
#DEFINE atoAccount    0
#DEFINE atoARRefundCreditCard    1
#DEFINE atoBill    2
#DEFINE atoBillPaymentCheck    3
#DEFINE atoBillPaymentCreditCard    4
#DEFINE atoBuildAssembly    5
#DEFINE atoCharge    6
#DEFINE atoCheck    7
#DEFINE atoCompany    8
#DEFINE atoCreditCardCharge    9
#DEFINE atoCreditCardCredit    10
#DEFINE atoCreditMemo    11
#DEFINE atoCustomer    12
#DEFINE atoDeposit    13
#DEFINE atoEmployee    14
#DEFINE atoEstimate    15
#DEFINE atoInventoryAdjustment    16
#DEFINE atoInvoice    17
#DEFINE atoItem    18
#DEFINE atoItemReceipt    19
#DEFINE atoJournalEntry    20
#DEFINE atoOtherName    21
#DEFINE atoPurchaseOrder    22
#DEFINE atoReceivePayment    23
#DEFINE atoSalesOrder    24
#DEFINE atoSalesReceipt    25
#DEFINE atoSalesTaxPaymentCheck    26
#DEFINE atoVendor    27
#DEFINE atoVendorCredit    28

*--- Constant Group: ENORDataExtDefQuery
#DEFINE ordedqNA    -1
#DEFINE ordedqOwnerID    0
#DEFINE ordedqAssignToObject    1

*--- Constant Group: ENListDataExtType
#DEFINE ldetAccount    0
#DEFINE ldetCustomer    1
#DEFINE ldetEmployee    2
#DEFINE ldetItem    3
#DEFINE ldetOtherName    4
#DEFINE ldetVendor    5

*--- Constant Group: ENTxnDataExtType
#DEFINE tdetARRefundCreditCard    0
#DEFINE tdetBill    1
#DEFINE tdetBillPaymentCheck    2
#DEFINE tdetBillPaymentCreditCard    3
#DEFINE tdetBuildAssembly    4
#DEFINE tdetCharge    5
#DEFINE tdetCheck    6
#DEFINE tdetCreditCardCharge    7
#DEFINE tdetCreditCardCredit    8
#DEFINE tdetCreditMemo    9
#DEFINE tdetDeposit    10
#DEFINE tdetEstimate    11
#DEFINE tdetInventoryAdjustment    12
#DEFINE tdetInvoice    13
#DEFINE tdetItemReceipt    14
#DEFINE tdetJournalEntry    15
#DEFINE tdetPurchaseOrder    16
#DEFINE tdetReceivePayment    17
#DEFINE tdetSalesOrder    18
#DEFINE tdetSalesReceipt    19
#DEFINE tdetSalesTaxPaymentCheck    20
#DEFINE tdetVendorCredit    21

*--- Constant Group: ENOtherDataExtType
#DEFINE odetCompany    0

*--- Constant Group: ENORListTxnWithMacro
#DEFINE orltwmNA    -1
#DEFINE orltwmListDataExt    0
#DEFINE orltwmTxnDataExtWithMacro    1
#DEFINE orltwmOtherDataExtType    2

*--- Constant Group: ENORListTxn
#DEFINE orltNA    -1
#DEFINE orltListDataExt    0
#DEFINE orltTxnDataExt    1
#DEFINE orltOtherDataExtType    2

*--- Constant Group: ENORPriceLevelRet
#DEFINE orplrNA    -1
#DEFINE orplrPriceLevelFixedPercentage    0
#DEFINE orplrPriceLevelPerItemRetCurrency    1

*--- Constant Group: ENORBillingRateRet
#DEFINE orbrrNA    -1
#DEFINE orbrrFixedBillingRate    0
#DEFINE orbrrBillingRatePerItemRet    1

*--- Constant Group: ENORInvoiceLineRet
#DEFINE orilr1NA    -1
#DEFINE orilrInvoiceLineRet    0
#DEFINE orilrInvoiceLineGroupRet    1

*--- Constant Group: ENORDiscountLineRet
#DEFINE ordlrNA    -1
#DEFINE ordlrAmount    0
#DEFINE ordlrRatePercent    1

*--- Constant Group: ENORSalesTaxLineRet
#DEFINE orstlrNA    -1
#DEFINE orstlrAmount    0
#DEFINE orstlrRatePercent    1

*--- Constant Group: ENOREstimateLineRet
#DEFINE orelrNA    -1
#DEFINE orelrEstimateLineRet    0
#DEFINE orelrEstimateLineGroupRet    1

*--- Constant Group: ENORMarkupRate
#DEFINE ormrNA    -1
#DEFINE ormrMarkupRate    0
#DEFINE ormrMarkupRatePercent    1

*--- Constant Group: ENORSalesOrderLineRet
#DEFINE orsolrNA    -1
#DEFINE orsolrSalesOrderLineRet    0
#DEFINE orsolrSalesOrderLineGroupRet    1

*--- Constant Group: ENORSalesReceiptLineRet
#DEFINE orsrlrNA    -1
#DEFINE orsrlrSalesReceiptLineRet    0
#DEFINE orsrlrSalesReceiptLineGroupRet    1

*--- Constant Group: ENORCreditMemoLineRet
#DEFINE orcmlrNA    -1
#DEFINE orcmlrCreditMemoLineRet    0
#DEFINE orcmlrCreditMemoLineGroupRet    1

*--- Constant Group: ENORPurchaseOrderLineRet
#DEFINE orpolrNA    -1
#DEFINE orpolrPurchaseOrderLineRet    0
#DEFINE orpolrPurchaseOrderLineGroupRet    1

*--- Constant Group: ENORItemLineRet
#DEFINE orilrNA    -1
#DEFINE orilrItemLineRet    0
#DEFINE orilrItemGroupLineRet    1

*--- Constant Group: ENORBillToPayRet
#DEFINE orbtprNA    -1
#DEFINE orbtprBillToPay    0
#DEFINE orbtprCreditToApply    1

*--- Constant Group: ENORReportData
#DEFINE orrdNA    -1
#DEFINE orrdDataRow    0
#DEFINE orrdTextRow    1
#DEFINE orrdSubtotalRow    2
#DEFINE orrdTotalRow    3

*--- Constant Group: ENORMenuSubmenu
#DEFINE ormsNA    -1
#DEFINE ormsSubmenu    0
#DEFINE ormsMenuItem    1

*--- Constant Group: ENSubscriptionType
#DEFINE stData    0
#DEFINE stUI    1
#DEFINE stUIExtension    2

*--- Constant Group: ENORListTxnEvent
#DEFINE orlteNA    -1
#DEFINE orlteListEvent    0
#DEFINE orlteTxnEvent    1

*--- Constant Group: ENTxnType
#DEFINE ttARRefundCreditCard    0
#DEFINE ttBill    1
#DEFINE ttBillPaymentCheck    2
#DEFINE ttBillPaymentCreditCard    3
#DEFINE ttBuildAssembly    4
#DEFINE ttCharge    5
#DEFINE ttCheck    6
#DEFINE ttCreditCardCharge    7
#DEFINE ttCreditCardCredit    8
#DEFINE ttCreditMemo    9
#DEFINE ttDeposit    10
#DEFINE ttEstimate    11
#DEFINE ttInventoryAdjustment    12
#DEFINE ttInvoice    13
#DEFINE ttItemReceipt    14
#DEFINE ttJournalEntry    15
#DEFINE ttLiabilityAdjustment    16
#DEFINE ttPaycheck    17
#DEFINE ttPayrollLiabilityCheck    18
#DEFINE ttPurchaseOrder    19
#DEFINE ttReceivePayment    20
#DEFINE ttSalesOrder    21
#DEFINE ttSalesReceipt    22
#DEFINE ttSalesTaxPaymentCheck    23
#DEFINE ttTransfer    24
#DEFINE ttVendorCredit    25
#DEFINE ttYTDAdjustment    26

*--- Constant Group: ENListType
#DEFINE ltAccount    0
#DEFINE ltClass    1
#DEFINE ltCustomer    2
#DEFINE ltCustomerMsg    3
#DEFINE ltCustomerType    4
#DEFINE ltDateDrivenTerms    5
#DEFINE ltEmployee    6
#DEFINE ltItemDiscount    7
#DEFINE ltItemFixedAsset    8
#DEFINE ltItemGroup    9
#DEFINE ltItemInventory    10
#DEFINE ltItemInventoryAssembly    11
#DEFINE ltItemNonInventory    12
#DEFINE ltItemOtherCharge    13
#DEFINE ltItemPayment    14
#DEFINE ltItemSalesTax    15
#DEFINE ltItemSalesTaxGroup    16
#DEFINE ltItemService    17
#DEFINE ltItemSubtotal    18
#DEFINE ltJobType    19
#DEFINE ltOtherName    20
#DEFINE ltPaymentMethod    21
#DEFINE ltPriceLevel    22
#DEFINE ltSalesRep    23
#DEFINE ltSalesTaxCode    24
#DEFINE ltShipMethod    25
#DEFINE ltStandardTerms    26
#DEFINE ltToDo    27
#DEFINE ltVendor    28
#DEFINE ltVendorType    29

*--- Constant Group: ENORCurrentWindow
#DEFINE orcwNA    -1
#DEFINE orcwTxnTypeID    0
#DEFINE orcwListTypeID    1

*--- Constant Group: ENOREntityRet
#DEFINE orerNA    -1
#DEFINE orerCustomerRet    0
#DEFINE orerEmployeeRet    1
#DEFINE orerOtherNameRet    2
#DEFINE orerVendorRet    3

*--- Constant Group: ENORTermsRet
#DEFINE ortrNA    -1
#DEFINE ortrStandardTermsRet    0
#DEFINE ortrDateDrivenTermsRet    1

*--- Constant Group: ENORSpecialItemRet
#DEFINE orsirNA    -1
#DEFINE orsirItemOtherChargeRet    0
#DEFINE orsirItemSubtotalRet    1
#DEFINE orsirItemGroupRet    2

*--- Constant Group: ENOREvent
#DEFINE orevNA    -1
#DEFINE orevDataEvent    0
#DEFINE orevUIEvent    1
#DEFINE orevUIExtensionEvent    2

*--- Constant Group: ENORItemRet
#DEFINE orirNA    -1
#DEFINE orirItemServiceRet    0
#DEFINE orirItemNonInventoryRet    1
#DEFINE orirItemOtherChargeRet    2
#DEFINE orirItemInventoryRet    3
#DEFINE orirItemInventoryAssemblyRet    4
#DEFINE orirItemFixedAssetRet    5
#DEFINE orirItemSubtotalRet    6
#DEFINE orirItemDiscountRet    7
#DEFINE orirItemPaymentRet    8
#DEFINE orirItemSalesTaxRet    9
#DEFINE orirItemSalesTaxGroupRet    10
#DEFINE orirItemGroupRet    11

*--- Constant Group: ENDetailAccountType
#DEFINE datAP    0
#DEFINE datAR    1
#DEFINE datAccumulatedAdjustment    2
#DEFINE datAccumulatedAmortization    3
#DEFINE datAccumulatedAmortizationOfOtherAssets    4
#DEFINE datAccumulatedDepletion    5
#DEFINE datAccumulatedDepreciation    6
#DEFINE datAdvertisingOrPromotional    7
#DEFINE datAllowanceForBadDebts    8
#DEFINE datAmortization    9
#DEFINE datAuto    10
#DEFINE datBadDebts    11
#DEFINE datBankCharges    12
#DEFINE datBuildings    13
#DEFINE datCashOnHand    14
#DEFINE datCharitableContributions    15
#DEFINE datChecking    16
#DEFINE datCommonStock    17
#DEFINE datCostOfLabor    18
#DEFINE datCostOfLaborCOS    19
#DEFINE datCreditCard    20
#DEFINE datDepletableAssets    21
#DEFINE datDepreciation    22
#DEFINE datDevelopmentCosts    23
#DEFINE datDiscountsOrRefundsGiven    24
#DEFINE datDividendIncome    25
#DEFINE datDuesAndSubscriptions    26
#DEFINE datEmployeeCashAdvances    27
#DEFINE datEntertainment    28
#DEFINE datEntertainmentMeals    29
#DEFINE datEquipmentRental    30
#DEFINE datEquipmentRentalCOS    31
#DEFINE datFederalIncomeTaxPayable    32
#DEFINE datFurnitureAndFixtures    33
#DEFINE datGoodwill    34
#DEFINE datInsurance    35
#DEFINE datInsurancePayable    36
#DEFINE datIntangibleAssets    37
#DEFINE datInterestEarned    38
#DEFINE datInterestPaid    39
#DEFINE datInventory    40
#DEFINE datInvestmentMortgageOrRealEstateLoans    41
#DEFINE datInvestmentOther    42
#DEFINE datInvestmentTaxExemptSecurities    43
#DEFINE datInvestmentUSGovObligations    44
#DEFINE datLand    45
#DEFINE datLeaseBuyout    46
#DEFINE datLeaseholdImprovements    47
#DEFINE datLegalAndProfessionalFees    48
#DEFINE datLicenses    49
#DEFINE datLineOfCredit    50
#DEFINE datLoanPayable    51
#DEFINE datLoansToOfficers    52
#DEFINE datLoansToOthers    53
#DEFINE datLoansToStockholders    54
#DEFINE datMachineryAndEquipment    55
#DEFINE datMoneyMarket    56
#DEFINE datNonProfitIncome    57
#DEFINE datNotesPayable    58
#DEFINE datOfficeOrGeneralAdministrativeExpenses    59
#DEFINE datOpeningBalanceEquity    60
#DEFINE datOrganizationalCosts    61
#DEFINE datOtherCostsOfServiceCOS    62
#DEFINE datOtherCurrentAssets    63
#DEFINE datOtherCurrentLiab    64
#DEFINE datOtherFixedAssets    65
#DEFINE datOtherInvestmentIncome    66
#DEFINE datOtherLongTermAssets    67
#DEFINE datOtherLongTermLiab    68
#DEFINE datOtherMiscExpense    69
#DEFINE datOtherMiscIncome    70
#DEFINE datOtherMiscServiceCost    71
#DEFINE datOtherPrimaryIncome    72
#DEFINE datOwnersEquity    73
#DEFINE datPaidInCapitalOrSurplus    74
#DEFINE datPartnerContributions    75
#DEFINE datPartnerDistributions    76
#DEFINE datPartnersEquity    77
#DEFINE datPayrollClearing    78
#DEFINE datPayrollExpenses    79
#DEFINE datPayrollTaxPayable    80
#DEFINE datPenaltiesAndSettlements    81
#DEFINE datPreferredStock    82
#DEFINE datPrepaidExpenses    83
#DEFINE datPrepaidExpensesPayable    84
#DEFINE datPromotionalMeals    85
#DEFINE datRentOrLeaseOfBuildings    86
#DEFINE datRentsHeldInTrust    87
#DEFINE datRentsInTrustLiab    88
#DEFINE datRepairAndMaintenance    89
#DEFINE datRetainage    90
#DEFINE datRetainedEarnings    91
#DEFINE datSalesOfProductIncome    92
#DEFINE datSalesTaxPayable    93
#DEFINE datSavings    94
#DEFINE datSecurityDeposits    95
#DEFINE datServiceOrFeeIncome    96
#DEFINE datShareholderNotesPayable    97
#DEFINE datShippingFreightAndDelivery    98
#DEFINE datShippingFreightAndDeliveryCOS    99
#DEFINE datStateOrLocalIncomeTaxPayable    100
#DEFINE datSuppliesAndMaterials    101
#DEFINE datSuppliesAndMaterialsCOGS    102
#DEFINE datTaxExemptInterest    103
#DEFINE datTaxesPaid    104
#DEFINE datTravel    105
#DEFINE datTravelMeals    106
#DEFINE datTreasuryStock    107
#DEFINE datTrustAccounts    108
#DEFINE datTrustAccountsLiab    109
#DEFINE datUndepositedFunds    110
#DEFINE datUtilities    111
#DEFINE datVehicles    112

*--- Constant Group: ENSpecialAccountType
#DEFINE satAccountsPayable    0
#DEFINE satAccountsReceivable    1
#DEFINE satCondenseItemAdjustmentExpenses    2
#DEFINE satCostOfGoodsSold    3
#DEFINE satDirectDepositLiabilities    4
#DEFINE satEstimates    5
#DEFINE satExchangeGainLoss    6
#DEFINE satInventoryAssets    7
#DEFINE satOpeningBalanceEquity    8
#DEFINE satPayrollExpenses    9
#DEFINE satPayrollLiabilities    10
#DEFINE satPettyCash    11
#DEFINE satPurchaseOrders    12
#DEFINE satReconciliationDifferences    13
#DEFINE satRetainedEarnings    14
#DEFINE satSalesOrders    15
#DEFINE satSalesTaxPayable    16
#DEFINE satUncategorizedExpenses    17
#DEFINE satUncategorizedIncome    18
#DEFINE satUndepositedFunds    19

*--- Constant Group: ENCashFlowClassification
#DEFINE cfcNone    0
#DEFINE cfcOperating    1
#DEFINE cfcInvesting    2
#DEFINE cfcFinancing    3
#DEFINE cfcNotApplicable    4

*--- Constant Group: ENSpecialItemType
#DEFINE sitFinanceCharge    0
#DEFINE sitReimbursableExpenseGroup    1
#DEFINE sitReimbursableExpenseSubtotal    2

*--- Constant Group: ENSalesTaxCountry
#DEFINE stcAustralia    0
#DEFINE stcCanada    1
#DEFINE stcUK    2

*--- Constant Group: ENJobStatus
#DEFINE jsAwarded    0
#DEFINE jsClosed    1
#DEFINE jsInProgress    2
#DEFINE jsNone    3
#DEFINE jsNotAwarded    4
#DEFINE jsPending    5

*--- Constant Group: ENDeliveryMethod
#DEFINE dmEmail    0
#DEFINE dmFax    1
#DEFINE dmPrint    2

*--- Constant Group: ENPriceLevelType
#DEFINE pltFixedPercentage    0
#DEFINE pltPerItem    1

*--- Constant Group: ENAVSStreet
#DEFINE avssPass    0
#DEFINE avssFail    1
#DEFINE avssNotAvailable    2

*--- Constant Group: ENAVSZip
#DEFINE avszPass    0
#DEFINE avszFail    1
#DEFINE avszNotAvailable    2

*--- Constant Group: ENCardSecurityCodeMatch
#DEFINE cscmPass    0
#DEFINE cscmFail    1
#DEFINE cscmNotAvailable    2

*--- Constant Group: ENPaymentStatus
#DEFINE pssUnknown    0
#DEFINE pssCompleted    1

*--- Constant Group: ENUnitUsedFor
#DEFINE uufPurchase    0
#DEFINE uufSales    1
#DEFINE uufShipping    2

*--- Constant Group: ENPayPeriod
#DEFINE ppDaily    0
#DEFINE ppWeekly    1
#DEFINE ppBiweekly    2
#DEFINE ppSemimonthly    3
#DEFINE ppMonthly    4
#DEFINE ppQuarterly    5
#DEFINE ppYearly    6

*--- Constant Group: ENUseTimeDataToCreatePaychecks
#DEFINE utdtcpNotSet    0
#DEFINE utdtcpUseTimeData    1
#DEFINE utdtcpDoNotUseTimeData    2

*--- Constant Group: ENTxnTypeFilter
#DEFINE ttfAll    0
#DEFINE ttfARRefundCreditCard    1
#DEFINE ttfBill    2
#DEFINE ttfBillPaymentCheck    3
#DEFINE ttfBillPaymentCreditCard    4
#DEFINE ttfBuildAssembly    5
#DEFINE ttfCharge    6
#DEFINE ttfCheck    7
#DEFINE ttfCreditCardCharge    8
#DEFINE ttfCreditCardCredit    9
#DEFINE ttfCreditMemo    10
#DEFINE ttfDeposit    11
#DEFINE ttfEstimate    12
#DEFINE ttfInventoryAdjustment    13
#DEFINE ttfInvoice    14
#DEFINE ttfItemReceipt    15
#DEFINE ttfJournalEntry    16
#DEFINE ttfLiabilityAdjustment    17
#DEFINE ttfPaycheck    18
#DEFINE ttfPayrollLiabilityCheck    19
#DEFINE ttfPurchaseOrder    20
#DEFINE ttfReceivePayment    21
#DEFINE ttfSalesOrder    22
#DEFINE ttfSalesReceipt    23
#DEFINE ttfSalesTaxPaymentCheck    24
#DEFINE ttfTransfer    25
#DEFINE ttfVendorCredit    26
#DEFINE ttfYTDAdjustment    27

*--- Constant Group: ENdataType
#DEFINE dtIDTYPE    0
#DEFINE dtGUIDTYPE    1
#DEFINE dtSTRTYPE    2
#DEFINE dtBOOLTYPE    3
#DEFINE dtDATETYPE    4
#DEFINE dtDATETIMETYPE    5
#DEFINE dtTIMEINTERVALTYPE    6
#DEFINE dtAMTTYPE    7
#DEFINE dtPRICETYPE    8
#DEFINE dtQUANTYPE    9
#DEFINE dtPERCENTTYPE    10
#DEFINE dtENUMTYPE    11
#DEFINE dtINTTYPE    12

*--- Constant Group: ENClearedStatus
#DEFINE csCleared    0
#DEFINE csNotCleared    1
#DEFINE csPending    2

*--- Constant Group: ENBillableStatus
#DEFINE bsBillable    0
#DEFINE bsNotBillable    1
#DEFINE bsHasBeenBilled    2

*--- Constant Group: ENThousandSeparator
#DEFINE tsComma    0
#DEFINE tsPeriod    1
#DEFINE tsSpace    2
#DEFINE tsApostrophe    3

*--- Constant Group: ENThousandSeparatorGrouping
#DEFINE tsgXX_XXX_XXX    0
#DEFINE tsgX_XX_XX_XXX    1

*--- Constant Group: ENDecimalPlaces
#DEFINE dp0    0
#DEFINE dp2    1

*--- Constant Group: ENDecimalSeparator
#DEFINE dsPeriod    0
#DEFINE dsComma    1

*--- Constant Group: ENBillingRateType
#DEFINE brtFixedRate    0
#DEFINE brtPerItem    1

*--- Constant Group: ENRemoveFromObject
#DEFINE rfoAccount    0
#DEFINE rfoARRefundCreditCard    1
#DEFINE rfoBill    2
#DEFINE rfoBillPaymentCheck    3
#DEFINE rfoBillPaymentCreditCard    4
#DEFINE rfoBuildAssembly    5
#DEFINE rfoCharge    6
#DEFINE rfoCheck    7
#DEFINE rfoCompany    8
#DEFINE rfoCreditCardCharge    9
#DEFINE rfoCreditCardCredit    10
#DEFINE rfoCreditMemo    11
#DEFINE rfoCustomer    12
#DEFINE rfoDeposit    13
#DEFINE rfoEmployee    14
#DEFINE rfoEstimate    15
#DEFINE rfoInventoryAdjustment    16
#DEFINE rfoInvoice    17
#DEFINE rfoItem    18
#DEFINE rfoItemReceipt    19
#DEFINE rfoJournalEntry    20
#DEFINE rfoOtherName    21
#DEFINE rfoPurchaseOrder    22
#DEFINE rfoReceivePayment    23
#DEFINE rfoSalesOrder    24
#DEFINE rfoSalesReceipt    25
#DEFINE rfoSalesTaxPaymentCheck    26
#DEFINE rfoVendor    27
#DEFINE rfoVendorCredit    28

*--- Constant Group: ENCalculateChargesFrom
#DEFINE ccfDueDate    0
#DEFINE ccfInvoiceOrBilledDate    1

*--- Constant Group: ENEmployeeType
#DEFINE etOfficer    0
#DEFINE etOwner    1
#DEFINE etRegular    2
#DEFINE etStatutory    3

*--- Constant Group: ENFirstDayOfWeek
#DEFINE fdowMonday    0
#DEFINE fdowTuesday    1
#DEFINE fdowWednesday    2
#DEFINE fdowThursday    3
#DEFINE fdowFriday    4
#DEFINE fdowSaturday    5
#DEFINE fdowSunday    6

*--- Constant Group: ENDataExtType
#DEFINE detAMTTYPE    0
#DEFINE detDATETIMETYPE    1
#DEFINE detINTTYPE    2
#DEFINE detPERCENTTYPE    3
#DEFINE detPRICETYPE    4
#DEFINE detQUANTYPE    5
#DEFINE detSTR1024TYPE    6
#DEFINE detSTR255TYPE    7

*--- Constant Group: ENListEventType
#DEFINE letAccount    0
#DEFINE letClass    1
#DEFINE letCustomer    2
#DEFINE letCustomerMsg    3
#DEFINE letCustomerType    4
#DEFINE letDateDrivenTerms    5
#DEFINE letEmployee    6
#DEFINE letItemDiscount    7
#DEFINE letItemFixedAsset    8
#DEFINE letItemGroup    9
#DEFINE letItemInventory    10
#DEFINE letItemInventoryAssembly    11
#DEFINE letItemNonInventory    12
#DEFINE letItemOtherCharge    13
#DEFINE letItemPayment    14
#DEFINE letItemSalesTax    15
#DEFINE letItemSalesTaxGroup    16
#DEFINE letItemService    17
#DEFINE letItemSubtotal    18
#DEFINE letJobType    19
#DEFINE letOtherName    20
#DEFINE letPaymentMethod    21
#DEFINE letPriceLevel    22
#DEFINE letSalesRep    23
#DEFINE letSalesTaxCode    24
#DEFINE letShipMethod    25
#DEFINE letStandardTerms    26
#DEFINE letToDo    27
#DEFINE letVendor    28
#DEFINE letVendorType    29

*--- Constant Group: ENListEventOperation
#DEFINE leoAdd    0
#DEFINE leoModify    1
#DEFINE leoDelete    2
#DEFINE leoMerge    3

*--- Constant Group: ENFirstMonthFiscalYear
#DEFINE fmfyJanuary    0
#DEFINE fmfyFebruary    1
#DEFINE fmfyMarch    2
#DEFINE fmfyApril    3
#DEFINE fmfyMay    4
#DEFINE fmfyJune    5
#DEFINE fmfyJuly    6
#DEFINE fmfyAugust    7
#DEFINE fmfySeptember    8
#DEFINE fmfyOctober    9
#DEFINE fmfyNovember    10
#DEFINE fmfyDecember    11

*--- Constant Group: ENFirstMonthIncomeTaxYear
#DEFINE fmityJanuary    0
#DEFINE fmityFebruary    1
#DEFINE fmityMarch    2
#DEFINE fmityApril    3
#DEFINE fmityMay    4
#DEFINE fmityJune    5
#DEFINE fmityJuly    6
#DEFINE fmityAugust    7
#DEFINE fmitySeptember    8
#DEFINE fmityOctober    9
#DEFINE fmityNovember    10
#DEFINE fmityDecember    11

*--- Constant Group: ENTaxForm
#DEFINE tfForm1040    0
#DEFINE tfForm1065    1
#DEFINE tfForm1120    2
#DEFINE tfForm1120S    3
#DEFINE tfForm990    4
#DEFINE tfForm990PF    5
#DEFINE tfForm990T    6
#DEFINE tfOtherOrNone    7

*--- Constant Group: ENAgingReportBasis
#DEFINE arbAgeFromDueDate    0
#DEFINE arbAgeFromTransactionDate    1

*--- Constant Group: ENSummaryReportBasis
#DEFINE srbAccrual    0
#DEFINE srbCash    1

*--- Constant Group: ENCompanyFileEventOperation
#DEFINE cfeoClose    0
#DEFINE cfeoOpen    1

*--- Constant Group: ENGender
#DEFINE gMale    0
#DEFINE gFemale    1

*--- Constant Group: ENReportingPeriod
#DEFINE rpMonthly    0
#DEFINE rpQuarterly    1

*--- Constant Group: ENWageType
#DEFINE wtHourly    0
#DEFINE wtSalary    1
#DEFINE wtBonus    2
#DEFINE wtCommission    3
#DEFINE wtHourlyOvertime    4
#DEFINE wtHourlyRegular    5
#DEFINE wtHourlySick    6
#DEFINE wtHourlyVacation    7
#DEFINE wtSalaryRegular    8
#DEFINE wtSalarySick    9
#DEFINE wtSalaryVacation    10

*--- Constant Group: ENLinkType
#DEFINE ltAMTTYPE    0
#DEFINE ltQUANTYPE    1

*--- Constant Group: ENTemplateType
#DEFINE tttCreditMemo    0
#DEFINE tttEstimate    1
#DEFINE tttInvoice    2
#DEFINE tttPurchaseOrder    3
#DEFINE tttSalesOrder    4
#DEFINE tttSalesReceipt    5

*--- Constant Group: ENOperator
#DEFINE oLessThan    0
#DEFINE oLessThanEqual    1
#DEFINE oEqual    2
#DEFINE oGreaterThan    3
#DEFINE oGreaterThanEqual    4

*--- Constant Group: ENUnitOfMeasureType
#DEFINE uomtArea    0
#DEFINE uomtCount    1
#DEFINE uomtLength    2
#DEFINE uomtOther    3
#DEFINE uomtTime    4
#DEFINE uomtVolume    5
#DEFINE uomtWeight    6

*--- Constant Group: ENVisibleIf
#DEFINE viAccountantCopyExists    0
#DEFINE viAssemblyItemsEnabled    1
#DEFINE viClassesEnabled    2
#DEFINE viEstimatesEnabled    3
#DEFINE viHasCustomers    4
#DEFINE viHasVendors    5
#DEFINE viInventoryEnabled    6
#DEFINE viIsAccountantCopy    7
#DEFINE viMultiUserMode    8
#DEFINE viPayrollEnabled    9
#DEFINE viPriceLevelsEnabled    10
#DEFINE viSalesOrdersEnabled    11
#DEFINE viSalesTaxEnabled    12
#DEFINE viTimeTrackingEnabled    13

*--- Constant Group: ENVisibleIfNot
#DEFINE vinAccountantCopyExists    0
#DEFINE vinAssemblyItemsEnabled    1
#DEFINE vinClassesEnabled    2
#DEFINE vinEstimatesEnabled    3
#DEFINE vinHasCustomers    4
#DEFINE vinHasVendors    5
#DEFINE vinInventoryEnabled    6
#DEFINE vinIsAccountantCopy    7
#DEFINE vinMultiUserMode    8
#DEFINE vinPayrollEnabled    9
#DEFINE vinPriceLevelsEnabled    10
#DEFINE vinSalesOrdersEnabled    11
#DEFINE vinSalesTaxEnabled    12
#DEFINE vinTimeTrackingEnabled    13

*--- Constant Group: ENEnabledIf
#DEFINE eiAccountantCopyExists    0
#DEFINE eiAssemblyItemsEnabled    1
#DEFINE eiClassesEnabled    2
#DEFINE eiEstimatesEnabled    3
#DEFINE eiHasCustomers    4
#DEFINE eiHasVendors    5
#DEFINE eiInventoryEnabled    6
#DEFINE eiIsAccountantCopy    7
#DEFINE eiMultiUserMode    8
#DEFINE eiPayrollEnabled    9
#DEFINE eiPriceLevelsEnabled    10
#DEFINE eiSalesOrdersEnabled    11
#DEFINE eiSalesTaxEnabled    12
#DEFINE eiTimeTrackingEnabled    13

*--- Constant Group: ENEnabledIfNot
#DEFINE einAccountantCopyExists    0
#DEFINE einAssemblyItemsEnabled    1
#DEFINE einClassesEnabled    2
#DEFINE einEstimatesEnabled    3
#DEFINE einHasCustomers    4
#DEFINE einHasVendors    5
#DEFINE einInventoryEnabled    6
#DEFINE einIsAccountantCopy    7
#DEFINE einMultiUserMode    8
#DEFINE einPayrollEnabled    9
#DEFINE einPriceLevelsEnabled    10
#DEFINE einSalesOrdersEnabled    11
#DEFINE einSalesTaxEnabled    12
#DEFINE einTimeTrackingEnabled    13

*--- Constant Group: ENNonWageType
#DEFINE nwtAddition    0
#DEFINE nwtCompanyContribution    1
#DEFINE nwtDeduction    2
#DEFINE nwtDirectDeposit    3
#DEFINE nwtTax    4

*--- Constant Group: ENAccrualPeriod
#DEFINE apBeginningOfYear    0
#DEFINE apEveryHourOnPaycheck    1
#DEFINE apEveryPaycheck    2

*--- Constant Group: ENAcquiredAs
#DEFINE aaNew    0
#DEFINE aaOld    1

*--- Constant Group: ENTransactionMode
#DEFINE tmCardNotPresent    0
#DEFINE tmCardPresent    1

*--- Constant Group: ENCreditCardTxnType
#DEFINE ccttAuthorization    0
#DEFINE ccttCapture    1
#DEFINE ccttCharge    2
#DEFINE ccttRefund    3
#DEFINE ccttVoiceAuthorization    4

*--- Constant Group: ENDeliveryPolicy
#DEFINE dpDeliverAlways    0
#DEFINE dpDeliverOnlyIfRunning    1

*--- Constant Group: ENTrackLostEvents
#DEFINE tleAll    0
#DEFINE tleNone    1

*--- Constant Group: ENJournalLineType
#DEFINE jltDebit    0
#DEFINE jltCredit    1

*--- Constant Group: ENLineType
#DEFINE ltECPurchases    0
#DEFINE ltECSales    1
#DEFINE ltPurchases    2
#DEFINE ltSales    3
#DEFINE ltSubTotal    4
#DEFINE ltTaxOnPurchases    5
#DEFINE ltTaxOnSales    6
#DEFINE ltTotal    7

*--- Constant Group: ENServiceStatus
#DEFINE ssActive    0
#DEFINE ssExpired    1
#DEFINE ssNever    2
#DEFINE ssPending    3
#DEFINE ssSuspended    4
#DEFINE ssTerminated    5
#DEFINE ssTrial    6

*--- Constant Group: ENrowType
#DEFINE rtaccount    0
#DEFINE rtclass    1
#DEFINE rtcustomer    2
#DEFINE rtcustomerMessage    3
#DEFINE rtcustomerType    4
#DEFINE rtemployee    5
#DEFINE rtitem    6
#DEFINE rtjobType    7
#DEFINE rtlabel    8
#DEFINE rtmemorizedTxn    9
#DEFINE rtmemorizedReport    10
#DEFINE rtname    11
#DEFINE rtotherName    12
#DEFINE rtpaymentMethod    13
#DEFINE rtpayrollItem    14
#DEFINE rtsalesRep    15
#DEFINE rtsalesTaxCode    16
#DEFINE rtshipMethod    17
#DEFINE rtstate    18
#DEFINE rtstyle    19
#DEFINE rtterms    20
#DEFINE rttoDo    21
#DEFINE rtvendor    22
#DEFINE rtvendorType    23

*--- Constant Group: ENAddToMenu
#DEFINE atmFile    0
#DEFINE atmCompany    1
#DEFINE atmCustomers    2
#DEFINE atmVendors    3
#DEFINE atmEmployees    4
#DEFINE atmBanking    5

*--- Constant Group: ENQBFileMode
#DEFINE qbfmMultiUser    0
#DEFINE qbfmSingleUser    1

*--- Constant Group: ENPaySalesTax
#DEFINE pstMonthly    0
#DEFINE pstQuarterly    1
#DEFINE pstAnnually    2

*--- Constant Group: ENColType
#DEFINE ctAccount    0
#DEFINE ctAddr1    1
#DEFINE ctAddr2    2
#DEFINE ctAddr3    3
#DEFINE ctAddr4    4
#DEFINE ctAddr5    5
#DEFINE ctAging    6
#DEFINE ctAmount    7
#DEFINE ctAmountDifference    8
#DEFINE ctAverageCost    9
#DEFINE ctBilledDate    10
#DEFINE ctBillingStatus    11
#DEFINE ctBlank    12
#DEFINE ctCalculatedAmount    13
#DEFINE ctClass    14
#DEFINE ctClearedStatus    15
#DEFINE ctCostPrice    16
#DEFINE ctCreateDate    17
#DEFINE ctCredit    18
#DEFINE ctCustomField    19
#DEFINE ctDate    20
#DEFINE ctDebit    21
#DEFINE ctDeliveryDate    22
#DEFINE ctDueDate    23
#DEFINE ctDuration    24
#DEFINE ctEarliestReceiptDate    25
#DEFINE ctEstimateActive    26
#DEFINE ctFOB    27
#DEFINE ctIncomeSubjectToTax    28
#DEFINE ctInvoiced    29
#DEFINE ctIsAdjustment    30
#DEFINE ctItem    31
#DEFINE ctItemDesc    32
#DEFINE ctItemVendor    33
#DEFINE ctLabel    34
#DEFINE ctLastModifiedBy    35
#DEFINE ctLatestOrPriorState    36
#DEFINE ctMemo    37
#DEFINE ctModifiedTime    38
#DEFINE ctName    39
#DEFINE ctNameAccountNumber    40
#DEFINE ctNameAddress    41
#DEFINE ctNameCity    42
#DEFINE ctNameContact    43
#DEFINE ctNameEmail    44
#DEFINE ctNameFax    45
#DEFINE ctNamePhone    46
#DEFINE ctNameState    47
#DEFINE ctNameZip    48
#DEFINE ctOpenBalance    49
#DEFINE ctOriginalAmount    50
#DEFINE ctPaidAmount    51
#DEFINE ctPaidStatus    52
#DEFINE ctPaidThroughDate    53
#DEFINE ctPaymentMethod    54
#DEFINE ctPayrollItem    55
#DEFINE ctPercent    56
#DEFINE ctPercentChange    57
#DEFINE ctPercentOfTotalRetail    58
#DEFINE ctPercentOfTotalValue    59
#DEFINE ctPhysicalCount    60
#DEFINE ctPONumber    61
#DEFINE ctPrintStatus    62
#DEFINE ctProgressAmount    63
#DEFINE ctProgressPercent    64
#DEFINE ctQuantity    65
#DEFINE ctQuantityAvailable    66
#DEFINE ctQuantityOnHand    67
#DEFINE ctQuantityOnOrder    68
#DEFINE ctQuantityOnPendingBuild    69
#DEFINE ctQuantityOnSalesOrder    70
#DEFINE ctReceivedQuantity    71
#DEFINE ctRefNumber    72
#DEFINE ctReorderPoint    73
#DEFINE ctRetailValueOnHand    74
#DEFINE ctRunningBalance    75
#DEFINE ctSalesPerWeek    76
#DEFINE ctSalesRep    77
#DEFINE ctSalesTaxCode    78
#DEFINE ctShipDate    79
#DEFINE ctShipMethod    80
#DEFINE ctShipToAddr1    81
#DEFINE ctShipToAddr2    82
#DEFINE ctShipToAddr3    83
#DEFINE ctShipToAddr4    84
#DEFINE ctShipToAddr5    85
#DEFINE ctSONumber    86
#DEFINE ctSourceName    87
#DEFINE ctSplitAccount    88
#DEFINE ctSSNOrTaxID    89
#DEFINE ctSuggestedReorder    90
#DEFINE ctTaxLine    91
#DEFINE ctTaxTableVersion    92
#DEFINE ctTerms    93
#DEFINE ctTotal    94
#DEFINE ctTxnID    95
#DEFINE ctTxnNumber    96
#DEFINE ctTxnType    97
#DEFINE ctUnitPrice    98
#DEFINE ctUserEdit    99
#DEFINE ctValueOnHand    100
#DEFINE ctWageBase    101
#DEFINE ctWageBaseTips    102

*--- Constant Group: ENMatchCriterion
#DEFINE mcStartsWith    0
#DEFINE mcContains    1
#DEFINE mcEndsWith    2

*--- Constant Group: ENTxnEventType
#DEFINE tetARRefundCreditCard    0
#DEFINE tetBill    1
#DEFINE tetBillPaymentCheck    2
#DEFINE tetBillPaymentCreditCard    3
#DEFINE tetCharge    4
#DEFINE tetCheck    5
#DEFINE tetCreditCardCharge    6
#DEFINE tetCreditCardCredit    7
#DEFINE tetCreditMemo    8
#DEFINE tetDeposit    9
#DEFINE tetEstimate    10
#DEFINE tetInventoryAdjustment    11
#DEFINE tetInvoice    12
#DEFINE tetItemReceipt    13
#DEFINE tetJournalEntry    14
#DEFINE tetPurchaseOrder    15
#DEFINE tetReceivePayment    16
#DEFINE tetSalesOrder    17
#DEFINE tetSalesReceipt    18
#DEFINE tetSalesTaxPaymentCheck    19
#DEFINE tetTimeTracking    20
#DEFINE tetVendorCredit    21

*--- Constant Group: ENTxnEventOperation
#DEFINE teoAdd    0
#DEFINE teoModify    1
#DEFINE teoDelete    2

*--- Constant Group: ENObjectType
#DEFINE otNA    -1
#DEFINE otGUIDList    100
#DEFINE otBSTRList    101
#DEFINE otQBBaseRef    103
#DEFINE otQBBaseRefList    104
#DEFINE otARRefundCreditCardFilter    10000
#DEFINE otORARRefundCreditCardQuery    10001
#DEFINE otForm1099CategoryAccountMappingMod    10002
#DEFINE otCurrencyFilter    10003
#DEFINE otForm1099CategoryAccountMappingRet    10004
#DEFINE otMappingAccount    10005
#DEFINE otCategoryAccountMapping    10006
#DEFINE otPayrollLastPeriodRet    10007
#DEFINE otCurrencyFormat    10008
#DEFINE otCategoryAccountMappingMod    10009
#DEFINE otMultiCurrencyPreferences    10010
#DEFINE otSalesTaxReturnRet    10011
#DEFINE otVendorCreditMod    10012
#DEFINE otAccountantCopy    10013
#DEFINE otMappingAccountList    10014
#DEFINE otSalesTaxReturnRetList    10015
#DEFINE otCategoryAccountMappingModList    10016
#DEFINE otSalesTaxReturnLineRetList    10017
#DEFINE otCategoryAccountMappingList    10018
#DEFINE otInventorySiteFilter    10019
#DEFINE otORInventorySiteQuery    10020
#DEFINE otInventorySiteQuery    10021
#DEFINE otSalesTaxPayableQuery    10022
#DEFINE otORValueAdjustment    10023
#DEFINE otTxnFilterNoCurrency    10024
#DEFINE otORTransferInventoryQuery    10025
#DEFINE otTransferInventoryQuery    10026
#DEFINE otTransferInventoryMod    10027
#DEFINE otSalesTaxPaymentCheckLineAdd    10028
#DEFINE otSiteAddress    10029
#DEFINE otInventorySiteMod    10030
#DEFINE otTransferInventoryRet    10031
#DEFINE otInventorySiteRet    10032
#DEFINE otTransferInventoryLineMod    10033
#DEFINE otSalesTaxPayableRet    10034
#DEFINE otTransferInventoryLineRet    10035
#DEFINE otSalesTaxPaymentCheckAdd    10036
#DEFINE otSalesTaxPayableLineRet    10037
#DEFINE otInventoryAdjustmentLineMod    10038
#DEFINE otSalesTaxPaymentCheckMod    10039
#DEFINE otInventoryAdjustmentMod    10040
#DEFINE otTransferInventoryAdd    10041
#DEFINE otInventorySiteAdd    10042
#DEFINE otTransferInventoryLineAdd    10043
#DEFINE otSalesTaxPaymentCheckLineAddList    10044
#DEFINE otSalesTaxPayableLineRetList    10045
#DEFINE otSalesTaxPayableRetList    10046
#DEFINE otTransferInventoryLineModList    10047
#DEFINE otTransferInventoryRetList    10048
#DEFINE otTransferInventoryLineAddList    10049
#DEFINE otTransferInventoryLineRetList    10050
#DEFINE otInventoryAdjustmentLineModList    10051
#DEFINE otInventorySiteRetList    10052
#DEFINE otORInventorySiteORShipToEntity    10053
#DEFINE otMultiLocationInventoryPreferences    10054
#DEFINE otENAccountTypeList    102
#DEFINE otORPurchaseOrderLineRet    111
#DEFINE otORCreditMemoLineAdd    112
#DEFINE otORDateRangeFilter    113
#DEFINE otORTimeTrackingTxnQuery    114
#DEFINE otORNameFilter    115
#DEFINE otORPurchaseOrderLineAdd    116
#DEFINE otORAccountFilter    117
#DEFINE otORDiscountRate    118
#DEFINE otORTermsRet    119
#DEFINE otORRate    120
#DEFINE otORRefNumberFilter    121
#DEFINE otORItemLineRet    122
#DEFINE otORSalesPurchase    123
#DEFINE otORToDoListQuery    124
#DEFINE otORAccountListQuery    125
#DEFINE otOREntityRet    126
#DEFINE otORSalesPurchaseMod    127
#DEFINE otORListQuery    128
#DEFINE otORVendorListQuery    129
#DEFINE otORSalesReceiptLineRet    130
#DEFINE otORCustomerListQuery    131
#DEFINE otORItemLineAdd    132
#DEFINE otORMarkupRate    133
#DEFINE otOREstimateLineRet    134
#DEFINE otORInvoiceQuery    135
#DEFINE otORTxnQuery    136
#DEFINE otORInvoiceLineRet    137
#DEFINE otORPrice    138
#DEFINE otORTimeTrackingEntityFilter    140
#DEFINE otORApplyPayment    141
#DEFINE otORBillQuery    142
#DEFINE otORTxnDateRangeFilter    143
#DEFINE otORSalesReceiptLineAdd    144
#DEFINE otOREntityFilter    145
#DEFINE otORCreditMemoLineRet    146
#DEFINE otOREstimateLineAdd    147
#DEFINE otORItemRet    148
#DEFINE otORInvoiceLineAdd    149
#DEFINE otTxnVoid    150
#DEFINE otInvoiceFilter    151
#DEFINE otAccountListFilter    152
#DEFINE otReceivePaymentQuery    153
#DEFINE otListDelRet    154
#DEFINE otSalesReceiptQuery    155
#DEFINE otCreditCardChargeQuery    156
#DEFINE otCreditMemoQuery    157
#DEFINE otVendorListFilter    158
#DEFINE otCustomerListFilter    159
#DEFINE otPurchaseOrderQuery    161
#DEFINE otTxnFilter    162
#DEFINE otChargeQuery    163
#DEFINE otInvoiceQuery    164
#DEFINE otCreditCardCreditQuery    165
#DEFINE otVendorCreditQuery    166
#DEFINE otJournalEntryQuery    167
#DEFINE otListDel    168
#DEFINE otBillFilter    169
#DEFINE otListFilter    170
#DEFINE otTxnDateFilter    171
#DEFINE otCheckQuery    172
#DEFINE otTimeTrackingTxnFilter    173
#DEFINE otTxnVoidRet    174
#DEFINE otTxnDelRet    175
#DEFINE otTxnDel    176
#DEFINE otToDoListFilter    177
#DEFINE otBillQuery    178
#DEFINE otEstimateQuery    179
#DEFINE otEstimateLineRet    180
#DEFINE otSalesAndCustomersPreferences    181
#DEFINE otItemSalesTaxMod    182
#DEFINE otDateDrivenTermsAdd    183
#DEFINE otPreferencesRet    185
#DEFINE otOtherNameAdd    186
#DEFINE otSalesReceiptLineAdd    187
#DEFINE otAccountRet    188
#DEFINE otPaymentMethodAdd    189
#DEFINE otSalesReceiptRet    190
#DEFINE otCustomerMsgAdd    191
#DEFINE otItemNonInventoryRet    192
#DEFINE otVendorRet    193
#DEFINE otCreditCardCreditAdd    194
#DEFINE otSalesTaxPreferences    195
#DEFINE otTimeTrackingPreferences    196
#DEFINE otJournalDebitLine    197
#DEFINE otCreditCardChargeRet    198
#DEFINE otInvoiceLineGroupAdd    199
#DEFINE otBillRet    200
#DEFINE otJournalEntryRet    201
#DEFINE otAccountMod    202
#DEFINE otItemNonInventoryMod    203
#DEFINE otReceivePaymentRet    204
#DEFINE otPurchaseOrderLineGroupAdd    205
#DEFINE otVendorMod    206
#DEFINE otTimeTrackingAdd    207
#DEFINE otChargeRet    208
#DEFINE otEmployeeRet    209
#DEFINE otItemSalesTaxAdd    210
#DEFINE otSalesRepRet    211
#DEFINE otEstimateAdd    212
#DEFINE otCreditMemoRet    213
#DEFINE otCreditMemoLineRet    214
#DEFINE otItemGroupRet    215
#DEFINE otItemSalesTaxGroupRet    216
#DEFINE otItemOtherChargeRet    217
#DEFINE otStandardTermsRet    218
#DEFINE otAccountFilter    219
#DEFINE otRefNumberFilter    220
#DEFINE otInvoiceLineAdd    221
#DEFINE otVendorCreditAdd    222
#DEFINE otCustomerRet    223
#DEFINE otEstimateLineAdd    224
#DEFINE otEmployeeMod    225
#DEFINE otSalesRepMod    226
#DEFINE otModifiedDateRangeFilter    227
#DEFINE otCompanyRet    228
#DEFINE otItemGroupMod    229
#DEFINE otItemSalesTaxGroupMod    230
#DEFINE otItemOtherChargeMod    231
#DEFINE otAccountAdd    233
#DEFINE otSalesReceiptAdd    234
#DEFINE otCustomerMod    235
#DEFINE otSalesTaxCodeRet    236
#DEFINE otSalesOrPurchaseMod    237
#DEFINE otItemNonInventoryAdd    238
#DEFINE otVendorAdd    239
#DEFINE otSalesAndPurchaseMod    240
#DEFINE otCreditCardChargeAdd    241
#DEFINE otExpenseLineRet    242
#DEFINE otItemSubtotalRet    243
#DEFINE otEstimateLineGroupRet    244
#DEFINE otBillAdd    245
#DEFINE otCustomerTypeRet    246
#DEFINE otItemServiceRet    247
#DEFINE otItemDiscountRet    248
#DEFINE otJournalEntryAdd    249
#DEFINE otSalesReceiptLineGroupRet    250
#DEFINE otPurchasesAndVendorsPreferences    251
#DEFINE otSalesTaxCodeMod    253
#DEFINE otPurchaseOrderLineRet    254
#DEFINE otReceivePaymentAdd    255
#DEFINE otAccountingPreferences    256
#DEFINE otEmployeeAdd    257
#DEFINE otChargeAdd    258
#DEFINE otItemSubtotalMod    259
#DEFINE otSalesRepAdd    260
#DEFINE otAppliedToTxnRet    261
#DEFINE otJobTypeRet    262
#DEFINE otCreditMemoAdd    263
#DEFINE otItemPaymentRet    264
#DEFINE otCreditMemoLineAdd    266
#DEFINE otItemGroupAdd    267
#DEFINE otItemSalesTaxGroupAdd    268
#DEFINE otItemServiceMod    269
#DEFINE otInvoiceRet    270
#DEFINE otItemDiscountMod    271
#DEFINE otItemOtherChargeAdd    272
#DEFINE otShipMethodRet    273
#DEFINE otJournalCreditLine    274
#DEFINE otStandardTermsAdd    275
#DEFINE otVendorTypeRet    276
#DEFINE otCustomerAdd    277
#DEFINE otItemLineRet    278
#DEFINE otClassRet    280
#DEFINE otTxnLineDetail    281
#DEFINE otSalesAndPurchase    282
#DEFINE otJobsAndEstimatesPreferences    283
#DEFINE otNameRangeFilter    285
#DEFINE otItemPaymentMod    286
#DEFINE otFinanceChargePreferences    287
#DEFINE otTotalBalanceFilter    289
#DEFINE otSalesTaxCodeAdd    291
#DEFINE otTxnDateRangeFilter    293
#DEFINE otRefNumberRangeFilter    294
#DEFINE otClassMod    295
#DEFINE otSalesOrPurchase    296
#DEFINE otExpenseLineAdd    297
#DEFINE otItemSubtotalAdd    298
#DEFINE otEstimateLineGroupAdd    299
#DEFINE otCustomerTypeAdd    300
#DEFINE otItemServiceAdd    301
#DEFINE otToDoRet    302
#DEFINE otItemDiscountAdd    303
#DEFINE otSalesReceiptLineGroupAdd    304
#DEFINE otPurchaseOrderLineAdd    306
#DEFINE otEntityFilter    307
#DEFINE otPurchaseOrderRet    308
#DEFINE otItemInventoryRet    309
#DEFINE otJobTypeAdd    310
#DEFINE otAppliedToTxnAdd    311
#DEFINE otCheckRet    312
#DEFINE otItemPaymentAdd    313
#DEFINE otCreditMemoLineGroupRet    314
#DEFINE otItemGroupLineRet    315
#DEFINE otItemGroupLine    316
#DEFINE otInvoiceAdd    317
#DEFINE otToDoMod    318
#DEFINE otShipMethodAdd    319
#DEFINE otVendorTypeAdd    320
#DEFINE otReportsPreferences    321
#DEFINE otItemLineAdd    322
#DEFINE otDateDrivenTermsRet    324
#DEFINE otNameFilter    325
#DEFINE otOtherNameRet    326
#DEFINE otPayrollItemWageRet    327
#DEFINE otClassAdd    328
#DEFINE otItemInventoryMod    330
#DEFINE otSalesReceiptLineRet    331
#DEFINE otPaymentMethodRet    332
#DEFINE otCustomerMsgRet    333
#DEFINE otTimeTrackingEntityFilter    334
#DEFINE otCreditCardCreditRet    335
#DEFINE otInvoiceLineGroupRet    336
#DEFINE otOtherNameMod    338
#DEFINE otLinkedTxn    340
#DEFINE otToDoAdd    341
#DEFINE otPurchaseOrderLineGroupRet    343
#DEFINE otTimeTrackingRet    344
#DEFINE otItemSalesTaxRet    345
#DEFINE otPurchaseOrderAdd    346
#DEFINE otEstimateRet    347
#DEFINE otSetCredit    348
#DEFINE otAddress    349
#DEFINE otItemInventoryAdd    350
#DEFINE otInvoiceLineRet    351
#DEFINE otCheckAdd    352
#DEFINE otHostRet    353
#DEFINE otCreditMemoLineGroupAdd    354
#DEFINE otVendorCreditRet    355
#DEFINE otItemGroupLineAdd    356
#DEFINE otTermsQuery    357
#DEFINE otOtherNameQuery    358
#DEFINE otItemNonInventoryQuery    359
#DEFINE otCustomerQuery    360
#DEFINE otClassQuery    361
#DEFINE otItemInventoryQuery    362
#DEFINE otItemServiceQuery    363
#DEFINE otPaymentMethodQuery    364
#DEFINE otJobTypeQuery    365
#DEFINE otTimeTrackingQuery    366
#DEFINE otItemGroupQuery    367
#DEFINE otSalesTaxCodeQuery    368
#DEFINE otEmployeeQuery    369
#DEFINE otDateDrivenTermsQuery    370
#DEFINE otCustomerTypeQuery    371
#DEFINE otVendorTypeQuery    372
#DEFINE otCustomerMsgQuery    373
#DEFINE otItemOtherChargeQuery    374
#DEFINE otSalesRepQuery    375
#DEFINE otItemSalesTaxGroupQuery    376
#DEFINE otPayrollItemWageQuery    377
#DEFINE otItemSubtotalQuery    378
#DEFINE otAccountQuery    379
#DEFINE otEntityQuery    380
#DEFINE otItemDiscountQuery    381
#DEFINE otItemQuery    382
#DEFINE otItemPaymentQuery    383
#DEFINE otToDoQuery    384
#DEFINE otShipMethodQuery    385
#DEFINE otStandardTermsQuery    386
#DEFINE otVendorQuery    387
#DEFINE otItemSalesTaxQuery    388
#DEFINE otToDoRetList    389
#DEFINE otVendorCreditRetList    390
#DEFINE otExpenseLineAddList    391
#DEFINE otItemPaymentRetList    392
#DEFINE otTxnLineDetailList    393
#DEFINE otJobTypeRetList    394
#DEFINE otAccountRetList    395
#DEFINE otItemSalesTaxRetList    396
#DEFINE otSetCreditList    397
#DEFINE otPayrollItemWageRetList    398
#DEFINE otCustomerMsgRetList    399
#DEFINE otAppliedToTxnRetList    400
#DEFINE otChargeRetList    401
#DEFINE otORSalesReceiptLineAddList    402
#DEFINE otPurchaseOrderLineRetList    403
#DEFINE otItemSubtotalRetList    405
#DEFINE otReceivePaymentRetList    406
#DEFINE otPaymentMethodRetList    407
#DEFINE otItemNonInventoryRetList    408
#DEFINE otSalesReceiptLineRetList    409
#DEFINE otORPurchaseOrderLineRetList    410
#DEFINE otVendorRetList    411
#DEFINE otLinkedTxnList    412
#DEFINE otStandardTermsRetList    413
#DEFINE otInvoiceLineRetList    414
#DEFINE otItemSalesTaxGroupRetList    416
#DEFINE otAppliedToTxnAddList    417
#DEFINE otBillRetList    418
#DEFINE otItemLineRetList    419
#DEFINE otORTermsRetList    420
#DEFINE otCreditCardChargeRetList    421
#DEFINE otORCreditMemoLineRetList    422
#DEFINE otEmployeeRetList    423
#DEFINE otCustomerTypeRetList    424
#DEFINE otSalesRepRetList    425
#DEFINE otORPurchaseOrderLineAddList    426
#DEFINE otOtherNameRetList    427
#DEFINE otSalesTaxCodeRetList    428
#DEFINE otCustomerRetList    429
#DEFINE otORItemRetList    430
#DEFINE otOREntityRetList    432
#DEFINE otItemGroupRetList    433
#DEFINE otORCreditMemoLineAddList    434
#DEFINE otVendorTypeRetList    436
#DEFINE otOREstimateLineRetList    438
#DEFINE otJournalEntryRetList    439
#DEFINE otEstimateLineRetList    440
#DEFINE otORItemLineRetList    441
#DEFINE otCreditMemoLineRetList    442
#DEFINE otORInvoiceLineRetList    443
#DEFINE otShipMethodRetList    444
#DEFINE otClassRetList    445
#DEFINE otItemDiscountRetList    446
#DEFINE otItemInventoryRetList    447
#DEFINE otPurchaseOrderRetList    448
#DEFINE otSalesReceiptRetList    449
#DEFINE otCreditCardCreditRetList    450
#DEFINE otExpenseLineRetList    451
#DEFINE otEstimateRetList    452
#DEFINE otItemServiceRetList    453
#DEFINE otDateDrivenTermsRetList    454
#DEFINE otItemGroupLineList    456
#DEFINE otOREstimateLineAddList    457
#DEFINE otTimeTrackingRetList    458
#DEFINE otORItemLineAddList    459
#DEFINE otCreditMemoRetList    460
#DEFINE otCheckRetList    461
#DEFINE otItemOtherChargeRetList    462
#DEFINE otORSalesReceiptLineRetList    463
#DEFINE otInvoiceRetList    464
#DEFINE otORInvoiceLineAddList    465
#DEFINE otORReportPeriod    466
#DEFINE otORInventoryAdjustmentQuery    467
#DEFINE otORDepositQuery    468
#DEFINE otORReportAccountFilter    469
#DEFINE otORSalesTaxPaymentCheckQuery    470
#DEFINE otORReportItemFilter    471
#DEFINE otORReportData    472
#DEFINE otORDataExtDefQuery    473
#DEFINE otORDepositLineAdd    475
#DEFINE otORQuantityAdjustment    476
#DEFINE otORBillToPayRet    477
#DEFINE otORJournalLine    478
#DEFINE otORListTxn    479
#DEFINE otORCheckPrint    480
#DEFINE otORReportEntityFilter    481
#DEFINE otORTypeAdjustment    482
#DEFINE otListDataExt    483
#DEFINE otInventoryAdjustmentQuery    484
#DEFINE otBillToPayQuery    485
#DEFINE otCustomDetailReportQuery    486
#DEFINE otGeneralDetailReportQuery    489
#DEFINE otDataExtDefDel    490
#DEFINE otCustomSummaryReportQuery    491
#DEFINE otTxnDataExt    492
#DEFINE otListDeletedQuery    493
#DEFINE otGeneralSummaryReportQuery    495
#DEFINE otItemInventoryAssemblyQuery    497
#DEFINE otBudgetSummaryReportQuery    498
#DEFINE otJobReportQuery    500
#DEFINE otSalesTaxPaymentCheckQuery    501
#DEFINE otBillPaymentCreditCardQuery    502
#DEFINE otAgingReportQuery    503
#DEFINE otDepositFilter    504
#DEFINE otTimeReportQuery    506
#DEFINE otBillPaymentCheckQuery    507
#DEFINE otDepositQuery    508
#DEFINE otDepositInfo    509
#DEFINE otTxnDeletedQuery    510
#DEFINE otPaymentLine    512
#DEFINE otDataExtDelRet    513
#DEFINE otBillPaymentCheckAdd    514
#DEFINE otEarnings    515
#DEFINE otDataExtDel    516
#DEFINE otDeletedDateRangeFilter    517
#DEFINE otPayrollItemWageAdd    518
#DEFINE otReportEntityFilter    519
#DEFINE otInventoryAdjustmentAdd    520
#DEFINE otItemInventoryAssemblyLine    521
#DEFINE otBillToPayRet    522
#DEFINE otBillPaymentCheckRet    523
#DEFINE otDepositLineAdd    524
#DEFINE otReportTxnTypeFilter    525
#DEFINE otColData    527
#DEFINE otReceivePaymentToDepositRet    528
#DEFINE otBillPaymentCreditCardAdd    529
#DEFINE otTextRow    530
#DEFINE otColDesc    531
#DEFINE otInventoryAdjustmentRet    532
#DEFINE otTxnDeletedRet    533
#DEFINE otInventoryAdjustmentLineAdd    534
#DEFINE otReportPeriod    535
#DEFINE otQuantityAdjustment    536
#DEFINE otDataExtDefMod    537
#DEFINE otDataExtDefAdd    539
#DEFINE otReportItemFilter    540
#DEFINE otDepositLineRet    541
#DEFINE otDepositAdd    542
#DEFINE otBillPaymentCreditCardRet    543
#DEFINE otSalesTaxPaymentCheckRet    544
#DEFINE otInventoryAdjustmentLineRet    545
#DEFINE otReportData    546
#DEFINE otSickHours    547
#DEFINE otSubtotalRow    548
#DEFINE otSalesTaxPaymentCheckLineRet    549
#DEFINE otTotalRow    550
#DEFINE otDataExtMod    551
#DEFINE otDataExtAdd    552
#DEFINE otCashBackInfoAdd    553
#DEFINE otDataExtDefRet    554
#DEFINE otItemInventoryAssemblyAdd    555
#DEFINE otDataRow    556
#DEFINE otDepositRet    557
#DEFINE otReportAccountFilter    558
#DEFINE otEmployeePayrollInfo    559
#DEFINE otDataExtDefDelRet    560
#DEFINE otVacationHours    561
#DEFINE otCompanyActivityRet    562
#DEFINE otRowData    563
#DEFINE otDataExtRet    564
#DEFINE otValueAdjustment    565
#DEFINE otItemInventoryAssemblyRet    566
#DEFINE otListDeletedRet    567
#DEFINE otReportRet    568
#DEFINE otBillToPay    569
#DEFINE otCreditToApply    570
#DEFINE otDataExtDefQuery    571
#DEFINE otBillToPayRetList    572
#DEFINE otColDescList    573
#DEFINE otDepositRetList    574
#DEFINE otItemInventoryAssemblyLineList    575
#DEFINE otDepositLineAddList    576
#DEFINE otDepositLineRetList    577
#DEFINE otInventoryAdjustmentLineAddList    578
#DEFINE otReceivePaymentToDepositRetList    579
#DEFINE otColDataList    580
#DEFINE otORJournalLineList    581
#DEFINE otSalesTaxPaymentCheckRetList    582
#DEFINE otInventoryAdjustmentLineRetList    583
#DEFINE otSalesTaxPaymentCheckLineRetList    584
#DEFINE otTxnDeletedRetList    585
#DEFINE otDataExtRetList    586
#DEFINE otItemInventoryAssemblyRetList    587
#DEFINE otInventoryAdjustmentRetList    588
#DEFINE otBillPaymentCreditCardRetList    589
#DEFINE otEarningsList    590
#DEFINE otBillPaymentCheckRetList    591
#DEFINE otListDeletedRetList    592
#DEFINE otORReportDataList    593
#DEFINE otDataExtDefRetList    594
#DEFINE otENAssignToObjectList    595
#DEFINE otENIncludeColumnList    596
#DEFINE otENListDelTypeList    597
#DEFINE otENTxnDelTypeList    598
#DEFINE otENTxnTypeFilterList    599
#DEFINE otENRemoveFromObjectList    600
#DEFINE otColTitle    601
#DEFINE otEmployeeAddress    602
#DEFINE otClearedStatusMod    603
#DEFINE otColTitleList    604
#DEFINE otCurrentAppAccessRights    605
#DEFINE otCashBackInfoRet    606
#DEFINE otCompanyQuery    607
#DEFINE otOREarnings    608
#DEFINE otTxnFilterWithItemFilter    609
#DEFINE otORItemFilter    610
#DEFINE otItemFilter    611
#DEFINE otEmployeePayrollInfoMod    612
#DEFINE otORInvoiceLineMod    613
#DEFINE otORSalesOrderLineAdd    614
#DEFINE otSalesOrderQuery    615
#DEFINE otTxnFilterNoAccount    616
#DEFINE otORTxnNoAccountQuery    617
#DEFINE otORPurchaseOrderLineMod    618
#DEFINE otORSalesOrderLineRet    619
#DEFINE otSalesOrderLineAdd    620
#DEFINE otSalesOrderLineGroupRet    621
#DEFINE otInvoiceLineMod    622
#DEFINE otSalesOrderLineRet    623
#DEFINE otSalesOrderAdd    624
#DEFINE otTaxLineInfoRet    625
#DEFINE otInvoiceLineGroupMod    626
#DEFINE otSalesOrderRet    627
#DEFINE otPurchaseOrderMod    628
#DEFINE otReportClassFilter    629
#DEFINE otPurchaseOrderLineGroupMod    630
#DEFINE otInvoiceMod    631
#DEFINE otSalesOrderLineGroupAdd    632
#DEFINE otPurchaseOrderLineMod    633
#DEFINE otORSalesOrderLineAddList    634
#DEFINE otORSalesOrderLineRetList    635
#DEFINE otPurchaseOrderLineModList    636
#DEFINE otSalesOrderRetList    637
#DEFINE otORInvoiceLineModList    638
#DEFINE otInvoiceLineModList    639
#DEFINE otSalesOrderLineRetList    640
#DEFINE otORPurchaseOrderLineModList    641
#DEFINE otORReportClassFilter    642
#DEFINE otORItemInventoryAssemblyLine    645
#DEFINE otItemFixedAssetQuery    646
#DEFINE otORItemGroupLine    648
#DEFINE otOREstimateLineMod    649
#DEFINE otORSalesOrderLineMod    650
#DEFINE otORCreditMemoLineMod    651
#DEFINE otListDisplayAdd    652
#DEFINE otListDisplayMod    653
#DEFINE otTxnDisplayAdd    654
#DEFINE otTxnDisplayMod    655
#DEFINE otORReportModifiedDate    659
#DEFINE otPayrollDetailReportQuery    660
#DEFINE otPayrollSummaryReportQuery    661
#DEFINE otTxnDataExtWithMacro    662
#DEFINE otORListTxnWithMacro    663
#DEFINE otDataEventSubscriptionQuery    665
#DEFINE otUIEventSubscriptionQuery    666
#DEFINE otORMenuSubmenu    667
#DEFINE otUIExtensionSubscriptionQuery    668
#DEFINE otSubscriptionDel    669
#DEFINE otDataEventRecoveryInfoQuery    671
#DEFINE otORListTxnEvent    672
#DEFINE otCompanyFileEventSubscription    673
#DEFINE otENCompanyFileEventOperationList    674
#DEFINE otUIEventSubscriptionAdd    675
#DEFINE otTxnEventSubscription    676
#DEFINE otENTxnEventTypeList    677
#DEFINE otENTxnEventOperationList    678
#DEFINE otPayrollItemNonWageRet    679
#DEFINE otCreditMemoMod    680
#DEFINE otListEvent    681
#DEFINE otMenuExtensionSubscription    682
#DEFINE otEstimateMod    683
#DEFINE otUIExtensionSubscriptionRet    685
#DEFINE otCOMCallbackInfo    686
#DEFINE otCreditMemoLineMod    687
#DEFINE otFixedAssetSalesInfo    690
#DEFINE otEstimateLineMod    691
#DEFINE otDisplayCondition    692
#DEFINE otENVisibleIfList    693
#DEFINE otENVisibleIfNotList    694
#DEFINE otENEnabledIfList    695
#DEFINE otENEnabledIfNotList    696
#DEFINE otItemFixedAssetMod    697
#DEFINE otDataEventSubscriptionRet    700
#DEFINE otListEventSubscription    701
#DEFINE otENListEventTypeList    702
#DEFINE otENListEventOperationList    703
#DEFINE otCreditMemoLineGroupMod    704
#DEFINE otItemFixedAssetRet    705
#DEFINE otTxnEvent    706
#DEFINE otUIExtensionSubscriptionAdd    707
#DEFINE otCreditCardInfo    708
#DEFINE otItemInventoryAssemblyMod    709
#DEFINE otSubmenu    710
#DEFINE otUIEventSubscriptionRet    711
#DEFINE otDataEventRecoveryInfoRet    713
#DEFINE otEstimateLineGroupMod    714
#DEFINE otMenuItem    715
#DEFINE otTemplateRet    716
#DEFINE otSalesOrderLineMod    717
#DEFINE otReportModifiedDateRangeFilter    718
#DEFINE otDataEventSubscriptionAdd    719
#DEFINE otSalesOrderMod    721
#DEFINE otChargeMod    723
#DEFINE otFixedAssetSalesInfoMod    724
#DEFINE otCompanyFileEvent    725
#DEFINE otItemFixedAssetAdd    726
#DEFINE otSalesOrderLineGroupMod    727
#DEFINE otPayrollItemNonWageQuery    729
#DEFINE otORSalesOrderLineModList    730
#DEFINE otOREstimateLineModList    731
#DEFINE otCreditMemoLineModList    732
#DEFINE otORCreditMemoLineModList    733
#DEFINE otTxnEventSubscriptionList    735
#DEFINE otTemplateRetList    736
#DEFINE otEstimateLineModList    737
#DEFINE otListEventSubscriptionList    738
#DEFINE otPayrollItemNonWageRetList    739
#DEFINE otSalesOrderLineModList    740
#DEFINE otMenuItemList    742
#DEFINE otItemFixedAssetRetList    743
#DEFINE otORItemLineMod    744
#DEFINE otItemReceiptQuery    745
#DEFINE otItemReceiptRet    746
#DEFINE otExpenseLineMod    747
#DEFINE otBillMod    748
#DEFINE otItemLineMod    749
#DEFINE otItemGroupLineMod    750
#DEFINE otExpenseLineModList    751
#DEFINE otItemReceiptRetList    752
#DEFINE otORItemLineModList    753
#DEFINE otItemLineModList    755
#DEFINE otOREvent    758
#DEFINE otDataEvent    759
#DEFINE otUIEvent    761
#DEFINE otUIExtensionEvent    763
#DEFINE otDataEventList    764
#DEFINE otORProgCLSID    765
#DEFINE otHostInfo    766
#DEFINE otCurrencyAdd    767
#DEFINE otCurrencyMod    771
#DEFINE otCurrencyRet    772
#DEFINE otCurrencyQuery    775
#DEFINE otCurrencyRetList    776
#DEFINE otDataEventRecoveryInfoDel    778
#DEFINE otChargeFilter    779
#DEFINE otORChargeTxnQuery    780
#DEFINE otModifiedDateRange    781
#DEFINE otORTransactionModifiedDateRangeFilter    782
#DEFINE otTxnDateRange    783
#DEFINE otORTransactionDateRangeFilter    784
#DEFINE otORTransactionEntityFilter    785
#DEFINE otORTransactionAccountFilter    786
#DEFINE otORTransactionItemFilter    787
#DEFINE otORTransactionClassFilter    788
#DEFINE otORTransactionRefNumberFilter    789
#DEFINE otTransactionFilter    790
#DEFINE otORTransactionQuery    791
#DEFINE otTransactionQuery    792
#DEFINE otTxnTypeID    793
#DEFINE otListTypeID    794
#DEFINE otORCurrentWindow    795
#DEFINE otTransactionModifiedDateRangeFilter    796
#DEFINE otTransactionEntityFilter    797
#DEFINE otTransactionClassFilter    798
#DEFINE otTransactionItemFilter    799
#DEFINE otTransactionAccountFilter    800
#DEFINE otTransactionTypeFilter    801
#DEFINE otItemReceiptAdd    802
#DEFINE otLinkToTxn    803
#DEFINE otTransactionRet    804
#DEFINE otCurrentWindow    805
#DEFINE otTransactionDateRangeFilter    806
#DEFINE otItemReceiptMod    807
#DEFINE otTransactionRetList    808
#DEFINE otORPriceLevel    811
#DEFINE otPriceLevelAdjustment    812
#DEFINE otORPriceLevelPrice    813
#DEFINE otPriceLevelFilter    814
#DEFINE otORPriceLevelQuery    815
#DEFINE otPriceLevelQuery    816
#DEFINE otORPriceLevelRet    817
#DEFINE otPriceLevelMod    818
#DEFINE otPriceLevelRet    819
#DEFINE otPriceLevelPerItem    820
#DEFINE otPriceLevelAdd    821
#DEFINE otPriceLevelPerItemRet    822
#DEFINE otPriceLevelPerItemRetList    823
#DEFINE otPriceLevelPerItemList    824
#DEFINE otPriceLevelRetList    825
#DEFINE otHostQuery    826
#DEFINE otCompanyActivityQuery    827
#DEFINE otPreferencesQuery    828
#DEFINE otTemplateQuery    829
#DEFINE otReceivePaymentToDepositQuery    830
#DEFINE otORRatePriceLevel    831
#DEFINE otORDiscountLineAdd    832
#DEFINE otORSalesTaxLineAdd    833
#DEFINE otORCustomPrice    834
#DEFINE otORORCustomPrice    835
#DEFINE otORDiscountLineRet    836
#DEFINE otORSalesTaxLineRet    837
#DEFINE otDiscountLineAdd    838
#DEFINE otSalesTaxLineAdd    839
#DEFINE otShippingLineRet    840
#DEFINE otPriceLevels    841
#DEFINE otDiscountLineRet    842
#DEFINE otShippingLineAdd    843
#DEFINE otSalesTaxLineRet    844
#DEFINE otCreditCardTxnInfo    845
#DEFINE otCreditCardTxnResultInfo    846
#DEFINE otCreditCardTxnInputInfo    847
#DEFINE otORSalesReceiptLineMod    849
#DEFINE otBuildAssemblyFilter    850
#DEFINE otORBuildAssemblyQuery    851
#DEFINE otBuildAssemblyQuery    852
#DEFINE otItemAssembliesCanBuildQuery    853
#DEFINE otARRefundCreditCardQuery    854
#DEFINE otItemAssembliesCanBuildRet    855
#DEFINE otARRefundCreditCardAdd    856
#DEFINE otBuildAssemblyMod    857
#DEFINE otSalesReceiptLineMod    858
#DEFINE otRefundAppliedToTxnRet    859
#DEFINE otComponentItemLineRet    860
#DEFINE otBuildAssemblyRet    861
#DEFINE otDataExt    862
#DEFINE otSalesReceiptMod    863
#DEFINE otSalesReceiptLineGroupMod    864
#DEFINE otRefundAppliedToTxnAdd    865
#DEFINE otBuildAssemblyAdd    866
#DEFINE otARRefundCreditCardRet    867
#DEFINE otBuildAssemblyRetList    870
#DEFINE otARRefundCreditCardRetList    871
#DEFINE otRefundAppliedToTxnRetList    872
#DEFINE otDataExtList    873
#DEFINE otRefundAppliedToTxnAddList    874
#DEFINE otComponentItemLineRetList    875
#DEFINE otSalesReceiptLineModList    876
#DEFINE otORSalesReceiptLineModList    877
#DEFINE otVehicleQuery    878
#DEFINE otORBillingRate    879
#DEFINE otORCustomRate    880
#DEFINE otBillingRateAdjustment    881
#DEFINE otORBillingRateItem    882
#DEFINE otORORCustomRate    883
#DEFINE otBillingRateFilter    884
#DEFINE otORBillingRateQuery    885
#DEFINE otBillingRateQuery    886
#DEFINE otOdometerReadingAdd    887
#DEFINE otORVehicleMileageAdd    888
#DEFINE otVehicleMileageFilter    889
#DEFINE otORVehicleMileageQuery    890
#DEFINE otVehicleMileageQuery    891
#DEFINE otORBillingRateRet    892
#DEFINE otORSpecialItemRet    893
#DEFINE otPayrollItemMetaData    894
#DEFINE otSpecialItemAdd    895
#DEFINE otBillingRateRet    896
#DEFINE otTimeTrackingMod    897
#DEFINE otVehicleMileageAdd    898
#DEFINE otTermsMetaData    899
#DEFINE otCustomerMsgMetaData    900
#DEFINE otReceivePaymentMod    901
#DEFINE otJournalEntryMod    902
#DEFINE otCheckMod    903
#DEFINE otClassMetaData    904
#DEFINE otVehicleAdd    905
#DEFINE otSalesTaxCodeMetaData    906
#DEFINE otEntityMetaData    907
#DEFINE otBillingRateAdd    908
#DEFINE otShipMethodMetaData    909
#DEFINE otSpecialAccountAdd    910
#DEFINE otBillPaymentCheckMod    911
#DEFINE otAddressBlock    912
#DEFINE otCreditCardChargeMod    913
#DEFINE otCustomerTypeMetaData    914
#DEFINE otItemMetaData    915
#DEFINE otPaymentMethodMetaData    916
#DEFINE otJobTypeMetaData    917
#DEFINE otListMetaData    918
#DEFINE otJournalLineMod    919
#DEFINE otPriceLevelMetaData    920
#DEFINE otVehicleMetaData    921
#DEFINE otToDoMetaData    922
#DEFINE otBillingRatePerItemRet    923
#DEFINE otVehicleMileageRet    924
#DEFINE otCreditCardCreditMod    925
#DEFINE otVendorTypeMetaData    926
#DEFINE otVehicleMod    927
#DEFINE otBillingRateMetaData    928
#DEFINE otIncludeListMetaData    929
#DEFINE otTemplateMetaData    930
#DEFINE otSalesRepMetaData    931
#DEFINE otBillingRatePerItem    932
#DEFINE otVehicleRet    933
#DEFINE otAppliedToTxnMod    934
#DEFINE otAccountMetaData    935
#DEFINE otVehicleRetList    936
#DEFINE otBillingRatePerItemRetList    937
#DEFINE otJournalLineModList    938
#DEFINE otAppliedToTxnModList    939
#DEFINE otBillingRateRetList    940
#DEFINE otVehicleMileageRetList    941
#DEFINE otBillingRatePerItemList    942
#DEFINE otPaymentMethodListFilter    943
#DEFINE otENPaymentMethodTypeList    944
#DEFINE otORPaymentMethodListQuery    945
#DEFINE otUnitOfMeasureSetQuery    946
#DEFINE otWorkersCompCodeFilter    947
#DEFINE otORWorkersCompCodeQuery    948
#DEFINE otWorkersCompCodeQuery    949
#DEFINE otORMarkupRatePriceLevel    950
#DEFINE otDepositInfoMod    951
#DEFINE otORDepositLineMod    952
#DEFINE otListMerge    953
#DEFINE otListMergeRet    954
#DEFINE otCreditCardTxnInputInfoMod    955
#DEFINE otWorkersCompCodeMod    956
#DEFINE otRateEntry    957
#DEFINE otCreditCardTxnResultInfoMod    958
#DEFINE otMergeFrom    959
#DEFINE otWorkersCompCodeRet    960
#DEFINE otAccountTaxLineInfoRet    961
#DEFINE otDepositMod    962
#DEFINE otMergedTo    963
#DEFINE otBaseUnit    964
#DEFINE otUnitOfMeasureSetAdd    965
#DEFINE otSubscribedServices    966
#DEFINE otDepositLineMod    967
#DEFINE otMergedFrom    968
#DEFINE otDefaultUnit    969
#DEFINE otCreditCardTxnInfoMod    970
#DEFINE otCashBackInfoMod    971
#DEFINE otWorkersCompCodeAdd    972
#DEFINE otService    973
#DEFINE otMergeTo    974
#DEFINE otRateHistory    975
#DEFINE otRelatedUnit    976
#DEFINE otUnitOfMeasureSetRet    977
#DEFINE otUnitOfMeasureSetRetList    978
#DEFINE otWorkersCompCodeRetList    979
#DEFINE otDefaultUnitList    980
#DEFINE otServiceList    981
#DEFINE otRateEntryList    982
#DEFINE otDepositLineModList    983
#DEFINE otRelatedUnitList    984
#DEFINE otAccountTaxLineInfoRetList    985
#DEFINE otRateHistoryList    986
#DEFINE otApplyCheckToTxnAdd    987
#DEFINE otApplyCheckToTxnMod    988
#DEFINE otApplyCheckToTxnAddList    989
#DEFINE otApplyCheckToTxnModList    990
#DEFINE otORCurrencyFilter    991
#DEFINE otPriceLevelPerItemCurrency    992
#DEFINE otForm1099CategoryAccountMappingQuery    993
#DEFINE otENMappingCategoryList    994
#DEFINE otSalesTaxReturnLineQuery    995
#DEFINE otCurrencyExchangeRate    996
#DEFINE otORHomeCurrencyAdjustment    997
#DEFINE otPriceLevelPerItemRetCurrency    998
#DEFINE otSalesTaxReturnLineRet    999
#DEFINE otThisIsNotTheLast_MoreToComeInTheFuture    1000

*--- Constant Group: ENResponseType
#DEFINE rtNA    -1
#DEFINE rtItemNonInventoryAddRs    1001
#DEFINE rtEmployeeQueryRs    1002
#DEFINE rtEntityQueryRs    1003
#DEFINE rtItemDiscountModRs    1004
#DEFINE rtVendorTypeQueryRs    1006
#DEFINE rtDateDrivenTermsAddRs    1007
#DEFINE rtHostQueryRs    1008
#DEFINE rtItemInventoryAddRs    1009
#DEFINE rtOtherNameQueryRs    1010
#DEFINE rtItemOtherChargeModRs    1012
#DEFINE rtJournalEntryAddRs    1013
#DEFINE rtItemSubtotalAddRs    1014
#DEFINE rtCustomerQueryRs    1015
#DEFINE rtCustomerAddRs    1016
#DEFINE rtSalesTaxCodeAddRs    1018
#DEFINE rtItemGroupQueryRs    1019
#DEFINE rtAccountModRs    1020
#DEFINE rtCreditCardCreditQueryRs    1022
#DEFINE rtItemQueryRs    1023
#DEFINE rtTxnDelRs    1024
#DEFINE rtEmployeeModRs    1025
#DEFINE rtItemSalesTaxModRs    1026
#DEFINE rtSalesRepModRs    1027
#DEFINE rtJournalEntryQueryRs    1028
#DEFINE rtCustomerMsgAddRs    1029
#DEFINE rtShipMethodAddRs    1030
#DEFINE rtCustomerTypeAddRs    1031
#DEFINE rtCheckAddRs    1032
#DEFINE rtReceivePaymentAddRs    1033
#DEFINE rtVendorCreditAddRs    1034
#DEFINE rtItemNonInventoryModRs    1035
#DEFINE rtShipMethodQueryRs    1036
#DEFINE rtCreditMemoQueryRs    1037
#DEFINE rtClassQueryRs    1038
#DEFINE rtItemDiscountQueryRs    1039
#DEFINE rtItemServiceAddRs    1040
#DEFINE rtPurchaseOrderQueryRs    1041
#DEFINE rtItemInventoryQueryRs    1042
#DEFINE rtSalesReceiptAddRs    1043
#DEFINE rtSalesReceiptQueryRs    1044
#DEFINE rtToDoModRs    1045
#DEFINE rtEstimateQueryRs    1046
#DEFINE rtItemServiceQueryRs    1047
#DEFINE rtBillAddRs    1048
#DEFINE rtVendorAddRs    1050
#DEFINE rtItemInventoryModRs    1051
#DEFINE rtVendorCreditQueryRs    1052
#DEFINE rtItemPaymentAddRs    1053
#DEFINE rtDateDrivenTermsQueryRs    1054
#DEFINE rtCreditCardCreditAddRs    1055
#DEFINE rtItemSubtotalModRs    1056
#DEFINE rtCustomerModRs    1057
#DEFINE rtVendorTypeAddRs    1058
#DEFINE rtItemSalesTaxGroupAddRs    1059
#DEFINE rtChargeAddRs    1060
#DEFINE rtSalesTaxCodeModRs    1061
#DEFINE rtClassAddRs    1062
#DEFINE rtItemGroupAddRs    1063
#DEFINE rtItemSalesTaxQueryRs    1064
#DEFINE rtTimeTrackingQueryRs    1065
#DEFINE rtPayrollItemWageQueryRs    1066
#DEFINE rtCheckQueryRs    1067
#DEFINE rtItemOtherChargeQueryRs    1068
#DEFINE rtInvoiceQueryRs    1069
#DEFINE rtChargeQueryRs    1070
#DEFINE rtOtherNameAddRs    1071
#DEFINE rtCreditMemoAddRs    1072
#DEFINE rtToDoQueryRs    1073
#DEFINE rtCreditCardChargeAddRs    1074
#DEFINE rtPaymentMethodQueryRs    1075
#DEFINE rtCompanyQueryRs    1077
#DEFINE rtItemPaymentQueryRs    1080
#DEFINE rtJobTypeQueryRs    1081
#DEFINE rtAccountQueryRs    1082
#DEFINE rtItemDiscountAddRs    1083
#DEFINE rtItemServiceModRs    1084
#DEFINE rtCustomerMsgQueryRs    1085
#DEFINE rtVendorModRs    1086
#DEFINE rtItemPaymentModRs    1087
#DEFINE rtInvoiceAddRs    1088
#DEFINE rtBillQueryRs    1089
#DEFINE rtStandardTermsAddRs    1090
#DEFINE rtItemOtherChargeAddRs    1091
#DEFINE rtItemSubtotalQueryRs    1092
#DEFINE rtReceivePaymentQueryRs    1093
#DEFINE rtPaymentMethodAddRs    1095
#DEFINE rtPurchaseOrderAddRs    1096
#DEFINE rtCreditCardChargeQueryRs    1097
#DEFINE rtItemSalesTaxGroupModRs    1098
#DEFINE rtListDelRs    1099
#DEFINE rtClassModRs    1100
#DEFINE rtItemGroupModRs    1101
#DEFINE rtItemNonInventoryQueryRs    1102
#DEFINE rtTimeTrackingAddRs    1103
#DEFINE rtEstimateAddRs    1104
#DEFINE rtAccountAddRs    1105
#DEFINE rtPreferencesQueryRs    1106
#DEFINE rtJobTypeAddRs    1107
#DEFINE rtToDoAddRs    1108
#DEFINE rtCustomerTypeQueryRs    1109
#DEFINE rtVendorQueryRs    1110
#DEFINE rtTxnVoidRs    1111
#DEFINE rtSalesRepQueryRs    1112
#DEFINE rtStandardTermsQueryRs    1113
#DEFINE rtEmployeeAddRs    1114
#DEFINE rtItemSalesTaxAddRs    1115
#DEFINE rtOtherNameModRs    1116
#DEFINE rtSalesRepAddRs    1117
#DEFINE rtTermsQueryRs    1119
#DEFINE rtItemSalesTaxGroupQueryRs    1120
#DEFINE rtSalesTaxCodeQueryRs    1121
#DEFINE rtBillPaymentCreditCardQueryRs    1122
#DEFINE rtBillPaymentCheckQueryRs    1123
#DEFINE rtItemInventoryAssemblyQueryRs    1124
#DEFINE rtInventoryAdjustmentQueryRs    1125
#DEFINE rtListDeletedQueryRs    1126
#DEFINE rtDataExtDefQueryRs    1127
#DEFINE rtItemInventoryAssemblyAddRs    1128
#DEFINE rtCustomDetailReportQueryRs    1129
#DEFINE rtBillToPayQueryRs    1130
#DEFINE rtBillPaymentCreditCardAddRs    1131
#DEFINE rtGeneralSummaryReportQueryRs    1132
#DEFINE rtDepositQueryRs    1133
#DEFINE rtDataExtAddRs    1134
#DEFINE rtPayrollItemWageAddRs    1135
#DEFINE rtDataExtModRs    1136
#DEFINE rtGeneralDetailReportQueryRs    1137
#DEFINE rtJobReportQueryRs    1138
#DEFINE rtBudgetSummaryReportQueryRs    1139
#DEFINE rtBillPaymentCheckAddRs    1140
#DEFINE rtDepositAddRs    1141
#DEFINE rtDataExtDefAddRs    1142
#DEFINE rtDataExtDelRs    1143
#DEFINE rtDataExtDefModRs    1144
#DEFINE rtTimeReportQueryRs    1145
#DEFINE rtReceivePaymentToDepositQueryRs    1146
#DEFINE rtCompanyActivityQueryRs    1147
#DEFINE rtAgingReportQueryRs    1148
#DEFINE rtInventoryAdjustmentAddRs    1149
#DEFINE rtTxnDeletedQueryRs    1150
#DEFINE rtSalesTaxPaymentCheckQueryRs    1151
#DEFINE rtCustomSummaryReportQueryRs    1152
#DEFINE rtDataExtDefDelRs    1153
#DEFINE rtSalesOrderQueryRs    1154
#DEFINE rtSalesOrderAddRs    1155
#DEFINE rtPurchaseOrderModRs    1156
#DEFINE rtInvoiceModRs    1157
#DEFINE rtItemInventoryAssemblyModRs    1158
#DEFINE rtPayrollDetailReportQueryRs    1159
#DEFINE rtUIEventSubscriptionQueryRs    1160
#DEFINE rtSalesOrderModRs    1161
#DEFINE rtPayrollItemNonWageQueryRs    1162
#DEFINE rtUIExtensionSubscriptionQueryRs    1163
#DEFINE rtPayrollSummaryReportQueryRs    1165
#DEFINE rtTemplateQueryRs    1166
#DEFINE rtDataEventSubscriptionQueryRs    1167
#DEFINE rtDataEventRecoveryInfoQueryRs    1168
#DEFINE rtItemFixedAssetQueryRs    1169
#DEFINE rtChargeModRs    1170
#DEFINE rtEstimateModRs    1171
#DEFINE rtItemFixedAssetModRs    1172
#DEFINE rtItemFixedAssetAddRs    1173
#DEFINE rtUIExtensionSubscriptionAddRs    1174
#DEFINE rtUIEventSubscriptionAddRs    1175
#DEFINE rtCreditMemoModRs    1176
#DEFINE rtDataEventSubscriptionAddRs    1177
#DEFINE rtItemReceiptQueryRs    1179
#DEFINE rtQBXMLEvents    1180
#DEFINE rtBillModRs    1181
#DEFINE rtCustomSummaryReportQueryRq    1182
#DEFINE rtBillModRq    1183
#DEFINE rtBillAddRq    1184
#DEFINE rtReceivePaymentAddRq    1185
#DEFINE rtItemInventoryAssemblyModRq    1186
#DEFINE rtItemInventoryAssemblyAddRq    1187
#DEFINE rtReceivePaymentQueryRq    1188
#DEFINE rtToDoQueryRq    1189
#DEFINE rtDataExtModRq    1190
#DEFINE rtDataExtAddRq    1191
#DEFINE rtAgingReportQueryRq    1192
#DEFINE rtOtherNameQueryRq    1193
#DEFINE rtCustomerMsgAddRq    1194
#DEFINE rtCustomerTypeAddRq    1195
#DEFINE rtPayrollDetailReportQueryRq    1196
#DEFINE rtCheckQueryRq    1197
#DEFINE rtUIEventSubscriptionQueryRq    1198
#DEFINE rtCustomerMsgQueryRq    1199
#DEFINE rtSalesReceiptQueryRq    1200
#DEFINE rtVendorQueryRq    1201
#DEFINE rtCustomDetailReportQueryRq    1202
#DEFINE rtBillPaymentCreditCardQueryRq    1203
#DEFINE rtItemOtherChargeModRq    1204
#DEFINE rtItemOtherChargeAddRq    1205
#DEFINE rtItemServiceQueryRq    1206
#DEFINE rtSalesOrderModRq    1207
#DEFINE rtSalesOrderAddRq    1208
#DEFINE rtVendorTypeQueryRq    1209
#DEFINE rtBillPaymentCheckQueryRq    1210
#DEFINE rtPayrollItemNonWageQueryRq    1211
#DEFINE rtReceivePaymentToDepositQueryRq    1212
#DEFINE rtTimeTrackingAddRq    1213
#DEFINE rtStandardTermsQueryRq    1214
#DEFINE rtUIExtensionSubscriptionQueryRq    1215
#DEFINE rtItemDiscountQueryRq    1216
#DEFINE rtVendorTypeAddRq    1217
#DEFINE rtCreditMemoQueryRq    1218
#DEFINE rtItemReceiptQueryRq    1219
#DEFINE rtBillPaymentCreditCardAddRq    1220
#DEFINE rtVendorCreditQueryRq    1221
#DEFINE rtItemSubtotalQueryRq    1222
#DEFINE rtInventoryAdjustmentAddRq    1223
#DEFINE rtEntityQueryRq    1224
#DEFINE rtPurchaseOrderQueryRq    1225
#DEFINE rtVendorCreditAddRq    1226
#DEFINE rtPreferencesQueryRq    1227
#DEFINE rtItemInventoryAssemblyQueryRq    1228
#DEFINE rtGeneralSummaryReportQueryRq    1229
#DEFINE rtInvoiceModRq    1230
#DEFINE rtInvoiceAddRq    1231
#DEFINE rtBillQueryRq    1232
#DEFINE rtSalesTaxCodeAddRq    1233
#DEFINE rtItemServiceModRq    1234
#DEFINE rtItemServiceAddRq    1235
#DEFINE rtSalesOrderQueryRq    1236
#DEFINE rtSalesRepQueryRq    1237
#DEFINE rtListDeletedQueryRq    1238
#DEFINE rtAccountQueryRq    1239
#DEFINE rtJournalEntryAddRq    1240
#DEFINE rtPayrollSummaryReportQueryRq    1241
#DEFINE rtInvoiceQueryRq    1242
#DEFINE rtOtherNameModRq    1243
#DEFINE rtOtherNameAddRq    1244
#DEFINE rtTxnDisplayModRq    1245
#DEFINE rtTxnDisplayAddRq    1246
#DEFINE rtGeneralDetailReportQueryRq    1247
#DEFINE rtToDoAddRq    1248
#DEFINE rtDataExtDelRq    1249
#DEFINE rtSalesRepModRq    1250
#DEFINE rtSalesRepAddRq    1251
#DEFINE rtItemPaymentQueryRq    1252
#DEFINE rtPaymentMethodAddRq    1253
#DEFINE rtCompanyQueryRq    1254
#DEFINE rtDataExtDefModRq    1255
#DEFINE rtDataExtDefAddRq    1256
#DEFINE rtListDelRq    1257
#DEFINE rtEmployeeModRq    1258
#DEFINE rtEmployeeAddRq    1259
#DEFINE rtChargeQueryRq    1260
#DEFINE rtTemplateQueryRq    1261
#DEFINE rtTxnDeletedQueryRq    1262
#DEFINE rtJobTypeAddRq    1263
#DEFINE rtItemSalesTaxGroupModRq    1264
#DEFINE rtItemSalesTaxGroupAddRq    1265
#DEFINE rtDateDrivenTermsQueryRq    1266
#DEFINE rtItemGroupModRq    1267
#DEFINE rtItemGroupAddRq    1268
#DEFINE rtItemSalesTaxQueryRq    1269
#DEFINE rtCreditCardCreditAddRq    1270
#DEFINE rtDataEventSubscriptionQueryRq    1271
#DEFINE rtCustomerQueryRq    1272
#DEFINE rtDataEventRecoveryInfoQueryRq    1273
#DEFINE rtItemSubtotalModRq    1274
#DEFINE rtItemSubtotalAddRq    1275
#DEFINE rtDepositQueryRq    1276
#DEFINE rtAccountAddRq    1277
#DEFINE rtSalesReceiptAddRq    1278
#DEFINE rtCreditCardChargeAddRq    1279
#DEFINE rtItemFixedAssetQueryRq    1280
#DEFINE rtPayrollItemWageQueryRq    1281
#DEFINE rtItemSalesTaxGroupQueryRq    1282
#DEFINE rtClassAddRq    1283
#DEFINE rtChargeModRq    1284
#DEFINE rtChargeAddRq    1285
#DEFINE rtListDisplayModRq    1286
#DEFINE rtListDisplayAddRq    1287
#DEFINE rtEstimateModRq    1288
#DEFINE rtEstimateAddRq    1289
#DEFINE rtItemFixedAssetModRq    1290
#DEFINE rtItemFixedAssetAddRq    1291
#DEFINE rtTermsQueryRq    1292
#DEFINE rtBillPaymentCheckAddRq    1293
#DEFINE rtClassQueryRq    1294
#DEFINE rtPayrollItemWageAddRq    1295
#DEFINE rtUIExtensionSubscriptionAddRq    1296
#DEFINE rtSalesTaxCodeQueryRq    1297
#DEFINE rtInventoryAdjustmentQueryRq    1298
#DEFINE rtDepositAddRq    1299
#DEFINE rtJournalEntryQueryRq    1300
#DEFINE rtPaymentMethodQueryRq    1301
#DEFINE rtTxnDelRq    1302
#DEFINE rtItemSalesTaxModRq    1303
#DEFINE rtItemSalesTaxAddRq    1304
#DEFINE rtItemOtherChargeQueryRq    1305
#DEFINE rtItemGroupQueryRq    1306
#DEFINE rtTimeTrackingQueryRq    1307
#DEFINE rtDataExtDefDelRq    1308
#DEFINE rtUIEventSubscriptionAddRq    1309
#DEFINE rtBillToPayQueryRq    1310
#DEFINE rtDataEventRecoveryInfoDelRq    1311
#DEFINE rtStandardTermsAddRq    1312
#DEFINE rtTxnVoidRq    1313
#DEFINE rtCreditMemoModRq    1314
#DEFINE rtCreditMemoAddRq    1315
#DEFINE rtCustomerModRq    1316
#DEFINE rtCustomerAddRq    1317
#DEFINE rtSalesTaxPaymentCheckQueryRq    1318
#DEFINE rtCheckAddRq    1319
#DEFINE rtCustomerTypeQueryRq    1320
#DEFINE rtShipMethodQueryRq    1321
#DEFINE rtCreditCardChargeQueryRq    1322
#DEFINE rtDataEventSubscriptionAddRq    1323
#DEFINE rtTimeReportQueryRq    1324
#DEFINE rtItemNonInventoryModRq    1325
#DEFINE rtItemNonInventoryAddRq    1326
#DEFINE rtDateDrivenTermsAddRq    1327
#DEFINE rtSubscriptionDelRq    1328
#DEFINE rtCreditCardCreditQueryRq    1329
#DEFINE rtEstimateQueryRq    1330
#DEFINE rtShipMethodAddRq    1331
#DEFINE rtItemQueryRq    1332
#DEFINE rtEmployeeQueryRq    1333
#DEFINE rtClearedStatusModRq    1334
#DEFINE rtItemPaymentModRq    1335
#DEFINE rtItemPaymentAddRq    1336
#DEFINE rtItemInventoryQueryRq    1337
#DEFINE rtJobTypeQueryRq    1338
#DEFINE rtJobReportQueryRq    1339
#DEFINE rtHostQueryRq    1340
#DEFINE rtItemNonInventoryQueryRq    1341
#DEFINE rtPurchaseOrderModRq    1342
#DEFINE rtPurchaseOrderAddRq    1343
#DEFINE rtCompanyActivityQueryRq    1344
#DEFINE rtItemDiscountModRq    1345
#DEFINE rtItemDiscountAddRq    1346
#DEFINE rtItemInventoryModRq    1347
#DEFINE rtItemInventoryAddRq    1348
#DEFINE rtVendorModRq    1349
#DEFINE rtVendorAddRq    1350
#DEFINE rtDataExtDefQueryRq    1351
#DEFINE rtBudgetSummaryReportQueryRq    1352
#DEFINE rtTxnDisplayModRs    1353
#DEFINE rtTxnDisplayAddRs    1354
#DEFINE rtListDisplayModRs    1355
#DEFINE rtListDisplayAddRs    1356
#DEFINE rtDataEventRecoveryInfoDelRs    1357
#DEFINE rtSubscriptionDelRs    1358
#DEFINE rtClearedStatusModRs    1359
#DEFINE rtCurrencyQueryRq    1360
#DEFINE rtCurrencyModRq    1363
#DEFINE rtCurrencyAddRq    1364
#DEFINE rtCurrencyQueryRs    1366
#DEFINE rtCurrencyModRs    1369
#DEFINE rtCurrencyAddRs    1370
#DEFINE rtItemReceiptModRq    1372
#DEFINE rtItemReceiptAddRq    1373
#DEFINE rtTransactionQueryRq    1374
#DEFINE rtItemReceiptModRs    1375
#DEFINE rtItemReceiptAddRs    1376
#DEFINE rtTransactionQueryRs    1377
#DEFINE rtPriceLevelQueryRq    1378
#DEFINE rtPriceLevelModRq    1379
#DEFINE rtPriceLevelAddRq    1380
#DEFINE rtPriceLevelQueryRs    1381
#DEFINE rtPriceLevelModRs    1382
#DEFINE rtPriceLevelAddRs    1383
#DEFINE rtItemAssembliesCanBuildQueryRq    1384
#DEFINE rtBuildAssemblyQueryRq    1385
#DEFINE rtARRefundCreditCardQueryRq    1386
#DEFINE rtSalesReceiptModRq    1387
#DEFINE rtBuildAssemblyModRq    1388
#DEFINE rtBuildAssemblyAddRq    1389
#DEFINE rtARRefundCreditCardAddRq    1390
#DEFINE rtItemAssembliesCanBuildQueryRs    1391
#DEFINE rtBuildAssemblyQueryRs    1392
#DEFINE rtARRefundCreditCardQueryRs    1393
#DEFINE rtSalesReceiptModRs    1394
#DEFINE rtBuildAssemblyModRs    1395
#DEFINE rtBuildAssemblyAddRs    1396
#DEFINE rtARRefundCreditCardAddRs    1397
#DEFINE rtReceivePaymentModRq    1398
#DEFINE rtVehicleMileageAddRq    1399
#DEFINE rtBillingRateAddRq    1400
#DEFINE rtTimeTrackingModRq    1401
#DEFINE rtJournalEntryModRq    1402
#DEFINE rtVehicleModRq    1403
#DEFINE rtVehicleAddRq    1404
#DEFINE rtCreditCardCreditModRq    1405
#DEFINE rtVehicleQueryRq    1406
#DEFINE rtAccountModRq    1407
#DEFINE rtCreditCardChargeModRq    1408
#DEFINE rtBillPaymentCheckModRq    1409
#DEFINE rtSpecialItemAddRq    1410
#DEFINE rtVehicleMileageQueryRq    1411
#DEFINE rtCheckModRq    1412
#DEFINE rtSpecialAccountAddRq    1413
#DEFINE rtBillingRateQueryRq    1414
#DEFINE rtReceivePaymentModRs    1415
#DEFINE rtVehicleMileageAddRs    1416
#DEFINE rtBillingRateAddRs    1417
#DEFINE rtTimeTrackingModRs    1418
#DEFINE rtJournalEntryModRs    1419
#DEFINE rtVehicleModRs    1420
#DEFINE rtVehicleAddRs    1421
#DEFINE rtCreditCardCreditModRs    1422
#DEFINE rtVehicleQueryRs    1423
#DEFINE rtCreditCardChargeModRs    1424
#DEFINE rtBillPaymentCheckModRs    1425
#DEFINE rtSpecialItemAddRs    1426
#DEFINE rtVehicleMileageQueryRs    1427
#DEFINE rtCheckModRs    1428
#DEFINE rtSpecialAccountAddRs    1429
#DEFINE rtBillingRateQueryRs    1430
#DEFINE rtWorkersCompCodeQueryRq    1431
#DEFINE rtUnitOfMeasureSetQueryRq    1432
#DEFINE rtDepositModRq    1433
#DEFINE rtListMergeRq    1434
#DEFINE rtAccountTaxLineInfoQueryRq    1435
#DEFINE rtUnitOfMeasureSetAddRq    1436
#DEFINE rtWorkersCompCodeModRq    1437
#DEFINE rtWorkersCompCodeAddRq    1438
#DEFINE rtWorkersCompCodeQueryRs    1439
#DEFINE rtUnitOfMeasureSetQueryRs    1440
#DEFINE rtDepositModRs    1441
#DEFINE rtListMergeRs    1442
#DEFINE rtAccountTaxLineInfoQueryRs    1443
#DEFINE rtUnitOfMeasureSetAddRs    1444
#DEFINE rtWorkersCompCodeModRs    1445
#DEFINE rtWorkersCompCodeAddRs    1446
#DEFINE rtSalesTaxReturnQueryRq    1447
#DEFINE rtVendorCreditModRq    1448
#DEFINE rtSalesTaxCodeModRq    1449
#DEFINE rtForm1099CategoryAccountMappingQueryRq    1450
#DEFINE rtSalesTaxReturnLineQueryRq    1451
#DEFINE rtClassModRq    1452
#DEFINE rtPayrollLastPeriodQueryRq    1453
#DEFINE rtForm1099CategoryAccountMappingModRq    1454
#DEFINE rtSalesTaxReturnQueryRs    1455
#DEFINE rtVendorCreditModRs    1456
#DEFINE rtForm1099CategoryAccountMappingQueryRs    1457
#DEFINE rtSalesTaxReturnLineQueryRs    1458
#DEFINE rtPayrollLastPeriodQueryRs    1459
#DEFINE rtForm1099CategoryAccountMappingModRs    1460
#DEFINE rtInventoryAdjustmentModRq    1461
#DEFINE rtToDoModRq    1462
#DEFINE rtInventorySiteModRq    1463
#DEFINE rtInventorySiteAddRq    1464
#DEFINE rtTransferInventoryModRq    1465
#DEFINE rtTransferInventoryAddRq    1466
#DEFINE rtSalesTaxPaymentCheckModRq    1467
#DEFINE rtSalesTaxPaymentCheckAddRq    1468
#DEFINE rtInventorySiteQueryRq    1469
#DEFINE rtSalesTaxPayableQueryRq    1470
#DEFINE rtTransferInventoryQueryRq    1471
#DEFINE rtInventoryAdjustmentModRs    1472
#DEFINE rtInventorySiteModRs    1473
#DEFINE rtInventorySiteAddRs    1474
#DEFINE rtTransferInventoryModRs    1475
#DEFINE rtTransferInventoryAddRs    1476
#DEFINE rtSalesTaxPaymentCheckModRs    1477
#DEFINE rtSalesTaxPaymentCheckAddRs    1478
#DEFINE rtInventorySiteQueryRs    1479
#DEFINE rtSalesTaxPayableQueryRs    1480
#DEFINE rtTransferInventoryQueryRs    1481
#DEFINE rtThisIsNotTheLast_MoreToComeInTheFuture    1482

Adding custom data to QuickBooks invoices from FoxPro

2011-02-23T16:14:00.001-06:00

I finally figured out a bug in my VFP code that we use to add data to custom fields in QuickBooks invoices!!!!

Well, actually, it turns out that there was no a bug in *my* code at all… The bug (so to say) was in the qbfc.h constants file that I had used successfully for years to do this very task. However, apparently when I upgraded to QuickBooks 8.0, the Enumeration values for the various QuickBooks object types changed from what they were in the previous version, for which my qbfc.h file had worked just fine.

When programming QuicjkBooks with the QuickBooks SDK, you use various constants to describe what objects, actions, or transactions you want to create or edit. So, the best way to deal with this pattern in programming languages is to assign Enums for each value, which makes your code much easier to read, and modify; you see words rather than numbers, and, should the Enum values change, your code that uses the Enums will still work. However, it *is* important/necessary to update the Enum values to match the API of whatever you are programming against. Duh! So, in C#, the Enums and values live in a namespace and a dll file that you get with the SDK. But, In FoxPro, you have to build your own .h file to define and manage “constants”, which are basically used in the same way as Enums in C#.

The original qbfc.h file that I have came from a guy named Cris Musgrave. I found it somewhere on the internet several years ago. (Thanks, Cris.) The file had dozens of constant names and values assigned. I sure wish I new where Cris got these values, as it appears to be generated from some other source. Surely, he did not type in all the values himself! Also, it was from 2004, and work great with QB 2004, and so on, until I got to QB8.0. That’s when it quit (a couple of years ago, and I just now got motivated to find the problem!) I’ve tried to find out how to reach him, but I’ve had no luck. (Hey, Cris, give me a shout some time, please.)

So, it turns out the problem was simply that the constants from the qbfc.h file no longer match the integer values for QB8.0. Easy to fix, if I just can learn what the new values are. Well, I’ve looked all of the Google, and I cannot find such info. If you know where to find this valuable info, please let me know.

Here’s the VFP code that sets the object type when you are goinf to add/modify a custom data field on an existing invoice:

loDataExtMod.ORListTxn.TxnDataExt.TxnDataExtType.Setvalue(tdetInvoice)

So, in the above method call, the “tdetInvoice” is a reference to a constant value from the qbfc.h file, which was defined as 11, but as of QB8.0, I’ve learned that the actual value for the “tdetInvoice” object is 13!!! (See below to learn how I figured this out.) Obviously, I can now see that these values are subject to change with any given release of QuickBooks, so watch out. I sure will.

Here’s how I figured out that the correct value for the constant/Enum “tdetInvoice”:

I downloaded a sample C# app a QBFC sample from the Intuit web site, and I opened the Solution file in Visual Studio. I then used the Object Browser to peek inside the QBFC10.dll assembly to see the namespaces and Enum classes, and after some snooping around, I found the golden info that I needed:

Then, I wrote a line of code to see what value I got when I referenced this constant:

And, the Watch window in Visual studio will show you the value of a variable:

So, it’s a long, slow process, but I have now corrected my qbfc.h file, and my code is working again!!! I suspect there are other changes to, but I only use a small set of them, so, for now, my code works fine. I’d love to know how to extract all the Enum names and values from a dll so I could generate a full, accurate qbfc.f file. Anyone know how to do this?

Rails Authorization and Authentication

2010-11-17T21:25:00.002-06:00

Some developers confuse the terms Authentication and Authorization. At first, I also kind of lumped them both in the same bucket. Eventually, I figured out the differences, and wanted to address the issue here to help clarify things a bit.

Definitions:

User *authentication* is looking them up in the Users database to ensure they have an account in your system.

User *authorization* is a system of determining what areas of your app the User can access once they are authenticated into the site.

I use two popular Rails gems that pretty much give you a drop-in solution for authentication and authorization. Devise is a Rails gem for User Authentication, and CanCan (by Ryan Bates of RailsCasts fame) is for User Authentication.

I ran across these great articles on another blog that describes using Rails and CanCan together:

Article 1: Getting Started with Devise and CanCan The article includes very detailed steps and code samples for both Devise and CanCan.

Article 2: Devise and CanCan - Restful Resources for Administrators

You can also read my blog post about Getting started with Devise, which includes lots of other helpful Devise links to get you started.

WPF Hole Patterns

2010-11-17T20:33:00.004-06:00

After I got my head above water in C# and WPF back in 2008, I created and published a sample of my first C# work that used the WPF platform for the UI. See my WPF Hole Patterns application on CodePlex to take a look at some of the vector graphics that are possible with C#, as well as how clean and pretty a WPF UI can be.

WPF Hole Patterns app is a vector based, CAD-like geometry program for laying out circular and linear hole patterns. In all, between the app and the source code, I've had over 100 downloads, so hopefully, it's been helpful to some curious developers to see what they can learn from my efforts. I've since ported the app to Silverlight and used it as a practice field for learning the basics of the MVVM pattern. If you'd like the latest version in Silverlight, just drop me an email.

Another Example

You can also another great example (much better than mine) by checking out this Silverlight Live Geometry app on CodePlex. It's another vector based drawing program intended to show off the Silverlight vector canvas. You can find a live version of the app at the Codeplex site, or here: http://livegeometry.com/http://livegeometry.com/

Both apps include full source code in C# and can be a helpful too in learning some geometry-based programming in C#, as well as WPF and Silverlight drawing.

HAML example

2010-11-14T09:10:00.004-06:00

I wanted find out for myself what the reported HAML goodness is all about, so I spent a little time to educate myself on the basics, and then I took to converting one of my Rails erb files over to HAML. I’m posting the before and after results here just to give one more convincing example of how much easier it is to read and write HAML views than the more noisy erb you-must-close-every-tag format.
At the end of this article, I list a few links to resources I found useful as I was getting started with HAML in my Rails application development.

Before (erb):

<div class="page-heading">
 <h1>Quote: <%= @quote.formatted_id ></h1>
</div>

<= render 'form' >

<div id="tabs">
 <ul>
  <li><a href="#devices-tab">Devices</a></li>
  <li><a href="#options-tab">System Options</a></li>
  <li><a href="#reports-tab">Reports</a></li>
  <li><a href="#notes-tab">Notes</a></li>
  </ul>
 </div>

<div id="devices-tab">
 Devices Page
</div>

<div id="options-tab">
 Options Page
</div>

<div id="reports-tab">
 Reports Page
</div>

<div id="notes-tab">
 Notes Page
</div>

<script type="text/javascript">
 $(document).ready(function() {
 $( "#tabs" ).tabs();
 });
</script>

After (HAML):

.page-heading
  %h1 Quote #{@quote.formatted_id}

= render 'form'

#tabs
  %ul
    %li
      %a{:href => "#devices-tab"}Devices
    %li
      %a{:href => "#options-tab"}System Options
    %li
      %a{:href => "#reports-tab"}Reports
    %li
      %a{:href => "#notes-tab"}Notes

#devices-tab
  Devices Page

#options-tab
  Options Page

#reports-tab
  Reports Page

#notes-tab
  Notes Page

:javascript
  $(document).ready(function() {
  $( "#tabs" ).tabs();
  });

HAML links

Some Thoughts on HAML by Rob Conery

Daniel Fischer says HAML is beautiful poetry

This article by Eric Davis exposes why he thinks HAML is bad, so you may want to study what he has to say

HAML cheat sheet

another HAML Cheat Sheet on http://cheat.errtheblog.com

HAML questions on StackOverflow

HAML user group on Google

http://www.rubyinside.com/haml-a-new-view-template-language-for-rails-235.html

http://haml-lang.com/

Learn more about HAML on Wikipedia

Latest HAML links on Coder I/O

Use this tool to automatically convert erb and html to HAML

HAML Videos

A video on HAML by Jason McCay from BarCamp Birmingham 2008-04-12

A HAML video from John Schult at merb day Atlanta 2008-12-06

HAML and SASS video (2007-11-20) - http://www.podcast.tv/video-episodes/episode-038-haml-and-sass-in-15-minutes-5214343.html

HAML and SASS video on Doctype video podcast Episode 38

Shredder vs Grinder vs Granulator

2010-08-24T23:35:00.000-05:00

Announcing a new blog post on our Jordan Reduction Solutions web site comparing the different functions of a shredder versus a grinder versus a granulator. Our engineering team has compiled a brief summary comparing each of these pieces of equipment used in grinding, shredding, and granulating processes in industrial applications. Follow this link to compare a shredder, a grinder, and a grinder to a granulator.

WordPress is double awesome

2010-08-15T22:38:00.002-05:00

I've just got say "WOW!" on this one... I recently wanted to add a blog to one of our corporate web sites so we could begin publishing a few articles about the equipment we manufacture in that division (heavy industrial shredders). Now, I had set up a Blogger account back in 2009 for my personal blogging effort, where I post mostly about software development stuff I'm working on or studying. But for this new corporate blogging plan I knew I wanted it living on our own server that we would fully control, rather than the Blogger model where your stuff is kind of under some control of Blogger. (Not that they are evil or anything, I'm just saying it didn't seem like the right choice for a corporate blog)

Anyway, I had heard about WordPress in the past, but never really knew what it was all about. Turns out... It's VERY powerful, simple to install, easy to use, and free.

All you do is download the zip file from WordPress.org, then FTP it to a folder on your web hosting company, say in a /blog folder. It has great instructions on how to configure MySql to host your blog, and you have to edit a config file to wire it up once the database is setup. (MySql database is included in most web hosting accounts. Our corporate web sites live on 1and.com and the installation and configuration went very well).

The whole thing is written in PHP. Now, I know nothing about PHP but that really doesn't matter. There's a Control Panel that you hit with your browser to configure everything. You can create as many Authors as you want, you can create Categories for your posts, installing Themes is easy, and there are tons of useful plugins that are available to do all kinds of cool stuff. There is a huge community around this software, and I plan to dig into that a little more in the future.

I'm not trying to give a complete tutorial on how install and set it up. Those topics have been covered in tons of places already. My point is that this "tool" is awesome! I learned the basics and had it installed, configured, and live all in one stay-up-late evening. I'm sure you can too.

Oh, by the way... you can see the blog here: http://www.JordanReductionSolutions.com/blog

Industrial Shredders and Tire Shredders are on the move

2010-07-04T08:24:00.001-05:00

I’ve been at Jordan Machine Company for about 18 years now, and for many of those years we have been a key vendor to what is now Jordan Reduction Solutions - a manufacturer who designs and installs heavy duty industrial shredders, tire shredder (like the PT-6000 Passenger Tire Shredder).

All of these machines are really quite impressive in their brute force way of ripping and tearing apart anything you throw at them. You can see several impressive videos on their web site on the shredder videos page.

Granulator

For instance, the granulator machine is for fine shredding and grinding of materials like plastic, PVC, wood, and just about anything else you throw at it. These are the smallest of all the machines, and cut with a high-speed rotor machine from solid steel, and has replaceable hardened knives that can be swapped out when the wear.

Tire Shredder

I’ve personally stood over a tire shredder and looked into the cutting chamber while it ripped up a car tire in seconds and dropped out little bits of rubber through the discharge screen. The sound is absolutely incredible; like something you’d hear in a scary movie. They can shred up the whole tire all at once, even that heavy bead that’s on the inside where the tire mounts to the rim.

Rubber Grinder

Some of the rubber grinder machines can even separate the wire out of the rubber, since that is required in some applications. The tire rubber (sometimes called “tire shreds” or "crumb rubber") is used for a variety of things from Tire Derived Fuel to manufacturing rubber hoses and mats, to playground coverings. Jordan doesn’t market the rubber products that these machines generate, they just specialize in helping companies get the tires shredded up.

Hog Mill and Hog Grinder

These Grinders machines were once actually called “hog mills” or "hog grinders" because way back in time, they were commonly used to grind up, well, hogs for the food processing industry. These days they have become very popular for other industrial grinding applications like plastic grinding. These machines were originally designed and sold by Mitts and Merrill, so many of them would be known by that brand.

Twin Shaft Shredder

Then there are the dual shaft, or, twin shaft shredders. These machines have two shafts, rotating in opposite directions, and each shafts is loaded full of thick cutting knives with hooks on them to grab the product and pull it into the machine, chop it up, and discharge it out the bottom. The shafts are hex shaped, and the knives also have an internal hex shape so they can be driven by the shafts. The machines typically rotate at slower speeds, and they can also be equipped with screens to filter and refine the product size that comes out of the shredding process. Other ways to refine the process include using thinner knives, or adding more hooks onto the knives, and even altering the reach of each hook to grab more or less of the product being processed.

Wrapping up

They also have plenty of shredding equipment set up in a test lab where customers send in samples of product they’d like to be shredded up into various sizes. I’ve seen them chop up carpet scraps, entire wooden pallets, and they can even grind up large bails of rubber and various plastics into small shavings or pellets. The machines use a qualifying screen to determine the final particle size, so they can swap out the screens and achieve different output.

So that’s a little info on what it’s like to be involved in the shredder industry. Jordan Reduction Solutions is a great company to work with for your shredding, chopping, and grinding needs for industrial applications. Please check them out at the links I provided at the top of this article.

Devise authentication for Rails

2010-06-16T10:43:00.003-05:00

I am proud to report that I have successfully installed and used the Devise authentication gem in my little test app that I am building learn Rails. I’m still a newbie at all this stuff, so anything that I can “gem install” and then hack my way through configuring and actually see the thing work in my app always brings a smile to my face. The Introducing Devise (#209) and Customizing Devise (#210) screencasts on RailsCasts.com really helped me a lot by showing how simple it is to set it up and do some customization. Plus, the documentation for basic configuration and use is pretty easy to follow. That’s always a good thing to see in these gems. Since I’m still playing around on Rails 2.3.5, I had to use version 1.0.7 of Devise, but they do have a Rails 3 version on the download page too, so be sure you use the right version.

With Devise in place in your app (it only requires a few lines to configure it, see the documentation on the web site for how to set it up), not only can you handle all the basic needs of authenticating a user login from your Users table (without writing as single line of code!), it also gives you built-in functions to create new user accounts, emailing them their forgotten password, and letting them change their password while logged in. Beyond those basics, you can then easily restrict access to certain parts of your app to only those users of a certain role. You simply create a Model for each role that you want to work with in your app.

I originally found some code samples for a roll-your-own authentication approach on the Building a New Web Site with Rails blog post over at a ThinkingInRails.com, and it did show me how to approach this if I wanted to have and maintain my own code base for this matter, but I really wanted to use a ready-made solution for this so I could move on to other matters in my Rails learning.
So, at this point, I must say that I’m going with the Devise gem for authentication in my Rails apps (like I have a lot of Rails apps, but hey, this thing is a great way to go when that does happen).

Other Devise resources:

Railscasts episode #209 Introducing Devise
Railscasts episode #210 Customizing Devise
Blog post by authors at <plataformatec/> introducing Devise
There is a fairly active Devise discussion group over on Google Groups.
Devise ver 1.0.07 Readme (for Rails 2.3.5)
Devise ver 1.1.rc1 Readme (for Rails 3 Beta 4)
Blog post: Comparison of various Rails authentication solutions
Rails authentication solutions discussed on Stack Overflow
Article 1: Getting Started with Devise and CanCan The article includes very detailed steps and code samples for both Devise and CanCan.
Article 2: Devise and CanCan - Restful Resources for Administrators

Ruby on Rails forever!

2010-05-26T22:35:00.001-05:00

May 26, 2010 - Last night I attended my first ever Ruby users group meeting. It's a meeting of the RubyHam Yahoo group for us folks here in Birmingham, Alabama. There were about 15 people there, and four short presentations on various Ruby and Rails topics, most of which were over my head at this point in my Ruby walk.

I began my study of Ruby and the Ruby on Rails framework in early April 2010. With my long FoxPro background (1992) and some .Net (2008), I’ve pretty much been a Microsoft man for a long time, so I'm not really sure what drew me to study Ruby and the Rails framework in the first place. I guess I'm just an easy sell on coding tools that sound cool. I knew the basics of the MVC pattern from my recent study of ASP.Net MVC, so I kind of knew what to expect, since Rails is an MVC framework too.

Mac, Windows, Linux? - At work I'm a Microsoft guy, but at home in the evenings I dance on the Apple floor (since about 2006) with my beautiful white iMac 20”. Since all of this was going to be new to me anyway, I decided to go the route that was the most foreign to me so I could really learn a lot of new things from this venture… So, I decided to setup that unsuspecting Mac to explore this dark new world.

Terminal Window vs. IDE…

I am an IDE guy, and not a terminal window guy, so I started out by installing the NetBeans 6.8 IDE (free, and it runs on Linux, Windows, and OSX). There are several choices when it comes to Ruby IDEs: RadRails from Aptana (free), Ruby In Steel (not free), RubyMine (not free), and many more. You can read this blog post to learn the pros and cons of some of these (and perhaps find a few more choices down in the blog comments). You’ll want to study them all to see which one you like best. Note: Ruby/Rails doesn’t require an IDE… you can do it all from the command line, but surely you’ll want a good IDE of some sort.

Database Choices…

The Rails framework (that is: the generated app it creates) defaults to work with the SQLite database thingy, which I knew little about, other than its simple life as an embedded database, which is a cool thing for sure. But I wanted to go with a more complex stack using MySql just because it seemed like a more big-boy thing to do. So I downloaded, installed, and configured MySql (for the first time ever, since I’ve always used Microsoft SQL Server) and now some of those mysteries about MySQL are now cleared up for me as well.

Now, I'm still a relative newbie on Mac stuff that takes me to that scary Terminal window, and man, it took some work to get my machine all gem'd up and ready for Ruby / Rails / MySql development, but I somehow stumbled through it all by surfing around for instructions. I'm still not exactly sure what all those ‘sudo’ commands did, but hey, it now works.

On Max OSX, Ruby is already installed with the OS, but I still had to get the rest of the bits in place. I may have installed a few things along the way that were already in present, but it seemed to work out fine.

First Rails app…

So there I was… Ruby, RubyGems, Rails, MySql, NetBeans 6.8. Ready to rock!

NetBeans has a New Project wizard for Ruby on Rails apps, so I fired that off to create my first ever Ruby on Rails app. The Project Wizard guides you through choosing your project name and location, Ruby version, database choice, web server, and Rails version. After the project is generated, if you decide to change which databases engine you’d like to use, you just edit the database.yml config file in the projects /Configuration folder to tell it which database adapter to use.

(I later setup and tested SQLite and it was cool to get that working too. Seems like I had to install some Ruby SQLite gems in the environment to get it set up.)

So the whole install/configure thing was surrounded with several mysterious activities to get everything in the environment setup properly, but I did it. I can't express the feeling of success I had after spending a couple of hours hacking away at my machine to install all this stuff, much of which I didn't understand at the time.

By "success" I simply mean that I can now:

start MySql server (I have not set it up to automatically start up yet. I don’t want it running all the time)
launch the NetBeans IDE and create a new Ruby on Rails project
‘script/generate scaffold’ - code generates a model, the views, and the controller (from the IDE, mind you, not that crazy command line)
‘migrate’ that model schema to the database (again, from the NetBeans IDE)
and finally, hit the Run button to watch the web server start up and take me to the default generated landing page for my app.

That wasn’t so bad..

Hearing all those smart guys talking in the room last night, I'd say I've got a LOT to learn from here, but I guess they all started where I am today, or even where I was back April wondering what this Ruby thing is all about.

You can do it too…

Now it’s your turn to give Rails a test drive. Configuring the environment is different on every OS platform, so depending on what OS you’re running (Mac OSX, Windows, or Linux) you’ll just have to surf around and find the instructions.

Here is a link to basic Ruby installation instructions for each OS. Then, you’ll still have to do some more work to install the Ruby on Rails framework.
Here’s is her set of instructions you can follow which guide you through installing Ruby, Ruby Gems, and Ruby on Rails.

Sadly, like many resources on the internet, the setup information is scattered all about. Many instructions assume you already know certain things about the platform. And there are different versions of everything… Ruby has a version, Rails has a versions, gems have versions. Heck, the gem installer even has versions. Oh yeah, and what is a gem in the first place? (You’ll find out soon enough once you get started.) I swear, it seems like more than you can keep straight at first. Oh, wait, but there’s RVM (Ruby Version Manager, I think). What the heck is that all about? Maybe I’ll find out if I keep digging.

Resources to help *YOU* get started

You can Google “Ruby on Rails” and get more info than you can shake a stick at, but below I'll list out some resources that were helpful to get me started (I’ll add more to the list when I can go back and find them). There are podcasts, videos, and blogs galore.

RailsTutourial.org (Check out the online Book link at the top of the page)
http://www.sitepoint.com/books/rails2/samplechapters.php (free book chapters in PDF, including setup for each OS)
http://guides.rubyonrails.org/ (good getting started info from the mail Rails site)
http://www.ruby-forum.com/ (very active user forum)
http://railscasts.com/ (videos. very good videos!)
youtube videos (more videos)
http://5by5.tv/rubyshow ( a good podcast)
http://www.buildingwebapps.com/learningrails (audio lessons and video screencasts)
RubyFlow.com Daily Ruby/Rails links added my community members
See more resource links here: Resources for getting started with Ruby on Rails

Using Linq to count rows in a DataTable based on a field value

2010-02-17T12:49:00.001-06:00

// Using Linq To DataSet to count rows based on a filter
// compared to
// Using the plain old Select() method that's been on DataTables since the beginning.

// Learn more about Linq To DataSet here: http://msdn.microsoft.com/en-us/library/bb386977(VS.100).aspx

using System;
using System.Linq;
using System.Data;
using System.Data.Common;


namespace ConsoleApplication
{

class Program
{
static void Main(string[] args)
{
DataTable dt = new DataTable();
dt.Columns.Add("nMenuLevel", Type.GetType("System.Int32"));
dt.Rows.Add(new object[] { 1 });
dt.Rows.Add(new object[] { 1 });
dt.Rows.Add(new object[] { 2 });
dt.Rows.Add(new object[] { 3 });

// Here's one way using Linq
int linqCount1 = (from DataRow row in dt.Rows where (int)row["nMenuLevel"] == 1 select row).Count();
Console.Write("linqCount1 = " + linqCount1.ToString() + "\n\n");

// Here's another way using Linq
int linqCount2 = dt.AsEnumerable().Where(c => c.Field("nMenuLevel") == 2).Count();
Console.Write("linqCount2 = " + linqCount2.ToString() + "\n\n");

// Here's a non-Linq way, using the old Select() method thats been available on DataTables
// since the beginning.  It's acutally much shorter and easier to read.
// But watch out! Notice this Select syntaxt only requires 1 equal sign, not 2.
int countWithSelect = dt.Select("nMenuLevel = 3").Count();
Console.Write("countWithSelect = " + countWithSelect.ToString() + "\n\n");

Console.ReadLine();

}
}

}

wwBusinessPro - Article 2: Configuring Child classes (wwBusProItemList)

2010-02-01T13:22:00.002-06:00

<< Back to Index

Another enhancement I added to wwBusinessPro was to allow for Child record collections to be easily used with a Parent BO.

When using a wwBusProParent, you set a few properties on the Parent that tell it about the Child class. Then, the Parent will create the Child class for you. So, when you’re working with your BO’s in code (after everything is all configured), you do not create the Child, you let the Parent do that. You will create a VCX library and add a Child class for each Child collection in there (based on wwBusProItemList), with its Child properties already set up. This allows the Parent to create the Child when he needs it. So you can see how this works, if you were to follow the path of the Get() method (remember, this is a key extension method I added in wwBusProParent), you will see that the Parent creates the Child object and attaches it to its oLineItems property. So, once your Child classes are configured in a VCX, you will not actually have to write any code to access them (unless you are doing some special case, custom coding), you just set up the Parent so he can find them. The Parent will handle all that for you, including the fetching of the related Child records.

wwBusinessPro Setup Instructions

2010-01-22T23:41:00.002-06:00

<< Back to Index

Added 02/02/2010 12:41 am

wwBusinessPro - Article 1: String Lookups

2010-01-21T10:58:00.002-06:00

<< Back to Index

I’ve written an extension library on top of the West Wind wwBusiness classes. You can read my original post on my work here. In my enhanced library, which I've named wwBusinessPro!, one of the things I've added is a lookup method that will handle String ID lookup values in addition to the native handling of Integer PK’s. The base wwBusiness library only works with Integer PK lookups, and I needed an enhancement to work with String lookups to get started with wwBusiness in my app.

When using my wwBusinessPro class, the main method that you call to do a lookup is the Get() method. You will call this method even when doing a Integer PK lookup because it will expose all the other extensions I've added to the library (more on that later).

So, the Get() method accepts one parameter which can be an Integer or a String.

oJob.Get(123) && An Integer PK lookup

- Or -

oJob.Get(‘123’) && A String lookup

Now, on each Business Object class that you create, you need to specify the following properties to allow any kind of lookup to work. (This is how the base wwBusiness functions, so this is not a new feature in wwBusinessPro!, except that I have extended it to work with String values too). The cPKField setting is required for all cases, and cLookupField is only required for String-based key values, in which case you must specify the same column names for both properties.

cPKField (This property is required. Choose either and Integer Pk column or a String key value column)
For Integer PK’s set this value to the name of the Integer PK column in the table. (basic wwBusiness feature)
For String PK’s set this value to the name of the String key value column in the table. (new feature)
Note: this key value is what will be used to locate your record when saving changes to existing records. For String key values, be sure you do not use Set Exact Off or else you may update the wrong record based on a partial string match.
cLookupField (optional)
Leave blank if you do not have a String value lookup field. (This is an extension property that I added to handle String lookups.)

For example, in an oJob class, you would set the cLookupField to the name of the column that has the string lookup key in it. For my Job table, the cLookupField property is set to ‘job_num’ which is a string column. Now it knows to look for the string value ‘123’ in the ‘job_num’ column. I also have Integer PK’s on that same table, so I also set the cPKField property to ‘ipkey’. Now my processing can also be done by the PK Integer value, if I know it. So I can now do lookups either by Strings or Integer PKs.

How it works:

The Get() method will determine what kind of lookup you are trying to do based on the data type of the value you pass in (integer or string) and will make the correct method call to other methods to do the actual lookup, all of which eventually drill down into the base wwBusiness class to do the lookup. Just pass in a string or an integer and it will happen like magic. You can then check the oJob.lFound property to determine if the requested record was found.

Here’s the code for the Get() method:

More about string lookups:

For string lookups, if you need more flexibility on the cLookupField, you can bypass the Get() method and use a lower-level lookup that accepts an alternate lookup column. It’s called LoadByRef() and accepts a string lookup value and a column name in which to perform the lookup. Like this:

oJob.LoadByRef(‘53443’, ‘po_num’) && Load a job by the po number.

And, to take it one step further, there is one more way you can further control the lookup, and that is by setting a property called cAdditionalFilter. Rather than accepting it as a parameter into the LoadByRef() method, it works as a property that you set before calling the method. This powerful feature allows, for example, find the first record with Status=”A” for Customer “DEN001”. You will just have to be creative and explore all the ways this method can be used. For DBF mode, the base wwBusiness method uses the LOCATE command, so the lookup is from the top down, so it will find the first record. For Sql Server mode, you can even include an Order By clause at the end of the cAddtionalFilter to all effectively working from the bottom up.

Example:

oJob.cAdditonalFilter = ‘Status = [A]’
oJob.LoadByRef(‘DEN001’, ‘cust_num’)

You can use any complex expression you want to in the cAdditionalFilter property:

oJob.cAdditonalFilter = ‘Status = [A] and Amount>1000’

Remember, in my methods, I am still eventually using the base wwBusiness methods to do the work, it’s just that I have built a wrapper around it to make it easier to use.

Here’s the method code for LoadByRef()

Exploring my wwBusiness extension library

2010-01-21T10:35:00.002-06:00

Updated 02/01/2010 1:26 pm

I’ve written an extension library on top of the West Wind wwBusiness classes for object oriented data access in Visual FoxPro. In this blog series I will explain some of the basics about the base West Wind wwBusiness class library and my extension library built on top of it, which I’ve named wwBusinessPro!

I’m offering my extension library freely to anyone who wants to give it try. Just let me know and I’ll send you my latest source code and Help file. No warranty at all, but I’ll be glad to help you get going with it. You’ll need to purchase your own license for the wwBusiness library, which you can find as part of the Web Connection or Client Tools package at the West Wind web site. (One day soon I’ll set it up as a download link on my main web site.)

I’ve prepared several articles explaining some basics of the wwBusiness library and how my wwBusinessPro! extensions include support for String lookups and Parent-Child data models for your applications.

It’s not hard to get started… I recommend this strategy:

1. Before you try to jump in, take time to read each article listed below.
2. When you are ready to start, follow the instructions in the post Setting up wwBusinessPro.vcx to work with wwBusiness.vcx
3. Now create a new class library for your Business Objects and add a Parent BO class based off of wwBusProParent, and a Child BO class based off of wwBusProItemList. Next, set all the required properties on each BO class to work with your parent and child tables (I’ll write about this soon to tell you which properties are involved and what they do).
Now you’re ready to go… With a Parent and a Child BO properly configured, you can actually drive the whole thing from the Command Window, which is a good way to play around with it and see it work. See this code sample for a typical code snippet that is used to work with BO’s. After a little testing you’ll be ready to create (or modify) your forms to use the Parent/Child BO pair. It’s not all that hard, you just need a simple get-started case to help you see it all come together.

Completed Articles and resources:

Intro and overview articles:
You can read my original review of the West Wind wwBusiness library here
Article 1 – String Lookup enhancements in wwBusinessPro!
Article 2 – Parent-Child enhancements in wwBusinessPro!

Specific Steps to use wwBusinessPro BO’s in your code and forms:

Step 1 - Setting up wwBusinessPro.vcx to work with wwBusiness.vcx

Step 2 – Creating and using your first Parent Business Object (wwBusProParent class)
(see also this Help entry from the base wwBusniess Help File)

Other Planned Articles

~~Step 1. Setting up wwBusiness to work with wwBusinessPro!~~     Done! See link above.
~~Step 2. Creating and using your first Parent Business Object~~ Done! See link above.
Step 3. Creating a Child collection Business Object (wwBusProItemList class)
           (see this Help for now from the base wwBusiness Help File)
Step 4. Joining a Parent BO to a Child BO collection (Wow!! This is the main part of my extension)
           (see this help for now from the base wwBusiness Help File)

Other wwBusiness resources:

Main wwBusiness Help File from West Wind (click Class Reference –> Class wwBusiness)
Article by Kevin Cully about wwBusiness (PDF)

If you have any questions or need specific help please comment below.

Detecting Session Timeout in Asp.Net

2010-01-11T22:37:00.002-06:00

I recently had the need in my Asp.Net Webforms application to determine if a Session Timeout had occurred while the user was logged in to the app. As you know, while working in a Line Of Business app, many users can be drawn away from the app for extended periods of time after logging in. Upon returning to the app and making their next postback (by clicking some link or button on the form), most applications will have a mechanism to check the timeout limit set in Web.config and force the user to login again if the timeout limit has been passed. This is a basic security mechanism that is broadly used in web apps, and I wanted this behavior in my application.

Well, it turns out there is no built-in event or flag in the .Net framework that indicates when a Session Timeout has occurred. As I began what I thought would be a routine Google search, I found various solutions offered up by many developers who I’m sure are much smarter than me. After filtering through all the variations and approaches I saw on the web, I have trimmed it down to a simple method that works well for me, so I wanted to offer it up here to help anyone else who may encounter this need. You can add this method to your base form or master page code behind.

This simple method will return true if a Session Timeout has occurred, or false if not. You can call this method and take the desired action if true is returned. In my case, I log the user out and redirect them to the login page, passing a querystring parameter that triggers my login page to notify the user what has happened.

Method CheckForSessionTimout():

public bool CheckForSessionTimeout()
{
if (Context.Session != null && Context.Session.IsNewSession)
{
string cookieHeader = Page.Request.Headers["Cookie"];
if ((null != cookieHeader) && (cookieHeader.IndexOf("ASP.NET_SessionId") >= 0))
return true;
else
return false;
}
else
return false;
}

Here is how I call the above method from the OnInit() method of my MasterPage:

if (CheckForSessionTimeout())
{
if (Page.Request.IsAuthenticated)
{
FormsAuthentication.SignOut();
}
NavigateToLoginPage(true);
}

And here is the code for my NavigateToLoginPage() method, where the parameter true means “alert the user that a timeout has occurred” :

public void NavigateToLoginPage(bool TimeOutHasOccurred)
{
Response.Redirect("~/Login.aspx?mode=timeout");
}

I the Login.aspx page, I look for the QueryString parameter of “mode” with a value of “timeout” and display this beautiful yellow <div> to tell the user what has happened.

Grid Column DataBinding feature for VFP Grids

2009-12-11T12:53:00.002-06:00

I want to share some code from my custom grid class that creates an easy way to programmatically bind columns in a grid to a cursor that is opened in the workspace. Basically, this method binds each column’s ControlSource property to the field in the cursor that you specify. It also handles calculated fields, Casting, and a few more things I’ll show in the code samples below.

You do have a custom grid class that you use in your apps, right? So, now just do two things to your grid class:

Create a new placeholder method on your grid class named SetColumnControlSources().
Create a new method named BindColumn() and add my code from the BindColumn() code sample below.

Now, in each instance of the grid that you use on a form or class or subclass, create the required columns on the grid and set the header captions to match what you intend to show in the grid from the cursor. Be sure to give each column a smart Name property for easy coding (see example below). You do not set the ControlSource of each column while designing the grid. That’s what my fancy BindColumn() method does for you, along with a few more things you’ll see in the code sample. You will make calls to the BindColumn() method from your SetColumnControlSources() method to do the real work. I’ll show you how…

In the SetColumnControlSources() method of each grid instance, you’ll write code like this (specific to each grid<—>cursor matching that you want to build):

Sample SetColumnControlSources() method code:

Local lcRecordSource

With this
.BindColumn(.colItem, 'item')
.BindColumn(.colPrint, 'print')
.BindColumn(.colPartNo, 'part_no')
.BindColumn(.colAltPartNo, 'altpartno')
.BindColumn(.colDwgNo, 'dwg_no')
.BindColumn(.colDesc, 'desc')
.BindColumn(.colQty, 'qty')
.BindColumn(.colPrice, 'price')
.BindColumn(.colTotal, 'qty * _RecordSource.price')
.BindColumn(.colLaborCost, 'laborcost')
.BindColumn(.colLaborHrs, 'laborhrs')
.BindColumn(.colMachRate, 'laborcost / _RecordSource.laborhrs', 'N(10,2)')
.BindColumn(.colMtlCost, 'mtlcost')
.BindColumn(.colMtlMarkup, 'mtlmarkup')
.BindColumn(.colPartCost, 'laborcost + _RecordSource.mtlcost + _RecordSource.mtlmarkup')
.BindColumn(.colTotalCost, 'qty * (_RecordSource.laborcost + _RecordSource.mtlcost + _RecordSource.mtlmarkup)')
EndWith
*-- Other fancy stuff you can do in addition to the above ---
lcRecordSource = this.RecordSource
If !Empty(this.RecordSource)
this.colItem.DynamicFontUnderline = 'iif(' + lcRecordSource + '.divider=.t., .t., .f.)'
this.colprice.DynamicCurrentControl = 'iif(' + lcRecordSource + '.no_quote, [lblNoQuote], [Text1])'
EndIf

Notice how we can build calculated columns that are not even in the cursor, and easily setup a Cast() to control decimals and some DynamicXXX formatting too. Plus, it gives me one nice code window to see all my column binding without having to use the Property Sheet to see what each column is bound to.

So the above is *your* code, and now here’s *my* custom BindColumn() method code that you need to add to your grid class to handle the code you’ll write like the above. This methods assigns the Column.ControlSource property, expanding any _RecordSource references, and also handles the optional Cast() function (see code for .colMachRate above to see how to specify a Cast() format in the third parameter of the BindColumn method).

BindColumn() method code:

Procedure BindColumn() (Add this method to your grid class)
Lparameters toColumn, tcBindExpression, tcCast
Local lcFieldExpression, lcBindExpression, lcRecordsource
If Vartype(toColumn) = 'O' and Upper(toColumn.baseclass) = 'COLUMN'
lcRecordsource = toColumn.parent.RecordSource
If !Empty(lcRecordsource) and !Empty(tcBindExpression)
lcFieldExpression = Alltrim(Strtran(Upper(tcBindExpression), '_RECORDSOURCE', lcRecordSource))
*-- Combine RecordSource.FieldExpressiopn
lcBindExpression = lcRecordSource + '.' + lcFieldExpression
*-- Wrap in Cast() statement if casting was passed in
If Vartype(tcCast) = 'C'
lcBindExpression = 'Cast(' + lcBindExpression + ' as ' + tcCast + ')'
EndIf
*-- Finally, set controlsource on column...
toColumn.ControlSource = lcBindExpression
EndIf
Else
Return
EndIf

Finally, to make it all work, you simply set the RecordSource property on the grid and then call SetColumnControlSources():

thisform.Grid1.RecordSource = ‘csrDataCursor’
thisform.Grid1.SetColumnControSources()

I found having this in place to be an effective way to handle times when I need to kill the cursor, rebuild it, and then re-bind to it.

Like this:

thisform.Grid1.RecordSource = ‘’

*—Now rebuild the cursor
thisform.Grid1.RecordSource = ‘csrDataCursor’
thisform.Grid1.SetColumnControSources()

So there you go. Several tricks could be used to pass in the cursor field that you want to bind to. I’ve also thought about including a provision for passing in the Header caption too.

Enjoy, revise, and post comments to share any other ideas you have for extending this.

Model, View Model, View – No way (for now)…

2009-11-24T23:03:00.002-06:00

I get all the Model <---> ViewModel <---> View stuff. It's great theory, but come on! A View Model class that has the same exact properties as the stinkin' Model that it is wrapping, just so we can say “I used MVVM”.

My little Asp.Net CRUD app is binding the UI controls directly the data properties on a BusinessObject.Entity, where the Entity is a Typed class from a LinqToSql query. (My BO’s are based on the West Wind wwLinqToSql Business Object Wrapper from the West Wind Web Tools for Asp.Net ). And guess, what… It works! It loads and saves data when the user clicks the buttons. Imagine that. I'll be darned if I'm gonna wrap a ViewModel class around that data Entity so I can bind my UI controls to that ViewModel, rather than hooking straight to the Entity properties. Just too much stinkin' code required.

I've also added a few additionally needed "presentation properties" into my Business Objects to *supplement* the Entity properties that came from the data base row. And, yes, when working with my BO’s, you have to access some properties right off the BO (the custom presentation properties I added) and some come from the main BO.Entity (the real data from the database row). So, you do have to know where to get the data you are after. By doing this, most of my UI binding is against the BusinessObject.Entity properties, and a few UI bindings go against the supplemental presentation properties I’ve added right on the BO.

So, I don't mind some bit of a hybrid ViewModel approach, but not a separate class where I have to re-host every single property that is on the Entity. And, since this is done on the Business Object class level, all these supplemental "presentation properties" can still be accessed by other UI apps that work with the same Business Object wrapper classes.

From a theoretical standpoint, sure, it breaks a few rules. But from a real world impact, we are talking about only a handful of supplemental properties. In all the BOs I've built (Customer, Invoice, Quote, Shipper, User, Employee, etc.), maybe I've added 3 to 5 additional properties on each one to serve what is usually one view, but sometimes two or three different views at the most. If things really get crazy, there might be as many as 10 presentation properties to handle all the views. It still seems like less of an overall burden on the application as a whole to add a few presentation properties right on the BO, rather than dropping an entire Model-to-ViewModel Mapper implementation on my app (homegrown or commercial). Talk about a burden.

Now look, these additional properties will be implemented somewhere. Why not stick them onto something that already exists (the BO) as little light-weight tag-a-longs, rather than create an entirely free-standing ViewModel object, where I put these innocent properties and then I have to REPLICATE all the real properties from the Model too. Is that how this magic ViewModel character makes things "cleaner"? Yuck! Oh, wait, I almost forgot... but look how clean my BO is! No thanks.

Here’s a use case from my app… I want to bind a UI control to the Customer Name for an Invoice Object that I have pulled from the database. Well, rather than attempting to bind through the main Invoice Entity and into the Customer sub-Entity (which LinqToSql handles nicely for me BTW) I've added a presentation property on the BusinessObject to access the Customer Name easily, and also guard against several null object cases that can arise.

Example: Attempting to bind a UI control to directly to this property (see below) could crash the UI generation if the Entity object or Customer Entity is null:

busInvoice.Entity.CustomerEntity.Name

Since it's possible that the busInvoice object’s .Entity property is not even saturated yet, or that the CustomerEntity is null, this could cause problems generating the UI. And, I certainly don’t want to test for all the potential problems in my UI pages every time I want to display that property. So, I added a property on the busInvoice object to host that value and deal will all the required testing.

Something like:

public string CustomerName
{
get
   {
     if (this.Entity != null && this.Entity.CustomerEntity != null)
       return this.Entity.CustomerEntity.Name;
     else
       return "";
   }
}

Anyway, back to my main rant about going overboard with ViewModels…

So look at this sample I found from a notable Asp.Net guru. It is a ProductView class that returns a ProductView object from a passed in Product (that you got from your DAL somewhere), and it can return a Product object from a passed in ProductView object, basically by unwrapping the ProductView object and casting the string properties back to the original data types. Look at all this code! Especially look at the ToProduct() method. Wow! ( code from http://weblogs.asp.net/craigshoemaker/archive/2009/11/03/vm-workshop-model-view-viewmodel-mvvm-and-the-presentation-model-pattern-in-5-ui-platforms.aspx )

It looks like a maintenance nightmare. I need more convincing that this is the way the pros do it. Perhaps I’ll be a rookie just a little bit longer.

    public class ProductEditView : IUrlSerializer
    {
        public string ProductId { get; set; }
        public string Title { get; set; }
        public string Description { get; set; }
        public string QuantityOnHand { get; set; }
        public string Price { get; set; }
        public string ReleaseDate { get; set; }

        public string SerializeToUrlString()
        {
            StringBuilder sb = new StringBuilder();
            sb.AppendFormat("productId={0}&", this.ProductId);
            sb.AppendFormat("title={0}&", this.Title);
            sb.AppendFormat("description={0}&", this.Description);
            sb.AppendFormat("quantityonhand={0}&", this.QuantityOnHand);
            sb.AppendFormat("price={0}&", this.Price);
            sb.AppendFormat("releasedate={0}", this.ReleaseDate);
            return sb.ToString();
        }

        public static ProductEditView ToProductEditView(Product product)
        {
            ProductEditView view = new ProductEditView();
            view.ProductId = product.ProductId.ToString();
            view.Title = product.Title;
            view.Description = product.Description;
            view.Price = string.Format("{0:c}",product.Price);
            view.QuantityOnHand = product.QuantityOnHand.ToString();
            view.ReleaseDate = product.ReleaseDate.ToShortDateString();
            return view;
        }
        public static Product ToProduct(ProductEditView view)
        {
            double db;
            int num;
            DateTime dt;

            Product product = new Product();
            product.Title = view.Title;
            product.Description = view.Description;

            if (double.TryParse(view.Price.TrimStart('$'), out db))
            {
                product.Price = db;
            }
            else
            {
                throw new ArgumentException("Price is malformed or not a valid value.");
            }

            if (int.TryParse(view.ProductId, out num))
            {
                product.ProductId = num;
            }
            else
            {
                throw new ArgumentException("ProductId is malformed or not a valid value.");
            }

            if (int.TryParse(view.QuantityOnHand, out num))
            {
                product.QuantityOnHand = num;
            }
            else
            {
                throw new ArgumentException("QuantityOnHand is malformed or not a valid value.");
            }

product.ProductId = Convert.ToInt32(view.ProductId);
product.QuantityOnHand = Convert.ToInt32(view.QuantityOnHand);

            product.ReleaseDate = Convert.ToDateTime(view.ReleaseDate);
            if (DateTime.TryParse(view.ReleaseDate, out dt))
            {
                product.ReleaseDate = dt;
            }
            else
            {
                throw new ArgumentException("ReleaseDate is malformed or not a valid value.");
            }

return product;
}

Adobe Acrobat PDF Printer output filename on 64-bit OS…

2009-11-13T22:23:00.001-06:00

Now that I’ve moved over to Windows 7 64-bit on my primary workstation, I’m in a new world of IT support that I didn’t expect from those extra 32 bits of OS horsepower. My MicroTek scanner is not supported, my HP 2800 Business Inkjet is not supported, and I recently discovered that a technique I use in my Visual FoxPro business application to pre-define the PDF output filename when using the Adobe Acrobat PDF printer driver mysteriously does not work on Windows 64-bit. So, I want to show the remedy in case others encounter this same problem. I’m explaining this from the perspective of a Visual FoxPro application, but the issue applies to all Windows applications, and the remedy can come from many programming languages.

Background… It’s well know that you can prevent the Adobe PDF printer driver from prompting the user to choose a path and filename for the output file by programmatically setting a certain registry key with a string value that contains the desired path and filename of PDF file you want to output. I use this technique to automatically set the path and filename for my users for the various PDF reports we generate to send out to our customers and vendors.

This magic registry key is located at: HKEY_CURRENT_USER\Software\Adobe\Adobe Distiller\PrinterJobControl. So, you create a string value under that key with the path and name of the *application* that is printing the PDf, and then you set the value of that string value to the path and filename of the PDF you want to create.

Now, the path and filename of the application that is doing the printing is not always easy to figure out, so I can’t solve that mystery here for any given app that you may be using, but I do know (and I forget where I learned this) that for a Visual FoxPro application (.exe), the path and application name can be discovered from the VFP variable “_VFP.ServerName”. Of course, it’s up to you to decide the path and filename of the PDF output file you’re want to create.

So, to bring it all together, you add a string value named after the app that is doing the printing (for instance) “C:\Program Files\Microsoft Visual FoxPro 9\vfp9.exe” and you set the value of that string value to the filename you want the PDF to be called; i.e. “C:\TEMP\JMC_PO_MS2741C.pdf”

Well, that’s how it works on good ‘ole 32-bit OS. Now, enter into the 64-bit world…

The issue is that the *application* name that the 64-bit OS sees as doing the printing is no longer the actual exe the user is running, but rather some odd Windows exe named “splwow64.exe” (some spooler-like thingy that actually handles the printing which I learned about here http://www.acrobatusers.com/forums/aucbb/viewtopic.php?pid=57794#p57794 ). So that’s the application name you have to use, and you do have to include the path. Since this spooler thingy exe runs from C:\Windows, the actual registry key that must therefore be created is “C:\Windows\splwow64.exe”.

So, with the PrinterJobControl registry key all programmatically setup as described above, when you actually fire off the Adobe PDF printer, the output name is already set and the user will not see the prompt dialog to choose the output path and filename.

Also, be aware that after *you* programmatically create and set the registry value, the Adobe PDF driver will actually delete that string value from the key right after the file is printed. Perhaps this is so the next app that prints won’t use the same name.

Finally, here’s the VFP code I use to set the values for both 32-bit and 64-bit OS’s. (This code uses an instance of the Registry class from the FoxPro FFC classes to work on the Windows registry). Again, this all works the same way whether you are using .Net, VFP, VB, or whatever. The main thing is to setup the registry value the right way.

oRegTools=createobject('registry')

m.lcKeyPath = "Software\Adobe\Acrobat Distiller\PrinterJobControl"

       *-- This RegKey setting works on 32-bit OS...
        oRegTools.OpenKey(@lcKeyPath, HKEY_CURRENT_USER , .T.)
        lcPrintingApplicationName = _VFP.ServerName
        oRegTools.SetKeyValue(lcPrintingApplicationName, “C:\TEMP\JMC_PO_MS2741C.pdf”)
        oRegTools.CloseKey()

        *-- This is the "Application" name that the OS sees as doing the printing when running on a 64-bit OS...
        oRegTools.OpenKey(@lcKeyPath, HKEY_CURRENT_USER , .T.)
        lcSplWow64ProcessName = 'C:\Windows\splwow64.exe' && <--- This is what the OS sees as what’s doing the printing...
        oRegTools.SetKeyValue(lcSplWow64ProcessName, “C:\TEMP\JMC_PO_MS2741C.pdf”)
        oRegTools.CloseKey()

Hopefully, this insight will save someone out there a little headache when working with the Adobe PDF printer driver on these super-duper 64-bit OS’es.

LINQ to SQL, Lazy Loading and Prefetching

2009-10-22T22:36:00.001-05:00

I want to recommend this interesting article that explains times when LinqToSql’s native behavior of “Lazy Loading” is not a good thing (from a database performance standpoint), and explains a pre-fetching technique that you can can use when you want to avoid lazy loading hits to SQL Server.

It's from the the great Rick Strahl. See his blog post at:

http://west-wind.com/Weblog/posts/38838.aspx

I also recommend that you review his LinqToSql Business Object wrapper framework and sample app that he created to show a real-world working app using the framework.

Original article and download, September 27, 2007 (read this first):

http://www.west-wind.com/WebLog/posts/160237.aspx

He also posted an update article on February 05, 2008:

http://www.west-wind.com/Weblog/posts/246690.aspx

And, Rick has continued to update the LinqToSql Business Object wrapper framework since those articles were written, and you can download the latest version which is included as part of the WestWind Web Toolkit for Asp.Net (tons of other goodies are in the entire Toolkit, so check out the free license details, which is a full working version) :

http://www.west-wind.com/westwindwebtoolkit/

In closing… You know, they've said that LinqToSql was kind of dead, but at least they did do a little work on it for .Net 4 framework. That’s encouraging to me. I think a LOT of people use LinqToSql, and I personally think it will pick up even more, rather than die off. It has a fine place in small-to-mid sized apps, and I frequently hear plenty of notables in the community speak of it.

Here's is an article on the updates to LinqToSql that included in the .Net 4 framework:

http://damieng.com/blog/2009/06/01/linq-to-sql-changes-in-net-4

Uninstalling Visual Studio 2010 Beta 2

2009-10-20T10:51:00.001-05:00

Why am I writing about Un-installing Visual Studio Beta 2 when it was just released yesterday, October 19, 2009? (video announcement can be seen at this link). Well, in the past whenever I’ve used the beta versions of some of Microsoft’s developer tools, I’ve found that it was impossible to uninstall them properly (or fully) when the RTM version was finally released.

Now, I know that VM’s can be used to test out beta software, and I do use VM’s on my machine, as I did when I installed VS2010 Beta 1 on a Windows 7 Beta VM running on VirualBox VM. But sometimes I still like running right on the bare metal so I will have access to the rest of the tools I need in a full dev environment. Especially now that it’s Beta 2, I’d feel pretty good running it on my live dev machine. But, I was unsure about being able to easily remove it later when the RTM version comes out on March 22, 2010.

So, I posted a question on the Visual Studio 2010 Install and Setup forum of the newly restyled http://www.msdn.com/forums to see if anyone could address this issue.

My question is titled Will we be able to un-install VS2010 Beta 2, when final version is released?.

Fortunately, I got a very quick reply from a MSFT moderator named Aaronru who claims a very easy and successful uninstall of VS2010 Beta 2 has been tested and WILL allow for an easy upgrade path to VS2010 RTM.

The exact reply was…

For helpful instructions on how to install Visual Studio, we've published some detailed instructions for installing and maintaining Visual Studio 2010 Beta 2.

If you evaluated Visual Studio 2010 Beta 1, you will be happy to hear that no reformatting is required. Additionally, simple path exists to appraise Beta 2 on the same machine. It involves uninstalling your Visual Studio 2010 Beta1 product and then installing one of the Visual Studio 2010 Beta2 offerings. Please refer to the following blog post for more details.

As part of our Beta 2 testing, we did test the uninstall of Beta 2 to ensure that the Beta 2 could be uninstalled sufficiently to the end that you could uninstall Beta 2 and install RTM with as seamless UX as possible.

You can read the entire thread here.

So go for it! The download of VS2010 Beta 2 will be available to the public on October 21, 2009, with final RTM to be released on March 22, 2010.

To Blog or to Forum Post, that’s the question…

2009-09-14T10:38:00.001-05:00

I'm not really sure why I'm so driven to do this, but I've always been a spread-the-news kind of guy for the VFP community. Any time I see something cool, or that I think others may be interest in, I make a post here-and-there to all the most popular FoxPro sites to spread the word. So, about a month ago I cranked up this blog for the purpose of doing just that, thinking this would be a good way to go. Now, I don't want to compete with the existing forums, because it's easy enough to go there and make announcements, but I have to visit UniversalThread, and Foxite, and the ProFox and VFUG lists too, oh, and even Fox.Wikis.com, oh, and sometimes use my FoxCentral.net account. I usually have to hit all those sites with a bunch of cut-and-paste to work all the places I want to reach. Plus, after posting to forums and lists, if I need to tweak the info (corrections, add details, etc), it’s too late to edit or just too much work. And, any conversations (comments) about the topic are now spread out across all the different places and there’s no one place other readers can visit to take it all in. Plus, the formatting and image posting in a blog is much better.

So, I'm trying to decide whether it really adds any value to put this info in a blog post and try to get an audience following the blog, or just keep it old school and post in multiple places.

Your opinions please.

Crash Course to Web Development for FoxPro and Web Connection Developers

2009-09-14T10:37:00.001-05:00

I just received an e-mail announcement for what looks like an awesome jump start class for Visual FoxPro developers to get their feet wet in the .Net Web development arena. Super-smart web maven Rick Strahl plans to give you 3 days of quick start how-to teaching on the .Net / Web development train.

You can attend live or watch on GoToMeeting. It’s a 3-day class, November 5, 2009 through November 7, 2009.

Here is a link with all the details: http://eps-software.com/EventDetail.aspx?id=37d20fbb-6632-4264-8db5-b1665904b00a

(P.S. – Does anyone want to sponsor me?)

The color of your comments

2009-08-18T10:35:00.001-05:00

Recently I had a thought that the comments in my code may be getting in the way of me actually seeing the code itself while I'm coding. There seems to be two camps in the code commenting world: (1) Write good code and you should not need comments and (2) Write comments or else you are being lazy and no one will ever be able to work with your code. Well, I'm not here to settle that debate (I fall somewhere in the middle).

So, I had this idea of changing the COLOR of my comments from GREEN to GREY, so that I could still see them, but they would kind of fade away into the background, but would still be there if I took a harder look. I suppose the default VFP comment color must be that classic green color that I've been looking at for years, so I've changed mine to grey to help me focus better on my code, and not the comments.

Who knows, maybe one day I'll be a real programmer and won't even need to write comments at all.

Also, the smart one, Bo Durban, posted this hint on UT (in response to this blog post) about how you are not limited to the base 16 colors:

Did you know...If you set it programmatically, you are not limited to the base 16 colors?:

oReg = NEWOBJECT("FoxReg",HOME(2)+"classes\registry.prg")
oReg.SetFoxOption("EditorCommentColor","RGB(80,140,80,250,250,170),NoAuto,NoAuto")
SYS(3056,1)

So, here are a few screenshots to compare... Give it a try and see what you think.

Grey Comments:	Green Comments:

Ruby on Birmingham

2009-08-12T16:19:00.003-05:00

In case you're interested, here is a link to the RubyHam users group in Birmingham, Alabama. They have monthly meetings, usually meeting on the first non-holiday Monday of the month. The meetings are around lunch time, rather than at night. I've never been to one the meetings, and I've never used Ruby, but I did see a presentation about it once and it seemed cool enough to make me want to learn more about it. I plan to go to the next meeting on September 14, 2009 just to see what it's all about. Will I see you there?

http://tech.groups.yahoo.com/group/rubyham/

Ruby is a (non-Microsoft) language that seems to have reasonable popularity among the kids. Microsoft is working on a version for .NET called IronRuby: http://www.ironruby.net Since I am indeed a Microsoft fanboy, that will probably win my first dance.

Get involved. Enjoy. The choices are endless.

West Wind Client Tools for VFP

2009-08-12T09:42:00.003-05:00

<<Back to Index

(Update.. Sample app has been completed as of 2010-09-03. Available to all who request it by contacting me.)

I recently got interested in converting my company's main Visual Foxpro CRUD application to a Business Object model, rather than old-school free .dbf tables with a bunch of procedural code stuck in all the button clicks and textbox valid() events. I'm sure none of you have ever done such hack-work, but back in the beginning (I started with FPD in 1992, then FPW, then VFP as each was released) that's how I started. I was a solo developer and had no formal training or access to mentors. It took me a long time to get the vision of how real programming should be done, but I finally learned some of these core fundamentals a few years back, and I'm really enjoying the process of refactoring my app into this BO pattern. I began by reading about the topic in all the usual places, and posted a few questions here and there on several VFP sites (like http://www.foxite.com/ and http://www.universalthread.com/), then I finally hacked out my own basic BO class, after I learned about the SCATTER approach that is widely used to capture data from a table row into an object.

Then, at a pair programming session with a Foxpro developer friend of mine, he showed me Rick Strahl's West Wind Web Connection for VFP that he's used for years. Turns out that package has a nice BO class library, called wwBusiness, which is also available as part of a client app tool set from West Wind (called the West Wind Client Tools for VFP http://www.west-wind.com/wwClientTools.asp ). So the Web Connection package and the Client Tools package both have the same wwBusiness BO class library.

Now, the West Wind Client Tools package also has a TON of stuff besides just the BO classes (like SMTP, HTTP, FTP, SQL, XML, JSON, SOAP, blah, blah). You can read all about them at the Client Tools page link I listed above.

One cool thing about the wwBusiness BO class is that it has one single property (nDataMode) to switch between VFP dbf tables and SQL Server, so it's very helpful if you want to migrate your application's data to a SQL Server backend and flip the switch once you are ready to move away from dbf tables. And the cool thing is that your app will never know where the data comes from, it just uses the wwBusiness BO to request data, and it comes back as an object that you can work with, then you call the .Save() method on the BO object to write the changes back to the DBF or Sql Server. I tested it, and it actually does work very well.

The wwBusiness.vcx class library has two class types:

wwBusiness - a single BO class (for fetching a parent record or a single line item)
wwItemList - a class which will fetch and hold a set of records (like line items on a Sales Order)

Together, these classes can model just about any Parent-Child data set you might have in your app. I found these classes to be good starting points, but I did write my own wrappers around them and extended their functionality greatly. I think anyone using the wwBusiness classes in a classic CRUD app will need to do the same thing. If you would like to see what I’ve done, feel free to contact me and I’d be glad to share my extensions to the standard wwBusiness class lib, which I have called wwBusinessPro! I have packaged my extensions nicely in a separate VCX class that should be usable in other VFP apps as well.

Here are the primary two ways I extended the classes:

The wwBusiness (single BO class) expects an integer PK to do lookups and fetches. I indeed have Integer PKs on my tables, but I sometimes also have a unique lookup string for each parent record, and I wanted the option of using that for fetching a Parent record (and related child records too). So, I created a Get() method which will accept either an Integer or a String. It then calls the native wwBusiness.Load(tnPk) for Integer PK lookups or it will call my extension method LoadByRef(tcLookupString) for string based lookups. The wwBusiness class already had cPKfield out of the box, and I added a cLookupField property to handle string-based lookups. I also enhanced the Save() method to apply the Parent Key to all the Child collection records so that the relational structure required for Parent-Child PK/FK would be automatically handled for me.
Out of the box, the wwItemList class requires YOU to write a method to fetch the desired child records into a cursor, then it loads that data from your cursor into an array when you call the wwItemList.LoadFromCursor() method. Well, that array would work fine for procedural processing, but for my application I needed to host the child records in a grid, so I needed to service the child records from that local cursor (rather than working on the array items). I wrapped the wwItemList Save() method to get the local records back into the real table from which they came. For my app design, this cursor-based functionality was the biggest missing part from the basic toolkit. I had to write about 3 or 4 methods to handle this workflow in an abstract way so I could have a generic solution for all my child item collections. The main methods I wrote were LoadLineItems() and a wrapper around SaveToCursor() which was needed to handle records that had been deleted from the local working cursor.

You can see a code sample of working with my extended wwBusiness classes here: http://codepaste.net/aascee
Here is a screenshot of the object model that I created with my extended wwBusiniess and wwItemList to create a Job object with several associated child collections: Line Items, Material Items, and Labor Items that are all from child tables related to the Parent record via PK/FK relationship.

Lastly, note that using a BO tool in general not only brings you data handling in an object-based manner with support for various back end data stores, but that same Business Object now becomes *THE* place to put business logic for each of your business objects. Like adding a method for CloseSalesOrder() or AssignJobPriority() or SetDefaultPropertiesForNewJob(), or PrintShippingTicket() etc. With all this properly in place on your Business Objects, creating a UI form becomes a much simpler task of just calling methods on the Business Object. Using this technique, I was able to reduce the code in my CRUD forms by more than 50%!! And now, I have a bunch of cute BOs I can instantiate in code or even right in the command window to work on them without even having a UI screen. Not only that, the same BO can easily support a web-based UI to your same exact data and business logic. It is truly beautiful!

So, as you can see, I did a lot of work on the West Wind classes to prepare them for my app, but two things: 1. It was VERY fun to work all this out, and 2. It works like a charm, and I now have a completely BO-based CRUD app where all the Business logic is nicely tucked away in the BOs and not in my forms or form controls.

Also, FoxPro veteran Kevin Cully is a long-time West Wind user, and he made a presentation on the wwBusiness classes to the Atlanta FoxPro User Group (AFUG) several years ago and prepared a nice 20-page introductory paper here: http://cullytechnologies.com/presentations/wwbusiness/cully_technologies_wwbusiness_presentation.pdf

Man, I wish I had this thing 10+ years ago when as I first began the VFP version of my app. Since I didn’t have a clue what I was doing at the time I started, it wound up a little bit messy, until this came along. I began my own BO efforts around May 2009, and the I abandoned my version in favor of wwBusiness around August 2009.

So go check it out for yourself... You can read the help file online and the package is only $199, and has 10% during August 2009, so about $179 gets you on his customer list and into the surf over at West Wind. You can download a working version with the full source code right from the site. The site also has a reasonably active discussion forum, and Rick is generally very responsive himself.