AR_REVENUE_ASSIGNMENTS_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| SESSION_ID | NUMBER | Yes | Oracle internal use only. | |
| CUSTOMER_TRX_LINE_ID | NUMBER | Yes | Oracle internal use only. | |
| COMPLETE_FLAG | VARCHAR2 | 1 | Yes | Oracle internal use only. |
| ACCOUNT_CLASS | VARCHAR2 | 20 | Yes | Oracle internal use only. |
| LUMP_SUM_FLAG | VARCHAR2 | 1 | Oracle internal use only. | |
| RULE_TYPE | VARCHAR2 | 10 | Yes | Oracle internal use only. |
| PERIOD_NUMBER | NUMBER | Yes | Oracle internal use only. | |
| PERCENT | NUMBER | Oracle internal use only. | ||
| RULE_DATE | DATE | Oracle internal use only. | ||
| SET_OF_BOOKS_ID | NUMBER | Yes | Oracle internal use only. | |
| PERIOD_TYPE | VARCHAR2 | 30 | Oracle internal use only. | |
| MAX_REGULAR_PERIOD_LENGTH | NUMBER | Oracle internal use only. | ||
| PPRR_AMOUNT | NUMBER | Oracle internal use only. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| AR_REVENUE_ASSIGNMENTS_GT_N1 | Non Unique | CUSTOMER_TRX_LINE_ID |