This table contains key flex field segments information for GL.
Module:
CODE_COMBINATION_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
CODE_COMBINATION_ID | NUMBER | 38 | 0 | True | Account key flexfield combination identifier. | ||
SOURCE_RECORD_ID | VARCHAR2 | 64 | Source record identifier. Value is same as the account key flexfield combination identifier. | ||||
CHART_OF_ACCOUNTS_ID | NUMBER | 38 | 0 | Chart of account identifier. | |||
ENABLED_FLAG | VARCHAR2 | 16 | Indicates that code combination is enabled. | ||||
CONCAT_SEGMENTS | VARCHAR2 | 999 | Concatenated segments. | ||||
GL_BALANCING_SEGMENT | VARCHAR2 | 32 | Balancing segment. | ||||
GL_BLNC_SGMNT_VALUESET_CODE | VARCHAR2 | 64 | Balancing segment value set code. | ||||
COST_CENTER_SEGMENT | VARCHAR2 | 32 | Cost center segment. | ||||
COST_CENTER_VALUESET_CODE | VARCHAR2 | 64 | Cost center value set code. | ||||
NATURAL_ACCOUNT_SEGMENT | VARCHAR2 | 32 | Natural account segment. | ||||
NTRL_ACNT_SGMNT_VALUESET_CODE | VARCHAR2 | 64 | Natural account value set code. | ||||
GL_SEGMENT1 | VARCHAR2 | 32 | Accounting segment 1. | ||||
GL_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 1 value set code. | ||||
GL_SEGMENT2 | VARCHAR2 | 32 | Accounting segment 2. | ||||
GL_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 2 value set code. | ||||
GL_SEGMENT3 | VARCHAR2 | 32 | Accounting segment 3. | ||||
GL_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 3 value set code. | ||||
GL_SEGMENT4 | VARCHAR2 | 32 | Accounting segment 4. | ||||
GL_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 4 value set code. | ||||
GL_SEGMENT5 | VARCHAR2 | 32 | Accounting segment 5. | ||||
GL_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 5 value set code. | ||||
GL_SEGMENT6 | VARCHAR2 | 32 | Accounting segment 6. | ||||
GL_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 6 value set code. | ||||
GL_SEGMENT7 | VARCHAR2 | 32 | Accounting segment 7. | ||||
GL_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 7 value set code. | ||||
GL_SEGMENT8 | VARCHAR2 | 32 | Accounting segment 8. | ||||
GL_SEGMENT8_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 8 value set code. | ||||
GL_SEGMENT9 | VARCHAR2 | 32 | Accounting segment 9. | ||||
GL_SEGMENT9_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 9 value set code. | ||||
GL_SEGMENT10 | VARCHAR2 | 32 | Accounting segment 10. | ||||
GL_SEGMENT10_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 10 value set code. | ||||
GL_SEGMENT11 | VARCHAR2 | 32 | Accounting segment 11. | ||||
GL_SEGMENT11_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 11 value set code. | ||||
GL_SEGMENT12 | VARCHAR2 | 32 | Accounting segment 12. | ||||
GL_SEGMENT12_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 12 value set code. | ||||
GL_SEGMENT13 | VARCHAR2 | 32 | Accounting segment 13. | ||||
GL_SEGMENT13_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 13 value set code. | ||||
GL_SEGMENT14 | VARCHAR2 | 32 | Accounting segment 14. | ||||
GL_SEGMENT14_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 14 value set code. | ||||
GL_SEGMENT15 | VARCHAR2 | 32 | Accounting segment 15. | ||||
GL_SEGMENT15_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 15 value set code. | ||||
GL_SEGMENT16 | VARCHAR2 | 32 | Accounting segment 16. | ||||
GL_SEGMENT16_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 16 value set code. | ||||
GL_SEGMENT17 | VARCHAR2 | 32 | Accounting segment 17. | ||||
GL_SEGMENT17_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 17 value set code. | ||||
GL_SEGMENT18 | VARCHAR2 | 32 | Accounting segment 18. | ||||
GL_SEGMENT18_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 18 value set code. | ||||
GL_SEGMENT19 | VARCHAR2 | 32 | Accounting segment 19. | ||||
GL_SEGMENT19_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 19 value set code. | ||||
GL_SEGMENT20 | VARCHAR2 | 32 | Accounting segment 20. | ||||
GL_SEGMENT20_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 20 value set code. | ||||
GL_SEGMENT21 | VARCHAR2 | 32 | Accounting segment 21. | ||||
GL_SEGMENT21_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 21 value set code. | ||||
GL_SEGMENT22 | VARCHAR2 | 32 | Accounting segment 22. | ||||
GL_SEGMENT22_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 22 value set code. | ||||
GL_SEGMENT23 | VARCHAR2 | 32 | Accounting segment 23. | ||||
GL_SEGMENT23_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 23 value set code. | ||||
GL_SEGMENT24 | VARCHAR2 | 32 | Accounting segment 24. | ||||
GL_SEGMENT24_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 24 value set code. | ||||
GL_SEGMENT25 | VARCHAR2 | 32 | Accounting segment 25. | ||||
GL_SEGMENT25_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 25 value set code. | ||||
GL_SEGMENT26 | VARCHAR2 | 32 | Accounting segment 26. | ||||
GL_SEGMENT26_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 26 value set code. | ||||
GL_SEGMENT27 | VARCHAR2 | 32 | Accounting segment 27. | ||||
GL_SEGMENT27_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 27 value set code. | ||||
GL_SEGMENT28 | VARCHAR2 | 32 | Accounting segment 28. | ||||
GL_SEGMENT28_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 28 value set code. | ||||
GL_SEGMENT29 | VARCHAR2 | 32 | Accounting segment 29. | ||||
GL_SEGMENT29_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 29 value set code. | ||||
GL_SEGMENT30 | VARCHAR2 | 32 | Accounting segment 30. | ||||
GL_SEGMENT30_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 30 value set code. | ||||
ACCOUNT_TYPE | VARCHAR2 | 16 | combination type (Asset, Liability, etc). |