This WebConnector provides data for the Accounts Payable reporting screens /summary>
More...
|
static DataSet | APAgedSupplierList (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataTable | APCurrentPayable (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataSet | APPaymentReport (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataSet | APAccountDetail (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataTable | SYBUNTTable (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataSet | DonorReportShort (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataSet | DonorReportDetail (Dictionary< string, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataSet | GiftsOverMinimum (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataSet | TopDonorReport (Dictionary< string, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataSet | NewDonorReport (Dictionary< string, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataTable | GiftBatchDetailTable (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataTable | GiftStatementRecipientTable (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter, string DonorKeyList="") |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static Boolean | GetGiftStatementTotals (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter, Int64 APartnerKey, out Decimal AThisYearTotal, out Decimal APreviousYearTotal, Boolean AForDonor=false) |
| Retrieves values for use in client-side reporting More...
|
|
static DataTable | GiftStatementDonorTable (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter, String ADonorKeyList, Int64 ARecipientKey=-1, String ACommentFor="RECIPIENT") |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataTable | GiftStatementDonorAddressesTable (TReportingDbAdapter DbAdapter, Int64 ADonorKey) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataTable | RecipientTaxDeductPctTable (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataTable | OneYearMonthGivingDonorTable (Dictionary< String, TVariant >AParameters, Int64 ARecipientKey, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataTable | MotivationResponse (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting Derived from the existing method in MFinanceQueries\ReportFinance.cs More...
|
|
static void | GetLedgerPeriodDetails (int ALedgerNumber, out int ANumberAccountingPeriods, out int ANumberForwardingPeriods, out int ACurrentPeriod, out int ACurrentYear) |
| get the details of the given ledger More...
|
|
static DataTable | GetAvailableFinancialYears (int ALedgerNumber, System.Int32 ADiffPeriod, out String ADisplayMember, out String AValueMember) |
| Loads all available financial years into a table To be used by a combobox to select the financial year More...
|
|
static DataTable | GetReceivingFields (int ALedgerNumber, out String ADisplayMember, out String AValueMember, Boolean ASeparateDBConnection=false) |
| Load all the receiving fields More...
|
|
static string | GetReportingCostCentres (int ALedgerNumber, String ASummaryCostCentreCode, string ARemoveCostCentresFromList) |
| Get all cost centres that report into the given summary cost centre More...
|
|
static string | GetReportingAccounts (int ALedgerNumber, string ASummaryAccountCodes, string ARemoveAccountsFromList) |
| Get all accounts that report into the given summary account More...
|
|
static string | GetLedgerName (int ALedgerNumber) |
| Get the name for this Ledger, using a new DB connection More...
|
|
static DataTable | GetPeriodBalances (String ALedgerFilter, String AAccountCodeFilter, String ACostCentreFilter, Int32 AFinancialYear, String ASortBy, DataTable ATransactionsTbl, Int32 AStartPeriod, Int32 AEndPeriod, String ASelectedCurrency) |
| Collects the period opening / closing balances for the Account Detail report More...
|
|
static DataTable | BalanceSheetTable (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable for use in client-side reporting This version begins with GLM and GLMP tables, but calculates amounts for the summary accounts, adding individual posting Cost Centres, so it does not rely on the summarisation in GLMP. More...
|
|
static DataTable | IncomeExpenseTable (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataSet to the client for use in client-side reporting This version begins with GLM and GLMP tables, but calculates amounts for the summary accounts, so it does not rely on summarisation in GLMP. More...
|
|
static DataTable | HosaGiftsTable (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataSet to the client for use in client-side reporting More...
|
|
static DataTable | KeyMinGiftsTable (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataSet to the client for use in client-side reporting More...
|
|
static DataTable | StewardshipTable (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataSet to the client for use in client-side reporting More...
|
|
static DataTable | FeesTable (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataTable | StewardshipForPeriodTable (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataTable | AFOTable (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataTable | ExecutiveSummaryTable (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataTable | FieldLeaderGiftSummary (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataTable | TotalGiftsThroughField (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting Derived from the existing method in MFinanceQueries\ReportFinance.cs More...
|
|
static DataTable | DonorGiftsToField (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataTable | GiftDestination (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataTable | TotalForRecipients (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataTable to the client for use in client-side reporting More...
|
|
static DataTable | TrialBalanceTable (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataSet to the client for use in client-side reporting More...
|
|
static DataTable | SurplusDeficitTable (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter) |
| Returns a DataSet to the client for use in client-side reporting More...
|
|
static string | GetTransactionCurrency (int ALedgerNumber, int ABatchNumber) |
| Returns the transaction currency for a Gift Batch More...
|
|
This WebConnector provides data for the Accounts Payable reporting screens /summary>
This WebConnector provides data for the finance reporting screens /summary>
This WebConnector provides data for the Gift reporting screens /summary>
This WebConnector provides data for the Financial Development reporting screens /summary>