Revision [1901]

This is an old revision of TableProgramCrossReference made by TurboPT on 2010-09-11 20:28:03.

 

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