For anyone on active subscription, I believe there is no additional cost for Premium (except for the SQL licenses purchased separately), making SQL mirroring unnecessary.  (It used to be that Premium licenses were more expensive, so mirroring was a way to save on software cost).

The  problem with Premium is all data access is via an ODBC emulation of ProvideX file I/O. What you gain in reporting speed being SQL native you lose in overall performance. Reading NOMADS screens via SQL is painfully slow. Updating isn't  much faster. Maybe things have improved since I last tried it.

The SQL mirroring package I'm offering is a non-invasive solution to making your data more accessible to the outside world and dramatically improving performance for BI add-ons. It doesn't require a version of ProvideX not distributed by Sage like the DSD solution. Written in ScriptBasic, multi-threaded and lightening fast.

Kevin,

My direction with Sage 100 is providing open source software as a means to make Sage 100 more open and affordable. The SQL mirroring package I'm offering is based on those goals. Written in ScriptBasic and using Postgres SQL as the DB engine,

I would agree with you and DSD that migrating from their custom ProvideX MS SQL Server based mirroring offering to 100 Premium would be the best direction.

For those running customized installations and don't want to touch anything or those only wishing to mirror critical tables for faster and more flexible reporting, Postgres SQL mirroring would be a good choice. 

I have updated the ScriptBasic ODBC extension module with a FetchSchema function. This was added so I can dynamically CREATE SQL tables on the server based on the SELECT used.

IMPORT odbc.sbi

dbh = odbc::RealConnect("SAGE100","","")
SQL = "SELECT * FROM AR_Customer"
odbc::Query(dbh, SQL)     
odbc::FetchSchema(dbh, col) 
odbc::Close(dbh)

FOR x = 0 TO UBOUND(col) STEP 5
  PRINT FORMAT("Column Name: %s, Type: %i, Size: %i, Digits: %i, Nullable: %i\n", col[x], col[x + 1], col[x + 2], col[x + 3], col[x + 4])
NEXT

Output:

Column Name: ARDivisionNo, Type: 12, Size: 2, Digits: 0, Nullable: 1
Column Name: CustomerNo, Type: 12, Size: 20, Digits: 0, Nullable: 1
Column Name: CustomerName, Type: 12, Size: 50, Digits: 0, Nullable: 1
Column Name: AddressLine1, Type: 12, Size: 40, Digits: 0, Nullable: 1
Column Name: AddressLine2, Type: 12, Size: 40, Digits: 0, Nullable: 1
Column Name: AddressLine3, Type: 12, Size: 40, Digits: 0, Nullable: 1
Column Name: City, Type: 12, Size: 30, Digits: 0, Nullable: 1
Column Name: State, Type: 12, Size: 2, Digits: 0, Nullable: 1
Column Name: ZipCode, Type: 12, Size: 10, Digits: 0, Nullable: 1
Column Name: CountryCode, Type: 12, Size: 3, Digits: 0, Nullable: 1
Column Name: TelephoneNo, Type: 12, Size: 20, Digits: 0, Nullable: 1
Column Name: TelephoneExt, Type: 12, Size: 6, Digits: 0, Nullable: 1
Column Name: TelephoneType, Type: 12, Size: 1, Digits: 0, Nullable: 1
Column Name: FaxNo, Type: 12, Size: 20, Digits: 0, Nullable: 1
Column Name: EmailAddress, Type: 12, Size: 250, Digits: 0, Nullable: 1
Column Name: URLAddress, Type: 12, Size: 50, Digits: 0, Nullable: 1
Column Name: EBMEnabled, Type: 12, Size: 1, Digits: 0, Nullable: 1
Column Name: EBMConsumerUserID, Type: 12, Size: 15, Digits: 0, Nullable: 1
Column Name: BatchFax, Type: 12, Size: 1, Digits: 0, Nullable: 1
Column Name: DefaultCreditCardPmtType, Type: 12, Size: 5, Digits: 0, Nullable: 1
Column Name: ContactCode, Type: 12, Size: 10, Digits: 0, Nullable: 1
Column Name: ShipMethod, Type: 12, Size: 15, Digits: 0, Nullable: 1
Column Name: TaxSchedule, Type: 12, Size: 9, Digits: 0, Nullable: 1
Column Name: TaxExemptNo, Type: 12, Size: 15, Digits: 0, Nullable: 1
Column Name: TermsCode, Type: 12, Size: 2, Digits: 0, Nullable: 1
Column Name: SalespersonDivisionNo, Type: 12, Size: 2, Digits: 0, Nullable: 1
Column Name: SalespersonNo, Type: 12, Size: 4, Digits: 0, Nullable: 1
Column Name: SalespersonDivisionNo2, Type: 12, Size: 2, Digits: 0, Nullable: 1
Column Name: SalespersonNo2, Type: 12, Size: 4, Digits: 0, Nullable: 1
Column Name: SalespersonDivisionNo3, Type: 12, Size: 2, Digits: 0, Nullable: 1
Column Name: SalespersonNo3, Type: 12, Size: 4, Digits: 0, Nullable: 1
Column Name: SalespersonDivisionNo4, Type: 12, Size: 2, Digits: 0, Nullable: 1
Column Name: SalespersonNo4, Type: 12, Size: 4, Digits: 0, Nullable: 1
Column Name: SalespersonDivisionNo5, Type: 12, Size: 2, Digits: 0, Nullable: 1
Column Name: SalespersonNo5, Type: 12, Size: 4, Digits: 0, Nullable: 1
Column Name: Comment, Type: 12, Size: 30, Digits: 0, Nullable: 1
Column Name: SortField, Type: 12, Size: 10, Digits: 0, Nullable: 1
Column Name: TemporaryCustomer, Type: 12, Size: 1, Digits: 0, Nullable: 1
Column Name: CustomerStatus, Type: 12, Size: 1, Digits: 0, Nullable: 1
Column Name: InactiveReasonCode, Type: 12, Size: 5, Digits: 0, Nullable: 1
Column Name: OpenItemCustomer, Type: 12, Size: 1, Digits: 0, Nullable: 1
Column Name: ResidentialAddress, Type: 12, Size: 1, Digits: 0, Nullable: 1
Column Name: StatementCycle, Type: 12, Size: 1, Digits: 0, Nullable: 1
Column Name: PrintDunningMessage, Type: 12, Size: 1, Digits: 0, Nullable: 1
Column Name: UseSageCloudForInvPrinting, Type: 12, Size: 1, Digits: 0, Nullable: 1
Column Name: CustomerType, Type: 12, Size: 4, Digits: 0, Nullable: 1
Column Name: PriceLevel, Type: 12, Size: 1, Digits: 0, Nullable: 1
Column Name: DateLastActivity, Type: 91, Size: 10, Digits: 0, Nullable: 1
Column Name: DateLastPayment, Type: 91, Size: 10, Digits: 0, Nullable: 1
Column Name: DateLastStatement, Type: 91, Size: 10, Digits: 0, Nullable: 1
Column Name: DateLastFinanceChrg, Type: 91, Size: 10, Digits: 0, Nullable: 1
Column Name: DateLastAging, Type: 91, Size: 10, Digits: 0, Nullable: 1
Column Name: DefaultItemCode, Type: 12, Size: 30, Digits: 0, Nullable: 1
Column Name: DefaultCostCode, Type: 12, Size: 9, Digits: 0, Nullable: 1
Column Name: DefaultCostType, Type: 12, Size: 1, Digits: 0, Nullable: 1
Column Name: CreditHold, Type: 12, Size: 1, Digits: 0, Nullable: 1
Column Name: PrimaryShipToCode, Type: 12, Size: 4, Digits: 0, Nullable: 1
Column Name: DateEstablished, Type: 91, Size: 10, Digits: 0, Nullable: 1
Column Name: CreditCardGUID, Type: 12, Size: 32, Digits: 0, Nullable: 1
Column Name: DefaultPaymentType, Type: 12, Size: 5, Digits: 0, Nullable: 1
Column Name: EInvoicePayments, Type: 12, Size: 1, Digits: 0, Nullable: 1
Column Name: EInvoiceContactId, Type: 12, Size: 24, Digits: 0, Nullable: 1
Column Name: EmailStatements, Type: 12, Size: 1, Digits: 0, Nullable: 1
Column Name: PIIEncryptedDate, Type: 91, Size: 10, Digits: 0, Nullable: 1
Column Name: NumberOfInvToUseInCalc, Type: 3, Size: 2, Digits: 0, Nullable: 1
Column Name: AvgDaysPaymentInvoice, Type: 3, Size: 3, Digits: 0, Nullable: 1
Column Name: AvgDaysOverDue, Type: 3, Size: 3, Digits: 0, Nullable: 1
Column Name: CustomerDiscountRate, Type: 3, Size: 12, Digits: 3, Nullable: 1
Column Name: ServiceChargeRate, Type: 3, Size: 12, Digits: 3, Nullable: 1
Column Name: CreditLimit, Type: 3, Size: 13, Digits: 2, Nullable: 1
Column Name: LastPaymentAmt, Type: 3, Size: 13, Digits: 2, Nullable: 1
Column Name: HighestStmntBalance, Type: 3, Size: 13, Digits: 2, Nullable: 1
Column Name: UnpaidServiceChrg, Type: 3, Size: 13, Digits: 2, Nullable: 1
Column Name: BalanceForward, Type: 3, Size: 13, Digits: 2, Nullable: 1
Column Name: CurrentBalance, Type: 3, Size: 13, Digits: 2, Nullable: 1
Column Name: AgingCategory1, Type: 3, Size: 13, Digits: 2, Nullable: 1
Column Name: AgingCategory2, Type: 3, Size: 13, Digits: 2, Nullable: 1
Column Name: AgingCategory3, Type: 3, Size: 13, Digits: 2, Nullable: 1
Column Name: AgingCategory4, Type: 3, Size: 13, Digits: 2, Nullable: 1
Column Name: OpenOrderAmt, Type: 3, Size: 13, Digits: 2, Nullable: 1
Column Name: RetentionCurrent, Type: 3, Size: 13, Digits: 2, Nullable: 1
Column Name: RetentionAging1, Type: 3, Size: 13, Digits: 2, Nullable: 1
Column Name: RetentionAging2, Type: 3, Size: 13, Digits: 2, Nullable: 1
Column Name: RetentionAging3, Type: 3, Size: 13, Digits: 2, Nullable: 1
Column Name: RetentionAging4, Type: 3, Size: 13, Digits: 2, Nullable: 1
Column Name: SplitCommRate2, Type: 3, Size: 8, Digits: 3, Nullable: 1
Column Name: SplitCommRate3, Type: 3, Size: 8, Digits: 3, Nullable: 1
Column Name: SplitCommRate4, Type: 3, Size: 8, Digits: 3, Nullable: 1
Column Name: SplitCommRate5, Type: 3, Size: 8, Digits: 3, Nullable: 1
Column Name: EncryptedVals, Type: -1, Size: 1152, Digits: 0, Nullable: 1
Column Name: DateCreated, Type: 91, Size: 10, Digits: 0, Nullable: 1
Column Name: TimeCreated, Type: 12, Size: 8, Digits: 0, Nullable: 1
Column Name: UserCreatedKey, Type: 12, Size: 10, Digits: 0, Nullable: 1
Column Name: DateUpdated, Type: 91, Size: 10, Digits: 0, Nullable: 1
Column Name: TimeUpdated, Type: 12, Size: 8, Digits: 0, Nullable: 1
Column Name: UserUpdatedKey, Type: 12, Size: 10, Digits: 0, Nullable: 1

• #define         SQL_UNKNOWN_TYPE 0
• #define         SQL_CHAR 1
• #define         SQL_NUMERIC 2
• #define         SQL_DECIMAL 3
• #define         SQL_INTEGER 4
• #define         SQL_SMALLINT 5
• #define         SQL_FLOAT 6
• #define         SQL_REAL 7
• #define         SQL_DOUBLE 8
• #define         SQL_DATETIME 9
• #define         SQL_VARCHAR 12
• #define         SQL_TYPE_DATE 91
• #define         SQL_TYPE_TIME 92
• #define         SQL_TYPE_TIMESTAMP 93

Update

I'm going to be using the ScriptBasic application server for the new SQL mirroring package. Data syncing runs a separate fault tolerant thread that runs in the background and maintained with a web UI. As an added benefit the application server provides a web service interface to hide BOI / COM programming with endpoints for common tasks. The web service uses an open scripting design. The application server can also provide traditional dynamic web content as well. The new version is targeting MS SQL Server as its primary DB.

The ScriptBasic application server runs as a Windows service and starts automatically when Windows starts or rebooted.

I'm working on web service BOI endpoint scripts and looking for suggestions of common BOI tasks used by the Sage community. I plan to cover typical transaction entry functions like invoice, sales order, purchase orders and others. Custom BOI web service scripts are easy to add with ScriptBasic's COM/OLE automation interface.

A key advantage over other BI offerings is that the ETL (Extract, Translate and Load) functionality happens as part of the mirroring process. Once changed tables are mirrored, SQL statements are executed building consolidation tables for instant BI dashboards that are interactive with Sage 100 modules.

This is an example of my new SBODBC.Schema OCX / DLL that returns DB Tables, Column and Key info.

ScriptBasic Test Program

IMPORT com.sbi

schema = COM::CREATE(:SET, "SBODBC.Schema")

PRINT "*** TABLES ***\n\n"
PRINT COM::CBN(schema, "TableList", :CALL, "DSN=SAGE100"), "\n"
PRINT "*** COLUMNS - AR_Customer ***\n\n"
PRINT COM::CBN(schema, "TableColumns", :CALL, "DSN=SAGE100", "AR_Customer"), "\n"
PRINT "*** KEYS - AR_Customer ***\n\n"
PRINT COM::CBN(schema, "TableKeys", :CALL, "DSN=SAGE100", "AR_Customer"), "\n"

COM::RELEASE schema

OUTPUT

*** TABLES ***

AP_ACHCheckEntry
AP_ACHFileWrk
AP_ACHGenerationAddenda
AP_ACHGenerationDetail
AP_ACHGenerationHeader
AP_ACHInterface
AP_ACHInterfaceListingWrk
AP_AgedInvoiceWrk
AP_Analysis
AP_AnalysisReportWrk
AP_AnalysisWrk
AP_ARClearingDetail
AP_ARClearingHeader
AP_ARClearingRecapWrk
AP_ARClearingRegisterWrk
AP_ARClearingRestart
AP_AssignVendorTaxSchedListWrk
AP_Audit
AP_CashRequirementsWrk
AP_ChangeVendorsValidate
AP_CheckDetail
AP_CheckDetailPosting
AP_CheckHeader
AP_CheckHeaderPosting
AP_CheckHistoryDetail
AP_CheckHistoryHeader
AP_CheckHistoryWrk
AP_CheckRegisterWrk
AP_CheckRestart
AP_CheckStubWrk
AP_CheckWrk
AP_DailyPostingWork
AP_DeleteChangeVendors
AP_DeleteChangeVendorsWork
AP_Division
AP_DivisionListingWrk
AP_ElectronicPmtRegisterWrk
AP_ExpenseByGLAccountWrk
AP_ExpenseDistTableDetail
AP_ExpenseDistTableHeader
AP_ExpenseDistTableWrk
AP_ExtendedStubWrk
AP_FixedAssetsHistoryWrk
AP_Form1099PrintingWrk
AP_InvoiceAppliedPrepayPosting
AP_InvoiceDetail
AP_InvoiceDetailPosting
AP_InvoiceHeader
AP_InvoiceHeaderPosting
AP_InvoiceHistoryAppliedPrepay
AP_InvoiceHistoryAsset
AP_InvoiceHistoryDetail
AP_InvoiceHistoryHeader
AP_InvoiceHistoryMemo
AP_InvoiceHistoryMemoSettings
AP_InvoiceHistoryTaxSummary
AP_InvoiceHistoryWrk
AP_InvoiceMemo
AP_InvoiceMemoSettings
AP_InvoicePaymentListingWrk
AP_InvoiceRegisterWrk
AP_InvoiceRestart
AP_InvoiceTaxDetail
AP_InvoiceTaxSummary
AP_JobDistributionDetail
AP_LastBankUsed
AP_ManualCheckDetail
AP_ManualCheckHeader
AP_ManualCheckInvDetail
AP_ManualCheckInvDetailWork
AP_ManualCheckRegisterWrk
AP_ManualCheckRestart
AP_ManualCheckTaxDetail
AP_ManualCheckTaxSummary
AP_MonthlyPurchaseWrk
AP_OpenInvoice
AP_OpenInvoiceByJobWrk
AP_OpenInvoiceTaxSummary
AP_Options
AP_OptionsListingWrk
AP_PaymentHistoryWrk
AP_PreNoteApprovalRegisterWrk
AP_PreNoteApprovalRestart
AP_PreNoteSelectionRegisterWrk
AP_PreNoteSelectionRestart
AP_RecapByDivisionWrk
AP_RepetitiveInvMemoSettings
AP_RepetitiveInvoiceDetail
AP_RepetitiveInvoiceHeader
AP_RepetitiveInvoiceListingWrk
AP_RepetitiveInvoiceMemo
AP_RepetitiveInvoiceTaxDetail
AP_RepetitiveInvoiceTaxSummary
AP_ReverseCheckDetail
AP_ReverseCheckHeader
AP_ReverseCheckRegisterWrk
AP_ReverseCheckRestart
AP_ReverseCheckWork
AP_SalesTax
AP_SalesTaxCalcErrorLogWrk
AP_SalesTaxWrk
AP_SummaryDrillDownWork
AP_TaxJournalWrk
AP_TaxSummaryWork
AP_TermsCode
AP_TransactionPaymentHistory
AP_TrialBalanceWrk
AP_Vendor
AP_Vendor1099Payments
AP_VendorAuditWrk
AP_VendorContact
AP_VendorContactListingWrk
AP_VendorCustomerLink
AP_VendorCustomerLinkListWrk
AP_VendorDocumentContacts
AP_VendorDocuments
AP_VendorElectronicPayHistory
AP_VendorElectronicPayment
AP_VendorListingBalWrk
AP_VendorListingWrk
AP_VendorMailingLabelsWrk
AP_VendorMemo
AP_VendorMemoPrintingWrk
AP_VendorMemoSettings
AP_VendorPDFLog
AP_VendorPurchaseAnalysisWrk
AP_VendorPurchasesHistory
AP_VendorPurchHistoryByPdWrk
AP_VendorRemit
AR_AgedInvoiceReportWrk
AR_AlternateInvoice
AR_Analysis
AR_AnalysisReportWrk
AR_AnalysisWrk
AR_Audit
AR_BillToCustomerListingWrk
AR_BillToSoldTo
AR_CashExpectationReportWrk
AR_CashReceiptsDeposit
AR_CashReceiptsDetail
AR_CashReceiptsHeader
AR_CashReceiptsHistory
AR_CashReceiptsJournalWrk
AR_CashReceiptsRestart
AR_CashReceiptsWrk
AR_CashRecPaymentTypeRecapWrk
AR_CashSales
AR_ChangeCustomersValidate
AR_CommissionRegisterWrk
AR_CreditCardSettlementWrk
AR_CreditCardWork
AR_Customer
AR_CustomerAuditWrk
AR_CustomerContact
AR_CustomerContactListingWrk
AR_CustomerCreditCard
AR_CustomerCreditCardEBMUser
AR_CustomerCreditCardListWrk
AR_CustomerDocumentContacts
AR_CustomerDocuments
AR_CustomerListingBalWrk
AR_CustomerListingWrk
AR_CustomerMailingLabelsWrk
AR_CustomerMemo
AR_CustomerMemoSettings
AR_CustomerMemoWrk
AR_CustomerPDFLog
AR_CustomerPricingWrk
AR_CustomerRenumber
AR_CustomerSalesAnalysisWrk
AR_CustomerSalesHistory
AR_CustomerSalespersonHistory
AR_CustomerShipToTaxExemptions
AR_CustomerSlsHistByPerWrk
AR_DailyPostingWork
AR_DeleteChangeCustomers
AR_DeleteChangeCustomersWork
AR_DepositHistory
AR_DepositHistoryWrk
AR_Division
AR_DivisionListingWrk
AR_EInvoiceErrorLog
AR_FinanceCharge
AR_FinanceChargeJournalRestart
AR_FinanceChargeJournalWrk
AR_GrossProfitJournalWrk
AR_InvoiceDetail
AR_InvoiceHeader
AR_InvoiceHistoryDetail
AR_InvoiceHistoryHeader
AR_InvoiceHistoryLotSerial
AR_InvoiceHistoryMemo
AR_InvoiceHistoryMemoSettings
AR_InvoiceHistoryPayment
AR_InvoiceHistoryTaxSummary
AR_InvoiceHistoryTracking
AR_InvoiceHistoryWrk
AR_InvoiceMemo
AR_InvoiceMemoSettings
AR_InvoiceRestart
AR_InvoiceTaxDetail
AR_InvoiceTaxSummary
AR_InvoiceWrk
AR_MatchCreditsToInvoiceWrk
AR_MonthlySalesWrk
AR_OpenInvoice
AR_OpenInvoiceSplitCommissions
AR_OpenInvoiceTaxSummary
AR_Options
AR_OptionsListingWrk
AR_PaymentType
AR_PaymentTypeWrk
AR_PriceLevelByCustCopyWrk
AR_PriceLevelByCustListingWrk
AR_PriceLevelByCustPriceCode
AR_PriceLevelByCustShipTo
AR_RecapByDivisionWrk
AR_RepetitiveInvMemoSettings
AR_RepetitiveInvoiceDetail
AR_RepetitiveInvoiceHeader
AR_RepetitiveInvoiceListingWrk
AR_RepetitiveInvoiceMemo
AR_RepetitiveInvoiceTaxDetail
AR_RepetitiveInvoiceTaxSummary
AR_SalesAnalysisSalespersonWrk
AR_SalesJournalWrk
AR_Salesperson
AR_SalespersonCommission
AR_SalespersonCommissionWrk
AR_SalespersonDocuments
AR_SalespersonHistory
AR_SalespersonLink
AR_SalespersonListingWrk
AR_SalespersonSlsHistByPerWrk
AR_SalesTax
AR_SalesTaxWrk
AR_StatementWrk
AR_SummaryDrillDownWork
AR_TaxJournalWrk
AR_TermsCode
AR_TrackingByItemHistory
AR_TransactionPaymentHistory
AR_TransactionPosting
AR_TrialBalanceWrk
BR_AutoCheckDetail
BR_AutoCheckHeader
BR_AutoCheckSettings
BR_AutoCheckWrk
BR_BankRecapWrk
BR_DailyPostingWork
BR_EstimatedCashFlowAnlysWrk
BR_Options
BR_PositivePayDetail
BR_PositivePayExportWrk
BR_PositivePayHeader
BR_PositivePaySelection
BR_PositivePaySettings
BR_ReconciliationRegisterWrk
BR_Transaction
BR_TransactionRegisterWrk
BR_TransactionRestart
CI_BackOrderFillWrk
CI_BankCodeListingWrk
CI_ChangeEntityWork
CI_ChangeItemsValidate
CI_CommodityCode
CI_CommodityCodeApplyWrk
CI_ConversionHistory
CI_EnhancementActivation
CI_ExtendedDescription
CI_InactivationExceptionWrk
CI_InactiveReasonCode
CI_Item
CI_ItemHistoryByPeriod
CI_ItemTransactionHistory
CI_MiscellaneousItemListingWrk
CI_MiscItemDetailTransWrk
CI_MiscItemHistoryByPeriodWrk
CI_Options
CI_SalesTaxAccountListingWrk
CI_StandardCostAdjustmentWork
CI_StandardCostAdjustmentWrk
CI_StandardCostAdjustRestart
CI_StandardCostAdjustSelection
CI_UnitOfMeasure
CM_DetailReportWrk
CM_Entity
CM_Lock
CM_Log
CM_Options
CM_Script
CM_ScriptLink
CM_ScriptListingWrk
CM_ScriptSettings
CM_SummaryReportWrk
CM_UDF
CM_UdfIolist
CM_UDFMaintenanceListingWrk
CM_UDFOptions
CM_UdtListingWrk
CM_UIScriptLink
CM_UIScriptSettings
CU_ActivityLog
CU_ActivityLogWrk
CU_Address
CU_AddressLink
CU_Company
CU_Country
CU_CountryWrk
CU_CRMServerOptions
CU_CustomerTemplate
CU_CustomerTemplateWrk
CU_Email
CU_EmailLink
CU_MAS_Company
CU_Notes
CU_Opportunity
CU_Options
CU_OptionsWrk
CU_OrderQuoteDetail
CU_OrderQuoteTracking
CU_Person
CU_Phone
CU_PhoneLink
CU_Users
ES_DashboardSelectionListWrk
ES_Options
ES_ViewSelectionDetail
ES_ViewSelectionHeader
GL_Account
GL_AccountCategory
GL_AccountFilterFRxWrk
GL_AccountFRxWrk
GL_AccountGroup
GL_AccountHistory
GL_AccountMemo
GL_AccountMemoSettings
GL_AccountMemoWrk
GL_AccountSegment
GL_AccountStructure
GL_AccountType
GL_AllocationDetail
GL_AllocationHeader
GL_AllocationJournalWrk
GL_AllocationSelectionCalc
GL_AllocationSelectionDetail
GL_AllocationSelectionHeader
GL_AllocationSelectionOptions
GL_AllocationSelectionRestart
GL_AnalysisWrk
GL_Audit
GL_AuditWrk
GL_BalanceFRxWrk
GL_Bank
GL_BankPIIWrk
GL_Budget
GL_BudgetAndHistoryWrk
GL_BudgetOptions
GL_BudgetReportWrk
GL_BudgetRevision
GL_BudgetRevisionOptions
GL_BudgetRevisionWrk
GL_ChangeAccounts
GL_ChangeAccountsRestart
GL_ChangeAccountsValidate
GL_ChangeAccountsWork
GL_ChartOfAccountsWrk
GL_CheckMicr
GL_CheckMicrPIIWrk
GL_CompanyActiveBatch
GL_CompanyBatchOptions
GL_CompanyMemoManagerSettings
GL_DailyPosting
GL_DailyTransactionRegisterWrk
GL_DailyTransactionRestart
GL_DataExchange
GL_DeleteAccountsWork
GL_DetailBySourceWrk
GL_DetailPosting
GL_DetailReportWrk
GL_ErrorLogWrk
GL_ExceptionReportWrk
GL_Exchange
GL_ExchangeAccountWrk
GL_ExchangeActivityWrk
GL_ExchangeBudgetWrk
GL_ExchangeSelection
GL_ExchangeTransactionWrk
GL_FinancialReport
GL_FinancialReportDetailWrk
GL_FinancialReportGroup
GL_FinancialReportHeaderWrk
GL_FinancialReportSelection
GL_FinancialReportTokenWrk
GL_FinancialTerminology
GL_FiscalYear
GL_FiscalYearDetail
GL_FiscalYearListingWrk
GL_GeneralJournalDetail
GL_GeneralJournalHeader
GL_GeneralJournalHistory
GL_GeneralJournalMemo
GL_GeneralJournalMemoSettings
GL_GeneralJournalRestart
GL_GeneralJournalWrk
GL_GraphicsWrk
GL_JournalDrillDownWrk
GL_MainAccount
GL_MainAccountListingWrk
GL_MainAccountMemo
GL_MainAccountMemoSettings
GL_MainAccountMemoWrk
GL_Options
GL_OptionsListingWrk
GL_PayAccount
GL_PayAccountSelectListingWrk
GL_PayActivity
GL_PayActivityLogWrk
GL_PayBank
GL_PayOptions
GL_PaySyncAccountWork
GL_PaySyncBankCodeWork
GL_PayTransactionDetail
GL_PayTransactionHeader
GL_PeriodBudgetDetail
GL_PeriodPostingHistory
GL_PostingRecapWrk
GL_PreMigrationReportsWrk
GL_RecalculateAccountsWork
GL_RecurringJournalDetail
GL_RecurringJournalHeader
GL_RecurringJournalHistory
GL_RecurringJournalRestart
GL_RecurringJournalUpdate
GL_RecurringJournalWrk
GL_Rollup
GL_SalesTax
GL_SourceJournal
GL_SourceJournalHistory
GL_SourceJournalHistoryWrk
GL_StandardJournalDetail
GL_StandardJournalHeader
GL_StandardJournalListingWrk
GL_SubAccount
GL_SummaryDetailDrillDown
GL_TransactionJournalDetail
GL_TransactionJournalHeader
GL_TransactionJournalHistory
GL_TransactionJournalMemo
GL_TransactionJournalRestart
GL_TransactionJournalWrk
GL_TransJournalMemoSettings
GL_TrialBalanceWrk
GL_WorksheetWrk
IM_AliasItem
IM_AliasItemListingWrk
IM_AlternateItem
IM_Audit
IM_AutoCostPriceChangeWrk
IM_BalanceQtyOnHandWork
IM_BuyerPlannerCode
IM_ChangeLotSerialExpDatesWrk
IM_CostedSalesKitWrk
IM_CountCardDefaults
IM_CountCardDetail
IM_CountCardHeader
IM_CountCardRestart
IM_CountCardVarRegisterWrk
IM_CountCardWrk
IM_DailyPostingWork
IM_DataEntryCostCalcCommit
IM_DeleteChangeItems
IM_DeleteChangeItemsWork
IM_DetailTransactionWrk
IM_ErrorLogWrk
IM_InventoryFileComparisonWrk
IM_InventoryLabelsWrk
IM_IssueHistoryWrk
IM_ItemAuditWrk
IM_ItemCost
IM_ItemCostCalcSource
IM_ItemCustomerHistoryByPeriod
IM_ItemListingWithSalesHistWrk
IM_ItemListingWrk
IM_ItemMemo
IM_ItemMemoSettings
IM_ItemMemoWrk
IM_ItemTransactionHistory
IM_ItemTransactionRecalc
IM_ItemValuationChangeWrk
IM_ItemValuationSelection
IM_ItemValuationUpdateRestart
IM_ItemValuationUpdateWork
IM_ItemVendor
IM_ItemVendorHistoryByPeriod
IM_ItemWarehouse
IM_ItemWhseHistoryByPeriod
IM_LotSerialExpStatusWrk
IM_LotSerialOrderWork
IM_LotSerialTransactionHistory
IM_LotSerialTransHistWrk
IM_MissingCountCardListingWrk
IM_NegativeTierRegisterWork
IM_NegativeTierRestart
IM_NegativeTierWrk
IM_Options
IM_OptionsListingWrk
IM_PeriodPostingHistory
IM_Physical
IM_PhysicalCountVarRegisterWrk
IM_PhysicalCountWrkstWrk
IM_PhysicalDefaults
IM_PhysicalRestart
IM_PriceCode
IM_PriceCodeListingWrk
IM_PriceListWrk
IM_ProductLine
IM_ProductLineApplyWrk
IM_ProductLineListingWrk
IM_ReceiptLabelsWork
IM_ReceiptsHistoryWrk
IM_ReorderReportWrk
IM_SalesAnalysisWrk
IM_SalesHistoryWrk
IM_SalesKitDetail
IM_SalesKitHeader
IM_SalesKitWhereUsedWrk
IM_SalesKitWrk
IM_SalesPromotion
IM_SalesPromotionApplyWrk
IM_SalesPromotionWrk
IM_StockStatusWrk
IM_TransactionDetail
IM_TransactionHeader
IM_TransactionPosting
IM_TransactionRegisterWrk
IM_TransactionRestart
IM_TransactionTierDist
IM_TrialBalanceWrk
IM_TurnoverReportWrk
IM_ValuationReportByPeriodWrk
IM_ValuationReportWrk
IM_Warehouse
IM_WarehouseListingWrk
IM_WarehouseRestricted
IM_WarrantyCode
IT_Category
IT_CategoryListingWrk
IT_CategoryTreeListingWrk
IT_Customer
IT_EMail
IT_EMailNotification
IT_EmailNotificationWrk
IT_EMailPending
IT_EMailReasonCode
IT_EMailToken
IT_HTMLTemplate
IT_Item
IT_ItemAttachment
IT_ItemCategory
IT_Options
IT_OptionsListingWrk
IT_OrderCategoryTree
IT_ShoppingCartAcceptLogWrk
IT_ShoppingCartAutoLogDtl
IT_ShoppingCartAutoLogHdr
IT_ShoppingCartDetail
IT_ShoppingCartHeader
IT_ShoppingCartItemsSelected
IT_ShoppingCartRegisterWrk
IT_ShoppingCartTaxDetail
IT_ShoppingCartTaxSummary
IT_StoreCategoryTree
IT_UIDCustomerAcceptanceLogWrk
IT_UIDCustomerChange
IT_UIDCustomerChangeAutoLog
IT_UIDCustomerChangeRestart
IT_UIDCustomerRegisterWrk
IT_UserIDListingWrk
IT_WebMenu
IT_WebTemplateOptions
JC_InvalidCostTypeListingWrk
MD_BatchListingWrk
MD_ConversionDriverListingWrk
MD_DefaultPerformWrk
MD_EISViewMasterReportWrk
MD_EMailNotificationListingWrk
MD_EnhancementReportWrk
MD_HelpMaintListingWrk
MD_MemoMaintenanceListingWrk
MD_MemoRelationshipListingWrk
MD_MenuReportWrk
MD_ModuleListingWrk
MD_ReportManagerMasterWrk
MD_ReportManagerTemplateWrk
MD_TaskReportWrk
PL_EmailMessage
PL_EmailMessageListingWrk
PL_Form
PL_FormListingWrk
PL_JournalPDFLog
PL_JournalRegister
PL_JournalRegisterListingWrk
PL_Options
PL_PeriodEndPDFLog
PL_PeriodEndReport
PL_PeriodEndReportListingWrk
PL_Report
PL_ReportListingWrk
PL_ReportPDFLog
PO_AutoGenerateOrders
PO_AutoGenerateOrdersDefaults
PO_AutomaticReorderSelectWrk
PO_AutoOrderSelectWrk
PO_AutoReorderSelection
PO_CancelReasonCode
PO_CashRequirementsWrk
PO_DailyPostingWork
PO_DailyPurchasesJournalWrk
PO_ExpectedDeliveryRecapWrk
PO_ExpectedDeliveryWrk
PO_LandedCostAllocation
PO_LandedCostHistory
PO_LandedCostReceipt
PO_LandedCostType
PO_LandedCostTypeListingWrk
PO_MaterialReqDefaults
PO_MaterialReqDetail
PO_MaterialReqHeader
PO_MaterialReqIssueRegisterWrk
PO_MaterialReqRestart
PO_MaterialReqTierDistribution
PO_OpenOrderDetailByItem
PO_OpenOrdersByItemWrk
PO_OpenOrdersByJobWrk
PO_OpenOrdersByWorkOrderWrk
PO_OpenPurchaseOrderWrk
PO_Options
PO_OptionsListingWrk
PO_PurchaseHistoryWrk
PO_PurchaseOrderDefaults
PO_PurchaseOrderDetail
PO_PurchaseOrderHeader
PO_PurchaseOrderHistoryDetail
PO_PurchaseOrderHistoryHeader
PO_PurchaseOrderHistoryMemo
PO_PurchaseOrderHistoryMemoSet
PO_PurchaseOrderHistoryWrk
PO_PurchaseOrderHistTaxDetail
PO_PurchaseOrderHistTaxSummary
PO_PurchaseOrderMemo
PO_PurchaseOrderMemoSettings
PO_PurchaseOrderNoListingWrk
PO_PurchaseOrderPrint
PO_PurchaseOrderRecap
PO_PurchaseOrderRecapWrk
PO_PurchaseOrderTaxDetail
PO_PurchaseOrderTaxSummary
PO_PurchaseOrderWrk
PO_PurchasesClearingWrk
PO_PurchasesHistory
PO_ReceiptAppliedLandedCost
PO_ReceiptAppliedPurchaseOrder
PO_ReceiptDefaults
PO_ReceiptDetail
PO_ReceiptHeader
PO_ReceiptHistoryAppliedLC
PO_ReceiptHistoryAppliedPO
PO_ReceiptHistoryDetail
PO_ReceiptHistoryHeader
PO_ReceiptHistoryLotSerial
PO_ReceiptHistoryMemo
PO_ReceiptHistoryMemoSettings
PO_ReceiptHistoryTaxSummary
PO_ReceiptHistoryWrk
PO_ReceiptInvoiceVarianceWrk
PO_ReceiptMemo
PO_ReceiptMemoSettings
PO_ReceiptOfGoodsInvoiceWrk
PO_ReceiptRestart
PO_ReceiptReturnMatRqByPO
PO_ReceiptTaxAllocation
PO_ReceiptTaxDetail
PO_ReceiptTaxJournalWrk
PO_ReceiptTaxSummary
PO_ReceiptTierDistribution
PO_ReceiptVarianceCalculation
PO_ReturnDebitMemoJournalWrk
PO_ReturnDefaults
PO_ReturnDetail
PO_ReturnHeader
PO_ReturnMatRqTierCostCalcWork
PO_ReturnMemo
PO_ReturnMemoSettings
PO_ReturnOfGoodsRegisterWrk
PO_ReturnOrderPrint
PO_ReturnOrderWrk
PO_ReturnRestart
PO_ReturnTaxAllocation
PO_ReturnTaxDetail
PO_ReturnTaxJournalWrk
PO_ReturnTaxSummary
PO_ReturnTierDistribution
PO_ShipToAddress
PO_ShipToAddressListingWrk
PO_SummaryDrillDownWork
PO_VendorPriceLevel
PO_VendorPriceLevelListingWrk
PO_VendorPurchaseAddress
PO_VendPurchAddressListingWrk
PO_WOTransactionJournalWrk
POT_TemporaryWork
PR1_EmployeeMaster
PR_MissingEmployeeListingWrk
PR_PreMigrationTaxListingWrk
PR_TaxProfile
PR_TaxProfileDetail
PR_TaxProfileLocation
RA_CustomerInvoiceSearch
RA_CustomerRMAWrk
RA_DailyRepairWrk
RA_DeleteRenumberMergeXref
RA_GenerateTransactions
RA_GenerateTransactionsWrk
RA_InquiryReceiptsHistoryLink
RA_OpenRMAWrk
RA_Options
RA_OptionsListingWrk
RA_ReceiptsDefaults
RA_ReceiptsDetail
RA_ReceiptsHeader
RA_ReceiptsHistoryDetail
RA_ReceiptsHistoryHeader
RA_ReceiptsHistoryInvoice
RA_ReceiptsHistoryLotSerial
RA_ReceiptsHistoryMemo
RA_ReceiptsHistoryMemoSettings
RA_ReceiptsHistoryWrk
RA_ReceiptsMemo
RA_ReceiptsMemoSettings
RA_ReceiptsReceiving
RA_ReceiptsRestart
RA_ReceiptsTierDistribution
RA_RepairDetail
RA_ReturnDefaults
RA_ReturnDetail
RA_ReturnHeader
RA_ReturnMemo
RA_ReturnMemoSettings
RA_ReturnPrint
RA_ReturnReasonCode
RA_ReturnReasonDetail
RA_ReturnReasonLotSerial
RA_ReturnReasonWrk
RA_ReturnTierDistribution
RA_ReturnToAddressCode
RA_ReturnToAddressListingWrk
RA_RMAReceiverWrk
SO_AdditionalPackingListWrk
SO_ARInvoiceHistoryLink
SO_AutoGenerateInvoices
SO_AutoGenerateOrders
SO_AutoGenInvoicesListingWrk
SO_AutoGenOrdersListingWrk
SO_BackOrderWrk
SO_BatchAuthorizationWrk
SO_CancelReasonCode
SO_CODLabelsWrk
SO_CustomerLastPurchaseListWrk
SO_CustomerSalesHistoryWrk
SO_CustomerSlsHistByItemWrk
SO_CustomerSlsHistByProdLnWrk
SO_DailyBackOrderRecapWrk
SO_DailyDepositRecapWrk
SO_DailyDropShipWrk
SO_DailyJobTransactionWrk
SO_DailyPostingWork
SO_DailyShipment
SO_DailyShipmentPackage
SO_DailyShipmentWrk
SO_DuplicatePOCheckingWrk
SO_GrossProfitJournalWrk
SO_InvoiceAppliedSalesOrders
SO_InvoiceDefaults
SO_InvoiceDetail
SO_InvoiceHeader
SO_InvoiceHistoryLink
SO_InvoiceMemo
SO_InvoiceMemoSettings
SO_InvoicePayment
SO_InvoiceRestart
SO_InvoiceTaxDetail
SO_InvoiceTaxSummary
SO_InvoiceTierCostCalcWork
SO_InvoiceTierDistribution
SO_InvoiceTracking
SO_InvoiceWrk
SO_LastPurchaseHistory
SO_LineItemCommission
SO_LineItemCommissionListWrk
SO_LotSerialHistory
SO_LotSerialHistoryWrk
SO_OpenOrderDetailByItem
SO_OpenOrdersByItemWrk
SO_OpenOrdersByPromiseDateWrk
SO_OpenOrdersWrk
SO_Options
SO_OptionsListingWrk
SO_PackageTrackingByItem
SO_PackingListWrk
SO_PickingSheetWrk
SO_PurchaseControlListingWrk
SO_PurchaseCtrlByCustByItem
SO_PurchaseCtrlByCustByProdLn
SO_PurchaseCtrlByStateByItem
SO_PurchaseCtrlByStateByProdLn
SO_RecapByDivision
SO_RecapByProductLineWhse
SO_RecapByWarehouse
SO_RecapWrk
SO_SalesDailyRecapWork
SO_SalesDailyRecapWrk
SO_SalesHistory
SO_SalesJournalRestart
SO_SalesJournalWrk
SO_SalesOrderDefaults
SO_SalesOrderDetail
SO_SalesOrderDropShip
SO_SalesOrderHeader
SO_SalesOrderHistMemoSettings
SO_SalesOrderHistoryDetail
SO_SalesOrderHistoryHeader
SO_SalesOrderHistoryMemo
SO_SalesOrderHistoryPayment
SO_SalesOrderHistoryTaxDetail
SO_SalesOrderHistoryTaxSummary
SO_SalesOrderMemo
SO_SalesOrderMemoSettings
SO_SalesOrderPayment
SO_SalesOrderPrint
SO_SalesOrderQuoteHistoryWrk
SO_SalesOrderRecap
SO_SalesOrdersThatAreOpenWrk
SO_SalesOrderTaxDetail
SO_SalesOrderTaxSummary
SO_SalesOrderTierDistribution
SO_SalesOrderWrk
SO_SalesRecapByDivisionWrk
SO_SalesRecapByProductLineWrk
SO_SalesRecapByWarehouseWrk
SO_SalesRecapByWhseProdLineWrk
SO_SalesTaxJournalWrk
SO_ShipperID
SO_ShippingExceptionWrk
SO_ShippingHistoryWrk
SO_ShippingLabelsWrk
SO_ShippingOptions
SO_ShippingRateDetail
SO_ShippingRateHeader
SO_ShippingRateListingWrk
SO_ShipToAddress
SO_ShipToAddressListingWrk
SO_SummaryDrillDownWork
SY0_CompanyParameters
SY0ACT_ACTLinkSystemParameters
SY0AL3_ACTLinkDataMapping
SY0DD1_DataDictionary
SY0FAX_FaxFormDefSysFile
SY0STE_NameToCodeXrefFile
SY1FAX_FaxFormDefMasterFile
SY_1099Setup
SY_ACH_ACHFileInfo
SY_Activation
SY_ActivationReq
SY_ActivityLog
SY_ActivityLogReportWrk
SY_ActivityType
SY_BaseODBCSecurity
SY_BatchManager
SY_Broadcast
SY_ClassEnhancement
SY_Company
SY_CompanyListingWrk
SY_ConfigData
SY_ConfigDataSettings
SY_Console
SY_Context
SY_ContextAFM
SY_ConversionDriver
SY_ConversionHistory
SY_Country
SY_CreditCardProcessXref
SY_CreditCardRestart
SY_CrystalAnalysisWrk
SY_Deferred
SY_Developer
SY_DeveloperManifest
SY_Dialog
SY_DialogSettings
SY_DictionaryConversionHist
SY_EBusinessManagerUserID
SY_EISViewMaster
SY_EmbeddedIOSettings
SY_Enhancement
SY_EnhancementModule
SY_ExportLink
SY_ExtendedSolutionUDFConvWork
SY_FieldMapping
SY_FinancialReport
SY_FinancialReportColumn
SY_FinancialTerminology
SY_FormsEFilingVersion
SY_GridDefinition
SY_InstalledModulesListingWrk
SY_JournalErrorLogWrk
SY_LastFormUsed
SY_LinkPathsWork
SY_LockFileInfo
SY_LockFiles
SY_MemoDefault
SY_MemoManager
SY_MemoRelationship
SY_MemoSettingsListingWrk
SY_Menu
SY_Message
SY_MessageLink
SY_Metering
SY_Module
SY_ModuleDate
SY_ModuleDateListingWrk
SY_MultiPartForm
SY_NoMessage
SY_ODBCSecurity
SY_OfficeUserMap
SY_OfficeUserMapListingWrk
SY_PaymentCenterReference
SY_PayrollEFilingMapping
SY_PeriodEndListingWrk
SY_PeriodEndReport
SY_Personalize
SY_PersonalizeALE
SY_PIIRestart
SY_PollingSystem
SY_PopupItem
SY_PopupMenu
SY_PopupMenuItem
SY_PopupXref
SY_PreMigrationCompany
SY_PreMigrationItemCode
SY_PreMigrationWarehouse
SY_PrinterPreferences
SY_ProcessFlows
SY_RebuildLog
SY_Relation
SY_ReportManagerFormat
SY_ReportManagerMaster
SY_ReportManagerTemplate
SY_ReportOption
SY_ReportSelection
SY_ReportSetting
SY_ReportSettingsListingWrk
SY_ReportTask
SY_ReportWizardExpressions
SY_ReportWizardFields
SY_ReportWizardFilters
SY_ReportWizardGroups
SY_ReportWizardLinks
SY_ReportWizardMain
SY_ReportWizardRoles
SY_ReportWizardSorts
SY_ReportWizardSources
SY_ResourceRoleSecurity
SY_Role
SY_RoleReportODBCSecurityWrk
SY_RoleReportWrk
SY_RoleSecurity
SY_SagePEP
SY_SagePEPSettings
SY_SagePEPTask
SY_SagePEPTrack
SY_SalesTaxClass
SY_SalesTaxCode
SY_SalesTaxCodeDetail
SY_SalesTaxCodeListingWrk
SY_SalesTaxSchedule
SY_SalesTaxScheduleDetail
SY_SalesTaxScheduleListingWrk
SY_SalesTaxScheduleStateXRef
SY_SalesTaxScheduleZipXRef
SY_SampleAccounts
SY_SampleAccountsWrk
SY_ServiceNotification
SY_ServiceNotificationListWrk
SY_SQLOptimize
SY_StarShipWork
SY_State
SY_StateCodeListingWrk
SY_StateEdit
SY_Surrogate
SY_SurrogateLog
SY_System
SY_SystemConfigListingWrk
SY_Task
SY_TaskSchedulerDetail
SY_TaskSchedulerHeader
SY_TaskSchedulerListingWrk
SY_TaskType
SY_Template
SY_TemplateSetting
SY_Terminal
SY_Theme
SY_Token
SY_URLMaintenance
SY_User
SY_UserAutoComplete
SY_UserHistory
SY_UserLogonSecurity
SY_UserRegistry
SY_UserReportWrk
SY_UserSecurity
SY_UserSettingsListingWrk
SY_UserTableSecurity
SY_UserTableSecurityReportWrk
SY_WizardListingWrk
SY_Workstation
SY_ZipCode
SY_ZipCodeEdit
SY_ZipCodeListingWrk
vAccount
vAccountCategory
vAccountGroup
vAccountHistory
vAccountMemo
vAccountSegment
vAccountsPayableDivisions
vAccountsReceivableDivisions
vAccountStructure
vAccountType
vAllocationEntry
vAPCheckEntry
vAPCheckHistory
vAPInvoiceEntry
vAPInvoiceEntryJobDistribution
vAPInvoiceEntryTaxDetail
vAPInvoiceEntryTaxSummary
vAPRepetitiveInvoiceEntry
vAPRepetitiveInvoiceEntryTaxDet
vAPRepetitiveInvoiceEntryTaxSum
vAPSalesTaxDetail
vAudit
vBank
vBankTransactions
vBillOfMaterials
vBillOptions
vBudget
vBudgetRevision
vCashReceiptsEntry
vCashReceiptsHistory
vCashSalesTransactions
vCustomer
vCustomerAudit
vCustomerContacts
vCustomerCreditCard
vCustomerInvoiceHistDetailTracking
vCustomerInvoiceHistItemTracking
vCustomerInvoiceHistLotSerial
vCustomerInvoiceHistory
vCustomerInvoiceHistoryMemo
vCustomerInvoiceHistoryPayment
vCustomerInvoiceHistTaxSummary
vCustomerInvoiceHistWithRMA
vCustomerInvoiceMemo
vCustomerLastPurchaseHistory
vCustomerMemos
vCustomerOpenInvoice
vCustomerSalesHistory
vCustomerSalespersonHistory
vCustomerShipToAddress
vCustomerTermsCodes
vCustomerTransPaymentHistory
vCustomerTransPymntHistWithRMA
vDailyPosting
vDepositTransactionHistory
vDetailPosting
vDisassemblyEntry
vDisassemblyEntryTierDistribution
vEngineeringChangeEntry
vFinancialTerminology
vFiscalYear
vFiscalYearDetail
vGeneralJournalEntry
vGeneralJournalHistory
VI_DefaultPerform
VI_ExportJobDefinitionWrk
VI_ImportJobDefinitionWrk
VI_JobExportElements
VI_JobExportSelection
VI_JobExportSort
VI_JobHeader
VI_JobImportElements
VI_JobImportRecordTypes
VI_JobImportSelection
VI_JobLog
VI_JobLogWrk
VI_JobPerform
VI_ODBCField
VI_ODBCLink
VI_ODBCTable
VI_Options
VI_SortWrk
vInventorySalesKit
vInvoiceEntry
vInvoiceEntryTaxDetail
vInvoiceEntryTaxSummary
vItem
vItemAudit
vItemCostingDetail
vItemCustomerHistory
vItemVendorHistory
vItemVendorInformation
vItemWarehouse
vItemWarehouseHistory
vJobCostCodeDetail
vJobCostJob
vLandedCostHistory
vLotAndSerialNumberReceiptHistory
vLotAndSerialTransactionHistory
vMainAccount
vMainAccountMemo
vManualCheckEntry
vManualCheckEntryTaxDetail
vManualCheckEntryTaxSummary
vMaterialReqEntryTierDistribution
vMaterialRequsitionIssueEntry
vPeriodBudgetDetail
vPeriodPostingHistory
vPhysicalCountEntry
vProductionEntry
vProductionEntryTierDistribution
vProductionHistory
vProductionHistoryTierDistribution
vPurchaseOrderEntry
vPurchaseOrderEntryMemo
vPurchaseOrderEntryTaxDetail
vPurchaseOrderHistory
vPurchaseOrderRecap
vPurchasesHistory
vReceiptHistory
vReceiptHistoryMemo
vReceiptHistoryTaxDetail
vReceiptOfGoodsEntry
vReceiptOfGoodsEntryMemo
vReceiptOfGoodsEntryTaxDetail
vReceiptOfGoodsLandedCost
vReceiptOfInvoiceEntry
vReceiptOfInvoiceEntryMemo
vReceiptOfInvoiceEntryTaxDetail
vReceiptsEntryTierDistribution
vRecurringJournalEntry
vRecurringJournalHistory
vRepetitiveInvoiceEntry
vRepetitiveInvoiceTaxDetail
vRepetitiveInvoiceTaxSummary
vReturnEntryTierDistribution
vReturnOfGoodsEntry
vReturnOfGoodsEntryMemo
vReturnOfGoodsEntryTaxDetail
vRMAReceiptsEntry
vRMAReceiptsHistory
vRMAReceiptsHistoryDetail
vRMAReceiptsHistoryMemo
vRMAReceiptsMemo
vRMAReturnEntry
vRMAReturnEntryDetail
vRMAReturnMemo
vRMAReturnReasonDetail
vSalesHistory
vSalesOrderEntry
vSalesOrderEntryMemo
vSalesOrderEntryPayment
vSalesOrderEntryTaxDetail
vSalesOrderHistory
vSalesOrderHistoryJobCost
vSalesOrderHistoryMemo
vSalesOrderHistoryPayment
vSalesOrderHistoryTaxDetail
vSalesOrderInvoiceEntry
vSalesOrderInvoicePayment
vSalesperson
vSalespersonCommissions
vSalespersonSalesHistory
vSalesTax
vSOInvoiceEntryPackageTracking
vSOInvoiceEntryTaxDetail
vSOInvoiceEntryTierDistribution
vSOLotAndSerialNumberHistory
vSOShipRateDetail
vSourceJournal
vSourceJournalHistory
vStandardJournal
vSubAccount
vTransactionEntry
vTransactionEntryTierDistribution
vTransactionJournalEntry
vTransactionJournalHistory
vTransactionPaymentHistory
vVendor
vVendor1099PaymentHistory
vVendorAudit
vVendorContacts
vVendorInvoiceHistory
vVendorInvoiceHistoryDetail
vVendorInvoiceHistoryMemo
vVendorInvoiceHistTaxSummary
vVendorInvoiceMemo
vVendorMemos
vVendorOpenInvoice
vVendorPurchasesHistory
vVendorRemitToAddresses
vVendorTermsCodes
vWorkOrder

*** COLUMNS - AR_Customer ***

ARDivisionNo,129,2,,,True
CustomerNo,129,20,,,True
CustomerName,129,50,,,True
AddressLine1,129,40,,,True
AddressLine2,129,40,,,True
AddressLine3,129,40,,,True
City,129,30,,,True
State,129,2,,,True
ZipCode,129,10,,,True
CountryCode,129,3,,,True
TelephoneNo,129,20,,,True
TelephoneExt,129,6,,,True
TelephoneType,129,1,,,True
FaxNo,129,20,,,True
EmailAddress,129,250,,,True
URLAddress,129,50,,,True
EBMEnabled,129,1,,,True
EBMConsumerUserID,129,15,,,True
BatchFax,129,1,,,True
DefaultCreditCardPmtType,129,5,,,True
ContactCode,129,10,,,True
ShipMethod,129,15,,,True
TaxSchedule,129,9,,,True
TaxExemptNo,129,15,,,True
TermsCode,129,2,,,True
SalespersonDivisionNo,129,2,,,True
SalespersonNo,129,4,,,True
SalespersonDivisionNo2,129,2,,,True
SalespersonNo2,129,4,,,True
SalespersonDivisionNo3,129,2,,,True
SalespersonNo3,129,4,,,True
SalespersonDivisionNo4,129,2,,,True
SalespersonNo4,129,4,,,True
SalespersonDivisionNo5,129,2,,,True
SalespersonNo5,129,4,,,True
Comment,129,30,,,True
SortField,129,10,,,True
TemporaryCustomer,129,1,,,True
CustomerStatus,129,1,,,True
InactiveReasonCode,129,5,,,True
OpenItemCustomer,129,1,,,True
ResidentialAddress,129,1,,,True
StatementCycle,129,1,,,True
PrintDunningMessage,129,1,,,True
UseSageCloudForInvPrinting,129,1,,,True
CustomerType,129,4,,,True
PriceLevel,129,1,,,True
DateLastActivity,133,,,,True
DateLastPayment,133,,,,True
DateLastStatement,133,,,,True
DateLastFinanceChrg,133,,,,True
DateLastAging,133,,,,True
DefaultItemCode,129,30,,,True
DefaultCostCode,129,9,,,True
DefaultCostType,129,1,,,True
CreditHold,129,1,,,True
PrimaryShipToCode,129,4,,,True
DateEstablished,133,,,,True
CreditCardGUID,129,32,,,True
DefaultPaymentType,129,5,,,True
EInvoicePayments,129,1,,,True
EInvoiceContactId,129,24,,,True
EmailStatements,129,1,,,True
PIIEncryptedDate,133,,,,True
NumberOfInvToUseInCalc,131,,2,0,True
AvgDaysPaymentInvoice,131,,3,0,True
AvgDaysOverDue,131,,3,0,True
CustomerDiscountRate,131,,12,3,True
ServiceChargeRate,131,,12,3,True
CreditLimit,131,,13,2,True
LastPaymentAmt,131,,13,2,True
HighestStmntBalance,131,,13,2,True
UnpaidServiceChrg,131,,13,2,True
BalanceForward,131,,13,2,True
CurrentBalance,131,,13,2,True
AgingCategory1,131,,13,2,True
AgingCategory2,131,,13,2,True
AgingCategory3,131,,13,2,True
AgingCategory4,131,,13,2,True
OpenOrderAmt,131,,13,2,True
RetentionCurrent,131,,13,2,True
RetentionAging1,131,,13,2,True
RetentionAging2,131,,13,2,True
RetentionAging3,131,,13,2,True
RetentionAging4,131,,13,2,True
SplitCommRate2,131,,8,3,True
SplitCommRate3,131,,8,3,True
SplitCommRate4,131,,8,3,True
SplitCommRate5,131,,8,3,True
EncryptedVals,129,1152,,,True
DateCreated,133,,,,True
TimeCreated,129,8,,,True
UserCreatedKey,129,10,,,True
DateUpdated,133,,,,True
TimeUpdated,129,8,,,True
UserUpdatedKey,129,10,,,True

*** KEYS - AR_Customer ***

ARDivisionNo,KEY0
CustomerNo,KEY0
CustomerName,KEY1
ARDivisionNo,KEY1
CustomerNo,KEY1
SortField,KEY2
ARDivisionNo,KEY2
CustomerNo,KEY2
ARDivisionNo,KEY3
SalespersonNo,KEY3
CustomerNo,KEY3
CustomerType,KEY4
ARDivisionNo,KEY4
CustomerNo,KEY4
ZipCode,KEY5
ARDivisionNo,KEY5
CustomerNo,KEY5
TelephoneNo,KEY6
ARDivisionNo,KEY6
CustomerNo,KEY6
CustomerNo,KEY7
AddressLine1,KEY8
ARDivisionNo,KEY8
CustomerNo,KEY8
AddressLine2,KEY9
ARDivisionNo,KEY9
CustomerNo,KEY9
AddressLine3,KEY10
ARDivisionNo,KEY10
CustomerNo,KEY10