Basic information for each general ledger on the system. Also counters for ledger-specific variables (such as last receipt number). More...

Inheritance diagram for Ict.Petra.Shared.MFinance.CrossLedger.Data.ExchangeRateTDSALedgerInfoTable:

Public Member Functions
	ExchangeRateTDSALedgerInfoTable ()
	constructor More...

	ExchangeRateTDSALedgerInfoTable (string ATablename)
	constructor More...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Public Attributes
DataColumn	ColumnCurrentPeriodStartDate
	The start date for the current period in this ledger. More...

DataColumn	ColumnCurrentPeriodEndDate
	The end date for the current period in this ledger. More...

DataColumn	ColumnForwardPeriodEndDate
	The end date for the last forward period in this ledger. More...

DataColumn	ColumnLedgerNumber
	This is used as a key field in most of the accounting system files .It is created from the first 4 digits of a partner key of type ""ledger"". More...

DataColumn	ColumnLedgerName
	This is the ledger name. More...

DataColumn	ColumnLedgerStatus
	Defines if the ledger is in use. More...

DataColumn	ColumnLastBatchNumber
	This is the last batch number used within a ledger. More...

DataColumn	ColumnLastRecurringBatchNumber

DataColumn	ColumnLastGiftNumber

DataColumn	ColumnLastApInvNumber

DataColumn	ColumnLastHeaderRNumber

DataColumn	ColumnLastPoNumber

DataColumn	ColumnLastSoNumber

DataColumn	ColumnMaxGiftAidAmount
	This is a number of currency units. More...

DataColumn	ColumnMinGiftAidAmount
	This is a number of currency units. More...

DataColumn	ColumnNumberOfGiftsToDisplay

DataColumn	ColumnTaxTypeCode

DataColumn	ColumnIltGlAccountCode
	The account for inter-ledger transfers. More...

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

DataColumn	ColumnNumberOfAccountingPeriods
	This defines which accounting period is being used. More...

DataColumn	ColumnCountryCode
	This identifies a country. It uses the ISO 3166-1-alpha-2 code elements. More...

DataColumn	ColumnBaseCurrency
	This defines which currency is being used. More...

DataColumn	ColumnTransactionAccountFlag
	Used to get a yes no response from the user. More...

DataColumn	ColumnYearEndFlag
	Used to get a yes no response from the user. More...

DataColumn	ColumnForexGainsLossesAccount
	The account for foreign exchange gains or losses. More...

DataColumn	ColumnSystemInterfaceFlag
	Used to get a yes no response from the user. More...

DataColumn	ColumnSuspenseAccountFlag
	Used to get a yes no response from the user. More...

DataColumn	ColumnBankAccountsFlag
	Used to get a yes no response from the user. More...

DataColumn	ColumnDeleteLedgerFlag
	Used to get a yes no response from the user. More...

DataColumn	ColumnNewFinancialYearFlag
	Used to get a yes no response from the user. More...

DataColumn	ColumnRecalculateGlMasterFlag
	Used to get a yes no response from the user. More...

DataColumn	ColumnInstallationId
	Defines which installation is running on this database. More...

DataColumn	ColumnBudgetControlFlag

DataColumn	ColumnBudgetDataRetention

DataColumn	ColumnCostOfSalesGlAccount

DataColumn	ColumnCreditorGlAccountCode

DataColumn	ColumnCurrentFinancialYear

DataColumn	ColumnCurrentPeriod

DataColumn	ColumnDateCrDrBalances

DataColumn	ColumnDebtorGlAccountCode

DataColumn	ColumnFaDepreciationGlAccount

DataColumn	ColumnFaGlAccountCode

DataColumn	ColumnFaPlOnSaleGlAccount

DataColumn	ColumnFaProvForDepnGlAccount

DataColumn	ColumnIltAccountFlag

DataColumn	ColumnLastApDnNumber

DataColumn	ColumnLastPoRetNumber

DataColumn	ColumnLastSoDelNumber

DataColumn	ColumnLastSoRetNumber

DataColumn	ColumnLastSpecialGiftNumber

DataColumn	ColumnNumberFwdPostingPeriods

DataColumn	ColumnDiscountAllowedPct

DataColumn	ColumnDiscountReceivedPct

DataColumn	ColumnPoAccrualGlAccountCode

DataColumn	ColumnProvisionalYearEndFlag
	This flag is set between the completion of the last month of the year and the year itself. In this state some activities are disabled and some others are enabled. More...

DataColumn	ColumnPurchaseGlAccountCode

DataColumn	ColumnRetEarningsGlAccount

DataColumn	ColumnSalesGlAccountCode

DataColumn	ColumnSoAccrualGlAccountCode

DataColumn	ColumnStockAccrualGlAccount

DataColumn	ColumnStockAdjGlAccountCode

DataColumn	ColumnStockGlAccountCode

DataColumn	ColumnTaxExclIncl

DataColumn	ColumnTaxExclInclIndicator

DataColumn	ColumnTaxInputGlAccountCode

DataColumn	ColumnTaxInputGlCcCode

DataColumn	ColumnTaxOutputGlAccountCode

DataColumn	ColumnTermsOfPaymentCode

DataColumn	ColumnLastPoRecNumber

DataColumn	ColumnTaxGlAccountNumber

DataColumn	ColumnActualsDataRetention

DataColumn	ColumnPartnerKey
	Partner key which links the ledger to the partner type record where the type is a ledger. More...

DataColumn	ColumnCalendarMode

DataColumn	ColumnYearEndProcessStatus
	How far along is the year end process. More...

DataColumn	ColumnLastHeaderPNumber
	last used cashbook payment header number More...

DataColumn	ColumnIltProcessingCentre
	Is this ledger an ILT processing centre (ie, clearinghouse status) More...

DataColumn	ColumnLastGiftBatchNumber
	The number of the last gift batch to be created. More...

DataColumn	ColumnIntlCurrency
	This defines which currency to use as a second ('international') base currency. More...

DataColumn	ColumnLastRecGiftBatchNumber
	The number of the last gift batch to be created. More...

DataColumn	ColumnGiftDataRetention
	How many years to retain gift data. More...

DataColumn	ColumnRecalculateAllPeriods
	When recalculating the account report structure this indicates that all periods should be recalculated. More...

DataColumn	ColumnLastIchNumber
	identifes the Last used ICH process number More...

DataColumn	ColumnConsolidationLedger
	Indicates whether the ledger is just for storing consolidated accounts (rather than a 'real' ledger). More...

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

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

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

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

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

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

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

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

static readonly short	ColumnCurrentPeriodStartDateId = 85
	used for generic TTypedDataTable functions More...

static readonly short	ColumnCurrentPeriodEndDateId = 86
	used for generic TTypedDataTable functions More...

static readonly short	ColumnForwardPeriodEndDateId = 87
	used for generic TTypedDataTable functions More...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

static readonly short	ColumnStockAccrualGlAccountId = 56
	used for generic TTypedDataTable functions More...

static readonly short	ColumnStockAdjGlAccountCodeId = 57
	used for generic TTypedDataTable functions More...

static readonly short	ColumnStockGlAccountCodeId = 58
	used for generic TTypedDataTable functions More...

static readonly short	ColumnTaxExclInclId = 59
	used for generic TTypedDataTable functions More...

static readonly short	ColumnTaxExclInclIndicatorId = 60
	used for generic TTypedDataTable functions More...

static readonly short	ColumnTaxInputGlAccountCodeId = 61
	used for generic TTypedDataTable functions More...

static readonly short	ColumnTaxInputGlCcCodeId = 62
	used for generic TTypedDataTable functions More...

static readonly short	ColumnTaxOutputGlAccountCodeId = 63
	used for generic TTypedDataTable functions More...

static readonly short	ColumnTermsOfPaymentCodeId = 64
	used for generic TTypedDataTable functions More...

static readonly short	ColumnLastPoRecNumberId = 65
	used for generic TTypedDataTable functions More...

static readonly short	ColumnTaxGlAccountNumberId = 66
	used for generic TTypedDataTable functions More...

static readonly short	ColumnActualsDataRetentionId = 67
	used for generic TTypedDataTable functions More...

static readonly short	ColumnPartnerKeyId = 68
	used for generic TTypedDataTable functions More...

static readonly short	ColumnCalendarModeId = 69
	used for generic TTypedDataTable functions More...

static readonly short	ColumnYearEndProcessStatusId = 70
	used for generic TTypedDataTable functions More...

static readonly short	ColumnLastHeaderPNumberId = 71
	used for generic TTypedDataTable functions More...

static readonly short	ColumnIltProcessingCentreId = 72
	used for generic TTypedDataTable functions More...

static readonly short	ColumnLastGiftBatchNumberId = 73
	used for generic TTypedDataTable functions More...

static readonly short	ColumnIntlCurrencyId = 74
	used for generic TTypedDataTable functions More...

static readonly short	ColumnLastRecGiftBatchNumberId = 75
	used for generic TTypedDataTable functions More...

static readonly short	ColumnGiftDataRetentionId = 76
	used for generic TTypedDataTable functions More...

static readonly short	ColumnRecalculateAllPeriodsId = 77
	used for generic TTypedDataTable functions More...

static readonly short	ColumnLastIchNumberId = 78
	used for generic TTypedDataTable functions More...

static readonly short	ColumnConsolidationLedgerId = 79
	used for generic TTypedDataTable functions More...

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

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

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

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

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

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

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

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

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

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

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

Detailed Description

Basic information for each general ledger on the system. Also counters for ledger-specific variables (such as last receipt number).

Constructor & Destructor Documentation

◆ ExchangeRateTDSALedgerInfoTable() [1/3]

Ict.Petra.Shared.MFinance.CrossLedger.Data.ExchangeRateTDSALedgerInfoTable.ExchangeRateTDSALedgerInfoTable ( )

inline

constructor

◆ ExchangeRateTDSALedgerInfoTable() [2/3]

Ict.Petra.Shared.MFinance.CrossLedger.Data.ExchangeRateTDSALedgerInfoTable.ExchangeRateTDSALedgerInfoTable ( string ATablename )

inline

constructor

◆ ExchangeRateTDSALedgerInfoTable() [3/3]

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

inline

constructor for serialization

Member Function Documentation

◆ CreateOdbcParameter() [1/3]

override OdbcParameter Ict.Petra.Shared.MFinance.CrossLedger.Data.ExchangeRateTDSALedgerInfoTable.CreateOdbcParameter ( Int32 AColumnNr )

inlinevirtual

get an odbc parameter for the given column

Reimplemented from Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.

◆ CreateOdbcParameter() [2/3]

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

inlinestaticinherited

create an odbc parameter for the given column

◆ CreateOdbcParameter() [3/3]

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

inlinestaticinherited

get character length for column

◆ GetChanges()

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

inlineinherited

make sure that we use GetChangesType instead of GetChanges

Returns: throws an exception

◆ GetChangesTyped()

new ExchangeRateTDSALedgerInfoTable Ict.Petra.Shared.MFinance.CrossLedger.Data.ExchangeRateTDSALedgerInfoTable.GetChangesTyped ( )

inline

get typed set of changes

◆ GetChangesTypedInternal()

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

inlineinherited

our own version of GetChanges

Returns: returns a typed table with the changes

◆ GetColumnNameSQL()

static string Ict.Common.Data.TTypedDataTable.GetColumnNameSQL	(	short	ATableNumber,
		short	AColumnNr
	)

inlineprotectedvirtual

create the columns

Reimplemented from Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.

◆ InitVars()

override void Ict.Petra.Shared.MFinance.CrossLedger.Data.ExchangeRateTDSALedgerInfoTable.InitVars ( )

inlinevirtual

assign columns to properties, set primary key

Reimplemented from Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.

◆ IsAvailableForCustomReport()

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

inlinevirtualinherited

Is this table generally available in custom reports?

◆ NewRowFromBuilder()

override System.Data.DataRow Ict.Petra.Shared.MFinance.CrossLedger.Data.ExchangeRateTDSALedgerInfoTable.NewRowFromBuilder ( System.Data.DataRowBuilder builder )

inlineprotected

new typed row using DataRowBuilder

◆ NewRowTyped() [1/2]

new ExchangeRateTDSALedgerInfoRow Ict.Petra.Shared.MFinance.CrossLedger.Data.ExchangeRateTDSALedgerInfoTable.NewRowTyped ( )

inline

create a new typed row, always with default values

◆ NewRowTyped() [2/2]

new ExchangeRateTDSALedgerInfoRow Ict.Petra.Shared.MFinance.CrossLedger.Data.ExchangeRateTDSALedgerInfoTable.NewRowTyped ( bool AWithDefaultValues )

inline

create a new typed row

◆ RemoveColumnsNotInTableTemplate()

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

inlineinherited

remove columns that are not needed

Parameters

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnConsolidationLedger

inherited

Indicates whether the ledger is just for storing consolidated accounts (rather than a 'real' ledger).

◆ ColumnConsolidationLedgerId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnConsolidationLedgerId = 79

staticinherited

used for generic TTypedDataTable functions

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnCurrentPeriod

inherited

◆ ColumnCurrentPeriodEndDate

DataColumn Ict.Petra.Shared.MFinance.CrossLedger.Data.ExchangeRateTDSALedgerInfoTable.ColumnCurrentPeriodEndDate

The end date for the current period in this ledger.

◆ ColumnCurrentPeriodEndDateId

readonly short Ict.Petra.Shared.MFinance.CrossLedger.Data.ExchangeRateTDSALedgerInfoTable.ColumnCurrentPeriodEndDateId = 86

static

used for generic TTypedDataTable functions

◆ ColumnCurrentPeriodId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnCurrentPeriodId = 34

staticinherited

used for generic TTypedDataTable functions

◆ ColumnCurrentPeriodStartDate

DataColumn Ict.Petra.Shared.MFinance.CrossLedger.Data.ExchangeRateTDSALedgerInfoTable.ColumnCurrentPeriodStartDate

The start date for the current period in this ledger.

◆ ColumnCurrentPeriodStartDateId

readonly short Ict.Petra.Shared.MFinance.CrossLedger.Data.ExchangeRateTDSALedgerInfoTable.ColumnCurrentPeriodStartDateId = 85

static

used for generic TTypedDataTable functions

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnDebtorGlAccountCode

inherited

◆ ColumnDebtorGlAccountCodeId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnDebtorGlAccountCodeId = 36

staticinherited

used for generic TTypedDataTable functions

◆ ColumnDeleteLedgerFlag

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnDeleteLedgerFlag

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnForexGainsLossesAccount

inherited

The account for foreign exchange gains or losses.

◆ ColumnForexGainsLossesAccountId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnForexGainsLossesAccountId = 21

staticinherited

used for generic TTypedDataTable functions

◆ ColumnForwardPeriodEndDate

DataColumn Ict.Petra.Shared.MFinance.CrossLedger.Data.ExchangeRateTDSALedgerInfoTable.ColumnForwardPeriodEndDate

The end date for the last forward period in this ledger.

◆ ColumnForwardPeriodEndDateId

readonly short Ict.Petra.Shared.MFinance.CrossLedger.Data.ExchangeRateTDSALedgerInfoTable.ColumnForwardPeriodEndDateId = 87

static

used for generic TTypedDataTable functions

◆ ColumnGiftDataRetention

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnGiftDataRetention

inherited

How many years to retain gift data.

◆ ColumnGiftDataRetentionId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnGiftDataRetentionId = 76

staticinherited

used for generic TTypedDataTable functions

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastApDnNumber

inherited

◆ ColumnLastApDnNumberId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastApDnNumberId = 42

staticinherited

used for generic TTypedDataTable functions

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastGiftNumber

inherited

◆ ColumnLastGiftNumberId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastGiftNumberId = 5

staticinherited

used for generic TTypedDataTable functions

◆ ColumnLastHeaderPNumber

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastHeaderPNumber

inherited

last used cashbook payment header number

◆ ColumnLastHeaderPNumberId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastHeaderPNumberId = 71

staticinherited

used for generic TTypedDataTable functions

◆ ColumnLastHeaderRNumber

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastHeaderRNumber

inherited

◆ ColumnLastHeaderRNumberId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastHeaderRNumberId = 7

staticinherited

used for generic TTypedDataTable functions

◆ ColumnLastIchNumber

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastIchNumber

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastRecGiftBatchNumber

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnNumberFwdPostingPeriods

inherited

◆ ColumnNumberFwdPostingPeriodsId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnNumberFwdPostingPeriodsId = 47

staticinherited

used for generic TTypedDataTable functions

◆ ColumnNumberOfAccountingPeriods

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnNumberOfAccountingPeriods

inherited

This defines which accounting period is being used.

◆ ColumnNumberOfAccountingPeriodsId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnNumberOfAccountingPeriodsId = 16

staticinherited

used for generic TTypedDataTable functions

◆ ColumnNumberOfGiftsToDisplay

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnNumberOfGiftsToDisplay

inherited

◆ ColumnNumberOfGiftsToDisplayId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnNumberOfGiftsToDisplayId = 12

staticinherited

used for generic TTypedDataTable functions

◆ ColumnPartnerKey

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnPartnerKey

inherited

Partner key which links the ledger to the partner type record where the type is a ledger.

◆ ColumnPartnerKeyId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnPartnerKeyId = 68

staticinherited

used for generic TTypedDataTable functions

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnPurchaseGlAccountCode

inherited

◆ ColumnPurchaseGlAccountCodeId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnPurchaseGlAccountCodeId = 52

staticinherited

used for generic TTypedDataTable functions

◆ ColumnRecalculateAllPeriods

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnRecalculateAllPeriods

inherited

When recalculating the account report structure this indicates that all periods should be recalculated.

◆ ColumnRecalculateAllPeriodsId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnRecalculateAllPeriodsId = 77

staticinherited

used for generic TTypedDataTable functions

◆ ColumnRecalculateGlMasterFlag

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnRecalculateGlMasterFlag

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnSuspenseAccountFlag

inherited

Used to get a yes no response from the user.

◆ ColumnSuspenseAccountFlagId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnSuspenseAccountFlagId = 23

staticinherited

used for generic TTypedDataTable functions

◆ ColumnSystemInterfaceFlag

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnSystemInterfaceFlag

◆ Count

int Ict.Common.Data.TTypedDataTable.Count

getinherited

the number of rows in the current table

◆ TableDBLabel

override string Ict.Petra.Shared.MFinance.CrossLedger.Data.ExchangeRateTDSALedgerInfoTable.TableDBLabel

get

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

◆ this[int i]

new ExchangeRateTDSALedgerInfoRow Ict.Petra.Shared.MFinance.CrossLedger.Data.ExchangeRateTDSALedgerInfoTable.this[int i]

get

Access a typed row by index.

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

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

Public Member Functions

Static Public Member Functions

Public Attributes

Static Public Attributes

Protected Member Functions

Static Protected Attributes

Properties

Detailed Description

Constructor & Destructor Documentation

◆ ExchangeRateTDSALedgerInfoTable() [1/3]

◆ ExchangeRateTDSALedgerInfoTable() [2/3]

◆ ExchangeRateTDSALedgerInfoTable() [3/3]

Member Function Documentation

◆ CreateOdbcParameter() [1/3]

◆ CreateOdbcParameter() [2/3]

◆ CreateOdbcParameter() [3/3]

◆ GetActualsDataRetentionDBName()

◆ GetActualsDataRetentionHelp()

◆ GetActualsDataRetentionLength()

◆ GetBankAccountsFlagDBName()

◆ GetBankAccountsFlagHelp()

◆ GetBankAccountsFlagLength()

◆ GetBaseCurrencyDBName()

◆ GetBaseCurrencyHelp()

◆ GetBaseCurrencyLength()

◆ GetBudgetControlFlagDBName()

◆ GetBudgetControlFlagHelp()

◆ GetBudgetControlFlagLength()

◆ GetBudgetDataRetentionDBName()

◆ GetBudgetDataRetentionHelp()

◆ GetBudgetDataRetentionLength()

◆ GetCalendarModeDBName()

◆ GetCalendarModeHelp()

◆ GetCalendarModeLength()

◆ GetChanges()

◆ GetChangesTyped()

◆ GetChangesTypedInternal()

◆ GetColumnNameSQL()

◆ GetColumnStringList()

◆ GetConsolidationLedgerDBName()

◆ GetConsolidationLedgerHelp()

◆ GetConsolidationLedgerLength()

◆ GetCostOfSalesGlAccountDBName()

◆ GetCostOfSalesGlAccountHelp()

◆ GetCostOfSalesGlAccountLength()

◆ GetCountryCodeDBName()

◆ GetCountryCodeHelp()

◆ GetCountryCodeLength()

◆ GetCreatedByDBName()

◆ GetCreatedByHelp()

◆ GetCreatedByLength()

◆ GetCreditorGlAccountCodeDBName()

◆ GetCreditorGlAccountCodeHelp()

◆ GetCreditorGlAccountCodeLength()

◆ GetCurrentFinancialYearDBName()

◆ GetCurrentFinancialYearHelp()

◆ GetCurrentFinancialYearLength()

◆ GetCurrentPeriodDBName()

◆ GetCurrentPeriodEndDateDBName()

◆ GetCurrentPeriodEndDateHelp()

◆ GetCurrentPeriodEndDateLength()

◆ GetCurrentPeriodHelp()

◆ GetCurrentPeriodLength()

◆ GetCurrentPeriodStartDateDBName()

◆ GetCurrentPeriodStartDateHelp()

◆ GetCurrentPeriodStartDateLength()

◆ GetCustomReportFieldList()

◆ GetCustomReportPermission()

◆ GetDateCrDrBalancesDBName()

◆ GetDateCrDrBalancesHelp()

◆ GetDateCrDrBalancesLength()

◆ GetDateCreatedDBName()

◆ GetDateCreatedHelp()

◆ GetDateCreatedLength()

◆ GetDateModifiedDBName()

◆ GetDateModifiedHelp()

◆ GetDateModifiedLength()

◆ GetDebtorGlAccountCodeDBName()

◆ GetDebtorGlAccountCodeHelp()

◆ GetDebtorGlAccountCodeLength()