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
pricesapi/api_stock.phpInsert, Update
pricesPrices.phpInsert, Update, Delete
pricesPricesBasedOnMarkUp.phpInsert, Update
pricesPrices_Customer.phpInsert, Update, Delete
pricesSalesTypes.phpDelete
pricesStocks.phpDelete
pricesZ_ChangeBranchCode.phpUpdate
pricesZ_ChangeCustomerCode.phpUpdate
pricesZ_ChangeStockCode.phpUpdate
pricesZ_PriceChanges.phpUpdate
purchdataapi/api_purchdata.phpInsert, Update
purchdataPurchData.phpInsert, Update, Delete
purchdataStocks.phpDelete
purchdataZ_ChangeStockCode.phpUpdate
purchorderauthPO_AuthorisationLevels.phpDelete, Insert, Update
purchorderdetailsGoodsReceived.phpUpdate
purchorderdetailsincludes\DefineShiptClass.phpUpdate
purchorderdetailsPO_Header.phpUpdate
purchorderdetailsPO_Items.phpInsert, Update, Delete
purchorderdetailsReverseGRN.phpUpdate
purchorderdetailsShipmentCosting.phpUpdate
purchorderdetailsShipments.phpUpdate
purchorderdetailsSpecialOrder.phpInsert
purchorderdetailsSupplierCredit.phpUpdate
purchorderdetailsSupplierInvoice.phpUpdate
purchorderdetailsZ_ChangeStockCode.phpUpdate
purchorderdetailsZ_DeleteSalesTransActions.phpUpdate, Delete
purchordersGoodsReceived.phpUpdate
purchordersPO_Header.phpUpdate, Delete
purchordersPO_Items.phpInsert, Update
purchordersPO_PDFPurchOrder.phpUpdate
purchordersSpecialOrder.phpInsert
purchordersZ_DeleteSalesTransActions.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.phpInsert, Update
salesanalysisRecurringSalesOrdersProcess.phpInsert, Update
salesanalysisSelectCreditItems.phpUpdate
salesanalysisZ_ChangeBranchCode.phpUpdate
salesanalysisZ_ChangeCustomerCode.phpUpdate
salesanalysisZ_ChangeStockCode.phpUpdate
salesanalysisZ_DeleteCreditNote.phpDelete
salesanalysisZ_DeleteInvoice.phpDelete
salesanalysisZ_ReApplyCostToSA.phpUpdate
salescatSalesCategories.phpInsert, Update, Delete
salescatprodSalesCategories.phpInsert, Delete
salesglpostingsSalesGLPostings.phpInsert, Update, Delete
salesglpostingsZ_CreateCompany.phpInsert
salesmanapi/api_salesman.phpInsert
salesmanSalesPeople.phpInsert, Update, Delete
salesorderdetailsapi/api_salesorders.phpInsert, Update
salesorderdetailsConfirmDispatch_Invoice.phpUpdate
salesorderdetailsCredit_Invoice.phpUpdate
salesorderdetailsDeliveryDetails.phpInsert, Update
SalesOrderDetailsGoodsReceived.phpUpdate
salesorderdetailsincludes/DefineCartClass.phpInsert, Delete, Update
salesorderdetailsRecurringSalesOrdersProcess.phpInsert, Update
salesorderdetailsSelectOrderItems.phpDelete
salesorderdetailsSpecialOrder.phpInsert
salesorderdetailsZ_ChangeStockCode.phpUpdate
salesorderdetailsZ_DeleteCreditNote.phpUpdate
salesorderdetailsZ_DeleteInvoice.phpUpdate
salesorderdetailsZ_DeleteSalesTransActions.phpUpdate, Delete
salesordersapi/api_salesorders.phpInsert, Update
salesordersConfirmDispatch_Invoice.phpUpdate
salesordersDeliveryDetails.phpInsert, Update
salesordersFTP_RadioBeacon.phpUpdate
salesordersPrintCustOrder.phpUpdate
salesordersPrintCustOrder_generic.phpUpdate
salesordersPrintSalesOrder_generic.phpUpdate
salesordersRecurringSalesOrdersProcess.phpInsert, Update
salesordersSelectOrderItems.phpDelete
salesordersSpecialOrder.phpInsert
salesordersZ_ChangeBranchCode.phpUpdate
salesordersZ_ChangeCustomerCode.phpUpdate
salesordersZ_CreateCompany.phpInsert
salesordersZ_DeleteSalesTransActions.phpDelete
salestypesapi/api_salestypes.phpInsert
salestypesSalesTypes.phpInsert, Update, Delete
securitygroupsWWW_Access.phpInsert, Delete
securityrolesWWW_Access.phpInsert, Update, Delete
shipmentchargesSupplierCredit.phpInsert
shipmentchargesSupplierInvoice.phpInsert
shipmentchargesZ_ChangeStockCode.phpUpdate
shipmentsShipmentCosting.phpUpdate
shipmentsShipments.phpInsert, Update
shippersShippers.phpInsert, Update, Delete
stockcategoryapi/api_stockcategories.phpInsert, Update
stockcategoryStockCategories.phpInsert, Update, Delete
stockcatpropertiesStockCategories.phpDelete, Insert, Update
stockcheckfreezeStockCheck.phpInsert
stockcheckfreezeZ_ChangeStockCode.phpUpdate
stockcountsStockCounts.phpInsert, Delete
stockcountsZ_ChangeStockCode.phpUpdate
stockitempropertiesStockCategories.phpDelete
stockitempropertiesStocks.phpDelete, Insert
stockitempropertiesZ_ChangeStockCode.phpUpdate
stockmasterapi/api_stock.phpInsert, Update
stockmasterDeliveryDetails.phpUpdate
stockmasterDiscountCategories.phpUpdate
stockmasterincludes/SQL_CommonFunctions.incUpdate
stockmasterShipmentCosting.phpUpdate
stockmasterSpecialOrder.phpInsert
stockmasterStockCostUpdate.phpUpdate
stockmasterStocks.phpInsert, Update, Delete
stockmasterSupplierInvoice.phpUpdate
stockmasterUnitsOfMeasure.phpUpdate
stockmasterWorkOrderCosting.phpUpdate
stockmasterWorkOrderReceive.phpUpdate
stockmasterWOSerialNos.phpUpdate
stockmasterZ_ChangeStockCode.phpInsert, Delete
stockmasterZ_CopyBOM.phpInsert, Update
stockmasterZ_ImportStocks.phpInsert
stockmovesapi/api_stock.phpInsert
stockmovesapi/api_workorders.phpInsert
stockmovesConfirmDispatch_Invoice.phpInsert
stockmovesCredit_Invoice.phpInsert
stockmovesGoodsReceived.phpInsert
stockmovesPDFStockCheckComparison.phpInsert
stockmovesRecurringSalesOrdersProcess.phpInsert
stockmovesReverseGRN.phpInsert
stockmovesSelectCreditItems.phpInsert
stockmovesStockAdjustments.phpInsert
stockmovesStockLocTransferReceive.phpInsert
stockmovesStockTransfers.phpInsert
stockmovesWorkOrderIssue.phpInsert
stockmovesWorkOrderReceive.phpInsert
stockmovesZ_ChangeBranchCode.phpUpdate
stockmovesZ_ChangeCustomerCode.phpUpdate
stockmovesZ_ChangeStockCode.phpUpdate
stockmovesZ_DeleteCreditNote.phpDelete
stockmovesZ_DeleteInvoice.phpDelete
stockmovesZ_DeleteSalesTransActions.phpDelete
stockmovestaxesConfirmDispatch_Invoice.phpInsert
stockmovestaxesCredit_Invoice.phpInsert
stockmovestaxesRecurringSalesOrdersProcess.phpInsert
stockmovestaxesSelectCreditItems.phpInsert
stockmovestaxesZ_DeleteSalesTransActions.phpDelete
stockserialitemsapi/api_workorders.phpUpdate
stockserialitemsConfirmDispatch_Invoice.phpUpdate
stockserialitemsCredit_Invoice.phpInsert, Update
stockserialitemsGoodsReceived.phpInsert, Update
stockserialitemsReverseGRN.phpUpdate
stockserialitemsSelectCreditItems.phpInsert, Update
stockserialitemsStockAdjustments.phpInsert, Update
stockserialitemsStockLocTransferReceive.phpInsert, Update
stockserialitemsStockTransfers.phpInsert, Update
stockserialitemsWorkOrderIssue.phpInsert, Update
stockserialitemsWorkOrderReceive.phpInsert, Update
stockserialitemsZ_ChangeStockCode.phpUpdate
stockserialmovesConfirmDispatch_Invoice.phpInsert
stockserialmovesCredit_Invoice.phpInsert
stockserialmovesGoodsReceived.phpInsert
stockserialmovesReverseGRN.phpInsert
stockserialmovesSelectCreditItems.phpInsert
stockserialmovesStockAdjustments.phpInsert
stockserialmovesStockLocTransferReceive.phpInsert
stockserialmovesStockTransfers.phpInsert
stockserialmovesWorkOrderIssue.phpInsert
stockserialmovesWorkOrderReceive.phpInsert
stockserialmovesZ_ChangeStockCode.phpUpdate
stockserialmovesZ_DeleteSalesTransActions.phpDelete
suppallocsincludes\PDFPaymentRun_PymtFooter.phpInsert
suppallocsSupplierAllocations.phpInsert, Delete
SuppAllocsZ_ReverseSuppPaymentRun.phpDelete
suppliercontactsSupplierContacts.phpInsert, Update, Delete
suppliersapi/api_suppliers.phpInsert, Update
suppliersgeocode.phpUpdate
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
systypesapi/api_debtortransactions.phpUpdate
systypesapi/api_stock.phpUpdate
systypesapi/api_workorders.phpUpdate
systypesincludes\SQL_CommonFunctions.incUpdate
systypesZ_DeleteSalesTransActions.phpUpdate
systypesAlso has DB-script inserted dataN/A
tagsGLTags.phpInsert, Update
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
woitemsapi/api_workorders.phpInsert
woitemsDeliveryDetails.phpInsert
woitemsDemandWorkOrders.phpInsert
woitemsWorkOrderEntry.phpDelete, Insert, Update
woitemsWorkOrderReceive.phpUpdate
woitemsWOSerialNos.phpUpdate
woitemsZ_ChangeStockCode.phpUpdate
worequirementsDemandWorkOrders.phpInsert
worequirementsincludes/SQL_CommonFunctions.incInsert, Update
worequirementsWorkOrderEntry.phpInsert, Delete
worequirementsWorkOrderReceive.phpDelete
worequirementsZ_ChangeStockCode.phpUpdate
workcentresWorkCentres.phpInsert, Update, Delete
workordersapi/api_workorders.phpInsert, Update
workordersDeliveryDetails.phpInsert
workordersDemandWorkOrders.phpInsert
workordersWorkOrderCosting.phpUpdate
workordersWorkOrderEntry.phpInsert, Update, Delete
workordersWorkOrderIssue.phpUpdate
workordersWorkOrderReceive.phpUpdate
woserialnosDeliveryDetails.phpInsert
woserialnosWorkOrderCosting.phpDelete
woserialnosWorkOrderEntry.phpDelete
woserialnosWOSerialNos.phpDelete, Insert, Update
www_usersCustLoginSetup.phpDelete, Insert, Update
www_usersincludes\session.incUpdate
www_usersinstall/save.phpUpdate
www_usersUserSettings.phpUpdate
www_usersWWW_Users.phpInsert, Update, Delete
www_usersZ_ChangeBranchCode.phpUpdate
www_usersZ_ChangeCustomerCode.phpUpdate
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki