Revision [225]

This is an old revision of ProgramTableCrossReference made by DavidPratten on 2006-10-02 05:53:54.

 

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 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

Valid XHTML :: Valid CSS: :: Powered by WikkaWikiGet webERP Accounting & Business Management at SourceForge.net. Fast, secure and Free Open Source software downloads