Revision [715]
This is an old revision of ProgramTableCrossReference made by PhilDaintree on 2007-11-07 01:21:09.
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
| Table start | New column | Another |
| New row | Next col | Another |
#
| |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 |