| Program | Table | Operations |
| AccountGroups.php | accountgroups | Insert, Update, Delete |
| AccountSections.php | accountsection | Insert, Update, Delete |
| Areas.php | areas | Insert, Update, Delete |
| BankAccounts.php | bankaccounts | Insert, Update, Delete |
| BankMatching.php | banktrans | Update |
| BOMs.php | bom | Insert, Update, Delete |
| COGSGLPostings.php | accountgroups | Insert |
| COGSGLPostings.php | chartmaster | Insert |
| COGSGLPostings.php | cogsglpostings | Insert, Update, Delete |
| CompanyPreferences.php | companies | Update |
| ConfirmDispatch_Invoice.php | custbranch | Update |
| ConfirmDispatch_Invoice.php | debtortrans | Insert |
| ConfirmDispatch_Invoice.php | debtortranstaxes | Insert |
| ConfirmDispatch_Invoice.php | gltrans | Insert |
| ConfirmDispatch_Invoice.php | locstock | Update |
| ConfirmDispatch_Invoice.php | orderdeliverydifferenceslog | Insert |
| ConfirmDispatch_Invoice.php | salesanalysis | Insert, Update |
| ConfirmDispatch_Invoice.php | salesorderdetails | Update |
| ConfirmDispatch_Invoice.php | salesorders | Update |
| ConfirmDispatch_Invoice.php | stockmoves | Insert |
| ConfirmDispatch_Invoice.php | stockmovestaxes | Insert |
| ConfirmDispatch_Invoice.php | stockserialitems | Update |
| ConfirmDispatch_Invoice.php | stockserialmoves | Insert |
| Credit_Invoice.php | custallocns | Insert |
| Credit_Invoice.php | debtortrans | Insert, Update |
| Credit_Invoice.php | debtortranstaxes | Insert |
| Credit_Invoice.php | gltrans | Insert |
| Credit_Invoice.php | locstock | Update |
| Credit_Invoice.php | salesanalysis | Update |
| Credit_Invoice.php | salesorderdetails | Update |
| Credit_Invoice.php | stockmoves | Insert |
| Credit_Invoice.php | stockmovestaxes | Insert |
| Credit_Invoice.php | stockserialitems | Insert, Update |
| Credit_Invoice.php | stockserialmoves | Insert |
| CreditStatus.php | holdreasons | Insert, Update, Delete |
| Currencies.php | currencies | Insert, Update, Delete |
| CustEDISetup.php | debtorsmaster | Update |
| CustomerAllocations.php | custallocns | Insert, Delete |
| CustomerAllocations.php | debtortrans | Update |
| CustomerAllocations.php | gltrans | Insert |
| CustomerBranches.php | accountscf | Insert |
| CustomerBranches.php | crmentity | Insert, Update |
| CustomerBranches.php | crmentity_seq | Update |
| CustomerBranches.php | custbranch | Insert, Update, Delete |
| CustomerReceipt.php | banktrans | Insert |
| CustomerReceipt.php | debtorsmaster | Update |
| CustomerReceipt.php | debtortrans | Insert |
| CustomerReceipt.php | gltrans | Insert |
| Customers.php | debtorsmaster | Insert, Update, Delete |
| |DeliveryDetails.php||salesorderdetails||Insert, Update||
| | DeliveryDetails.php | salesorders | Insert, Update |
| |DiscountCategories.php||stockmaster||Update||
| | DiscountMatrix.php | discountmatrix | Insert, Delete |
| EDIMessageFormat.php | edimessageformat | Insert, Update, Delete |
| FreightCosts.php | freightcosts | Insert, Update, Delete |
| FTP_RadioBeacon.php | salesorders | Update |
| GLAccounts.php | chartdetails | Insert, Delete |
| GLAccounts.php | chartmaster | Insert, Update, Delete |
| GLJournal.php | gltrans | Insert |
| GoodsReceived.php | gltrans | Insert |
| GoodsReceived.php | grns | Insert |
| GoodsReceived.php | locstock | Update |
| GoodsReceived.php | purchorderdetails | Update |
| GoodsReceived.php | stockmoves | Insert |
| GoodsReceived.php | stockserialitems | Insert, Update |
| GoodsReceived.php | stockserialmoves | Insert |
| includes\DateFunctions.inc | chartdetails | Insert |
| includes\DateFunctions.inc | periods | Insert |
| includes\DefineCartClass.php | salesorderdetails | Insert, Delete |
| includes\DefineShiptClass.php | purchorderdetails | Update |
| includes\GetSalesTransGLCodes.inc | accountgroups | Insert |
| includes\GetSalesTransGLCodes.inc | chartmaster | Insert |
| includes\GLPostings.inc | chartdetails | Insert, Update |
| includes\GLPostings.inc | gltrans | Update |
| includes\GLPostings.inc | periods | Insert |
| includes\PDFPaymentRun_PymtFooter.php | banktrans | Insert |
| includes\PDFPaymentRun_PymtFooter.php | gltrans | Insert |
| includes\PDFPaymentRun_PymtFooter.php | suppallocs | Insert |
| includes\PDFPaymentRun_PymtFooter.php | supptrans | Insert |
| includes\session.inc | www_users | Update |
| includes\SQL_CommonFunctions.inc | systypes | Update |
| Locations.php | locations | Insert, Update, Delete |
| Locations.php | locstock | Insert, Delete |
| Locations.php | taxauthrates | Insert, Delete |
| PaymentMethods.php | banktrans | Update |
| PaymentMethods.php | paymentmethods | Insert, Update, Delete |
| Payments.php | banktrans | Insert |
| Payments.php | gltrans | Insert |
| Payments.php | suppliers | Update |
| Payments.php | supptrans | Insert |
| PaymentTerms.php | paymentterms | Insert, Update, Delete |
| PDFStockCheckComparison.php | gltrans | Insert |
| PDFStockCheckComparison.php | locstock | Update |
| PDFStockCheckComparison.php | stockmoves | Insert |
| PO_Header.php | purchorderdetails | Delete |
| PO_Header.php | purchorders | Update, Delete |
| PO_Items.php | purchorderdetails | Insert, Update, Delete |
| PO_Items.php | purchorders | Insert, Update |
| PO_PDFPurchOrder.php | purchorders | Update |
| Prices.php | prices | Insert, Update, Delete |
| Prices_Customer.php | prices | Insert, Update, Delete |
| PrintCustOrder.php | salesorders | Update |
| PrintCustOrder_generic.php | salesorders | Update |
| PrintCustStatements.php | debtortrans | Update |
| PurchData.php | purchdata | Insert, Update, Delete |
| RecurringSalesOrders.php | recurringsalesorders | Insert, Update, Delete |
| RecurringSalesOrders.php | recurrsalesorderdetails | Insert, Delete |
| RecurringSalesOrdersProcess.php | debtortrans | Insert |
| RecurringSalesOrdersProcess.php | debtortranstaxes | Insert |
| RecurringSalesOrdersProcess.php | gltrans | Insert |
| RecurringSalesOrdersProcess.php | recurringsalesorders | Update |
| RecurringSalesOrdersProcess.php | salesanalysis | Insert, Update |
| RecurringSalesOrdersProcess.php | salesorderdetails | Insert, Update |
| RecurringSalesOrdersProcess.php | salesorders | Insert, Update |
| RecurringSalesOrdersProcess.php | stockmoves | Insert |
| RecurringSalesOrdersProcess.php | stockmovestaxes | Insert |
| ReverseGRN.php | gltrans | Insert |
| ReverseGRN.php | grns | Update |
| ReverseGRN.php | locstock | Update |
| ReverseGRN.php | purchorderdetails | Update |
| ReverseGRN.php | stockmoves | Insert |
| ReverseGRN.php | stockserialitems | Update |
| ReverseGRN.php | stockserialmoves | Insert |
| SalesAnalReptCols.php | reportcolumns | Insert, Update, Delete |
| SalesAnalRepts.php | reportcolumns | Delete |
| SalesAnalRepts.php | reportheaders | Insert, Update, Delete |
| SalesCategories.php | salescat | Insert, Update, Delete |
| SalesCategories.php | salescatprod | Insert, Delete |
| SalesGLPostings.php | accountgroups | Insert |
| SalesGLPostings.php | chartmaster | Insert |
| SalesGLPostings.php | salesglpostings | Insert, Update, Delete |
| SalesPeople.php | salesman | Insert, Update, Delete |
| SalesTypes.php | prices | Delete |
| SalesTypes.php | salestypes | Insert, Update, Delete |
| SelectCreditItems.php | debtortrans | Insert |
| SelectCreditItems.php | debtortranstaxes | Insert |
| SelectCreditItems.php | gltrans | Insert |
| SelectCreditItems.php | locstock | Update |
| SelectCreditItems.php | salesanalysis | Update |
| SelectCreditItems.php | stockmoves | Insert |
| SelectCreditItems.php | stockmovestaxes | Insert |
| SelectCreditItems.php | stockserialitems | Insert, Update |
| SelectCreditItems.php | stockserialmoves | Insert |
| SelectOrderItems.php | salesorderdetails | Delete |
| SelectOrderItems.php | salesorders | Delete |
| ShipmentCosting.php | gltrans | Insert |
| ShipmentCosting.php | stockmaster | Update |
| Shipments.php | purchorderdetails | Update |
| Shipments.php | shipments | Insert, Update |
| Shippers.php | shippers | Insert, Update, Delete |
| SpecialOrder.php | locstock | Insert |
| SpecialOrder.php | purchorderdetails | Insert |
| SpecialOrder.php | purchorders | Insert |
| SpecialOrder.php | salesorderdetails | Insert |
| SpecialOrder.php | salesorders | Insert |
| SpecialOrder.php | stockmaster | Insert |
| StockAdjustments.php | gltrans | Insert |
| StockAdjustments.php | locstock | Update |
| StockAdjustments.php | stockmoves | Insert |
| StockAdjustments.php | stockserialitems | Insert, Update |
| StockAdjustments.php | stockserialmoves | Insert |
| StockCategories.php | stockcategory | Insert, Update, Delete |
| StockCheck.php | stockcheckfreeze | Insert |
| StockCostUpdate.php | gltrans | Insert |
| StockCostUpdate.php | stockmaster | Update |
| StockCounts.php | stockcounts | Insert, Delete |
| StockLocTransfer.php | loctransfers | Insert |
| StockLocTransferReceive.php | locstock | Update |
| StockLocTransferReceive.php | loctransfers | Update |
| StockLocTransferReceive.php | stockmoves | Insert |
| StockLocTransferReceive.php | stockserialitems | Insert, Update |
| StockLocTransferReceive.php | stockserialmoves | Insert |
| StockReorderLevel.php | locstock | Update |
| Stocks.php | bom | Delete |
| Stocks.php | locstock | Insert, Delete |
| Stocks.php | purchdata | Delete |
| Stocks.php | stockmaster | Insert, Update, Delete |
| StockTransfers.php | locstock | Update |
| StockTransfers.php | stockmoves | Insert |
| StockTransfers.php | stockserialitems | Insert, Update |
| StockTransfers.php | stockserialmoves | Insert |
| SupplierAllocations.php | gltrans | Insert |
| SupplierAllocations.php | suppallocs | Insert, Delete |
| SupplierAllocations.php | supptrans | Update |
| SupplierContacts.php | suppliercontacts | Insert, Update, Delete |
| SupplierCredit.php | gltrans | Insert |
| SupplierCredit.php | grns | Update |
| SupplierCredit.php | purchorderdetails | Update |
| SupplierCredit.php | shipmentcharges | Insert |
| SupplierCredit.php | supptrans | Insert |
| SupplierCredit.php | supptranstaxes | Insert |
| SupplierInquiry.php | supptrans | Update |
| SupplierInvoice.php | gltrans | Insert |
| SupplierInvoice.php | grns | Update |
| SupplierInvoice.php | purchorderdetails | Update |
| SupplierInvoice.php | shipmentcharges | Insert |
| SupplierInvoice.php | stockmaster | Update |
| SupplierInvoice.php | supptrans | Insert |
| SupplierInvoice.php | supptranstaxes | Insert |
| Suppliers.php | suppliers | Insert, Update, Delete |
| SuppPaymentRun.php | supptrans | Update |
| SystemParameters.php | config | Update |
| TaxAuthorities.php | taxauthorities | Insert, Update, Delete |
| TaxAuthorities.php | taxauthrates | Insert, Delete |
| TaxAuthorityRates.php | taxauthrates | Update |
| TaxCategories.php | taxauthrates | Insert, Delete |
| TaxCategories.php | taxcategories | Insert, Update, Delete |
| TaxGroups.php | taxgroups | Insert, Update, Delete |
| TaxGroups.php | taxgrouptaxes | Insert, Update, Delete |
| TaxProvinces.php | taxauthrates | Insert, Delete |
| TaxProvinces.php | taxprovinces | Insert, Update, Delete |
| UnitsOfMeasure.php | contracts | Update |
| UnitsOfMeasure.php | stockmaster | Update |
| UnitsOfMeasure.php | unitsofmeasure | Insert, Update, Delete |
| UserSettings.php | www_users | Update |
| WorkCentres.php | workcentres | Insert, Update, Delete |
| WorkOrderEntry.php | worequirements | Insert, Delete |
| WorkOrderEntry.php | worksorders | Insert, Update, Delete |
| WorkOrderIssue.php | woissues | Insert |
| WorkOrderIssue.php | worksorders | Update |
| WWW_Access.php | securitygroups | Insert, Delete |
| WWW_Access.php | securityroles | Insert, Update, Delete |
| WWW_Users.php | www_users | Insert, Update, Delete |
| Z_ChangeBranchCode.php | contracts | Update |
| Z_ChangeBranchCode.php | custbranch | Insert, Delete |
| Z_ChangeBranchCode.php | debtortrans | Update |
| Z_ChangeBranchCode.php | orderdeliverydifferenceslog | Update |
| Z_ChangeBranchCode.php | prices | Update |
| Z_ChangeBranchCode.php | salesanalysis | Update |
| Z_ChangeBranchCode.php | salesorders | Update |
| Z_ChangeBranchCode.php | stockmoves | Update |
| Z_ChangeBranchCode.php | www_users | Update |
| Z_ChangeCustomerCode.php | contracts | Update |
| Z_ChangeCustomerCode.php | custbranch | Insert, Delete |
| Z_ChangeCustomerCode.php | debtorsmaster | Insert, Delete |
| Z_ChangeCustomerCode.php | debtortrans | Update |
| Z_ChangeCustomerCode.php | orderdeliverydifferenceslog | Update |
| Z_ChangeCustomerCode.php | prices | Update |
| Z_ChangeCustomerCode.php | salesanalysis | Update |
| Z_ChangeCustomerCode.php | salesorders | Update |
| Z_ChangeCustomerCode.php | stockmoves | Update |
| Z_ChangeCustomerCode.php | www_users | Update |
| Z_ChangeStockCode.php | bom | Update |
| Z_ChangeStockCode.php | contractbom | Update |
| Z_ChangeStockCode.php | grns | Update |
| Z_ChangeStockCode.php | locstock | Update |
| Z_ChangeStockCode.php | orderdeliverydifferenceslog | Update |
| Z_ChangeStockCode.php | prices | Update |
| Z_ChangeStockCode.php | purchdata | Update |
| Z_ChangeStockCode.php | purchorderdetails | Update |
| Z_ChangeStockCode.php | salesanalysis | Update |
| Z_ChangeStockCode.php | salesorderdetails | Update |
| Z_ChangeStockCode.php | shipmentcharges | Update |
| Z_ChangeStockCode.php | stockcheckfreeze | Update |
| Z_ChangeStockCode.php | stockcounts | Update |
| Z_ChangeStockCode.php | stockmaster | Insert, Delete |
| Z_ChangeStockCode.php | stockmoves | Update |
| Z_ChangeStockCode.php | stockserialitems | Update |
| Z_ChangeStockCode.php | stockserialmoves | Update |
| Z_CreateChartDetails.php | chartdetails | Insert, Update |
| Z_CreateCompany.php | accountgroups | Insert |
| Z_CreateCompany.php | chartmaster | Insert |
| Z_CreateCompany.php | cogsglpostings | Insert |
| Z_CreateCompany.php | companies | Insert |
| Z_CreateCompany.php | salesglpostings | Insert |
| Z_CreateCompany.php | salesorders | Insert |
| Z_DeleteCreditNote.php | debtortrans | Delete |
| Z_DeleteCreditNote.php | locstock | Update |
| Z_DeleteCreditNote.php | salesanalysis | Delete |
| Z_DeleteCreditNote.php | salesorderdetails | Update |
| Z_DeleteCreditNote.php | stockmoves | Delete |
| Z_DeleteInvoice.php | debtortrans | Delete |
| Z_DeleteInvoice.php | orderdeliverydifferenceslog | Delete |
| Z_DeleteInvoice.php | salesanalysis | Delete |
| Z_DeleteInvoice.php | salesorderdetails | Update |
| Z_DeleteInvoice.php | stockmoves | Delete |
| Z_DeleteSalesTransActions.php | debtortrans | Delete |
| Z_DeleteSalesTransActions.php | debtortranstaxes | Delete |
| Z_DeleteSalesTransActions.php | gltrans | Delete |
| Z_DeleteSalesTransActions.php | grns | Delete |
| Z_DeleteSalesTransActions.php | locstock | Update |
| Z_DeleteSalesTransActions.php | orderdeliverydifferenceslog | Delete |
| Z_DeleteSalesTransActions.php | purchorderdetails | Update, Delete |
| Z_DeleteSalesTransActions.php | purchorders | Delete |
| Z_DeleteSalesTransActions.php | salesorderdetails | Update, Delete |
| Z_DeleteSalesTransActions.php | salesorders | Delete |
| Z_DeleteSalesTransActions.php | stockmoves | Delete |
| Z_DeleteSalesTransActions.php | stockmovestaxes | Delete |
| Z_DeleteSalesTransActions.php | stockserialmoves | Delete |
| Z_DeleteSalesTransActions.php | systypes | Update |
| Z_MakeStockLocns.php | locstock | Insert |
| Z_PriceChanges.php | prices | Update |
| Z_PurgePeriods.php | custallocns | Delete |
| Z_PurgePeriods.php | debtortrans | Delete |
| Z_PurgePeriods.php | gltrans | Delete |
| Z_PurgePeriods.php | grns | Delete |
| Z_PurgePeriods.php | locstock | Update |
| Z_PurgePeriods.php | orderdeliverydifferenceslog | Delete |
| Z_PurgePeriods.php | purchorderdetails | Update, Delete |
| Z_PurgePeriods.php | purchorders | Delete |
| Z_PurgePeriods.php | salesanalysis | Delete |
| Z_PurgePeriods.php | salesorderdetails | Update, Delete |
| Z_PurgePeriods.php | salesorders | Delete |
| Z_PurgePeriods.php | stockmoves | Delete |
| Z_PurgePeriods.php | stockserialmoves | Delete |
| Z_PurgePeriods.php | systypes | Update |
| Z_ReApplyCostToSA.php | salesanalysis | Update |
| Z_RePostGLFromPeriod.php | chartdetails | Update |
| Z_RePostGLFromPeriod.php | gltrans | Update |
| Z_ReverseSuppPaymentRun.php | BankTrans | Delete |
| Z_ReverseSuppPaymentRun.php | GLTrans | Delete |
| Z_ReverseSuppPaymentRun.php | SuppAllocs | Delete |
| Z_ReverseSuppPaymentRun.php | SuppTrans | Update, Delete |
| Z_UpdateChartDetailsBFwd.php | chartdetails | Update |
There are no comments on this page. [Add comment]