19.9 OOTB Latest Balances Extract for Management Ledger As Of Effective Date

For the Management ledger, there will be an extract definition Sys ML Latest Balance Extract As Of Effective Date as an out-of-the-box extract. This seeded Data Extraction will provide the latest balances for a given Effective Date and Ledger.

Management Ledger latest balance data for a given Effective Date per ledger will be available with:

• all relevant segments
• audit attributes
• parent information for General Ledger & Business Unit
• Balance Update Start and End time

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 Latest Balance Extract As Of Effective Date 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
   • Balance Update Start Time
   • Balance Update End Time
5. Click Describe File.
6. In Specify Data file names, enter the file name. This is a mandatory field.
   For example: sys_ml_latest_bal_as_of_effective_date_%#LEDGER_ID%.csv

   Note:

   The file extension must be either .txt or .csv.
7. Select Column delimiter from the drop down list.
   For Example: Comma
8. Specify the Text qualifier.
   For Example: Double quotes can be used, prefixed, and suffixed with text.
9. Select the file format.
   For Example: Fixed Length or Delimited.
10. Select the Record delimiter.
    For Example: Unix
11. Toggle the Header button if you want a header to be displayed in the extracted file.
    This field is optional.

    Note:

    The extracted file will show Result, Dimension, Integration, and Staging tables. Currently, Processing layer tables are not supported.

    In case two physical entities contain the same logical name, the order of preference for the entity will be in the following order:

    • 1 - Result
    • 2 - Dimension
    • 3 - Integration
    • 4 - Staging
12. Toggle the Generate a control file button if you want to generate a control file. The control file provides verification/validation information for use with extracted data files.
    This field is optional.

    In the Specify control file name field, enter the file name. This is a mandatory field. The file extension must be either .txt or .csv.

    The parameters you entered for Specify Data file names are copied to the Control file properties. You can modify based on your requiements. By default, the name is added as < Specify Data file names >_control.csv/.txt . For more details on fields such as Select file format, Select Column delimiter, Select Record delimiter, and Specify Text qualifier, see the above step.

    To add the controls, click Add button.

    • Add the control name in the text box.
    • Select the aggregation type from the dropdown. The supported options are Count, Avg, Sum, Min, and Max.
    • Select the attribute from the drop-down. The Attribute field is disabled when the aggregation type is selected as Count.

    You can add multiple controls to the file by clicking on Add button.

    The Control file is available in the Archived Extract file.

    Note:

    The following are the behavior of the Control file in this release:

    • There is no validations performed while generating a control file.
    • Header will not be generated in case of control file during data extraction and you will not have an option to add the header.
13. Click Save.
    The Sys ML Latest Balance Extract As Of Effective Date definition is updated.
14. For this seeded connector, you must create a pipeline to execute. You must pass a value for LEDGER_ID during execution.

    Note:

    The attributes common across Management Ledger Period Balance And Movement, and Management Ledger COA Segment Combination COA Segments entities are exposed for extraction. You can select and de-select the common attributes across these entities.

    Note:

    Incremental data extraction is supported for Management Ledger Latest Balance As Of Effective Date Connector.