Revision [717]
This is an old revision of ProgramTableCrossReference made by PhilDaintree on 2007-11-07 01:23:47.
Program-Table Cross Reference
For developers wanting to find starting points for development work, the following tables may be of interest. They were created by grepping the CVS source as at 1/Oct/2006.See also TableProgramCrossReference Table-Program Cross Reference
Program | Table | Operations |
~AccountGroups.php | accountgroups | Insert, Update, Delete |
~AccountSections.php | accountsection | Insert, Update, Delete |
~Areas.php | areas | Insert, Update, Delete |
~BankAccounts.php | bankaccounts | Insert, Update, Delete |
~BankMatching.php | banktrans | Update |
~BOMs.php | bom | Insert, Update, Delete |
~COGSGLPostings.php | accountgroups | Insert |
~COGSGLPostings.php | chartmaster | Insert |
~COGSGLPostings.php | cogsglpostings | Insert, Update, Delete |
~CompanyPreferences.php | companies | Update |
~ConfirmDispatch_Invoice.php | custbranch | Update |
~ConfirmDispatch_Invoice.php | debtortrans | Insert |
~ConfirmDispatch_Invoice.php|debtortranstaxes|Insert | ||
~ConfirmDispatch_Invoice.php|gltrans|Insert | ||
~ConfirmDispatch_Invoice.php|locstock|Update | ||
~ConfirmDispatch_Invoice.php|orderdeliverydifferenceslog|Insert | ||
~ConfirmDispatch_Invoice.php|salesanalysis|Insert, Update | ||
~ConfirmDispatch_Invoice.php|salesorderdetails|Update | ||
~ConfirmDispatch_Invoice.php|salesorders|Update | ||
~ConfirmDispatch_Invoice.php|stockmoves|Insert | ||
~ConfirmDispatch_Invoice.php|stockmovestaxes|Insert | ||
~ConfirmDispatch_Invoice.php|stockserialitems|Update | ||
~ConfirmDispatch_Invoice.php|stockserialmoves|Insert | ||
~Credit_Invoice.php|custallocns|Insert | ||
~Credit_Invoice.php|debtortrans|Insert, Update | ||
~Credit_Invoice.php|debtortranstaxes|Insert | ||
~Credit_Invoice.php|gltrans|Insert | ||
~Credit_Invoice.php|locstock|Update | ||
~Credit_Invoice.php|salesanalysis|Update | ||
~Credit_Invoice.php|salesorderdetails|Update | ||
~Credit_Invoice.php|stockmoves|Insert | ||
~Credit_Invoice.php|stockmovestaxes|Insert | ||
~Credit_Invoice.php|stockserialitems|Insert, Update | ||
~Credit_Invoice.php|stockserialmoves|Insert | ||
~CreditStatus.php|holdreasons|Insert, Update, Delete | ||
~Currencies.php|currencies|Insert, Update, Delete | ||
~CustEDISetup.php|debtorsmaster|Update | ||
~CustomerAllocations.php|custallocns|Insert, Delete | ||
~CustomerAllocations.php|debtortrans|Update | ||
~CustomerAllocations.php|gltrans|Insert | ||
~CustomerBranches.php|accountscf|Insert | ||
~CustomerBranches.php|crmentity|Insert, Update | ||
~CustomerBranches.php|crmentity_seq|Update | ||
~CustomerBranches.php|custbranch|Insert, Update, Delete | ||
~CustomerReceipt.php|banktrans|Insert | ||
~CustomerReceipt.php|debtorsmaster|Update | ||
~CustomerReceipt.php|debtortrans|Insert | ||
~CustomerReceipt.php|gltrans|Insert | ||
~Customers.php|debtorsmaster|Insert, Update, Delete | ||
~DeliveryDetails.php|salesorderdetails|Insert, Update | ||
~DeliveryDetails.php|salesorders|Insert, Update | ||
~DiscountCategories.php|stockmaster|Update | ||
~DiscountMatrix.php|discountmatrix|Insert, Delete | ||
~EDIMessageFormat.php|edimessageformat|Insert, Update, Delete | ||
~FreightCosts.php|freightcosts|Insert, Update, Delete | ||
~FTP_RadioBeacon.php|salesorders|Update | ||
~GLAccounts.php|chartdetails|Insert, Delete | ||
~GLAccounts.php|chartmaster|Insert, Update, Delete | ||
~GLJournal.php|gltrans|Insert | ||
~GoodsReceived.php|gltrans|Insert | ||
~GoodsReceived.php|grns|Insert | ||
~GoodsReceived.php|locstock|Update | ||
~GoodsReceived.php|purchorderdetails|Update | ||
~GoodsReceived.php|stockmoves|Insert | ||
~GoodsReceived.php|stockserialitems|Insert, Update | ||
~GoodsReceived.php|stockserialmoves|Insert | ||
~includes\DateFunctions.inc|chartdetails|Insert | ||
~includes\DateFunctions.inc|periods|Insert | ||
~includes\DefineCartClass.php|salesorderdetails|Insert, Delete | ||
~includes\DefineShiptClass.php|purchorderdetails|Update | ||
~includes\GetSalesTransGLCodes.inc|accountgroups|Insert | ||
~includes\GetSalesTransGLCodes.inc|chartmaster|Insert | ||
~includes\GLPostings.inc|chartdetails|Insert, Update | ||
~includes\GLPostings.inc|gltrans|Update | ||
~includes\GLPostings.inc|periods|Insert | ||
~includes\PDFPaymentRun_PymtFooter.php|banktrans|Insert | ||
~includes\PDFPaymentRun_PymtFooter.php|gltrans|Insert | ||
~includes\PDFPaymentRun_PymtFooter.php|suppallocs|Insert | ||
~includes\PDFPaymentRun_PymtFooter.php|supptrans|Insert | ||
~includes\session.inc|www_users|Update | ||
~includes\SQL_CommonFunctions.inc|systypes|Update | ||
~Locations.php|locations|Insert, Update, Delete | ||
~Locations.php|locstock|Insert, Delete | ||
~Locations.php|taxauthrates|Insert, Delete | ||
~PaymentMethods.php|banktrans|Update | ||
~PaymentMethods.php|paymentmethods|Insert, Update, Delete | ||
~Payments.php|banktrans|Insert | ||
~Payments.php|gltrans|Insert | ||
~Payments.php|suppliers|Update | ||
~Payments.php|supptrans|Insert | ||
~PaymentTerms.php|paymentterms|Insert, Update, Delete | ||
~PDFStockCheckComparison.php|gltrans|Insert | ||
~PDFStockCheckComparison.php|locstock|Update | ||
~PDFStockCheckComparison.php|stockmoves|Insert | ||
~PO_Header.php|purchorderdetails|Delete | ||
~PO_Header.php|purchorders|Update, Delete | ||
~PO_Items.php|purchorderdetails|Insert, Update, Delete | ||
~PO_Items.php|purchorders|Insert, Update | ||
~PO_PDFPurchOrder.php|purchorders|Update | ||
~Prices.php|prices|Insert, Update, Delete | ||
~Prices_Customer.php|prices|Insert, Update, Delete | ||
~PrintCustOrder.php|salesorders|Update | ||
~PrintCustOrder_generic.php|salesorders|Update | ||
~PrintCustStatements.php|debtortrans|Update | ||
~PurchData.php|purchdata|Insert, Update, Delete | ||
~RecurringSalesOrders.php|recurringsalesorders|Insert, Update, Delete | ||
~RecurringSalesOrders.php|recurrsalesorderdetails|Insert, Delete | ||
~RecurringSalesOrdersProcess.php|debtortrans|Insert | ||
~RecurringSalesOrdersProcess.php|debtortranstaxes|Insert | ||
~RecurringSalesOrdersProcess.php|gltrans|Insert | ||
~RecurringSalesOrdersProcess.php|recurringsalesorders|Update | ||
~RecurringSalesOrdersProcess.php|salesanalysis|Insert, Update | ||
~RecurringSalesOrdersProcess.php|salesorderdetails|Insert, Update | ||
~RecurringSalesOrdersProcess.php|salesorders|Insert, Update | ||
~RecurringSalesOrdersProcess.php|stockmoves|Insert | ||
~RecurringSalesOrdersProcess.php|stockmovestaxes|Insert | ||
~ReverseGRN.php|gltrans|Insert | ||
~ReverseGRN.php|grns|Update | ||
~ReverseGRN.php|locstock|Update | ||
~ReverseGRN.php|purchorderdetails|Update | ||
~ReverseGRN.php|stockmoves|Insert | ||
~ReverseGRN.php|stockserialitems|Update | ||
~ReverseGRN.php|stockserialmoves|Insert | ||
~SalesAnalReptCols.php|reportcolumns|Insert, Update, Delete | ||
~SalesAnalRepts.php|reportcolumns|Delete | ||
~SalesAnalRepts.php|reportheaders|Insert, Update, Delete | ||
~SalesCategories.php|salescat|Insert, Update, Delete | ||
~SalesCategories.php|salescatprod|Insert, Delete | ||
~SalesGLPostings.php|accountgroups|Insert | ||
~SalesGLPostings.php|chartmaster|Insert | ||
~SalesGLPostings.php|salesglpostings|Insert, Update, Delete | ||
~SalesPeople.php|salesman|Insert, Update, Delete | ||
~SalesTypes.php|prices|Delete | ||
~SalesTypes.php|salestypes|Insert, Update, Delete | ||
~SelectCreditItems.php|debtortrans|Insert | ||
~SelectCreditItems.php|debtortranstaxes|Insert | ||
~SelectCreditItems.php|gltrans|Insert | ||
~SelectCreditItems.php|locstock|Update | ||
~SelectCreditItems.php|salesanalysis|Update | ||
~SelectCreditItems.php|stockmoves|Insert | ||
~SelectCreditItems.php|stockmovestaxes|Insert | ||
~SelectCreditItems.php|stockserialitems|Insert, Update | ||
~SelectCreditItems.php|stockserialmoves|Insert | ||
~SelectOrderItems.php|salesorderdetails|Delete | ||
~SelectOrderItems.php|salesorders|Delete | ||
~ShipmentCosting.php|gltrans|Insert | ||
~ShipmentCosting.php|stockmaster|Update | ||
~Shipments.php|purchorderdetails|Update | ||
~Shipments.php|shipments|Insert, Update | ||
~Shippers.php|shippers|Insert, Update, Delete | ||
~SpecialOrder.php|locstock|Insert | ||
~SpecialOrder.php|purchorderdetails|Insert | ||
~SpecialOrder.php|purchorders|Insert | ||
~SpecialOrder.php|salesorderdetails|Insert | ||
~SpecialOrder.php|salesorders|Insert | ||
~SpecialOrder.php|stockmaster|Insert | ||
~StockAdjustments.php|gltrans|Insert | ||
~StockAdjustments.php|locstock|Update | ||
~StockAdjustments.php|stockmoves|Insert | ||
~StockAdjustments.php|stockserialitems|Insert, Update | ||
~StockAdjustments.php|stockserialmoves|Insert | ||
~StockCategories.php|stockcategory|Insert, Update, Delete | ||
~StockCheck.php|stockcheckfreeze|Insert | ||
~StockCostUpdate.php|gltrans|Insert | ||
~StockCostUpdate.php|stockmaster|Update | ||
~StockCounts.php|stockcounts|Insert, Delete | ||
~StockLocTransfer.php|loctransfers|Insert | ||
~StockLocTransferReceive.php|locstock|Update | ||
~StockLocTransferReceive.php|loctransfers|Update | ||
~StockLocTransferReceive.php|stockmoves|Insert | ||
~StockLocTransferReceive.php|stockserialitems|Insert, Update | ||
~StockLocTransferReceive.php|stockserialmoves|Insert | ||
~StockReorderLevel.php|locstock|Update | ||
~Stocks.php|bom|Delete | ||
~Stocks.php|locstock|Insert, Delete | ||
~Stocks.php|purchdata|Delete | ||
~Stocks.php|stockmaster|Insert, Update, Delete | ||
~StockTransfers.php|locstock|Update | ||
~StockTransfers.php|stockmoves|Insert | ||
~StockTransfers.php|stockserialitems|Insert, Update | ||
~StockTransfers.php|stockserialmoves|Insert | ||
~SupplierAllocations.php|gltrans|Insert | ||
~SupplierAllocations.php|suppallocs|Insert, Delete | ||
~SupplierAllocations.php|supptrans|Update | ||
~SupplierContacts.php|suppliercontacts|Insert, Update, Delete | ||
~SupplierCredit.php|gltrans|Insert | ||
~SupplierCredit.php|grns|Update | ||
~SupplierCredit.php|purchorderdetails|Update | ||
~SupplierCredit.php|shipmentcharges|Insert | ||
~SupplierCredit.php|supptrans|Insert | ||
~SupplierCredit.php|supptranstaxes|Insert | ||
~SupplierInquiry.php|supptrans|Update | ||
~SupplierInvoice.php|gltrans|Insert | ||
~SupplierInvoice.php|grns|Update | ||
~SupplierInvoice.php|purchorderdetails|Update | ||
~SupplierInvoice.php|shipmentcharges|Insert | ||
~SupplierInvoice.php|stockmaster|Update | ||
~SupplierInvoice.php|supptrans|Insert | ||
~SupplierInvoice.php|supptranstaxes|Insert | ||
~Suppliers.php|suppliers|Insert, Update, Delete | ||
~SuppPaymentRun.php|supptrans|Update | ||
~SystemParameters.php|config|Update | ||
~TaxAuthorities.php|taxauthorities|Insert, Update, Delete | ||
~TaxAuthorities.php|taxauthrates|Insert, Delete | ||
~TaxAuthorityRates.php|taxauthrates|Update | ||
~TaxCategories.php|taxauthrates|Insert, Delete | ||
~TaxCategories.php|taxcategories|Insert, Update, Delete | ||
~TaxGroups.php|taxgroups|Insert, Update, Delete | ||
~TaxGroups.php|taxgrouptaxes|Insert, Update, Delete | ||
~TaxProvinces.php|taxauthrates|Insert, Delete | ||
~TaxProvinces.php|taxprovinces|Insert, Update, Delete | ||
~UnitsOfMeasure.php|contracts|Update | ||
~UnitsOfMeasure.php|stockmaster|Update | ||
~UnitsOfMeasure.php|unitsofmeasure|Insert, Update, Delete | ||
~UserSettings.php|www_users|Update | ||
~WorkCentres.php|workcentres|Insert, Update, Delete | ||
~WorkOrderEntry.php|worequirements|Insert, Delete | ||
~WorkOrderEntry.php|worksorders|Insert, Update, Delete | ||
~WorkOrderIssue.php|woissues|Insert | ||
~WorkOrderIssue.php|worksorders|Update | ||
~WWW_Access.php|securitygroups|Insert, Delete | ||
~WWW_Access.php|securityroles|Insert, Update, Delete | ||
~WWW_Users.php|www_users|Insert, Update, Delete | ||
~Z_ChangeBranchCode.php|contracts|Update | ||
~Z_ChangeBranchCode.php|custbranch|Insert, Delete | ||
~Z_ChangeBranchCode.php|debtortrans|Update | ||
~Z_ChangeBranchCode.php|orderdeliverydifferenceslog|Update | ||
~Z_ChangeBranchCode.php|prices|Update | ||
~Z_ChangeBranchCode.php|salesanalysis|Update | ||
~Z_ChangeBranchCode.php|salesorders|Update | ||
~Z_ChangeBranchCode.php|stockmoves|Update | ||
~Z_ChangeBranchCode.php|www_users|Update | ||
~Z_ChangeCustomerCode.php|contracts|Update | ||
~Z_ChangeCustomerCode.php|custbranch|Insert, Delete | ||
~Z_ChangeCustomerCode.php|debtorsmaster|Insert, Delete | ||
~Z_ChangeCustomerCode.php|debtortrans|Update | ||
~Z_ChangeCustomerCode.php|orderdeliverydifferenceslog|Update | ||
~Z_ChangeCustomerCode.php|prices|Update | ||
~Z_ChangeCustomerCode.php|salesanalysis|Update | ||
~Z_ChangeCustomerCode.php|salesorders|Update | ||
~Z_ChangeCustomerCode.php|stockmoves|Update | ||
~Z_ChangeCustomerCode.php|www_users|Update | ||
~Z_ChangeStockCode.php|bom|Update | ||
~Z_ChangeStockCode.php|contractbom|Update | ||
~Z_ChangeStockCode.php|grns|Update | ||
~Z_ChangeStockCode.php|locstock|Update | ||
~Z_ChangeStockCode.php|orderdeliverydifferenceslog|Update | ||
~Z_ChangeStockCode.php|prices|Update | ||
~Z_ChangeStockCode.php|purchdata|Update | ||
~Z_ChangeStockCode.php|purchorderdetails|Update | ||
~Z_ChangeStockCode.php|salesanalysis|Update | ||
~Z_ChangeStockCode.php|salesorderdetails|Update | ||
~Z_ChangeStockCode.php|shipmentcharges|Update | ||
~Z_ChangeStockCode.php|stockcheckfreeze|Update | ||
~Z_ChangeStockCode.php|stockcounts|Update | ||
~Z_ChangeStockCode.php|stockmaster|Insert, Delete | ||
~Z_ChangeStockCode.php|stockmoves|Update | ||
~Z_ChangeStockCode.php|stockserialitems|Update | ||
~Z_ChangeStockCode.php|stockserialmoves|Update | ||
~Z_CreateChartDetails.php|chartdetails|Insert, Update | ||
~Z_CreateCompany.php|accountgroups|Insert | ||
~Z_CreateCompany.php|chartmaster|Insert | ||
~Z_CreateCompany.php|cogsglpostings|Insert | ||
~Z_CreateCompany.php|companies|Insert | ||
~Z_CreateCompany.php|salesglpostings|Insert | ||
~Z_CreateCompany.php|salesorders|Insert | ||
~Z_DeleteCreditNote.php|debtortrans|Delete | ||
~Z_DeleteCreditNote.php|locstock|Update | ||
~Z_DeleteCreditNote.php|salesanalysis|Delete | ||
~Z_DeleteCreditNote.php|salesorderdetails|Update | ||
~Z_DeleteCreditNote.php|stockmoves|Delete | ||
~Z_DeleteInvoice.php|debtortrans|Delete | ||
~Z_DeleteInvoice.php|orderdeliverydifferenceslog|Delete | ||
~Z_DeleteInvoice.php|salesanalysis|Delete | ||
~Z_DeleteInvoice.php|salesorderdetails|Update | ||
~Z_DeleteInvoice.php|stockmoves|Delete | ||
~Z_DeleteSalesTransActions.php|debtortrans|Delete | ||
~Z_DeleteSalesTransActions.php|debtortranstaxes|Delete | ||
~Z_DeleteSalesTransActions.php|gltrans|Delete | ||
~Z_DeleteSalesTransActions.php|grns|Delete | ||
~Z_DeleteSalesTransActions.php|locstock|Update | ||
~Z_DeleteSalesTransActions.php|orderdeliverydifferenceslog|Delete | ||
~Z_DeleteSalesTransActions.php|purchorderdetails|Update, Delete | ||
~Z_DeleteSalesTransActions.php|purchorders|Delete | ||
~Z_DeleteSalesTransActions.php|salesorderdetails|Update, Delete | ||
~Z_DeleteSalesTransActions.php|salesorders|Delete | ||
~Z_DeleteSalesTransActions.php|stockmoves|Delete | ||
~Z_DeleteSalesTransActions.php|stockmovestaxes|Delete | ||
~Z_DeleteSalesTransActions.php|stockserialmoves|Delete | ||
~Z_DeleteSalesTransActions.php|systypes|Update | ||
~Z_MakeStockLocns.php|locstock|Insert | ||
~Z_PriceChanges.php|prices|Update | ||
~Z_PurgePeriods.php|custallocns|Delete | ||
~Z_PurgePeriods.php|debtortrans|Delete | ||
~Z_PurgePeriods.php|gltrans|Delete | ||
~Z_PurgePeriods.php|grns|Delete | ||
~Z_PurgePeriods.php|locstock|Update | ||
~Z_PurgePeriods.php|orderdeliverydifferenceslog|Delete | ||
~Z_PurgePeriods.php|purchorderdetails|Update, Delete | ||
~Z_PurgePeriods.php|purchorders|Delete | ||
~Z_PurgePeriods.php|salesanalysis|Delete | ||
~Z_PurgePeriods.php|salesorderdetails|Update, Delete | ||
~Z_PurgePeriods.php|salesorders|Delete | ||
~Z_PurgePeriods.php|stockmoves|Delete | ||
~Z_PurgePeriods.php|stockserialmoves|Delete | ||
~Z_PurgePeriods.php|systypes|Update | ||
~Z_ReApplyCostToSA.php|salesanalysis|Update | ||
~Z_RePostGLFromPeriod.php|chartdetails|Update | ||
~Z_RePostGLFromPeriod.php|gltrans|Update | ||
~Z_ReverseSuppPaymentRun.php|BankTrans|Delete | ||
~Z_ReverseSuppPaymentRun.php|GLTrans|Delete | ||
~Z_ReverseSuppPaymentRun.php|SuppAllocs|Delete | ||
~Z_ReverseSuppPaymentRun.php|SuppTrans|Update, Delete | ||
~Z_UpdateChartDetailsBFwd.php|chartdetails|Update |