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