1. User Guide
  2. Data Administration
  3. Data File Specification
  4. Loading External Data
  5. Data File Specification
  6. Creating the Data File

Creating the Data File

After the Data File Specification is defined, follow the below mentioned guidelines to prepare the Data Files:

  • Columns to be included in the Data File must be as per the Data File Specification.
  • Name of the Data File must be same as the Data File Specification with a prefix of “input_yyyymmdd” where yyyymmdd is the Date (As of Date) for which the Data File is prepared. For example:
    • Data File Specification Name is “Asset.dat”
    • The As of Date is 06-July-2022
    • Data File Name must be “input_20220706_asset.dat”
  • Unique Data Validations:
    • Instrument Data Files: Account Numbers must be unique across the data files for a single As of Date.
    • Management Ledger Data Files: The combination of KPDs and Simple Dimensions must be unique across the data files for a single As of Date.
    • Transaction Summary Data Files: The combination of Account Numbers and KPDs must be unique across the data files for a single As of Date.
  • Permitted Delimiters are comma (,) and pipeline (|).
  • Data Validations:
    • Number fields: only numbers and dot (.) are allowed.
    • Description fields: comma (,) pipeline (|), single quotes (‘’), and double quotes (“ “) are not supported.
    • Any nullable fields which are mapped in the Data File Specification definitions should not skipped in the Data File.
    • The column order in the Data File should be in sync with the order defined in the Data File Specification definition.
    • Field Enclosures: Only double quotes (“”) are considered as Field Enclosures.

See the following sample files for your reference:

For more information about the data required by the Profitability and Balance Sheet Management Cloud Services, see the Data Requirements available at the Doc ID: 2869409.1.