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