Revision [1902]

Last edited on 2010-09-11 20:59:47 by TurboPT [Add [or updated] W-named tables.]
Additions:
||woitems||api/api_workorders.php||Insert||
||woitems||DeliveryDetails.php||Insert||
||woitems||DemandWorkOrders.php||Insert||
||woitems||WorkOrderEntry.php||Delete, Insert, Update||
||woitems||WorkOrderReceive.php||Update||
||woitems||WOSerialNos.php||Update||
||woitems||Z_ChangeStockCode.php||Update||
||worequirements||DemandWorkOrders.php||Insert||
||worequirements||includes/SQL_CommonFunctions.inc||Insert, Update||
||worequirements||WorkOrderReceive.php||Delete||
||worequirements||Z_ChangeStockCode.php||Update||
||workorders||api/api_workorders.php||Insert, Update||
||workorders||DeliveryDetails.php||Insert||
||workorders||DemandWorkOrders.php||Insert||
||workorders||WorkOrderCosting.php||Update||
||workorders||WorkOrderEntry.php||Insert, Update, Delete||
||workorders||WorkOrderIssue.php||Update||
||workorders||WorkOrderReceive.php||Update||
||woserialnos||DeliveryDetails.php||Insert||
||woserialnos||WorkOrderCosting.php||Delete||
||woserialnos||WorkOrderEntry.php||Delete||
||woserialnos||WOSerialNos.php||Delete, Insert, Update||
||www_users||CustLoginSetup.php||Delete, Insert, Update||
||www_users||install/save.php||Update||
Deletions:
||woissues||WorkOrderIssue.php||Insert||
||worksorders||WorkOrderEntry.php||Insert, Update, Delete||
||worksorders||WorkOrderIssue.php||Update||


Revision [1901]

Edited on 2010-09-11 20:28:03 by TurboPT [Added info. for table 'tags'.]
Additions:
||tags||GLTags.php||Insert, Update||


Revision [1900]

Edited on 2010-09-10 23:05:24 by TurboPT [Add [or updated] S-named tables]
Additions:
||salesanalysis||Credit_Invoice.php||Insert, Update||
||salesman||api/api_salesman.php||Insert||
||salesorderdetails||api/api_salesorders.php||Insert, Update||
||SalesOrderDetails||GoodsReceived.php||Update||
||salesorderdetails||includes/DefineCartClass.php||Insert, Delete, Update||
||salesorders||api/api_salesorders.php||Insert, Update||
||salesorders||PrintSalesOrder_generic.php||Update||
||salestypes||api/api_salestypes.php||Insert||
||shipments||ShipmentCosting.php||Update||
||stockcategory||api/api_stockcategories.php||Insert, Update||
||stockcatproperties||StockCategories.php||Delete, Insert, Update||
||stockitemproperties||StockCategories.php||Delete||
||stockitemproperties||Stocks.php||Delete, Insert||
||stockitemproperties||Z_ChangeStockCode.php||Update||
||stockmaster||api/api_stock.php||Insert, Update||
||stockmaster||DeliveryDetails.php||Update||
||stockmaster||includes/SQL_CommonFunctions.inc||Update||
||stockmaster||WorkOrderCosting.php||Update||
||stockmaster||WorkOrderReceive.php||Update||
||stockmaster||WOSerialNos.php||Update||
||stockmaster||Z_CopyBOM.php||Insert, Update||
||stockmaster||Z_ImportStocks.php||Insert||
||stockmoves||api/api_stock.php||Insert||
||stockmoves||api/api_workorders.php||Insert||
||stockmoves||WorkOrderIssue.php||Insert||
||stockmoves||WorkOrderReceive.php||Insert||
||stockserialitems||api/api_workorders.php||Update||
||stockserialitems||WorkOrderIssue.php||Insert, Update||
||stockserialitems||WorkOrderReceive.php||Insert, Update||
||stockserialmoves||WorkOrderIssue.php||Insert||
||stockserialmoves||WorkOrderReceive.php||Insert||
||suppliers||api/api_suppliers.php||Insert, Update||
||suppliers||geocode.php||Update||
||systypes||api/api_debtortransactions.php||Update||
||systypes||api/api_stock.php||Update||
||systypes||api/api_workorders.php||Update||
||systypes||Also has DB-script inserted data||N/A||
Deletions:
||salesanalysis||Credit_Invoice.php||Update||
||salesanalysis||Z_PurgePeriods.php||Delete||
||salesorderdetails||includes\DefineCartClass.php||Insert, Delete||
||salesorderdetails||Z_PurgePeriods.php||Update, Delete||
||salesorders||Z_PurgePeriods.php||Delete||
||stockmoves||Z_PurgePeriods.php||Delete||
||stockserialmoves||Z_PurgePeriods.php||Delete||
||systypes||Z_PurgePeriods.php||Update||


Revision [1899]

Edited on 2010-09-10 21:56:35 by TurboPT [Add [or update] P-named tables]
Additions:
||periods||includes/DateFunctions.inc||Insert||
||periods||includes/GLPostings.inc||Insert||
||prices||api/api_stock.php||Insert, Update||
||prices||PricesBasedOnMarkUp.php||Insert, Update||
||prices||Stocks.php||Delete||
||purchdata||api/api_purchdata.php||Insert, Update||
||purchorderauth||PO_AuthorisationLevels.php||Delete, Insert, Update||
||purchorderdetails||PO_Header.php||Update||
||purchorderdetails||ShipmentCosting.php||Update||
||purchorders||GoodsReceived.php||Update||
Deletions:
||periods||includes\DateFunctions.inc||Insert||
||periods||includes\GLPostings.inc||Insert||
||purchorderdetails||PO_Header.php||Delete||
||purchorderdetails||Z_PurgePeriods.php||Update, Delete||
||purchorders||Z_PurgePeriods.php||Delete||


Revision [1887]

Edited on 2010-09-08 21:58:57 by TurboPT [Added M-named tables.]
Additions:
||mrpcalendar||MRPCalendar.php||Insert, Update||
||mrpdemands||MRPCreateDemands.php||Insert||
||mrpdemands||MRPDemands.php||Delete, Insert, Update||
||mrpdemands||Z_ChangeStockCode.php||Update||
||mrpdemandtypes||MRPDemandTypes.php||Delete, Insert, Update||


Revision [1886]

Edited on 2010-09-08 21:51:15 by TurboPT [Updated O-named table. [removed 1 entry]]
Deletions:
||orderdeliverydifferenceslog||Z_PurgePeriods.php||Delete||


Revision [1885]

Edited on 2010-09-08 21:46:26 by TurboPT [Finished updating L-named tables.]
Additions:
||locstock||api/api_stock.php||Insert, Update||
||locstock||api/api_workorders.php||Update||
||locstock||WorkOrderIssue.php||Update||
||locstock||WorkOrderReceive.php||Update||
||locstock||Z_CopyBOM.php||Insert||
||locstock||Z_ImportStocks.php||Insert||
||loctransfers||Z_ChangeStockCode.php||Update||
Deletions:
||locstock||Z_PurgePeriods.php||Update||


Revision [1884]

Edited on 2010-09-08 21:28:47 by TurboPT [Added tables with E, F, G, and started L-named]
Additions:
||edimessageformat||EDIMessageFormat.php||Delete, Insert, Update||
||edi_orders_segs||DB-script data inserted||N/A||
||edi_orders_seg_groups||DB-script data inserted||N/A||
||factorcompanies||Factors.php||Delete, Insert, Update||
||freightcosts||FreightCosts.php||Delete, Insert||
||geocode_param||GeocodeSetup.php||Delete, Insert, Update||
||gltrans||api/api_debtortransactions.php||Insert||
||gltrans||api/api_stock.php||Insert||
||gltrans||api/api_workorders.php||Insert||
||gltrans||BankReconciliation.php||Insert||
||gltrans||ConfirmDispatch_Invoice.php||Insert||
||gltrans||Credit_Invoice.php||Insert||
||gltrans||CustomerAllocations.php||Insert||
||gltrans||CustomerReceipt.php||Insert||
||gltrans||GLJournal.php||Insert||
||gltrans||GoodsReceived.php||Insert||
||gltrans||includes/GLPostings.inc||Update||
||gltrans||includes/PDFPaymentRun_PymtFooter.php||Insert||
||gltrans||includes/SQL_CommonFunctions.inc||Insert||
||gltrans||Payments.php||Insert||
||gltrans||PDFStockCheckComparison.php||Insert||
||gltrans||RecurringSalesOrdersProcess.php||Insert||
||gltrans||ReverseGRN.php||Insert||
||gltrans||SelectCreditItems.php||Insert||
||gltrans||ShipmentCosting.php||Insert||
||gltrans||StockAdjustments.php||Insert||
||gltrans||SupplierAllocations.php||Insert||
||gltrans||SupplierCredit.php||Insert||
||gltrans||SupplierInvoice.php||Insert||
||gltrans||WorkOrderCosting.php||Insert||
||gltrans||WorkOrderIssue.php||Insert||
||gltrans||WorkOrderReceive.php||Insert||
||gltrans||Z_DeleteInvoice.php||Delete||
||gltrans||Z_DeleteSalesTransActions.php||Delete||
||gltrans||Z_ReverseSuppPaymentRun.php||Delete||
||locations||api/api_locations.php||Insert, Update||
Deletions:
||GLTrans||Z_ReverseSuppPaymentRun.php||Delete||


Revision [1883]

Edited on 2010-09-06 22:34:15 by TurboPT [Fix c-named table actions; Added d-named tables.]
Additions:
||currencies||Currencies.php||Delete, Insert, Update||
||custallocns||Credit_Invoice.php||Insert||
||custallocns||CustomerAllocations.php||Delete||
||custbranch||api/api_branches.php||Insert, Update||
||custbranch||CustomerBranches.php||Delete, Insert, Update||
||custbranch||Z_ChangeBranchCode.php||Delete, Insert||
||custbranch||Z_ChangeCustomerCode.php||Delete, Insert||
||custcontacts||AddCustomerContacts.php||Delete, Insert, Update||
||custcontacts||Customers.php||Delete, Update||
||custnotes||AddCustomerNotes.php||Delete, Insert, Update||
||debtorsmaster||api/api_customers.php||Insert, Update||
||debtorsmaster||CustEDISetup.php||Update||
||debtorsmaster||CustomerReceipt.php||Update||
||debtorsmaster||Customers.php||Delete, Insert, Update||
||debtorsmaster||Z_ChangeCustomerCode.php||Delete, Insert||
||debtortrans||api/api_debtortransactions.php||Insert||
||debtortrans||ConfirmDispatch_Invoice.php||Insert||
||debtortrans||Credit_Invoice.php||Insert, Update||
||debtortrans||CustomerAllocations.php||Update||
||debtortrans||CustomerReceipt.php||Insert||
||debtortrans||EDISendInvoices.php||Update||
||debtortrans||PrintCustStatements.php||Update||
||debtortrans||RecurringSalesOrdersProcess.php||Insert||
||debtortrans||SelectCreditItems.php||Insert||
||debtortrans||Z_ChangeBranchCode.php||Update||
||debtortrans||Z_ChangeCustomerCode.php||Update||
||debtortrans||Z_DeleteCreditNote.php||Delete||
||debtortrans||Z_DeleteInvoice.php||Delete||
||debtortrans||Z_DeleteSalesTransActions.php||Delete||
||debtortranstaxes||ConfirmDispatch_Invoice.php||Insert||
||debtortranstaxes||Credit_Invoice.php||Insert||
||debtortranstaxes||RecurringSalesOrdersProcess.php||Insert||
||debtortranstaxes||SelectCreditItems.php||Insert||
||debtortranstaxes||Z_DeleteSalesTransActions.php||Delete||
||debtortype||CustomerTypes.php||Delete, Insert, Update||
||debtortypenotes||AddCustomerTypeNotes.php||Delete, Insert, Update||
||discountmatrix||DiscountMatrix.php||Delete, Insert||
Deletions:
||currencies||Currencies.php||Update||
||custbranch||api/api_branches.php||Update||
||custbranch||CustomerBranches.php||Update||
||custcontacts||AddCustomerContacts.php||Update||
||custcontacts||Customers.php||Update||
||custnotes||AddCustomerNotes.php||Update||


Revision [1882]

Edited on 2010-09-06 21:19:21 by TurboPT [Added tables that start with c.]
Additions:
||chartdetails||api/api_glaccounts.php||Insert||
||chartdetails||GLAccounts.php||Delete, Insert||
||chartdetails||GLBudgets.php||Update||
||chartdetails||includes/DateFunctions.inc||Insert||
||chartdetails||includes/GLPostings.inc||Insert, Update||
||chartdetails||Z_CreateChartDetails.php||Insert, Update||
||chartdetails||Z_RePostGLFromPeriod.php||Update||
||chartdetails||Z_UpdateChartDetailsBFwd.php||Update||
||chartmaster||api/api_glaccounts.php||Insert||
||chartmaster||COGSGLPostings.php||Insert||
||chartmaster||GLAccounts.php||Delete, Insert, Update||
||chartmaster||includes/GetSalesTransGLCodes.inc||Insert||
||chartmaster||SalesGLPostings.php||Insert||
||chartmaster||Z_CreateCompany.php||Insert||
||cogsglpostings||COGSGLPostings.php||Delete, Insert, Update||
||cogsglpostings||Z_CreateCompany.php||Insert||
||companies||CompanyPreferences.php||Update||
||companies||install/save.php||Update||
||companies||Z_CreateCompany.php||Insert||
||config||CustomerTypes.php||Update||
||config||includes/ConnectDB_mysql.inc||Update||
||config||includes/ConnectDB_mysqli.inc||Update||
||config||includes/ConnectDB_postgres.inc||Update||
||config||includes/session.inc||Update||
||config||SalesTypes.php||Update||
||config||SystemParameters.php||Update||
||config||Z_MakeNewCompany.php||Update||
||contractbom||Z_ChangeStockCode.php||Update||
||contracts||UnitsOfMeasure.php||Update||
||contracts||Z_ChangeBranchCode.php||Update||
||contracts||Z_ChangeCustomerCode.php||Update||
||currencies||CompanyPreferences.php||Update||
||currencies||Currencies.php||Update||
||currencies||includes/session.inc||Update||
||custbranch||api/api_branches.php||Update||
||custbranch||ConfirmDispatch_Invoice.php||Update||
||custbranch||CustomerBranches.php||Update||
||custbranch||geocode.php||Update||
||custcontacts||AddCustomerContacts.php||Update||
||custcontacts||Customers.php||Update||
||custnotes||AddCustomerNotes.php||Update||


Revision [1881]

Edited on 2010-09-05 23:00:12 by TurboPT [Added tables starting with a or b.]
Additions:
||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||


Revision [780]

Edited on 2007-11-09 20:14:47 by PhilDaintree [Added tables starting with a or b.]
Additions:
||systypes||includes\SQL_CommonFunctions.inc||Update||
||www_users||includes\session.inc||Update||
Deletions:
||systypes||includes\SQL_CommonFunctions.inc|Update||
||www_users||includes\session.inc|Update||


Revision [779]

Edited on 2007-11-09 20:13:11 by PhilDaintree [Added tables starting with a or b.]
Additions:
||====DB Table====||====webERP Script====||**Action**||


Revision [778]

Edited on 2007-11-09 20:11:47 by PhilDaintree [Added tables starting with a or b.]
Additions:
||GLTrans||Z_ReverseSuppPaymentRun.php||Delete||
||grns||Z_DeleteSalesTransActions.php||Delete||
||grns||Z_PurgePeriods.php||Delete||
||orderdeliverydifferenceslog||Z_DeleteInvoice.php||Delete||
||orderdeliverydifferenceslog||Z_DeleteSalesTransActions.php||Delete||
||orderdeliverydifferenceslog||Z_PurgePeriods.php||Delete||
||prices||SalesTypes.php||Delete||
||purchdata||Stocks.php||Delete||
||purchorderdetails||PO_Header.php||Delete||
||purchorders||Z_DeleteSalesTransActions.php||Delete||
||purchorders||Z_PurgePeriods.php||Delete||
||reportcolumns||SalesAnalRepts.php||Delete||
||salesanalysis||Z_DeleteCreditNote.php||Delete||
||salesanalysis||Z_DeleteInvoice.php||Delete||
||salesanalysis||Z_PurgePeriods.php||Delete||
||salesorderdetails||SelectOrderItems.php||Delete||
||salesorders||SelectOrderItems.php||Delete||
||salesorders||Z_DeleteSalesTransActions.php||Delete||
||salesorders||Z_PurgePeriods.php||Delete||
||stockmoves||Z_DeleteCreditNote.php||Delete||
||stockmoves||Z_DeleteInvoice.php||Delete||
||stockmoves||Z_DeleteSalesTransActions.php||Delete||
||stockmoves||Z_PurgePeriods.php||Delete||
||stockmovestaxes||Z_DeleteSalesTransActions.php||Delete||
||stockserialmoves||Z_DeleteSalesTransActions.php||Delete||
||stockserialmoves||Z_PurgePeriods.php||Delete||
||SuppAllocs||Z_ReverseSuppPaymentRun.php||Delete||
Deletions:
||GLTrans||Z_ReverseSuppPaymentRun.php|Delete||
||grns||Z_DeleteSalesTransActions.php|Delete||
||grns||Z_PurgePeriods.php|Delete||
||orderdeliverydifferenceslog||Z_DeleteInvoice.php|Delete||
||orderdeliverydifferenceslog||Z_DeleteSalesTransActions.php|Delete||
||orderdeliverydifferenceslog||Z_PurgePeriods.php|Delete||
||prices||SalesTypes.php|Delete||
||purchdata||Stocks.php|Delete||
||purchorderdetails||PO_Header.php|Delete||
||purchorders||Z_DeleteSalesTransActions.php|Delete||
||purchorders||Z_PurgePeriods.php|Delete||
||reportcolumns||SalesAnalRepts.php|Delete||
||salesanalysis||Z_DeleteCreditNote.php|Delete||
||salesanalysis||Z_DeleteInvoice.php|Delete||
||salesanalysis||Z_PurgePeriods.php|Delete||
||salesorderdetails||SelectOrderItems.php|Delete||
||salesorders||SelectOrderItems.php|Delete||
||salesorders||Z_DeleteSalesTransActions.php|Delete||
||salesorders||Z_PurgePeriods.php|Delete||
||stockmoves||Z_DeleteCreditNote.php|Delete||
||stockmoves||Z_DeleteInvoice.php|Delete||
||stockmoves||Z_DeleteSalesTransActions.php|Delete||
||stockmoves||Z_PurgePeriods.php|Delete||
||stockmovestaxes||Z_DeleteSalesTransActions.php|Delete||
||stockserialmoves||Z_DeleteSalesTransActions.php|Delete||
||stockserialmoves||Z_PurgePeriods.php|Delete||
||SuppAllocs||Z_ReverseSuppPaymentRun.php|Delete||


Revision [777]

Edited on 2007-11-09 20:11:05 by PhilDaintree [Added tables starting with a or b.]
Deletions:
Z_PurgePeriods.php|Delete||
|#


Revision [776]

Edited on 2007-11-09 20:09:52 by PhilDaintree [Added tables starting with a or b.]
Additions:
||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||
Deletions:
||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||


Revision [775]

Edited on 2007-11-09 20:08:49 by PhilDaintree [Added tables starting with a or b.]
Additions:
Z_PurgePeriods.php|Delete||
||gltrans|~Z_RePostGLFromPeriod.php||Update||
||grns|~GoodsReceived.php||Insert||
||grns|~ReverseGRN.php||Update||
||grns|~SupplierCredit.php||Update||
||grns|~SupplierInvoice.php||Update||
||grns|~Z_ChangeStockCode.php||Update||
||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||
||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|~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|~Z_ChangeStockCode.php||Update||
||purchorderdetails|~GoodsReceived.php||Update||
||purchorderdetails|~includes\DefineShiptClass.php||Update||
||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||
||recurringsalesorders|~RecurringSalesOrders.php||Insert, Update, Delete||
||recurringsalesorders|~RecurringSalesOrdersProcess.php||Update||
||recurrsalesorderdetails|~RecurringSalesOrders.php||Insert, Delete||
||reportcolumns|~SalesAnalReptCols.php||Insert, Update, 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_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|~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|~SpecialOrder.php||Insert||
||salesorders|~Z_ChangeBranchCode.php||Update||
||salesorders|~Z_ChangeCustomerCode.php||Update||
||salesorders|~Z_CreateCompany.php||Insert||
||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||
||stockmovestaxes|~ConfirmDispatch_Invoice.php||Insert||
||stockmovestaxes|~Credit_Invoice.php||Insert||
||stockmovestaxes|~RecurringSalesOrdersProcess.php||Insert||
||stockmovestaxes|~SelectCreditItems.php||Insert||
||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||
||suppallocs|~includes\PDFPaymentRun_PymtFooter.php||Insert||
||suppallocs|~SupplierAllocations.php||Insert, 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|~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|~UserSettings.php||Update||
||www_users|~WWW_Users.php||Insert, Update, Delete||
||www_users|~Z_ChangeBranchCode.php||Update||
||www_users|~Z_ChangeCustomerCode.php||Update||
Deletions:
==Table-Program Cross Reference==
For developers wanting to find starting points for development work, the following tables may be of interest. They were created by grepping the CVS source as at 1/Oct/2006.
See also [[ProgramTableCrossReference Program-Table Cross Reference]].
#|
||**table**||**program**||**Usage**||
||accountgroups||AccountGroups.php||Insert, Update, Delete||
||accountgroups||COGSGLPostings.php||Insert||
||accountgroups||includes\GetSalesTransGLCodes.inc||Insert||
||accountgroups||SalesGLPostings.php||Insert||
||accountgroups||Z_CreateCompany.php||Insert||
||accountscf||CustomerBranches.php||Insert||
||accountsection||AccountSections.php||Insert, Update, Delete||
||areas||Areas.php||Insert, Update, Delete||
||bankaccounts||BankAccounts.php||Insert, Update, Delete||
||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||Insert, Update, Delete||
||bom||Stocks.php||Delete||
||bom||Z_ChangeStockCode.php||Update||
||chartdetails||GLAccounts.php||Insert, Delete||
||chartdetails||includes\DateFunctions.inc||Insert||
||chartdetails||includes\GLPostings.inc||Insert, Update||
||chartdetails||Z_CreateChartDetails.php||Insert, Update||
||chartdetails||Z_RePostGLFromPeriod.php|Update||
||chartdetails||Z_UpdateChartDetailsBFwd.php|Update||
||chartmaster||COGSGLPostings.php|Insert||
||chartmaster||GLAccounts.php|Insert, Update, Delete||
||chartmaster||includes\GetSalesTransGLCodes.inc|Insert||
||chartmaster||SalesGLPostings.php|Insert||
||chartmaster||Z_CreateCompany.php|Insert||
||cogsglpostings||COGSGLPostings.php|Insert, Update, Delete||
||cogsglpostings||Z_CreateCompany.php|Insert||
||companies||CompanyPreferences.php|Update||
||companies||Z_CreateCompany.php|Insert||
||config||SystemParameters.php|Update||
||contractbom||Z_ChangeStockCode.php|Update||
||contracts|~UnitsOfMeasure.php|Update||
||contracts|~Z_ChangeBranchCode.php|Update||
||contracts|~Z_ChangeCustomerCode.php|Update||
||crmentity|~CustomerBranches.php|Insert, Update||
||crmentity_seq|~CustomerBranches.php|Update||
||currencies|~Currencies.php|Insert, Update, Delete||
||custallocns|~Credit_Invoice.php|Insert||
||custallocns|~CustomerAllocations.php|Insert, Delete||
||custallocns|~Z_PurgePeriods.php|Delete||
||custbranch|~ConfirmDispatch_Invoice.php|Update||
||custbranch|~CustomerBranches.php|Insert, Update, Delete||
||custbranch|~Z_ChangeBranchCode.php|Insert, Delete||
||custbranch|~Z_ChangeCustomerCode.php|Insert, Delete||
||debtorsmaster|~CustEDISetup.php|Update||
||debtorsmaster|~CustomerReceipt.php|Update||
||debtorsmaster|~Customers.php|Insert, Update, Delete||
||debtorsmaster|~Z_ChangeCustomerCode.php|Insert, Delete||
||debtortrans|~ConfirmDispatch_Invoice.php|Insert||
||debtortrans|~Credit_Invoice.php|Insert, Update||
||debtortrans|~CustomerAllocations.php|Update||
||debtortrans|~CustomerReceipt.php|Insert||
||debtortrans|~PrintCustStatements.php|Update||
||debtortrans|~RecurringSalesOrdersProcess.php|Insert||
||debtortrans|~SelectCreditItems.php|Insert||
||debtortrans|~Z_ChangeBranchCode.php|Update||
||debtortrans|~Z_ChangeCustomerCode.php|Update||
||debtortrans|~Z_DeleteCreditNote.php|Delete||
||debtortrans|~Z_DeleteInvoice.php|Delete||
||debtortrans|~Z_DeleteSalesTransActions.php|Delete||
||debtortrans|~Z_PurgePeriods.php|Delete||
||debtortranstaxes|~ConfirmDispatch_Invoice.php|Insert||
||debtortranstaxes|~Credit_Invoice.php|Insert||
||debtortranstaxes|~RecurringSalesOrdersProcess.php|Insert||
||debtortranstaxes|~SelectCreditItems.php|Insert||
||debtortranstaxes|~Z_DeleteSalesTransActions.php|Delete||
||discountmatrix|~DiscountMatrix.php|Insert, Delete||
||edimessageformat|~EDIMessageFormat.php|Insert, Update, Delete||
||freightcosts|~FreightCosts.php|Insert, Update, Delete||
||gltrans|~ConfirmDispatch_Invoice.php|Insert||
||gltrans|~Credit_Invoice.php|Insert||
||gltrans|~CustomerAllocations.php|Insert||
||gltrans|~CustomerReceipt.php|Insert||
||gltrans|~GLJournal.php|Insert||
||gltrans|~GoodsReceived.php|Insert||
||gltrans|~includes\GLPostings.inc|Update||
||gltrans|~includes\PDFPaymentRun_PymtFooter.php|Insert||
||gltrans|~Payments.php|Insert||
||gltrans|~PDFStockCheckComparison.php|Insert||
||gltrans|~RecurringSalesOrdersProcess.php|Insert||
||gltrans|~ReverseGRN.php|Insert||
||gltrans|~SelectCreditItems.php|Insert||
||gltrans|~ShipmentCosting.php|Insert||
||gltrans|~StockAdjustments.php|Insert||
||gltrans|~StockCostUpdate.php|Insert||
||gltrans|~SupplierAllocations.php|Insert||
||gltrans|~SupplierCredit.php|Insert||
||gltrans|~SupplierInvoice.php|Insert||
||gltrans|~Z_DeleteSalesTransActions.php|Delete||
||gltrans|~Z_PurgePeriods.php|Delete||
||gltrans|~Z_RePostGLFromPeriod.php|Update||
||grns|~GoodsReceived.php|Insert||
||grns|~ReverseGRN.php|Update||
||grns|~SupplierCredit.php|Update||
||grns|~SupplierInvoice.php|Update||
||grns|~Z_ChangeStockCode.php|Update||
||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||
||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|~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|~Z_ChangeStockCode.php|Update||
||purchorderdetails|~GoodsReceived.php|Update||
||purchorderdetails|~includes\DefineShiptClass.php|Update||
||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||
||recurringsalesorders|~RecurringSalesOrders.php|Insert, Update, Delete||
||recurringsalesorders|~RecurringSalesOrdersProcess.php|Update||
||recurrsalesorderdetails|~RecurringSalesOrders.php|Insert, Delete||
||reportcolumns|~SalesAnalReptCols.php|Insert, Update, 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_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|~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|~SpecialOrder.php|Insert||
||salesorders|~Z_ChangeBranchCode.php|Update||
||salesorders|~Z_ChangeCustomerCode.php|Update||
||salesorders|~Z_CreateCompany.php|Insert||
||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||
||stockmovestaxes|~ConfirmDispatch_Invoice.php|Insert||
||stockmovestaxes|~Credit_Invoice.php|Insert||
||stockmovestaxes|~RecurringSalesOrdersProcess.php|Insert||
||stockmovestaxes|~SelectCreditItems.php|Insert||
||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||
||suppallocs|~includes\PDFPaymentRun_PymtFooter.php|Insert||
||suppallocs|~SupplierAllocations.php|Insert, 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|~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|~UserSettings.php|Update||
||www_users|~WWW_Users.php|Insert, Update, Delete||
||www_users|~Z_ChangeBranchCode.php|Update||
||www_users|~Z_ChangeCustomerCode.php|Update||


Revision [774]

Edited on 2007-11-09 20:03:39 by PhilDaintree [Added tables starting with a or b.]
Additions:
||**table**||**program**||**Usage**||
||accountgroups||AccountGroups.php||Insert, Update, Delete||
||accountgroups||COGSGLPostings.php||Insert||
||accountgroups||includes\GetSalesTransGLCodes.inc||Insert||
||accountgroups||SalesGLPostings.php||Insert||
||accountgroups||Z_CreateCompany.php||Insert||
||accountscf||CustomerBranches.php||Insert||
||accountsection||AccountSections.php||Insert, Update, Delete||
||areas||Areas.php||Insert, Update, Delete||
||bankaccounts||BankAccounts.php||Insert, Update, Delete||
||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||Insert, Update, Delete||
||bom||Stocks.php||Delete||
||bom||Z_ChangeStockCode.php||Update||
||chartdetails||GLAccounts.php||Insert, Delete||
||chartdetails||includes\DateFunctions.inc||Insert||
||chartdetails||includes\GLPostings.inc||Insert, Update||
||chartdetails||Z_CreateChartDetails.php||Insert, Update||
||chartdetails||Z_RePostGLFromPeriod.php|Update||
||chartdetails||Z_UpdateChartDetailsBFwd.php|Update||
||chartmaster||COGSGLPostings.php|Insert||
||chartmaster||GLAccounts.php|Insert, Update, Delete||
||chartmaster||includes\GetSalesTransGLCodes.inc|Insert||
||chartmaster||SalesGLPostings.php|Insert||
||chartmaster||Z_CreateCompany.php|Insert||
||cogsglpostings||COGSGLPostings.php|Insert, Update, Delete||
||cogsglpostings||Z_CreateCompany.php|Insert||
||companies||CompanyPreferences.php|Update||
||companies||Z_CreateCompany.php|Insert||
||config||SystemParameters.php|Update||
||contractbom||Z_ChangeStockCode.php|Update||
Deletions:
||**table**|**program**|**Usage**||
||accountgroups|~AccountGroups.php|Insert, Update, Delete||
||accountgroups|~COGSGLPostings.php|Insert||
||accountgroups|~includes\GetSalesTransGLCodes.inc|Insert||
||accountgroups|~SalesGLPostings.php|Insert||
||accountgroups|~Z_CreateCompany.php|Insert||
||accountscf|~CustomerBranches.php|Insert||
||accountsection|~AccountSections.php|Insert, Update, Delete||
||areas|~Areas.php|Insert, Update, Delete||
||bankaccounts|~BankAccounts.php|Insert, Update, Delete||
||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|Insert, Update, Delete||
||bom|~Stocks.php|Delete||
||bom|~Z_ChangeStockCode.php|Update||
||chartdetails|~GLAccounts.php|Insert, Delete||
||chartdetails|~includes\DateFunctions.inc|Insert||
||chartdetails|~includes\GLPostings.inc|Insert, Update||
||chartdetails|~Z_CreateChartDetails.php|Insert, Update||
||chartdetails|~Z_RePostGLFromPeriod.php|Update||
||chartdetails|~Z_UpdateChartDetailsBFwd.php|Update||
||chartmaster|~COGSGLPostings.php|Insert||
||chartmaster|~GLAccounts.php|Insert, Update, Delete||
||chartmaster|~includes\GetSalesTransGLCodes.inc|Insert||
||chartmaster|~SalesGLPostings.php|Insert||
||chartmaster|~Z_CreateCompany.php|Insert||
||cogsglpostings|~COGSGLPostings.php|Insert, Update, Delete||
||cogsglpostings|~Z_CreateCompany.php|Insert||
||companies|~CompanyPreferences.php|Update||
||companies|~Z_CreateCompany.php|Insert||
||config|~SystemParameters.php|Update||
||contractbom|~Z_ChangeStockCode.php|Update||


Revision [228]

The oldest known version of this page was created on 2006-10-02 05:54:17 by DavidPratten [Added tables starting with a or b.]
Valid XHTML :: Valid CSS: :: Powered by WikkaWikiGet webERP Accounting & Business Management at SourceForge.net. Fast, secure and Free Open Source software downloads