XLA_SUP_REF_COMBINATIONS
This table contains unique supporting reference combination.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
XLA_SUP_REF_COMBINATIONS_PK |
SUPP_REF_COMBINATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SUPP_REF_COMBINATION_ID | NUMBER | 18 | Yes | Identifier of the combination of additional transactional information on a subledger journal entry or line. | |
| SUP_REF_CODE1 | VARCHAR2 | 30 | Supporting Reference Short Name 1. | ||
| SUP_REF_CODE2 | VARCHAR2 | 30 | Supporting Reference Short Name 2. | ||
| SUP_REF_CODE3 | VARCHAR2 | 30 | Supporting Reference Short Name 3. | ||
| SUP_REF_CODE4 | VARCHAR2 | 30 | Supporting Reference Short Name 4. | ||
| SUP_REF_CODE5 | VARCHAR2 | 30 | Supporting Reference Short Name 5. | ||
| SUP_REF_CODE6 | VARCHAR2 | 30 | Supporting Reference Short Name 6. | ||
| SUP_REF_CODE7 | VARCHAR2 | 30 | Supporting Reference Short Name 7. | ||
| SUP_REF_CODE8 | VARCHAR2 | 30 | Supporting Reference Short Name 8. | ||
| SUP_REF_CODE9 | VARCHAR2 | 30 | Supporting Reference Short Name 9. | ||
| SUP_REF_CODE10 | VARCHAR2 | 30 | Supporting Reference Short Name 10. | ||
| SUP_REF_CODE11 | VARCHAR2 | 30 | Supporting Reference Short Name 11. | ||
| SUP_REF_CODE12 | VARCHAR2 | 30 | Supporting Reference Short Name 12. | ||
| SUP_REF_CODE13 | VARCHAR2 | 30 | Supporting Reference Short Name 13. | ||
| SUP_REF_CODE14 | VARCHAR2 | 30 | Supporting Reference Short Name 14. | ||
| SUP_REF_CODE15 | VARCHAR2 | 30 | Supporting Reference Short Name 15. | ||
| SUP_REF_CODE16 | VARCHAR2 | 30 | Supporting Reference Short Name 16. | ||
| SUP_REF_CODE17 | VARCHAR2 | 30 | Supporting Reference Short Name 17. | ||
| SUP_REF_CODE18 | VARCHAR2 | 30 | Supporting Reference Short Name 18. | ||
| SUP_REF_CODE19 | VARCHAR2 | 30 | Supporting Reference Short Name 19. | ||
| SUP_REF_CODE20 | VARCHAR2 | 30 | Supporting Reference Short Name 20. | ||
| SUP_REF_CODE21 | VARCHAR2 | 30 | Supporting Reference Short Name 21. | ||
| SUP_REF_CODE22 | VARCHAR2 | 30 | Supporting Reference Short Name 22. | ||
| SUP_REF_CODE23 | VARCHAR2 | 30 | Supporting Reference Short Name 23. | ||
| SUP_REF_CODE24 | VARCHAR2 | 30 | Supporting Reference Short Name 24. | ||
| SUP_REF_CODE25 | VARCHAR2 | 30 | Supporting Reference Short Name 25. | ||
| SUP_REF_CODE26 | VARCHAR2 | 30 | Supporting Reference Short Name 26. | ||
| SUP_REF_CODE27 | VARCHAR2 | 30 | Supporting Reference Short Name 27. | ||
| SUP_REF_CODE28 | VARCHAR2 | 30 | Supporting Reference Short Name 28. | ||
| SUP_REF_CODE29 | VARCHAR2 | 30 | Supporting Reference Short Name 29. | ||
| SUP_REF_CODE30 | VARCHAR2 | 30 | Supporting Reference Short Name 30 | ||
| SUP_REF_CODE31 | VARCHAR2 | 30 | Supporting Reference Short Name 31. | ||
| SUP_REF_CODE32 | VARCHAR2 | 30 | Supporting Reference Short Name 32. | ||
| SUP_REF_CODE33 | VARCHAR2 | 30 | Supporting Reference Short Name 33. | ||
| SUP_REF_CODE34 | VARCHAR2 | 30 | Supporting Reference Short Name 34. | ||
| SUP_REF_CODE35 | VARCHAR2 | 30 | Supporting Reference Short Name 35. | ||
| SUP_REF_CODE36 | VARCHAR2 | 30 | Supporting Reference Short Name 36. | ||
| SUP_REF_CODE37 | VARCHAR2 | 30 | Supporting Reference Short Name 37. | ||
| SUP_REF_CODE38 | VARCHAR2 | 30 | Supporting Reference Short Name 38. | ||
| SUP_REF_CODE39 | VARCHAR2 | 30 | Supporting Reference Short Name 39. | ||
| SUP_REF_CODE40 | VARCHAR2 | 30 | Supporting Reference Short Name 40. | ||
| SUP_REF_CODE41 | VARCHAR2 | 30 | Supporting Reference Short Name 41. | ||
| SUP_REF_CODE42 | VARCHAR2 | 30 | Supporting Reference Short Name 42. | ||
| SUP_REF_CODE43 | VARCHAR2 | 30 | Supporting Reference Short Name 43. | ||
| SUP_REF_CODE44 | VARCHAR2 | 30 | Supporting Reference Short Name 44. | ||
| SUP_REF_CODE45 | VARCHAR2 | 30 | Supporting Reference Short Name 45. | ||
| SUP_REF_CODE46 | VARCHAR2 | 30 | Supporting Reference Short Name 46. | ||
| SUP_REF_CODE47 | VARCHAR2 | 30 | Supporting Reference Short Name 47. | ||
| SUP_REF_CODE48 | VARCHAR2 | 30 | Supporting Reference Short Name 48. | ||
| SUP_REF_CODE49 | VARCHAR2 | 30 | Supporting Reference Short Name 49. | ||
| SUP_REF_CODE50 | VARCHAR2 | 30 | Supporting Reference Short Name 50. | ||
| SUP_REF_CODE51 | VARCHAR2 | 30 | Supporting Reference Short Name 51. | ||
| SUP_REF_CODE52 | VARCHAR2 | 30 | Supporting Reference Short Name 52. | ||
| SUP_REF_CODE53 | VARCHAR2 | 30 | Supporting Reference Short Name 53. | ||
| SUP_REF_CODE54 | VARCHAR2 | 30 | Supporting Reference Short Name 54. | ||
| SUP_REF_CODE55 | VARCHAR2 | 30 | Supporting Reference Short Name 55. | ||
| SUP_REF_CODE56 | VARCHAR2 | 30 | Supporting Reference Short Name 56. | ||
| SUP_REF_CODE57 | VARCHAR2 | 30 | Supporting Reference Short Name 57. | ||
| SUP_REF_CODE58 | VARCHAR2 | 30 | Supporting Reference Short Name 58. | ||
| SUP_REF_CODE59 | VARCHAR2 | 30 | Supporting Reference Short Name 59. | ||
| SUP_REF_CODE60 | VARCHAR2 | 30 | Supporting Reference Short Name 60. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| XLA_SUP_REF_COMBINATIONS_U1 | Unique | Default | SUPP_REF_COMBINATION_ID |