Classes
class	ArePurchaseOrdersAlreadyMergedProcedure
	Prepares, validates, and executes the function "transactions.are_purchase_orders_already_merged(arr bigint[])" on the database. More...

class	AreSalesOrdersAlreadyMergedProcedure
	Prepares, validates, and executes the function "transactions.are_sales_orders_already_merged(arr bigint[])" on the database. More...

class	AreSalesQuotationsAlreadyMergedProcedure
	Prepares, validates, and executes the function "transactions.are_sales_quotations_already_merged(_stock_master_id bigint[])" on the database. More...

class	AutoVerifyProcedure
	Prepares, validates, and executes the function "transactions.auto_verify(_tran_id bigint, _office_id integer)" on the database. More...

class	ContainsIncompatibleTaxesProcedure
	Prepares, validates, and executes the function "transactions.contains_incompatible_taxes(arr bigint[])" on the database. More...

class	CreateRecurringInvoicesProcedure
	Prepares, validates, and executes the function "transactions.create_recurring_invoices(pg_arg0 bigint)" on the database. More...

class	CreateRoutineProcedure
	Prepares, validates, and executes the function "transactions.create_routine(_routine_code character varying, _routine regproc, _order integer)" on the database. More...

class	CustomerReceipt
	Provides simplified data access features to perform SCRUD operation on the database table "transactions.customer_receipts". More...

class	DayOperation
	Provides simplified data access features to perform SCRUD operation on the database table "transactions.day_operation". More...

class	DayOperationRoutine
	Provides simplified data access features to perform SCRUD operation on the database table "transactions.day_operation_routines". More...

class	GetAccountStatementProcedure
	Prepares, validates, and executes the function "transactions.get_account_statement(_value_date_from date, _value_date_to date, _user_id integer, _account_id bigint, _office_id integer)" on the database. More...

class	GetAveragePartyTransactionProcedure
	Prepares, validates, and executes the function "transactions.get_average_party_transaction(party_id bigint, office_id integer)" on the database. More...

class	GetBalanceSheetProcedure
	Prepares, validates, and executes the function "transactions.get_balance_sheet(_previous_period date, _current_period date, _user_id integer, _office_id integer, _factor integer)" on the database. More...

class	GetCashFlowStatementProcedure
	Prepares, validates, and executes the function "transactions.get_cash_flow_statement(_date_from date, _date_to date, _user_id integer, _office_id integer, _factor integer)" on the database. More...

class	GetCashRepositoryBalanceProcedure
	Prepares, validates, and executes the function "transactions.get_cash_repository_balance(_cash_repository_id integer, _currency_code character varying)" on the database. More...

class	GetClosingStockProcedure
	Prepares, validates, and executes the function "transactions.get_closing_stock(_on_date date, _office_id integer)" on the database. More...

class	GetCostOfGoodsSoldProcedure
	Prepares, validates, and executes the function "transactions.get_cost_of_goods_sold(_item_id integer, _unit_id integer, _store_id integer, _quantity integer)" on the database. More...

class	GetDefaultCurrencyCodeByOfficeIdProcedure
	Prepares, validates, and executes the function "transactions.get_default_currency_code_by_office_id(office_id integer)" on the database. More...

class	GetDefaultCurrencyCodeProcedure
	Prepares, validates, and executes the function "transactions.get_default_currency_code(cash_repository_id integer)" on the database. More...

class	GetDueDateProcedure
	Prepares, validates, and executes the function "transactions.get_due_date(_value_date date, _payment_term_id integer)" on the database. More...

class	GetEoyProfitSummaryProcedure
	Prepares, validates, and executes the function "transactions.get_eoy_profit_summary(_office_id integer)" on the database. More...

class	GetExchangeRateProcedure
	Prepares, validates, and executes the function "transactions.get_exchange_rate(office_id integer, source_currency_code character varying, destination_currency_code character varying)" on the database. More...

class	GetIncomeExpenditureStatementProcedure
	Prepares, validates, and executes the function "transactions.get_income_expenditure_statement(_date_from date, _date_to date, _user_id integer, _office_id integer, _compact boolean)" on the database. More...

class	GetInventoryTransferRequestViewProcedure
	Prepares, validates, and executes the function "transactions.get_inventory_transfer_request_view(_user_id integer, _login_id bigint, _office_id integer, _from date, _to date, _office text, _store text, _authorized text, _delivered text, _received text, _user text, _reference_number text, _statement_reference text)" on the database. More...

class	GetInvoiceAmountProcedure
	Prepares, validates, and executes the function "transactions.get_invoice_amount(transaction_master_id_ bigint)" on the database. More...

class	GetJournalViewProcedure
	Prepares, validates, and executes the function "transactions.get_journal_view(_user_id integer, _office_id integer, _from date, _to date, _tran_id bigint, _tran_code character varying, _book character varying, _reference_number character varying, _statement_reference character varying, _posted_by character varying, _office character varying, _status character varying, _verified_by character varying, _reason character varying)" on the database. More...

class	GetLastReceiptDateProcedure
	Prepares, validates, and executes the function "transactions.get_last_receipt_date(office_id integer, party_id bigint)" on the database. More...

class	GetMavcogsProcedure
	Prepares, validates, and executes the function "transactions.get_mavcogs(_item_id integer, _store_id integer, _base_quantity numeric, _factor numeric)" on the database. More...

class	GetNetProfitProcedure
	Prepares, validates, and executes the function "transactions.get_net_profit(_date_from date, _date_to date, _office_id integer, _factor integer, _no_provison boolean)" on the database. More...

class	GetNewTransactionCounterProcedure
	Prepares, validates, and executes the function "transactions.get_new_transaction_counter(pg_arg0 date)" on the database. More...

class	GetNonGlProductViewProcedure
	Prepares, validates, and executes the function "transactions.get_non_gl_product_view(user_id_ integer, book_ text, office_id_ integer, date_from_ date, date_to_ date, office_ character varying, party_ text, price_type_ text, user_ character varying, reference_number_ character varying, statement_reference_ text)" on the database. More...

class	GetPartyTransactionSummaryProcedure
	Prepares, validates, and executes the function "transactions.get_party_transaction_summary(office_id integer, party_id bigint)" on the database. More...

class	GetPlAppropriationDataProcedure
	Prepares, validates, and executes the function "transactions.get_pl_appropriation_data(_office_id integer)" on the database. More...

class	GetProductViewProcedure
	Prepares, validates, and executes the function "transactions.get_product_view(user_id_ integer, book_ text, office_id_ integer, date_from_ date, date_to_ date, office_ character varying, party_ text, price_type_ text, user_ character varying, reference_number_ character varying, statement_reference_ text)" on the database. More...

class	GetProfitAndLossStatementProcedure
	Prepares, validates, and executes the function "transactions.get_profit_and_loss_statement(_date_from date, _date_to date, _user_id integer, _office_id integer, _factor integer, _compact boolean)" on the database. More...

class	GetPurchaseProcedure
	Prepares, validates, and executes the function "transactions.get_purchase(_date_from date, _date_to date, _office_id integer)" on the database. More...

class	GetReceiptViewProcedure
	Prepares, validates, and executes the function "transactions.get_receipt_view(_user_id integer, _office_id integer, _date_from date, _date_to date, _office character varying, _party text, _user character varying, _reference_number character varying, _statement_reference text)" on the database. More...

class	GetReorderViewFunctionProcedure
	Prepares, validates, and executes the function "transactions.get_reorder_view_function(office_id integer)" on the database. More...

class	GetRetainedEarningsProcedure
	Prepares, validates, and executes the function "transactions.get_retained_earnings(_date_to date, _office_id integer, _factor integer)" on the database. More...

class	GetRetainedEarningsStatementProcedure
	Prepares, validates, and executes the function "transactions.get_retained_earnings_statement(_date_to date, _office_id integer, _factor integer)" on the database. More...

class	GetSalesByOfficesProcedure
	Prepares, validates, and executes the function "transactions.get_sales_by_offices(office_id integer, divide_by integer)" on the database. More...

class	GetSalespersonReportProcedure
	Prepares, validates, and executes the function "transactions.get_salesperson_report(_office_id integer, _factor integer)" on the database. More...

class	GetSalesTaxIdProcedure
	Prepares, validates, and executes the function "transactions.get_sales_tax_id(_tran_book character varying, _store_id integer, _party_code character varying, _shipping_address_code character varying, _price_type_id integer, _item_code character varying, _unit_id integer, _price money_strict)" on the database. More...

class	GetSalesTaxProcedure
	Prepares, validates, and executes the function "transactions.get_sales_tax(_tran_book character varying, _store_id integer, _party_code character varying, _shipping_address_code character varying, _price_type_id integer, _item_code character varying, _price money_strict2, _quantity integer_strict2, _discount money_strict2, _shipping_charge money_strict2, _sales_tax_id integer)" on the database. More...

class	GetStockAccountStatementProcedure
	Prepares, validates, and executes the function "transactions.get_stock_account_statement(_value_date_from date, _value_date_to date, _user_id integer, _item_id integer, _store_id integer)" on the database. More...

class	GetStockMasterIdByTransactionMasterIdProcedure
	Prepares, validates, and executes the function "transactions.get_stock_master_id_by_transaction_master_id(_stock_master_id bigint)" on the database. More...

class	GetTopSellingProductsByOfficeProcedure
	Prepares, validates, and executes the function "transactions.get_top_selling_products_by_office(_office_id integer, top integer)" on the database. More...

class	GetTopSellingProductsOfAllTimeProcedure
	Prepares, validates, and executes the function "transactions.get_top_selling_products_of_all_time(top integer)" on the database. More...

class	GetTotalDueProcedure
	Prepares, validates, and executes the function "transactions.get_total_due(office_id integer, party_id bigint)" on the database. More...

class	GetTotalSalesByOfficeProcedure
	Prepares, validates, and executes the function "transactions.get_total_sales_by_office(_office_id integer)" on the database. More...

class	GetTransactionCodeProcedure
	Prepares, validates, and executes the function "transactions.get_transaction_code(value_date date, office_id integer, user_id integer, login_id bigint)" on the database. More...

class	GetTransactionMasterIdByStockMasterIdProcedure
	Prepares, validates, and executes the function "transactions.get_transaction_master_id_by_stock_master_id(_stock_master_id bigint)" on the database. More...

class	GetTrialBalanceProcedure
	Prepares, validates, and executes the function "transactions.get_trial_balance(_date_from date, _date_to date, _user_id integer, _office_id integer, _compact boolean, _factor numeric, _change_side_when_negative boolean, _include_zero_balance_accounts boolean)" on the database. More...

class	GetValueDateProcedure
	Prepares, validates, and executes the function "transactions.get_value_date(_office_id integer)" on the database. More...

class	GetVerificationStatusProcedure
	Prepares, validates, and executes the function "transactions.get_verification_status(_tran_id bigint)" on the database. More...

class	GetWriteOffCostOfGoodsSoldProcedure
	Prepares, validates, and executes the function "transactions.get_write_off_cost_of_goods_sold(_stock_master_id bigint, _item_id integer, _unit_id integer, _quantity integer)" on the database. More...

class	HasNexusProcedure
	Prepares, validates, and executes the function "transactions.has_nexus(_state_id integer)" on the database. More...

class	InitializeEodOperationProcedure
	Prepares, validates, and executes the function "transactions.initialize_eod_operation(_user_id integer, _office_id integer, _value_date date)" on the database. More...

class	InventoryTransferDelivery
	Provides simplified data access features to perform SCRUD operation on the database table "transactions.inventory_transfer_deliveries". More...

class	InventoryTransferDeliveryDetail
	Provides simplified data access features to perform SCRUD operation on the database table "transactions.inventory_transfer_delivery_details". More...

class	InventoryTransferRequest
	Provides simplified data access features to perform SCRUD operation on the database table "transactions.inventory_transfer_requests". More...

class	InventoryTransferRequestDetail
	Provides simplified data access features to perform SCRUD operation on the database table "transactions.inventory_transfer_request_details". More...

class	IsEodInitializedProcedure
	Prepares, validates, and executes the function "transactions.is_eod_initialized(_office_id integer, _value_date date)" on the database. More...

class	IsNormallyDebitProcedure
	Prepares, validates, and executes the function "transactions.is_normally_debit(_account_id bigint)" on the database. More...

class	IsPurchaseProcedure
	Prepares, validates, and executes the function "transactions.is_purchase(_transaction_master_id bigint)" on the database. More...

class	IsValidPartyByStockMasterIdProcedure
	Prepares, validates, and executes the function "transactions.is_valid_party_by_stock_master_id(_stock_master_id bigint, _party_id bigint)" on the database. More...

class	IsValidPartyByTransactionMasterIdProcedure
	Prepares, validates, and executes the function "transactions.is_valid_party_by_transaction_master_id(_transaction_master_id bigint, _party_id bigint)" on the database. More...

class	IsValidStockTransactionByStockMasterIdProcedure
	Prepares, validates, and executes the function "transactions.is_valid_stock_transaction_by_stock_master_id(_stock_master_id bigint)" on the database. More...

class	IsValidStockTransactionByTransactionMasterIdProcedure
	Prepares, validates, and executes the function "transactions.is_valid_stock_transaction_by_transaction_master_id(_transaction_master_id bigint)" on the database. More...

class	LateFee
	Provides simplified data access features to perform SCRUD operation on the database table "transactions.late_fee". More...

class	ListClosingStockProcedure
	Prepares, validates, and executes the function "transactions.list_closing_stock(_store_id integer)" on the database. More...

class	NonGlStockDetail
	Provides simplified data access features to perform SCRUD operation on the database table "transactions.non_gl_stock_details". More...

class	NonGlStockMaster
	Provides simplified data access features to perform SCRUD operation on the database table "transactions.non_gl_stock_master". More...

class	NonGlStockMasterRelation
	Provides simplified data access features to perform SCRUD operation on the database table "transactions.non_gl_stock_master_relations". More...

class	NonGlStockTaxDetail
	Provides simplified data access features to perform SCRUD operation on the database table "transactions.non_gl_stock_tax_details". More...

class	OpeningInventoryExistsProcedure
	Prepares, validates, and executes the function "transactions.opening_inventory_exists(_office_id integer)" on the database. More...

class	PartyItemChartView
	Provides simplified data access features to perform SCRUD operation on the database view "transactions.party_item_chart_view". More...

class	PartyPurchaseChartView
	Provides simplified data access features to perform SCRUD operation on the database view "transactions.party_purchase_chart_view". More...

class	PartySalesChartView
	Provides simplified data access features to perform SCRUD operation on the database view "transactions.party_sales_chart_view". More...

class	PerformEodOperationProcedure
	Prepares, validates, and executes the function "transactions.perform_eod_operation(_user_id integer, _login_id bigint, _office_id integer, _value_date date)" on the database. More...

class	PostBonusProcedure
	Prepares, validates, and executes the function "transactions.post_bonus(_user_id integer, _login_id bigint, _office_id integer, _value_date date)" on the database. More...

class	PostErFluctuationProcedure
	Prepares, validates, and executes the function "transactions.post_er_fluctuation(_user_id integer, _login_id bigint, _office_id integer, _value_date date)" on the database. More...

class	PostInventoryTransferDeliveryProcedure
	Prepares, validates, and executes the function "transactions.post_inventory_transfer_delivery(_office_id integer, _user_id integer, _login_id bigint, _inventory_transfer_request_id bigint, _value_date date, _reference_number character varying, _statement_reference text, _shipper_id integer, _source_store_id integer, _details transactions.stock_adjustment_type[])" on the database. More...

class	PostInventoryTransferRequestProcedure
	Prepares, validates, and executes the function "transactions.post_inventory_transfer_request(_office_id integer, _user_id integer, _login_id bigint, _value_date date, _reference_number character varying, _statement_reference text, _details transactions.stock_adjustment_type[])" on the database. More...

class	PostLateFeeProcedure
	Prepares, validates, and executes the function "transactions.post_late_fee(_user_id integer, _login_id bigint, _office_id integer, _value_date date)" on the database. More...

class	PostNonGlTransactionProcedure
	Prepares, validates, and executes the function "transactions.post_non_gl_transaction(_book_name character varying, _office_id integer, _user_id integer, _login_id bigint, _value_date date, _reference_number character varying, _statement_reference text, _party_code character varying, _price_type_id integer, _is_non_taxable_sales boolean, _salesperson_id integer, _shipper_id integer, _shipping_address_code character varying, _store_id integer, _tran_ids bigint[], _details transactions.stock_detail_type[], _attachments core.attachment_type[])" on the database. More...

class	PostOpeningInventoryProcedure
	Prepares, validates, and executes the function "transactions.post_opening_inventory(_office_id integer, _user_id integer, _login_id bigint, _value_date date, _reference_number character varying, _statement_reference text, _details transactions.opening_stock_type[])" on the database. More...

class	PostPurchaseProcedure
	Prepares, validates, and executes the function "transactions.post_purchase(_book_name character varying, _office_id integer, _user_id integer, _login_id bigint, _value_date date, _cost_center_id integer, _reference_number character varying, _statement_reference text, _is_credit boolean, _party_code character varying, _price_type_id integer, _shipper_id integer, _store_id integer, _tran_ids bigint[], _details transactions.stock_detail_type[], _attachments core.attachment_type[])" on the database. More...

class	PostPurchaseReturnProcedure
	Prepares, validates, and executes the function "transactions.post_purchase_return(_transaction_master_id bigint, _office_id integer, _user_id integer, _login_id bigint, _value_date date, _store_id integer, _party_code character varying, _price_type_id integer, _reference_number character varying, _statement_reference text, _details transactions.stock_detail_type[], _attachments core.attachment_type[])" on the database. More...

class	PostPurhcaseReorderProcedure
	Prepares, validates, and executes the function "transactions.post_purhcase_reorder(_value_date date, _login_id bigint, _user_id integer, _office_id integer, _details transactions.purchase_reorder_type[])" on the database. More...

class	PostReceiptProcedure
	Prepares, validates, and executes the function "transactions.post_receipt(_user_id integer, _office_id integer, _login_id bigint, _party_code character varying, _currency_code character varying, _amount money_strict, _exchange_rate_debit decimal_strict, _exchange_rate_credit decimal_strict, _reference_number character varying, _statement_reference character varying, _cost_center_id integer, _cash_repository_id integer, _posted_date date, _bank_account_id bigint, _payment_card_id integer, _bank_instrument_code character varying, _bank_tran_code character varying, _cascading_tran_id bigint)" on the database. More...

class	PostRecurringInvoicesProcedure
	Prepares, validates, and executes the function "transactions.post_recurring_invoices(_user_id integer, _login_id bigint, _office_id integer, _value_date date)" on the database. More...

class	PostSalesProcedure
	Prepares, validates, and executes the function "transactions.post_sales(_book_name character varying, _office_id integer, _user_id integer, _login_id bigint, _value_date date, _cost_center_id integer, _reference_number character varying, _statement_reference text, _is_credit boolean, _payment_term_id integer, _party_code character varying, _price_type_id integer, _salesperson_id integer, _shipper_id integer, _shipping_address_code character varying, _store_id integer, _is_non_taxable_sales boolean, _details transactions.stock_detail_type[], _attachments core.attachment_type[], _non_gl_tran_ids bigint[])" on the database. More...

class	PostSalesReturnProcedure
	Prepares, validates, and executes the function "transactions.post_sales_return(_transaction_master_id bigint, _office_id integer, _user_id integer, _login_id bigint, _value_date date, _store_id integer, _party_code character varying, _price_type_id integer, _reference_number character varying, _statement_reference text, _details transactions.stock_detail_type[], _attachments core.attachment_type[])" on the database. More...

class	PostStockAdjustmentProcedure
	Prepares, validates, and executes the function "transactions.post_stock_adjustment(_office_id integer, _user_id integer, _login_id bigint, _value_date date, _reference_number character varying, _statement_reference text, _details transactions.stock_adjustment_type[])" on the database. More...

class	PostStockJournalProcedure
	Prepares, validates, and executes the function "transactions.post_stock_journal(_office_id integer, _user_id integer, _login_id bigint, _value_date date, _reference_number character varying, _statement_reference text, _details transactions.stock_adjustment_type[])" on the database. More...

class	PostStockTransferAcknowledgementProcedure
	Prepares, validates, and executes the function "transactions.post_stock_transfer_acknowledgement(_office_id integer, _user_id integer, _login_id bigint, _request_id bigint)" on the database. More...

class	ReceiptView
	Provides simplified data access features to perform SCRUD operation on the database view "transactions.receipt_view". More...

class	RefreshMaterializedViewsProcedure
	Prepares, validates, and executes the function "transactions.refresh_materialized_views(_user_id integer, _login_id bigint, _office_id integer, _value_date date)" on the database. More...

class	Routine
	Provides simplified data access features to perform SCRUD operation on the database table "transactions.routines". More...

class	SalesByCountryView
	Provides simplified data access features to perform SCRUD operation on the database view "transactions.sales_by_country_view". More...

class	SalesDeliveryView
	Provides simplified data access features to perform SCRUD operation on the database view "transactions.sales_delivery_view". More...

class	SalesOrderView
	Provides simplified data access features to perform SCRUD operation on the database view "transactions.sales_order_view". More...

class	SalesQuotationView
	Provides simplified data access features to perform SCRUD operation on the database view "transactions.sales_quotation_view". More...

class	SettlePartyDueProcedure
	Prepares, validates, and executes the function "transactions.settle_party_due(_party_id bigint, _office_id integer)" on the database. More...

class	StockDetail
	Provides simplified data access features to perform SCRUD operation on the database table "transactions.stock_details". More...

class	StockMaster
	Provides simplified data access features to perform SCRUD operation on the database table "transactions.stock_master". More...

class	StockMasterNonGlRelation
	Provides simplified data access features to perform SCRUD operation on the database table "transactions.stock_master_non_gl_relations". More...

class	StockReturn
	Provides simplified data access features to perform SCRUD operation on the database table "transactions.stock_return". More...

class	StockTaxDetail
	Provides simplified data access features to perform SCRUD operation on the database table "transactions.stock_tax_details". More...

class	StockTransactionView
	Provides simplified data access features to perform SCRUD operation on the database view "transactions.stock_transaction_view". More...

class	TransactionDetail
	Provides simplified data access features to perform SCRUD operation on the database table "transactions.transaction_details". More...

class	TransactionMaster
	Provides simplified data access features to perform SCRUD operation on the database table "transactions.transaction_master". More...

class	TransactionView
	Provides simplified data access features to perform SCRUD operation on the database view "transactions.transaction_view". More...

class	ValidateItemsForReturnProcedure
	Prepares, validates, and executes the function "transactions.validate_items_for_return(_transaction_master_id bigint, _details transactions.stock_detail_type[])" on the database. More...

class	VerifiedStockDetailsView
	Provides simplified data access features to perform SCRUD operation on the database view "transactions.verified_stock_details_view". More...

class	VerifiedTransactionView
	Provides simplified data access features to perform SCRUD operation on the database view "transactions.verified_transaction_view". More...

class	VerifyTransactionProcedure
	Prepares, validates, and executes the function "transactions.verify_transaction(_transaction_master_id bigint, _office_id integer, _user_id integer, _login_id bigint, _verification_status_id smallint, _reason character varying)" on the database. More...

Classes