GL_INTERFACE_SUMMARY_GT
This table is used for internal processing only
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| JE_HEADER_ID | NUMBER | 18 | Oracle internal use only | |
| LEDGER_ID | NUMBER | 18 | Oracle internal use only | |
| CODE_COMBINATION_ID | NUMBER | 18 | Oracle internal use only | |
| AMOUNT_TYPE | NUMBER | Oracle internal use only | ||
| GROUPING_STRING | VARCHAR2 | 2000 | Grouping string value to be used with Summary Flag. | |
| JE_LINE_NUM | NUMBER | 18 | Oracle internal use only | |
| PERIOD_NAME | VARCHAR2 | 15 | Oracle internal use only | |
| EFFECTIVE_DATE | DATE | Oracle internal use only | ||
| ENTERED_DR | NUMBER | Oracle internal use only | ||
| ENTERED_CR | NUMBER | Oracle internal use only | ||
| ACCOUNTED_DR | NUMBER | Oracle internal use only | ||
| ACCOUNTED_CR | NUMBER | Oracle internal use only | ||
| STAT_AMOUNT | NUMBER | Oracle internal use only | ||
| DESCRIPTION | VARCHAR2 | 240 | Oracle internal use only | |
| JGZZ_RECON_REF | VARCHAR2 | 240 | Oracle internal use only. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CURRENCY_CODE | VARCHAR2 | 15 | Oracle internal use only. | |
| CURRENCY_CONVERSION_DATE | DATE | Currency conversion date at line level. | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Currency conversion type at line level. | |
| CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate at line level. | ||
| PARTITION_GROUP_CODE | VARCHAR2 | 15 | Oracle internal use only. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| GL_INTERFACE_SUMMARY_GT_U1 | Unique | JE_HEADER_ID, CODE_COMBINATION_ID, GROUPING_STRING, AMOUNT_TYPE |