Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable Class Reference

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.Account.Data.ALedgerTable:

Public Member Functions
	ALedgerTable ()
	constructor More...
	ALedgerTable (string ATablename)
	constructor More...
	ALedgerTable (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...
ALedgerRow	NewRowTyped (bool AWithDefaultValues)
	create a new typed row More...
ALedgerRow	NewRowTyped ()
	create a new typed row, always with default values More...
ALedgerTable	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 string	GetTableName ()
	return the CamelCase name of the table More...
static string	GetTableDBName ()
	return the name of the table as it is used in the database More...
static 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	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 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 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 string	GetTableName (short ATableNumber)
	the table name in CamelCase 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	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 readonly short	TableId = 111
	TableId for Ict.Common.Data generic 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
ALedgerRow	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

ALedgerTable() [1/3]

Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ALedgerTable ( )

inline

constructor

ALedgerTable() [2/3]

Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ALedgerTable ( string  ATablename )

inline

constructor

ALedgerTable() [3/3]

Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ALedgerTable ( 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.Account.Data.ALedgerTable.CreateOdbcParameter ( Int32  AColumnNr )

inlinevirtual

get an odbc parameter for the given column

Implements Ict.Common.Data.TTypedDataTable.

Reimplemented in Ict.Petra.Shared.MFinance.CrossLedger.Data.ExchangeRateTDSALedgerInfoTable.

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

create an odbc parameter for the given column

GetActualsDataRetentionDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetActualsDataRetentionDBName ( )

inlinestatic

get the name of the field in the database for this column

GetActualsDataRetentionHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetActualsDataRetentionHelp ( )

inlinestatic

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

GetActualsDataRetentionLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetActualsDataRetentionLength ( )

inlinestatic

get character length for column

GetBankAccountsFlagDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetBankAccountsFlagDBName ( )

inlinestatic

get the name of the field in the database for this column

GetBankAccountsFlagHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetBankAccountsFlagHelp ( )

inlinestatic

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

GetBankAccountsFlagLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetBankAccountsFlagLength ( )

inlinestatic

get character length for column

GetBaseCurrencyDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetBaseCurrencyDBName ( )

inlinestatic

get the name of the field in the database for this column

GetBaseCurrencyHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetBaseCurrencyHelp ( )

inlinestatic

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

GetBaseCurrencyLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetBaseCurrencyLength ( )

inlinestatic

get character length for column

GetBudgetControlFlagDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetBudgetControlFlagDBName ( )

inlinestatic

get the name of the field in the database for this column

GetBudgetControlFlagHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetBudgetControlFlagHelp ( )

inlinestatic

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

GetBudgetControlFlagLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetBudgetControlFlagLength ( )

inlinestatic

get character length for column

GetBudgetDataRetentionDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetBudgetDataRetentionDBName ( )

inlinestatic

get the name of the field in the database for this column

GetBudgetDataRetentionHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetBudgetDataRetentionHelp ( )

inlinestatic

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

GetBudgetDataRetentionLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetBudgetDataRetentionLength ( )

inlinestatic

get character length for column

GetCalendarModeDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCalendarModeDBName ( )

inlinestatic

get the name of the field in the database for this column

GetCalendarModeHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCalendarModeHelp ( )

inlinestatic

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

GetCalendarModeLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCalendarModeLength ( )

inlinestatic

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()

ALedgerTable Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.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  )

inlinestaticinherited

the column name as it is in the SQL database

GetColumnStringList()

static string[] Ict.Common.Data.TTypedDataTable.GetColumnStringList ( short  ATableNumber )

inlinestaticinherited

get the names of the columns in this table

GetConsolidationLedgerDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetConsolidationLedgerDBName ( )

inlinestatic

get the name of the field in the database for this column

GetConsolidationLedgerHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetConsolidationLedgerHelp ( )

inlinestatic

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

GetConsolidationLedgerLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetConsolidationLedgerLength ( )

inlinestatic

get character length for column

GetCostOfSalesGlAccountDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCostOfSalesGlAccountDBName ( )

inlinestatic

get the name of the field in the database for this column

GetCostOfSalesGlAccountHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCostOfSalesGlAccountHelp ( )

inlinestatic

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

GetCostOfSalesGlAccountLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCostOfSalesGlAccountLength ( )

inlinestatic

get character length for column

GetCountryCodeDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCountryCodeDBName ( )

inlinestatic

get the name of the field in the database for this column

GetCountryCodeHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCountryCodeHelp ( )

inlinestatic

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

GetCountryCodeLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCountryCodeLength ( )

inlinestatic

get character length for column

GetCreatedByDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCreatedByDBName ( )

inlinestatic

get the name of the field in the database for this column

GetCreatedByHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCreatedByHelp ( )

inlinestatic

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

GetCreatedByLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCreatedByLength ( )

inlinestatic

get character length for column

GetCreditorGlAccountCodeDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCreditorGlAccountCodeDBName ( )

inlinestatic

get the name of the field in the database for this column

GetCreditorGlAccountCodeHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCreditorGlAccountCodeHelp ( )

inlinestatic

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

GetCreditorGlAccountCodeLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCreditorGlAccountCodeLength ( )

inlinestatic

get character length for column

GetCurrentFinancialYearDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCurrentFinancialYearDBName ( )

inlinestatic

get the name of the field in the database for this column

GetCurrentFinancialYearHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCurrentFinancialYearHelp ( )

inlinestatic

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

GetCurrentFinancialYearLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCurrentFinancialYearLength ( )

inlinestatic

get character length for column

GetCurrentPeriodDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCurrentPeriodDBName ( )

inlinestatic

get the name of the field in the database for this column

GetCurrentPeriodHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCurrentPeriodHelp ( )

inlinestatic

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

GetCurrentPeriodLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetCurrentPeriodLength ( )

inlinestatic

get character length for column

GetCustomReportFieldList()

virtual List< String > Ict.Common.Data.TTypedDataTable.GetCustomReportFieldList ( )

inlinevirtualinherited

Return a list of fields that are available for custom reports

GetCustomReportPermission()

virtual string Ict.Common.Data.TTypedDataTable.GetCustomReportPermission ( )

inlinevirtualinherited

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

GetDateCrDrBalancesDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDateCrDrBalancesDBName ( )

inlinestatic

get the name of the field in the database for this column

GetDateCrDrBalancesHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDateCrDrBalancesHelp ( )

inlinestatic

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

GetDateCrDrBalancesLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDateCrDrBalancesLength ( )

inlinestatic

get character length for column

GetDateCreatedDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDateCreatedDBName ( )

inlinestatic

get the name of the field in the database for this column

GetDateCreatedHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDateCreatedHelp ( )

inlinestatic

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

GetDateCreatedLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDateCreatedLength ( )

inlinestatic

get character length for column

GetDateModifiedDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDateModifiedDBName ( )

inlinestatic

get the name of the field in the database for this column

GetDateModifiedHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDateModifiedHelp ( )

inlinestatic

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

GetDateModifiedLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDateModifiedLength ( )

inlinestatic

get character length for column

GetDebtorGlAccountCodeDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDebtorGlAccountCodeDBName ( )

inlinestatic

get the name of the field in the database for this column

GetDebtorGlAccountCodeHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDebtorGlAccountCodeHelp ( )

inlinestatic

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

GetDebtorGlAccountCodeLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDebtorGlAccountCodeLength ( )

inlinestatic

get character length for column

GetDeleteLedgerFlagDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDeleteLedgerFlagDBName ( )

inlinestatic

get the name of the field in the database for this column

GetDeleteLedgerFlagHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDeleteLedgerFlagHelp ( )

inlinestatic

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

GetDeleteLedgerFlagLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDeleteLedgerFlagLength ( )

inlinestatic

get character length for column

GetDiscountAllowedPctDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDiscountAllowedPctDBName ( )

inlinestatic

get the name of the field in the database for this column

GetDiscountAllowedPctHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDiscountAllowedPctHelp ( )

inlinestatic

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

GetDiscountAllowedPctLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDiscountAllowedPctLength ( )

inlinestatic

get character length for column

GetDiscountReceivedPctDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDiscountReceivedPctDBName ( )

inlinestatic

get the name of the field in the database for this column

GetDiscountReceivedPctHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDiscountReceivedPctHelp ( )

inlinestatic

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

GetDiscountReceivedPctLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetDiscountReceivedPctLength ( )

inlinestatic

get character length for column

GetFaDepreciationGlAccountDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetFaDepreciationGlAccountDBName ( )

inlinestatic

get the name of the field in the database for this column

GetFaDepreciationGlAccountHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetFaDepreciationGlAccountHelp ( )

inlinestatic

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

GetFaDepreciationGlAccountLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetFaDepreciationGlAccountLength ( )

inlinestatic

get character length for column

GetFaGlAccountCodeDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetFaGlAccountCodeDBName ( )

inlinestatic

get the name of the field in the database for this column

GetFaGlAccountCodeHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetFaGlAccountCodeHelp ( )

inlinestatic

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

GetFaGlAccountCodeLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetFaGlAccountCodeLength ( )

inlinestatic

get character length for column

GetFaPlOnSaleGlAccountDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetFaPlOnSaleGlAccountDBName ( )

inlinestatic

get the name of the field in the database for this column

GetFaPlOnSaleGlAccountHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetFaPlOnSaleGlAccountHelp ( )

inlinestatic

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

GetFaPlOnSaleGlAccountLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetFaPlOnSaleGlAccountLength ( )

inlinestatic

get character length for column

GetFaProvForDepnGlAccountDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetFaProvForDepnGlAccountDBName ( )

inlinestatic

get the name of the field in the database for this column

GetFaProvForDepnGlAccountHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetFaProvForDepnGlAccountHelp ( )

inlinestatic

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

GetFaProvForDepnGlAccountLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetFaProvForDepnGlAccountLength ( )

inlinestatic

get character length for column

GetForexGainsLossesAccountDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetForexGainsLossesAccountDBName ( )

inlinestatic

get the name of the field in the database for this column

GetForexGainsLossesAccountHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetForexGainsLossesAccountHelp ( )

inlinestatic

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

GetForexGainsLossesAccountLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetForexGainsLossesAccountLength ( )

inlinestatic

get character length for column

GetGiftDataRetentionDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetGiftDataRetentionDBName ( )

inlinestatic

get the name of the field in the database for this column

GetGiftDataRetentionHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetGiftDataRetentionHelp ( )

inlinestatic

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

GetGiftDataRetentionLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetGiftDataRetentionLength ( )

inlinestatic

get character length for column

GetIltAccountFlagDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetIltAccountFlagDBName ( )

inlinestatic

get the name of the field in the database for this column

GetIltAccountFlagHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetIltAccountFlagHelp ( )

inlinestatic

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

GetIltAccountFlagLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetIltAccountFlagLength ( )

inlinestatic

get character length for column

GetIltGlAccountCodeDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetIltGlAccountCodeDBName ( )

inlinestatic

get the name of the field in the database for this column

GetIltGlAccountCodeHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetIltGlAccountCodeHelp ( )

inlinestatic

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

GetIltGlAccountCodeLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetIltGlAccountCodeLength ( )

inlinestatic

get character length for column

GetIltProcessingCentreDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetIltProcessingCentreDBName ( )

inlinestatic

get the name of the field in the database for this column

GetIltProcessingCentreHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetIltProcessingCentreHelp ( )

inlinestatic

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

GetIltProcessingCentreLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetIltProcessingCentreLength ( )

inlinestatic

get character length for column

GetInstallationIdDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetInstallationIdDBName ( )

inlinestatic

get the name of the field in the database for this column

GetInstallationIdHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetInstallationIdHelp ( )

inlinestatic

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

GetInstallationIdLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetInstallationIdLength ( )

inlinestatic

get character length for column

GetIntlCurrencyDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetIntlCurrencyDBName ( )

inlinestatic

get the name of the field in the database for this column

GetIntlCurrencyHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetIntlCurrencyHelp ( )

inlinestatic

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

GetIntlCurrencyLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetIntlCurrencyLength ( )

inlinestatic

get character length for column

GetKeyColumnStringList()

static string[] Ict.Common.Data.TTypedDataTable.GetKeyColumnStringList ( short  ATableNumber, int[]  AKeyColumnsOrder  )

inlinestaticinherited

get the names of the columns that are part of the key

GetLabel()

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

inlinestaticinherited

returns the translated label for the column

GetLastApDnNumberDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastApDnNumberDBName ( )

inlinestatic

get the name of the field in the database for this column

GetLastApDnNumberHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastApDnNumberHelp ( )

inlinestatic

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

GetLastApDnNumberLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastApDnNumberLength ( )

inlinestatic

get character length for column

GetLastApInvNumberDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastApInvNumberDBName ( )

inlinestatic

get the name of the field in the database for this column

GetLastApInvNumberHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastApInvNumberHelp ( )

inlinestatic

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

GetLastApInvNumberLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastApInvNumberLength ( )

inlinestatic

get character length for column

GetLastBatchNumberDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastBatchNumberDBName ( )

inlinestatic

get the name of the field in the database for this column

GetLastBatchNumberHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastBatchNumberHelp ( )

inlinestatic

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

GetLastBatchNumberLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastBatchNumberLength ( )

inlinestatic

get character length for column

GetLastGiftBatchNumberDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastGiftBatchNumberDBName ( )

inlinestatic

get the name of the field in the database for this column

GetLastGiftBatchNumberHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastGiftBatchNumberHelp ( )

inlinestatic

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

GetLastGiftBatchNumberLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastGiftBatchNumberLength ( )

inlinestatic

get character length for column

GetLastGiftNumberDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastGiftNumberDBName ( )

inlinestatic

get the name of the field in the database for this column

GetLastGiftNumberHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastGiftNumberHelp ( )

inlinestatic

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

GetLastGiftNumberLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastGiftNumberLength ( )

inlinestatic

get character length for column

GetLastHeaderPNumberDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastHeaderPNumberDBName ( )

inlinestatic

get the name of the field in the database for this column

GetLastHeaderPNumberHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastHeaderPNumberHelp ( )

inlinestatic

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

GetLastHeaderPNumberLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastHeaderPNumberLength ( )

inlinestatic

get character length for column

GetLastHeaderRNumberDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastHeaderRNumberDBName ( )

inlinestatic

get the name of the field in the database for this column

GetLastHeaderRNumberHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastHeaderRNumberHelp ( )

inlinestatic

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

GetLastHeaderRNumberLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastHeaderRNumberLength ( )

inlinestatic

get character length for column

GetLastIchNumberDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastIchNumberDBName ( )

inlinestatic

get the name of the field in the database for this column

GetLastIchNumberHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastIchNumberHelp ( )

inlinestatic

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

GetLastIchNumberLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastIchNumberLength ( )

inlinestatic

get character length for column

GetLastPoNumberDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastPoNumberDBName ( )

inlinestatic

get the name of the field in the database for this column

GetLastPoNumberHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastPoNumberHelp ( )

inlinestatic

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

GetLastPoNumberLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastPoNumberLength ( )

inlinestatic

get character length for column

GetLastPoRecNumberDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastPoRecNumberDBName ( )

inlinestatic

get the name of the field in the database for this column

GetLastPoRecNumberHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastPoRecNumberHelp ( )

inlinestatic

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

GetLastPoRecNumberLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastPoRecNumberLength ( )

inlinestatic

get character length for column

GetLastPoRetNumberDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastPoRetNumberDBName ( )

inlinestatic

get the name of the field in the database for this column

GetLastPoRetNumberHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastPoRetNumberHelp ( )

inlinestatic

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

GetLastPoRetNumberLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastPoRetNumberLength ( )

inlinestatic

get character length for column

GetLastRecGiftBatchNumberDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastRecGiftBatchNumberDBName ( )

inlinestatic

get the name of the field in the database for this column

GetLastRecGiftBatchNumberHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastRecGiftBatchNumberHelp ( )

inlinestatic

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

GetLastRecGiftBatchNumberLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastRecGiftBatchNumberLength ( )

inlinestatic

get character length for column

GetLastRecurringBatchNumberDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastRecurringBatchNumberDBName ( )

inlinestatic

get the name of the field in the database for this column

GetLastRecurringBatchNumberHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastRecurringBatchNumberHelp ( )

inlinestatic

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

GetLastRecurringBatchNumberLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastRecurringBatchNumberLength ( )

inlinestatic

get character length for column

GetLastSoDelNumberDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastSoDelNumberDBName ( )

inlinestatic

get the name of the field in the database for this column

GetLastSoDelNumberHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastSoDelNumberHelp ( )

inlinestatic

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

GetLastSoDelNumberLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastSoDelNumberLength ( )

inlinestatic

get character length for column

GetLastSoNumberDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastSoNumberDBName ( )

inlinestatic

get the name of the field in the database for this column

GetLastSoNumberHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastSoNumberHelp ( )

inlinestatic

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

GetLastSoNumberLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastSoNumberLength ( )

inlinestatic

get character length for column

GetLastSoRetNumberDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastSoRetNumberDBName ( )

inlinestatic

get the name of the field in the database for this column

GetLastSoRetNumberHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastSoRetNumberHelp ( )

inlinestatic

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

GetLastSoRetNumberLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastSoRetNumberLength ( )

inlinestatic

get character length for column

GetLastSpecialGiftNumberDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastSpecialGiftNumberDBName ( )

inlinestatic

get the name of the field in the database for this column

GetLastSpecialGiftNumberHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastSpecialGiftNumberHelp ( )

inlinestatic

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

GetLastSpecialGiftNumberLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLastSpecialGiftNumberLength ( )

inlinestatic

get character length for column

GetLedgerNameDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLedgerNameDBName ( )

inlinestatic

get the name of the field in the database for this column

GetLedgerNameHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLedgerNameHelp ( )

inlinestatic

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

GetLedgerNameLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLedgerNameLength ( )

inlinestatic

get character length for column

GetLedgerNumberDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLedgerNumberDBName ( )

inlinestatic

get the name of the field in the database for this column

GetLedgerNumberHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLedgerNumberHelp ( )

inlinestatic

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

GetLedgerNumberLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLedgerNumberLength ( )

inlinestatic

get character length for column

GetLedgerStatusDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLedgerStatusDBName ( )

inlinestatic

get the name of the field in the database for this column

GetLedgerStatusHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLedgerStatusHelp ( )

inlinestatic

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

GetLedgerStatusLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetLedgerStatusLength ( )

inlinestatic

get character length for column

GetLength() [1/2]

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

inlinestaticinherited

get the maximum length for the field

GetLength() [2/2]

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

inlinestaticinherited

get the maximum length for the field

GetMaxGiftAidAmountDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetMaxGiftAidAmountDBName ( )

inlinestatic

get the name of the field in the database for this column

GetMaxGiftAidAmountHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetMaxGiftAidAmountHelp ( )

inlinestatic

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

GetMaxGiftAidAmountLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetMaxGiftAidAmountLength ( )

inlinestatic

get character length for column

GetMinGiftAidAmountDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetMinGiftAidAmountDBName ( )

inlinestatic

get the name of the field in the database for this column

GetMinGiftAidAmountHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetMinGiftAidAmountHelp ( )

inlinestatic

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

GetMinGiftAidAmountLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetMinGiftAidAmountLength ( )

inlinestatic

get character length for column

GetModificationIdDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetModificationIdDBName ( )

inlinestatic

get the name of the field in the database for this column

GetModificationIdHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetModificationIdHelp ( )

inlinestatic

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

GetModificationIdLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetModificationIdLength ( )

inlinestatic

get character length for column

GetModifiedByDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetModifiedByDBName ( )

inlinestatic

get the name of the field in the database for this column

GetModifiedByHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetModifiedByHelp ( )

inlinestatic

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

GetModifiedByLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetModifiedByLength ( )

inlinestatic

get character length for column

GetNewFinancialYearFlagDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetNewFinancialYearFlagDBName ( )

inlinestatic

get the name of the field in the database for this column

GetNewFinancialYearFlagHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetNewFinancialYearFlagHelp ( )

inlinestatic

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

GetNewFinancialYearFlagLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetNewFinancialYearFlagLength ( )

inlinestatic

get character length for column

GetNumberFwdPostingPeriodsDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetNumberFwdPostingPeriodsDBName ( )

inlinestatic

get the name of the field in the database for this column

GetNumberFwdPostingPeriodsHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetNumberFwdPostingPeriodsHelp ( )

inlinestatic

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

GetNumberFwdPostingPeriodsLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetNumberFwdPostingPeriodsLength ( )

inlinestatic

get character length for column

GetNumberOfAccountingPeriodsDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetNumberOfAccountingPeriodsDBName ( )

inlinestatic

get the name of the field in the database for this column

GetNumberOfAccountingPeriodsHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetNumberOfAccountingPeriodsHelp ( )

inlinestatic

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

GetNumberOfAccountingPeriodsLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetNumberOfAccountingPeriodsLength ( )

inlinestatic

get character length for column

GetNumberOfGiftsToDisplayDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetNumberOfGiftsToDisplayDBName ( )

inlinestatic

get the name of the field in the database for this column

GetNumberOfGiftsToDisplayHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetNumberOfGiftsToDisplayHelp ( )

inlinestatic

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

GetNumberOfGiftsToDisplayLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetNumberOfGiftsToDisplayLength ( )

inlinestatic

get character length for column

GetPartnerKeyDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetPartnerKeyDBName ( )

inlinestatic

get the name of the field in the database for this column

GetPartnerKeyHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetPartnerKeyHelp ( )

inlinestatic

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

GetPartnerKeyLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetPartnerKeyLength ( )

inlinestatic

get character length for column

GetPoAccrualGlAccountCodeDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetPoAccrualGlAccountCodeDBName ( )

inlinestatic

get the name of the field in the database for this column

GetPoAccrualGlAccountCodeHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetPoAccrualGlAccountCodeHelp ( )

inlinestatic

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

GetPoAccrualGlAccountCodeLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetPoAccrualGlAccountCodeLength ( )

inlinestatic

get character length for column

GetPrimaryKeyColumnOrdList()

static int[] Ict.Common.Data.TTypedDataTable.GetPrimaryKeyColumnOrdList ( short  ATableNumber )

inlinestaticinherited

get the order number of the columns that are part of the primary key

GetPrimaryKeyColumnStringList()

static string[] Ict.Common.Data.TTypedDataTable.GetPrimaryKeyColumnStringList ( short  ATableNumber )

inlinestaticinherited

get the names of the columns that are part of the primary key

GetProfitLossGlAccountCodeDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetProfitLossGlAccountCodeDBName ( )

inlinestatic

get the name of the field in the database for this column

GetProfitLossGlAccountCodeHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetProfitLossGlAccountCodeHelp ( )

inlinestatic

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

GetProfitLossGlAccountCodeLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetProfitLossGlAccountCodeLength ( )

inlinestatic

get character length for column

GetProvisionalYearEndFlagDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetProvisionalYearEndFlagDBName ( )

inlinestatic

get the name of the field in the database for this column

GetProvisionalYearEndFlagHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetProvisionalYearEndFlagHelp ( )

inlinestatic

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

GetProvisionalYearEndFlagLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetProvisionalYearEndFlagLength ( )

inlinestatic

get character length for column

GetPurchaseGlAccountCodeDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetPurchaseGlAccountCodeDBName ( )

inlinestatic

get the name of the field in the database for this column

GetPurchaseGlAccountCodeHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetPurchaseGlAccountCodeHelp ( )

inlinestatic

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

GetPurchaseGlAccountCodeLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetPurchaseGlAccountCodeLength ( )

inlinestatic

get character length for column

GetRecalculateAllPeriodsDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetRecalculateAllPeriodsDBName ( )

inlinestatic

get the name of the field in the database for this column

GetRecalculateAllPeriodsHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetRecalculateAllPeriodsHelp ( )

inlinestatic

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

GetRecalculateAllPeriodsLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetRecalculateAllPeriodsLength ( )

inlinestatic

get character length for column

GetRecalculateGlMasterFlagDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetRecalculateGlMasterFlagDBName ( )

inlinestatic

get the name of the field in the database for this column

GetRecalculateGlMasterFlagHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetRecalculateGlMasterFlagHelp ( )

inlinestatic

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

GetRecalculateGlMasterFlagLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetRecalculateGlMasterFlagLength ( )

inlinestatic

get character length for column

GetRetEarningsGlAccountDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetRetEarningsGlAccountDBName ( )

inlinestatic

get the name of the field in the database for this column

GetRetEarningsGlAccountHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetRetEarningsGlAccountHelp ( )

inlinestatic

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

GetRetEarningsGlAccountLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetRetEarningsGlAccountLength ( )

inlinestatic

get character length for column

GetSalesGlAccountCodeDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetSalesGlAccountCodeDBName ( )

inlinestatic

get the name of the field in the database for this column

GetSalesGlAccountCodeHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetSalesGlAccountCodeHelp ( )

inlinestatic

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

GetSalesGlAccountCodeLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetSalesGlAccountCodeLength ( )

inlinestatic

get character length for column

GetSoAccrualGlAccountCodeDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetSoAccrualGlAccountCodeDBName ( )

inlinestatic

get the name of the field in the database for this column

GetSoAccrualGlAccountCodeHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetSoAccrualGlAccountCodeHelp ( )

inlinestatic

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

GetSoAccrualGlAccountCodeLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetSoAccrualGlAccountCodeLength ( )

inlinestatic

get character length for column

GetStockAccrualGlAccountDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetStockAccrualGlAccountDBName ( )

inlinestatic

get the name of the field in the database for this column

GetStockAccrualGlAccountHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetStockAccrualGlAccountHelp ( )

inlinestatic

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

GetStockAccrualGlAccountLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetStockAccrualGlAccountLength ( )

inlinestatic

get character length for column

GetStockAdjGlAccountCodeDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetStockAdjGlAccountCodeDBName ( )

inlinestatic

get the name of the field in the database for this column

GetStockAdjGlAccountCodeHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetStockAdjGlAccountCodeHelp ( )

inlinestatic

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

GetStockAdjGlAccountCodeLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetStockAdjGlAccountCodeLength ( )

inlinestatic

get character length for column

GetStockGlAccountCodeDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetStockGlAccountCodeDBName ( )

inlinestatic

get the name of the field in the database for this column

GetStockGlAccountCodeHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetStockGlAccountCodeHelp ( )

inlinestatic

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

GetStockGlAccountCodeLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetStockGlAccountCodeLength ( )

inlinestatic

get character length for column

GetSuspenseAccountFlagDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetSuspenseAccountFlagDBName ( )

inlinestatic

get the name of the field in the database for this column

GetSuspenseAccountFlagHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetSuspenseAccountFlagHelp ( )

inlinestatic

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

GetSuspenseAccountFlagLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetSuspenseAccountFlagLength ( )

inlinestatic

get character length for column

GetSystemInterfaceFlagDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetSystemInterfaceFlagDBName ( )

inlinestatic

get the name of the field in the database for this column

GetSystemInterfaceFlagHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetSystemInterfaceFlagHelp ( )

inlinestatic

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

GetSystemInterfaceFlagLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetSystemInterfaceFlagLength ( )

inlinestatic

get character length for column

GetTableByName()

static TTypedTableInfo Ict.Common.Data.TTypedDataTable.GetTableByName ( string  ATableName )

inlinestaticinherited

the table name in CamelCase

GetTableDBLabel()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTableDBLabel ( )

inlinestatic

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

GetTableDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTableDBName ( )

inlinestatic

return the name of the table as it is used in the database

GetTableName() [1/2]

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTableName ( )

inlinestatic

return the CamelCase name of the table

GetTableName() [2/2]

static string Ict.Common.Data.TTypedDataTable.GetTableName ( short  ATableNumber )

inlinestaticinherited

the table name in CamelCase

GetTableNameSQL()

static string Ict.Common.Data.TTypedDataTable.GetTableNameSQL ( short  ATableNumber )

inlinestaticinherited

the table name as it is in the SQL database

GetTaxExclInclDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxExclInclDBName ( )

inlinestatic

get the name of the field in the database for this column

GetTaxExclInclHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxExclInclHelp ( )

inlinestatic

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

GetTaxExclInclIndicatorDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxExclInclIndicatorDBName ( )

inlinestatic

get the name of the field in the database for this column

GetTaxExclInclIndicatorHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxExclInclIndicatorHelp ( )

inlinestatic

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

GetTaxExclInclIndicatorLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxExclInclIndicatorLength ( )

inlinestatic

get character length for column

GetTaxExclInclLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxExclInclLength ( )

inlinestatic

get character length for column

GetTaxGlAccountNumberDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxGlAccountNumberDBName ( )

inlinestatic

get the name of the field in the database for this column

GetTaxGlAccountNumberHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxGlAccountNumberHelp ( )

inlinestatic

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

GetTaxGlAccountNumberLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxGlAccountNumberLength ( )

inlinestatic

get character length for column

GetTaxInputGlAccountCodeDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxInputGlAccountCodeDBName ( )

inlinestatic

get the name of the field in the database for this column

GetTaxInputGlAccountCodeHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxInputGlAccountCodeHelp ( )

inlinestatic

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

GetTaxInputGlAccountCodeLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxInputGlAccountCodeLength ( )

inlinestatic

get character length for column

GetTaxInputGlCcCodeDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxInputGlCcCodeDBName ( )

inlinestatic

get the name of the field in the database for this column

GetTaxInputGlCcCodeHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxInputGlCcCodeHelp ( )

inlinestatic

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

GetTaxInputGlCcCodeLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxInputGlCcCodeLength ( )

inlinestatic

get character length for column

GetTaxOutputGlAccountCodeDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxOutputGlAccountCodeDBName ( )

inlinestatic

get the name of the field in the database for this column

GetTaxOutputGlAccountCodeHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxOutputGlAccountCodeHelp ( )

inlinestatic

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

GetTaxOutputGlAccountCodeLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxOutputGlAccountCodeLength ( )

inlinestatic

get character length for column

GetTaxTypeCodeDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxTypeCodeDBName ( )

inlinestatic

get the name of the field in the database for this column

GetTaxTypeCodeHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxTypeCodeHelp ( )

inlinestatic

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

GetTaxTypeCodeLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTaxTypeCodeLength ( )

inlinestatic

get character length for column

GetTermsOfPaymentCodeDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTermsOfPaymentCodeDBName ( )

inlinestatic

get the name of the field in the database for this column

GetTermsOfPaymentCodeHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTermsOfPaymentCodeHelp ( )

inlinestatic

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

GetTermsOfPaymentCodeLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTermsOfPaymentCodeLength ( )

inlinestatic

get character length for column

GetTransactionAccountFlagDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTransactionAccountFlagDBName ( )

inlinestatic

get the name of the field in the database for this column

GetTransactionAccountFlagHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTransactionAccountFlagHelp ( )

inlinestatic

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

GetTransactionAccountFlagLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetTransactionAccountFlagLength ( )

inlinestatic

get character length for column

GetUniqueKeyColumnOrdList()

static int[] Ict.Common.Data.TTypedDataTable.GetUniqueKeyColumnOrdList ( short  ATableNumber )

inlinestaticinherited

get the order number of the columns that are part of a unique key

GetUniqueKeyColumnStringList()

static string[] Ict.Common.Data.TTypedDataTable.GetUniqueKeyColumnStringList ( short  ATableNumber )

inlinestaticinherited

get the names of the columns that are part of the unique key

GetYearEndFlagDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetYearEndFlagDBName ( )

inlinestatic

get the name of the field in the database for this column

GetYearEndFlagHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetYearEndFlagHelp ( )

inlinestatic

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

GetYearEndFlagLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetYearEndFlagLength ( )

inlinestatic

get character length for column

GetYearEndProcessStatusDBName()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetYearEndProcessStatusDBName ( )

inlinestatic

get the name of the field in the database for this column

GetYearEndProcessStatusHelp()

static string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetYearEndProcessStatusHelp ( )

inlinestatic

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

GetYearEndProcessStatusLength()

static short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.GetYearEndProcessStatusLength ( )

inlinestatic

get character length for column

InitClass()

override void Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.InitClass ( )

inlineprotectedvirtual

create the columns

Implements Ict.Common.Data.TTypedDataTable.

Reimplemented in Ict.Petra.Shared.MFinance.CrossLedger.Data.ExchangeRateTDSALedgerInfoTable.

InitVars()

override void Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.InitVars ( )

inlinevirtual

assign columns to properties, set primary key

Implements Ict.Common.Data.TTypedDataTable.

Reimplemented in Ict.Petra.Shared.MFinance.CrossLedger.Data.ExchangeRateTDSALedgerInfoTable.

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.Account.Data.ALedgerTable.NewRowFromBuilder ( System.Data.DataRowBuilder  builder )

inlineprotected

new typed row using DataRowBuilder

NewRowTyped() [1/2]

ALedgerRow Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.NewRowTyped ( )

inline

create a new typed row, always with default values

NewRowTyped() [2/2]

ALedgerRow Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.NewRowTyped ( bool  AWithDefaultValues )

inline

create a new typed row

RemoveColumnsNotInTableTemplate()

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

inlineinherited

remove columns that are not needed

Parameters

ATableTemplate

this table only contains the columns that should be kept

ResetStaticVariables()

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

inlinestaticinherited

reset the static variables for each Web Request call.

Member Data Documentation

ColumnActualsDataRetention

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

ColumnActualsDataRetentionId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnActualsDataRetentionId = 67

static

used for generic TTypedDataTable functions

ColumnBankAccountsFlag

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

Used to get a yes no response from the user.

ColumnBankAccountsFlagId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnBankAccountsFlagId = 24

static

used for generic TTypedDataTable functions

ColumnBaseCurrency

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

This defines which currency is being used.

ColumnBaseCurrencyId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnBaseCurrencyId = 18

static

used for generic TTypedDataTable functions

ColumnBudgetControlFlag

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

ColumnBudgetControlFlagId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnBudgetControlFlagId = 29

static

used for generic TTypedDataTable functions

ColumnBudgetDataRetention

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

ColumnBudgetDataRetentionId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnBudgetDataRetentionId = 30

static

used for generic TTypedDataTable functions

ColumnCalendarMode

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

ColumnCalendarModeId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnCalendarModeId = 69

static

used for generic TTypedDataTable functions

ColumnConsolidationLedger

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

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

static

used for generic TTypedDataTable functions

ColumnCostOfSalesGlAccount

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

ColumnCostOfSalesGlAccountId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnCostOfSalesGlAccountId = 31

static

used for generic TTypedDataTable functions

ColumnCountryCode

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

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

ColumnCountryCodeId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnCountryCodeId = 17

static

used for generic TTypedDataTable functions

ColumnCreatedBy

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

User ID of who created this record.

ColumnCreatedById

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnCreatedById = 81

static

used for generic TTypedDataTable functions

ColumnCreditorGlAccountCode

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

ColumnCreditorGlAccountCodeId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnCreditorGlAccountCodeId = 32

static

used for generic TTypedDataTable functions

ColumnCurrentFinancialYear

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

ColumnCurrentFinancialYearId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnCurrentFinancialYearId = 33

static

used for generic TTypedDataTable functions

ColumnCurrentPeriod

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

ColumnCurrentPeriodId

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

static

used for generic TTypedDataTable functions

ColumnDateCrDrBalances

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

ColumnDateCrDrBalancesId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnDateCrDrBalancesId = 35

static

used for generic TTypedDataTable functions

ColumnDateCreated

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

The date the record was created.

ColumnDateCreatedId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnDateCreatedId = 80

static

used for generic TTypedDataTable functions

ColumnDateModified

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

The date the record was modified.

ColumnDateModifiedId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnDateModifiedId = 82

static

used for generic TTypedDataTable functions

ColumnDebtorGlAccountCode

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

ColumnDebtorGlAccountCodeId

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

static

used for generic TTypedDataTable functions

ColumnDeleteLedgerFlag

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

Used to get a yes no response from the user.

ColumnDeleteLedgerFlagId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnDeleteLedgerFlagId = 25

static

used for generic TTypedDataTable functions

ColumnDiscountAllowedPct

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

ColumnDiscountAllowedPctId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnDiscountAllowedPctId = 48

static

used for generic TTypedDataTable functions

ColumnDiscountReceivedPct

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

ColumnDiscountReceivedPctId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnDiscountReceivedPctId = 49

static

used for generic TTypedDataTable functions

ColumnFaDepreciationGlAccount

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

ColumnFaDepreciationGlAccountId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnFaDepreciationGlAccountId = 37

static

used for generic TTypedDataTable functions

ColumnFaGlAccountCode

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

ColumnFaGlAccountCodeId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnFaGlAccountCodeId = 38

static

used for generic TTypedDataTable functions

ColumnFaPlOnSaleGlAccount

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

ColumnFaPlOnSaleGlAccountId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnFaPlOnSaleGlAccountId = 39

static

used for generic TTypedDataTable functions

ColumnFaProvForDepnGlAccount

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

ColumnFaProvForDepnGlAccountId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnFaProvForDepnGlAccountId = 40

static

used for generic TTypedDataTable functions

ColumnForexGainsLossesAccount

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

The account for foreign exchange gains or losses.

ColumnForexGainsLossesAccountId

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

static

used for generic TTypedDataTable functions

ColumnGiftDataRetention

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

How many years to retain gift data.

ColumnGiftDataRetentionId

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

static

used for generic TTypedDataTable functions

ColumnIltAccountFlag

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

ColumnIltAccountFlagId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnIltAccountFlagId = 41

static

used for generic TTypedDataTable functions

ColumnIltGlAccountCode

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

The account for inter-ledger transfers.

ColumnIltGlAccountCodeId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnIltGlAccountCodeId = 14

static

used for generic TTypedDataTable functions

ColumnIltProcessingCentre

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

Is this ledger an ILT processing centre (ie, clearinghouse status)

ColumnIltProcessingCentreId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnIltProcessingCentreId = 72

static

used for generic TTypedDataTable functions

ColumnInstallationId

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

Defines which installation is running on this database.

ColumnInstallationIdId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnInstallationIdId = 28

static

used for generic TTypedDataTable functions

ColumnIntlCurrency

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

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

ColumnIntlCurrencyId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnIntlCurrencyId = 74

static

used for generic TTypedDataTable functions

ColumnLastApDnNumber

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

ColumnLastApDnNumberId

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

static

used for generic TTypedDataTable functions

ColumnLastApInvNumber

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

ColumnLastApInvNumberId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastApInvNumberId = 6

static

used for generic TTypedDataTable functions

ColumnLastBatchNumber

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

This is the last batch number used within a ledger.

ColumnLastBatchNumberId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastBatchNumberId = 3

static

used for generic TTypedDataTable functions

ColumnLastGiftBatchNumber

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

The number of the last gift batch to be created.

ColumnLastGiftBatchNumberId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastGiftBatchNumberId = 73

static

used for generic TTypedDataTable functions

ColumnLastGiftNumber

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

ColumnLastGiftNumberId

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

static

used for generic TTypedDataTable functions

ColumnLastHeaderPNumber

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

last used cashbook payment header number

ColumnLastHeaderPNumberId

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

static

used for generic TTypedDataTable functions

ColumnLastHeaderRNumber

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

ColumnLastHeaderRNumberId

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

static

used for generic TTypedDataTable functions

ColumnLastIchNumber

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

identifes the Last used ICH process number

ColumnLastIchNumberId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastIchNumberId = 78

static

used for generic TTypedDataTable functions

ColumnLastPoNumber

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

ColumnLastPoNumberId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastPoNumberId = 8

static

used for generic TTypedDataTable functions

ColumnLastPoRecNumber

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

ColumnLastPoRecNumberId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastPoRecNumberId = 65

static

used for generic TTypedDataTable functions

ColumnLastPoRetNumber

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

ColumnLastPoRetNumberId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastPoRetNumberId = 43

static

used for generic TTypedDataTable functions

ColumnLastRecGiftBatchNumber

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

The number of the last gift batch to be created.

ColumnLastRecGiftBatchNumberId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastRecGiftBatchNumberId = 75

static

used for generic TTypedDataTable functions

ColumnLastRecurringBatchNumber

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

ColumnLastRecurringBatchNumberId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastRecurringBatchNumberId = 4

static

used for generic TTypedDataTable functions

ColumnLastSoDelNumber

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

ColumnLastSoDelNumberId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastSoDelNumberId = 44

static

used for generic TTypedDataTable functions

ColumnLastSoNumber

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

ColumnLastSoNumberId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastSoNumberId = 9

static

used for generic TTypedDataTable functions

ColumnLastSoRetNumber

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

ColumnLastSoRetNumberId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastSoRetNumberId = 45

static

used for generic TTypedDataTable functions

ColumnLastSpecialGiftNumber

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

ColumnLastSpecialGiftNumberId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLastSpecialGiftNumberId = 46

static

used for generic TTypedDataTable functions

ColumnLedgerName

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

This is the ledger name.

ColumnLedgerNameId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLedgerNameId = 1

static

used for generic TTypedDataTable functions

ColumnLedgerNumber

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.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"".

ColumnLedgerNumberId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLedgerNumberId = 0

static

used for generic TTypedDataTable functions

ColumnLedgerStatus

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

Defines if the ledger is in use.

ColumnLedgerStatusId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnLedgerStatusId = 2

static

used for generic TTypedDataTable functions

ColumnMaxGiftAidAmount

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

This is a number of currency units.

ColumnMaxGiftAidAmountId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnMaxGiftAidAmountId = 10

static

used for generic TTypedDataTable functions

ColumnMinGiftAidAmount

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

This is a number of currency units.

ColumnMinGiftAidAmountId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnMinGiftAidAmountId = 11

static

used for generic TTypedDataTable functions

ColumnModificationId

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

This identifies the current version of the record.

ColumnModificationIdId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnModificationIdId = 84

static

used for generic TTypedDataTable functions

ColumnModifiedBy

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

User ID of who last modified this record.

ColumnModifiedById

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnModifiedById = 83

static

used for generic TTypedDataTable functions

ColumnNewFinancialYearFlag

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

Used to get a yes no response from the user.

ColumnNewFinancialYearFlagId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnNewFinancialYearFlagId = 26

static

used for generic TTypedDataTable functions

ColumnNumberFwdPostingPeriods

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

ColumnNumberFwdPostingPeriodsId

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

static

used for generic TTypedDataTable functions

ColumnNumberOfAccountingPeriods

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

This defines which accounting period is being used.

ColumnNumberOfAccountingPeriodsId

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

static

used for generic TTypedDataTable functions

ColumnNumberOfGiftsToDisplay

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

ColumnNumberOfGiftsToDisplayId

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

static

used for generic TTypedDataTable functions

ColumnPartnerKey

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

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

static

used for generic TTypedDataTable functions

ColumnPoAccrualGlAccountCode

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

ColumnPoAccrualGlAccountCodeId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnPoAccrualGlAccountCodeId = 50

static

used for generic TTypedDataTable functions

ColumnProfitLossGlAccountCode

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

This identifies the account the financial transaction must be stored against.

ColumnProfitLossGlAccountCodeId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnProfitLossGlAccountCodeId = 15

static

used for generic TTypedDataTable functions

ColumnProvisionalYearEndFlag

DataColumn Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.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.

ColumnProvisionalYearEndFlagId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnProvisionalYearEndFlagId = 51

static

used for generic TTypedDataTable functions

ColumnPurchaseGlAccountCode

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

ColumnPurchaseGlAccountCodeId

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

static

used for generic TTypedDataTable functions

ColumnRecalculateAllPeriods

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

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

static

used for generic TTypedDataTable functions

ColumnRecalculateGlMasterFlag

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

Used to get a yes no response from the user.

ColumnRecalculateGlMasterFlagId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnRecalculateGlMasterFlagId = 27

static

used for generic TTypedDataTable functions

ColumnRetEarningsGlAccount

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

ColumnRetEarningsGlAccountId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnRetEarningsGlAccountId = 53

static

used for generic TTypedDataTable functions

ColumnSalesGlAccountCode

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

ColumnSalesGlAccountCodeId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnSalesGlAccountCodeId = 54

static

used for generic TTypedDataTable functions

ColumnSoAccrualGlAccountCode

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

ColumnSoAccrualGlAccountCodeId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnSoAccrualGlAccountCodeId = 55

static

used for generic TTypedDataTable functions

ColumnStockAccrualGlAccount

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

ColumnStockAccrualGlAccountId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnStockAccrualGlAccountId = 56

static

used for generic TTypedDataTable functions

ColumnStockAdjGlAccountCode

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

ColumnStockAdjGlAccountCodeId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnStockAdjGlAccountCodeId = 57

static

used for generic TTypedDataTable functions

ColumnStockGlAccountCode

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

ColumnStockGlAccountCodeId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnStockGlAccountCodeId = 58

static

used for generic TTypedDataTable functions

ColumnSuspenseAccountFlag

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

Used to get a yes no response from the user.

ColumnSuspenseAccountFlagId

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

static

used for generic TTypedDataTable functions

ColumnSystemInterfaceFlag

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

Used to get a yes no response from the user.

ColumnSystemInterfaceFlagId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnSystemInterfaceFlagId = 22

static

used for generic TTypedDataTable functions

ColumnTaxExclIncl

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

ColumnTaxExclInclId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnTaxExclInclId = 59

static

used for generic TTypedDataTable functions

ColumnTaxExclInclIndicator

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

ColumnTaxExclInclIndicatorId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnTaxExclInclIndicatorId = 60

static

used for generic TTypedDataTable functions

ColumnTaxGlAccountNumber

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

ColumnTaxGlAccountNumberId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnTaxGlAccountNumberId = 66

static

used for generic TTypedDataTable functions

ColumnTaxInputGlAccountCode

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

ColumnTaxInputGlAccountCodeId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnTaxInputGlAccountCodeId = 61

static

used for generic TTypedDataTable functions

ColumnTaxInputGlCcCode

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

ColumnTaxInputGlCcCodeId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnTaxInputGlCcCodeId = 62

static

used for generic TTypedDataTable functions

ColumnTaxOutputGlAccountCode

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

ColumnTaxOutputGlAccountCodeId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnTaxOutputGlAccountCodeId = 63

static

used for generic TTypedDataTable functions

ColumnTaxTypeCode

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

ColumnTaxTypeCodeId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnTaxTypeCodeId = 13

static

used for generic TTypedDataTable functions

ColumnTermsOfPaymentCode

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

ColumnTermsOfPaymentCodeId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnTermsOfPaymentCodeId = 64

static

used for generic TTypedDataTable functions

ColumnTransactionAccountFlag

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

Used to get a yes no response from the user.

ColumnTransactionAccountFlagId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnTransactionAccountFlagId = 19

static

used for generic TTypedDataTable functions

ColumnYearEndFlag

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

Used to get a yes no response from the user.

ColumnYearEndFlagId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnYearEndFlagId = 20

static

used for generic TTypedDataTable functions

ColumnYearEndProcessStatus

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

How far along is the year end process.

ColumnYearEndProcessStatusId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.ColumnYearEndProcessStatusId = 70

static

used for generic TTypedDataTable functions

DontThrowAwayAfterSubmitChanges

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

inherited

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

TableId

readonly short Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.TableId = 111

static

TableId for Ict.Common.Data generic functions.

TableInfo

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

staticprotectedinherited

stores information about typed tables

ThrowAwayAfterSubmitChanges

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

inherited

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

Property Documentation

Count

int Ict.Common.Data.TTypedDataTable.Count

getinherited

the number of rows in the current table

TableDBLabel

override string Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.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]

ALedgerRow Ict.Petra.Shared.MFinance.Account.Data.ALedgerTable.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/Account.Tables-generated.cs