The gift recipient information for a gift. A single gift can be split among more than one recipient. A gift detail record is created for each recipient. More...

Inheritance diagram for Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable:

Public Member Functions
	GiftBatchTDSAGiftDetailTable ()
	constructor More...

	GiftBatchTDSAGiftDetailTable (string ATablename)
	constructor More...

	GiftBatchTDSAGiftDetailTable (System.Runtime.Serialization.SerializationInfo info, System.Runtime.Serialization.StreamingContext context)
	constructor for serialization More...

override void	InitVars ()
	assign columns to properties, set primary key More...

new GiftBatchTDSAGiftDetailRow	NewRowTyped (bool AWithDefaultValues)
	create a new typed row More...

new GiftBatchTDSAGiftDetailRow	NewRowTyped ()
	create a new typed row, always with default values More...

new GiftBatchTDSAGiftDetailTable	GetChangesTyped ()
	get typed set of changes More...

override OdbcParameter	CreateOdbcParameter (Int32 AColumnNr)
	get an odbc parameter for the given column More...

new DataTable	GetChanges ()
	make sure that we use GetChangesType instead of GetChanges More...

virtual string	GetCustomReportPermission ()
	string to indicate which permissions a user needs to access table for custom reports (e.g. "PTNRUSER", "OR(FINANCE-1,DEVUSER)", "AND(PTNRUSER,FINANCE-1)" This should be returned by method in derived class More...

virtual bool	IsAvailableForCustomReport ()
	Is this table generally available in custom reports? More...

virtual List< String >	GetCustomReportFieldList ()
	Return a list of fields that are available for custom reports More...

DataTable	GetChangesTypedInternal ()
	our own version of GetChanges More...

void	RemoveColumnsNotInTableTemplate (DataTable ATableTemplate)
	remove columns that are not needed More...

Static Public Member Functions
static new string	GetTableName ()
	return the CamelCase name of the table More...

static new string	GetTableDBName ()
	return the name of the table as it is used in the database More...

static new string	GetTableDBLabel ()
	static method to return the 'Label' of the table as it is used in the database (the 'Label' is usually a short description of what the db table is about) More...

static string	GetDonorKeyDBName ()
	get the name of the field in the database for this column More...

static short	GetDonorKeyLength ()
	get character length for column More...

static string	GetDonorKeyHelp ()
	get the help text for the field in the database for this column More...

static string	GetDonorNameDBName ()
	get the name of the field in the database for this column More...

static short	GetDonorNameLength ()
	get character length for column More...

static string	GetDonorNameHelp ()
	get the help text for the field in the database for this column More...

static string	GetDonorClassDBName ()
	get the name of the field in the database for this column More...

static short	GetDonorClassLength ()
	get character length for column More...

static string	GetDonorClassHelp ()
	get the help text for the field in the database for this column More...

static string	GetDateEnteredDBName ()
	get the name of the field in the database for this column More...

static short	GetDateEnteredLength ()
	get character length for column More...

static string	GetDateEnteredHelp ()
	get the help text for the field in the database for this column More...

static string	GetRecipientDescriptionDBName ()
	get the name of the field in the database for this column More...

static short	GetRecipientDescriptionLength ()
	get character length for column More...

static string	GetRecipientDescriptionHelp ()
	get the help text for the field in the database for this column More...

static string	GetRecipientFieldDBName ()
	get the name of the field in the database for this column More...

static short	GetRecipientFieldLength ()
	get character length for column More...

static string	GetRecipientFieldHelp ()
	get the help text for the field in the database for this column More...

static string	GetRecipientKeyMinistryDBName ()
	get the name of the field in the database for this column More...

static short	GetRecipientKeyMinistryLength ()
	get character length for column More...

static string	GetRecipientKeyMinistryHelp ()
	get the help text for the field in the database for this column More...

static string	GetRecipientClassDBName ()
	get the name of the field in the database for this column More...

static short	GetRecipientClassLength ()
	get character length for column More...

static string	GetRecipientClassHelp ()
	get the help text for the field in the database for this column More...

static string	GetReceiptNumberDBName ()
	get the name of the field in the database for this column More...

static short	GetReceiptNumberLength ()
	get character length for column More...

static string	GetReceiptNumberHelp ()
	get the help text for the field in the database for this column More...

static string	GetReceiptPrintedDBName ()
	get the name of the field in the database for this column More...

static short	GetReceiptPrintedLength ()
	get character length for column More...

static string	GetReceiptPrintedHelp ()
	get the help text for the field in the database for this column More...

static string	GetMethodOfGivingCodeDBName ()
	get the name of the field in the database for this column More...

static short	GetMethodOfGivingCodeLength ()
	get character length for column More...

static string	GetMethodOfGivingCodeHelp ()
	get the help text for the field in the database for this column More...

static string	GetMethodOfPaymentCodeDBName ()
	get the name of the field in the database for this column More...

static short	GetMethodOfPaymentCodeLength ()
	get character length for column More...

static string	GetMethodOfPaymentCodeHelp ()
	get the help text for the field in the database for this column More...

static string	GetReferenceDBName ()
	get the name of the field in the database for this column More...

static short	GetReferenceLength ()
	get character length for column More...

static string	GetReferenceHelp ()
	get the help text for the field in the database for this column More...

static string	GetMembershipDBName ()
	get the name of the field in the database for this column More...

static short	GetMembershipLength ()
	get character length for column More...

static string	GetMembershipHelp ()
	get the help text for the field in the database for this column More...

static string	GetSponsorshipDBName ()
	get the name of the field in the database for this column More...

static short	GetSponsorshipLength ()
	get character length for column More...

static string	GetSponsorshipHelp ()
	get the help text for the field in the database for this column More...

static string	GetWorkerSupportDBName ()
	get the name of the field in the database for this column More...

static short	GetWorkerSupportLength ()
	get character length for column More...

static string	GetWorkerSupportHelp ()
	get the help text for the field in the database for this column More...

static string	GetTableName (short ATableNumber)
	the table name in CamelCase More...

static OdbcParameter	CreateOdbcParameter (short ATableNumber, TSearchCriteria ASearchCriteria)
	create an odbc parameter for the given column More...

static OdbcParameter	CreateOdbcParameter (short ATableNumber, Int32 AColumnNr)
	create an odbc parameter for the given column More...

static string	GetLedgerNumberDBName ()
	get the name of the field in the database for this column More...

static short	GetLedgerNumberLength ()
	get character length for column More...

static string	GetLedgerNumberHelp ()
	get the help text for the field in the database for this column More...

static string	GetBatchNumberDBName ()
	get the name of the field in the database for this column More...

static short	GetBatchNumberLength ()
	get character length for column More...

static string	GetBatchNumberHelp ()
	get the help text for the field in the database for this column More...

static string	GetGiftTransactionNumberDBName ()
	get the name of the field in the database for this column More...

static short	GetGiftTransactionNumberLength ()
	get character length for column More...

static string	GetGiftTransactionNumberHelp ()
	get the help text for the field in the database for this column More...

static string	GetDetailNumberDBName ()
	get the name of the field in the database for this column More...

static short	GetDetailNumberLength ()
	get character length for column More...

static string	GetDetailNumberHelp ()
	get the help text for the field in the database for this column More...

static string	GetRecipientLedgerNumberDBName ()
	get the name of the field in the database for this column More...

static short	GetRecipientLedgerNumberLength ()
	get character length for column More...

static string	GetRecipientLedgerNumberHelp ()
	get the help text for the field in the database for this column More...

static string	GetGiftAmountDBName ()
	get the name of the field in the database for this column More...

static short	GetGiftAmountLength ()
	get character length for column More...

static string	GetGiftAmountHelp ()
	get the help text for the field in the database for this column More...

static string	GetMotivationGroupCodeDBName ()
	get the name of the field in the database for this column More...

static short	GetMotivationGroupCodeLength ()
	get character length for column More...

static string	GetMotivationGroupCodeHelp ()
	get the help text for the field in the database for this column More...

static string	GetMotivationDetailCodeDBName ()
	get the name of the field in the database for this column More...

static short	GetMotivationDetailCodeLength ()
	get character length for column More...

static string	GetMotivationDetailCodeHelp ()
	get the help text for the field in the database for this column More...

static string	GetCommentOneTypeDBName ()
	get the name of the field in the database for this column More...

static short	GetCommentOneTypeLength ()
	get character length for column More...

static string	GetCommentOneTypeHelp ()
	get the help text for the field in the database for this column More...

static string	GetGiftCommentOneDBName ()
	get the name of the field in the database for this column More...

static short	GetGiftCommentOneLength ()
	get character length for column More...

static string	GetGiftCommentOneHelp ()
	get the help text for the field in the database for this column More...

static string	GetConfidentialGiftFlagDBName ()
	get the name of the field in the database for this column More...

static short	GetConfidentialGiftFlagLength ()
	get character length for column More...

static string	GetConfidentialGiftFlagHelp ()
	get the help text for the field in the database for this column More...

static string	GetTaxDeductibleDBName ()
	get the name of the field in the database for this column More...

static short	GetTaxDeductibleLength ()
	get character length for column More...

static string	GetTaxDeductibleHelp ()
	get the help text for the field in the database for this column More...

static string	GetRecipientKeyDBName ()
	get the name of the field in the database for this column More...

static short	GetRecipientKeyLength ()
	get character length for column More...

static string	GetRecipientKeyHelp ()
	get the help text for the field in the database for this column More...

static string	GetChargeFlagDBName ()
	get the name of the field in the database for this column More...

static short	GetChargeFlagLength ()
	get character length for column More...

static string	GetChargeFlagHelp ()
	get the help text for the field in the database for this column More...

static string	GetCostCentreCodeDBName ()
	get the name of the field in the database for this column More...

static short	GetCostCentreCodeLength ()
	get character length for column More...

static string	GetCostCentreCodeHelp ()
	get the help text for the field in the database for this column More...

static string	GetAccountCodeDBName ()
	get the name of the field in the database for this column More...

static short	GetAccountCodeLength ()
	get character length for column More...

static string	GetAccountCodeHelp ()
	get the help text for the field in the database for this column More...

static string	GetGiftAmountIntlDBName ()
	get the name of the field in the database for this column More...

static short	GetGiftAmountIntlLength ()
	get character length for column More...

static string	GetGiftAmountIntlHelp ()
	get the help text for the field in the database for this column More...

static string	GetModifiedDetailDBName ()
	get the name of the field in the database for this column More...

static short	GetModifiedDetailLength ()
	get character length for column More...

static string	GetModifiedDetailHelp ()
	get the help text for the field in the database for this column More...

static string	GetModifiedDetailKeyDBName ()
	get the name of the field in the database for this column More...

static short	GetModifiedDetailKeyLength ()
	get character length for column More...

static string	GetModifiedDetailKeyHelp ()
	get the help text for the field in the database for this column More...

static string	GetFixedGiftDestinationDBName ()
	get the name of the field in the database for this column More...

static short	GetFixedGiftDestinationLength ()
	get character length for column More...

static string	GetFixedGiftDestinationHelp ()
	get the help text for the field in the database for this column More...

static string	GetGiftTransactionAmountDBName ()
	get the name of the field in the database for this column More...

static short	GetGiftTransactionAmountLength ()
	get character length for column More...

static string	GetGiftTransactionAmountHelp ()
	get the help text for the field in the database for this column More...

static string	GetIchNumberDBName ()
	get the name of the field in the database for this column More...

static short	GetIchNumberLength ()
	get character length for column More...

static string	GetIchNumberHelp ()
	get the help text for the field in the database for this column More...

static string	GetMailingCodeDBName ()
	get the name of the field in the database for this column More...

static short	GetMailingCodeLength ()
	get character length for column More...

static string	GetMailingCodeHelp ()
	get the help text for the field in the database for this column More...

static string	GetCommentTwoTypeDBName ()
	get the name of the field in the database for this column More...

static short	GetCommentTwoTypeLength ()
	get character length for column More...

static string	GetCommentTwoTypeHelp ()
	get the help text for the field in the database for this column More...

static string	GetGiftCommentTwoDBName ()
	get the name of the field in the database for this column More...

static short	GetGiftCommentTwoLength ()
	get character length for column More...

static string	GetGiftCommentTwoHelp ()
	get the help text for the field in the database for this column More...

static string	GetCommentThreeTypeDBName ()
	get the name of the field in the database for this column More...

static short	GetCommentThreeTypeLength ()
	get character length for column More...

static string	GetCommentThreeTypeHelp ()
	get the help text for the field in the database for this column More...

static string	GetGiftCommentThreeDBName ()
	get the name of the field in the database for this column More...

static short	GetGiftCommentThreeLength ()
	get character length for column More...

static string	GetGiftCommentThreeHelp ()
	get the help text for the field in the database for this column More...

static string	GetTaxDeductibleAccountCodeDBName ()
	get the name of the field in the database for this column More...

static short	GetTaxDeductibleAccountCodeLength ()
	get character length for column More...

static string	GetTaxDeductibleAccountCodeHelp ()
	get the help text for the field in the database for this column More...

static string	GetTaxDeductiblePctDBName ()
	get the name of the field in the database for this column More...

static short	GetTaxDeductiblePctLength ()
	get character length for column More...

static string	GetTaxDeductiblePctHelp ()
	get the help text for the field in the database for this column More...

static string	GetTaxDeductibleAmountDBName ()
	get the name of the field in the database for this column More...

static short	GetTaxDeductibleAmountLength ()
	get character length for column More...

static string	GetTaxDeductibleAmountHelp ()
	get the help text for the field in the database for this column More...

static string	GetTaxDeductibleAmountBaseDBName ()
	get the name of the field in the database for this column More...

static short	GetTaxDeductibleAmountBaseLength ()
	get character length for column More...

static string	GetTaxDeductibleAmountBaseHelp ()
	get the help text for the field in the database for this column More...

static string	GetTaxDeductibleAmountIntlDBName ()
	get the name of the field in the database for this column More...

static short	GetTaxDeductibleAmountIntlLength ()
	get character length for column More...

static string	GetTaxDeductibleAmountIntlHelp ()
	get the help text for the field in the database for this column More...

static string	GetNonDeductibleAmountDBName ()
	get the name of the field in the database for this column More...

static short	GetNonDeductibleAmountLength ()
	get character length for column More...

static string	GetNonDeductibleAmountHelp ()
	get the help text for the field in the database for this column More...

static string	GetNonDeductibleAmountBaseDBName ()
	get the name of the field in the database for this column More...

static short	GetNonDeductibleAmountBaseLength ()
	get character length for column More...

static string	GetNonDeductibleAmountBaseHelp ()
	get the help text for the field in the database for this column More...

static string	GetNonDeductibleAmountIntlDBName ()
	get the name of the field in the database for this column More...

static short	GetNonDeductibleAmountIntlLength ()
	get character length for column More...

static string	GetNonDeductibleAmountIntlHelp ()
	get the help text for the field in the database for this column More...

static string	GetDateCreatedDBName ()
	get the name of the field in the database for this column More...

static short	GetDateCreatedLength ()
	get character length for column More...

static string	GetDateCreatedHelp ()
	get the help text for the field in the database for this column More...

static string	GetCreatedByDBName ()
	get the name of the field in the database for this column More...

static short	GetCreatedByLength ()
	get character length for column More...

static string	GetCreatedByHelp ()
	get the help text for the field in the database for this column More...

static string	GetDateModifiedDBName ()
	get the name of the field in the database for this column More...

static short	GetDateModifiedLength ()
	get character length for column More...

static string	GetDateModifiedHelp ()
	get the help text for the field in the database for this column More...

static string	GetModifiedByDBName ()
	get the name of the field in the database for this column More...

static short	GetModifiedByLength ()
	get character length for column More...

static string	GetModifiedByHelp ()
	get the help text for the field in the database for this column More...

static string	GetModificationIdDBName ()
	get the name of the field in the database for this column More...

static short	GetModificationIdLength ()
	get character length for column More...

static string	GetModificationIdHelp ()
	get the help text for the field in the database for this column More...

static void	ResetStaticVariables ()
	reset the static variables for each Web Request call. More...

static string	GetTableNameSQL (short ATableNumber)
	the table name as it is in the SQL database More...

static TTypedTableInfo	GetTableByName (string ATableName)
	the table name in CamelCase More...

static string	GetColumnNameSQL (short ATableNumber, short AColumnNr)
	the column name as it is in the SQL database More...

static string	GetLabel (short ATableNumber, short AColumnNr)
	returns the translated label for the column More...

static Int32	GetLength (short ATableNumber, short AColumnNr)
	get the maximum length for the field More...

static Int32	GetLength (string ATableName, string AColumnName)
	get the maximum length for the field More...

static string[]	GetKeyColumnStringList (short ATableNumber, int[] AKeyColumnsOrder)
	get the names of the columns that are part of the key More...

static string[]	GetPrimaryKeyColumnStringList (short ATableNumber)
	get the names of the columns that are part of the primary key More...

static string[]	GetUniqueKeyColumnStringList (short ATableNumber)
	get the names of the columns that are part of the unique key More...

static int[]	GetPrimaryKeyColumnOrdList (short ATableNumber)
	get the order number of the columns that are part of the primary key More...

static int[]	GetUniqueKeyColumnOrdList (short ATableNumber)
	get the order number of the columns that are part of a unique key More...

static string[]	GetColumnStringList (short ATableNumber)
	get the names of the columns in this table More...

Public Attributes
DataColumn	ColumnDonorKey

DataColumn	ColumnDonorName

DataColumn	ColumnDonorClass

DataColumn	ColumnDateEntered

DataColumn	ColumnRecipientDescription

DataColumn	ColumnRecipientField

DataColumn	ColumnRecipientKeyMinistry

DataColumn	ColumnRecipientClass

DataColumn	ColumnReceiptNumber

DataColumn	ColumnReceiptPrinted

DataColumn	ColumnMethodOfGivingCode

DataColumn	ColumnMethodOfPaymentCode

DataColumn	ColumnReference

DataColumn	ColumnMembership
	Indicates whether or not the motivation is for paying a membership. The recipient key should be used. More...

DataColumn	ColumnSponsorship
	Indicates whether or not the motivation is for a paying a sponsorship. The recipient key might be used. More...

DataColumn	ColumnWorkerSupport
	Indicates whether or not the motivation is for supporting a worker. The recipient key must be used. More...

DataColumn	ColumnLedgerNumber
	The four digit ledger number of the gift. More...

DataColumn	ColumnBatchNumber
	Number of the gift batch containing this detail. More...

DataColumn	ColumnGiftTransactionNumber
	Identifies a gift transaction within a gift batch. More...

DataColumn	ColumnDetailNumber
	Identifies a gift detail within a gift transaction. When a donor gives a donation to multiple recipients (a split gift), a gift detail record is created for each recipient. More...

DataColumn	ColumnRecipientLedgerNumber
	The partner key of the commitment field (the unit) of the recipient of the gift. This is not the ledger number but rather the partner key of the unit associated with the ledger. More...

DataColumn	ColumnGiftAmount
	This is a number of currency units of the ledger base currency. More...

DataColumn	ColumnMotivationGroupCode
	This defines a motivation group. More...

DataColumn	ColumnMotivationDetailCode
	This defines the motivation detail within a motivation group. More...

DataColumn	ColumnCommentOneType
	Used to decide whose reports will see this comment. More...

DataColumn	ColumnGiftCommentOne
	This is a long description and is 80 characters long. More...

DataColumn	ColumnConfidentialGiftFlag
	Defines whether the donor wishes the recipient to know who gave the gift. More...

DataColumn	ColumnTaxDeductible
	Whether this gift is tax deductible. More...

DataColumn	ColumnRecipientKey
	The partner key of the recipient of the gift. More...

DataColumn	ColumnChargeFlag
	To determine whether an admin fee on the transaction should be overwritten if it normally has a charge associated with it. Used for both local and ilt transaction. More...

DataColumn	ColumnCostCentreCode
	This identifies which cost centre an account is applied to. A cost centre can be a partner. More...

DataColumn	ColumnAccountCode
	This identifies the account the financial transaction must be stored against. More...

DataColumn	ColumnGiftAmountIntl
	This is a number of currency units in the International Currency. More...

DataColumn	ColumnModifiedDetail
	Indicates whether this gift detail has a matching inverse detail record because a modification was made. More...

DataColumn	ColumnModifiedDetailKey
	Stores the concatenated primary key fields of the originating gift detail, of which this gift detail is the inverse. More...

DataColumn	ColumnFixedGiftDestination
	Indicates whether this gift detail's gift destination can be changed. Used for gift adjustments with family recipients. More...

DataColumn	ColumnGiftTransactionAmount
	This is a number of currency units in the entered Currency. More...

DataColumn	ColumnIchNumber
	identifes the ICH process number More...

DataColumn	ColumnMailingCode
	Mailing Code of the mailing that the gift was a response to. More...

DataColumn	ColumnCommentTwoType
	Used to decide whose reports will see this comment. More...

DataColumn	ColumnGiftCommentTwo
	This is a long description and is 80 characters long. More...

DataColumn	ColumnCommentThreeType
	Used to decide whose reports will see this comment. More...

DataColumn	ColumnGiftCommentThree
	This is a long description and is 80 characters long. More...

DataColumn	ColumnTaxDeductibleAccountCode
	Account Code to be used for the Tax deductible portion of this Gift. More...

DataColumn	ColumnTaxDeductiblePct
	Percentage of gift amount that is tax-deductible. More...

DataColumn	ColumnTaxDeductibleAmount
	Tax deductible portion of gift. More...

DataColumn	ColumnTaxDeductibleAmountBase
	Tax deductible portion of gift (Base Currency) More...

DataColumn	ColumnTaxDeductibleAmountIntl
	Tax deductible portion of gift (Intl Currency) More...

DataColumn	ColumnNonDeductibleAmount
	Non tax-deductible portion of gift. More...

DataColumn	ColumnNonDeductibleAmountBase
	Non tax-deductible portion of gift (Base Currency) More...

DataColumn	ColumnNonDeductibleAmountIntl
	Non tax-deductible portion of gift (Intl Currency) More...

DataColumn	ColumnDateCreated
	The date the record was created. More...

DataColumn	ColumnCreatedBy
	User ID of who created this record. More...

DataColumn	ColumnDateModified
	The date the record was modified. More...

DataColumn	ColumnModifiedBy
	User ID of who last modified this record. More...

DataColumn	ColumnModificationId
	This identifies the current version of the record. More...

bool	ThrowAwayAfterSubmitChanges = false
	if you want the datatable to be cleared after submitchanges. This will increase the speed significantly: no updating of modificationID, no slow AcceptChanges. More...

bool	DontThrowAwayAfterSubmitChanges = false
	if you want no warning about that the datatable should be cleared after submitchanges. in some cases you must keep the data, eg when you need the new keys after INSERT More...

Static Public Attributes
static new readonly short	TableId = 160
	TableId for Ict.Common.Data generic functions. More...

static readonly short	ColumnDonorKeyId = 40
	used for generic TTypedDataTable functions More...

static readonly short	ColumnDonorNameId = 41
	used for generic TTypedDataTable functions More...

static readonly short	ColumnDonorClassId = 42
	used for generic TTypedDataTable functions More...

static readonly short	ColumnDateEnteredId = 43
	used for generic TTypedDataTable functions More...

static readonly short	ColumnRecipientDescriptionId = 44
	used for generic TTypedDataTable functions More...

static readonly short	ColumnRecipientFieldId = 45
	used for generic TTypedDataTable functions More...

static readonly short	ColumnRecipientKeyMinistryId = 46
	used for generic TTypedDataTable functions More...

static readonly short	ColumnRecipientClassId = 47
	used for generic TTypedDataTable functions More...

static readonly short	ColumnReceiptNumberId = 48
	used for generic TTypedDataTable functions More...

static readonly short	ColumnReceiptPrintedId = 49
	used for generic TTypedDataTable functions More...

static readonly short	ColumnMethodOfGivingCodeId = 50
	used for generic TTypedDataTable functions More...

static readonly short	ColumnMethodOfPaymentCodeId = 51
	used for generic TTypedDataTable functions More...

static readonly short	ColumnReferenceId = 52
	used for generic TTypedDataTable functions More...

static readonly short	ColumnMembershipId = 53
	used for generic TTypedDataTable functions More...

static readonly short	ColumnSponsorshipId = 54
	used for generic TTypedDataTable functions More...

static readonly short	ColumnWorkerSupportId = 55
	used for generic TTypedDataTable functions More...

static readonly short	ColumnLedgerNumberId = 0
	used for generic TTypedDataTable functions More...

static readonly short	ColumnBatchNumberId = 1
	used for generic TTypedDataTable functions More...

static readonly short	ColumnGiftTransactionNumberId = 2
	used for generic TTypedDataTable functions More...

static readonly short	ColumnDetailNumberId = 3
	used for generic TTypedDataTable functions More...

static readonly short	ColumnRecipientLedgerNumberId = 4
	used for generic TTypedDataTable functions More...

static readonly short	ColumnGiftAmountId = 5
	used for generic TTypedDataTable functions More...

static readonly short	ColumnMotivationGroupCodeId = 6
	used for generic TTypedDataTable functions More...

static readonly short	ColumnMotivationDetailCodeId = 7
	used for generic TTypedDataTable functions More...

static readonly short	ColumnCommentOneTypeId = 8
	used for generic TTypedDataTable functions More...

static readonly short	ColumnGiftCommentOneId = 9
	used for generic TTypedDataTable functions More...

static readonly short	ColumnConfidentialGiftFlagId = 10
	used for generic TTypedDataTable functions More...

static readonly short	ColumnTaxDeductibleId = 11
	used for generic TTypedDataTable functions More...

static readonly short	ColumnRecipientKeyId = 12
	used for generic TTypedDataTable functions More...

static readonly short	ColumnChargeFlagId = 13
	used for generic TTypedDataTable functions More...

static readonly short	ColumnCostCentreCodeId = 14
	used for generic TTypedDataTable functions More...

static readonly short	ColumnAccountCodeId = 15
	used for generic TTypedDataTable functions More...

static readonly short	ColumnGiftAmountIntlId = 16
	used for generic TTypedDataTable functions More...

static readonly short	ColumnModifiedDetailId = 17
	used for generic TTypedDataTable functions More...

static readonly short	ColumnModifiedDetailKeyId = 18
	used for generic TTypedDataTable functions More...

static readonly short	ColumnFixedGiftDestinationId = 19
	used for generic TTypedDataTable functions More...

static readonly short	ColumnGiftTransactionAmountId = 20
	used for generic TTypedDataTable functions More...

static readonly short	ColumnIchNumberId = 21
	used for generic TTypedDataTable functions More...

static readonly short	ColumnMailingCodeId = 22
	used for generic TTypedDataTable functions More...

static readonly short	ColumnCommentTwoTypeId = 23
	used for generic TTypedDataTable functions More...

static readonly short	ColumnGiftCommentTwoId = 24
	used for generic TTypedDataTable functions More...

static readonly short	ColumnCommentThreeTypeId = 25
	used for generic TTypedDataTable functions More...

static readonly short	ColumnGiftCommentThreeId = 26
	used for generic TTypedDataTable functions More...

static readonly short	ColumnTaxDeductibleAccountCodeId = 27
	used for generic TTypedDataTable functions More...

static readonly short	ColumnTaxDeductiblePctId = 28
	used for generic TTypedDataTable functions More...

static readonly short	ColumnTaxDeductibleAmountId = 29
	used for generic TTypedDataTable functions More...

static readonly short	ColumnTaxDeductibleAmountBaseId = 30
	used for generic TTypedDataTable functions More...

static readonly short	ColumnTaxDeductibleAmountIntlId = 31
	used for generic TTypedDataTable functions More...

static readonly short	ColumnNonDeductibleAmountId = 32
	used for generic TTypedDataTable functions More...

static readonly short	ColumnNonDeductibleAmountBaseId = 33
	used for generic TTypedDataTable functions More...

static readonly short	ColumnNonDeductibleAmountIntlId = 34
	used for generic TTypedDataTable functions More...

static readonly short	ColumnDateCreatedId = 35
	used for generic TTypedDataTable functions More...

static readonly short	ColumnCreatedById = 36
	used for generic TTypedDataTable functions More...

static readonly short	ColumnDateModifiedId = 37
	used for generic TTypedDataTable functions More...

static readonly short	ColumnModifiedById = 38
	used for generic TTypedDataTable functions More...

static readonly short	ColumnModificationIdId = 39
	used for generic TTypedDataTable functions More...

Protected Member Functions
override void	InitClass ()
	create the columns More...

override System.Data.DataRow	NewRowFromBuilder (System.Data.DataRowBuilder builder)
	new typed row using DataRowBuilder More...

Static Protected Attributes
static SortedList< short, TTypedTableInfo >	TableInfo = new SortedList <short, TTypedTableInfo>()
	stores information about typed tables More...

Properties
new GiftBatchTDSAGiftDetailRow	this[int i] `[get]`
	Access a typed row by index. More...

override string	TableDBLabel `[get]`
	instance property to get the 'Label' of the table as it is used in the database (the 'Label' is usually a short description of what the db table is about) More...

int	Count `[get]`
	the number of rows in the current table More...

Detailed Description

The gift recipient information for a gift. A single gift can be split among more than one recipient. A gift detail record is created for each recipient.

Constructor & Destructor Documentation

◆ GiftBatchTDSAGiftDetailTable() [1/3]

Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.GiftBatchTDSAGiftDetailTable ( )

inline

constructor

◆ GiftBatchTDSAGiftDetailTable() [2/3]

Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.GiftBatchTDSAGiftDetailTable ( string ATablename )

inline

constructor

◆ GiftBatchTDSAGiftDetailTable() [3/3]

Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.GiftBatchTDSAGiftDetailTable	(	System.Runtime.Serialization.SerializationInfo	info,
		System.Runtime.Serialization.StreamingContext	context
	)

inline

constructor for serialization

Member Function Documentation

◆ CreateOdbcParameter() [1/3]

override OdbcParameter Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.CreateOdbcParameter ( Int32 AColumnNr )

inlinevirtual

get an odbc parameter for the given column

Implements Ict.Common.Data.TTypedDataTable.

◆ CreateOdbcParameter() [2/3]

static OdbcParameter Ict.Common.Data.TTypedDataTable.CreateOdbcParameter	(	short	ATableNumber,
		Int32	AColumnNr
	)

inlinestaticinherited

create an odbc parameter for the given column

◆ CreateOdbcParameter() [3/3]

static OdbcParameter Ict.Common.Data.TTypedDataTable.CreateOdbcParameter	(	short	ATableNumber,
		TSearchCriteria	ASearchCriteria
	)

inlinestaticinherited

get character length for column

◆ GetChanges()

new DataTable Ict.Common.Data.TTypedDataTable.GetChanges ( )

inlineinherited

make sure that we use GetChangesType instead of GetChanges

Returns: throws an exception

◆ GetChangesTyped()

new GiftBatchTDSAGiftDetailTable Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.GetChangesTyped ( )

inline

get typed set of changes

◆ GetChangesTypedInternal()

DataTable Ict.Common.Data.TTypedDataTable.GetChangesTypedInternal ( )

inlineinherited

our own version of GetChanges

Returns: returns a typed table with the changes

◆ GetLength() [1/2]

static Int32 Ict.Common.Data.TTypedDataTable.GetLength	(	short	ATableNumber,
		short	AColumnNr
	)

inlinestaticinherited

get the maximum length for the field

◆ GetLength() [2/2]

static Int32 Ict.Common.Data.TTypedDataTable.GetLength	(	string	ATableName,
		string	AColumnName
	)

inlinestatic

get the help text for the field in the database for this column

◆ GetWorkerSupportLength()

static short Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.GetWorkerSupportLength ( )

inlinestatic

get character length for column

◆ InitClass()

override void Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.InitClass ( )

inlineprotectedvirtual

create the columns

Implements Ict.Common.Data.TTypedDataTable.

◆ InitVars()

override void Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.InitVars ( )

inlinevirtual

assign columns to properties, set primary key

Implements Ict.Common.Data.TTypedDataTable.

◆ IsAvailableForCustomReport()

virtual bool Ict.Common.Data.TTypedDataTable.IsAvailableForCustomReport ( )

inlinevirtualinherited

Is this table generally available in custom reports?

◆ NewRowFromBuilder()

override System.Data.DataRow Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.NewRowFromBuilder ( System.Data.DataRowBuilder builder )

inlineprotected

new typed row using DataRowBuilder

◆ NewRowTyped() [1/2]

new GiftBatchTDSAGiftDetailRow Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.NewRowTyped ( )

inline

create a new typed row, always with default values

◆ NewRowTyped() [2/2]

new GiftBatchTDSAGiftDetailRow Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.NewRowTyped ( bool AWithDefaultValues )

inline

create a new typed row

◆ RemoveColumnsNotInTableTemplate()

void Ict.Common.Data.TTypedDataTable.RemoveColumnsNotInTableTemplate ( DataTable ATableTemplate )

inlineinherited

remove columns that are not needed

Parameters

ATableTemplate this table only contains the columns that should be kept

◆ ResetStaticVariables()

static void Ict.Common.Data.TTypedDataTable.ResetStaticVariables ( )

DataColumn Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.ColumnDateEntered

◆ ColumnDateEnteredId

readonly short Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.ColumnDateEnteredId = 43

static

used for generic TTypedDataTable functions

◆ ColumnDateModified

DataColumn Ict.Petra.Shared.MFinance.Gift.Data.AGiftDetailTable.ColumnDateModified

inherited

The date the record was modified.

◆ ColumnDateModifiedId

readonly short Ict.Petra.Shared.MFinance.Gift.Data.AGiftDetailTable.ColumnDateModifiedId = 37

staticinherited

used for generic TTypedDataTable functions

◆ ColumnDetailNumber

DataColumn Ict.Petra.Shared.MFinance.Gift.Data.AGiftDetailTable.ColumnDetailNumber

inherited

Identifies a gift detail within a gift transaction. When a donor gives a donation to multiple recipients (a split gift), a gift detail record is created for each recipient.

◆ ColumnDetailNumberId

readonly short Ict.Petra.Shared.MFinance.Gift.Data.AGiftDetailTable.ColumnDetailNumberId = 3

staticinherited

used for generic TTypedDataTable functions

◆ ColumnDonorClass

DataColumn Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.ColumnDonorClass

◆ ColumnDonorClassId

readonly short Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.ColumnDonorClassId = 42

static

used for generic TTypedDataTable functions

◆ ColumnDonorKey

DataColumn Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.ColumnDonorKey

◆ ColumnDonorKeyId

readonly short Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.ColumnDonorKeyId = 40

static

DataColumn Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.ColumnMembership

Indicates whether or not the motivation is for paying a membership. The recipient key should be used.

◆ ColumnMembershipId

readonly short Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.ColumnMembershipId = 53

static

used for generic TTypedDataTable functions

◆ ColumnMethodOfGivingCode

DataColumn Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.ColumnMethodOfGivingCode

◆ ColumnMethodOfGivingCodeId

readonly short Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.ColumnMethodOfGivingCodeId = 50

static

DataColumn Ict.Petra.Shared.MFinance.Gift.Data.AGiftDetailTable.ColumnRecipientKey

inherited

The partner key of the recipient of the gift.

◆ ColumnRecipientKeyId

readonly short Ict.Petra.Shared.MFinance.Gift.Data.AGiftDetailTable.ColumnRecipientKeyId = 12

staticinherited

used for generic TTypedDataTable functions

◆ ColumnRecipientKeyMinistry

DataColumn Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.ColumnRecipientKeyMinistry

◆ ColumnRecipientKeyMinistryId

readonly short Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.ColumnRecipientKeyMinistryId = 46

static

used for generic TTypedDataTable functions

◆ ColumnRecipientLedgerNumber

DataColumn Ict.Petra.Shared.MFinance.Gift.Data.AGiftDetailTable.ColumnRecipientLedgerNumber

inherited

The partner key of the commitment field (the unit) of the recipient of the gift. This is not the ledger number but rather the partner key of the unit associated with the ledger.

◆ ColumnRecipientLedgerNumberId

readonly short Ict.Petra.Shared.MFinance.Gift.Data.AGiftDetailTable.ColumnRecipientLedgerNumberId = 4

staticinherited

used for generic TTypedDataTable functions

◆ ColumnReference

DataColumn Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.ColumnReference

◆ ColumnReferenceId

readonly short Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.ColumnReferenceId = 52

static

used for generic TTypedDataTable functions

DataColumn Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.ColumnWorkerSupport

Indicates whether or not the motivation is for supporting a worker. The recipient key must be used.

◆ ColumnWorkerSupportId

readonly short Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.ColumnWorkerSupportId = 55

static

used for generic TTypedDataTable functions

◆ DontThrowAwayAfterSubmitChanges

bool Ict.Common.Data.TTypedDataTable.DontThrowAwayAfterSubmitChanges = false

inherited

if you want no warning about that the datatable should be cleared after submitchanges. in some cases you must keep the data, eg when you need the new keys after INSERT

◆ TableId

new readonly short Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.TableId = 160

static

TableId for Ict.Common.Data generic functions.

◆ TableInfo

SortedList<short, TTypedTableInfo> Ict.Common.Data.TTypedDataTable.TableInfo = new SortedList <short, TTypedTableInfo>()

staticprotectedinherited

stores information about typed tables

◆ ThrowAwayAfterSubmitChanges

bool Ict.Common.Data.TTypedDataTable.ThrowAwayAfterSubmitChanges = false

inherited

if you want the datatable to be cleared after submitchanges. This will increase the speed significantly: no updating of modificationID, no slow AcceptChanges.

Property Documentation

◆ Count

int Ict.Common.Data.TTypedDataTable.Count

getinherited

the number of rows in the current table

◆ TableDBLabel

override string Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.TableDBLabel

get

instance property to get the 'Label' of the table as it is used in the database (the 'Label' is usually a short description of what the db table is about)

◆ this[int i]

new GiftBatchTDSAGiftDetailRow Ict.Petra.Shared.MFinance.Gift.Data.GiftBatchTDSAGiftDetailTable.this[int i]

get

Access a typed row by index.

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

csharp/ICT/Petra/Shared/lib/data/Finance.Gift.DataSets-generated.cs

Public Member Functions

Static Public Member Functions

Public Attributes

Static Public Attributes

Protected Member Functions

Static Protected Attributes

Properties

Detailed Description

Constructor & Destructor Documentation

◆ GiftBatchTDSAGiftDetailTable() [1/3]

◆ GiftBatchTDSAGiftDetailTable() [2/3]

◆ GiftBatchTDSAGiftDetailTable() [3/3]

Member Function Documentation

◆ CreateOdbcParameter() [1/3]

◆ CreateOdbcParameter() [2/3]

◆ CreateOdbcParameter() [3/3]

◆ GetAccountCodeDBName()

◆ GetAccountCodeHelp()

◆ GetAccountCodeLength()

◆ GetBatchNumberDBName()

◆ GetBatchNumberHelp()

◆ GetBatchNumberLength()

◆ GetChanges()

◆ GetChangesTyped()

◆ GetChangesTypedInternal()

◆ GetChargeFlagDBName()

◆ GetChargeFlagHelp()

◆ GetChargeFlagLength()

◆ GetColumnNameSQL()

◆ GetColumnStringList()

◆ GetCommentOneTypeDBName()

◆ GetCommentOneTypeHelp()

◆ GetCommentOneTypeLength()

◆ GetCommentThreeTypeDBName()

◆ GetCommentThreeTypeHelp()

◆ GetCommentThreeTypeLength()

◆ GetCommentTwoTypeDBName()

◆ GetCommentTwoTypeHelp()

◆ GetCommentTwoTypeLength()

◆ GetConfidentialGiftFlagDBName()

◆ GetConfidentialGiftFlagHelp()

◆ GetConfidentialGiftFlagLength()

◆ GetCostCentreCodeDBName()

◆ GetCostCentreCodeHelp()

◆ GetCostCentreCodeLength()

◆ GetCreatedByDBName()

◆ GetCreatedByHelp()

◆ GetCreatedByLength()

◆ GetCustomReportFieldList()

◆ GetCustomReportPermission()

◆ GetDateCreatedDBName()

◆ GetDateCreatedHelp()

◆ GetDateCreatedLength()

◆ GetDateEnteredDBName()

◆ GetDateEnteredHelp()

◆ GetDateEnteredLength()

◆ GetDateModifiedDBName()

◆ GetDateModifiedHelp()

◆ GetDateModifiedLength()

◆ GetDetailNumberDBName()

◆ GetDetailNumberHelp()

◆ GetDetailNumberLength()

◆ GetDonorClassDBName()

◆ GetDonorClassHelp()

◆ GetDonorClassLength()

◆ GetDonorKeyDBName()

◆ GetDonorKeyHelp()

◆ GetDonorKeyLength()

◆ GetDonorNameDBName()

◆ GetDonorNameHelp()

◆ GetDonorNameLength()

◆ GetFixedGiftDestinationDBName()

◆ GetFixedGiftDestinationHelp()

◆ GetFixedGiftDestinationLength()

◆ GetGiftAmountDBName()

◆ GetGiftAmountHelp()

◆ GetGiftAmountIntlDBName()

◆ GetGiftAmountIntlHelp()

◆ GetGiftAmountIntlLength()

◆ GetGiftAmountLength()