Public Member Functions |
Static Public Member Functions |
Public Attributes |
Static Public Attributes |
Protected Member Functions |
Static Protected Attributes |
Properties |
List of all members
Ict.Petra.Shared.MFinance.BankImport.Data.BankImportTDSTransactionDetailTable Class Reference
the matches that can be used to identify recurring gift or GL transactions More...
Inheritance diagram for Ict.Petra.Shared.MFinance.BankImport.Data.BankImportTDSTransactionDetailTable:
Public Member Functions | |
| BankImportTDSTransactionDetailTable () | |
| constructor More... | |
| BankImportTDSTransactionDetailTable (string ATablename) | |
| constructor More... | |
| BankImportTDSTransactionDetailTable (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 BankImportTDSTransactionDetailRow | NewRowTyped (bool AWithDefaultValues) |
| create a new typed row More... | |
| new BankImportTDSTransactionDetailRow | NewRowTyped () |
| create a new typed row, always with default values More... | |
| new BankImportTDSTransactionDetailTable | 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 | GetStatementKeyDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetStatementKeyLength () |
| get character length for column More... | |
| static string | GetStatementKeyHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetOrderDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetOrderLength () |
| get character length for column More... | |
| static string | GetOrderHelp () |
| 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 | GetEpMatchKeyDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetEpMatchKeyLength () |
| get character length for column More... | |
| static string | GetEpMatchKeyHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetMatchTextDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetMatchTextLength () |
| get character length for column More... | |
| static string | GetMatchTextHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetDetailDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetDetailLength () |
| get character length for column More... | |
| static string | GetDetailHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetActionDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetActionLength () |
| get character length for column More... | |
| static string | GetActionHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetRecentMatchDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetRecentMatchLength () |
| get character length for column More... | |
| static string | GetRecentMatchHelp () |
| get the help text for the field in the database for this 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 | 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 | 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 | 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 | 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 | GetHomeAdminChargesFlagDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetHomeAdminChargesFlagLength () |
| get character length for column More... | |
| static string | GetHomeAdminChargesFlagHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetIltAdminChargesFlagDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetIltAdminChargesFlagLength () |
| get character length for column More... | |
| static string | GetIltAdminChargesFlagHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetReceiptLetterCodeDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetReceiptLetterCodeLength () |
| get character length for column More... | |
| static string | GetReceiptLetterCodeHelp () |
| 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 | 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 | GetAdminChargeDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetAdminChargeLength () |
| get character length for column More... | |
| static string | GetAdminChargeHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetNarrativeDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetNarrativeLength () |
| get character length for column More... | |
| static string | GetNarrativeHelp () |
| 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 | GetDonorShortNameDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetDonorShortNameLength () |
| get character length for column More... | |
| static string | GetDonorShortNameHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetRecipientShortNameDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetRecipientShortNameLength () |
| get character length for column More... | |
| static string | GetRecipientShortNameHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetRestrictedDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetRestrictedLength () |
| get character length for column More... | |
| static string | GetRestrictedHelp () |
| 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 | GetKeyMinistryKeyDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetKeyMinistryKeyLength () |
| get character length for column More... | |
| static string | GetKeyMinistryKeyHelp () |
| 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 | ColumnStatementKey |
| this transaction belongs to that statement More... | |
| DataColumn | ColumnOrder |
| to complete the primary key More... | |
| 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 | ColumnEpMatchKey |
| this is a sequence to easily identify which transaction has been matched and how More... | |
| DataColumn | ColumnMatchText |
| this is a separated list of all the recurring details of a_ep_transaction (ie. name, bank account, sort code, IBAN, amount, description) More... | |
| DataColumn | ColumnDetail |
| the match can be applied to split gifts as well More... | |
| DataColumn | ColumnAction |
| What to do with this match: gift, GL, or discard. More... | |
| DataColumn | ColumnRecentMatch |
| The date when this match was recently applied; useful for purging old entries. More... | |
| DataColumn | ColumnLedgerNumber |
| The four digit ledger number of the gift. 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 | 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 deductaible. 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 | 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 | ColumnGiftTransactionAmount |
| This is a number of currency units in the entered Currency. More... | |
| DataColumn | ColumnHomeAdminChargesFlag |
| Used to get a yes no response from the user. More... | |
| DataColumn | ColumnIltAdminChargesFlag |
| Used to get a yes no response from the user. More... | |
| DataColumn | ColumnReceiptLetterCode |
| DataColumn | ColumnMethodOfGivingCode |
| Defines how a gift is given. More... | |
| DataColumn | ColumnMethodOfPaymentCode |
| This is how the partner paid. Eg cash, Cheque etc. More... | |
| DataColumn | ColumnDonorKey |
| This is the partner key of the donor. More... | |
| DataColumn | ColumnAdminCharge |
| NOT USED AT ALL. More... | |
| DataColumn | ColumnNarrative |
| DataColumn | ColumnReference |
| Reference number/code for the transaction. More... | |
| DataColumn | ColumnDonorShortName |
| short name of the donor; will be used for generating export files More... | |
| DataColumn | ColumnRecipientShortName |
| short name of recipient More... | |
| DataColumn | ColumnRestricted |
| Indicates whether or not the gift has restricted access. If it does then the access will be controlled by s_group_gift. More... | |
| DataColumn | ColumnAccountCode |
| This identifies the account the financial transaction must be stored against. More... | |
| DataColumn | ColumnKeyMinistryKey |
| Key ministry to which this transaction applies (just for fund transfers) 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 = 65 |
| TableId for Ict.Common.Data generic functions. More... | |
| static readonly short | ColumnStatementKeyId = 41 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnOrderId = 42 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnMembershipId = 43 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnSponsorshipId = 44 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnWorkerSupportId = 45 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnEpMatchKeyId = 0 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnMatchTextId = 1 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnDetailId = 2 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnActionId = 3 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnRecentMatchId = 4 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnLedgerNumberId = 5 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnRecipientLedgerNumberId = 6 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnMotivationGroupCodeId = 7 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnMotivationDetailCodeId = 8 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnCommentOneTypeId = 9 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnGiftCommentOneId = 10 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnConfidentialGiftFlagId = 11 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnTaxDeductibleId = 12 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnRecipientKeyId = 13 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnChargeFlagId = 14 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnCostCentreCodeId = 15 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnMailingCodeId = 16 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnCommentTwoTypeId = 17 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnGiftCommentTwoId = 18 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnCommentThreeTypeId = 19 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnGiftCommentThreeId = 20 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnGiftTransactionAmountId = 21 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnHomeAdminChargesFlagId = 22 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnIltAdminChargesFlagId = 23 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnReceiptLetterCodeId = 24 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnMethodOfGivingCodeId = 25 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnMethodOfPaymentCodeId = 26 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnDonorKeyId = 27 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnAdminChargeId = 28 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnNarrativeId = 29 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnReferenceId = 30 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnDonorShortNameId = 31 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnRecipientShortNameId = 32 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnRestrictedId = 33 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnAccountCodeId = 34 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnKeyMinistryKeyId = 35 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnDateCreatedId = 36 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnCreatedById = 37 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnDateModifiedId = 38 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnModifiedById = 39 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnModificationIdId = 40 |
| 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 BankImportTDSTransactionDetailRow | 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 matches that can be used to identify recurring gift or GL transactions
Constructor & Destructor Documentation
◆ BankImportTDSTransactionDetailTable() [1/3]
|
inline |
constructor
◆ BankImportTDSTransactionDetailTable() [2/3]
|
inline |
constructor
◆ BankImportTDSTransactionDetailTable() [3/3]
|
inline |
constructor for serialization
Member Function Documentation
◆ CreateOdbcParameter() [1/3]
|
inlinevirtual |
get an odbc parameter for the given column
Reimplemented from Ict.Petra.Shared.MFinance.Account.Data.AEpMatchTable.
◆ CreateOdbcParameter() [2/3]
|
inlinestaticinherited |
create an odbc parameter for the given column
◆ CreateOdbcParameter() [3/3]
|
inlinestaticinherited |
create an odbc parameter for the given column
◆ GetAccountCodeDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetAccountCodeHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetAccountCodeLength()
|
inlinestaticinherited |
get character length for column
◆ GetActionDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetActionHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetActionLength()
|
inlinestaticinherited |
get character length for column
◆ GetAdminChargeDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetAdminChargeHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetAdminChargeLength()
|
inlinestaticinherited |
get character length for column
◆ GetChanges()
|
inlineinherited |
make sure that we use GetChangesType instead of GetChanges
- Returns
- throws an exception
◆ GetChangesTyped()
|
inline |
get typed set of changes
◆ GetChangesTypedInternal()
|
inlineinherited |
our own version of GetChanges
- Returns
- returns a typed table with the changes
◆ GetChargeFlagDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetChargeFlagHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetChargeFlagLength()
|
inlinestaticinherited |
get character length for column
◆ GetColumnNameSQL()
|
inlinestaticinherited |
the column name as it is in the SQL database
◆ GetColumnStringList()
|
inlinestaticinherited |
get the names of the columns in this table
◆ GetCommentOneTypeDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetCommentOneTypeHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetCommentOneTypeLength()
|
inlinestaticinherited |
get character length for column
◆ GetCommentThreeTypeDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetCommentThreeTypeHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetCommentThreeTypeLength()
|
inlinestaticinherited |
get character length for column
◆ GetCommentTwoTypeDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetCommentTwoTypeHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetCommentTwoTypeLength()
|
inlinestaticinherited |
get character length for column
◆ GetConfidentialGiftFlagDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetConfidentialGiftFlagHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetConfidentialGiftFlagLength()
|
inlinestaticinherited |
get character length for column
◆ GetCostCentreCodeDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetCostCentreCodeHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetCostCentreCodeLength()
|
inlinestaticinherited |
get character length for column
◆ GetCreatedByDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetCreatedByHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetCreatedByLength()
|
inlinestaticinherited |
get character length for column
◆ GetCustomReportFieldList()
|
inlinevirtualinherited |
Return a list of fields that are available for custom reports
◆ GetCustomReportPermission()
|
inlinevirtualinherited |
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
◆ GetDateCreatedDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetDateCreatedHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetDateCreatedLength()
|
inlinestaticinherited |
get character length for column
◆ GetDateModifiedDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetDateModifiedHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetDateModifiedLength()
|
inlinestaticinherited |
get character length for column
◆ GetDetailDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetDetailHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetDetailLength()
|
inlinestaticinherited |
get character length for column
◆ GetDonorKeyDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetDonorKeyHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetDonorKeyLength()
|
inlinestaticinherited |
get character length for column
◆ GetDonorShortNameDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetDonorShortNameHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetDonorShortNameLength()
|
inlinestaticinherited |
get character length for column
◆ GetEpMatchKeyDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetEpMatchKeyHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetEpMatchKeyLength()
|
inlinestaticinherited |
get character length for column
◆ GetGiftCommentOneDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetGiftCommentOneHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetGiftCommentOneLength()
|
inlinestaticinherited |
get character length for column
◆ GetGiftCommentThreeDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetGiftCommentThreeHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetGiftCommentThreeLength()
|
inlinestaticinherited |
get character length for column
◆ GetGiftCommentTwoDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetGiftCommentTwoHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetGiftCommentTwoLength()
|
inlinestaticinherited |
get character length for column
◆ GetGiftTransactionAmountDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetGiftTransactionAmountHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetGiftTransactionAmountLength()
|
inlinestaticinherited |
get character length for column
◆ GetHomeAdminChargesFlagDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetHomeAdminChargesFlagHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetHomeAdminChargesFlagLength()
|
inlinestaticinherited |
get character length for column
◆ GetIltAdminChargesFlagDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetIltAdminChargesFlagHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetIltAdminChargesFlagLength()
|
inlinestaticinherited |
get character length for column
◆ GetKeyColumnStringList()
|
inlinestaticinherited |
get the names of the columns that are part of the key
◆ GetKeyMinistryKeyDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetKeyMinistryKeyHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetKeyMinistryKeyLength()
|
inlinestaticinherited |
get character length for column
◆ GetLabel()
|
inlinestaticinherited |
returns the translated label for the column
◆ GetLedgerNumberDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetLedgerNumberHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetLedgerNumberLength()
|
inlinestaticinherited |
get character length for column
◆ GetLength() [1/2]
|
inlinestaticinherited |
get the maximum length for the field
◆ GetLength() [2/2]
|
inlinestaticinherited |
get the maximum length for the field
◆ GetMailingCodeDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetMailingCodeHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetMailingCodeLength()
|
inlinestaticinherited |
get character length for column
◆ GetMatchTextDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetMatchTextHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetMatchTextLength()
|
inlinestaticinherited |
get character length for column
◆ GetMembershipDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetMembershipHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetMembershipLength()
|
inlinestatic |
get character length for column
◆ GetMethodOfGivingCodeDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetMethodOfGivingCodeHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetMethodOfGivingCodeLength()
|
inlinestaticinherited |
get character length for column
◆ GetMethodOfPaymentCodeDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetMethodOfPaymentCodeHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetMethodOfPaymentCodeLength()
|
inlinestaticinherited |
get character length for column
◆ GetModificationIdDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetModificationIdHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetModificationIdLength()
|
inlinestaticinherited |
get character length for column
◆ GetModifiedByDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetModifiedByHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetModifiedByLength()
|
inlinestaticinherited |
get character length for column
◆ GetMotivationDetailCodeDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetMotivationDetailCodeHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetMotivationDetailCodeLength()
|
inlinestaticinherited |
get character length for column
◆ GetMotivationGroupCodeDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetMotivationGroupCodeHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetMotivationGroupCodeLength()
|
inlinestaticinherited |
get character length for column
◆ GetNarrativeDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetNarrativeHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetNarrativeLength()
|
inlinestaticinherited |
get character length for column
◆ GetOrderDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetOrderHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetOrderLength()
|
inlinestatic |
get character length for column
◆ GetPrimaryKeyColumnOrdList()
|
inlinestaticinherited |
get the order number of the columns that are part of the primary key
◆ GetPrimaryKeyColumnStringList()
|
inlinestaticinherited |
get the names of the columns that are part of the primary key
◆ GetReceiptLetterCodeDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetReceiptLetterCodeHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetReceiptLetterCodeLength()
|
inlinestaticinherited |
get character length for column
◆ GetRecentMatchDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetRecentMatchHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetRecentMatchLength()
|
inlinestaticinherited |
get character length for column
◆ GetRecipientKeyDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetRecipientKeyHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetRecipientKeyLength()
|
inlinestaticinherited |
get character length for column
◆ GetRecipientLedgerNumberDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetRecipientLedgerNumberHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetRecipientLedgerNumberLength()
|
inlinestaticinherited |
get character length for column
◆ GetRecipientShortNameDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetRecipientShortNameHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetRecipientShortNameLength()
|
inlinestaticinherited |
get character length for column
◆ GetReferenceDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetReferenceHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetReferenceLength()
|
inlinestaticinherited |
get character length for column
◆ GetRestrictedDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetRestrictedHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetRestrictedLength()
|
inlinestaticinherited |
get character length for column
◆ GetSponsorshipDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetSponsorshipHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetSponsorshipLength()
|
inlinestatic |
get character length for column
◆ GetStatementKeyDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetStatementKeyHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetStatementKeyLength()
|
inlinestatic |
get character length for column
◆ GetTableByName()
|
inlinestaticinherited |
the table name in CamelCase
◆ GetTableDBLabel()
|
inlinestatic |
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)
◆ GetTableDBName()
|
inlinestatic |
return the name of the table as it is used in the database
◆ GetTableName() [1/2]
|
inlinestatic |
return the CamelCase name of the table
◆ GetTableName() [2/2]
|
inlinestaticinherited |
the table name in CamelCase
◆ GetTableNameSQL()
|
inlinestaticinherited |
the table name as it is in the SQL database
◆ GetTaxDeductibleDBName()
|
inlinestaticinherited |
get the name of the field in the database for this column
◆ GetTaxDeductibleHelp()
|
inlinestaticinherited |
get the help text for the field in the database for this column
◆ GetTaxDeductibleLength()
|
inlinestaticinherited |
get character length for column
◆ GetUniqueKeyColumnOrdList()
|
inlinestaticinherited |
get the order number of the columns that are part of a unique key
◆ GetUniqueKeyColumnStringList()
|
inlinestaticinherited |
get the names of the columns that are part of the unique key
◆ GetWorkerSupportDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetWorkerSupportHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetWorkerSupportLength()
|
inlinestatic |
get character length for column
◆ InitClass()
|
inlineprotectedvirtual |
create the columns
Reimplemented from Ict.Petra.Shared.MFinance.Account.Data.AEpMatchTable.
◆ InitVars()
|
inlinevirtual |
assign columns to properties, set primary key
Reimplemented from Ict.Petra.Shared.MFinance.Account.Data.AEpMatchTable.
◆ IsAvailableForCustomReport()
|
inlinevirtualinherited |
Is this table generally available in custom reports?
◆ NewRowFromBuilder()
|
inlineprotected |
new typed row using DataRowBuilder
◆ NewRowTyped() [1/2]
|
inline |
create a new typed row, always with default values
◆ NewRowTyped() [2/2]
|
inline |
create a new typed row
◆ RemoveColumnsNotInTableTemplate()
|
inlineinherited |
remove columns that are not needed
- Parameters
-
ATableTemplate this table only contains the columns that should be kept
◆ ResetStaticVariables()
|
inlinestaticinherited |
reset the static variables for each Web Request call.
Member Data Documentation
◆ ColumnAccountCode
|
inherited |
This identifies the account the financial transaction must be stored against.
◆ ColumnAccountCodeId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnAction
|
inherited |
What to do with this match: gift, GL, or discard.
◆ ColumnActionId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnAdminCharge
|
inherited |
NOT USED AT ALL.
◆ ColumnAdminChargeId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnChargeFlag
|
inherited |
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.
◆ ColumnChargeFlagId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnCommentOneType
|
inherited |
Used to decide whose reports will see this comment.
◆ ColumnCommentOneTypeId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnCommentThreeType
|
inherited |
Used to decide whose reports will see this comment.
◆ ColumnCommentThreeTypeId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnCommentTwoType
|
inherited |
Used to decide whose reports will see this comment.
◆ ColumnCommentTwoTypeId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnConfidentialGiftFlag
|
inherited |
Defines whether the donor wishes the recipient to know who gave the gift.
◆ ColumnConfidentialGiftFlagId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnCostCentreCode
|
inherited |
This identifies which cost centre an account is applied to. A cost centre can be a partner.
◆ ColumnCostCentreCodeId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnCreatedBy
|
inherited |
User ID of who created this record.
◆ ColumnCreatedById
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnDateCreated
|
inherited |
The date the record was created.
◆ ColumnDateCreatedId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnDateModified
|
inherited |
The date the record was modified.
◆ ColumnDateModifiedId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnDetail
|
inherited |
the match can be applied to split gifts as well
◆ ColumnDetailId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnDonorKey
|
inherited |
This is the partner key of the donor.
◆ ColumnDonorKeyId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnDonorShortName
|
inherited |
short name of the donor; will be used for generating export files
◆ ColumnDonorShortNameId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnEpMatchKey
|
inherited |
this is a sequence to easily identify which transaction has been matched and how
◆ ColumnEpMatchKeyId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnGiftCommentOne
|
inherited |
This is a long description and is 80 characters long.
◆ ColumnGiftCommentOneId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnGiftCommentThree
|
inherited |
This is a long description and is 80 characters long.
◆ ColumnGiftCommentThreeId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnGiftCommentTwo
|
inherited |
This is a long description and is 80 characters long.
◆ ColumnGiftCommentTwoId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnGiftTransactionAmount
|
inherited |
This is a number of currency units in the entered Currency.
◆ ColumnGiftTransactionAmountId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnHomeAdminChargesFlag
|
inherited |
Used to get a yes no response from the user.
◆ ColumnHomeAdminChargesFlagId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnIltAdminChargesFlag
|
inherited |
Used to get a yes no response from the user.
◆ ColumnIltAdminChargesFlagId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnKeyMinistryKey
|
inherited |
Key ministry to which this transaction applies (just for fund transfers)
◆ ColumnKeyMinistryKeyId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnLedgerNumber
|
inherited |
The four digit ledger number of the gift.
◆ ColumnLedgerNumberId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnMailingCode
|
inherited |
Mailing Code of the mailing that the gift was a response to.
◆ ColumnMailingCodeId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnMatchText
|
inherited |
this is a separated list of all the recurring details of a_ep_transaction (ie. name, bank account, sort code, IBAN, amount, description)
◆ ColumnMatchTextId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnMembership
| DataColumn Ict.Petra.Shared.MFinance.BankImport.Data.BankImportTDSTransactionDetailTable.ColumnMembership |
Indicates whether or not the motivation is for paying a membership. The recipient key should be used.
◆ ColumnMembershipId
|
static |
used for generic TTypedDataTable functions
◆ ColumnMethodOfGivingCode
|
inherited |
Defines how a gift is given.
◆ ColumnMethodOfGivingCodeId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnMethodOfPaymentCode
|
inherited |
This is how the partner paid. Eg cash, Cheque etc.
◆ ColumnMethodOfPaymentCodeId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnModificationId
|
inherited |
This identifies the current version of the record.
◆ ColumnModificationIdId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnModifiedBy
|
inherited |
User ID of who last modified this record.
◆ ColumnModifiedById
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnMotivationDetailCode
|
inherited |
This defines the motivation detail within a motivation group.
◆ ColumnMotivationDetailCodeId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnMotivationGroupCode
|
inherited |
This defines a motivation group.
◆ ColumnMotivationGroupCodeId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnNarrative
|
inherited |
◆ ColumnNarrativeId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnOrder
| DataColumn Ict.Petra.Shared.MFinance.BankImport.Data.BankImportTDSTransactionDetailTable.ColumnOrder |
to complete the primary key
◆ ColumnOrderId
|
static |
used for generic TTypedDataTable functions
◆ ColumnReceiptLetterCode
|
inherited |
◆ ColumnReceiptLetterCodeId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnRecentMatch
|
inherited |
The date when this match was recently applied; useful for purging old entries.
◆ ColumnRecentMatchId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnRecipientKey
|
inherited |
The partner key of the recipient of the gift.
◆ ColumnRecipientKeyId
|
staticinherited |
used for generic TTypedDataTable functions
◆ 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
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnRecipientShortName
|
inherited |
short name of recipient
◆ ColumnRecipientShortNameId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnReference
|
inherited |
Reference number/code for the transaction.
◆ ColumnReferenceId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnRestricted
|
inherited |
Indicates whether or not the gift has restricted access. If it does then the access will be controlled by s_group_gift.
◆ ColumnRestrictedId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnSponsorship
| DataColumn Ict.Petra.Shared.MFinance.BankImport.Data.BankImportTDSTransactionDetailTable.ColumnSponsorship |
Indicates whether or not the motivation is for a paying a sponsorship. The recipient key might be used.
◆ ColumnSponsorshipId
|
static |
used for generic TTypedDataTable functions
◆ ColumnStatementKey
| DataColumn Ict.Petra.Shared.MFinance.BankImport.Data.BankImportTDSTransactionDetailTable.ColumnStatementKey |
this transaction belongs to that statement
◆ ColumnStatementKeyId
|
static |
used for generic TTypedDataTable functions
◆ ColumnTaxDeductible
|
inherited |
Whether this gift is tax deductaible.
◆ ColumnTaxDeductibleId
|
staticinherited |
used for generic TTypedDataTable functions
◆ ColumnWorkerSupport
| DataColumn Ict.Petra.Shared.MFinance.BankImport.Data.BankImportTDSTransactionDetailTable.ColumnWorkerSupport |
Indicates whether or not the motivation is for supporting a worker. The recipient key must be used.
◆ ColumnWorkerSupportId
|
static |
used for generic TTypedDataTable functions
◆ DontThrowAwayAfterSubmitChanges
|
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
|
static |
TableId for Ict.Common.Data generic functions.
◆ TableInfo
|
staticprotectedinherited |
stores information about typed tables
◆ ThrowAwayAfterSubmitChanges
|
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
|
getinherited |
the number of rows in the current table
◆ 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]
|
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.BankImport.DataSets-generated.cs
