Revision [1887]

This is an old revision of TableProgramCrossReference made by TurboPT on 2010-09-08 21:58:57.

 

DB Table

webERP Script

Action
accountgroupsAccountGroups.phpDelete, Insert, Update
accountgroupsapi/api_glgroups.phpInsert
accountgroupsCOGSGLPostings.phpInsert
accountgroupsincludes/GetSalesTransGLCodes.incInsert
accountgroupsSalesGLPostings.phpInsert
accountgroupsZ_CreateCompany.phpInsert
accountsectionsAccountSections.phpDelete, Insert, Update
accountsectionsapi/api_glsections.phpInsert
areasAreas.phpDelete, Insert, Update
areasapi/api_salesareas.phpInsert
audittrailincludes/ConnectDB_mysql.incInsert
audittrailincludes/ConnectDB_mysqli.incInsert
audittrailincludes/session.incDelete
bankaccountsBankAccounts.phpDelete, Insert, Update
banktransBankMatching.phpUpdate
banktransCustomerReceipt.phpInsert
banktransincludes/PDFPaymentRun_PymtFooter.phpInsert
banktransPaymentMethods.phpUpdate
banktransPayments.phpInsert
banktransZ_ReverseSuppPaymentRun.phpDelete
bomBOMs.phpDelete, Insert, Update
bomStocks.phpDelete
bomZ_ChangeStockCode.phpUpdate
bomZ_CopyBOM.phpInsert
chartdetailsapi/api_glaccounts.phpInsert
chartdetailsGLAccounts.phpDelete, Insert
chartdetailsGLBudgets.phpUpdate
chartdetailsincludes/DateFunctions.incInsert
chartdetailsincludes/GLPostings.incInsert, Update
chartdetailsZ_CreateChartDetails.phpInsert, Update
chartdetailsZ_RePostGLFromPeriod.phpUpdate
chartdetailsZ_UpdateChartDetailsBFwd.phpUpdate
chartmasterapi/api_glaccounts.phpInsert
chartmasterCOGSGLPostings.phpInsert
chartmasterGLAccounts.phpDelete, Insert, Update
chartmasterincludes/GetSalesTransGLCodes.incInsert
chartmasterSalesGLPostings.phpInsert
chartmasterZ_CreateCompany.phpInsert
cogsglpostingsCOGSGLPostings.phpDelete, Insert, Update
cogsglpostingsZ_CreateCompany.phpInsert
companiesCompanyPreferences.phpUpdate
companiesinstall/save.phpUpdate
companiesZ_CreateCompany.phpInsert
configCustomerTypes.phpUpdate
configincludes/ConnectDB_mysql.incUpdate
configincludes/ConnectDB_mysqli.incUpdate
configincludes/ConnectDB_postgres.incUpdate
configincludes/session.incUpdate
configSalesTypes.phpUpdate
configSystemParameters.phpUpdate
configZ_MakeNewCompany.phpUpdate
contractbomZ_ChangeStockCode.phpUpdate
contractsUnitsOfMeasure.phpUpdate
contractsZ_ChangeBranchCode.phpUpdate
contractsZ_ChangeCustomerCode.phpUpdate
currenciesCompanyPreferences.phpUpdate
currenciesCurrencies.phpDelete, Insert, Update
currenciesincludes/session.incUpdate
custallocnsCredit_Invoice.phpInsert
custallocnsCustomerAllocations.phpDelete
custbranchapi/api_branches.phpInsert, Update
custbranchConfirmDispatch_Invoice.phpUpdate
custbranchCustomerBranches.phpDelete, Insert, Update
custbranchgeocode.phpUpdate
custbranchZ_ChangeBranchCode.phpDelete, Insert
custbranchZ_ChangeCustomerCode.phpDelete, Insert
custcontactsAddCustomerContacts.phpDelete, Insert, Update
custcontactsCustomers.phpDelete, Update
custnotesAddCustomerNotes.phpDelete, Insert, Update
debtorsmasterapi/api_customers.phpInsert, Update
debtorsmasterCustEDISetup.phpUpdate
debtorsmasterCustomerReceipt.phpUpdate
debtorsmasterCustomers.phpDelete, Insert, Update
debtorsmasterZ_ChangeCustomerCode.phpDelete, Insert
debtortransapi/api_debtortransactions.phpInsert
debtortransConfirmDispatch_Invoice.phpInsert
debtortransCredit_Invoice.phpInsert, Update
debtortransCustomerAllocations.phpUpdate
debtortransCustomerReceipt.phpInsert
debtortransEDISendInvoices.phpUpdate
debtortransPrintCustStatements.phpUpdate
debtortransRecurringSalesOrdersProcess.phpInsert
debtortransSelectCreditItems.phpInsert
debtortransZ_ChangeBranchCode.phpUpdate
debtortransZ_ChangeCustomerCode.phpUpdate
debtortransZ_DeleteCreditNote.phpDelete
debtortransZ_DeleteInvoice.phpDelete
debtortransZ_DeleteSalesTransActions.phpDelete
debtortranstaxesConfirmDispatch_Invoice.phpInsert
debtortranstaxesCredit_Invoice.phpInsert
debtortranstaxesRecurringSalesOrdersProcess.phpInsert
debtortranstaxesSelectCreditItems.phpInsert
debtortranstaxesZ_DeleteSalesTransActions.phpDelete
debtortypeCustomerTypes.phpDelete, Insert, Update
debtortypenotesAddCustomerTypeNotes.phpDelete, Insert, Update
discountmatrixDiscountMatrix.phpDelete, Insert
edimessageformatEDIMessageFormat.phpDelete, Insert, Update
edi_orders_segsDB-script data insertedN/A
edi_orders_seg_groupsDB-script data insertedN/A
factorcompaniesFactors.phpDelete, Insert, Update
freightcostsFreightCosts.phpDelete, Insert
geocode_paramGeocodeSetup.phpDelete, Insert, Update
gltransapi/api_debtortransactions.phpInsert
gltransapi/api_stock.phpInsert
gltransapi/api_workorders.phpInsert
gltransBankReconciliation.phpInsert
gltransConfirmDispatch_Invoice.phpInsert
gltransCredit_Invoice.phpInsert
gltransCustomerAllocations.phpInsert
gltransCustomerReceipt.phpInsert
gltransGLJournal.phpInsert
gltransGoodsReceived.phpInsert
gltransincludes/GLPostings.incUpdate
gltransincludes/PDFPaymentRun_PymtFooter.phpInsert
gltransincludes/SQL_CommonFunctions.incInsert
gltransPayments.phpInsert
gltransPDFStockCheckComparison.phpInsert
gltransRecurringSalesOrdersProcess.phpInsert
gltransReverseGRN.phpInsert
gltransSelectCreditItems.phpInsert
gltransShipmentCosting.phpInsert
gltransStockAdjustments.phpInsert
gltransSupplierAllocations.phpInsert
gltransSupplierCredit.phpInsert
gltransSupplierInvoice.phpInsert
gltransWorkOrderCosting.phpInsert
gltransWorkOrderIssue.phpInsert
gltransWorkOrderReceive.phpInsert
gltransZ_DeleteInvoice.phpDelete
gltransZ_DeleteSalesTransActions.phpDelete
gltransZ_RePostGLFromPeriod.phpUpdate
gltransZ_ReverseSuppPaymentRun.phpDelete
grnsGoodsReceived.phpInsert
grnsReverseGRN.phpUpdate
grnsSupplierCredit.phpUpdate
grnsSupplierInvoice.phpUpdate
grnsZ_ChangeStockCode.phpUpdate
grnsZ_DeleteSalesTransActions.phpDelete
grnsZ_PurgePeriods.phpDelete
holdreasonsCreditStatus.phpInsert, Update, Delete
locationsapi/api_locations.phpInsert, Update
locationsLocations.phpInsert, Update, Delete
locstockapi/api_stock.phpInsert, Update
locstockapi/api_workorders.phpUpdate
locstockConfirmDispatch_Invoice.phpUpdate
locstockCredit_Invoice.phpUpdate
locstockGoodsReceived.phpUpdate
locstockLocations.phpInsert, Delete
locstockPDFStockCheckComparison.phpUpdate
locstockReverseGRN.phpUpdate
locstockSelectCreditItems.phpUpdate
locstockSpecialOrder.phpInsert
locstockStockAdjustments.phpUpdate
locstockStockLocTransferReceive.phpUpdate
locstockStockReorderLevel.phpUpdate
locstockStocks.phpInsert, Delete
locstockStockTransfers.phpUpdate
locstockWorkOrderIssue.phpUpdate
locstockWorkOrderReceive.phpUpdate
locstockZ_ChangeStockCode.phpUpdate
locstockZ_CopyBOM.phpInsert
locstockZ_DeleteCreditNote.phpUpdate
locstockZ_DeleteSalesTransActions.phpUpdate
locstockZ_ImportStocks.phpInsert
locstockZ_MakeStockLocns.phpInsert
loctransfersStockLocTransfer.phpInsert
loctransfersStockLocTransferReceive.phpUpdate
loctransfersZ_ChangeStockCode.phpUpdate
mrpcalendarMRPCalendar.phpInsert, Update
mrpdemandsMRPCreateDemands.phpInsert
mrpdemandsMRPDemands.phpDelete, Insert, Update
mrpdemandsZ_ChangeStockCode.phpUpdate
mrpdemandtypesMRPDemandTypes.phpDelete, Insert, Update
orderdeliverydifferenceslogConfirmDispatch_Invoice.phpInsert
orderdeliverydifferenceslogZ_ChangeBranchCode.phpUpdate
orderdeliverydifferenceslogZ_ChangeCustomerCode.phpUpdate
orderdeliverydifferenceslogZ_ChangeStockCode.phpUpdate
orderdeliverydifferenceslogZ_DeleteInvoice.phpDelete
orderdeliverydifferenceslogZ_DeleteSalesTransActions.phpDelete
paymentmethodsPaymentMethods.phpInsert, Update, Delete
paymenttermsPaymentTerms.phpInsert, Update, Delete
periodsincludes\DateFunctions.incInsert
periodsincludes\GLPostings.incInsert
pricesPrices.phpInsert, Update, Delete
pricesPrices_Customer.phpInsert, Update, Delete
pricesSalesTypes.phpDelete
pricesZ_ChangeBranchCode.phpUpdate
pricesZ_ChangeCustomerCode.phpUpdate
pricesZ_ChangeStockCode.phpUpdate
pricesZ_PriceChanges.phpUpdate
purchdataPurchData.phpInsert, Update, Delete
purchdataStocks.phpDelete
purchdataZ_ChangeStockCode.phpUpdate
purchorderdetailsGoodsReceived.phpUpdate
purchorderdetailsincludes\DefineShiptClass.phpUpdate
purchorderdetailsPO_Header.phpDelete
purchorderdetailsPO_Items.phpInsert, Update, Delete
purchorderdetailsReverseGRN.phpUpdate
purchorderdetailsShipments.phpUpdate
purchorderdetailsSpecialOrder.phpInsert
purchorderdetailsSupplierCredit.phpUpdate
purchorderdetailsSupplierInvoice.phpUpdate
purchorderdetailsZ_ChangeStockCode.phpUpdate
purchorderdetailsZ_DeleteSalesTransActions.phpUpdate, Delete
purchorderdetailsZ_PurgePeriods.phpUpdate, Delete
purchordersPO_Header.phpUpdate, Delete
purchordersPO_Items.phpInsert, Update
purchordersPO_PDFPurchOrder.phpUpdate
purchordersSpecialOrder.phpInsert
purchordersZ_DeleteSalesTransActions.phpDelete
purchordersZ_PurgePeriods.phpDelete
recurringsalesordersRecurringSalesOrders.phpInsert, Update, Delete
recurringsalesordersRecurringSalesOrdersProcess.phpUpdate
recurrsalesorderdetailsRecurringSalesOrders.phpInsert, Delete
reportcolumnsSalesAnalReptCols.phpInsert, Update, Delete
reportcolumnsSalesAnalRepts.phpDelete
reportheadersSalesAnalRepts.phpInsert, Update, Delete
salesanalysisConfirmDispatch_Invoice.phpInsert, Update
salesanalysisCredit_Invoice.phpUpdate
salesanalysisRecurringSalesOrdersProcess.phpInsert, Update
salesanalysisSelectCreditItems.phpUpdate
salesanalysisZ_ChangeBranchCode.phpUpdate
salesanalysisZ_ChangeCustomerCode.phpUpdate
salesanalysisZ_ChangeStockCode.phpUpdate
salesanalysisZ_DeleteCreditNote.phpDelete
salesanalysisZ_DeleteInvoice.phpDelete
salesanalysisZ_PurgePeriods.phpDelete
salesanalysisZ_ReApplyCostToSA.phpUpdate
salescatSalesCategories.phpInsert, Update, Delete
salescatprodSalesCategories.phpInsert, Delete
salesglpostingsSalesGLPostings.phpInsert, Update, Delete
salesglpostingsZ_CreateCompany.phpInsert
salesmanSalesPeople.phpInsert, Update, Delete
salesorderdetailsConfirmDispatch_Invoice.phpUpdate
salesorderdetailsCredit_Invoice.phpUpdate
salesorderdetailsDeliveryDetails.phpInsert, Update
salesorderdetailsincludes\DefineCartClass.phpInsert, Delete
salesorderdetailsRecurringSalesOrdersProcess.phpInsert, Update
salesorderdetailsSelectOrderItems.phpDelete
salesorderdetailsSpecialOrder.phpInsert
salesorderdetailsZ_ChangeStockCode.phpUpdate
salesorderdetailsZ_DeleteCreditNote.phpUpdate
salesorderdetailsZ_DeleteInvoice.phpUpdate
salesorderdetailsZ_DeleteSalesTransActions.phpUpdate, Delete
salesorderdetailsZ_PurgePeriods.phpUpdate, Delete
salesordersConfirmDispatch_Invoice.phpUpdate
salesordersDeliveryDetails.phpInsert, Update
salesordersFTP_RadioBeacon.phpUpdate
salesordersPrintCustOrder.phpUpdate
salesordersPrintCustOrder_generic.phpUpdate
salesordersRecurringSalesOrdersProcess.phpInsert, Update
salesordersSelectOrderItems.phpDelete
salesordersSpecialOrder.phpInsert
salesordersZ_ChangeBranchCode.phpUpdate
salesordersZ_ChangeCustomerCode.phpUpdate
salesordersZ_CreateCompany.phpInsert
salesordersZ_DeleteSalesTransActions.phpDelete
salesordersZ_PurgePeriods.phpDelete
salestypesSalesTypes.phpInsert, Update, Delete
securitygroupsWWW_Access.phpInsert, Delete
securityrolesWWW_Access.phpInsert, Update, Delete
shipmentchargesSupplierCredit.phpInsert
shipmentchargesSupplierInvoice.phpInsert
shipmentchargesZ_ChangeStockCode.phpUpdate
shipmentsShipments.phpInsert, Update
shippersShippers.phpInsert, Update, Delete
stockcategoryStockCategories.phpInsert, Update, Delete
stockcheckfreezeStockCheck.phpInsert
stockcheckfreezeZ_ChangeStockCode.phpUpdate
stockcountsStockCounts.phpInsert, Delete
stockcountsZ_ChangeStockCode.phpUpdate
stockmasterDiscountCategories.phpUpdate
stockmasterShipmentCosting.phpUpdate
stockmasterSpecialOrder.phpInsert
stockmasterStockCostUpdate.phpUpdate
stockmasterStocks.phpInsert, Update, Delete
stockmasterSupplierInvoice.phpUpdate
stockmasterUnitsOfMeasure.phpUpdate
stockmasterZ_ChangeStockCode.phpInsert, Delete
stockmovesConfirmDispatch_Invoice.phpInsert
stockmovesCredit_Invoice.phpInsert
stockmovesGoodsReceived.phpInsert
stockmovesPDFStockCheckComparison.phpInsert
stockmovesRecurringSalesOrdersProcess.phpInsert
stockmovesReverseGRN.phpInsert
stockmovesSelectCreditItems.phpInsert
stockmovesStockAdjustments.phpInsert
stockmovesStockLocTransferReceive.phpInsert
stockmovesStockTransfers.phpInsert
stockmovesZ_ChangeBranchCode.phpUpdate
stockmovesZ_ChangeCustomerCode.phpUpdate
stockmovesZ_ChangeStockCode.phpUpdate
stockmovesZ_DeleteCreditNote.phpDelete
stockmovesZ_DeleteInvoice.phpDelete
stockmovesZ_DeleteSalesTransActions.phpDelete
stockmovesZ_PurgePeriods.phpDelete
stockmovestaxesConfirmDispatch_Invoice.phpInsert
stockmovestaxesCredit_Invoice.phpInsert
stockmovestaxesRecurringSalesOrdersProcess.phpInsert
stockmovestaxesSelectCreditItems.phpInsert
stockmovestaxesZ_DeleteSalesTransActions.phpDelete
stockserialitemsConfirmDispatch_Invoice.phpUpdate
stockserialitemsCredit_Invoice.phpInsert, Update
stockserialitemsGoodsReceived.phpInsert, Update
stockserialitemsReverseGRN.phpUpdate
stockserialitemsSelectCreditItems.phpInsert, Update
stockserialitemsStockAdjustments.phpInsert, Update
stockserialitemsStockLocTransferReceive.phpInsert, Update
stockserialitemsStockTransfers.phpInsert, Update
stockserialitemsZ_ChangeStockCode.phpUpdate
stockserialmovesConfirmDispatch_Invoice.phpInsert
stockserialmovesCredit_Invoice.phpInsert
stockserialmovesGoodsReceived.phpInsert
stockserialmovesReverseGRN.phpInsert
stockserialmovesSelectCreditItems.phpInsert
stockserialmovesStockAdjustments.phpInsert
stockserialmovesStockLocTransferReceive.phpInsert
stockserialmovesStockTransfers.phpInsert
stockserialmovesZ_ChangeStockCode.phpUpdate
stockserialmovesZ_DeleteSalesTransActions.phpDelete
stockserialmovesZ_PurgePeriods.phpDelete
suppallocsincludes\PDFPaymentRun_PymtFooter.phpInsert
suppallocsSupplierAllocations.phpInsert, Delete
SuppAllocsZ_ReverseSuppPaymentRun.phpDelete
suppliercontactsSupplierContacts.phpInsert, Update, Delete
suppliersPayments.phpUpdate
suppliersSuppliers.phpInsert, Update, Delete
supptransincludes\PDFPaymentRun_PymtFooter.phpInsert
supptransPayments.phpInsert
supptransSupplierAllocations.phpUpdate
supptransSupplierCredit.phpInsert
supptransSupplierInquiry.phpUpdate
supptransSupplierInvoice.phpInsert
supptransSuppPaymentRun.phpUpdate
SuppTransZ_ReverseSuppPaymentRun.phpUpdate, Delete
supptranstaxesSupplierCredit.phpInsert
supptranstaxesSupplierInvoice.phpInsert
systypesincludes\SQL_CommonFunctions.incUpdate
systypesZ_DeleteSalesTransActions.phpUpdate
systypesZ_PurgePeriods.phpUpdate
taxauthoritiesTaxAuthorities.phpInsert, Update, Delete
taxauthratesLocations.phpInsert, Delete
taxauthratesTaxAuthorities.phpInsert, Delete
taxauthratesTaxAuthorityRates.phpUpdate
taxauthratesTaxCategories.phpInsert, Delete
taxauthratesTaxProvinces.phpInsert, Delete
taxcategoriesTaxCategories.phpInsert, Update, Delete
taxgroupsTaxGroups.phpInsert, Update, Delete
taxgrouptaxesTaxGroups.phpInsert, Update, Delete
taxprovincesTaxProvinces.phpInsert, Update, Delete
unitsofmeasureUnitsOfMeasure.phpInsert, Update, Delete
woissuesWorkOrderIssue.phpInsert
worequirementsWorkOrderEntry.phpInsert, Delete
workcentresWorkCentres.phpInsert, Update, Delete
worksordersWorkOrderEntry.phpInsert, Update, Delete
worksordersWorkOrderIssue.phpUpdate
www_usersincludes\session.incUpdate
www_usersUserSettings.phpUpdate
www_usersWWW_Users.phpInsert, Update, Delete
www_usersZ_ChangeBranchCode.phpUpdate
www_usersZ_ChangeCustomerCode.phpUpdate
Valid XHTML :: Valid CSS: :: Powered by WikkaWikiGet webERP Accounting & Business Management at SourceForge.net. Fast, secure and Free Open Source software downloads