CreateAuDSStandardTableTaskFactory

The following code retrieves a reference to the service that provides access to the objects that create the standard tables.

'Note: IDEA 10.0 or higher is required.

Dim stdTableTaskFactory as Object

Set stdTableTaskFactory = SmartContext.GetServiceById("CreateAuDSStandardTableTaskFactory")

If the service is not available, GetServiceById returns nothing. The service is currently only available in the execution context of a data preparation task. The task factory service implements the CreateAuDSStandardTableTaskFactory interface with the following members:

1. Function NewAuDSStandardTablesTask() as Object

2. The method returns an object that can be used to create all AuDS standard tables and implements the CreateAuDSStandardTablesTask interface with the following members:

3. 1. Property GeneralLedgerDetailsSourceDatabaseName as String

      This read/write property of type string gets/sets the absolute or project-relative path to the source database of the result 'AuDS_Fibu-Journal' (aka GeneralLedgerDetails).

   2. Property ChartOfAccountsSourceDatabaseName as String

      This read-write property of type string gets/sets the absolute or project-relative path to the source database of the result 'AuDS_Sachkontenstamm' (aka ChartOfAccounts).

   3. Property SupplierMasterSourceDatabaseName as String

      This read/write property of type string gets/sets the absolute or project-relative path to the source database of the result 'AuDS_Kreditorenstamm' (aka SupplierMaster).

   4. Property CustomerMasterSourceDatabaseName as String

      This read/write property of type string gets/sets the absolute or project-relative path to the source database of the result 'AuDS_Debitorenstamm' (aka CustomerMaster).

   5. Property AuditPeriodStart as Date

      This read/write property of type date gets/sets the start date of the audit period.

   6. Property AuditPeriodEnd as Date

      This read/write property of type date gets/sets the end date of the audit period.

   7. Sub PerformTask()

      This method resets the result properties (see GeneralLedgerDetailsResult, ChartOfAccountsResult etc. below), executes the task and updates the result properties. If the source database of a standard table was not specified, if it is not valid or if it does not include all mandatory columns, PerformTask will not attempt to produce the standard table. Its result object will be nothing.

      If the set of valid data sources is empty, PerformTask does nothing (except resetting the result properties).

      The produced results will be registered with the list of result databases in the context.

   8. Property GeneralLedgerDetailsResult as Object

      This read-only property returns a reference (nothing or an ITestResultFile) to an object containing the name, ID, record count, tagging-related data etc. of the result database 'AuDS_Fibu-Journal' (aka GeneralLedgerDetails).

      The property value is Nothing if the task was not executed or if a valid source database was not specified in GeneralLedgerDetailsSourceDatabaseName.

      The standard table alias is stored under the key "Alias" in the ExtraValues dictionary of the result object. The alias of the standard table is 'GeneralLedgerDetails'.

   9. Property ChartOfAccountsResult as Object

      This read-only property returns a reference (nothing or an ITestResultFile) to an object containing the name, ID, record count, tagging-related data etc. of the result database 'AuDS_Sachkontenstamm' (aka ChartOfAccounts).

      The property value is Nothing if the task was not executed or if a valid source database was not specified in ChartOfAccountsSourceDatabaseName.

      The standard table alias is stored under the key "Alias" in the ExtraValues dictionary of the result object. The alias of the standard table is 'ChartOfAccounts'.

   10. Property SupplierMasterResult as Object

       This read-only property returns a reference (nothing or an ITestResultFile) to an object containing the name, ID, record count, tagging-related data etc. of the result database 'AuDS_Kreditorenstamm' (aka SupplierMaster).

       The property value is Nothing if the task was not executed or if a valid source database was not specified in SupplierMasterSourceDatabaseName.

       The standard table alias is stored under the key "Alias" in the ExtraValues dictionary of the result object. The alias of the standard table is 'SupplierMaster'.

   11. Property CustomerMasterResult as Object

       This read-only property returns a reference (nothing or an ITestResultFile) to an object containing the name, ID, record count, tagging-related data etc. of the result database 'AuDS_Debitorenstamm' (aka CustomerMaster).

       The property value is Nothing if the task was not executed or if a valid source database was not specified in CustomerMasterSourceDatabaseName.

       The standard table alias is stored under the key "Alias" in the ExtraValues dictionary of the result object. The alias of the standard table is 'CustomerMaster'.