18.3 Custom Attributes

Following are the number of custom attributes for OOB tables supported in the current release.

Table 18-10 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- 10, VARCHAR - 50, DATE - 8 , CUSTOM DIMENSIONAL ATTRIBUTES - 15
ACCOUNT NUMBER- 10, VARCHAR- 40, DATE - 8
CHANNEL NUMBER – 20, VARCHAR – 20, DATE - 5
LOCATION NUMBER – 20, VARCHAR – 20, DATE - 5
RECONCILIATION DIFFERENCE SUMMARY CUSTOM DIMENSIONAL ATTRIBUTES - 15
GL ADJUSTMENT ENTRIES SUMMARY CUSTOM DIMENSIONAL ATTRIBUTES - 15
GL THRESHOLD BREACHES CUSTOM DIMENSIONAL ATTRIBUTES - 15
INTEGRATION MANAGEMENT LEDGER COA SEGMENTS COMBINATION CUSTOM DIMENSIONAL ATTRIBUTES - 15

Table 18-11 Number of Custom dimensions supported for each subject area

Subject Area No of Custom Dimensions No of Custom Attributes
Balance Computation Results 15 NUMBER – 5, VARCHAR – 5, DATE - 5
Reconciliation 15 NUMBER – 5, VARCHAR – 5, DATE - 5
Results 15 NUMBER – 5, VARCHAR – 5, DATE - 5

Note:

The following attributes are added by default in each custom dimension.
  • CODE
  • ID
  • LRI
  • SKEY
  • RECORD START DATE
  • RECORD END DATE