MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure Class Reference

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

Inheritance diagram for MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure:
PetaPoco.DbAccess PetaPoco.IDBAccess

Public Member Functions

 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...
 
 PostReceiptProcedure (int userId, int officeId, long loginIdParameter, string partyCode, string currencyCode, decimal amount, decimal exchangeRateDebit, decimal exchangeRateCredit, string referenceNumber, string statementReference, int costCenterId, int cashRepositoryId, DateTime postedDate, long bankAccountId, int paymentCardId, string bankInstrumentCode, string bankTranCode, long cascadingTranId)
 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...
 
long Execute ()
 Prepares and executes the function "transactions.post_receipt". More...
 
- Public Member Functions inherited from PetaPoco.DbAccess
void Validate (AccessTypeEnum type, long loginId, bool noException)
 Validates application user access rights to execute the function. More...
 

Public Attributes

override string ObjectNamespace => "transactions"
 The schema of this PostgreSQL function. More...
 
override string ObjectName => "post_receipt"
 The schema unqualified name of this PostgreSQL function. More...
 

Properties

long _LoginId [get, set]
 Login id of application user accessing this PostgreSQL function. More...
 
int _UserId [get, set]
 User id of application user accessing this table. More...
 
string Catalog [get, set]
 The name of the database on which queries are being executed to. More...
 
int UserId [get, set]
 Maps to "_user_id" argument of the function "transactions.post_receipt". More...
 
int OfficeId [get, set]
 Maps to "_office_id" argument of the function "transactions.post_receipt". More...
 
long LoginIdParameter [get, set]
 Maps to "_login_id" argument of the function "transactions.post_receipt". More...
 
string PartyCode [get, set]
 Maps to "_party_code" argument of the function "transactions.post_receipt". More...
 
string CurrencyCode [get, set]
 Maps to "_currency_code" argument of the function "transactions.post_receipt". More...
 
decimal Amount [get, set]
 Maps to "_amount" argument of the function "transactions.post_receipt". More...
 
decimal ExchangeRateDebit [get, set]
 Maps to "_exchange_rate_debit" argument of the function "transactions.post_receipt". More...
 
decimal ExchangeRateCredit [get, set]
 Maps to "_exchange_rate_credit" argument of the function "transactions.post_receipt". More...
 
string ReferenceNumber [get, set]
 Maps to "_reference_number" argument of the function "transactions.post_receipt". More...
 
string StatementReference [get, set]
 Maps to "_statement_reference" argument of the function "transactions.post_receipt". More...
 
int CostCenterId [get, set]
 Maps to "_cost_center_id" argument of the function "transactions.post_receipt". More...
 
int CashRepositoryId [get, set]
 Maps to "_cash_repository_id" argument of the function "transactions.post_receipt". More...
 
DateTime PostedDate [get, set]
 Maps to "_posted_date" argument of the function "transactions.post_receipt". More...
 
long BankAccountId [get, set]
 Maps to "_bank_account_id" argument of the function "transactions.post_receipt". More...
 
int PaymentCardId [get, set]
 Maps to "_payment_card_id" argument of the function "transactions.post_receipt". More...
 
string BankInstrumentCode [get, set]
 Maps to "_bank_instrument_code" argument of the function "transactions.post_receipt". More...
 
string BankTranCode [get, set]
 Maps to "_bank_tran_code" argument of the function "transactions.post_receipt". More...
 
long CascadingTranId [get, set]
 Maps to "_cascading_tran_id" argument of the function "transactions.post_receipt". More...
 
- Properties inherited from PetaPoco.DbAccess
abstract string ObjectNamespace [get]
 
abstract string ObjectName [get]
 
bool HasAccess [get]
 
bool Validated [get]
 
bool SkipValidation [get, set]
 
- Properties inherited from PetaPoco.IDBAccess
bool HasAccess [get]
 

Detailed Description

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.

Constructor & Destructor Documentation

MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.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.

MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.PostReceiptProcedure ( int  userId,
int  officeId,
long  loginIdParameter,
string  partyCode,
string  currencyCode,
decimal  amount,
decimal  exchangeRateDebit,
decimal  exchangeRateCredit,
string  referenceNumber,
string  statementReference,
int  costCenterId,
int  cashRepositoryId,
DateTime  postedDate,
long  bankAccountId,
int  paymentCardId,
string  bankInstrumentCode,
string  bankTranCode,
long  cascadingTranId 
)

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.

Parameters
userIdEnter argument value for "_user_id" parameter of the function "transactions.post_receipt".
officeIdEnter argument value for "_office_id" parameter of the function "transactions.post_receipt".
loginIdParameterEnter argument value for "_login_id" parameter of the function "transactions.post_receipt".
partyCodeEnter argument value for "_party_code" parameter of the function "transactions.post_receipt".
currencyCodeEnter argument value for "_currency_code" parameter of the function "transactions.post_receipt".
amountEnter argument value for "_amount" parameter of the function "transactions.post_receipt".
exchangeRateDebitEnter argument value for "_exchange_rate_debit" parameter of the function "transactions.post_receipt".
exchangeRateCreditEnter argument value for "_exchange_rate_credit" parameter of the function "transactions.post_receipt".
referenceNumberEnter argument value for "_reference_number" parameter of the function "transactions.post_receipt".
statementReferenceEnter argument value for "_statement_reference" parameter of the function "transactions.post_receipt".
costCenterIdEnter argument value for "_cost_center_id" parameter of the function "transactions.post_receipt".
cashRepositoryIdEnter argument value for "_cash_repository_id" parameter of the function "transactions.post_receipt".
postedDateEnter argument value for "_posted_date" parameter of the function "transactions.post_receipt".
bankAccountIdEnter argument value for "_bank_account_id" parameter of the function "transactions.post_receipt".
paymentCardIdEnter argument value for "_payment_card_id" parameter of the function "transactions.post_receipt".
bankInstrumentCodeEnter argument value for "_bank_instrument_code" parameter of the function "transactions.post_receipt".
bankTranCodeEnter argument value for "_bank_tran_code" parameter of the function "transactions.post_receipt".
cascadingTranIdEnter argument value for "_cascading_tran_id" parameter of the function "transactions.post_receipt".

Member Function Documentation

long MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.Execute ( )

Prepares and executes the function "transactions.post_receipt".

Member Data Documentation

override string MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.ObjectName => "post_receipt"

The schema unqualified name of this PostgreSQL function.

override string MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.ObjectNamespace => "transactions"

The schema of this PostgreSQL function.

Property Documentation

long MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure._LoginId
getset

Login id of application user accessing this PostgreSQL function.

int MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure._UserId
getset

User id of application user accessing this table.

decimal MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.Amount
getset

Maps to "_amount" argument of the function "transactions.post_receipt".

long MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.BankAccountId
getset

Maps to "_bank_account_id" argument of the function "transactions.post_receipt".

string MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.BankInstrumentCode
getset

Maps to "_bank_instrument_code" argument of the function "transactions.post_receipt".

string MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.BankTranCode
getset

Maps to "_bank_tran_code" argument of the function "transactions.post_receipt".

long MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.CascadingTranId
getset

Maps to "_cascading_tran_id" argument of the function "transactions.post_receipt".

int MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.CashRepositoryId
getset

Maps to "_cash_repository_id" argument of the function "transactions.post_receipt".

string MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.Catalog
getset

The name of the database on which queries are being executed to.

int MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.CostCenterId
getset

Maps to "_cost_center_id" argument of the function "transactions.post_receipt".

string MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.CurrencyCode
getset

Maps to "_currency_code" argument of the function "transactions.post_receipt".

decimal MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.ExchangeRateCredit
getset

Maps to "_exchange_rate_credit" argument of the function "transactions.post_receipt".

decimal MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.ExchangeRateDebit
getset

Maps to "_exchange_rate_debit" argument of the function "transactions.post_receipt".

long MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.LoginIdParameter
getset

Maps to "_login_id" argument of the function "transactions.post_receipt".

int MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.OfficeId
getset

Maps to "_office_id" argument of the function "transactions.post_receipt".

string MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.PartyCode
getset

Maps to "_party_code" argument of the function "transactions.post_receipt".

int MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.PaymentCardId
getset

Maps to "_payment_card_id" argument of the function "transactions.post_receipt".

DateTime MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.PostedDate
getset

Maps to "_posted_date" argument of the function "transactions.post_receipt".

string MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.ReferenceNumber
getset

Maps to "_reference_number" argument of the function "transactions.post_receipt".

string MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.StatementReference
getset

Maps to "_statement_reference" argument of the function "transactions.post_receipt".

int MixERP.Net.Schemas.Transactions.Data.PostReceiptProcedure.UserId
getset

Maps to "_user_id" argument of the function "transactions.post_receipt".


The documentation for this class was generated from the following file: