22 Data Extraction

You can access data extraction definitions by accessing the AFCS User Interface. On the Home page, from the Left Hand Side menu, click Data Extraction. This displays basic details of the Extract definitions. AFCS supports user-configured extraction of data from Staging and Results entities via Connectors.

Note:

If the Extraction Entity contains the As Of Date column, the data will be filtered based on the PMF execution date. When no date is selected during PMF Execution, the data will be filtered based on the current date.

To extract all the active nodes, the default filter applied for the dimension extract is "Execution Date between Record Start Date and Record End Date" instead of "As of date".

As the PMF execution date will be picked up as the default date for the extraction, you are not expected to provide a filter on As of Date during connector creation.

Note:

In the AFCS Standard Edition, backward flow is not applicable and therefore Sys ML Latest Balances Extracts are not supported. For more information, see the About Accounting Foundation Cloud Service- Standard Edition.