Revision [1881]
This is an old revision of TableProgramCrossReference made by TurboPT on 2010-09-05 23:00:12.
DB Table | webERP Script | Action |
accountgroups | AccountGroups.php | Delete, Insert, Update |
accountgroups | api/api_glgroups.php | Insert |
accountgroups | COGSGLPostings.php | Insert |
accountgroups | includes/GetSalesTransGLCodes.inc | Insert |
accountgroups | SalesGLPostings.php | Insert |
accountgroups | Z_CreateCompany.php | Insert |
accountsections | AccountSections.php | Delete, Insert, Update |
accountsections | api/api_glsections.php | Insert |
areas | Areas.php | Delete, Insert, Update |
areas | api/api_salesareas.php | Insert |
audittrail | includes/ConnectDB_mysql.inc | Insert |
audittrail | includes/ConnectDB_mysqli.inc | Insert |
audittrail | includes/session.inc | Delete |
bankaccounts | BankAccounts.php | Delete, Insert, Update |
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 | Delete, Insert, Update |
bom | Stocks.php | Delete |
bom | Z_ChangeStockCode.php | Update |
bom | Z_CopyBOM.php | Insert |
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 |