the transactions from the recently imported bank statements; they should help to identify the other party of the transaction (donor, etc) and the purpose of the transaction More...

Inheritance diagram for Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow:

Public Member Functions
	AEpTransactionRow (System.Data.DataRowBuilder rb)
	Constructor. More...

virtual void	InitValues ()
	set default values More...

bool	IsStatementKeyNull ()
	test for NULL value More...

void	SetStatementKeyNull ()
	assign NULL value More...

bool	IsOrderNull ()
	test for NULL value More...

void	SetOrderNull ()
	assign NULL value More...

bool	IsDetailKeyNull ()
	test for NULL value More...

void	SetDetailKeyNull ()
	assign NULL value More...

bool	IsNumberOnPaperStatementNull ()
	test for NULL value More...

void	SetNumberOnPaperStatementNull ()
	assign NULL value More...

bool	IsMatchTextNull ()
	test for NULL value More...

void	SetMatchTextNull ()
	assign NULL value More...

bool	IsAccountNameNull ()
	test for NULL value More...

void	SetAccountNameNull ()
	assign NULL value More...

bool	IsTitleNull ()
	test for NULL value More...

void	SetTitleNull ()
	assign NULL value More...

bool	IsFirstNameNull ()
	test for NULL value More...

void	SetFirstNameNull ()
	assign NULL value More...

bool	IsMiddleNameNull ()
	test for NULL value More...

void	SetMiddleNameNull ()
	assign NULL value More...

bool	IsLastNameNull ()
	test for NULL value More...

void	SetLastNameNull ()
	assign NULL value More...

bool	IsBranchCodeNull ()
	test for NULL value More...

void	SetBranchCodeNull ()
	assign NULL value More...

bool	IsBicNull ()
	test for NULL value More...

void	SetBicNull ()
	assign NULL value More...

bool	IsBankAccountNumberNull ()
	test for NULL value More...

void	SetBankAccountNumberNull ()
	assign NULL value More...

bool	IsIbanNull ()
	test for NULL value More...

void	SetIbanNull ()
	assign NULL value More...

bool	IsTransactionTypeCodeNull ()
	test for NULL value More...

void	SetTransactionTypeCodeNull ()
	assign NULL value More...

bool	IsTransactionAmountNull ()
	test for NULL value More...

void	SetTransactionAmountNull ()
	assign NULL value More...

bool	IsDescriptionNull ()
	test for NULL value More...

void	SetDescriptionNull ()
	assign NULL value More...

bool	IsDateEffectiveNull ()
	test for NULL value More...

void	SetDateEffectiveNull ()
	assign NULL value More...

bool	IsEpMatchKeyNull ()
	test for NULL value More...

void	SetEpMatchKeyNull ()
	assign NULL value More...

bool	IsDateCreatedNull ()
	test for NULL value More...

void	SetDateCreatedNull ()
	assign NULL value More...

bool	IsCreatedByNull ()
	test for NULL value More...

void	SetCreatedByNull ()
	assign NULL value More...

bool	IsDateModifiedNull ()
	test for NULL value More...

void	SetDateModifiedNull ()
	assign NULL value More...

bool	IsModifiedByNull ()
	test for NULL value More...

void	SetModifiedByNull ()
	assign NULL value More...

bool	IsModificationIdNull ()
	test for NULL value More...

void	SetModificationIdNull ()
	assign NULL value More...

Properties
Int32	StatementKey `[get, set]`
	this transaction belongs to that statement More...

Int32	Order `[get, set]`
	to complete the primary key More...

Int32	DetailKey `[get, set]`
	a transaction can be split in order to support mixed GL and Gift records More...

Int32	NumberOnPaperStatement `[get, set]`
	can be different from order, since the paper statements can have different order than the electronic statement More...

String	MatchText `[get, set]`
	this is a calculated text that uniquely identifies this transaction so that it can be recognised next month. TODO: should have a link table a_ep_match between a_ep_transaction and a_ep_match_detail More...

String	AccountName `[get, set]`
	This can be a summary of title, first name, last name etc. of the other party. More...

String	Title `[get, set]`

String	FirstName `[get, set]`

String	MiddleName `[get, set]`

String	LastName `[get, set]`
	the name of the other party More...

String	BranchCode `[get, set]`
	The bank code/branch code/sort code of the other party. More...

String	Bic `[get, set]`
	BIC (Bank Identifier Code)/SWIFT code of the other party. More...

String	BankAccountNumber `[get, set]`
	The account number in the bank of the other party. More...

String	Iban `[get, set]`
	The IBAN (International Bank Account Number) of the other party. More...

String	TransactionTypeCode `[get, set]`
	This can be recurring income, recurring payment, income, payment, direct debit, etc. More...

Decimal	TransactionAmount `[get, set]`
	The amount in the currency of the bank account. More...

String	Description `[get, set]`
	This description was given when the transfer was initiated. More...

System.DateTime	DateEffective `[get, set]`
	The date when this transaction became valid or available. More...

Int32	EpMatchKey `[get, set]`
	set this value to the match (either new match or set automatically) More...

System.? DateTime	DateCreated `[get, set]`
	The date the record was created. More...

String	CreatedBy `[get, set]`
	User ID of who created this record. More...

System.? DateTime	DateModified `[get, set]`
	The date the record was modified. More...

String	ModifiedBy `[get, set]`
	User ID of who last modified this record. More...

DateTime	ModificationId `[get, set]`
	This identifies the current version of the record. More...

Detailed Description

the transactions from the recently imported bank statements; they should help to identify the other party of the transaction (donor, etc) and the purpose of the transaction

Constructor & Destructor Documentation

◆ AEpTransactionRow()

Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.AEpTransactionRow ( System.Data.DataRowBuilder rb )

inline

Constructor.

Member Function Documentation

◆ InitValues()

virtual void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.InitValues ( )

inlinevirtual

set default values

Reimplemented in Ict.Petra.Shared.MFinance.BankImport.Data.BankImportTDSAEpTransactionRow.

◆ IsAccountNameNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsAccountNameNull ( )

inline

test for NULL value

◆ IsBankAccountNumberNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsBankAccountNumberNull ( )

inline

test for NULL value

◆ IsBicNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsBicNull ( )

inline

test for NULL value

◆ IsBranchCodeNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsBranchCodeNull ( )

inline

test for NULL value

◆ IsCreatedByNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsCreatedByNull ( )

inline

test for NULL value

◆ IsDateCreatedNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsDateCreatedNull ( )

inline

test for NULL value

◆ IsDateEffectiveNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsDateEffectiveNull ( )

inline

test for NULL value

◆ IsDateModifiedNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsDateModifiedNull ( )

inline

test for NULL value

◆ IsDescriptionNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsDescriptionNull ( )

inline

test for NULL value

◆ IsDetailKeyNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsDetailKeyNull ( )

inline

test for NULL value

◆ IsEpMatchKeyNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsEpMatchKeyNull ( )

inline

test for NULL value

◆ IsFirstNameNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsFirstNameNull ( )

inline

test for NULL value

◆ IsIbanNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsIbanNull ( )

inline

test for NULL value

◆ IsLastNameNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsLastNameNull ( )

inline

test for NULL value

◆ IsMatchTextNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsMatchTextNull ( )

inline

test for NULL value

◆ IsMiddleNameNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsMiddleNameNull ( )

inline

test for NULL value

◆ IsModificationIdNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsModificationIdNull ( )

inline

test for NULL value

◆ IsModifiedByNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsModifiedByNull ( )

inline

test for NULL value

◆ IsNumberOnPaperStatementNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsNumberOnPaperStatementNull ( )

inline

test for NULL value

◆ IsOrderNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsOrderNull ( )

inline

test for NULL value

◆ IsStatementKeyNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsStatementKeyNull ( )

inline

test for NULL value

◆ IsTitleNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsTitleNull ( )

inline

test for NULL value

◆ IsTransactionAmountNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsTransactionAmountNull ( )

inline

test for NULL value

◆ IsTransactionTypeCodeNull()

bool Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.IsTransactionTypeCodeNull ( )

inline

test for NULL value

◆ SetAccountNameNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetAccountNameNull ( )

inline

assign NULL value

◆ SetBankAccountNumberNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetBankAccountNumberNull ( )

inline

assign NULL value

◆ SetBicNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetBicNull ( )

inline

assign NULL value

◆ SetBranchCodeNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetBranchCodeNull ( )

inline

assign NULL value

◆ SetCreatedByNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetCreatedByNull ( )

inline

assign NULL value

◆ SetDateCreatedNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetDateCreatedNull ( )

inline

assign NULL value

◆ SetDateEffectiveNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetDateEffectiveNull ( )

inline

assign NULL value

◆ SetDateModifiedNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetDateModifiedNull ( )

inline

assign NULL value

◆ SetDescriptionNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetDescriptionNull ( )

inline

assign NULL value

◆ SetDetailKeyNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetDetailKeyNull ( )

inline

assign NULL value

◆ SetEpMatchKeyNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetEpMatchKeyNull ( )

inline

assign NULL value

◆ SetFirstNameNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetFirstNameNull ( )

inline

assign NULL value

◆ SetIbanNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetIbanNull ( )

inline

assign NULL value

◆ SetLastNameNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetLastNameNull ( )

inline

assign NULL value

◆ SetMatchTextNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetMatchTextNull ( )

inline

assign NULL value

◆ SetMiddleNameNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetMiddleNameNull ( )

inline

assign NULL value

◆ SetModificationIdNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetModificationIdNull ( )

inline

assign NULL value

◆ SetModifiedByNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetModifiedByNull ( )

inline

assign NULL value

◆ SetNumberOnPaperStatementNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetNumberOnPaperStatementNull ( )

inline

assign NULL value

◆ SetOrderNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetOrderNull ( )

inline

assign NULL value

◆ SetStatementKeyNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetStatementKeyNull ( )

inline

assign NULL value

◆ SetTitleNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetTitleNull ( )

inline

assign NULL value

◆ SetTransactionAmountNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetTransactionAmountNull ( )

inline

assign NULL value

◆ SetTransactionTypeCodeNull()

void Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.SetTransactionTypeCodeNull ( )

inline

assign NULL value

Property Documentation

◆ AccountName

String Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.AccountName

getset

This can be a summary of title, first name, last name etc. of the other party.

◆ BankAccountNumber

String Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.BankAccountNumber

getset

The account number in the bank of the other party.

◆ Bic

String Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.Bic

getset

BIC (Bank Identifier Code)/SWIFT code of the other party.

◆ BranchCode

String Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.BranchCode

getset

The bank code/branch code/sort code of the other party.

◆ CreatedBy

String Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.CreatedBy

getset

User ID of who created this record.

◆ DateCreated

System.? DateTime Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.DateCreated

getset

The date the record was created.

◆ DateEffective

System.DateTime Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.DateEffective

getset

The date when this transaction became valid or available.

◆ DateModified

System.? DateTime Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.DateModified

getset

The date the record was modified.

◆ Description

String Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.Description

getset

This description was given when the transfer was initiated.

◆ DetailKey

Int32 Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.DetailKey

getset

a transaction can be split in order to support mixed GL and Gift records

◆ EpMatchKey

Int32 Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.EpMatchKey

getset

set this value to the match (either new match or set automatically)

◆ FirstName

String Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.FirstName

getset

◆ Iban

String Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.Iban

getset

The IBAN (International Bank Account Number) of the other party.

◆ LastName

String Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.LastName

getset

the name of the other party

◆ MatchText

String Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.MatchText

getset

this is a calculated text that uniquely identifies this transaction so that it can be recognised next month. TODO: should have a link table a_ep_match between a_ep_transaction and a_ep_match_detail

◆ MiddleName

String Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.MiddleName

getset

◆ ModificationId

DateTime Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.ModificationId

getset

This identifies the current version of the record.

◆ ModifiedBy

String Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.ModifiedBy

getset

User ID of who last modified this record.

◆ NumberOnPaperStatement

Int32 Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.NumberOnPaperStatement

getset

can be different from order, since the paper statements can have different order than the electronic statement

◆ Order

Int32 Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.Order

getset

to complete the primary key

◆ StatementKey

Int32 Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.StatementKey

getset

this transaction belongs to that statement

◆ Title

String Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.Title

getset

◆ TransactionAmount

Decimal Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.TransactionAmount

getset

The amount in the currency of the bank account.

◆ TransactionTypeCode

String Ict.Petra.Shared.MFinance.Account.Data.AEpTransactionRow.TransactionTypeCode

getset

This can be recurring income, recurring payment, income, payment, direct debit, etc.

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

csharp/ICT/Petra/Shared/lib/data/Account.Tables-generated.cs

Public Member Functions

Properties

Detailed Description

Constructor & Destructor Documentation

◆ AEpTransactionRow()

Member Function Documentation

◆ InitValues()

◆ IsAccountNameNull()

◆ IsBankAccountNumberNull()

◆ IsBicNull()

◆ IsBranchCodeNull()

◆ IsCreatedByNull()

◆ IsDateCreatedNull()

◆ IsDateEffectiveNull()

◆ IsDateModifiedNull()

◆ IsDescriptionNull()

◆ IsDetailKeyNull()

◆ IsEpMatchKeyNull()

◆ IsFirstNameNull()

◆ IsIbanNull()

◆ IsLastNameNull()

◆ IsMatchTextNull()

◆ IsMiddleNameNull()

◆ IsModificationIdNull()

◆ IsModifiedByNull()

◆ IsNumberOnPaperStatementNull()

◆ IsOrderNull()

◆ IsStatementKeyNull()

◆ IsTitleNull()

◆ IsTransactionAmountNull()

◆ IsTransactionTypeCodeNull()

◆ SetAccountNameNull()

◆ SetBankAccountNumberNull()

◆ SetBicNull()

◆ SetBranchCodeNull()

◆ SetCreatedByNull()

◆ SetDateCreatedNull()

◆ SetDateEffectiveNull()

◆ SetDateModifiedNull()

◆ SetDescriptionNull()

◆ SetDetailKeyNull()

◆ SetEpMatchKeyNull()

◆ SetFirstNameNull()

◆ SetIbanNull()

◆ SetLastNameNull()

◆ SetMatchTextNull()

◆ SetMiddleNameNull()

◆ SetModificationIdNull()

◆ SetModifiedByNull()

◆ SetNumberOnPaperStatementNull()

◆ SetOrderNull()

◆ SetStatementKeyNull()

◆ SetTitleNull()

◆ SetTransactionAmountNull()

◆ SetTransactionTypeCodeNull()

Property Documentation

◆ AccountName

◆ BankAccountNumber

◆ Bic

◆ BranchCode

◆ CreatedBy

◆ DateCreated

◆ DateEffective

◆ DateModified

◆ Description

◆ DetailKey

◆ EpMatchKey

◆ FirstName

◆ Iban

◆ LastName

◆ MatchText

◆ MiddleName

◆ ModificationId

◆ ModifiedBy

◆ NumberOnPaperStatement

◆ Order

◆ StatementKey

◆ Title

◆ TransactionAmount

◆ TransactionTypeCode