Revision [1882]

This is an old revision of TableProgramCrossReference made by TurboPT on 2010-09-06 21:19:21.

 

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.phpUpdate
currenciesincludes/session.incUpdate
custbranchapi/api_branches.phpUpdate
custbranchConfirmDispatch_Invoice.phpUpdate
custbranchCustomerBranches.phpUpdate
custbranchgeocode.phpUpdate
custcontactsAddCustomerContacts.phpUpdate
custcontactsCustomers.phpUpdate
custnotesAddCustomerNotes.phpUpdate
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
locationsLocations.phpInsert, Update, Delete
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
locstockZ_ChangeStockCode.phpUpdate
locstockZ_DeleteCreditNote.phpUpdate
locstockZ_DeleteSalesTransActions.phpUpdate
locstockZ_MakeStockLocns.phpInsert
locstockZ_PurgePeriods.phpUpdate
loctransfersStockLocTransfer.phpInsert
loctransfersStockLocTransferReceive.phpUpdate
orderdeliverydifferenceslogConfirmDispatch_Invoice.phpInsert
orderdeliverydifferenceslogZ_ChangeBranchCode.phpUpdate
orderdeliverydifferenceslogZ_ChangeCustomerCode.phpUpdate
orderdeliverydifferenceslogZ_ChangeStockCode.phpUpdate
orderdeliverydifferenceslogZ_DeleteInvoice.phpDelete
orderdeliverydifferenceslogZ_DeleteSalesTransActions.phpDelete
orderdeliverydifferenceslogZ_PurgePeriods.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 WikkaWiki