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 |