- Generated on Tue Jun 3 2025 00:24:10 for OpenPetra by
1.9.4
|
OpenPetra
Free Administration Software for Non-Profits
|
| ▼NGenerateGlue | |
| CGenerateServerGlue | generate the code for the server |
| ▼NGenerateI18N | |
| CTDropUnwantedStrings | drop unwanted strings from the po file |
| CTGenerateCatalogStrings | Use all Text properties from the designer file and add Catalog.SetString in the constructor |
| CTGenerateErrorCodeDoc | Parse the code for Error Codes and store to HTML file |
| CTPoFileParser | parse a gettext po file |
| ▼NGenerateSharedCode | |
| CCreateInterfaces | create the interfaces for the shared code |
| CTCollectConnectorInterfaces | parse the code and collect all connector classes that we want to publish in the API |
| ▼NGenerateSQL | |
| CTLoadMysql | initialise the database |
| CTWriteSQL | This class will write the SQL create table statements and other SQL statements using the datadefinitionn from the xml file |
| ▼NGuidedTranslation | |
| CItemWithDerivates | contains the item string with and without additional characters and all its derivates |
| COriginalItem | contains one original String, string without additional characters and its source location |
| CTProcessPot | process the pot file for double items |
| ▼NIct | |
| ►NCommon | |
| ►NConversion | |
| CTDate | Performs Date conversions that are needed both on Server and Client side. |
| ►NData | |
| ►NExceptions | |
| CEDBConcurrencyException | Thrown by classes in the DataStore if the record that is beeing written to the DB has modifications by another user. |
| CEDBConcurrencyNoRowToUpdateException | Specialisation of EDBConcurrencyException - this is thrown if a record should be updated, but it isn't in the DB! |
| CEDBSubmitException | Raised when a Database INSERT, UPDATE or DELETE query that was issued by the DataStore failed, or if it is to be issued and the DataStore determines that it cannot be issued for some reason. |
| CEOPDBTypedDataAccessException | Base Class for OpenPetra-specific data access-level and database-level Exceptions that are thrown by the Typed Data Access class, TTypedDataAccess. |
| ►NTesting | |
| CTTestCommonData | This is a testing program for Ict.Common.Data.dll |
| CDataSetAdapter | Helper methods and functions. |
| ►CDataUtilities | Contains Utility functions for ADO.NET Data operations. |
| CTColumnDifference | small structure for comparing 2 DataRows by columns, used by CompareAllColumnValues |
| CTRowReferenceInfo | Data Class that holds information about DB Rows referencing another DB Row. |
| CTTypedConstraint | this defines a constraint, foreign key |
| CTTypedDataAccess | This is the base class for the data access store. It mainly contains static methods. |
| ►CTTypedDataSet | our own Typed Dataset base class |
| CTOtherDataSet | helper class to be able to use the standard serialization constructor |
| ►CTTypedDataTable | This is the base class for the typed datatables. |
| CTTypedColumnInfo | Will be filled by generated code |
| CTTypedTableInfo | Will be filled by generated code |
| CTTypedRelation | this class is derived from TTypedConstraint and has additional settings whether this relation is enabled or not |
| CTypedDataSet | This is the base class for the typed datasets. It deals with some strange behaviour when Mono and MS.net have to talk to each other. |
| ►NDB | |
| ►NDBCaching | |
| CTSQLCache | This class allows to cache common SQL queries |
| ►NExceptions | |
| CEDBAccessLackingCoordinationException | Thrown in case a caller wants to run an action against the DB, but that isn't possible as another action that was started earlier prevents that - this means that the DB access isn't co-ordinated (but it would need to be!). |
| CEDBAttemptingToCloseDBConnectionThatGotEstablishedOnDifferentThreadException | Thrown in case a caller wants to close a DB Connection when there is still a Transaction running - which the act of closing of the DB Connection would roll back - and that DB Transaction was started on another Thread (running DB commands on different Threads on the same DB Connection isn't supported as the ADO.NET providers (specifically: the PostgreSQL provider, Npgsql) aren't thread-safe!). |
| CEDBAttemptingToCreateCommandEnlistedInDifferentDBTransactionThanTheCurrentDBTransactionException | Thrown in case a caller wants to create a Command that would be enlisted in a DB Transaction that is different from the current DB Transaction (running DB Commands on a DB Transaction other than the currently running DB Transaction is not supported [because parallel DB Transactions are not supported]). |
| CEDBAttemptingToCreateCommandOnDifferentDBConnectionThanTheDBConnectionOfOfTheDBTransactionThatGotPassedException | Thrown in case a caller wants to create a Command that would be enlisted in a DB Transaction that was started against a DB Connection that is different from the DB Connection of current DB Connection (running DB Commands on one DB Connection with a DB Transaction that was started against another DB Connection isn't supported [because each DB Command is bound to a certain DB Connection as the ADO.NET providers {specifically: the PostgreSQL provider, Npgsql} aren't thread-safe!}]). |
| CEDBAttemptingToCreateCommandThatWouldRunCommandOnDifferentThreadThanThreadOfTheTransactionThatGotPassedException | Thrown in case a caller wants to create a Command that would be executed on a Thread that is different from the Thread that started the DB Transaction that got passed in as an Argument (running DB commands on different Threads in the same DB Transaction [and hence on the same DB Connection] isn't supported as the ADO.NET providers [specifically: the PostgreSQL provider, Npgsql] aren't thread-safe!) |
| CEDBAttemptingToUseTransactionThatIsInvalidException | Thrown in case a caller wants to use a DB Transaction and that DB Transaction is no longer Valid (i.e. that DB Transaction has already been Committed or Rolled Back). |
| CEDBAttemptingToWorkWithTransactionThatGotStartedOnDifferentThreadException | Thrown in case a caller wants to work with a Transaction and that DB Transaction was started on another Thread (running DB commands on different Threads in the same DB Transaction [and hence on the same DB Connection] isn't supported!). |
| CEDBAutoServerCallRetriesExceededException | Thrown when co-ordinated (=Thread-safe) DB Access was requested, but the DB Abstraction layer was busy executing another request, and the waiting time for the request for which this Exception got thrown was exceeded. The request for which this Exception got thrown didn't get executed because of this. |
| CEDBConnectionBrokenException | Thrown if the DB Connection was found to be broken in the 'BeginTransaction' Methods (determined with a call to Method 'TExceptionHandler.IsExceptionCausedByUnavailableDBConnectionServerSide') AND the the one retry attempt to re-establish the broken DB Connection in those Methods didn't overcome the situation. |
| CEDBConnectionIsAlreadyOpenException | Thrown if an attempt to create a DB connection failed because the DB connection was already established earlier. |
| CEDBConnectionNotAvailableException | Thrown if the DB connection is not able to execute any SQL commands. |
| CEDBConnectionNotEstablishedException | Thrown if an attempt to create a DB connection failed. |
| CEDBConnectionWasAlreadyEstablishedException | Thrown if an attempt to create a DB connection failed because the DB connection was already established earlier. |
| CEDBCoordinatedDBAccessWaitingTimeExceededException | Thrown when co-ordinated (=Thread-safe) DB Access was requested, but the DB Abstraction layer was busy executing another request, and the waiting time for the request for which this Exception got thrown was exceeded. The request for which this Exception got thrown didn't get executed because of this. |
| CEDBNullTransactionException | Thrown if a transaction is expected on a DB connection but the current transaction is null. |
| CEDBParameterisedQueryMissingParameterPlaceholdersException | Thrown if a SQL command should execute a parameterised query, but parameter placeholders were missing in the query string. |
| CEDBSyncUnknownParameterTypeException | Thrown during the write to the Sync table, where the ODBC parameters need to be written to a string for the PostgreSQL database. |
| CEDBTransactionBusyException | Thrown in case a caller wants to start a new Transaction by calling BeginTransaction, but a Transaction is currently executing (parallel Transactions are not supported by ADO.NET!). |
| CEDBTransactionIsolationLevelTooLowException | Thrown in case code wants to use a Transaction with a certain IsolationLevel, but the Transaction it is using has an IsolationLevel that is lower than it expects. |
| CEDBTransactionIsolationLevelWrongException | Thrown in case code wants to use a Transaction with a certain IsolationLevel, but the Transaction it is using has a different IsolationLevel than it expects. |
| CEDBTransactionMissingException | Thrown in case code wants to run an SQL query without a transaction. This would give problems with the Progress SQL engine, with locking. Progress SQL requires all SQL queries to be in a transaction. |
| CEDBTransactionSerialisationException | Thrown during a serializable transaction if another concurrent transaction has messed with the same records for the PostgreSQL database. |
| CEDBUnsupportedDBUpgradeException | Thrown if an upgrade of the DB to a newer version of OpenPetra cannot be done. |
| CTDBExceptionHelper | Static helper class for DB Exceptions |
| ►NTesting | |
| CTTestCommonDB | |
| CDBAccess | Contains some Constants and a Global Variable for use with Database Access. |
| CEDBConnectionAlreadyClosedException | Thrown if an attempt is made to close an already/still closed DB Connection. |
| CIDataBaseRDBMS | every database system that works for OpenPetra has to implement these functions |
| CTDataAdapterCanceller | Provides a safe means to cancel the Fill operation of an associated DbDataAdapter. |
| CTDataBase | Contains functions that open and close the connection to the DB, allow execution of SQL statements and creation of DB Transactions. It is designed to support connections to different kinds of databases; there needs to be an implementation of the interface IDataBaseRDBMS to support an RDBMS |
| CTDbListParameterValue | A list of parameters which should be expanded into an ‘IN (?)’ context. |
| CTDBTransaction | A generic Class for managing all kinds of ADO.NET Database Transactions - to be used instead of concrete ADO.NET Transaction objects, eg. OdbcTransaction or NpgsqlTransaction, etc. Effectively wraps ADO.NET Transaction objects. |
| CTMySQL | Allows access to MySQL databases using the 'MySQL AB ADO.Net Driver for MySQL' .NET Data Provider. |
| CTPostgreSQL | Allows access to PostgreSQL databases using the 'Npgsql' .NET Data Provider. |
| CTServerBusyHelper | Helper Class for dealing with 'server busy' state (which can occur due to the prevention of multi-threading DB access problems). |
| ►NExceptions | |
| CEAccessDeniedException | Access denied to a certain screen or information. |
| CECachedDataTableLoadingRetryGotCancelledException | Thrown by the Cache Manager Class if the loading of a Cached DataTable got cancelled by the user when the attemps to retry the loading were exhausted. |
| CECachedDataTableNotImplementedException | Thrown by a Cache Instantiator Class if a Cached DataTable was requested that does not exist. |
| CECachedDataTableReturnedNothingException | Thrown by a Cache Instantiator Class if a Cached DataTable that was requested returned no DataTable object. |
| CECachedDataTableTableNameMismatchException | Thrown by a Cache Instantiator Class if a Cached DataTable that was requested is named differently than the Enum. |
| CEClientVersionMismatchException | The binaries of the Client don't match the Version that the Server uses. The Client is prevented from connecting to the Server in such a circumstance. |
| CEFinanceSystemCacheableTableReturnedNoDataException | Thrown if a given cacheable data table object is null or empty |
| CEFinanceSystemDataObjectNullOrEmptyException | Thrown if a given data object is null |
| CEFinanceSystemDataTableAccessFailedException | Thrown if a given data table object is unable to access (and load the contents of) a specified DB table |
| CEFinanceSystemDataTableReturnedNoDataException | Thrown if a given data table object is null or empty |
| CEFinanceSystemDBTransactionNullException | Thrown if a given DB Transaction is null |
| CEFinanceSystemInvalidBatchNumberException | Thrown if a Batch number in a given Ledger number is invalid. |
| CEFinanceSystemInvalidLedgerNumberException | Thrown if a Ledger number is invalid. |
| CEFinanceSystemUnexpectedStateException | Base Class for OpenPetra-finance-system-specific application-level Exceptions. |
| CEInvalidSiteKeyException | The Client is using an invalid SiteKey which the Server does not know about. |
| CELicenseExpiredException | Thrown if the license for the OpenPetra System is not paid in a hosted offering |
| CELoginFailedServerTooBusyException | Thrown if login was not possible because the Server was too busy. |
| CEOPAppException | Base Class for OpenPetra-specific application-level Exceptions. |
| CEOPDBException | Base Class for OpenPetra-specific data access-level and database-level Exceptions. |
| CEOPDBInvalidSessionException | Thrown if a Session that is asked for is invalid. |
| CEOPDBSessionException | Base Class for OpenPetra-specific Session Exceptions. |
| CEOPException | Base Class for OpenPetra-specific Exceptions. |
| CEOutOfRangeException | Thrown if a value is out of range. |
| CEPagedTableNoRecordsException | Thrown by the TPagedDataSet Class if no records where found by the query. |
| CEPagedTableNoSuchPageException | Thrown by the TPagedDataSet Class if a page was requested that does not exist. |
| CEPartnerKeyOutOfRangeException | This Exception is raised when a the PartnerKey number does not fit into a string of Length 10. |
| CEPasswordWrongException | Password was wrong. |
| CEPetraSecurityException | Security violation (eg. access permissions etc). |
| CEProblemConstructingHyperlinkException | Thrown if the the attempt to construct a Hyperlink from a Value and a Hyperlink Format fails. |
| CESecurityAccessDeniedException | Base Class for all Security Exceptions. |
| CESecurityDBTableAccessDeniedException | Thrown by the TDataBase Class if the user doesn't have enough rights to execute the query. |
| CESecurityGroupAccessDeniedException | Thrown if an OpenPetra User has no rights for a certain Security Group. |
| CESecurityModuleAccessDeniedException | Thrown if an OpenPetra User has no rights for a certain Security Module. |
| CESecurityScreenAccessDeniedException | Thrown if an OpenPetra screen (WinForm) cannot be opened for security reasons. |
| CESystemDisabledException | Thrown if the whole OpenPetra System is down for maintenance. |
| CEUserAccountGotLockedException | User Account got locked (happens automatically after too many login attempts with the wrong password). |
| CEUserAccountLockedException | User Account is locked (a User Account gets locked automatically after too many login attempts with the wrong password). |
| CEUserNotExistantException | User does not exist. |
| CEUserRetiredException | User is not active anymore (Retired on purpose). |
| CTExceptionHelper | Helper Class for handling Exceptions. |
| ►NIO | |
| ►NTesting | |
| CTTestCommonIO | This is a testing program for Ict.Common.IO.dll |
| CTTestHttpClient | This is a test for retrieving data via http with THTTPUtils |
| CTTestSmtpSender | This is a test for sending e-mails |
| CEncryptionRijndael | |
| CESmtpSenderException | Generic emailer exception |
| CESmtpSenderInitializeException | Exception for errors that occur during initialization |
| CESmtpSenderSendException | Exception for errors that occur during sending |
| CPackTools | Some helpful wrapper functions for packing and unpacking files and directories |
| CProcessTemplate | this class helps with template scripts and other text files |
| CStringBuilderExtensions | helpful extensions for the StringBuilder |
| CTCsv2Xml | |
| CTExcel | This contains some functions to write into Excel via remote calls constants from http:www.p6c.com/CommonTypelibs/O2000_EXCEL9.CSV |
| ►CTFileHelper | Helps in handling with certain aspects of files and compression. |
| ►CStreams | Helps in handling Streams and files. |
| CCompression | Helps in handling Zip-compression of Streams and files. |
| CFileHandling | Helps in handling MemoryStreams and files. |
| CTHTTPUtils | a few simple functions to access content from the web |
| CTImportExportTextFile | write and read a text file in a format that Petra 2.x uses |
| CTOpenDocumentParser | |
| CTSEPAWriterDirectDebit | Write SEPA files for Direct Debit |
| CTSimpleYmlParser | TSimpleYmlParser is mainly used for restoring a database saved as yml.gz; avoids loading a huge XmlDocument with all tables at once. for smaller files, the other implementation, TYml2Xml, is much easier to step through, since you get an XmlDocument |
| CTsmtpFailedRecipient | If TSmtpSender.SendMessage can detect that an email didn't reach its recipient (which is not always possible) It will report an array of these as FailedRecipients. |
| CTSmtpSender | This is a small wrapper around the .net SMTP Email services |
| CTSmtpServerSettings | Returns the settings to initialize SmtpSender, either to Client or Server |
| CTTextFile | |
| CTTextFileEncoding | A class to handle the various character encoding supported by Open Petra |
| CTXMLParser | This class provides methods for parsing an XML document and assign the contents to a representation in memory |
| CTYml2Xml | TYml2Xml is able to parse a YML file and store it in an XmlDocument |
| CYamlItemOrderComparer | For sorting the controls, depending on Order attribute, and depth |
| ►NPrinting | |
| ►NTesting | |
| CTTestPrintingPDF | This is a test for printing to PDF |
| CHtml2Pdf | Usw wkhtmltopdf to print HTML to PDF |
| CMonoFontResolver | |
| CPageImageList | |
| CTBarCode128 | collection of data that is entered on the web form |
| CTFormLettersTools | helper functions for form letters, which can be used for printing to paper or preparing emails etc |
| CTGfxPrinter | The TGfxPrinter class is the base class for TPdfPrinter |
| CTPdfPrinter | this printer uses PdfSharp to print to PDF. |
| CTPrinter | The TPrinter class helps to print |
| CTPrinterHtml | a class that renders HTML, ie. prints HTML to Screen or PDF |
| CTPrinterLayout | |
| CTPrinterState | Definition for current state of printer; useful with the stack |
| CTTableCellGfx | todoComment |
| CTTableRowGfx | todoComment |
| CTTxtPrinter | The TTxtPrinter class allows to freely position text in a file |
| ►NRemoting | |
| ►NClient | |
| CTHttpConnector | Connect to the server and return a response |
| ►NServer | |
| CDomainManager | manages access to some session variables |
| CIDBUpgrades | for updating the database |
| CIErrorLog | an interface for logging to the database |
| CIImportExportManager | for saving and loading the database |
| CILoginLog | an interface for login logging to the database |
| CIMaintenanceLogonMessage | an interface for retrieving a welcome message from the database |
| CIUserManager | an interface for the user authentication |
| CTClientManager | Main class for Client connection and disconnection and other Client actions |
| CTClientTasksManager | Handles Server-to-Client messaging |
| CTConnectedClient | This class holds details about a connected Client. It is stored as an entry in the UClientObjects HashTable (one entry for each current Client connection) |
| CTExceptionHandling | Contains procedures for structured Exception handling. They are intended to be used as 'last resort' in case an Exception that was thrown anywhere in the Application wasn't caught anywhere. |
| CTPollClientTasks | |
| CTServerManagerBase | some common implementations for IServerAdminInterface |
| ►NShared | |
| CICacheableTablesManager | Interface for cacheable tables manager |
| CIInterface | Surrogate Base Interface All Interfaces can safely derive from this Interface. The reason why we have this is: that all Types that implement any Interfaces that themselves derives from IInterface can be cast to IInterface (and passed as Function Argument: eg. IInterface AnObject). This is important for .NET Remoting scenarios |
| CIServerAdminInterface | |
| CRemotingConstants | some constants that are useful for Remoting |
| CResourceTexts | Contains resource texts. |
| CTHttpBinarySerializer | |
| ►NSession | |
| CTSession | Static class for storing sessions. we are using our own session handling, since we want to store sessions in the database, and we want to run tests without HttpContext. |
| ►NTesting | |
| CTErrorCodesTest | Needed for testing error codes. |
| CTErrorCodesTest2 | Needed for testing error codes. |
| CTTestCommon | This is a testing program for Ict.Common.dll |
| ►NVerification | |
| ►NExceptions | |
| CEVerificationResultsException | Can be hrown when TVerificationResultCollections hold one or more severe TVerificationResult item(s). |
| ►NTesting | |
| CTTestCommon | This is a testing program for Ict.Common.Verification.dll |
| CTTestVerificationResultCollection | This is a testing program for TVerificationResultCollection from Ict.Common.Verification.dll |
| CCommonResourcestrings | Contains Resource Strings which can be used anywhere in the verification routines. |
| CEVerificationException | This exception transports the error message and if the reason was another exception to the end of the routine. ResultCollection unpacks this data into a TVerificationResultCollection object, so that the user gets this message on the "normal" message box. |
| CIResultInterface | Properties that every 'Verification Result' needs to implement. |
| CTDateChecks | Class for date verifications that are needed both on Server and Client side. |
| CTGeneralChecks | Class for general verifications that are needed both on Server and Client side. |
| CTHelper | Contains Helper Methods for data verification. |
| CTNumericalChecks | Class for numerical verifications that are needed both on Server and Client side. |
| CTScreenVerificationResult | A TScreenVerificationResult object stores information about failed data verification in a Form or UserControl on the Client side. It is made to be stored in the TVerificationResultCollection. |
| CTStringChecks | Class for string verifications that are needed both on Server and Client side. |
| CTTimeChecks | Class for time verifications that are needed both on Server and Client side. |
| CTVerificationHelper | Helper Methods for dealing with TVerificationResults. |
| CTVerificationResult | A TVerificationResult object stores information about failed data verification and is passed (serialised) from the Server to the Client. It is made to be stored in the TVerificationResultCollection. |
| CTVerificationResultCollection | A TVerificationResultCollection object stores any number of TVerificationResult objects. With this typed Collection it is for instance possible to perform several data verification steps on the Server and pass the results back to the Client in one object. |
| ►CAttributes | this class contains some attribute classes (at the moment only one) |
| CResourceStringAttribute | This custom .NET Attribute is used to mark functions that return resourcestrings. These Attributes can later be found and the functions can be changed to return resourcestrings from any source/repository instead of having them hardcoded in code. |
| CCatalog | a helper class for Gnu gettext |
| CCommonErrorCodes | |
| CCommonJoinString | A class of pre-defined strings that may be used to join two other strings together |
| CCommonTagString | This small class has several string constants relating to strings that can be part of a control's Tag property |
| CCommonTypes | some functions that are useful for operating with the enums defined in Ict.Common |
| CEDuplicateErrorCodeException | Thrown if an attempt is made to add a Error Code with a value that already exists in Dictionary ErrorCodeInventory.ErrorCodeCatalogue. |
| CEErrorCodeNotRegisteredException | Thrown if an attempt is made to inquire an Error Code that doesn't exist in Dictionary ErrorCodeInventory.ErrorCodeCatalogue. |
| CENoLoggingToFile_WrongConstructorUsedException | This Exception is thrown if the TLogging class was created using the Create() constructor (without the FileName parameter) and a logging request is made that would write to a Logfile. |
| CEProblemLaunchingHyperlinkException | Thrown when OpenPetra encounters a problem when trying to launch a Hyperlink. |
| CErrCodeAttribute | Allows to add information to a constant for a specific error code. |
| CErrCodeInfo | Holds information about a specific error code. |
| CErrorCodeInventory | Inventory functions for the OpenPetra Error Codes. |
| CErrorCodes | Contains Helper Methods for working with information that is associated with Error Codes. |
| CIOPWebServerManagerActions | Interface used by Open Petra Web Server |
| CIPasswordHashingScheme | Interface which all Password Hashing Scheme implementations need to implement. |
| CNetworking | Contains general networking procedures and functions for ICT Applications. |
| CNoRemotingAttribute | simple attribute for marking methods that should not be remoted. the code generator for generateGlue will take note of this attribute. |
| CNumberToWords | This is to write a currency value in words, eg. 123 becomes onehundred twenty-three; this has to be implemented for each language. see also Java GPL code: NumericalChameleon: http://www.jonelo.de/java/nc/ |
| CStringHelper | General String utility functions for ICT applications. |
| CTAppSettingsManager | The TAppSettingsManager class allows reading of AppSettings section values in any .NET Configuration File (not just the one that has the same name as the Application itself). It also supports parameters on the command line which override the values in the config file. |
| CTCmdOpts | This class contains all the commandline parameters. It takes a very easy approach for the formatting of commandline parameters that takes values. Basically it uses the format <flag>:<value>, eg -F:c:\path\to\file.txt where -F is the parameter name, and c:\path\to\file.txt is the value. |
| CTFileVersionInfo | our own type for version information for a file |
| CTHelperNumeric | Helper class for all things numeric |
| CThreadingHelper | Helper Class for things that have to do with Multithreading. |
| CTHyperLinkHandling | Class for HyperLink handling. Used by the 'TtxtLinkTextBox' and 'TRtbHyperlinks' Controls. |
| CTLogging | The TLogging class provides general logging functionality. Logging output can currently go to the Console, to a file or to both at the same time. |
| CTLogWriter | The TLogWriter class writes arbitrary strings to a specified log file, prefixing them with date and time and optionally also with a prefix. Part of the logging framework for ICT Applications. |
| CTPasswordHashingScheme_V1 | Password Hashing Scheme V1: Generates 'salted' Password Hashes with the Scrypt Key Stretching Algorithm |
| CTPasswordHelper | Helper Class for dealing with the secure hashing of passwords in OpenPetra. |
| CTProgressState | current state of the long-running procedure |
| CTSaveConvert | some static methods for the save conversion of dates to objects and objects to dates |
| CTSearchCriteria | search criteria for SQL queries |
| CTSelfExpandingArrayList | A wrapper around System.Collections.ArrayList, that allows to use the index property even beyond the existing count of objects |
| CTSrvSetting | Class for storing Server settings. Once instantiated, Server settings can only be read! Server Settings are gathered from the Command line, .NET Configuration files and other ways (eg. determining the OS on which the server is running on-the-fly) at Server start-up |
| CTVariant | a class for the storage of values in different representations; Conversion functions are provided. |
| CTWindowHandling | Contains Windows API (WinAPI) calls that are necessary for getting window positions right |
| CUtilities | General utility functions for ICT applications that don't fall into other Units of the Ict.Common namespace. |
| ►NPetra | |
| ►NServer | |
| ►NApp | |
| ►NCore | |
| ►NSecurity | |
| CCheckServerAdminTokenAttribute | attribute for annotation of server functions. Instantiator will check access permissions |
| CRequireModulePermissionAttribute | attribute for annotation of server functions. Instantiator will check access permissions |
| CTDataBasePetra | This class provides protection for the database. It is specific to the Petra Database. It uses s_user_table_access_permission to get the permissions for the current user. The database object needs to be created with the constructor from this class, not with TDataBase.Create() |
| CTErrorLog | Reads and saves entries in the Error Log table. |
| CTLoginLog | Saves entries in the Login Log table. |
| CTModuleAccessManager | The TModuleAccessManager class provides provides functions to work with the Module Access Permissions of a Petra DB. |
| CTTableAccessPermissionManager | The TTableAccessPermissionManager class provides functions to work with the Table Access Permissions of a User of a Petra DB. |
| CTUserAccountActivityLog | Saves entries in the 'User Account Activity Log' table (s_user_account_activity). |
| ►NServerAdmin | |
| ►NWebConnectors | |
| CTServerAdminWebConnector | This connector provides methods for the server admin console /summary> |
| CTMaintenanceLogonMessage | Reads and saves the Logon Message. |
| CTProgressTracker | tracks the progress for long running jobs |
| CTServerManager | Main class for Server startup and shutdown and Server interaction via a Server Admin application |
| CTSystemDefaults | Manager for the System Defaults of the OpenPetra Site. It can be accessed from the client through the Ict.Petra.Server.MSysMan.Common.WebConnectors TSystemDefaultsConnector. |
| CTTimedProcessing | Provides means to run certain processing routines at timed intervals. This class is called by a cronjob. |
| ►NDelegates | |
| CTSetupDelegates | Sets up Delegates that allow arbitrary code to be called in various server-side DLL's, avoiding 'circular dependencies' between DLL's that need to call Methods in other DLL's (which would also reference the DLL that the call would originate from). |
| ►NWebService | |
| CTMCommonWebService | this publishes the SOAP web services of OpenPetra.org for module Common |
| CTMConferenceWebService | this publishes the SOAP web services of OpenPetra.org for module Conference |
| CTMFinanceWebService | this publishes the SOAP web services of OpenPetra.org for module Finance |
| CTMFinDevWebService | this publishes the SOAP web services of OpenPetra.org for module FinDev |
| CTMHospitalityWebService | this publishes the SOAP web services of OpenPetra.org for module Hospitality |
| CTMPartnerWebService | this publishes the SOAP web services of OpenPetra.org for module Partner |
| CTMPersonnelWebService | this publishes the SOAP web services of OpenPetra.org for module Personnel |
| CTMReportingWebService | this publishes the SOAP web services of OpenPetra.org for module Reporting |
| CTMServerAdminWebService | this publishes the SOAP web services of OpenPetra.org for module ServerAdmin |
| CTMSponsorshipWebService | this publishes the SOAP web services of OpenPetra.org for module Sponsorship |
| CTMSysManWebService | this publishes the SOAP web services of OpenPetra.org for module SysMan |
| CTOpenPetraOrgSessionManager | this publishes the SOAP web services of OpenPetra.org |
| ►Napp | |
| ►NJSClient | |
| CTUINavigation | Load navigation from UINavigation.yml and return as json specific for this user, disabling parts that he does not have access to |
| ►NMCommon | |
| ►NCacheable | |
| ►NWebConnectors | |
| CTCommonCacheableWebConnector | WebConnector for Cacheable |
| CTCacheable | Returns cacheable DataTables for DB tables in the MCommon sub-namespace that can be cached on the Client side |
| ►NData | |
| ►NAccess | |
| CACurrencyAccess | Unit of money for various countries |
| CAFrequencyAccess | Units of time. Used in partner letters. Also used to indicate how often a publication is produced or a receipt is sent to a donor |
| CCacheableTablesTDSAccess | Auto generated |
| COfficeSpecificDataLabelsTDSAccess | Auto generated |
| CPartnerAddressTDSAccess | Auto generated |
| CPCountryAccess | List of countries with their codes |
| CPInternationalPostalTypeAccess | Post office mailing zone classification |
| CPLanguageAccess | List of language codes |
| CSampleDataConstructorTDSAccess | Auto generated |
| ►NCascading | |
| CAAccountCascading | Auto generated |
| CAAccountHierarchyCascading | Auto generated |
| CAAccountHierarchyDetailCascading | Auto generated |
| CAAccountingPeriodCascading | Auto generated |
| CAAccountingSystemParameterCascading | Auto generated |
| CAAccountPropertyCascading | Auto generated |
| CAAccountPropertyCodeCascading | Auto generated |
| CAAnalysisAttributeCascading | Auto generated |
| CAAnalysisStoreTableCascading | Auto generated |
| CAAnalysisTypeCascading | Auto generated |
| CAApAnalAttribCascading | Auto generated |
| CAApDocumentCascading | Auto generated |
| CAApDocumentDetailCascading | Auto generated |
| CAApDocumentPaymentCascading | Auto generated |
| CAApPaymentCascading | Auto generated |
| CAApSupplierCascading | Auto generated |
| CAArArticleCascading | Auto generated |
| CAArArticlePriceCascading | Auto generated |
| CAArCategoryCascading | Auto generated |
| CAArDefaultDiscountCascading | Auto generated |
| CAArDiscountCascading | Auto generated |
| CAArDiscountPerCategoryCascading | Auto generated |
| CAArInvoiceCascading | Auto generated |
| CAArInvoiceDetailCascading | Auto generated |
| CAArInvoiceDetailDiscountCascading | Auto generated |
| CAArInvoiceDiscountCascading | Auto generated |
| CABatchCascading | Auto generated |
| CABudgetCascading | Auto generated |
| CABudgetPeriodCascading | Auto generated |
| CABudgetRevisionCascading | Auto generated |
| CABudgetTypeCascading | Auto generated |
| CACorporateExchangeRateCascading | Auto generated |
| CACostCentreCascading | Auto generated |
| CACostCentreTypesCascading | Auto generated |
| CACrdtNoteInvoiceLinkCascading | Auto generated |
| CACurrencyCascading | Auto generated |
| CACurrencyLanguageCascading | Auto generated |
| CADailyExchangeRateCascading | Auto generated |
| CAEmailDestinationCascading | Auto generated |
| CAEpAccountCascading | Auto generated |
| CAEpDocumentPaymentCascading | Auto generated |
| CAEpMatchCascading | Auto generated |
| CAEpPaymentCascading | Auto generated |
| CAEpStatementCascading | Auto generated |
| CAEpTransactionCascading | Auto generated |
| CAFeesPayableCascading | Auto generated |
| CAFeesReceivableCascading | Auto generated |
| CAFormCascading | Auto generated |
| CAFormElementCascading | Auto generated |
| CAFormElementTypeCascading | Auto generated |
| CAFreeformAnalysisCascading | Auto generated |
| CAFrequencyCascading | Auto generated |
| CAGeneralLedgerMasterCascading | Auto generated |
| CAGeneralLedgerMasterPeriodCascading | Auto generated |
| CAGiftBatchCascading | Auto generated |
| CAGiftCascading | Auto generated |
| CAGiftDetailCascading | Auto generated |
| CAIchStewardshipCascading | Auto generated |
| CAJournalCascading | Auto generated |
| CALedgerCascading | Auto generated |
| CALedgerInitFlagCascading | Auto generated |
| CAMethodOfGivingCascading | Auto generated |
| CAMethodOfPaymentCascading | Auto generated |
| CAMotivationDetailCascading | Auto generated |
| CAMotivationDetailFeeCascading | Auto generated |
| CAMotivationGroupCascading | Auto generated |
| CAProcessedFeeCascading | Auto generated |
| CARecurringBatchCascading | Auto generated |
| CARecurringGiftBatchCascading | Auto generated |
| CARecurringGiftCascading | Auto generated |
| CARecurringGiftDetailCascading | Auto generated |
| CARecurringJournalCascading | Auto generated |
| CARecurringTransactionCascading | Auto generated |
| CARecurringTransAnalAttribCascading | Auto generated |
| CARevaluationCascading | Auto generated |
| CASpecialTransTypeCascading | Auto generated |
| CASubSystemCascading | Auto generated |
| CASuspenseAccountCascading | Auto generated |
| CASystemInterfaceCascading | Auto generated |
| CATaxTableCascading | Auto generated |
| CATaxTypeCascading | Auto generated |
| CATransactionCascading | Auto generated |
| CATransactionTypeCascading | Auto generated |
| CATransAnalAttribCascading | Auto generated |
| CAValidLedgerNumberCascading | Auto generated |
| CMExtractCascading | Auto generated |
| CMExtractMasterCascading | Auto generated |
| CMExtractParameterCascading | Auto generated |
| CMExtractTypeCascading | Auto generated |
| CPAcquisitionCascading | Auto generated |
| CPActionCascading | Auto generated |
| CPAddressBlockCascading | Auto generated |
| CPAddressBlockElementCascading | Auto generated |
| CPAddresseeTitleOverrideCascading | Auto generated |
| CPAddresseeTypeCascading | Auto generated |
| CPAddressElementCascading | Auto generated |
| CPAddressLayoutCascading | Auto generated |
| CPAddressLayoutCodeCascading | Auto generated |
| CPAddressLineCascading | Auto generated |
| CPBankCascading | Auto generated |
| CPBankingDetailsCascading | Auto generated |
| CPBankingDetailsUsageCascading | Auto generated |
| CPBankingDetailsUsageTypeCascading | Auto generated |
| CPBankingTypeCascading | Auto generated |
| CPBusinessCascading | Auto generated |
| CPcAttendeeCascading | Auto generated |
| CPcBuildingCascading | Auto generated |
| CPcConferenceCascading | Auto generated |
| CPcConferenceCostCascading | Auto generated |
| CPcConferenceOptionCascading | Auto generated |
| CPcConferenceOptionTypeCascading | Auto generated |
| CPcConferenceVenueCascading | Auto generated |
| CPcCostTypeCascading | Auto generated |
| CPcDiscountCascading | Auto generated |
| CPcDiscountCriteriaCascading | Auto generated |
| CPcEarlyLateCascading | Auto generated |
| CPcExtraCostCascading | Auto generated |
| CPcGroupCascading | Auto generated |
| CPChurchCascading | Auto generated |
| CPConsentChannelCascading | Auto generated |
| CPConsentHistoryCascading | Auto generated |
| CPConsentHistoryPermissionCascading | Auto generated |
| CPConsentPurposeCascading | Auto generated |
| CPContactAttributeCascading | Auto generated |
| CPContactAttributeDetailCascading | Auto generated |
| CPContactLogCascading | Auto generated |
| CPCountryCascading | Auto generated |
| CPcRoomAllocCascading | Auto generated |
| CPcRoomAttributeCascading | Auto generated |
| CPcRoomAttributeTypeCascading | Auto generated |
| CPcRoomCascading | Auto generated |
| CPcSupplementCascading | Auto generated |
| CPCustomisedGreetingCascading | Auto generated |
| CPDataLabelCascading | Auto generated |
| CPDataLabelLookupCascading | Auto generated |
| CPDataLabelLookupCategoryCascading | Auto generated |
| CPDataLabelUseCascading | Auto generated |
| CPDataLabelValueApplicationCascading | Auto generated |
| CPDataLabelValuePartnerCascading | Auto generated |
| CPDenominationCascading | Auto generated |
| CPEmailCascading | Auto generated |
| CPFamilyCascading | Auto generated |
| CPFileInfoCascading | Auto generated |
| CPFirstContactCascading | Auto generated |
| CPFormalityCascading | Auto generated |
| CPFormCascading | Auto generated |
| CPFoundationCascading | Auto generated |
| CPFoundationDeadlineCascading | Auto generated |
| CPFoundationProposalCascading | Auto generated |
| CPFoundationProposalDetailCascading | Auto generated |
| CPFoundationProposalStatusCascading | Auto generated |
| CPhBookingCascading | Auto generated |
| CPhRoomBookingCascading | Auto generated |
| CPInterestCascading | Auto generated |
| CPInterestCategoryCascading | Auto generated |
| CPInternationalPostalTypeCascading | Auto generated |
| CPLabelCascading | Auto generated |
| CPLanguageCascading | Auto generated |
| CPLocationCascading | Auto generated |
| CPLocationTypeCascading | Auto generated |
| CPMailingCascading | Auto generated |
| CPmApplicationFileCascading | Auto generated |
| CPmApplicationStatusHistoryCascading | Auto generated |
| CPmCommitmentStatusCascading | Auto generated |
| CPmDocumentCascading | Auto generated |
| CPmDocumentCategoryCascading | Auto generated |
| CPmDocumentFileCascading | Auto generated |
| CPmDocumentTypeCascading | Auto generated |
| CPMembershipCascading | Auto generated |
| CPMergeFieldCascading | Auto generated |
| CPMergeFormCascading | Auto generated |
| CPMethodOfContactCascading | Auto generated |
| CPmFormalEducationCascading | Auto generated |
| CPmGeneralApplicationCascading | Auto generated |
| CPmJobAssignmentCascading | Auto generated |
| CPmPassportDetailsCascading | Auto generated |
| CPmPastExperienceCascading | Auto generated |
| CPmPersonAbilityCascading | Auto generated |
| CPmPersonAbsenceCascading | Auto generated |
| CPmPersonalDataCascading | Auto generated |
| CPmPersonCommitmentStatusCascading | Auto generated |
| CPmPersonEvaluationCascading | Auto generated |
| CPmPersonFileCascading | Auto generated |
| CPmPersonLanguageCascading | Auto generated |
| CPmPersonQualificationCascading | Auto generated |
| CPmPersonSkillCascading | Auto generated |
| CPmShortTermApplicationCascading | Auto generated |
| CPmSpecialNeedCascading | Auto generated |
| CPmStaffDataCascading | Auto generated |
| CPmYearProgramApplicationCascading | Auto generated |
| CPOccupationCascading | Auto generated |
| CPOrganisationCascading | Auto generated |
| CPPartnerActionCascading | Auto generated |
| CPPartnerAttributeCascading | Auto generated |
| CPPartnerAttributeCategoryCascading | Auto generated |
| CPPartnerAttributeTypeCascading | Auto generated |
| CPPartnerBankingDetailsCascading | Auto generated |
| CPPartnerCascading | Auto generated |
| CPPartnerClassesCascading | Auto generated |
| CPPartnerCommentCascading | Auto generated |
| CPPartnerContactAttributeCascading | Auto generated |
| CPPartnerContactCascading | Auto generated |
| CPPartnerContactFileCascading | Auto generated |
| CPPartnerFileCascading | Auto generated |
| CPPartnerGiftDestinationCascading | Auto generated |
| CPPartnerGraphicCascading | Auto generated |
| CPPartnerInterestCascading | Auto generated |
| CPPartnerLedgerCascading | Auto generated |
| CPPartnerLocationCascading | Auto generated |
| CPPartnerMembershipCascading | Auto generated |
| CPPartnerMembershipPaidCascading | Auto generated |
| CPPartnerMergeCascading | Auto generated |
| CPPartnerRelationshipCascading | Auto generated |
| CPPartnerReminderCascading | Auto generated |
| CPPartnerSetCascading | Auto generated |
| CPPartnerSetPartnerCascading | Auto generated |
| CPPartnerShortCodeCascading | Auto generated |
| CPPartnerStateCascading | Auto generated |
| CPPartnerStatusCascading | Auto generated |
| CPPartnerTaxDeductiblePctCascading | Auto generated |
| CPPartnerTypeCascading | Auto generated |
| CPPersonCascading | Auto generated |
| CPPostcodeRangeCascading | Auto generated |
| CPPostcodeRegionCascading | Auto generated |
| CPPostcodeRegionRangeCascading | Auto generated |
| CPProcessCascading | Auto generated |
| CPProposalSubmissionTypeCascading | Auto generated |
| CPPublicationCascading | Auto generated |
| CPPublicationCostCascading | Auto generated |
| CPReasonSubscriptionCancelledCascading | Auto generated |
| CPReasonSubscriptionGivenCascading | Auto generated |
| CPRecentPartnersCascading | Auto generated |
| CPRelationCascading | Auto generated |
| CPRelationCategoryCascading | Auto generated |
| CPReminderCategoryCascading | Auto generated |
| CPStateCascading | Auto generated |
| CPSubscriptionCascading | Auto generated |
| CPtAbilityAreaCascading | Auto generated |
| CPtAbilityLevelCascading | Auto generated |
| CPtApplicantStatusCascading | Auto generated |
| CPtApplicationTypeCascading | Auto generated |
| CPtArrivalPointCascading | Auto generated |
| CPtAssignmentTypeCascading | Auto generated |
| CPTaxCascading | Auto generated |
| CPtCongressCodeCascading | Auto generated |
| CPtContactCascading | Auto generated |
| CPTitleCascading | Auto generated |
| CPtLanguageLevelCascading | Auto generated |
| CPtLeadershipRatingCascading | Auto generated |
| CPtMaritalStatusCascading | Auto generated |
| CPtOutreachPreferenceLevelCascading | Auto generated |
| CPtPassportTypeCascading | Auto generated |
| CPtPositionCascading | Auto generated |
| CPtQualificationAreaCascading | Auto generated |
| CPtQualificationLevelCascading | Auto generated |
| CPtSkillCategoryCascading | Auto generated |
| CPtSkillLevelCascading | Auto generated |
| CPtSpecialApplicantCascading | Auto generated |
| CPtTravelTypeCascading | Auto generated |
| CPTypeCascading | Auto generated |
| CPTypeCategoryCascading | Auto generated |
| CPUnitCascading | Auto generated |
| CPVenueCascading | Auto generated |
| CSChangeEventCascading | Auto generated |
| CSDefaultFileVolumeCascading | Auto generated |
| CSErrorLogCascading | Auto generated |
| CSFormCascading | Auto generated |
| CSFunctionCascading | Auto generated |
| CSFunctionRelationshipCascading | Auto generated |
| CSGroupCascading | Auto generated |
| CSGroupCostCentreCascading | Auto generated |
| CSGroupDataLabelCascading | Auto generated |
| CSGroupExtractCascading | Auto generated |
| CSGroupFileInfoCascading | Auto generated |
| CSGroupFunctionCascading | Auto generated |
| CSGroupGiftCascading | Auto generated |
| CSGroupLedgerCascading | Auto generated |
| CSGroupLocationCascading | Auto generated |
| CSGroupModuleAccessPermissionCascading | Auto generated |
| CSGroupMotivationCascading | Auto generated |
| CSGroupPartnerContactCascading | Auto generated |
| CSGroupPartnerLocationCascading | Auto generated |
| CSGroupPartnerReminderCascading | Auto generated |
| CSGroupPartnerSetCascading | Auto generated |
| CSGroupTableAccessPermissionCascading | Auto generated |
| CSJobGroupCascading | Auto generated |
| CSLabelCascading | Auto generated |
| CSLanguageSpecificCascading | Auto generated |
| CSLoginCascading | Auto generated |
| CSLogonMessageCascading | Auto generated |
| CSModuleCascading | Auto generated |
| CSModuleTableAccessPermissionCascading | Auto generated |
| CSPatchLogCascading | Auto generated |
| CSReportResultCascading | Auto generated |
| CSReportsToArchiveCascading | Auto generated |
| CSReportTemplateCascading | Auto generated |
| CSSessionCascading | Auto generated |
| CSSystemDefaultsCascading | Auto generated |
| CSSystemDefaultsGuiCascading | Auto generated |
| CSSystemStatusCascading | Auto generated |
| CSUserAccountActivityCascading | Auto generated |
| CSUserCascading | Auto generated |
| CSUserDefaultsCascading | Auto generated |
| CSUserGroupCascading | Auto generated |
| CSUserModuleAccessPermissionCascading | Auto generated |
| CSUserTableAccessPermissionCascading | Auto generated |
| CSValidOutputFormCascading | Auto generated |
| CSVolumeCascading | Auto generated |
| CSVolumePartnerGroupCascading | Auto generated |
| CSVolumePartnerGroupPartnerCascading | Auto generated |
| CSWorkflowDefinitionCascading | Auto generated |
| CSWorkflowGroupCascading | Auto generated |
| CSWorkflowInstanceCascading | Auto generated |
| CSWorkflowInstanceStepCascading | Auto generated |
| CSWorkflowStepCascading | Auto generated |
| CSWorkflowUserCascading | Auto generated |
| CUmJobCascading | Auto generated |
| CUmJobLanguageCascading | Auto generated |
| CUmJobQualificationCascading | Auto generated |
| CUmJobRequirementCascading | Auto generated |
| CUmUnitAbilityCascading | Auto generated |
| CUmUnitCostCascading | Auto generated |
| CUmUnitEvaluationCascading | Auto generated |
| CUmUnitLanguageCascading | Auto generated |
| CUmUnitStructureCascading | Auto generated |
| CUUnitTypeCascading | Auto generated |
| ►NFormTemplates | |
| ►NWebConnectors | |
| CTFormTemplatesWebConnector | methods related to form templates in the MCommon namespace |
| ►NProcessing | |
| CTProcessDataChecks | Run some data checks against the database and tell the users how to fix consistency issues. |
| ►Nqueries | |
| CExtractQueryBase | base class for extract queries on server side |
| ►NUIConnectors | |
| CTOfficeSpecificDataLabelsUIConnector | Office Specific Data Labels Screen UIConnector |
| ►NValidation | |
| CACurrencyValidation | Unit of money for various countries |
| CAFrequencyValidation | Units of time. Used in partner letters. Also used to indicate how often a publication is produced or a receipt is sent to a donor |
| CPCountryValidation | List of countries with their codes |
| CPInternationalPostalTypeValidation | Post office mailing zone classification |
| CPLanguageValidation | List of language codes |
| CTCommonValidation | Contains functions for the validation of MCommon DataTables. |
| CTValidation_CacheableDataTables | Contains functions for the validation of Cacheable DataTables. |
| CTValidationControlHelper | Contains helper functions for the shared validation of data, specific to Controls. |
| CTValidationHelper | Contains helper functions for the shared validation of data. |
| ►NWebConnectors | |
| CTProgressTrackerWebConnector | this connector allows tracking of long-running procedures, using a webconnector. currently only supports one tracker per client |
| CTSequenceWebConnector | this connector returns the next sequence value from the database |
| CMCommonMain | Contains utility and helper functions that are Petra Server specific and are shared between several Petra modules. |
| CTDynamicSearchHelper | Universal class to help assemble the ODBC parameters for a dynamic search |
| ►CTPagedDataSet | Universal class that can run any SQL SELECT query and return the resulting rows in 'pages' that contain a certain amount of rows. Especially useful for Find screens, but also for other screens where a lot of data is requested but might never be fully accessed |
| CTAsyncFindParameters | |
| CTReportingDbAdapter | Reporting Query for use with 'FastReports', with Cancel Option. |
| ►NMConference | |
| ►NApplications | |
| CTApplicationManagement | Manage Conference applications |
| CTAttendeeManagement | provides methods for managing the attendees |
| ►NCacheable | |
| ►NWebConnectors | |
| CTConferenceCacheableWebConnector | WebConnector for Cacheable |
| CTCacheable | Returns cacheable DataTables for DB tables in the MConference sub-namespace that can be cached on the Client side |
| ►NConference | |
| ►NWebConnectors | |
| CTConferenceDataReaderWebConnector | Performs server-side lookups for the Client in the MConference DataReader sub-namespace |
| CTConferenceFindForm | provides server side methods for the Conference Find Form |
| CTConferenceMasterDataWebConnector | Performs server-side lookups for the Client in the MConference DataReader sub-namespace |
| CTFormLettersConferenceWebConnector | methods related to form letters for Conference Module |
| ►NData | |
| ►NAccess | |
| CConferenceApplicationTDSAccess | Auto generated |
| CConferenceSetupTDSAccess | Auto generated |
| CPcAttendeeAccess | Lists the attendees at a conference |
| CPcConferenceAccess | Basic details about a conference |
| CPcConferenceCostAccess | Charges for the various outreach options from a conference (currency held in conference master) |
| CPcConferenceOptionAccess | Lists options that are set for a conference |
| CPcConferenceOptionTypeAccess | Lists types of options that can be used for a conference |
| CPcConferenceVenueAccess | Links venues to conferences |
| CPcCostTypeAccess | Cost types to be used for conference (extra) charges |
| CPcDiscountAccess | Lists optional discounts for a conference |
| CPcDiscountCriteriaAccess | Lists possible criterias that must be met for discounts to be applied |
| CPcEarlyLateAccess | Discounts and Supplements for early or late registration |
| CPcExtraCostAccess | Contains extra conference costs for individual attendees |
| CPcGroupAccess | Contains information about which groups individual attendees are assigned to |
| CPcSupplementAccess | Outreach travel supplements (by outreach ID) |
| CSelectConferenceTDSAccess | Auto generated |
| ►NValidation | |
| CPcAttendeeValidation | Lists the attendees at a conference |
| CPcConferenceCostValidation | Charges for the various outreach options from a conference (currency held in conference master) |
| CPcConferenceOptionTypeValidation | Lists types of options that can be used for a conference |
| CPcConferenceOptionValidation | Lists options that are set for a conference |
| CPcConferenceValidation | Basic details about a conference |
| CPcConferenceVenueValidation | Links venues to conferences |
| CPcCostTypeValidation | Cost types to be used for conference (extra) charges |
| CPcDiscountCriteriaValidation | Lists possible criterias that must be met for discounts to be applied |
| CPcDiscountValidation | Lists optional discounts for a conference |
| CPcEarlyLateValidation | Discounts and Supplements for early or late registration |
| CPcExtraCostValidation | Contains extra conference costs for individual attendees |
| CPcGroupValidation | Contains information about which groups individual attendees are assigned to |
| CPcSupplementValidation | Outreach travel supplements (by outreach ID) |
| CTConferenceValidation_Conference | Contains functions for the validation of Conference DataTables. |
| CTValidation_CacheableDataTables | Contains functions for the validation of Cacheable DataTables. |
| ►NWebConnectors | |
| CTConferenceOptions | Description of ConferenceOptions. |
| ►NMFinance | |
| ►NAccount | |
| ►NData | |
| ►NAccess | |
| CAAccountAccess | Details about each account code within a ledger. Also holds information on the summary account structure for reporting |
| CAAccountHierarchyAccess | Hierarchy of accounts; what is the root account of the hierarchy |
| CAAccountHierarchyDetailAccess | Elements of the hierarchy of accounts; which account is reporting to which other account |
| CAAccountingPeriodAccess | Information about each financial period in a ledger |
| CAAccountingSystemParameterAccess | One record describing the limitations imposed on the accounting system |
| CAAccountPropertyAccess | Properties and optional values for an account can be saved in this table |
| CAAccountPropertyCodeAccess | Extra properties that might want to be saved with an account can be defined in this table |
| CAAnalysisAttributeAccess | Indicates which accounts use analysis attributes and what attribute types may be used with the account. Analysis attributes are user-definable extra information to be stored against an account |
| CAAnalysisStoreTableAccess | List of tables in the financial system, meant to be used with analysis attributes. Not available |
| CAAnalysisTypeAccess | Types of analysis attributes |
| CABatchAccess | Store current and forward period general ledger batches for a ledger |
| CABudgetAccess | Budget information for cost centre-account combinations |
| CABudgetPeriodAccess | This is the budget data for one period (e.g. a month) |
| CABudgetRevisionAccess | This defines a certain revision of a budget in a ledger in a year |
| CABudgetTypeAccess | Used for initial set up of budgets, for how to calculate amounts for each period. Some possible types are adhoc,same,percentage of annual |
| CACorporateExchangeRateAccess | Hold (monthly) corporate rates |
| CACostCentreAccess | Master cost centre records which contain details of each cost centre and their relationship to each other; determines the cost centre structure |
| CACostCentreTypesAccess | Stores standard and user-defined cost centre types. For example: Foreign, Local |
| CACurrencyLanguageAccess | Describes what is to be displayed for a currency and language combination when displaying the amount as text |
| CADailyExchangeRateAccess | Ad hoc exchange rates |
| CAEmailDestinationAccess | Where Petra supports it a cross reference between a file and destination can be established for automatic distribution |
| CAEpAccountAccess | This contains the settings for one specific bank account |
| CAEpMatchAccess | Matches that can be used to identify recurring gift or GL transactions |
| CAEpStatementAccess | List of recently imported bank statements |
| CAEpTransactionAccess | Transactions from the recently imported bank statements; they should help to identify the other party of the transaction (donor, etc) and the purpose of the transaction |
| CAFeesPayableAccess | Fees owed to another ledger. (e.g. admin grant) |
| CAFeesReceivableAccess | Charges to collect from other ledgers. (e.g. office admin fee) |
| CAFormAccess | The form description for user definable forms such as receipts |
| CAFormElementAccess | Each element that can be displayed on a form is defined on this table |
| CAFormElementTypeAccess | The element types that are available for placing in forms |
| CAFreeformAnalysisAccess | Available analysis values that may be given to a transaction for each analysis type |
| CAGeneralLedgerMasterAccess | All balances on accounts, including summary information is stored here |
| CAGeneralLedgerMasterPeriodAccess | The General Ledger Master data for one period (e.g. a month) |
| CAIchStewardshipAccess | Contains the calculation for the stewardship for a particular run. Files and reports can be recreated from this. ICH = International Clearing House (Handles transfering of funds and admin grant fees among offices.) |
| CAJournalAccess | Holds details of each general ledger journal, which contains a group of transactions |
| CALedgerAccess | Basic information for each general ledger on the system. Also counters for ledger-specific variables (such as last receipt number) |
| CALedgerInitFlagAccess | Ledger Init Flags |
| CAMethodOfGivingAccess | Special payment programs the donor may give money through. (ie, Gift Aid in the UK). Currently not used in Petra release 1 |
| CARecurringBatchAccess | Templates of general ledger batches which can be copied into the ledger |
| CARecurringJournalAccess | Templates of general ledger journals which are copied into the ledger with recurring general ledger batches |
| CARecurringTransactionAccess | Templates of general ledger transactions which are copied into the ledger with general ledger batches |
| CARecurringTransAnalAttribAccess | Detailed analysis information stored along with the recurring transaction template |
| CARevaluationAccess | Holds information used specifically in revaluations. The table extends the a_journal table |
| CASpecialTransTypeAccess | Transaction types which have special processing. Eg. Allocation, Reallocation, Gift, Revaluation |
| CASubSystemAccess | Subsystems to the general ledger which can be added and removed independantly. Eg GL, AP, AR, GR |
| CASuspenseAccountAccess | Lists the suspense accounts of each ledger |
| CASystemInterfaceAccess | Shows which systems are interfaced (have been added) to each general ledger |
| CATransactionAccess | Detailed information for each debit and credit in a general ledger journal |
| CATransactionTypeAccess | Various ways a transaction may originate, depending on the subsystem |
| CATransAnalAttribAccess | Analysis information entered by the user for a general ledger transaction |
| CAValidLedgerNumberAccess | List of foreign ledgers (eg, other fields) which the local ledger may send transctions to |
| CPEmailAccess | Email addresses of our organisation |
| ►NValidation | |
| CAAccountHierarchyDetailValidation | Elements of the hierarchy of accounts; which account is reporting to which other account |
| CAAccountHierarchyValidation | Hierarchy of accounts; what is the root account of the hierarchy |
| CAAccountingPeriodValidation | Information about each financial period in a ledger |
| CAAccountingSystemParameterValidation | One record describing the limitations imposed on the accounting system |
| CAAccountPropertyCodeValidation | Extra properties that might want to be saved with an account can be defined in this table |
| CAAccountPropertyValidation | Properties and optional values for an account can be saved in this table |
| CAAccountValidation | Details about each account code within a ledger. Also holds information on the summary account structure for reporting |
| CAAnalysisAttributeValidation | Indicates which accounts use analysis attributes and what attribute types may be used with the account. Analysis attributes are user-definable extra information to be stored against an account |
| CAAnalysisStoreTableValidation | List of tables in the financial system, meant to be used with analysis attributes. Not available |
| CAAnalysisTypeValidation | Types of analysis attributes |
| CABatchValidation | Store current and forward period general ledger batches for a ledger |
| CABudgetPeriodValidation | This is the budget data for one period (e.g. a month) |
| CABudgetRevisionValidation | This defines a certain revision of a budget in a ledger in a year |
| CABudgetTypeValidation | Used for initial set up of budgets, for how to calculate amounts for each period. Some possible types are adhoc,same,percentage of annual |
| CABudgetValidation | Budget information for cost centre-account combinations |
| CACorporateExchangeRateValidation | Hold (monthly) corporate rates |
| CACostCentreTypesValidation | Stores standard and user-defined cost centre types. For example: Foreign, Local |
| CACostCentreValidation | Master cost centre records which contain details of each cost centre and their relationship to each other; determines the cost centre structure |
| CACurrencyLanguageValidation | Describes what is to be displayed for a currency and language combination when displaying the amount as text |
| CADailyExchangeRateValidation | Ad hoc exchange rates |
| CAEmailDestinationValidation | Where Petra supports it a cross reference between a file and destination can be established for automatic distribution |
| CAEpAccountValidation | This contains the settings for one specific bank account |
| CAEpMatchValidation | Matches that can be used to identify recurring gift or GL transactions |
| CAEpStatementValidation | List of recently imported bank statements |
| CAEpTransactionValidation | Transactions from the recently imported bank statements; they should help to identify the other party of the transaction (donor, etc) and the purpose of the transaction |
| CAFeesPayableValidation | Fees owed to another ledger. (e.g. admin grant) |
| CAFeesReceivableValidation | Charges to collect from other ledgers. (e.g. office admin fee) |
| CAFormElementTypeValidation | The element types that are available for placing in forms |
| CAFormElementValidation | Each element that can be displayed on a form is defined on this table |
| CAFormValidation | The form description for user definable forms such as receipts |
| CAFreeformAnalysisValidation | Available analysis values that may be given to a transaction for each analysis type |
| CAGeneralLedgerMasterPeriodValidation | The General Ledger Master data for one period (e.g. a month) |
| CAGeneralLedgerMasterValidation | All balances on accounts, including summary information is stored here |
| CAIchStewardshipValidation | Contains the calculation for the stewardship for a particular run. Files and reports can be recreated from this. ICH = International Clearing House (Handles transfering of funds and admin grant fees among offices.) |
| CAJournalValidation | Holds details of each general ledger journal, which contains a group of transactions |
| CALedgerInitFlagValidation | Ledger Init Flags |
| CALedgerValidation | Basic information for each general ledger on the system. Also counters for ledger-specific variables (such as last receipt number) |
| CAMethodOfGivingValidation | Special payment programs the donor may give money through. (ie, Gift Aid in the UK). Currently not used in Petra release 1 |
| CARecurringBatchValidation | Templates of general ledger batches which can be copied into the ledger |
| CARecurringJournalValidation | Templates of general ledger journals which are copied into the ledger with recurring general ledger batches |
| CARecurringTransactionValidation | Templates of general ledger transactions which are copied into the ledger with general ledger batches |
| CARecurringTransAnalAttribValidation | Detailed analysis information stored along with the recurring transaction template |
| CARevaluationValidation | Holds information used specifically in revaluations. The table extends the a_journal table |
| CASpecialTransTypeValidation | Transaction types which have special processing. Eg. Allocation, Reallocation, Gift, Revaluation |
| CASubSystemValidation | Subsystems to the general ledger which can be added and removed independantly. Eg GL, AP, AR, GR |
| CASuspenseAccountValidation | Lists the suspense accounts of each ledger |
| CASystemInterfaceValidation | Shows which systems are interfaced (have been added) to each general ledger |
| CATransactionTypeValidation | Various ways a transaction may originate, depending on the subsystem |
| CATransactionValidation | Detailed information for each debit and credit in a general ledger journal |
| CATransAnalAttribValidation | Analysis information entered by the user for a general ledger transaction |
| CAValidLedgerNumberValidation | List of foreign ledgers (eg, other fields) which the local ledger may send transctions to |
| CPEmailValidation | Email addresses of our organisation |
| ►NAP | |
| ►NData | |
| ►NAccess | |
| CAApAnalAttribAccess | Analysis Attributes applied to an AP for posting to the GL |
| CAApDocumentAccess | Either an invoice or a credit note in the Accounts Payable system |
| CAApDocumentDetailAccess | An invoice or credit note consists out of several items, or details. This table contains all these details |
| CAApDocumentPaymentAccess | This table links the different payments to actual invoices and credit notes |
| CAApPaymentAccess | Records all payments that have been made against an accounts payable detail |
| CAApSupplierAccess | This table defines the concept of a supplier in the AP system and is the centre of the AP system |
| CAccountsPayableTDSAccess | Auto generated |
| CACrdtNoteInvoiceLinkAccess | This table receives a new entry when a credit note is applied to an invoice. Since the invoices and credit notes share the same table, we need a way to link the two, and this is the role of this table |
| CAEpDocumentPaymentAccess | This table links the different EP payments to actual invoices and credit notes |
| CAEpPaymentAccess | This table acts as a queue for electronic payments. If an invoice is paid electronically, the payment is added to this table. A EP program will go through this table paying all entries to GL and moving them to the a_ap_payment table |
| ►NUIConnectors | |
| CTFindUIConnector | This UIConnector provides data for the finance Accounts Payable screens |
| CTSupplierEditUIConnector | This UIConnector provides data for the finance Accounts Payable screens |
| ►NValidation | |
| CAApAnalAttribValidation | Analysis Attributes applied to an AP for posting to the GL |
| CAApDocumentDetailValidation | An invoice or credit note consists out of several items, or details. This table contains all these details |
| CAApDocumentPaymentValidation | This table links the different payments to actual invoices and credit notes |
| CAApDocumentValidation | Either an invoice or a credit note in the Accounts Payable system |
| CAApPaymentValidation | Records all payments that have been made against an accounts payable detail |
| CAApSupplierValidation | This table defines the concept of a supplier in the AP system and is the centre of the AP system |
| CACrdtNoteInvoiceLinkValidation | This table receives a new entry when a credit note is applied to an invoice. Since the invoices and credit notes share the same table, we need a way to link the two, and this is the role of this table |
| CAEpDocumentPaymentValidation | This table links the different EP payments to actual invoices and credit notes |
| CAEpPaymentValidation | This table acts as a queue for electronic payments. If an invoice is paid electronically, the payment is added to this table. A EP program will go through this table paying all entries to GL and moving them to the a_ap_payment table |
| ►NWebConnectors | |
| CTAPTransactionWebConnector | This connector provides data for the finance Accounts Payable screens /summary> |
| CTRemittanceWebConnector | Web connector for dealing with AP Remittances |
| ►NAR | |
| ►NData | |
| ►NAccess | |
| CAArArticleAccess | Defines an item that can be sold or a service that can be charged for; this can be used for catering, hospitality, store and fees; it can describe a specific book, or a group of equally priced books |
| CAArArticlePriceAccess | Assign a price to an article, which can be updated by time |
| CAArCategoryAccess | There are several categories that are can use invoicing: catering, hospitality, store and fees |
| CAArDefaultDiscountAccess | Defines which discounts should be applied by default during a certain event or time period to articles from a certain category |
| CAArDiscountAccess | Defines a discount that depends on other conditions or can just be assigned to an invoice or article |
| CAArDiscountPerCategoryAccess | Defines which discount applies to which category to limit the options in the UI |
| CAArInvoiceAccess | Invoice (which is also an offer at a certain stage) |
| CAArInvoiceDetailAccess | Invoice consists of one or more details |
| CAArInvoiceDetailDiscountAccess | Defines which discounts apply one invoice item |
| CAArInvoiceDiscountAccess | Defines which discounts apply directly to the invoice rather than the invoice items; this can depend on the customer etc |
| CATaxTableAccess | This is used by the invoicing |
| CATaxTypeAccess | Used for invoicing |
| ►NValidation | |
| CAArArticlePriceValidation | Assign a price to an article, which can be updated by time |
| CAArArticleValidation | Defines an item that can be sold or a service that can be charged for; this can be used for catering, hospitality, store and fees; it can describe a specific book, or a group of equally priced books |
| CAArCategoryValidation | There are several categories that are can use invoicing: catering, hospitality, store and fees |
| CAArDefaultDiscountValidation | Defines which discounts should be applied by default during a certain event or time period to articles from a certain category |
| CAArDiscountPerCategoryValidation | Defines which discount applies to which category to limit the options in the UI |
| CAArDiscountValidation | Defines a discount that depends on other conditions or can just be assigned to an invoice or article |
| CAArInvoiceDetailDiscountValidation | Defines which discounts apply one invoice item |
| CAArInvoiceDetailValidation | Invoice consists of one or more details |
| CAArInvoiceDiscountValidation | Defines which discounts apply directly to the invoice rather than the invoice items; this can depend on the customer etc |
| CAArInvoiceValidation | Invoice (which is also an offer at a certain stage) |
| CATaxTableValidation | This is used by the invoicing |
| CATaxTypeValidation | Used for invoicing |
| ►NBankImport | |
| ►NData | |
| ►NAccess | |
| CBankImportTDSAccess | Auto generated |
| ►NLogic | |
| CTBankImportMatching | train the matching for bank import, by comparing existing batches with old bank statements |
| CTBankStatementImport | import a bank statement from a file |
| CTBankStatementImportCAMT | import a bank statement from a CAMT Swift file |
| CTBankStatementImportCSV | import a bank statement from a CSV file |
| CTBankStatementImportMT940 | import a bank statement from a MT940 Swift file |
| CTCAMTParser | parses bank statement files (ISO 20022 CAMT.053) in Germany; for the structure of the file see https://www.rabobank.com/nl/images/Format%20description%20CAMT.053.pdf http://www.national-bank.de/fileadmin/user_upload/nationalbank/Service_Center/Electronic_Banking_Center/Downloads/Handbuecher_und_Bedingungen/SRZ-Anlage_5b_Kontoauszug_ISO_20022_camt_2010-06-15b.pdf http://www.hettwer-beratung.de/sepa-spezialwissen/sepa-technische-anforderungen/camt-format-camt-053/ |
| CTStatement | TodoComment |
| CTSwiftParser | parses bank statement files (Swift MT940) in Germany; for the structure of the file see https://www.db-bankline.deutsche-bank.com/download/MT940_Deutschland_Structure2002.pdf |
| CTTransaction | TodoComment |
| ►NWebConnectors | |
| CTBankImportWebConnector | import a bank statement from a CSV file |
| ►NBudget | |
| ►NWebConnectors | |
| CTBudgetAutoGenerateWebConnector | maintain the budget |
| CTBudgetConsolidateWebConnector | maintain the budget |
| CTBudgetMaintainWebConnector | maintain the budget |
| ►NCacheable | |
| ►NWebConnectors | |
| CTFinanceCacheableWebConnector | WebConnector for Cacheable |
| CTCacheable | Returns cacheable DataTables for DB tables in the MFinance sub-namespace that can be cached on the Client side |
| ►NCommon | |
| ►NServerLookups | |
| ►NWebConnectors | |
| CTFinanceServerLookupWebConnector | Performs server-side lookups for the Client in the MFinance.Common.ServerLookups sub-namespace |
| ►NWebConnectors | |
| CTCrossLedger | This connector provides methods for working with the Cross-Ledger data /summary> |
| CAbstractPeriodEndOperation | The period end classes inherit and complete this abstract class. The constructor of the inheriting class handles all parameters which are necessary for the RunEndOfPeriodOperation and RunEndOfPeriodOperation handles the database operations. |
| CCommon | Contains Finance Module Setup-Subnamespace Business Logic |
| CFormatConverter | This class is a local Format converter Console.WriteLine(new FormatConverter("->>>,>>>,>>>,>>9.99").digits.ToString()); Console.WriteLine(new FormatConverter("->>>,>>>,>>>,>>9.9").digits.ToString()); Console.WriteLine(new FormatConverter("->>>,>>>,>>>,>>9").digits.ToString()); The result is 2,1 and 0 digits .. |
| CTAccountInfo | TAccountInfo uses the LedgerNumber. All Accounts are load in both contructors. You can define an initial account code in the second constructor or you can set the value later (or change) by using SetAccountRowTo. Then you can read the values for the selected Account. |
| CTAccountPeriodInfo | Gets the specific date informations of an accounting intervall. This routine is either used by GL.PeriodEnd.Month and GL.Revaluation but in different senses. On time the dataset holds exact one row (Contructor with two parameters) and on time it holds a set of rows (Constructor with one parameter. |
| CTCommonAccountingTool | This Tool creates a batch enables to add a journal and to add transactions to a journal All internal "pointers" and control data are set internal and the structure is "read to post". |
| CTCommonBudgetMaintain | |
| CTCommonImport | Helper class for parsing import lines in an import file |
| CTCorporateExchangeRateCache | a cache for corporate exchange rates. mainly used by the reporting tool |
| CTCurrencyInfo | Base on the idea to reduce the number of database request to it's minimum, this object reads the complete a_currency table. Two currency slots are provided, a base currency slot and a foreigen currency slot. The the base currency slot can only set in one of the constructors one time and the foreign currency slot can easily be switched to an other currency by using the ForeignCurrencyCode property without and any more database request |
| CTExchangeRate | todoComment |
| CTExchangeRateTools | several static functions to get the exchange rates from the database |
| CTFinancialYear | This connector provides methods for creating and closing a financial year or period /summary> |
| CTGet_GLM_Info | Object to handle the read only glm-infos ... |
| CTGetAccountHierarchyDetailInfo | This object handles the table AccountHierarchyDetailInfo and provides some standard procedures. |
| CTGlmInfo | GLM-Info but an other handling than TGet_GLM_Info |
| CTGlmpInfo | Handling the information of the General Legder Master Table Period Table ... |
| ►CTGLPosting | provides methods for posting a batch |
| CTAmount | Helper class for storing the amounts of a batch at posting level for account/costcentre combinations |
| CTHandleAccountPropertyInfo | A handler to the special accounts in TAccountPropertyEnum |
| CTLedgerInfo | This routine reads the line of a_ledger defined by the ledger number |
| CTLedgerInitFlag | LedgerInitFlag is a table wich holds properties for each Ledger. |
| CTPeriodEndOperations | If a procedure is defined which shall be assigned inside a specific perodic process you have to use this class the handle the operation itself and the AbstractPeriodEndOperation class to handle the internal parts of the operation. For example the class TMonthEnd and TYearEnd inherits TPeriodEndOperations. |
| ►NDataAggregates | |
| CTALedgerNameAggregate | The TALedgerNameAggregate Class contains logic to retrieve a list of ledger names, involving both a_ledger and p_partner tables. |
| CTCostCentresLinkedToPartner | allows to filter cost centres by partner class |
| ►NFinance | |
| ►NUIConnectors | |
| CTGiftDetailFindUIConnector | Partner Find Screen UIConnector |
| CTGLTransactionFindUIConnector | GL Transaction Find Screen UIConnector |
| ►NGift | |
| ►NData | |
| ►NAccess | |
| CAGiftAccess | Information on the donor's giving. Points to the gift detail records |
| CAGiftBatchAccess | Information describing groups (batches) of gifts |
| CAGiftDetailAccess | 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 |
| CAMethodOfPaymentAccess | Media types of money received. Eg: Cash, Check Credit Card |
| CAMotivationDetailAccess | Used as a subdvision of motivation group. Details of the reason money has been received, where it is going (cost centre and account), and fees to be charged on it |
| CAMotivationDetailFeeAccess | Motivation details can have several fees |
| CAMotivationGroupAccess | This is used to track a partner's reason for contacting the organisation/sending money. Divided into Motivation Detail codes |
| CAProcessedFeeAccess | Stores administrative fees and grants which have been calculated on gifts |
| CARecurringGiftAccess | Templates of donor gift information which can be copied into the gift system with recurring gift batches |
| CARecurringGiftBatchAccess | Templates of gift batches which can be copied into the gift system |
| CARecurringGiftDetailAccess | Store recipient information for the recurring gift |
| CGiftBatchTDSAccess | Auto generated |
| ►NValidation | |
| CAGiftBatchValidation | Information describing groups (batches) of gifts |
| CAGiftDetailValidation | 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 |
| CAGiftValidation | Information on the donor's giving. Points to the gift detail records |
| CAMethodOfPaymentValidation | Media types of money received. Eg: Cash, Check Credit Card |
| CAMotivationDetailFeeValidation | Motivation details can have several fees |
| CAMotivationDetailValidation | Used as a subdvision of motivation group. Details of the reason money has been received, where it is going (cost centre and account), and fees to be charged on it |
| CAMotivationGroupValidation | This is used to track a partner's reason for contacting the organisation/sending money. Divided into Motivation Detail codes |
| CAProcessedFeeValidation | Stores administrative fees and grants which have been calculated on gifts |
| CARecurringGiftBatchValidation | Templates of gift batches which can be copied into the gift system |
| CARecurringGiftDetailValidation | Store recipient information for the recurring gift |
| CARecurringGiftValidation | Templates of donor gift information which can be copied into the gift system with recurring gift batches |
| ►NWebConnectors | |
| CTAdjustmentWebConnector | This connector provides functions to adjust and reverse gifts /summary> |
| CTGiftSetupWebConnector | setup the motivation groups and motivation details |
| CTGiftTransactionWebConnector | This connector provides data for the finance Gift screens /summary> |
| CTGuiTools | Description of Class1. |
| CTReceiptingWebConnector | This connector allows creating the gift receipts /summary> |
| CTTaxDeductibleWebConnector | setup the motivation groups and motivation details |
| CAGiftSummaryRow | provides the (outer and inner) structure for summarizing gifts |
| CTGift | Business functions for Gift sub system of Finance |
| CTGiftBatchFunctions | Some methods for creating gift batches /summary> |
| CTGiftDetailFind | Base for the Gift Detail Find Screen. (Based on Partner.PartnerFind). Utilised by the 'TGiftDetailFindUIConnector' Class. |
| CTGiftExporting | provides methods for exporting a batch |
| CTGiftExportingSEPA | provides methods for exporting a batch to a SEPA Direct Debit file |
| CTGiftImporting | Import a Gift Batch |
| ►NGL | |
| ►NData | |
| ►NAccess | |
| CBudgetTDSAccess | Auto generated |
| CCorporateExchangeSetupTDSAccess | Auto generated |
| CGLBatchTDSAccess | Auto generated |
| CGLPostingTDSAccess | Auto generated |
| CGLReportingTDSAccess | Auto generated |
| CGLSetupTDSAccess | Auto generated |
| CGLStewardshipCalculationTDSAccess | Auto generated |
| CSuspenseAccountTDSAccess | Auto generated |
| ►NWebConnectors | |
| CTAccountingPeriodsWebConnector | This connector provides data for the finance GL screens /summary> |
| CTGLTransactionWebConnector | This connector provides data for the finance GL screens /summary> |
| CTPeriodIntervalConnector | Routines for running the period month end check. |
| CTRevaluationWebConnector | Description of GL_Revaluation. |
| CAJournalSummaryRow | provides the outer structure for summarizing journals |
| CATransactionSummaryRow | provides the inner structure for summarising transactions |
| CCLSRevaluation | Main Revaluation Class. The routine is too complex for a linear program. |
| CGetBatchInfo | GetBatchInfo is a class to check for a list of batches in ledgerNum and actual period which are not posted or not cancelled, that means. This routine is looking for open tasks. |
| CGetSuspenseAccountInfo | Routine to read the a_suspense_account entries |
| CGetUnpostedGiftInfo | Routine to find unposted gifts batches. |
| CRunMonthEndChecks | |
| CRunMonthlyAdminFees | Example .... |
| CTAccountPeriodToNewYear | Change the rows of the AccountingPeriod Table to the new year |
| CTArchive | If the oldest year of data is now beyond the retention period, archive it to file and delete those records. This includes: Gifts, GL Records, Exchange rates (these are multi-ledger, so can only be archived if all ledgers allow it.) |
| CTGLExporting | provides methods for exporting a batch |
| CTGLImporting | Import a GL Batch |
| CTGlmNewYearInit | Read all glm year end records of the actual year and create the start record for the next year. Move the Ledger Row to the next year, and set the AccountingPeriod to 1. |
| CTGLTransactionFind | Base for the GL Transaction Find Screen. (Based on Partner.PartnerFind). Utilised by the 'TGLTransactionFindUIConnector' Class. |
| CTMonthEnd | Main Class to serve a Ict.Petra.Server.MFinance.GL.WebConnectors.TPeriodMonthEnd request ... |
| CTReallocation | Create and post the year end batch... |
| CTResetForwardPeriodBatches | Reset period columns on batch, journal and gift batch tables for periods beyond end of last year |
| CTResetForwardPeriodICH | Delete old year and update periods for those in new year (eg. 13 becomes 1, 14 becomes 2, etc) |
| CTYearEnd | Module for the year end calculations ... |
| ►NICH | |
| ►NWebConnectors | |
| CTGenHOSAFilesReportsWebConnector | Class for the generation of "Home Office Statement of Accounts" reports for each foreign cost centre (ledger/fund). This is basically a modified Trial Balance. |
| CTStewardshipCalculationWebConnector | Class for the performance of the Stewardship Calculation |
| ►Nqueries | |
| CQueryDonorByAmount | this report is quite simple, and should be used as an example for more complex reports and extracts |
| CQueryDonorByField | this report is quite simple, and should be used as an example for more complex reports and extracts |
| CQueryDonorByMiscellaneous | this report is quite simple, and should be used as an example for more complex reports and extracts |
| CQueryDonorByMotivation | this report is quite simple, and should be used as an example for more complex reports and extracts |
| CQueryFinanceReport | contains a method that calculates the gifts for a HOSA |
| CQueryRecipientByField | this report is quite simple, and should be used as an example for more complex reports and extracts |
| ►NReporting | |
| ►NWebConnectors | |
| CTFinanceReportingWebConnector | This WebConnector provides data for the Accounts Payable reporting screens /summary> |
| ►NSetup | |
| ►NWebConnectors | |
| CTCorporateExchangeRatesSetupWebConnector | setup the Corporate Exchange Rates |
| CTGLSetupWebConnector | setup the account hierarchy, cost centre hierarchy, and other data relevant for a General Ledger |
| ►NValidation | |
| CTFinanceValidation_AP | Contains functions for the validation of MFinance AP DataTables. |
| CTFinanceValidation_Gift | Contains functions for the validation of MFinance Gift DataTables. |
| CTFinanceValidation_GL | Contains functions for the validation of MFinance GL DataTables. |
| CTFinanceValidation_GLSetup | Contains functions for the validation of MFinance GL DataTables. |
| CTFinanceValidationHelper | Contains helper functions for the shared validation of Finance data. |
| ►NMFinDev | |
| ►NWebConnectors | |
| CTFinDevWebConnector | webconnectors for the financial development module |
| ►NMHospitality | |
| ►NData | |
| ►NAccess | |
| CHospitalityTDSAccess | Auto generated |
| CPcBuildingAccess | Details of building used for accomodation at a conference |
| CPcRoomAccess | Details of rooms used for accommodation at a conference |
| CPcRoomAllocAccess | Links rooms to attendees of a conference or a booking in the hospitality module |
| CPcRoomAttributeAccess | Attributes assigned to rooms used for accommodation at a conference |
| CPcRoomAttributeTypeAccess | Contains type of attributes that can be assigned to a room |
| CPhBookingAccess | Make sure charging works for a group or an individual; this summarises all the hospitality services that have to be paid for; also useful for planning meals in the kitchen and room preparation |
| CPhRoomBookingAccess | Links room allocations and a booking |
| ►NValidation | |
| CPcBuildingValidation | Details of building used for accomodation at a conference |
| CPcRoomAllocValidation | Links rooms to attendees of a conference or a booking in the hospitality module |
| CPcRoomAttributeTypeValidation | Contains type of attributes that can be assigned to a room |
| CPcRoomAttributeValidation | Attributes assigned to rooms used for accommodation at a conference |
| CPcRoomValidation | Details of rooms used for accommodation at a conference |
| CPhBookingValidation | Make sure charging works for a group or an individual; this summarises all the hospitality services that have to be paid for; also useful for planning meals in the kitchen and room preparation |
| CPhRoomBookingValidation | Links room allocations and a booking |
| ►NWebConnectors | |
| CTHospitalityWebConnector | webconnectors for the hospitality module |
| ►NMPartner | |
| ►NCommon | |
| ►CCalculations | Contains functions to be used by the Server and the Client that perform certain calculations - specific for the Partner Module. |
| CTOverallContactSettings | Holds the 'Overall Contact Settings' of an arbitrary number of Partners. |
| CTPartnersOverallContactSettings | Holds details of a Partners' 'Overall Contact Settings' |
| CChecks | Contains functions to be used by the Server and the Client that perform certain checks - specific for the Partner Module. |
| CPartnerCodeHelper | Gets descriptions for codes in the Partner Module. |
| CServerCalculations | Contains functions to be used by the Server that perform certain calculations - specific for the Partner Module. |
| CTAddressTools | useful functions for the address of a partner /summary> |
| CTFormLetterTools | |
| CTMailing | Contains Partner Module Partner (Mailing) - Subnamespace Business Logic |
| CTMailroom | Contains Partner Module Partner (Mailroom) -Subnamespace Business Logic |
| CTNewPartnerKey | Create a new partner key, depending on the selected field; make sure, there are no duplicate partner keys |
| CTPartnerReportTools | SQL Tool for Partner Reports |
| CTSecurity | Contains security-related functions for Partners that that can be used by any Class |
| CTServerLookups_PartnerInfo | Contains Methods that looks up miscellaneous Partner data. Used by TPartnerServerLookups.PartnerInfo Method. |
| ►NDataAggregates | |
| CTContactDetailsAggregate | The TContactDetailsAggregate Class contains logic for working with Partner Contact Details. |
| CTPPartnerAddressAggregate | The TPPartnerAddressAggregate Class contains logic to create, edit and delete addresses, involving both p_location and p_partner_location tables. |
| ►NExtracts | |
| ►NUIConnectors | |
| CTPartnerNewExtractUIConnector | New Extract User Interface Connector It contains methods to create new extracts in m_extract_master data table |
| CTExtractsHandling | Contains Partner Module Extracts handling Business Objects. These Business Objects handle the retrieval, verification and saving of data |
| ►NImport | |
| CTExportAllPartnerData | Export all data of a partner |
| ►NImportExport | |
| ►NWebConnectors | |
| CTImportExportTaxWebConnector | Import and export partner tax authority data |
| CTImportExportWebConnector | import and export partner data |
| ►CTPartnerContactDetails_LocationConversionHelper | Helper Class that aids in the conversion of certain p_partner_location data columns' content into Contact Details. |
| CPPartnerAttributeRecord | Holds data of a p_partner_attribute Record. |
| CTPartnerImportCSV | This will create a new partner and new relationships, match addresses etc |
| ►NMailing | |
| ►NCacheable | |
| ►NWebConnectors | |
| CTMailingCacheableWebConnector | WebConnector for Cacheable |
| CTPartnerCacheable | Returns cacheable DataTables for DB tables in the MPartner.Mailing sub-namespace that can be cached on the Client side |
| ►NWebConnectors | |
| CTAddressWebConnector | useful functions for the address of a partner /summary> |
| ►NMailroom | |
| ►NData | |
| ►NAccess | |
| CMExtractAccess | Contains the list of partners in each mailing extract |
| CMExtractMasterAccess | Master file for extracts. Contains names for the extract id |
| CMExtractParameterAccess | Contains a list of parameters that an extract was run with (so it can be rerun) |
| CMExtractTypeAccess | Contains a list of extract type which is needed when extracts need to be rerun |
| CPAddressBlockAccess | This table contains the address lines used in laying out an address. Eg a form letter address layout |
| CPAddressBlockElementAccess | This contains the elements which make up an address. Eg Name etc |
| CPAddresseeTitleOverrideAccess | |
| CPAddressElementAccess | This contains the elements which make up an address. Eg Name etc |
| CPAddressLayoutAccess | This table contains the address lines used in laying out an address. Eg a form letter address layout |
| CPAddressLayoutCodeAccess | This table contains the address layouts generally available for the user |
| CPAddressLineAccess | This is an address line which consists of address elements. Used along with p_address_layout and p_address_element to define layout of an address for different countries |
| CPContactAttributeAccess | Possible attributes for partner contacts. Gives the description of each attribute code. An attribute is a type of contact that was made or which occurred with a partner |
| CPContactAttributeDetailAccess | Possible attribute details for each contact attribute. Breaks down the attribute into more specifice information that applies to a contact with a partner |
| CPContactLogAccess | Details of contacts with partners |
| CPCustomisedGreetingAccess | Specific greetings from a user to a partner |
| CPFormAccess | The form description for user definable forms such as receipts |
| CPFormalityAccess | Contains the text used in letters |
| CPLabelAccess | Defines the attributes of different label types. Eg: for address labels |
| CPMailingAccess | Lists mailings that are being tracked. When entering gifts, the mailing that motivated the gift can be indicated |
| CPMergeFieldAccess | Fields within a Mail Merge Form |
| CPMergeFormAccess | Master record for Mail Merge output creation |
| CPMethodOfContactAccess | How contacts are made |
| CPPartnerContactAccess | Link between Partners and Contacts |
| CPPartnerContactAttributeAccess | Associates a p_contact_attribute_detail with a p_contact_log. A contact log may have more than one p_contact_attribute_detail associated with it |
| CPPostcodeRangeAccess | Postcode ranges for each region |
| CPPostcodeRegionAccess | List postcode regions |
| CPPostcodeRegionRangeAccess | Links ranges to a region |
| CPPublicationAccess | Details of a publication |
| CPPublicationCostAccess | Cost of a publication |
| CPReasonSubscriptionCancelledAccess | List of reasons for cancelling a subscription |
| CPReasonSubscriptionGivenAccess | List of reasons for giving a subscription |
| CPSubscriptionAccess | Details of which partners receive which publications |
| ►NValidation | |
| CMExtractMasterValidation | Master file for extracts. Contains names for the extract id |
| CMExtractParameterValidation | Contains a list of parameters that an extract was run with (so it can be rerun) |
| CMExtractTypeValidation | Contains a list of extract type which is needed when extracts need to be rerun |
| CMExtractValidation | Contains the list of partners in each mailing extract |
| CPAddressBlockElementValidation | This contains the elements which make up an address. Eg Name etc |
| CPAddressBlockValidation | This table contains the address lines used in laying out an address. Eg a form letter address layout |
| CPAddresseeTitleOverrideValidation | |
| CPAddressElementValidation | This contains the elements which make up an address. Eg Name etc |
| CPAddressLayoutCodeValidation | This table contains the address layouts generally available for the user |
| CPAddressLayoutValidation | This table contains the address lines used in laying out an address. Eg a form letter address layout |
| CPAddressLineValidation | This is an address line which consists of address elements. Used along with p_address_layout and p_address_element to define layout of an address for different countries |
| CPContactAttributeDetailValidation | Possible attribute details for each contact attribute. Breaks down the attribute into more specifice information that applies to a contact with a partner |
| CPContactAttributeValidation | Possible attributes for partner contacts. Gives the description of each attribute code. An attribute is a type of contact that was made or which occurred with a partner |
| CPContactLogValidation | Details of contacts with partners |
| CPCustomisedGreetingValidation | Specific greetings from a user to a partner |
| CPFormalityValidation | Contains the text used in letters |
| CPFormValidation | The form description for user definable forms such as receipts |
| CPLabelValidation | Defines the attributes of different label types. Eg: for address labels |
| CPMailingValidation | Lists mailings that are being tracked. When entering gifts, the mailing that motivated the gift can be indicated |
| CPMergeFieldValidation | Fields within a Mail Merge Form |
| CPMergeFormValidation | Master record for Mail Merge output creation |
| CPMethodOfContactValidation | How contacts are made |
| CPPartnerContactAttributeValidation | Associates a p_contact_attribute_detail with a p_contact_log. A contact log may have more than one p_contact_attribute_detail associated with it |
| CPPartnerContactValidation | Link between Partners and Contacts |
| CPPostcodeRangeValidation | Postcode ranges for each region |
| CPPostcodeRegionRangeValidation | Links ranges to a region |
| CPPostcodeRegionValidation | List postcode regions |
| CPPublicationCostValidation | Cost of a publication |
| CPPublicationValidation | Details of a publication |
| CPReasonSubscriptionCancelledValidation | List of reasons for cancelling a subscription |
| CPReasonSubscriptionGivenValidation | List of reasons for giving a subscription |
| CPSubscriptionValidation | Details of which partners receive which publications |
| ►NWebConnectors | |
| CTAddressDumplicateWebConnector | Performs server-side lookups for the Client |
| CTPostcodeRegionsDataWebConnector | Performs server-side lookups for the Client in the MCommon DataReader sub-namespace |
| ►NPartner | |
| ►NCacheable | |
| ►NWebConnectors | |
| CTPartnerCacheableWebConnector | WebConnector for Cacheable |
| CTPartnerCacheable | Returns cacheable DataTables for DB tables in the MPartner.Partner sub-namespace that can be cached on the Client side |
| ►NData | |
| ►NAccess | |
| CBankTDSAccess | Auto generated |
| CContactTDSAccess | Auto generated |
| CDataConsentTDSAccess | Auto generated |
| CExtractTDSAccess | Auto generated |
| CPAcquisitionAccess | This table is used to describe how a partner first came into contact with the organisation. Which department entered them |
| CPActionAccess | A particular action within a process which can be performed on a Partner |
| CPAddresseeTypeAccess | Ex. Fam - Family, SM - Single Male, etc |
| CPartnerAddressAggregateTDSAccess | Auto generated |
| CPartnerContactSetupTDSAccess | Auto generated |
| CPartnerEditTDSAccess | Auto generated |
| CPartnerFindTDSAccess | Auto generated |
| CPartnerImportExportTDSAccess | Auto generated |
| CPartnerInfoTDSAccess | Auto generated |
| CPartnerSetupTDSAccess | Auto generated |
| CPBankAccess | Details of an bank |
| CPBankingDetailsAccess | Any bank details for a partner can be stored in this table |
| CPBankingDetailsUsageAccess | Links p_partner - p_banking_details combination to a usage type |
| CPBankingDetailsUsageTypeAccess | Usage type information for Banking Details |
| CPBankingTypeAccess | Tells of what type this banking-detail is (bank-account, visa, mastercard, etc |
| CPBusinessAccess | List of businesses with codes |
| CPChurchAccess | Specific information about a church which is a partner |
| CPConsentChannelAccess | All possible channels to get data changes and consent |
| CPConsentHistoryAccess | Keeps track of all data changes for GDPR |
| CPConsentHistoryPermissionAccess | The history of consent for personal data |
| CPConsentPurposeAccess | Purposes for consent, for which the data may be used |
| CPDataLabelAccess | This table is used to define data labels for individual use in each office |
| CPDataLabelLookupAccess | This table holds all lookup values that can be used for data label values |
| CPDataLabelLookupCategoryAccess | This table holds the categories that can be used for data label values |
| CPDataLabelUseAccess | This table defines where a data label is used and the order the labels appear in |
| CPDataLabelValuePartnerAccess | This table holds the label values for partner related data |
| CPDenominationAccess | List of denomination codes for churches |
| CPFamilyAccess | Contains details about a family in Partnership with us. May have P_Person records linked to it |
| CPFileInfoAccess | Store information about the physical location of a file linked into Petra |
| CPFirstContactAccess | Lookup table for First Contact Codes (ie. how did person first hear about us) |
| CPFoundationAccess | Foundations - a type of ORGANISATION for fundraising proposals |
| CPFoundationDeadlineAccess | The month and day of reviews so that proposals can be sent in time |
| CPFoundationProposalAccess | Proposals submitted to a Foundation |
| CPFoundationProposalDetailAccess | A proposal may be for more than one project or key ministry |
| CPFoundationProposalStatusAccess | Foundation proposal status codes and descriptions |
| CPInterestAccess | Area of Interest |
| CPInterestCategoryAccess | Categories for Area of Interest |
| CPLocationAccess | Address and other data related to that address |
| CPLocationTypeAccess | Types of address e.g. home, business |
| CPMembershipAccess | Details of a membership |
| CPmPersonFileAccess | Link file with a person |
| CPOccupationAccess | List of occupations with codes |
| CPOrganisationAccess | Details of an organisation |
| CPostcodeRegionsTDSAccess | Auto generated |
| CPPartnerAccess | This is the main table of the partner system. Partners can be individuals, families, organisations (churches, businesses), fields, cost centers, and others. These represent various classes of partners |
| CPPartnerActionAccess | A particular action which has been or needs to be applied to a Partner |
| CPPartnerAttributeAccess | Mainly introduced for Partner Contact Details like email addresses and (mobile) phone numbers, but can be used for any attribute we might want to save for a Partner |
| CPPartnerAttributeCategoryAccess | Holds categories that categorise Partner Attributes Types, thus allowing logical grouping of the latter (e.g. to have all Partner Attributes Types that are to do with phone numbers in one category) |
| CPPartnerAttributeTypeAccess | Holds various Partner Attribute Types |
| CPPartnerBankingDetailsAccess | Links p_partner table with p_banking_details table for many to many relationship |
| CPPartnerClassesAccess | The class a partner is (PERSON, UNIT, etc |
| CPPartnerCommentAccess | Allows multiple as well as arbitrary-length partner comments |
| CPPartnerContactFileAccess | Link file with a partner contact |
| CPPartnerFileAccess | Link file with a partner |
| CPPartnerGiftDestinationAccess | Tracks the current gift destination for the Partner and maintains a history |
| CPPartnerGraphicAccess | Any graphic associated to a partner can be stored here |
| CPPartnerInterestAccess | Partner Area of Interest |
| CPPartnerLedgerAccess | Used to keep track of partner keys |
| CPPartnerLocationAccess | Links partners with locations (addresses) and has specific info about the link (e.g. date effective) |
| CPPartnerMembershipAccess | Membership of a partner |
| CPPartnerMembershipPaidAccess | There is a record for each payment of a membership, or hours served |
| CPPartnerMergeAccess | Partner merge history |
| CPPartnerRelationshipAccess | Relationships between pairs of partners. Among other relationships, this also relates the FAMILY class partners to the PERSON class partners to indicate members of a family |
| CPPartnerReminderAccess | A reminder that can be linked to a Partner or Partner contact |
| CPPartnerSetAccess | Defines a Partner set |
| CPPartnerSetPartnerAccess | Places Partners in a Partner set |
| CPPartnerShortCodeAccess | Stores one or more short codes for a Partner (eg. a donor or recipient code for online giving system) |
| CPPartnerStateAccess | A particular state in which the Partner is or has been. The Partner may be in more than one state at one time if there are two different processes relating to them |
| CPPartnerStatusAccess | List of statuses for partners |
| CPPartnerTaxDeductiblePctAccess | Specifies the percentage of incoming gifts to this recipient that can be considered tax deductible |
| CPPartnerTypeAccess | Types assigned to each partner. Also known as special types |
| CPPersonAccess | DEPRECATED. USE P_FAMILY INSTEAD. Details of a person. A person must also have a related FAMILY class p_partner record |
| CPProcessAccess | Refers to a process through which a Partner may go (eg. application, different status of donor - small->medium->big, etc) |
| CPProposalSubmissionTypeAccess | Submission type for foundation proposals e.g. EMAIL, LETTER |
| CPRecentPartnersAccess | The partners a user has been working with recently |
| CPRelationAccess | List of relationships between partners. Relations occur in one direction only. The relation code is used in the p_partner_relationship record |
| CPRelationCategoryAccess | This table contains the codes that indicate the categories of relations (grouping) |
| CPReminderCategoryAccess | This table contains the codes that indicate the categories of reminders |
| CPStateAccess | A particular state within a process which can apply to a Partner. Each state will probably need to have an Idle state to indicate when no state applies |
| CPTaxAccess | Tax reference numbers |
| CPTitleAccess | Titles available for use |
| CPtMaritalStatusAccess | This table contains the codes indicating someones marital status |
| CPTypeAccess | List of all possible special types for a partner |
| CPTypeCategoryAccess | This table contains the codes that indicate the categories of partner (special) types |
| CPUnitAccess | Details of a unit. This is an organizational unit such as an om field, department, local cost center, etc |
| CPVenueAccess | Details of a venue |
| CUmUnitStructureAccess | This contains parent/child relationships |
| CUUnitTypeAccess | General information about the unit such as unit type and entry conference |
| ►NServerLookups | |
| ►NWebConnectors | |
| CTPartnerServerLookups | Performs server-side lookups for the Client in the MPartner.ServerLookups sub-namespace. |
| ►NUIConnectors | |
| CTPartnerEditUIConnector | Partner Edit Screen UIConnector working with a Typed DataSet |
| CTPartnerFindUIConnector | Partner Find Screen UIConnector |
| CTPartnerLocationFindUIConnector | Partner Location Search Screen UIConnector |
| ►NValidation | |
| CPAcquisitionValidation | This table is used to describe how a partner first came into contact with the organisation. Which department entered them |
| CPActionValidation | A particular action within a process which can be performed on a Partner |
| CPAddresseeTypeValidation | Ex. Fam - Family, SM - Single Male, etc |
| CPBankingDetailsUsageTypeValidation | Usage type information for Banking Details |
| CPBankingDetailsUsageValidation | Links p_partner - p_banking_details combination to a usage type |
| CPBankingDetailsValidation | Any bank details for a partner can be stored in this table |
| CPBankingTypeValidation | Tells of what type this banking-detail is (bank-account, visa, mastercard, etc |
| CPBankValidation | Details of an bank |
| CPBusinessValidation | List of businesses with codes |
| CPChurchValidation | Specific information about a church which is a partner |
| CPConsentChannelValidation | All possible channels to get data changes and consent |
| CPConsentHistoryPermissionValidation | The history of consent for personal data |
| CPConsentHistoryValidation | Keeps track of all data changes for GDPR |
| CPConsentPurposeValidation | Purposes for consent, for which the data may be used |
| CPDataLabelLookupCategoryValidation | This table holds the categories that can be used for data label values |
| CPDataLabelLookupValidation | This table holds all lookup values that can be used for data label values |
| CPDataLabelUseValidation | This table defines where a data label is used and the order the labels appear in |
| CPDataLabelValidation | This table is used to define data labels for individual use in each office |
| CPDataLabelValuePartnerValidation | This table holds the label values for partner related data |
| CPDenominationValidation | List of denomination codes for churches |
| CPFamilyValidation | Contains details about a family in Partnership with us. May have P_Person records linked to it |
| CPFileInfoValidation | Store information about the physical location of a file linked into Petra |
| CPFirstContactValidation | Lookup table for First Contact Codes (ie. how did person first hear about us) |
| CPFoundationDeadlineValidation | The month and day of reviews so that proposals can be sent in time |
| CPFoundationProposalDetailValidation | A proposal may be for more than one project or key ministry |
| CPFoundationProposalStatusValidation | Foundation proposal status codes and descriptions |
| CPFoundationProposalValidation | Proposals submitted to a Foundation |
| CPFoundationValidation | Foundations - a type of ORGANISATION for fundraising proposals |
| CPInterestCategoryValidation | Categories for Area of Interest |
| CPInterestValidation | Area of Interest |
| CPLocationTypeValidation | Types of address e.g. home, business |
| CPLocationValidation | Address and other data related to that address |
| CPMembershipValidation | Details of a membership |
| CPmPersonFileValidation | Link file with a person |
| CPOccupationValidation | List of occupations with codes |
| CPOrganisationValidation | Details of an organisation |
| CPPartnerActionValidation | A particular action which has been or needs to be applied to a Partner |
| CPPartnerAttributeCategoryValidation | Holds categories that categorise Partner Attributes Types, thus allowing logical grouping of the latter (e.g. to have all Partner Attributes Types that are to do with phone numbers in one category) |
| CPPartnerAttributeTypeValidation | Holds various Partner Attribute Types |
| CPPartnerAttributeValidation | Mainly introduced for Partner Contact Details like email addresses and (mobile) phone numbers, but can be used for any attribute we might want to save for a Partner |
| CPPartnerBankingDetailsValidation | Links p_partner table with p_banking_details table for many to many relationship |
| CPPartnerClassesValidation | The class a partner is (PERSON, UNIT, etc |
| CPPartnerCommentValidation | Allows multiple as well as arbitrary-length partner comments |
| CPPartnerContactFileValidation | Link file with a partner contact |
| CPPartnerFileValidation | Link file with a partner |
| CPPartnerGiftDestinationValidation | Tracks the current gift destination for the Partner and maintains a history |
| CPPartnerGraphicValidation | Any graphic associated to a partner can be stored here |
| CPPartnerInterestValidation | Partner Area of Interest |
| CPPartnerLedgerValidation | Used to keep track of partner keys |
| CPPartnerLocationValidation | Links partners with locations (addresses) and has specific info about the link (e.g. date effective) |
| CPPartnerMembershipPaidValidation | There is a record for each payment of a membership, or hours served |
| CPPartnerMembershipValidation | Membership of a partner |
| CPPartnerMergeValidation | Partner merge history |
| CPPartnerRelationshipValidation | Relationships between pairs of partners. Among other relationships, this also relates the FAMILY class partners to the PERSON class partners to indicate members of a family |
| CPPartnerReminderValidation | A reminder that can be linked to a Partner or Partner contact |
| CPPartnerSetPartnerValidation | Places Partners in a Partner set |
| CPPartnerSetValidation | Defines a Partner set |
| CPPartnerShortCodeValidation | Stores one or more short codes for a Partner (eg. a donor or recipient code for online giving system) |
| CPPartnerStateValidation | A particular state in which the Partner is or has been. The Partner may be in more than one state at one time if there are two different processes relating to them |
| CPPartnerStatusValidation | List of statuses for partners |
| CPPartnerTaxDeductiblePctValidation | Specifies the percentage of incoming gifts to this recipient that can be considered tax deductible |
| CPPartnerTypeValidation | Types assigned to each partner. Also known as special types |
| CPPartnerValidation | This is the main table of the partner system. Partners can be individuals, families, organisations (churches, businesses), fields, cost centers, and others. These represent various classes of partners |
| CPPersonValidation | DEPRECATED. USE P_FAMILY INSTEAD. Details of a person. A person must also have a related FAMILY class p_partner record |
| CPProcessValidation | Refers to a process through which a Partner may go (eg. application, different status of donor - small->medium->big, etc) |
| CPProposalSubmissionTypeValidation | Submission type for foundation proposals e.g. EMAIL, LETTER |
| CPRecentPartnersValidation | The partners a user has been working with recently |
| CPRelationCategoryValidation | This table contains the codes that indicate the categories of relations (grouping) |
| CPRelationValidation | List of relationships between partners. Relations occur in one direction only. The relation code is used in the p_partner_relationship record |
| CPReminderCategoryValidation | This table contains the codes that indicate the categories of reminders |
| CPStateValidation | A particular state within a process which can apply to a Partner. Each state will probably need to have an Idle state to indicate when no state applies |
| CPTaxValidation | Tax reference numbers |
| CPTitleValidation | Titles available for use |
| CPtMaritalStatusValidation | This table contains the codes indicating someones marital status |
| CPTypeCategoryValidation | This table contains the codes that indicate the categories of partner (special) types |
| CPTypeValidation | List of all possible special types for a partner |
| CPUnitValidation | Details of a unit. This is an organizational unit such as an om field, department, local cost center, etc |
| CPVenueValidation | Details of a venue |
| CUmUnitStructureValidation | This contains parent/child relationships |
| CUUnitTypeValidation | General information about the unit such as unit type and entry conference |
| ►NWebConnectors | |
| CCancelledByUserException | Used for cancelling merge when the user presses cancel on the progress dialog |
| CDataHistoryChange | dummy object to parse data into |
| CTContactsWebConnector | store and maintain all contact details with partners, eg. phone calls, letters sent/received, emails, publications sent, etc |
| CTDataHistoryWebConnector | Get the data history of a partner |
| CTExtractMasterWebConnector | methods for extract master list |
| CTFormLettersWebConnector | methods related to form letters |
| CTMergePartnersCheckWebConnector | Performs server-side lookups for the Client in the MCommon DataReader sub-namespace |
| CTMergePartnersWebConnector | Performs server-side lookups for the Client in the MCommon DataReader sub-namespace |
| CTPartnerDataReaderWebConnector | Performs server-side lookups for the Client in the MCommon DataReader sub-namespace |
| CTPartnerWebConnector | general methods for use in partner module |
| CTSimplePartnerEditWebConnector | functions for creating new partners and to edit partners |
| CTSimplePartnerFindWebConnector | functions for a very simple partner find control |
| ►NPartnerFind | |
| CTPartnerFind | Base for the Partner Find Screen UIConnector. We need this in MPartner.Common, so that we can use the functionality from the SimplePartnerFind WebConnector as well |
| ►NProcessing | |
| CTFamilyHandling | class TFamilyHandling |
| CTPartnerFamilyIDHandling | handle the family ID this determines the parents of the family (id 0 and 1, and the children) |
| CTProcessPartnerReminders | Processes the Partner Reminders. |
| CTRecentPartnersHandling | class TRecentPartnersHandling |
| ►Nqueries | |
| CQueryFamilyExtractForPersons | query finds all family records for person records given in a base extract |
| CQueryFamilyMembersExtract | query finds all family members (persons) of families given in a base extract |
| CQueryPartnerByCity | this report is quite simple, and should be used as an example for more complex reports and extracts |
| CQueryPartnerByContactLog | Backend for creating an Extract based off of Contact Logs |
| CQueryPartnerByGeneralCriteria | this creates the query for extracts of partners by special types |
| CQueryPartnerByRelationship | this report is quite simple, and should be used as an example for more complex reports and extracts |
| CQueryPartnerBySpecialType | this creates the query for extracts of partners by special types |
| CQueryPartnerBySubscription | this report is queries the database for partners that are subscribed to certain publications and also filters the data by other criteria |
| ►NReporting | |
| ►NWebConnectors | |
| CTPartnerReportingWebConnector | This WebConnector provides data for the Partner reporting screens /summary> |
| ►NSubscriptions | |
| ►NCacheable | |
| ►NWebConnectors | |
| CTSubscriptionsCacheableWebConnector | WebConnector for Cacheable |
| CTPartnerCacheable | Returns cacheable DataTables for DB tables in the MPartner.Subscriptions sub-namespace that can be cached on the Client side |
| ►NTableMaintenance | |
| ►NWebConnectors | |
| CTPartnerSetupWebConnector | setup the partner tables |
| ►NValidation | |
| CTPartnerValidation_Partner | Contains functions for the validation of MPartner Partner DataTables. |
| CTPartnerValidationHelper | Contains helper functions for the shared validation of Partner data. |
| ►NMPersonnel | |
| ►NPerson | |
| ►NCacheable | |
| ►NWebConnectors | |
| CTPersonCacheableWebConnector | WebConnector for Cacheable |
| CTPersonnelCacheable | Returns cacheable DataTables for DB tables in the MPersonnel.Person sub-namespace that can be cached on the Client side |
| ►NDataElements | |
| ►NWebConnectors | |
| CTApplicationDataWebConnector | Web Connector for the Application Data of a PERSON. |
| CTFormLettersPersonnelWebConnector | methods related to form letters for Personnel Module |
| CTIndividualDataWebConnector | Web Connector for the Individual Data of a PERSON. |
| ►NPersonnel | |
| ►NData | |
| ►NAccess | |
| CApplicationTDSAccess | Auto generated |
| CIndividualDataTDSAccess | Auto generated |
| CLengthOfCommitmentReportTDSAccess | Auto generated |
| CPDataLabelValueApplicationAccess | This table holds the label values for application related data |
| CPersonnelTDSAccess | Auto generated |
| CPmApplicationFileAccess | Link file with an application |
| CPmApplicationStatusHistoryAccess | Keeps a history of the application status for short and long term applications |
| CPmCommitmentStatusAccess | This table holds the statuses that are be used for commitments |
| CPmDocumentAccess | Document |
| CPmDocumentCategoryAccess | This table contains the codes that indicate the categories of document types (grouping) |
| CPmDocumentFileAccess | Link file with a personal document |
| CPmDocumentTypeAccess | This table contains the codes that indicate the types of documents for a person |
| CPmFormalEducationAccess | This table records the formal education that a person has |
| CPmGeneralApplicationAccess | The first part of any application which contains data common to either short term or long term applications |
| CPmJobAssignmentAccess | This defines the position one fills |
| CPmPassportDetailsAccess | Passport Details |
| CPmPastExperienceAccess | This details any previous ministry experience the individual has |
| CPmPersonAbilityAccess | |
| CPmPersonAbsenceAccess | This table records the absence of a person (holiday, sickness, etc.) |
| CPmPersonalDataAccess | This table contains personal data about our staff, eg. tax id |
| CPmPersonCommitmentStatusAccess | This table holds the commitment type history of a person |
| CPmPersonEvaluationAccess | This table contains information regarding personal progress reports |
| CPmPersonLanguageAccess | |
| CPmPersonQualificationAccess | This table provides detail on qualifications someone may possess |
| CPmPersonSkillAccess | This table describes the skills that a person has (including professional skills but also other ones) |
| CPmShortTermApplicationAccess | Table for short term applications |
| CPmSpecialNeedAccess | This table includes special medical or dietary needs someone may have |
| CPmStaffDataAccess | This table contains information regarding recruitment, home office, field office, etc. |
| CPmYearProgramApplicationAccess | This table contains information pertaining to the application process |
| CPtAbilityAreaAccess | Defines the areas in which a person may possess an ability, e.g. plays the guitar |
| CPtAbilityLevelAccess | |
| CPtApplicantStatusAccess | This table contains the different codes that indicate where an applicant is in the application continuum |
| CPtApplicationTypeAccess | This decribes the type of application a person has submitted, e.g, Short-Term, Long-Term, or 2 years |
| CPtArrivalPointAccess | This table contains the codes used to indicate where the conferee is arriving or departing |
| CPtCongressCodeAccess | This table contains the codes that indicate a person's role and/or position at conferences and outreachs |
| CPtContactAccess | This list the various methods by which a person learns of this organisation. This table can be changed to fit any field's particular awareness programs |
| CPtLanguageLevelAccess | This is the degree to which a language is spoken, e.g. a little, phrases, fluent |
| CPtLeadershipRatingAccess | This table contains the codes indicating the leadership potential of someone |
| CPtOutreachPreferenceLevelAccess | Describes the importance of the country and activity choices |
| CPtPassportTypeAccess | This table contains the codes that indicate the type of passport a person holds |
| CPtQualificationAreaAccess | This defines the areas in which a person may posess a qualification, e.g. computing or accountancy |
| CPtQualificationLevelAccess | This is the level to which a qualifications is possessed, e.g. Secondary education, Master's Degree |
| CPtSkillCategoryAccess | This is the category that will be used for a person's skill |
| CPtSkillLevelAccess | This is the level to which a skill is possessed |
| CPtSpecialApplicantAccess | This table contains the codes that indicate special situations of applicants |
| CPtTravelTypeAccess | This table contains the codes that indicate the mode of travel being used |
| ►NValidation | |
| CPDataLabelValueApplicationValidation | This table holds the label values for application related data |
| CPmApplicationFileValidation | Link file with an application |
| CPmApplicationStatusHistoryValidation | Keeps a history of the application status for short and long term applications |
| CPmCommitmentStatusValidation | This table holds the statuses that are be used for commitments |
| CPmDocumentCategoryValidation | This table contains the codes that indicate the categories of document types (grouping) |
| CPmDocumentFileValidation | Link file with a personal document |
| CPmDocumentTypeValidation | This table contains the codes that indicate the types of documents for a person |
| CPmDocumentValidation | Document |
| CPmFormalEducationValidation | This table records the formal education that a person has |
| CPmGeneralApplicationValidation | The first part of any application which contains data common to either short term or long term applications |
| CPmJobAssignmentValidation | This defines the position one fills |
| CPmPassportDetailsValidation | Passport Details |
| CPmPastExperienceValidation | This details any previous ministry experience the individual has |
| CPmPersonAbilityValidation | |
| CPmPersonAbsenceValidation | This table records the absence of a person (holiday, sickness, etc.) |
| CPmPersonalDataValidation | This table contains personal data about our staff, eg. tax id |
| CPmPersonCommitmentStatusValidation | This table holds the commitment type history of a person |
| CPmPersonEvaluationValidation | This table contains information regarding personal progress reports |
| CPmPersonLanguageValidation | |
| CPmPersonQualificationValidation | This table provides detail on qualifications someone may possess |
| CPmPersonSkillValidation | This table describes the skills that a person has (including professional skills but also other ones) |
| CPmShortTermApplicationValidation | Table for short term applications |
| CPmSpecialNeedValidation | This table includes special medical or dietary needs someone may have |
| CPmStaffDataValidation | This table contains information regarding recruitment, home office, field office, etc. |
| CPmYearProgramApplicationValidation | This table contains information pertaining to the application process |
| CPtAbilityAreaValidation | Defines the areas in which a person may possess an ability, e.g. plays the guitar |
| CPtAbilityLevelValidation | |
| CPtApplicantStatusValidation | This table contains the different codes that indicate where an applicant is in the application continuum |
| CPtApplicationTypeValidation | This decribes the type of application a person has submitted, e.g, Short-Term, Long-Term, or 2 years |
| CPtArrivalPointValidation | This table contains the codes used to indicate where the conferee is arriving or departing |
| CPtCongressCodeValidation | This table contains the codes that indicate a person's role and/or position at conferences and outreachs |
| CPtContactValidation | This list the various methods by which a person learns of this organisation. This table can be changed to fit any field's particular awareness programs |
| CPtLanguageLevelValidation | This is the degree to which a language is spoken, e.g. a little, phrases, fluent |
| CPtLeadershipRatingValidation | This table contains the codes indicating the leadership potential of someone |
| CPtOutreachPreferenceLevelValidation | Describes the importance of the country and activity choices |
| CPtPassportTypeValidation | This table contains the codes that indicate the type of passport a person holds |
| CPtQualificationAreaValidation | This defines the areas in which a person may posess a qualification, e.g. computing or accountancy |
| CPtQualificationLevelValidation | This is the level to which a qualifications is possessed, e.g. Secondary education, Master's Degree |
| CPtSkillCategoryValidation | This is the category that will be used for a person's skill |
| CPtSkillLevelValidation | This is the level to which a skill is possessed |
| CPtSpecialApplicantValidation | This table contains the codes that indicate special situations of applicants |
| CPtTravelTypeValidation | This table contains the codes that indicate the mode of travel being used |
| ►Nqueries | |
| CQueryBirthdayReport | some useful methods for birthday reports |
| CQueryLengthOfCommitmentReport | some methods for the length of commitment report |
| CQueryPartnerByCommitment | find all partners that match a commitment |
| CQueryPartnerByEvent | this report is quite simple, and should be used as an example for more complex reports and extracts |
| CQueryPartnerByEventRole | this report is quite simple, and should be used as an example for more complex reports and extracts |
| CQueryPartnerByField | this report is quite simple, and should be used as an example for more complex reports and extracts |
| ►NReporting | |
| ►NWebConnectors | |
| CTPersonnelReportingWebConnector | This WebConnector provides data for the Personnel reporting screens /summary> |
| ►NUnit | |
| ►NCacheable | |
| ►NWebConnectors | |
| CTUnitCacheableWebConnector | WebConnector for Cacheable |
| CTPersonnelCacheable | Returns cacheable DataTables for DB tables in the MPersonnel.Unit sub-namespace that can be cached on the Client side |
| ►NUnits | |
| ►NData | |
| ►NAccess | |
| CPtAssignmentTypeAccess | Describes whether a person is full-time, part-time, etc |
| CPtPositionAccess | This is a listing of the different position which exist within our organisation, e.g. Field Leader, Book Keeper, Computer support |
| CUmJobAccess | This table contains information concerning jobs within the unit |
| CUmJobLanguageAccess | Language used on this job |
| CUmJobQualificationAccess | Details of qualifications required for individual jobs |
| CUmJobRequirementAccess | Lists abilities and experience required for various positions |
| CUmUnitAbilityAccess | Details of the abilities within the unit |
| CUmUnitCostAccess | Details pertaining to the costs of being on in the unit |
| CUmUnitEvaluationAccess | Details pertaining to evaluation of the unit |
| CUmUnitLanguageAccess | Details of the language used within this unit |
| ►NValidation | |
| CPtAssignmentTypeValidation | Describes whether a person is full-time, part-time, etc |
| CPtPositionValidation | This is a listing of the different position which exist within our organisation, e.g. Field Leader, Book Keeper, Computer support |
| CUmJobLanguageValidation | Language used on this job |
| CUmJobQualificationValidation | Details of qualifications required for individual jobs |
| CUmJobRequirementValidation | Lists abilities and experience required for various positions |
| CUmJobValidation | This table contains information concerning jobs within the unit |
| CUmUnitAbilityValidation | Details of the abilities within the unit |
| CUmUnitCostValidation | Details pertaining to the costs of being on in the unit |
| CUmUnitEvaluationValidation | Details pertaining to evaluation of the unit |
| CUmUnitLanguageValidation | Details of the language used within this unit |
| ►NValidation | |
| CTPersonnelValidation_Personnel | Contains functions for the validation of MPersonnel Personnel DataTables. |
| ►NWebConnectors | |
| CTPersonnelWebConnector | Description of Personnel. |
| ►NMReporting | |
| ►NCalculator | |
| CTRptDataCalculator | calculate a report |
| ►NMFinance | |
| CAccountDetail | Calculate the Account Detail report |
| CLedgerStatus | holds some lists of cached values |
| CTFinancialPeriod | should help with forwarding periods, different financial years etc. |
| CTGlmSequence | todoComment |
| CTGlmSequenceCache | todoComment |
| CTrialBalance | Calculate the TrialBalance report |
| ►NMPartner | |
| CAnnualReportWithoutAnnualReceiptRecipients | Report for sending an annual report to supporters that did not receive an annual receipt |
| CPartnerByCity | Calculate the Partner By City report |
| CPartnerBySpecialTypes | Calculate the Partner By Special Types report |
| CPartnerBySubscription | Report for sending subscriptions to supporters |
| CUtils | Utilities for GDPR |
| ►NWebConnectors | |
| CTReportGeneratorWebConnector | the connector for the report generation |
| CHTMLTemplateProcessor | Parse and replace HTML templates for reports |
| CTRptFormatQuery | tools to format an SQL query so that it is useful for the SQL server |
| ►NMSponsorship | |
| ►NData | |
| ►NAccess | |
| CSponsorshipFindTDSAccess | Auto generated |
| CSponsorshipTDSAccess | Auto generated |
| ►NWebConnectors | |
| CTSponsorshipWebConnector | webconnector for the sponsorship module |
| ►NMSysMan | |
| ►NApplication | |
| ►NWebConnectors | |
| CTSysManServerLookups | Performs server-side lookups for the Client in the MSysMan.ServerLookups sub-namespace. |
| ►NCacheable | |
| ►NWebConnectors | |
| CTSysManCacheableWebConnector | WebConnector for Cacheable |
| CTCacheable | Returns cacheable DataTables for DB tables in the MSysMan sub-namespace that can be cached on the Client side |
| ►NCommon | |
| ►NWebConnectors | |
| CTSystemDefaultsConnector | Reads and updates/adds System Defaults. |
| CTUserDefaults | Reads and saves User Defaults |
| ►NData | |
| ►NAccess | |
| CMaintainUsersTDSAccess | Auto generated |
| CSChangeEventAccess | Records all database events (ie. insert, update, delete). Gets purged after each export |
| CSDefaultFileVolumeAccess | Set Default Volume for a user group in a specific area |
| CSErrorLogAccess | Log of captured runtime errors |
| CSFormAccess | List of forms for printers |
| CSFunctionAccess | Contains all Petra functions to which access can be granted or denied |
| CSFunctionRelationshipAccess | Represents a relationship between two particular functions. Eg. Partner Find and Partner Edit |
| CSGroupAccess | List of groups to which users can belong |
| CSGroupCostCentreAccess | Gives a group access to a specific cost centre (so that people without other finance access can access data on their own department) |
| CSGroupDataLabelAccess | Controls the access that a group has to a specific Data Label, if the Data Label is restricted |
| CSGroupExtractAccess | Gives a group access to a specific extract |
| CSGroupFileInfoAccess | Associates a Group with an external document (file info). This may be read, write, delete |
| CSGroupFunctionAccess | Gives the group access to a particular function |
| CSGroupGiftAccess | Controls the access that a group has to a specific gift, if the gift is restricted |
| CSGroupLedgerAccess | Gives a group access to a specific ledger |
| CSGroupLocationAccess | Controls the access that a group has to a specific location, if the Location is restricted |
| CSGroupModuleAccessPermissionAccess | Security mappings from groups to Petra modules |
| CSGroupMotivationAccess | Controls the access that a group has to gifts with a specific motivation |
| CSGroupPartnerContactAccess | Controls the access that a group has to a specific Partner contact, if the contact is restricted |
| CSGroupPartnerLocationAccess | Controls the access that a group has to a specific partner location, if the Partner Location is restricted |
| CSGroupPartnerReminderAccess | Controls the access that a group has to a specific Partner reminder, if the reminder is restricted |
| CSGroupPartnerSetAccess | Associates a Group with a Partner Set. This may be an inclusive or exclusive association and may be read, write, delete |
| CSGroupTableAccessPermissionAccess | Security mappings from groups to Petra database |
| CSJobGroupAccess | Associates groups with roles |
| CSLabelAccess | Attributes for label paper |
| CSLanguageSpecificAccess | Definitions of fields that are language specific |
| CSLoginAccess | Log of all the log-ins/log-in attempts to the system, and of log-outs from the system (activities on user accounts themselves are recorded in s_user_account_activity) |
| CSLogonMessageAccess | List of logon messages by language |
| CSModuleAccess | List of Petra software modules |
| CSModuleTableAccessPermissionAccess | Security mappings from modules to Petra database |
| CSPatchLogAccess | Logs each patch procedure that is run |
| CSReportResultAccess | Report Results |
| CSReportsToArchiveAccess | Contains the titles of reports that should be archived, not deleted, when Purge Reports is run |
| CSReportTemplateAccess | Filesystem for storage of XML report templates - those provided initially and also tweaks saved by users |
| CSSessionAccess | Sessions |
| CSSystemDefaultsAccess | The settings that are system wide (iso per user) |
| CSSystemDefaultsGuiAccess | Describes the GUI controls for editing the default values |
| CSSystemStatusAccess | Records current status of system (up, maintenance etc.) |
| CSUserAccess | List of users |
| CSUserAccountActivityAccess | Logs activity on user accounts themselves (user logins and logouts are recorded in s_login) |
| CSUserDefaultsAccess | Stores various default values and options for each user |
| CSUserGroupAccess | Security mappings of users to groups |
| CSUserModuleAccessPermissionAccess | Security mappings of users to Petra modules |
| CSUserTableAccessPermissionAccess | Security mappings of users to Petra database |
| CSValidOutputFormAccess | Lists printer forms that are valid for each Petra module |
| CSVolumeAccess | Volume to either represent a file directory or a volume relative to a parent volume |
| CSVolumePartnerGroupAccess | Set up a Group for use in Default Volumes |
| CSVolumePartnerGroupPartnerAccess | Assign Partners to a Group for use in Default Volumes |
| CSWorkflowDefinitionAccess | Stores the definition of each workflow. These may be pre-created, or created by the user |
| CSWorkflowGroupAccess | Which groups have access to this workflow |
| CSWorkflowInstanceAccess | A running instance of a defined workflow |
| CSWorkflowInstanceStepAccess | Each step of the running workflow, including the status of that step |
| CSWorkflowStepAccess | Stores each step of the workflow |
| CSWorkflowUserAccess | Which users have access to this workflow |
| ►NDBUpgrades | |
| CTDBUpgrade | Upgrade the database |
| CTDBUpgrades | Upgrade the database |
| ►NImportExport | |
| ►NWebConnectors | |
| CTImportExportWebConnector | import and export of all data in this database |
| CTImportExportManager | this manager is called from the server admin console |
| ►NMaintenance | |
| ►NUserManagement | |
| CTUserManager | this manager is called from Server.App.Core |
| ►NWebConnectors | |
| CTMaintainLanguageSettingsWebConnector | allow the user to set the language and culture settings |
| CTMaintenanceWebConnector | maintain the system, eg. user management etc |
| ►NSecurity | |
| ►NUserManager | |
| ►NWebConnectors | |
| CTUserManagerWebConnector | The TUserManager class provides access to the security-related information of Users of a Petra DB. |
| CTErrorLog | Reads and saves entries in the Error Log table. |
| CTGroupManager | The TGroupManager class provides functions to work with the Security Groups and Users' Security Groups of a Petra DB. |
| CTLoginLog | Adds records to the s_login DB Table. That DB Table contains a log of all the log-ins/log-in attempts to the system, and of log-outs from the system. |
| CTTableAccessPermissionManager | The TTableAccessPermissionManager class provides functions to work with the Table Access Permissions of a User of a Petra DB. |
| ►NValidation | |
| CSChangeEventValidation | Records all database events (ie. insert, update, delete). Gets purged after each export |
| CSDefaultFileVolumeValidation | Set Default Volume for a user group in a specific area |
| CSErrorLogValidation | Log of captured runtime errors |
| CSFormValidation | List of forms for printers |
| CSFunctionRelationshipValidation | Represents a relationship between two particular functions. Eg. Partner Find and Partner Edit |
| CSFunctionValidation | Contains all Petra functions to which access can be granted or denied |
| CSGroupCostCentreValidation | Gives a group access to a specific cost centre (so that people without other finance access can access data on their own department) |
| CSGroupDataLabelValidation | Controls the access that a group has to a specific Data Label, if the Data Label is restricted |
| CSGroupExtractValidation | Gives a group access to a specific extract |
| CSGroupFileInfoValidation | Associates a Group with an external document (file info). This may be read, write, delete |
| CSGroupFunctionValidation | Gives the group access to a particular function |
| CSGroupGiftValidation | Controls the access that a group has to a specific gift, if the gift is restricted |
| CSGroupLedgerValidation | Gives a group access to a specific ledger |
| CSGroupLocationValidation | Controls the access that a group has to a specific location, if the Location is restricted |
| CSGroupModuleAccessPermissionValidation | Security mappings from groups to Petra modules |
| CSGroupMotivationValidation | Controls the access that a group has to gifts with a specific motivation |
| CSGroupPartnerContactValidation | Controls the access that a group has to a specific Partner contact, if the contact is restricted |
| CSGroupPartnerLocationValidation | Controls the access that a group has to a specific partner location, if the Partner Location is restricted |
| CSGroupPartnerReminderValidation | Controls the access that a group has to a specific Partner reminder, if the reminder is restricted |
| CSGroupPartnerSetValidation | Associates a Group with a Partner Set. This may be an inclusive or exclusive association and may be read, write, delete |
| CSGroupTableAccessPermissionValidation | Security mappings from groups to Petra database |
| CSGroupValidation | List of groups to which users can belong |
| CSJobGroupValidation | Associates groups with roles |
| CSLabelValidation | Attributes for label paper |
| CSLanguageSpecificValidation | Definitions of fields that are language specific |
| CSLoginValidation | Log of all the log-ins/log-in attempts to the system, and of log-outs from the system (activities on user accounts themselves are recorded in s_user_account_activity) |
| CSLogonMessageValidation | List of logon messages by language |
| CSModuleTableAccessPermissionValidation | Security mappings from modules to Petra database |
| CSModuleValidation | List of Petra software modules |
| CSPatchLogValidation | Logs each patch procedure that is run |
| CSReportResultValidation | Report Results |
| CSReportsToArchiveValidation | Contains the titles of reports that should be archived, not deleted, when Purge Reports is run |
| CSReportTemplateValidation | Filesystem for storage of XML report templates - those provided initially and also tweaks saved by users |
| CSSessionValidation | Sessions |
| CSSystemDefaultsGuiValidation | Describes the GUI controls for editing the default values |
| CSSystemDefaultsValidation | The settings that are system wide (iso per user) |
| CSSystemStatusValidation | Records current status of system (up, maintenance etc.) |
| CSUserAccountActivityValidation | Logs activity on user accounts themselves (user logins and logouts are recorded in s_login) |
| CSUserDefaultsValidation | Stores various default values and options for each user |
| CSUserGroupValidation | Security mappings of users to groups |
| CSUserModuleAccessPermissionValidation | Security mappings of users to Petra modules |
| CSUserTableAccessPermissionValidation | Security mappings of users to Petra database |
| CSUserValidation | List of users |
| CSValidOutputFormValidation | Lists printer forms that are valid for each Petra module |
| CSVolumePartnerGroupPartnerValidation | Assign Partners to a Group for use in Default Volumes |
| CSVolumePartnerGroupValidation | Set up a Group for use in Default Volumes |
| CSVolumeValidation | Volume to either represent a file directory or a volume relative to a parent volume |
| CSWorkflowDefinitionValidation | Stores the definition of each workflow. These may be pre-created, or created by the user |
| CSWorkflowGroupValidation | Which groups have access to this workflow |
| CSWorkflowInstanceStepValidation | Each step of the running workflow, including the status of that step |
| CSWorkflowInstanceValidation | A running instance of a defined workflow |
| CSWorkflowStepValidation | Stores each step of the workflow |
| CSWorkflowUserValidation | Which users have access to this workflow |
| CTSysManValidation | Contains functions for the validation of MPartner Partner DataTables. |
| ►NWebConnectors | |
| CTSettingsWebConnector | Performs server-side lookups for the Client in the MCommon DataReader sub-namespace |
| ►NServerAdmin | |
| ►NApp | |
| ►NCore | |
| ►NRemoteObjects | |
| ►CTMServerAdminNamespace | Top level namespace for the module ServerAdmin |
| CTServerAdminWebConnectorsNamespace | namespace definition |
| ►NShared | |
| ►NInterfaces | |
| ►NPlugins | |
| ►NMSysMan | |
| CIUserAuthentication | This interface defines which methods need to be implemented by a plugin for authentication of users e.g. you can authenticate against an LDAP server or use the authentication of another application that the users are already using |
| ►NMCommon | |
| ►NData | |
| CACurrencyRow | Unit of money for various countries |
| CACurrencyTable | Unit of money for various countries |
| CAFrequencyRow | Units of time. Used in partner letters. Also used to indicate how often a publication is produced or a receipt is sent to a donor |
| CAFrequencyTable | Units of time. Used in partner letters. Also used to indicate how often a publication is produced or a receipt is sent to a donor |
| CCacheableTablesTDS | Auto generated |
| CCacheableTablesTDSContentsRow | |
| CCacheableTablesTDSContentsTable | |
| COfficeSpecificDataLabelsTDS | Auto generated |
| CPartnerAddressTDS | Auto generated |
| CPCountryRow | List of countries with their codes |
| CPCountryTable | List of countries with their codes |
| CPInternationalPostalTypeRow | Post office mailing zone classification |
| CPInternationalPostalTypeTable | Post office mailing zone classification |
| CPLanguageRow | List of language codes |
| CPLanguageTable | List of language codes |
| CSampleDataConstructorTDS | Auto generated |
| CCommonCodeHelper | Gets descriptions for codes in the Common Module. |
| CMCommonConstants | this class defines some data types that can be used for Office Specific Data Labels |
| CMCommonTypes | collection of static methods that are useful for the types defined in MCommon |
| CTFormData | Base Class for mail merge form data |
| CTFormDataAPPayment | Contains data for individual AP Invoice payments |
| CTFormDataApplicant | |
| CTFormDataAttendee | |
| CTFormDataCommitment | Contains data for a commitment record for a person |
| CTFormDataContactDetail | Contains data for a contact detail entry for a partner |
| CTFormDataContactLog | Contains data for a contact log entry for a partner |
| CTFormDataDegree | Contains data for a degree record for a person |
| CTFormDataFamilyMember | Contains data for a family member |
| CTFormDataGift | Contains data for a gift detail for/from a partner |
| CTFormDataKeyDescription | Contains data for key/description pairs of data (used e.g. for printing setup screen keys and descriptions) (includes extra data fields) |
| CTFormDataKeyDescriptionList | Contains metadata and a list of key/description pairs of data (used e.g. for printing setup screen keys and descriptions) |
| CTFormDataLanguage | Contains data for a language record for a person |
| CTFormDataPartner | Contains data for a Partner to be used for export to forms |
| CTFormDataPartnerList | List Class for partner form data objects |
| CTFormDataPassport | Contains data for a passport record for a person |
| CTFormDataPerson | Contains data for a Person to be used for export to forms |
| CTFormDataSkill | Contains data for a skill record for a person |
| CTFormDataSubscription | Contains data for a subscription for a partner |
| CTFormDataUnit | Contains data for a Unit to be used for export to forms |
| CTFormDataWorkExperience | Contains data for a work experience record for a person |
| CTFormLetterFinanceInfo | Class to keep information about form letter creation process for finance letters |
| ►CTFormLetterInfo | Class to keep information about form letter creation process |
| CFormality | Class to keep information about formality records |
| CTFormLetterPrintOptions | Class to keep information about Form Letter printing options |
| CTSharedAddressHandling | Contains functions for handling of Addresses. |
| ►NMConference | |
| ►NData | |
| CConferenceApplicationTDS | Auto generated |
| CConferenceSetupTDS | Auto generated |
| CConferenceSetupTDSPcConferenceVenueRow | Links venues to conferences |
| CConferenceSetupTDSPcConferenceVenueTable | Links venues to conferences |
| CPcAttendeeRow | Lists the attendees at a conference |
| CPcAttendeeTable | Lists the attendees at a conference |
| CPcConferenceCostRow | Charges for the various outreach options from a conference (currency held in conference master) |
| CPcConferenceCostTable | Charges for the various outreach options from a conference (currency held in conference master) |
| CPcConferenceOptionRow | Lists options that are set for a conference |
| CPcConferenceOptionTable | Lists options that are set for a conference |
| CPcConferenceOptionTypeRow | Lists types of options that can be used for a conference |
| CPcConferenceOptionTypeTable | Lists types of options that can be used for a conference |
| CPcConferenceRow | Basic details about a conference |
| CPcConferenceTable | Basic details about a conference |
| CPcConferenceVenueRow | Links venues to conferences |
| CPcConferenceVenueTable | Links venues to conferences |
| CPcCostTypeRow | Cost types to be used for conference (extra) charges |
| CPcCostTypeTable | Cost types to be used for conference (extra) charges |
| CPcDiscountCriteriaRow | Lists possible criterias that must be met for discounts to be applied |
| CPcDiscountCriteriaTable | Lists possible criterias that must be met for discounts to be applied |
| CPcDiscountRow | Lists optional discounts for a conference |
| CPcDiscountTable | Lists optional discounts for a conference |
| CPcEarlyLateRow | Discounts and Supplements for early or late registration |
| CPcEarlyLateTable | Discounts and Supplements for early or late registration |
| CPcExtraCostRow | Contains extra conference costs for individual attendees |
| CPcExtraCostTable | Contains extra conference costs for individual attendees |
| CPcGroupRow | Contains information about which groups individual attendees are assigned to |
| CPcGroupTable | Contains information about which groups individual attendees are assigned to |
| CPcSupplementRow | Outreach travel supplements (by outreach ID) |
| CPcSupplementTable | Outreach travel supplements (by outreach ID) |
| CSelectConferenceTDS | Auto generated |
| CMConferenceConstants | some constants used in the conference module |
| ►NMFinance | |
| ►NAccount | |
| ►NData | |
| CAAccountHierarchyDetailRow | Elements of the hierarchy of accounts; which account is reporting to which other account |
| CAAccountHierarchyDetailTable | Elements of the hierarchy of accounts; which account is reporting to which other account |
| CAAccountHierarchyRow | Hierarchy of accounts; what is the root account of the hierarchy |
| CAAccountHierarchyTable | Hierarchy of accounts; what is the root account of the hierarchy |
| CAAccountingPeriodRow | Information about each financial period in a ledger |
| CAAccountingPeriodTable | Information about each financial period in a ledger |
| CAAccountingSystemParameterRow | One record describing the limitations imposed on the accounting system |
| CAAccountingSystemParameterTable | One record describing the limitations imposed on the accounting system |
| CAAccountPropertyCodeRow | Extra properties that might want to be saved with an account can be defined in this table |
| CAAccountPropertyCodeTable | Extra properties that might want to be saved with an account can be defined in this table |
| CAAccountPropertyRow | Properties and optional values for an account can be saved in this table |
| CAAccountPropertyTable | Properties and optional values for an account can be saved in this table |
| CAAccountRow | Details about each account code within a ledger. Also holds information on the summary account structure for reporting |
| CAAccountTable | Details about each account code within a ledger. Also holds information on the summary account structure for reporting |
| CAAnalysisAttributeRow | Indicates which accounts use analysis attributes and what attribute types may be used with the account. Analysis attributes are user-definable extra information to be stored against an account |
| CAAnalysisAttributeTable | Indicates which accounts use analysis attributes and what attribute types may be used with the account. Analysis attributes are user-definable extra information to be stored against an account |
| CAAnalysisStoreTableRow | List of tables in the financial system, meant to be used with analysis attributes. Not available |
| CAAnalysisStoreTableTable | List of tables in the financial system, meant to be used with analysis attributes. Not available |
| CAAnalysisTypeRow | Types of analysis attributes |
| CAAnalysisTypeTable | Types of analysis attributes |
| CABatchRow | Store current and forward period general ledger batches for a ledger |
| CABatchTable | Store current and forward period general ledger batches for a ledger |
| CABudgetPeriodRow | This is the budget data for one period (e.g. a month) |
| CABudgetPeriodTable | This is the budget data for one period (e.g. a month) |
| CABudgetRevisionRow | This defines a certain revision of a budget in a ledger in a year |
| CABudgetRevisionTable | This defines a certain revision of a budget in a ledger in a year |
| CABudgetRow | Budget information for cost centre-account combinations |
| CABudgetTable | Budget information for cost centre-account combinations |
| CABudgetTypeRow | Used for initial set up of budgets, for how to calculate amounts for each period. Some possible types are adhoc,same,percentage of annual |
| CABudgetTypeTable | Used for initial set up of budgets, for how to calculate amounts for each period. Some possible types are adhoc,same,percentage of annual |
| CACorporateExchangeRateRow | Hold (monthly) corporate rates |
| CACorporateExchangeRateTable | Hold (monthly) corporate rates |
| CACostCentreRow | Master cost centre records which contain details of each cost centre and their relationship to each other; determines the cost centre structure |
| CACostCentreTable | Master cost centre records which contain details of each cost centre and their relationship to each other; determines the cost centre structure |
| CACostCentreTypesRow | Stores standard and user-defined cost centre types. For example: Foreign, Local |
| CACostCentreTypesTable | Stores standard and user-defined cost centre types. For example: Foreign, Local |
| CACurrencyLanguageRow | Describes what is to be displayed for a currency and language combination when displaying the amount as text |
| CACurrencyLanguageTable | Describes what is to be displayed for a currency and language combination when displaying the amount as text |
| CADailyExchangeRateRow | Ad hoc exchange rates |
| CADailyExchangeRateTable | Ad hoc exchange rates |
| CAEmailDestinationRow | Where Petra supports it a cross reference between a file and destination can be established for automatic distribution |
| CAEmailDestinationTable | Where Petra supports it a cross reference between a file and destination can be established for automatic distribution |
| CAEpAccountRow | This contains the settings for one specific bank account |
| CAEpAccountTable | This contains the settings for one specific bank account |
| CAEpMatchRow | Matches that can be used to identify recurring gift or GL transactions |
| CAEpMatchTable | Matches that can be used to identify recurring gift or GL transactions |
| CAEpStatementRow | List of recently imported bank statements |
| CAEpStatementTable | List of recently imported bank statements |
| CAEpTransactionRow | Transactions from the recently imported bank statements; they should help to identify the other party of the transaction (donor, etc) and the purpose of the transaction |
| CAEpTransactionTable | Transactions from the recently imported bank statements; they should help to identify the other party of the transaction (donor, etc) and the purpose of the transaction |
| CAFeesPayableRow | Fees owed to another ledger. (e.g. admin grant) |
| CAFeesPayableTable | Fees owed to another ledger. (e.g. admin grant) |
| CAFeesReceivableRow | Charges to collect from other ledgers. (e.g. office admin fee) |
| CAFeesReceivableTable | Charges to collect from other ledgers. (e.g. office admin fee) |
| CAFormElementRow | Each element that can be displayed on a form is defined on this table |
| CAFormElementTable | Each element that can be displayed on a form is defined on this table |
| CAFormElementTypeRow | The element types that are available for placing in forms |
| CAFormElementTypeTable | The element types that are available for placing in forms |
| CAFormRow | The form description for user definable forms such as receipts |
| CAFormTable | The form description for user definable forms such as receipts |
| CAFreeformAnalysisRow | Available analysis values that may be given to a transaction for each analysis type |
| CAFreeformAnalysisTable | Available analysis values that may be given to a transaction for each analysis type |
| CAGeneralLedgerMasterPeriodRow | The General Ledger Master data for one period (e.g. a month) |
| CAGeneralLedgerMasterPeriodTable | The General Ledger Master data for one period (e.g. a month) |
| CAGeneralLedgerMasterRow | All balances on accounts, including summary information is stored here |
| CAGeneralLedgerMasterTable | All balances on accounts, including summary information is stored here |
| CAIchStewardshipRow | Contains the calculation for the stewardship for a particular run. Files and reports can be recreated from this. ICH = International Clearing House (Handles transfering of funds and admin grant fees among offices.) |
| CAIchStewardshipTable | Contains the calculation for the stewardship for a particular run. Files and reports can be recreated from this. ICH = International Clearing House (Handles transfering of funds and admin grant fees among offices.) |
| CAJournalRow | Holds details of each general ledger journal, which contains a group of transactions |
| CAJournalTable | Holds details of each general ledger journal, which contains a group of transactions |
| CALedgerInitFlagRow | Ledger Init Flags |
| CALedgerInitFlagTable | Ledger Init Flags |
| CALedgerRow | Basic information for each general ledger on the system. Also counters for ledger-specific variables (such as last receipt number) |
| CALedgerTable | Basic information for each general ledger on the system. Also counters for ledger-specific variables (such as last receipt number) |
| CAMethodOfGivingRow | Special payment programs the donor may give money through. (ie, Gift Aid in the UK). Currently not used in Petra release 1 |
| CAMethodOfGivingTable | Special payment programs the donor may give money through. (ie, Gift Aid in the UK). Currently not used in Petra release 1 |
| CARecurringBatchRow | Templates of general ledger batches which can be copied into the ledger |
| CARecurringBatchTable | Templates of general ledger batches which can be copied into the ledger |
| CARecurringJournalRow | Templates of general ledger journals which are copied into the ledger with recurring general ledger batches |
| CARecurringJournalTable | Templates of general ledger journals which are copied into the ledger with recurring general ledger batches |
| CARecurringTransactionRow | Templates of general ledger transactions which are copied into the ledger with general ledger batches |
| CARecurringTransactionTable | Templates of general ledger transactions which are copied into the ledger with general ledger batches |
| CARecurringTransAnalAttribRow | Detailed analysis information stored along with the recurring transaction template |
| CARecurringTransAnalAttribTable | Detailed analysis information stored along with the recurring transaction template |
| CARevaluationRow | Holds information used specifically in revaluations. The table extends the a_journal table |
| CARevaluationTable | Holds information used specifically in revaluations. The table extends the a_journal table |
| CASpecialTransTypeRow | Transaction types which have special processing. Eg. Allocation, Reallocation, Gift, Revaluation |
| CASpecialTransTypeTable | Transaction types which have special processing. Eg. Allocation, Reallocation, Gift, Revaluation |
| CASubSystemRow | Subsystems to the general ledger which can be added and removed independantly. Eg GL, AP, AR, GR |
| CASubSystemTable | Subsystems to the general ledger which can be added and removed independantly. Eg GL, AP, AR, GR |
| CASuspenseAccountRow | Lists the suspense accounts of each ledger |
| CASuspenseAccountTable | Lists the suspense accounts of each ledger |
| CASystemInterfaceRow | Shows which systems are interfaced (have been added) to each general ledger |
| CASystemInterfaceTable | Shows which systems are interfaced (have been added) to each general ledger |
| CATransactionRow | Detailed information for each debit and credit in a general ledger journal |
| CATransactionTable | Detailed information for each debit and credit in a general ledger journal |
| CATransactionTypeRow | Various ways a transaction may originate, depending on the subsystem |
| CATransactionTypeTable | Various ways a transaction may originate, depending on the subsystem |
| CATransAnalAttribRow | Analysis information entered by the user for a general ledger transaction |
| CATransAnalAttribTable | Analysis information entered by the user for a general ledger transaction |
| CAValidLedgerNumberRow | List of foreign ledgers (eg, other fields) which the local ledger may send transctions to |
| CAValidLedgerNumberTable | List of foreign ledgers (eg, other fields) which the local ledger may send transctions to |
| CPEmailRow | Email addresses of our organisation |
| CPEmailTable | Email addresses of our organisation |
| ►NAP | |
| ►NData | |
| CAApAnalAttribRow | Analysis Attributes applied to an AP for posting to the GL |
| CAApAnalAttribTable | Analysis Attributes applied to an AP for posting to the GL |
| CAApDocumentDetailRow | An invoice or credit note consists out of several items, or details. This table contains all these details |
| CAApDocumentDetailTable | An invoice or credit note consists out of several items, or details. This table contains all these details |
| CAApDocumentPaymentRow | This table links the different payments to actual invoices and credit notes |
| CAApDocumentPaymentTable | This table links the different payments to actual invoices and credit notes |
| CAApDocumentRow | Either an invoice or a credit note in the Accounts Payable system |
| CAApDocumentTable | Either an invoice or a credit note in the Accounts Payable system |
| CAApPaymentRow | Records all payments that have been made against an accounts payable detail |
| CAApPaymentTable | Records all payments that have been made against an accounts payable detail |
| CAApSupplierRow | This table defines the concept of a supplier in the AP system and is the centre of the AP system |
| CAApSupplierTable | This table defines the concept of a supplier in the AP system and is the centre of the AP system |
| CAccountsPayableTDS | Auto generated |
| CAccountsPayableTDSAApDocumentDetailRow | An invoice or credit note consists out of several items, or details. This table contains all these details |
| CAccountsPayableTDSAApDocumentDetailTable | An invoice or credit note consists out of several items, or details. This table contains all these details |
| CAccountsPayableTDSAApDocumentPaymentRow | This table links the different payments to actual invoices and credit notes |
| CAccountsPayableTDSAApDocumentPaymentTable | This table links the different payments to actual invoices and credit notes |
| CAccountsPayableTDSAApDocumentRow | Either an invoice or a credit note in the Accounts Payable system |
| CAccountsPayableTDSAApDocumentTable | Either an invoice or a credit note in the Accounts Payable system |
| CAccountsPayableTDSAApPaymentRow | Records all payments that have been made against an accounts payable detail |
| CAccountsPayableTDSAApPaymentTable | Records all payments that have been made against an accounts payable detail |
| CACrdtNoteInvoiceLinkRow | This table receives a new entry when a credit note is applied to an invoice. Since the invoices and credit notes share the same table, we need a way to link the two, and this is the role of this table |
| CACrdtNoteInvoiceLinkTable | This table receives a new entry when a credit note is applied to an invoice. Since the invoices and credit notes share the same table, we need a way to link the two, and this is the role of this table |
| CAEpDocumentPaymentRow | This table links the different EP payments to actual invoices and credit notes |
| CAEpDocumentPaymentTable | This table links the different EP payments to actual invoices and credit notes |
| CAEpPaymentRow | This table acts as a queue for electronic payments. If an invoice is paid electronically, the payment is added to this table. A EP program will go through this table paying all entries to GL and moving them to the a_ap_payment table |
| CAEpPaymentTable | This table acts as a queue for electronic payments. If an invoice is paid electronically, the payment is added to this table. A EP program will go through this table paying all entries to GL and moving them to the a_ap_payment table |
| ►NAR | |
| ►NData | |
| CAArArticlePriceRow | Assign a price to an article, which can be updated by time |
| CAArArticlePriceTable | Assign a price to an article, which can be updated by time |
| CAArArticleRow | Defines an item that can be sold or a service that can be charged for; this can be used for catering, hospitality, store and fees; it can describe a specific book, or a group of equally priced books |
| CAArArticleTable | Defines an item that can be sold or a service that can be charged for; this can be used for catering, hospitality, store and fees; it can describe a specific book, or a group of equally priced books |
| CAArCategoryRow | There are several categories that are can use invoicing: catering, hospitality, store and fees |
| CAArCategoryTable | There are several categories that are can use invoicing: catering, hospitality, store and fees |
| CAArDefaultDiscountRow | Defines which discounts should be applied by default during a certain event or time period to articles from a certain category |
| CAArDefaultDiscountTable | Defines which discounts should be applied by default during a certain event or time period to articles from a certain category |
| CAArDiscountPerCategoryRow | Defines which discount applies to which category to limit the options in the UI |
| CAArDiscountPerCategoryTable | Defines which discount applies to which category to limit the options in the UI |
| CAArDiscountRow | Defines a discount that depends on other conditions or can just be assigned to an invoice or article |
| CAArDiscountTable | Defines a discount that depends on other conditions or can just be assigned to an invoice or article |
| CAArInvoiceDetailDiscountRow | Defines which discounts apply one invoice item |
| CAArInvoiceDetailDiscountTable | Defines which discounts apply one invoice item |
| CAArInvoiceDetailRow | Invoice consists of one or more details |
| CAArInvoiceDetailTable | Invoice consists of one or more details |
| CAArInvoiceDiscountRow | Defines which discounts apply directly to the invoice rather than the invoice items; this can depend on the customer etc |
| CAArInvoiceDiscountTable | Defines which discounts apply directly to the invoice rather than the invoice items; this can depend on the customer etc |
| CAArInvoiceRow | Invoice (which is also an offer at a certain stage) |
| CAArInvoiceTable | Invoice (which is also an offer at a certain stage) |
| CATaxTableRow | This is used by the invoicing |
| CATaxTableTable | This is used by the invoicing |
| CATaxTypeRow | Used for invoicing |
| CATaxTypeTable | Used for invoicing |
| ►NBankImport | |
| ►NData | |
| CBankImportTDS | Auto generated |
| CBankImportTDSAEpMatchRow | Matches that can be used to identify recurring gift or GL transactions |
| CBankImportTDSAEpMatchTable | Matches that can be used to identify recurring gift or GL transactions |
| CBankImportTDSAEpTransactionRow | Transactions from the recently imported bank statements; they should help to identify the other party of the transaction (donor, etc) and the purpose of the transaction |
| CBankImportTDSAEpTransactionTable | Transactions from the recently imported bank statements; they should help to identify the other party of the transaction (donor, etc) and the purpose of the transaction |
| CBankImportTDSAGiftDetailRow | 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 |
| CBankImportTDSAGiftDetailTable | 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 |
| CBankImportTDSAGiftRow | Information on the donor's giving. Points to the gift detail records |
| CBankImportTDSAGiftTable | Information on the donor's giving. Points to the gift detail records |
| CBankImportTDSPBankingDetailsRow | Any bank details for a partner can be stored in this table |
| CBankImportTDSPBankingDetailsTable | Any bank details for a partner can be stored in this table |
| CBankImportTDSTransactionDetailRow | Matches that can be used to identify recurring gift or GL transactions |
| CBankImportTDSTransactionDetailTable | Matches that can be used to identify recurring gift or GL transactions |
| ►NCrossLedger | |
| ►NData | |
| CExchangeRateTDS | Auto generated |
| CExchangeRateTDSADailyExchangeRateRow | Ad hoc exchange rates |
| CExchangeRateTDSADailyExchangeRateTable | Ad hoc exchange rates |
| CExchangeRateTDSADailyExchangeRateUsageRow | Ad hoc exchange rates |
| CExchangeRateTDSADailyExchangeRateUsageTable | Ad hoc exchange rates |
| CExchangeRateTDSALedgerInfoRow | Basic information for each general ledger on the system. Also counters for ledger-specific variables (such as last receipt number) |
| CExchangeRateTDSALedgerInfoTable | Basic information for each general ledger on the system. Also counters for ledger-specific variables (such as last receipt number) |
| CExchangeRateTDSARawDailyExchangeRateRow | Ad hoc exchange rates |
| CExchangeRateTDSARawDailyExchangeRateTable | Ad hoc exchange rates |
| ►NGift | |
| ►NData | |
| CAGiftBatchRow | Information describing groups (batches) of gifts |
| CAGiftBatchTable | Information describing groups (batches) of gifts |
| CAGiftDetailRow | 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 |
| CAGiftDetailTable | 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 |
| CAGiftRow | Information on the donor's giving. Points to the gift detail records |
| CAGiftTable | Information on the donor's giving. Points to the gift detail records |
| CAMethodOfPaymentRow | Media types of money received. Eg: Cash, Check Credit Card |
| CAMethodOfPaymentTable | Media types of money received. Eg: Cash, Check Credit Card |
| CAMotivationDetailFeeRow | Motivation details can have several fees |
| CAMotivationDetailFeeTable | Motivation details can have several fees |
| CAMotivationDetailRow | Used as a subdvision of motivation group. Details of the reason money has been received, where it is going (cost centre and account), and fees to be charged on it |
| CAMotivationDetailTable | Used as a subdvision of motivation group. Details of the reason money has been received, where it is going (cost centre and account), and fees to be charged on it |
| CAMotivationGroupRow | This is used to track a partner's reason for contacting the organisation/sending money. Divided into Motivation Detail codes |
| CAMotivationGroupTable | This is used to track a partner's reason for contacting the organisation/sending money. Divided into Motivation Detail codes |
| CAProcessedFeeRow | Stores administrative fees and grants which have been calculated on gifts |
| CAProcessedFeeTable | Stores administrative fees and grants which have been calculated on gifts |
| CARecurringGiftBatchRow | Templates of gift batches which can be copied into the gift system |
| CARecurringGiftBatchTable | Templates of gift batches which can be copied into the gift system |
| CARecurringGiftDetailRow | Store recipient information for the recurring gift |
| CARecurringGiftDetailTable | Store recipient information for the recurring gift |
| CARecurringGiftRow | Templates of donor gift information which can be copied into the gift system with recurring gift batches |
| CARecurringGiftTable | Templates of donor gift information which can be copied into the gift system with recurring gift batches |
| CGiftBatchTDS | Auto generated |
| CGiftBatchTDSAGiftBatchRow | Information describing groups (batches) of gifts |
| CGiftBatchTDSAGiftBatchTable | Information describing groups (batches) of gifts |
| CGiftBatchTDSAGiftDetailRow | 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 |
| CGiftBatchTDSAGiftDetailTable | 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 |
| CGiftBatchTDSAGiftRow | Information on the donor's giving. Points to the gift detail records |
| CGiftBatchTDSAGiftTable | Information on the donor's giving. Points to the gift detail records |
| CGiftBatchTDSARecurringGiftDetailRow | Store recipient information for the recurring gift |
| CGiftBatchTDSARecurringGiftDetailTable | Store recipient information for the recurring gift |
| CGiftBatchTDSARecurringGiftRow | Templates of donor gift information which can be copied into the gift system with recurring gift batches |
| CGiftBatchTDSARecurringGiftTable | Templates of donor gift information which can be copied into the gift system with recurring gift batches |
| CGiftBatchTDSPPartnerBankingDetailsRow | Links p_partner table with p_banking_details table for many to many relationship |
| CGiftBatchTDSPPartnerBankingDetailsTable | Links p_partner table with p_banking_details table for many to many relationship |
| ►NGL | |
| ►NData | |
| CBudgetTDS | Auto generated |
| CBudgetTDSABudgetRow | Budget information for cost centre-account combinations |
| CBudgetTDSABudgetTable | Budget information for cost centre-account combinations |
| CCorporateExchangeSetupTDS | Auto generated |
| CGLBatchTDS | Auto generated |
| CGLBatchTDSABatchRow | Store current and forward period general ledger batches for a ledger |
| CGLBatchTDSABatchTable | Store current and forward period general ledger batches for a ledger |
| CGLBatchTDSAJournalRow | Holds details of each general ledger journal, which contains a group of transactions |
| CGLBatchTDSAJournalTable | Holds details of each general ledger journal, which contains a group of transactions |
| CGLBatchTDSARecurringJournalRow | Templates of general ledger journals which are copied into the ledger with recurring general ledger batches |
| CGLBatchTDSARecurringJournalTable | Templates of general ledger journals which are copied into the ledger with recurring general ledger batches |
| CGLBatchTDSARecurringTransactionRow | Templates of general ledger transactions which are copied into the ledger with general ledger batches |
| CGLBatchTDSARecurringTransactionTable | Templates of general ledger transactions which are copied into the ledger with general ledger batches |
| CGLBatchTDSATransactionRow | Detailed information for each debit and credit in a general ledger journal |
| CGLBatchTDSATransactionTable | Detailed information for each debit and credit in a general ledger journal |
| CGLPostingTDS | Auto generated |
| CGLReportingTDS | Auto generated |
| CGLReportingTDSATransactionRow | Detailed information for each debit and credit in a general ledger journal |
| CGLReportingTDSATransactionTable | Detailed information for each debit and credit in a general ledger journal |
| CGLSetupTDS | Auto generated |
| CGLSetupTDSAAccountRow | Details about each account code within a ledger. Also holds information on the summary account structure for reporting |
| CGLSetupTDSAAccountTable | Details about each account code within a ledger. Also holds information on the summary account structure for reporting |
| CGLStewardshipCalculationTDS | Auto generated |
| CGLStewardshipCalculationTDSCreditFeeTotalRow | |
| CGLStewardshipCalculationTDSCreditFeeTotalTable | |
| CSuspenseAccountTDS | Auto generated |
| ►NValidation | |
| CTFinanceValidation_Setup | Contains functions for the validation of MFinance Maintain Table screens. |
| CCommonRoutines | Contains several functions which are specific to the Petra Finance Module. |
| CGLRoutines | useful routines that are used on both server and client |
| CMFinanceConstants | some constants used in the finance module |
| CTaxDeductibility | Contains several functions which are specific to the Petra Finance Module. |
| ►NMHospitality | |
| ►NData | |
| CHospitalityTDS | Auto generated |
| CPcBuildingRow | Details of building used for accomodation at a conference |
| CPcBuildingTable | Details of building used for accomodation at a conference |
| CPcRoomAllocRow | Links rooms to attendees of a conference or a booking in the hospitality module |
| CPcRoomAllocTable | Links rooms to attendees of a conference or a booking in the hospitality module |
| CPcRoomAttributeRow | Attributes assigned to rooms used for accommodation at a conference |
| CPcRoomAttributeTable | Attributes assigned to rooms used for accommodation at a conference |
| CPcRoomAttributeTypeRow | Contains type of attributes that can be assigned to a room |
| CPcRoomAttributeTypeTable | Contains type of attributes that can be assigned to a room |
| CPcRoomRow | Details of rooms used for accommodation at a conference |
| CPcRoomTable | Details of rooms used for accommodation at a conference |
| CPhBookingRow | Make sure charging works for a group or an individual; this summarises all the hospitality services that have to be paid for; also useful for planning meals in the kitchen and room preparation |
| CPhBookingTable | Make sure charging works for a group or an individual; this summarises all the hospitality services that have to be paid for; also useful for planning meals in the kitchen and room preparation |
| CPhRoomBookingRow | Links room allocations and a booking |
| CPhRoomBookingTable | Links room allocations and a booking |
| ►NMPartner | |
| ►NMailroom | |
| ►NData | |
| CMExtractMasterRow | Master file for extracts. Contains names for the extract id |
| CMExtractMasterTable | Master file for extracts. Contains names for the extract id |
| CMExtractParameterRow | Contains a list of parameters that an extract was run with (so it can be rerun) |
| CMExtractParameterTable | Contains a list of parameters that an extract was run with (so it can be rerun) |
| CMExtractRow | Contains the list of partners in each mailing extract |
| CMExtractTable | Contains the list of partners in each mailing extract |
| CMExtractTypeRow | Contains a list of extract type which is needed when extracts need to be rerun |
| CMExtractTypeTable | Contains a list of extract type which is needed when extracts need to be rerun |
| CPAddressBlockElementRow | This contains the elements which make up an address. Eg Name etc |
| CPAddressBlockElementTable | This contains the elements which make up an address. Eg Name etc |
| CPAddressBlockRow | This table contains the address lines used in laying out an address. Eg a form letter address layout |
| CPAddressBlockTable | This table contains the address lines used in laying out an address. Eg a form letter address layout |
| CPAddresseeTitleOverrideRow | |
| CPAddresseeTitleOverrideTable | |
| CPAddressElementRow | This contains the elements which make up an address. Eg Name etc |
| CPAddressElementTable | This contains the elements which make up an address. Eg Name etc |
| CPAddressLayoutCodeRow | This table contains the address layouts generally available for the user |
| CPAddressLayoutCodeTable | This table contains the address layouts generally available for the user |
| CPAddressLayoutRow | This table contains the address lines used in laying out an address. Eg a form letter address layout |
| CPAddressLayoutTable | This table contains the address lines used in laying out an address. Eg a form letter address layout |
| CPAddressLineRow | This is an address line which consists of address elements. Used along with p_address_layout and p_address_element to define layout of an address for different countries |
| CPAddressLineTable | This is an address line which consists of address elements. Used along with p_address_layout and p_address_element to define layout of an address for different countries |
| CPContactAttributeDetailRow | Possible attribute details for each contact attribute. Breaks down the attribute into more specifice information that applies to a contact with a partner |
| CPContactAttributeDetailTable | Possible attribute details for each contact attribute. Breaks down the attribute into more specifice information that applies to a contact with a partner |
| CPContactAttributeRow | Possible attributes for partner contacts. Gives the description of each attribute code. An attribute is a type of contact that was made or which occurred with a partner |
| CPContactAttributeTable | Possible attributes for partner contacts. Gives the description of each attribute code. An attribute is a type of contact that was made or which occurred with a partner |
| CPContactLogRow | Details of contacts with partners |
| CPContactLogTable | Details of contacts with partners |
| CPCustomisedGreetingRow | Specific greetings from a user to a partner |
| CPCustomisedGreetingTable | Specific greetings from a user to a partner |
| CPFormalityRow | Contains the text used in letters |
| CPFormalityTable | Contains the text used in letters |
| CPFormRow | The form description for user definable forms such as receipts |
| CPFormTable | The form description for user definable forms such as receipts |
| CPLabelRow | Defines the attributes of different label types. Eg: for address labels |
| CPLabelTable | Defines the attributes of different label types. Eg: for address labels |
| CPMailingRow | Lists mailings that are being tracked. When entering gifts, the mailing that motivated the gift can be indicated |
| CPMailingTable | Lists mailings that are being tracked. When entering gifts, the mailing that motivated the gift can be indicated |
| CPMergeFieldRow | Fields within a Mail Merge Form |
| CPMergeFieldTable | Fields within a Mail Merge Form |
| CPMergeFormRow | Master record for Mail Merge output creation |
| CPMergeFormTable | Master record for Mail Merge output creation |
| CPMethodOfContactRow | How contacts are made |
| CPMethodOfContactTable | How contacts are made |
| CPPartnerContactAttributeRow | Associates a p_contact_attribute_detail with a p_contact_log. A contact log may have more than one p_contact_attribute_detail associated with it |
| CPPartnerContactAttributeTable | Associates a p_contact_attribute_detail with a p_contact_log. A contact log may have more than one p_contact_attribute_detail associated with it |
| CPPartnerContactRow | Link between Partners and Contacts |
| CPPartnerContactTable | Link between Partners and Contacts |
| CPPostcodeRangeRow | Postcode ranges for each region |
| CPPostcodeRangeTable | Postcode ranges for each region |
| CPPostcodeRegionRangeRow | Links ranges to a region |
| CPPostcodeRegionRangeTable | Links ranges to a region |
| CPPostcodeRegionRow | List postcode regions |
| CPPostcodeRegionTable | List postcode regions |
| CPPublicationCostRow | Cost of a publication |
| CPPublicationCostTable | Cost of a publication |
| CPPublicationRow | Details of a publication |
| CPPublicationTable | Details of a publication |
| CPReasonSubscriptionCancelledRow | List of reasons for cancelling a subscription |
| CPReasonSubscriptionCancelledTable | List of reasons for cancelling a subscription |
| CPReasonSubscriptionGivenRow | List of reasons for giving a subscription |
| CPReasonSubscriptionGivenTable | List of reasons for giving a subscription |
| CPSubscriptionRow | Details of which partners receive which publications |
| CPSubscriptionTable | Details of which partners receive which publications |
| ►NPartner | |
| ►NData | |
| CBankTDS | Auto generated |
| CBankTDSPBankRow | Details of an bank |
| CBankTDSPBankTable | Details of an bank |
| CContactTDS | Auto generated |
| CDataConsentTDS | Auto generated |
| CDataConsentTDSPConsentHistoryRow | Keeps track of all data changes for GDPR |
| CDataConsentTDSPConsentHistoryTable | Keeps track of all data changes for GDPR |
| CExtractTDS | Auto generated |
| CExtractTDSMExtractMasterRow | Master file for extracts. Contains names for the extract id |
| CExtractTDSMExtractMasterTable | Master file for extracts. Contains names for the extract id |
| CExtractTDSMExtractRow | Contains the list of partners in each mailing extract |
| CExtractTDSMExtractTable | Contains the list of partners in each mailing extract |
| CPAcquisitionRow | This table is used to describe how a partner first came into contact with the organisation. Which department entered them |
| CPAcquisitionTable | This table is used to describe how a partner first came into contact with the organisation. Which department entered them |
| CPActionRow | A particular action within a process which can be performed on a Partner |
| CPActionTable | A particular action within a process which can be performed on a Partner |
| CPAddresseeTypeRow | Ex. Fam - Family, SM - Single Male, etc |
| CPAddresseeTypeTable | Ex. Fam - Family, SM - Single Male, etc |
| CPartnerAddressAggregateTDS | Auto generated |
| CPartnerAddressAggregateTDSAddressAddedOrChangedPromotionRow | |
| CPartnerAddressAggregateTDSAddressAddedOrChangedPromotionTable | |
| CPartnerAddressAggregateTDSChangePromotionParametersRow | |
| CPartnerAddressAggregateTDSChangePromotionParametersTable | |
| CPartnerAddressAggregateTDSSimilarLocationParametersRow | Address and other data related to that address |
| CPartnerAddressAggregateTDSSimilarLocationParametersTable | Address and other data related to that address |
| CPartnerContactSetupTDS | Auto generated |
| CPartnerEditTDS | Auto generated |
| CPartnerEditTDSAGiftDetailRow | 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 |
| CPartnerEditTDSAGiftDetailTable | 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 |
| CPartnerEditTDSFamilyMembersInfoForStatusChangeRow | |
| CPartnerEditTDSFamilyMembersInfoForStatusChangeTable | |
| CPartnerEditTDSFamilyMembersRow | |
| CPartnerEditTDSFamilyMembersTable | |
| CPartnerEditTDSMiscellaneousDataRow | |
| CPartnerEditTDSMiscellaneousDataTable | |
| CPartnerEditTDSPartnerTypeChangeFamilyMembersPromotionRow | |
| CPartnerEditTDSPartnerTypeChangeFamilyMembersPromotionTable | |
| CPartnerEditTDSPBankingDetailsRow | Any bank details for a partner can be stored in this table |
| CPartnerEditTDSPBankingDetailsTable | Any bank details for a partner can be stored in this table |
| CPartnerEditTDSPFamilyRow | Contains details about a family in Partnership with us. May have P_Person records linked to it |
| CPartnerEditTDSPFamilyTable | Contains details about a family in Partnership with us. May have P_Person records linked to it |
| CPartnerEditTDSPPartnerAttributeRow | Mainly introduced for Partner Contact Details like email addresses and (mobile) phone numbers, but can be used for any attribute we might want to save for a Partner |
| CPartnerEditTDSPPartnerAttributeTable | Mainly introduced for Partner Contact Details like email addresses and (mobile) phone numbers, but can be used for any attribute we might want to save for a Partner |
| CPartnerEditTDSPPartnerInterestRow | Partner Area of Interest |
| CPartnerEditTDSPPartnerInterestTable | Partner Area of Interest |
| CPartnerEditTDSPPartnerLocationRow | Links partners with locations (addresses) and has specific info about the link (e.g. date effective) |
| CPartnerEditTDSPPartnerLocationTable | Links partners with locations (addresses) and has specific info about the link (e.g. date effective) |
| CPartnerEditTDSPPartnerRelationshipRow | Relationships between pairs of partners. Among other relationships, this also relates the FAMILY class partners to the PERSON class partners to indicate members of a family |
| CPartnerEditTDSPPartnerRelationshipTable | Relationships between pairs of partners. Among other relationships, this also relates the FAMILY class partners to the PERSON class partners to indicate members of a family |
| CPartnerEditTDSPPersonRow | DEPRECATED. USE P_FAMILY INSTEAD. Details of a person. A person must also have a related FAMILY class p_partner record |
| CPartnerEditTDSPPersonTable | DEPRECATED. USE P_FAMILY INSTEAD. Details of a person. A person must also have a related FAMILY class p_partner record |
| CPartnerFindTDS | Auto generated |
| CPartnerFindTDSSearchCriteriaRow | |
| CPartnerFindTDSSearchCriteriaTable | |
| CPartnerFindTDSSearchResultRow | |
| CPartnerFindTDSSearchResultTable | |
| CPartnerImportExportTDS | Auto generated |
| CPartnerImportExportTDSOutputDataRow | |
| CPartnerImportExportTDSOutputDataTable | |
| CPartnerImportExportTDSPConsentHistoryRow | Keeps track of all data changes for GDPR |
| CPartnerImportExportTDSPConsentHistoryTable | Keeps track of all data changes for GDPR |
| CPartnerImportExportTDSPContactLogRow | Details of contacts with partners |
| CPartnerImportExportTDSPContactLogTable | Details of contacts with partners |
| CPartnerImportExportTDSPmDocumentRow | Document |
| CPartnerImportExportTDSPmDocumentTable | Document |
| CPartnerImportExportTDSPPartnerInterestRow | Partner Area of Interest |
| CPartnerImportExportTDSPPartnerInterestTable | Partner Area of Interest |
| CPartnerInfoTDS | Auto generated |
| CPartnerInfoTDSFamilyMembersRow | |
| CPartnerInfoTDSFamilyMembersTable | |
| CPartnerInfoTDSPartnerAdditionalInfoRow | |
| CPartnerInfoTDSPartnerAdditionalInfoTable | |
| CPartnerInfoTDSPartnerHeadInfoRow | |
| CPartnerInfoTDSPartnerHeadInfoTable | |
| CPartnerInfoTDSPPartnerAttributeRow | Mainly introduced for Partner Contact Details like email addresses and (mobile) phone numbers, but can be used for any attribute we might want to save for a Partner |
| CPartnerInfoTDSPPartnerAttributeTable | Mainly introduced for Partner Contact Details like email addresses and (mobile) phone numbers, but can be used for any attribute we might want to save for a Partner |
| CPartnerInfoTDSUnitInfoRow | |
| CPartnerInfoTDSUnitInfoTable | |
| CPartnerSetupTDS | Auto generated |
| CPBankingDetailsRow | Any bank details for a partner can be stored in this table |
| CPBankingDetailsTable | Any bank details for a partner can be stored in this table |
| CPBankingDetailsUsageRow | Links p_partner - p_banking_details combination to a usage type |
| CPBankingDetailsUsageTable | Links p_partner - p_banking_details combination to a usage type |
| CPBankingDetailsUsageTypeRow | Usage type information for Banking Details |
| CPBankingDetailsUsageTypeTable | Usage type information for Banking Details |
| CPBankingTypeRow | Tells of what type this banking-detail is (bank-account, visa, mastercard, etc |
| CPBankingTypeTable | Tells of what type this banking-detail is (bank-account, visa, mastercard, etc |
| CPBankRow | Details of an bank |
| CPBankTable | Details of an bank |
| CPBusinessRow | List of businesses with codes |
| CPBusinessTable | List of businesses with codes |
| CPChurchRow | Specific information about a church which is a partner |
| CPChurchTable | Specific information about a church which is a partner |
| CPConsentChannelRow | All possible channels to get data changes and consent |
| CPConsentChannelTable | All possible channels to get data changes and consent |
| CPConsentHistoryPermissionRow | The history of consent for personal data |
| CPConsentHistoryPermissionTable | The history of consent for personal data |
| CPConsentHistoryRow | Keeps track of all data changes for GDPR |
| CPConsentHistoryTable | Keeps track of all data changes for GDPR |
| CPConsentPurposeRow | Purposes for consent, for which the data may be used |
| CPConsentPurposeTable | Purposes for consent, for which the data may be used |
| CPDataLabelLookupCategoryRow | This table holds the categories that can be used for data label values |
| CPDataLabelLookupCategoryTable | This table holds the categories that can be used for data label values |
| CPDataLabelLookupRow | This table holds all lookup values that can be used for data label values |
| CPDataLabelLookupTable | This table holds all lookup values that can be used for data label values |
| CPDataLabelRow | This table is used to define data labels for individual use in each office |
| CPDataLabelTable | This table is used to define data labels for individual use in each office |
| CPDataLabelUseRow | This table defines where a data label is used and the order the labels appear in |
| CPDataLabelUseTable | This table defines where a data label is used and the order the labels appear in |
| CPDataLabelValuePartnerRow | This table holds the label values for partner related data |
| CPDataLabelValuePartnerTable | This table holds the label values for partner related data |
| CPDenominationRow | List of denomination codes for churches |
| CPDenominationTable | List of denomination codes for churches |
| CPFamilyRow | Contains details about a family in Partnership with us. May have P_Person records linked to it |
| CPFamilyTable | Contains details about a family in Partnership with us. May have P_Person records linked to it |
| CPFileInfoRow | Store information about the physical location of a file linked into Petra |
| CPFileInfoTable | Store information about the physical location of a file linked into Petra |
| CPFirstContactRow | Lookup table for First Contact Codes (ie. how did person first hear about us) |
| CPFirstContactTable | Lookup table for First Contact Codes (ie. how did person first hear about us) |
| CPFoundationDeadlineRow | The month and day of reviews so that proposals can be sent in time |
| CPFoundationDeadlineTable | The month and day of reviews so that proposals can be sent in time |
| CPFoundationProposalDetailRow | A proposal may be for more than one project or key ministry |
| CPFoundationProposalDetailTable | A proposal may be for more than one project or key ministry |
| CPFoundationProposalRow | Proposals submitted to a Foundation |
| CPFoundationProposalStatusRow | Foundation proposal status codes and descriptions |
| CPFoundationProposalStatusTable | Foundation proposal status codes and descriptions |
| CPFoundationProposalTable | Proposals submitted to a Foundation |
| CPFoundationRow | Foundations - a type of ORGANISATION for fundraising proposals |
| CPFoundationTable | Foundations - a type of ORGANISATION for fundraising proposals |
| CPInterestCategoryRow | Categories for Area of Interest |
| CPInterestCategoryTable | Categories for Area of Interest |
| CPInterestRow | Area of Interest |
| CPInterestTable | Area of Interest |
| CPLocationRow | Address and other data related to that address |
| CPLocationTable | Address and other data related to that address |
| CPLocationTypeRow | Types of address e.g. home, business |
| CPLocationTypeTable | Types of address e.g. home, business |
| CPMembershipRow | Details of a membership |
| CPMembershipTable | Details of a membership |
| CPmPersonFileRow | Link file with a person |
| CPmPersonFileTable | Link file with a person |
| CPOccupationRow | List of occupations with codes |
| CPOccupationTable | List of occupations with codes |
| CPOrganisationRow | Details of an organisation |
| CPOrganisationTable | Details of an organisation |
| CPostcodeRegionsTDS | Auto generated |
| CPostcodeRegionsTDSPPostcodeRegionRangeRow | Links ranges to a region |
| CPostcodeRegionsTDSPPostcodeRegionRangeTable | Links ranges to a region |
| CPPartnerActionRow | A particular action which has been or needs to be applied to a Partner |
| CPPartnerActionTable | A particular action which has been or needs to be applied to a Partner |
| CPPartnerAttributeCategoryRow | Holds categories that categorise Partner Attributes Types, thus allowing logical grouping of the latter (e.g. to have all Partner Attributes Types that are to do with phone numbers in one category) |
| CPPartnerAttributeCategoryTable | Holds categories that categorise Partner Attributes Types, thus allowing logical grouping of the latter (e.g. to have all Partner Attributes Types that are to do with phone numbers in one category) |
| CPPartnerAttributeRow | Mainly introduced for Partner Contact Details like email addresses and (mobile) phone numbers, but can be used for any attribute we might want to save for a Partner |
| CPPartnerAttributeTable | Mainly introduced for Partner Contact Details like email addresses and (mobile) phone numbers, but can be used for any attribute we might want to save for a Partner |
| CPPartnerAttributeTypeRow | Holds various Partner Attribute Types |
| CPPartnerAttributeTypeTable | Holds various Partner Attribute Types |
| CPPartnerBankingDetailsRow | Links p_partner table with p_banking_details table for many to many relationship |
| CPPartnerBankingDetailsTable | Links p_partner table with p_banking_details table for many to many relationship |
| CPPartnerClassesRow | The class a partner is (PERSON, UNIT, etc |
| CPPartnerClassesTable | The class a partner is (PERSON, UNIT, etc |
| CPPartnerCommentRow | Allows multiple as well as arbitrary-length partner comments |
| CPPartnerCommentTable | Allows multiple as well as arbitrary-length partner comments |
| CPPartnerContactFileRow | Link file with a partner contact |
| CPPartnerContactFileTable | Link file with a partner contact |
| CPPartnerFileRow | Link file with a partner |
| CPPartnerFileTable | Link file with a partner |
| CPPartnerGiftDestinationRow | Tracks the current gift destination for the Partner and maintains a history |
| CPPartnerGiftDestinationTable | Tracks the current gift destination for the Partner and maintains a history |
| CPPartnerGraphicRow | Any graphic associated to a partner can be stored here |
| CPPartnerGraphicTable | Any graphic associated to a partner can be stored here |
| CPPartnerInterestRow | Partner Area of Interest |
| CPPartnerInterestTable | Partner Area of Interest |
| CPPartnerLedgerRow | Used to keep track of partner keys |
| CPPartnerLedgerTable | Used to keep track of partner keys |
| CPPartnerLocationRow | Links partners with locations (addresses) and has specific info about the link (e.g. date effective) |
| CPPartnerLocationTable | Links partners with locations (addresses) and has specific info about the link (e.g. date effective) |
| CPPartnerMembershipPaidRow | There is a record for each payment of a membership, or hours served |
| CPPartnerMembershipPaidTable | There is a record for each payment of a membership, or hours served |
| CPPartnerMembershipRow | Membership of a partner |
| CPPartnerMembershipTable | Membership of a partner |
| CPPartnerMergeRow | Partner merge history |
| CPPartnerMergeTable | Partner merge history |
| CPPartnerRelationshipRow | Relationships between pairs of partners. Among other relationships, this also relates the FAMILY class partners to the PERSON class partners to indicate members of a family |
| CPPartnerRelationshipTable | Relationships between pairs of partners. Among other relationships, this also relates the FAMILY class partners to the PERSON class partners to indicate members of a family |
| CPPartnerReminderRow | A reminder that can be linked to a Partner or Partner contact |
| CPPartnerReminderTable | A reminder that can be linked to a Partner or Partner contact |
| CPPartnerRow | This is the main table of the partner system. Partners can be individuals, families, organisations (churches, businesses), fields, cost centers, and others. These represent various classes of partners |
| CPPartnerSetPartnerRow | Places Partners in a Partner set |
| CPPartnerSetPartnerTable | Places Partners in a Partner set |
| CPPartnerSetRow | Defines a Partner set |
| CPPartnerSetTable | Defines a Partner set |
| CPPartnerShortCodeRow | Stores one or more short codes for a Partner (eg. a donor or recipient code for online giving system) |
| CPPartnerShortCodeTable | Stores one or more short codes for a Partner (eg. a donor or recipient code for online giving system) |
| CPPartnerStateRow | A particular state in which the Partner is or has been. The Partner may be in more than one state at one time if there are two different processes relating to them |
| CPPartnerStateTable | A particular state in which the Partner is or has been. The Partner may be in more than one state at one time if there are two different processes relating to them |
| CPPartnerStatusRow | List of statuses for partners |
| CPPartnerStatusTable | List of statuses for partners |
| CPPartnerTable | This is the main table of the partner system. Partners can be individuals, families, organisations (churches, businesses), fields, cost centers, and others. These represent various classes of partners |
| CPPartnerTaxDeductiblePctRow | Specifies the percentage of incoming gifts to this recipient that can be considered tax deductible |
| CPPartnerTaxDeductiblePctTable | Specifies the percentage of incoming gifts to this recipient that can be considered tax deductible |
| CPPartnerTypeRow | Types assigned to each partner. Also known as special types |
| CPPartnerTypeTable | Types assigned to each partner. Also known as special types |
| CPPersonRow | DEPRECATED. USE P_FAMILY INSTEAD. Details of a person. A person must also have a related FAMILY class p_partner record |
| CPPersonTable | DEPRECATED. USE P_FAMILY INSTEAD. Details of a person. A person must also have a related FAMILY class p_partner record |
| CPProcessRow | Refers to a process through which a Partner may go (eg. application, different status of donor - small->medium->big, etc) |
| CPProcessTable | Refers to a process through which a Partner may go (eg. application, different status of donor - small->medium->big, etc) |
| CPProposalSubmissionTypeRow | Submission type for foundation proposals e.g. EMAIL, LETTER |
| CPProposalSubmissionTypeTable | Submission type for foundation proposals e.g. EMAIL, LETTER |
| CPRecentPartnersRow | The partners a user has been working with recently |
| CPRecentPartnersTable | The partners a user has been working with recently |
| CPRelationCategoryRow | This table contains the codes that indicate the categories of relations (grouping) |
| CPRelationCategoryTable | This table contains the codes that indicate the categories of relations (grouping) |
| CPRelationRow | List of relationships between partners. Relations occur in one direction only. The relation code is used in the p_partner_relationship record |
| CPRelationTable | List of relationships between partners. Relations occur in one direction only. The relation code is used in the p_partner_relationship record |
| CPReminderCategoryRow | This table contains the codes that indicate the categories of reminders |
| CPReminderCategoryTable | This table contains the codes that indicate the categories of reminders |
| CPStateRow | A particular state within a process which can apply to a Partner. Each state will probably need to have an Idle state to indicate when no state applies |
| CPStateTable | A particular state within a process which can apply to a Partner. Each state will probably need to have an Idle state to indicate when no state applies |
| CPTaxRow | Tax reference numbers |
| CPTaxTable | Tax reference numbers |
| CPTitleRow | Titles available for use |
| CPTitleTable | Titles available for use |
| CPtMaritalStatusRow | This table contains the codes indicating someones marital status |
| CPtMaritalStatusTable | This table contains the codes indicating someones marital status |
| CPTypeCategoryRow | This table contains the codes that indicate the categories of partner (special) types |
| CPTypeCategoryTable | This table contains the codes that indicate the categories of partner (special) types |
| CPTypeRow | List of all possible special types for a partner |
| CPTypeTable | List of all possible special types for a partner |
| CPUnitRow | Details of a unit. This is an organizational unit such as an om field, department, local cost center, etc |
| CPUnitTable | Details of a unit. This is an organizational unit such as an om field, department, local cost center, etc |
| CPVenueRow | Details of a venue |
| CPVenueTable | Details of a venue |
| CUmUnitStructureRow | This contains parent/child relationships |
| CUmUnitStructureTable | This contains parent/child relationships |
| CUUnitTypeRow | General information about the unit such as unit type and entry conference |
| CUUnitTypeTable | General information about the unit such as unit type and entry conference |
| CEPartnerFamilyIDException | Throw this exception to signalize that there is a problem in finding a family ID |
| CEPartnerLocationNotExistantException | Can be thrown to signalise that a PPartnerLocation Key does not exist in the DB |
| CEPartnerNotExistantException | Throw this Exception when a Business Object is asked to load data for a Partner that does either not exist or is deleted, not active, etc. whatever is applicable to the situation. |
| CESecurityPartnerAccessDeniedException | Thrown if a Partner cannot be opened for security reasons |
| CMPartnerConstants | some constants used in the partner module |
| CTLocationPK | Class that holds a combination of SiteKey and LocationKey. |
| CTLocationPKCopyHelper | Static helper class for creating 'deep copies' of two-dimensional TLocationPK arrays. |
| CTSecurity | Contains security-related functions for Partners that that can be used by any Class. |
| ►NMPersonnel | |
| NPerson | |
| ►NPersonnel | |
| ►NData | |
| CApplicationTDS | Auto generated |
| CIndividualDataTDS | Auto generated |
| CIndividualDataTDSJobAssignmentStaffDataCombinedRow | |
| CIndividualDataTDSJobAssignmentStaffDataCombinedTable | |
| CIndividualDataTDSMiscellaneousDataRow | |
| CIndividualDataTDSMiscellaneousDataTable | |
| CIndividualDataTDSPmGeneralApplicationRow | The first part of any application which contains data common to either short term or long term applications |
| CIndividualDataTDSPmGeneralApplicationTable | The first part of any application which contains data common to either short term or long term applications |
| CIndividualDataTDSPmPassportDetailsRow | Passport Details |
| CIndividualDataTDSPmPassportDetailsTable | Passport Details |
| CIndividualDataTDSPmPastExperienceRow | This details any previous ministry experience the individual has |
| CIndividualDataTDSPmPastExperienceTable | This details any previous ministry experience the individual has |
| CIndividualDataTDSPmPersonLanguageRow | |
| CIndividualDataTDSPmPersonLanguageTable | |
| CIndividualDataTDSPPartnerAttributeRow | Mainly introduced for Partner Contact Details like email addresses and (mobile) phone numbers, but can be used for any attribute we might want to save for a Partner |
| CIndividualDataTDSPPartnerAttributeTable | Mainly introduced for Partner Contact Details like email addresses and (mobile) phone numbers, but can be used for any attribute we might want to save for a Partner |
| CIndividualDataTDSSummaryDataRow | |
| CIndividualDataTDSSummaryDataTable | |
| CLengthOfCommitmentReportTDS | Auto generated |
| CLengthOfCommitmentReportTDSPmStaffDataRow | This table contains information regarding recruitment, home office, field office, etc. |
| CLengthOfCommitmentReportTDSPmStaffDataTable | This table contains information regarding recruitment, home office, field office, etc. |
| CPDataLabelValueApplicationRow | This table holds the label values for application related data |
| CPDataLabelValueApplicationTable | This table holds the label values for application related data |
| CPersonnelTDS | Auto generated |
| CPmApplicationFileRow | Link file with an application |
| CPmApplicationFileTable | Link file with an application |
| CPmApplicationStatusHistoryRow | Keeps a history of the application status for short and long term applications |
| CPmApplicationStatusHistoryTable | Keeps a history of the application status for short and long term applications |
| CPmCommitmentStatusRow | This table holds the statuses that are be used for commitments |
| CPmCommitmentStatusTable | This table holds the statuses that are be used for commitments |
| CPmDocumentCategoryRow | This table contains the codes that indicate the categories of document types (grouping) |
| CPmDocumentCategoryTable | This table contains the codes that indicate the categories of document types (grouping) |
| CPmDocumentFileRow | Link file with a personal document |
| CPmDocumentFileTable | Link file with a personal document |
| CPmDocumentRow | Document |
| CPmDocumentTable | Document |
| CPmDocumentTypeRow | This table contains the codes that indicate the types of documents for a person |
| CPmDocumentTypeTable | This table contains the codes that indicate the types of documents for a person |
| CPmFormalEducationRow | This table records the formal education that a person has |
| CPmFormalEducationTable | This table records the formal education that a person has |
| CPmGeneralApplicationRow | The first part of any application which contains data common to either short term or long term applications |
| CPmGeneralApplicationTable | The first part of any application which contains data common to either short term or long term applications |
| CPmJobAssignmentRow | This defines the position one fills |
| CPmJobAssignmentTable | This defines the position one fills |
| CPmPassportDetailsRow | Passport Details |
| CPmPassportDetailsTable | Passport Details |
| CPmPastExperienceRow | This details any previous ministry experience the individual has |
| CPmPastExperienceTable | This details any previous ministry experience the individual has |
| CPmPersonAbilityRow | |
| CPmPersonAbilityTable | |
| CPmPersonAbsenceRow | This table records the absence of a person (holiday, sickness, etc.) |
| CPmPersonAbsenceTable | This table records the absence of a person (holiday, sickness, etc.) |
| CPmPersonalDataRow | This table contains personal data about our staff, eg. tax id |
| CPmPersonalDataTable | This table contains personal data about our staff, eg. tax id |
| CPmPersonCommitmentStatusRow | This table holds the commitment type history of a person |
| CPmPersonCommitmentStatusTable | This table holds the commitment type history of a person |
| CPmPersonEvaluationRow | This table contains information regarding personal progress reports |
| CPmPersonEvaluationTable | This table contains information regarding personal progress reports |
| CPmPersonLanguageRow | |
| CPmPersonLanguageTable | |
| CPmPersonQualificationRow | This table provides detail on qualifications someone may possess |
| CPmPersonQualificationTable | This table provides detail on qualifications someone may possess |
| CPmPersonSkillRow | This table describes the skills that a person has (including professional skills but also other ones) |
| CPmPersonSkillTable | This table describes the skills that a person has (including professional skills but also other ones) |
| CPmShortTermApplicationRow | Table for short term applications |
| CPmShortTermApplicationTable | Table for short term applications |
| CPmSpecialNeedRow | This table includes special medical or dietary needs someone may have |
| CPmSpecialNeedTable | This table includes special medical or dietary needs someone may have |
| CPmStaffDataRow | This table contains information regarding recruitment, home office, field office, etc. |
| CPmStaffDataTable | This table contains information regarding recruitment, home office, field office, etc. |
| CPmYearProgramApplicationRow | This table contains information pertaining to the application process |
| CPmYearProgramApplicationTable | This table contains information pertaining to the application process |
| CPtAbilityAreaRow | Defines the areas in which a person may possess an ability, e.g. plays the guitar |
| CPtAbilityAreaTable | Defines the areas in which a person may possess an ability, e.g. plays the guitar |
| CPtAbilityLevelRow | |
| CPtAbilityLevelTable | |
| CPtApplicantStatusRow | This table contains the different codes that indicate where an applicant is in the application continuum |
| CPtApplicantStatusTable | This table contains the different codes that indicate where an applicant is in the application continuum |
| CPtApplicationTypeRow | This decribes the type of application a person has submitted, e.g, Short-Term, Long-Term, or 2 years |
| CPtApplicationTypeTable | This decribes the type of application a person has submitted, e.g, Short-Term, Long-Term, or 2 years |
| CPtArrivalPointRow | This table contains the codes used to indicate where the conferee is arriving or departing |
| CPtArrivalPointTable | This table contains the codes used to indicate where the conferee is arriving or departing |
| CPtCongressCodeRow | This table contains the codes that indicate a person's role and/or position at conferences and outreachs |
| CPtCongressCodeTable | This table contains the codes that indicate a person's role and/or position at conferences and outreachs |
| CPtContactRow | This list the various methods by which a person learns of this organisation. This table can be changed to fit any field's particular awareness programs |
| CPtContactTable | This list the various methods by which a person learns of this organisation. This table can be changed to fit any field's particular awareness programs |
| CPtLanguageLevelRow | This is the degree to which a language is spoken, e.g. a little, phrases, fluent |
| CPtLanguageLevelTable | This is the degree to which a language is spoken, e.g. a little, phrases, fluent |
| CPtLeadershipRatingRow | This table contains the codes indicating the leadership potential of someone |
| CPtLeadershipRatingTable | This table contains the codes indicating the leadership potential of someone |
| CPtOutreachPreferenceLevelRow | Describes the importance of the country and activity choices |
| CPtOutreachPreferenceLevelTable | Describes the importance of the country and activity choices |
| CPtPassportTypeRow | This table contains the codes that indicate the type of passport a person holds |
| CPtPassportTypeTable | This table contains the codes that indicate the type of passport a person holds |
| CPtQualificationAreaRow | This defines the areas in which a person may posess a qualification, e.g. computing or accountancy |
| CPtQualificationAreaTable | This defines the areas in which a person may posess a qualification, e.g. computing or accountancy |
| CPtQualificationLevelRow | This is the level to which a qualifications is possessed, e.g. Secondary education, Master's Degree |
| CPtQualificationLevelTable | This is the level to which a qualifications is possessed, e.g. Secondary education, Master's Degree |
| CPtSkillCategoryRow | This is the category that will be used for a person's skill |
| CPtSkillCategoryTable | This is the category that will be used for a person's skill |
| CPtSkillLevelRow | This is the level to which a skill is possessed |
| CPtSkillLevelTable | This is the level to which a skill is possessed |
| CPtSpecialApplicantRow | This table contains the codes that indicate special situations of applicants |
| CPtSpecialApplicantTable | This table contains the codes that indicate special situations of applicants |
| CPtTravelTypeRow | This table contains the codes that indicate the mode of travel being used |
| CPtTravelTypeTable | This table contains the codes that indicate the mode of travel being used |
| ►NUnits | |
| ►NData | |
| CPtAssignmentTypeRow | Describes whether a person is full-time, part-time, etc |
| CPtAssignmentTypeTable | Describes whether a person is full-time, part-time, etc |
| CPtPositionRow | This is a listing of the different position which exist within our organisation, e.g. Field Leader, Book Keeper, Computer support |
| CPtPositionTable | This is a listing of the different position which exist within our organisation, e.g. Field Leader, Book Keeper, Computer support |
| CUmJobLanguageRow | Language used on this job |
| CUmJobLanguageTable | Language used on this job |
| CUmJobQualificationRow | Details of qualifications required for individual jobs |
| CUmJobQualificationTable | Details of qualifications required for individual jobs |
| CUmJobRequirementRow | Lists abilities and experience required for various positions |
| CUmJobRequirementTable | Lists abilities and experience required for various positions |
| CUmJobRow | This table contains information concerning jobs within the unit |
| CUmJobTable | This table contains information concerning jobs within the unit |
| CUmUnitAbilityRow | Details of the abilities within the unit |
| CUmUnitAbilityTable | Details of the abilities within the unit |
| CUmUnitCostRow | Details pertaining to the costs of being on in the unit |
| CUmUnitCostTable | Details pertaining to the costs of being on in the unit |
| CUmUnitEvaluationRow | Details pertaining to evaluation of the unit |
| CUmUnitEvaluationTable | Details pertaining to evaluation of the unit |
| CUmUnitLanguageRow | Details of the language used within this unit |
| CUmUnitLanguageTable | Details of the language used within this unit |
| CCalculations | Contains functions to be used by the Server and the Client that perform certain calculations - specific for the Personnel Module. |
| CMPersonnelConstants | some constants used in the personnel module |
| CPersonnelChecks | Contains functions to be used by the Server and the Client that perform certain checks - specific for the Personnel Module. |
| CUnitHierarchyNode | This object supplies fields to / from a TreeNode, for the UnitHierarchy methods. |
| ►NMReporting | |
| CTColumnSetting | |
| CTColumnSettingCollection | |
| CTParameter | This class is able to hold one value, and knows to which column and level this variable applies. |
| CTParameterList | This class is a container class that holds an unlimited number of TParameter objects. It provides functions to add parameters of all possible types. It provides functions for retrieving the value of a given parameter, depending on column and level. The data can be stored to an xml file and loaded from an xml file |
| CTResultList | This will be removed soon. |
| ►NMSponsorship | |
| ►NData | |
| CSponsorshipFindTDS | Auto generated |
| CSponsorshipFindTDSSearchResultRow | |
| CSponsorshipFindTDSSearchResultTable | |
| CSponsorshipTDS | Auto generated |
| CSponsorshipTDSARecurringGiftDetailRow | Store recipient information for the recurring gift |
| CSponsorshipTDSARecurringGiftDetailTable | Store recipient information for the recurring gift |
| ►NMSysMan | |
| ►NData | |
| CMaintainUsersTDS | Auto generated |
| CSChangeEventRow | Records all database events (ie. insert, update, delete). Gets purged after each export |
| CSChangeEventTable | Records all database events (ie. insert, update, delete). Gets purged after each export |
| CSDefaultFileVolumeRow | Set Default Volume for a user group in a specific area |
| CSDefaultFileVolumeTable | Set Default Volume for a user group in a specific area |
| CSErrorLogRow | Log of captured runtime errors |
| CSErrorLogTable | Log of captured runtime errors |
| CSFormRow | List of forms for printers |
| CSFormTable | List of forms for printers |
| CSFunctionRelationshipRow | Represents a relationship between two particular functions. Eg. Partner Find and Partner Edit |
| CSFunctionRelationshipTable | Represents a relationship between two particular functions. Eg. Partner Find and Partner Edit |
| CSFunctionRow | Contains all Petra functions to which access can be granted or denied |
| CSFunctionTable | Contains all Petra functions to which access can be granted or denied |
| CSGroupCostCentreRow | Gives a group access to a specific cost centre (so that people without other finance access can access data on their own department) |
| CSGroupCostCentreTable | Gives a group access to a specific cost centre (so that people without other finance access can access data on their own department) |
| CSGroupDataLabelRow | Controls the access that a group has to a specific Data Label, if the Data Label is restricted |
| CSGroupDataLabelTable | Controls the access that a group has to a specific Data Label, if the Data Label is restricted |
| CSGroupExtractRow | Gives a group access to a specific extract |
| CSGroupExtractTable | Gives a group access to a specific extract |
| CSGroupFileInfoRow | Associates a Group with an external document (file info). This may be read, write, delete |
| CSGroupFileInfoTable | Associates a Group with an external document (file info). This may be read, write, delete |
| CSGroupFunctionRow | Gives the group access to a particular function |
| CSGroupFunctionTable | Gives the group access to a particular function |
| CSGroupGiftRow | Controls the access that a group has to a specific gift, if the gift is restricted |
| CSGroupGiftTable | Controls the access that a group has to a specific gift, if the gift is restricted |
| CSGroupLedgerRow | Gives a group access to a specific ledger |
| CSGroupLedgerTable | Gives a group access to a specific ledger |
| CSGroupLocationRow | Controls the access that a group has to a specific location, if the Location is restricted |
| CSGroupLocationTable | Controls the access that a group has to a specific location, if the Location is restricted |
| CSGroupModuleAccessPermissionRow | Security mappings from groups to Petra modules |
| CSGroupModuleAccessPermissionTable | Security mappings from groups to Petra modules |
| CSGroupMotivationRow | Controls the access that a group has to gifts with a specific motivation |
| CSGroupMotivationTable | Controls the access that a group has to gifts with a specific motivation |
| CSGroupPartnerContactRow | Controls the access that a group has to a specific Partner contact, if the contact is restricted |
| CSGroupPartnerContactTable | Controls the access that a group has to a specific Partner contact, if the contact is restricted |
| CSGroupPartnerLocationRow | Controls the access that a group has to a specific partner location, if the Partner Location is restricted |
| CSGroupPartnerLocationTable | Controls the access that a group has to a specific partner location, if the Partner Location is restricted |
| CSGroupPartnerReminderRow | Controls the access that a group has to a specific Partner reminder, if the reminder is restricted |
| CSGroupPartnerReminderTable | Controls the access that a group has to a specific Partner reminder, if the reminder is restricted |
| CSGroupPartnerSetRow | Associates a Group with a Partner Set. This may be an inclusive or exclusive association and may be read, write, delete |
| CSGroupPartnerSetTable | Associates a Group with a Partner Set. This may be an inclusive or exclusive association and may be read, write, delete |
| CSGroupRow | List of groups to which users can belong |
| CSGroupTable | List of groups to which users can belong |
| CSGroupTableAccessPermissionRow | Security mappings from groups to Petra database |
| CSGroupTableAccessPermissionTable | Security mappings from groups to Petra database |
| CSJobGroupRow | Associates groups with roles |
| CSJobGroupTable | Associates groups with roles |
| CSLabelRow | Attributes for label paper |
| CSLabelTable | Attributes for label paper |
| CSLanguageSpecificRow | Definitions of fields that are language specific |
| CSLanguageSpecificTable | Definitions of fields that are language specific |
| CSLoginRow | Log of all the log-ins/log-in attempts to the system, and of log-outs from the system (activities on user accounts themselves are recorded in s_user_account_activity) |
| CSLoginTable | Log of all the log-ins/log-in attempts to the system, and of log-outs from the system (activities on user accounts themselves are recorded in s_user_account_activity) |
| CSLogonMessageRow | List of logon messages by language |
| CSLogonMessageTable | List of logon messages by language |
| CSModuleRow | List of Petra software modules |
| CSModuleTable | List of Petra software modules |
| CSModuleTableAccessPermissionRow | Security mappings from modules to Petra database |
| CSModuleTableAccessPermissionTable | Security mappings from modules to Petra database |
| CSPatchLogRow | Logs each patch procedure that is run |
| CSPatchLogTable | Logs each patch procedure that is run |
| CSReportResultRow | Report Results |
| CSReportResultTable | Report Results |
| CSReportsToArchiveRow | Contains the titles of reports that should be archived, not deleted, when Purge Reports is run |
| CSReportsToArchiveTable | Contains the titles of reports that should be archived, not deleted, when Purge Reports is run |
| CSReportTemplateRow | Filesystem for storage of XML report templates - those provided initially and also tweaks saved by users |
| CSReportTemplateTable | Filesystem for storage of XML report templates - those provided initially and also tweaks saved by users |
| CSSessionRow | Sessions |
| CSSessionTable | Sessions |
| CSSystemDefaultsGuiRow | Describes the GUI controls for editing the default values |
| CSSystemDefaultsGuiTable | Describes the GUI controls for editing the default values |
| CSSystemDefaultsRow | The settings that are system wide (iso per user) |
| CSSystemDefaultsTable | The settings that are system wide (iso per user) |
| CSSystemStatusRow | Records current status of system (up, maintenance etc.) |
| CSSystemStatusTable | Records current status of system (up, maintenance etc.) |
| CSUserAccountActivityRow | Logs activity on user accounts themselves (user logins and logouts are recorded in s_login) |
| CSUserAccountActivityTable | Logs activity on user accounts themselves (user logins and logouts are recorded in s_login) |
| CSUserDefaultsRow | Stores various default values and options for each user |
| CSUserDefaultsTable | Stores various default values and options for each user |
| CSUserGroupRow | Security mappings of users to groups |
| CSUserGroupTable | Security mappings of users to groups |
| CSUserModuleAccessPermissionRow | Security mappings of users to Petra modules |
| CSUserModuleAccessPermissionTable | Security mappings of users to Petra modules |
| CSUserRow | List of users |
| CSUserTable | List of users |
| CSUserTableAccessPermissionRow | Security mappings of users to Petra database |
| CSUserTableAccessPermissionTable | Security mappings of users to Petra database |
| CSValidOutputFormRow | Lists printer forms that are valid for each Petra module |
| CSValidOutputFormTable | Lists printer forms that are valid for each Petra module |
| CSVolumePartnerGroupPartnerRow | Assign Partners to a Group for use in Default Volumes |
| CSVolumePartnerGroupPartnerTable | Assign Partners to a Group for use in Default Volumes |
| CSVolumePartnerGroupRow | Set up a Group for use in Default Volumes |
| CSVolumePartnerGroupTable | Set up a Group for use in Default Volumes |
| CSVolumeRow | Volume to either represent a file directory or a volume relative to a parent volume |
| CSVolumeTable | Volume to either represent a file directory or a volume relative to a parent volume |
| CSWorkflowDefinitionRow | Stores the definition of each workflow. These may be pre-created, or created by the user |
| CSWorkflowDefinitionTable | Stores the definition of each workflow. These may be pre-created, or created by the user |
| CSWorkflowGroupRow | Which groups have access to this workflow |
| CSWorkflowGroupTable | Which groups have access to this workflow |
| CSWorkflowInstanceRow | A running instance of a defined workflow |
| CSWorkflowInstanceStepRow | Each step of the running workflow, including the status of that step |
| CSWorkflowInstanceStepTable | Each step of the running workflow, including the status of that step |
| CSWorkflowInstanceTable | A running instance of a defined workflow |
| CSWorkflowStepRow | Stores each step of the workflow |
| CSWorkflowStepTable | Stores each step of the workflow |
| CSWorkflowUserRow | Which users have access to this workflow |
| CSWorkflowUserTable | Which users have access to this workflow |
| CMSysManConstants | some constants used in the system manager module |
| ►NSecurity | |
| CELoginMessageAlreadySetException | Thrown by TPetraPrincipal class if the LoginMessage property is written to althought it has already got a value |
| CEProcessIDAlreadySetException | Thrown by TPetraPrincipal class if the ProcessID property is written to althought it has already got a value |
| CTPetraPrincipal | |
| CTSecureData | Implements data security |
| CTSecurityChecks | Implements security checks. |
| ►NTesting | |
| CTTestShared | This is a testing program for Ict.Petra.Shared.dll |
| CConversions | Functions for various Petra-related conversions |
| CECacheableTablesMgrException | This Exception is thrown on several occasions by TCacheableTablesManager. |
| CECacheableTablesMgrTableNotUpToDateException | This Exception is thrown by GetCachedDataTable if the Cacheable DataTable isn't in an up-to-date state. This means it needs to be retrieved anew before it can be used. |
| CMessages | Contains functions for processing of error messages, etc |
| CPetraErrorCodes | |
| CSharedConstants | constants that are used all over the place |
| CSharedTypes | provides useful functions for shared types |
| CTCacheableTablesLoader | The TCacheableTablesLoader class is designed to get base.by a Class that will be a Cache Manager (who is responsible for the actual loading and saving of the DataTables). It contains only a helper function that is used by every Cache Manager |
| CTCacheableTablesManager | |
| ►CTSharedDataCache | Contains functions for the shared access to cacheable data |
| CTMCommon | todoComment |
| CTMConference | todoComment |
| CTMFinance | todoComment |
| CTMPartner | todoComment |
| CTMPersonnel | todoComment |
| CTMSysMan | todoComment |
| CTTableList | this returns a list of all database tables, ordered by the most referenced tables, which need to be created first and can be deleted last |
| CUserInfo | Holds User Information (particularly security-related) in a global variable and allows refreshing of this information. |
| ►NTools | |
| ►NMFinance | |
| ►NServer | |
| ►NGDPdUExport | |
| CTGDPdUExport | This will export the finance data for the tax office, according to GDPdU |
| CTGDPdUExportAccountsAndCostCentres | This will export the accounts and costcentres involved |
| CTGDPdUExportAccountsPayable | This will export the finance data for the tax office, according to GDPdU |
| CTGDPdUExportBalances | This will export the finance data for the tax office, according to GDPdU |
| CTGDPdUExportParticipants | This will export the finance data for the tax office, according to GDPdU |
| CTGDPdUExportTransactions | This will export the finance data for the tax office, according to GDPdU |
| ►NGDPdUExportIncomeTax | |
| CTGDPdUExport | This will export the finance data for the tax office, according to GDPdU |
| CTGDPdUExportAccountsAndCostCentres | This will export the accounts and costcentres involved |
| CTGDPdUExportBalances | This will export the finance data for the tax office, according to GDPdU |
| CTGDPdUExportTransactions | This will export the finance data for the tax office, according to GDPdU |
| CTGDPdUExportWorkers | This will export the finance data for the tax office, according to GDPdU |
| ►NMSysMan | |
| ►NYmlGzImportExport | |
| CTYmlGzImportExport | This will import and export the database via YmlGz file |
| ►NSampleDataConstructor | |
| CSampleDataAccountsPayable | tools for generating and posting and paying invoices |
| CSampleDataBankPartners | tools for generating bank partners |
| CSampleDataDonors | tools for generating partners with FAMILY records |
| CSampleDataGiftBatches | tools for generating and posting gift batches with sample data |
| CSampleDataLedger | tools for populating a ledger with data |
| CSampleDataOrganisations | tools for generating organisation partner records |
| CSampleDataUnitPartners | tools for generating unit partners (fields and key ministries) |
| CSampleDataWorkers | tools for generating people with FAMILY and PERSON partner records, and commitment data |
| CTSampleDataConstructor | This class creates sample data (partners, organisations, gifts) and imports them into OpenPetra. |
| ►NTesting | |
| ►NI18N | |
| CProgram | see http://www.gnu.org/software/gettext/manual/gettext.html#C_0023 c:\programme\poedit\bin\xgettext.exe –strict –no-location –from-code=UTF-8 u:\csharp\ICT\Testing\Common\I18N\Program.cs -o u:\csharp\ICT\Testing\Testing\Common\I18N\de.po use -j for second time –no-location, because if code changes, the lines will change, and -j will add a new position line in Notepad++: change format to UTF-8 without BOM in mono shell, or with mono bin path in PATH: PATH=PATH%;c:\Programme\Mono-2.4.3\bin;c:\Programme\Poedit\bin msgfmt csharp\Ict\Testing\Common\I18N\de.po -d csharp\ICT\Testing_bin\Debug –locale=de-DE –resource=OpenPetra –csharp to merge a custom language file (eg. organisation specific), use msgcat: msgcat csharp\Ict\Testing\Common\I18N\de-custom.po csharp\Ict\Testing\Common\I18N\de.po –use-first -o csharp\Ict\Testing\Common\I18N\de-test.po |
| ►NI18N_GNU | |
| ►NGettext | |
| CExample | |
| ►NNUnitPetraServer | |
| CTPetraServerConnector | |
| ►NNUnitTools | |
| CCommonNUnitFunctions | a set of small helpfull routines to make testing something easier. |
| CDateConverter | This converter finds the different date substrings in a string like a message. Actually the common date format looks like "dd-MMM-yyyy" and so we are dealing with strings like "This Date is valid from 17-JAN-2009 to 21-FEB-2010". |
| CTNUnitEventAsserter | To be used in connection with Class TNUnitEventHandlerCheck<T> for easy asserting of Events. |
| CTNUnitEventHandlerCheck | To be used with NUnit to faciltate checking of Events - if they are getting raised and if they aren't getting raised. |
| ►NPetra | |
| ►NServer | |
| ►NMFinance | |
| ►NAP | |
| CTestAP | a couple of tests for AP |
| ►NBankImport | |
| CTBankImportGiftMatching | This will test the business logic directly on the server |
| ►NBudget | |
| CTestBudget | a couple of tests for Budget |
| ►NGL | |
| CChangeSuspenseAccount | |
| CTestCommonAccountingTool | TestCommonAccountingTool |
| CTestGLCommonTools | TestGLCommonTools |
| CTestGLImport | TestGLImport |
| CTestGLPeriodicEnd | Test of the GL.PeriodEnd.Year routines ... |
| CTestGLPeriodicEndMonth | Test of the GL.PeriodEnd.Month routines ... |
| CTestGLPeriodicEndYear | Test of the GL.PeriodEnd.Year routines ... |
| CTestGLRevaluation | TestGLRevaluation - math part |
| CTestOperation | |
| CTestOperations | |
| ►NTools | |
| ►NCheckHtml | |
| CProgram | |
| ►NCodeChecker | |
| CProgram | |
| ►NCodeGeneration | |
| ►NCachedTables | |
| CTGenerateCachedTables | creates a file with enums in Shared and one file per submodule in Server for cached tables |
| ►NDataStore | |
| CCodeGenerationAccess | |
| CCodeGenerationCascading | |
| CCodeGenerationDataset | generate code for typed datasets |
| CCodeGenerationDatasetAccess | create code for reading and writing datasets from and to the database |
| CCodeGenerationTable | the code generator for typed tables |
| CCodeGenerationTableValidation | the code generator for validation for typed tables |
| CTGenerateTableList | produces an ordered list of tables, ordered by foreign key dependancies |
| CAutoGenerationTools | Some useful functions for auto generating code |
| CCSParser | A wrapper for NRefactory from SharpDevelop |
| CTDataValidation | functions for data validation |
| CTInsertIntoRegion | insert auto generated code into a region |
| ►NDataMigrateStatistics | |
| CProgram | |
| ►NDBXML | |
| CConstraintComparer | for comparing constraints for sorting and to test if they are the same |
| CTConstraint | constraints can be foreign keys or primary keys |
| CTDataDefinitionParser | This is a special XML parser for the datadefinition file for Petra |
| CTDataDefinitionStore | This holds the tables and the sequences of the database structure; this is an objectorientated representation in memory of the database structure that was originally defined in XML |
| CTDataSetTable | |
| CTIndex | data of an index |
| CTIndexField | data of an index |
| CTSequence | all necessary data of a sequence |
| CTTable | all information about the structure of a database table |
| CTTableField | this describes a column of a table |
| CTTableSort | sort the tables by dependency of the constraints, using topological sort. in the end, we get a list of tables, in the order that you need when you populate the database with constraints enabled. first the tables that depend on nothing, and then the tables that depend on them. deleting the database can be done the other way round |
| ►NDeleteButtonWiki | |
| CProgram | This application reads YAML, manual and auto-generated files in the entire OpenPetra suite It examines the content of these files looking for 'issues' In this case the issues are to do with the implementation of the Delete Button functionality The output from the application is a text file in the 'log' folder This text is formatted so that it can be inserted directly onto a wiki page to give a tabular page content. |
| ►NDevelopersAssistantUpdater | |
| CProgram | |
| ►NFilterButtonWiki | |
| CProgram | |
| ►NGenerateGlue | |
| CProgram | |
| ►NGenerateI18N | |
| CProgram | |
| ►NGenerateORM | |
| CgenerateTypedTables | This program generates the tables and datasets for the typed datasets |
| ►NGenerateSQL | |
| CProgram | |
| ►NGuidedTranslation | |
| CProgram | |
| ►NTinyWebServer | |
| CThreadedHttpListenerWrapper | this class is a wrapper for HttpListener. it is able to deal with multiple requests, starting a thread for each request |
| CTMyHttpWorkerRequest | extend HttpWorkerRequest so that we can handle asmx requests |
| CTTinyASMXServer | this is a simple ASMX Server, for use if XSP from mono is not available |
| ▼NNamespaceHierarchy | |
| CTNamespace | to be parsed from the cs files |
| ▼NPetraServerAdminConsole | |
| CPetraServerAdminConsole | |
| CTAdminConsole | Petra Server Admin Command Line Application |
| ▼NTests | |
| ►NCommon | |
| ►NIO | |
| CTTestEmailAddressListConverter | Tests conversion of email address lists from semicolon-separated to comma-separated. |
| ►NMFinance | |
| ►NServer | |
| ►NCrossLedger | |
| CTAvailableLedgersTest | The main test class for Available Ledgers |
| ►NGift | |
| CSetMotivationGroupAndDetailTest | The Webconnector class TSetMotivationGroupAndDetail is tested |
| CTGiftAnnualReceiptTest | This will test the generation of the annual gift receipts on the server |
| CTGiftBatchTest | This will test the business logic directly on the server |
| CTGiftSingleGiftReceiptTest | This will test the generation of a gift receipt for a single gift on the server |
| CTGiftTest | This will test the business logic directly on the server |
| CTRecurringGiftBatchTest | This will test the business logic directly on the server |
| CTRevertAdjustGiftBatchTest | This will test the business logic directly on the server |
| ►NGL | |
| CTGLBatchTest | This will test the business logic directly on the server |
| ►NICH | |
| CTICHHOSAFileReportsTest | This will test the business logic directly on the server |
| CTStewardshipCalculationTest | This will test the business logic directly on the server |
| ►NReporting | |
| CTAccountDetailTest | This will test the business logic directly on the server |
| CTBalanceSheetTest | This will test the business logic directly on the server |
| CTIncExpStatementTest | This will test the business logic directly on the server |
| CTTrialBalanceTest | This will test the business logic directly on the server |
| ►NMPartner | |
| ►NServer | |
| ►NAddressTools | |
| CTAddressToolsTest | This will test the business logic directly on the server |
| ►NPartnerEdit | |
| CTPartnerEditBankingDetailsTest | This will test the business logic directly on the server |
| CTPartnerEditTest | This will test the business logic directly on the server |
| ►NPartnerExports | |
| CTPartnerImportCSVTest | This will test the business logic directly on the server |
| ►NPartnerMerge | |
| CTPartnerMergeTest | This will test the business logic directly on the server |
| ►NReporting | |
| CTPartnerReportsTest | This will test the business logic directly on the server |
| ►Nshared | |
| ►NCreateTestPartnerData | |
| CTCreateTestPartnerData | This will create data to be used in Partner tests |
| ►NMReporting | |
| ►NTools | |
| CTReportTestingTools | Tools for testing the finance reports |
| ►NMSponsorship | |
| ►NServer | |
| ►NMSponsorship | |
| CTSponsorshipTesting | |
| ►NReporting | |
| CTConfigTest | |
| CTParameterListTest | This is a test for the parameter list which is used for reporting. |
1.9.4