18.2.2 Custom Attributes for OOB Tables

To define a custom attribute in OOB table, complete the following steps:
  1. On the AFCS Home page, click the My Profile icon and select Administration.
  2. Click Report Configuration.
  3. Select the OOB table and click on the Edit icon.
  4. Select the attribute and click on the Edit icon in the Attribute mapping window.
  5. Select the Attribute name from the dropdown list and click Save.
  6. To delete a cusom attribute, select the attribute and click on Delete icon.

    Note:

    User cannot Edit or Delete the OOTB dimension, it will display NA flag in the Dimension Mapping window. The available and mapped flag for Custom Attributes are displayed in the Attribute Mapping window to show the availability of attributes.

    Note:

    Following are the number of custom attributes for subject area for OOB table supported in the current release.

    Table 18-11 Table Name and Number of Custom Attributes supported

    Presentation Entity Name No of Custom Attributes
    ORGANIZATION UNIT NUMBER – 55, VARCHAR – 110, DATE - 5
    GENERAL LEDGER ACCOUNT NUMBER – 55, VARCHAR – 110, DATE - 5
    PRODUCT NUMBER – 20, VARCHAR - 20, DATE - 5
    LEGAL ENTITY NUMBER – 20, VARCHAR - 20, DATE - 5
    PROJECT NUMBER – 20, VARCHAR - 20, DATE - 5
    BRANCH NUMBER – 20, VARCHAR - 20, DATE - 5
    BUSINESS UNIT NUMBER – 20, VARCHAR - 20, DATE - 5
    ACCOUNTING ENTRIES NUMBER- 30, VARCHAR - 50, DATE - 8 , CUSTOM DIMENSIONS - 15
    ACCOUNT NUMBER- 10, VARCHAR- 40, DATE - 8
    CHANNEL NUMBER – 20, VARCHAR – 20, DATE - 5
    LOCATION NUMBER – 20, VARCHAR – 20, DATE - 5
    LEDGER NUMBER – 20, VARCHAR – 20, DATE - 5
    INSTRUMENT CONTRACT NUMBER – 20, VARCHAR – 20, DATE - 5
    PARTY NUMBER – 20, VARCHAR – 20, DATE - 5
    DATA SOURCE NUMBER – 20, VARCHAR – 20, DATE - 5
    RECONCILIATION DIFFERENCE SUMMARY CUSTOM DIMENSIONS - 15*
    GL ADJUSTMENT ENTRIES SUMMARY CUSTOM DIMENSIONS - 15*
    GL THRESHOLD BREACHES CUSTOM DIMENSIONS - 15*
    INTEGRATION MANAGEMENT LEDGER COA SEGMENTS COMBINATION CUSTOM DIMENSIONS - 15*

    *The number of custom dimensions supported against all grains.