18.2 OOTB Extract for Management Ledger

For the Management ledger, there will be an extract definition Sys ML Balance Extract as an out-of-the-box extract.

To view or modify the extract definitions:

1. From the AFCS Home page, select Data Extraction.
   The Summary page is displayed with a list of data extraction definitions.
2. Select Sys ML Balance Extract by searching for it. Click to view details of this extract.

   Note:

   You cannot modify the Name, Description, Grain, and Entity.
3. User will have the option to apply a filter on Management Ledger tables and Hierarchy tables.

   Note:

   Note that selecting the Hierarchy parent will be available only for this out-of-the-box extract but not for other custom extracts.
4. Click Select Attributes. The following attributes are added in Computed section under Available Attributes.
   • Parent GL Account Code
   • Parent Business Unit Code
   • Parent Business Unit Description
   • Intercompany Identifier Description
5. Click Describe File.
6. Specify data file name, file format, column delimiter, record delimiter, text qualifier, and header requirement.
7. For this seeded connector, you must create a pipeline to execute.