RA_AR_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 | Precision | Comments |
|---|---|---|---|---|
| ACCOUNT_CLASS | VARCHAR2 | 30 | Oracle internal use only | |
| ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ACCTD_AMT_CR | NUMBER | Oracle internal use only | ||
| ACCTD_AMT_DR | NUMBER | Oracle internal use only | ||
| ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ALLOC_AMT | NUMBER | Oracle internal use only | ||
| AMT | NUMBER | Oracle internal use only | ||
| AMT_CR | NUMBER | Oracle internal use only | ||
| AMT_DR | NUMBER | Oracle internal use only | ||
| BASE_CHRG_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_CHRG_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_CURRENCY | VARCHAR2 | 30 | Oracle internal use only | |
| BASE_DIST_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_DIST_AMT | NUMBER | Oracle internal use only | ||
| BASE_DIST_CHRG_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_DIST_CHRG_AMT | NUMBER | Oracle internal use only | ||
| BASE_DIST_FRT_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_DIST_FRT_AMT | NUMBER | Oracle internal use only | ||
| BASE_DIST_TAX_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_DIST_TAX_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_CHRG_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_CHRG_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_DIST_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_DIST_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_DIST_CHRG_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_DIST_CHRG_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_DIST_FRT_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_DIST_FRT_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_DIST_TAX_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_DIST_TAX_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_FRT_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_FRT_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_TAX_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_TAX_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_FRT_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_FRT_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_TAX_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_TAX_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_CHRG_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_CHRG_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_DIST_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_DIST_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_DIST_CHRG_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_DIST_CHRG_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_DIST_FRT_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_DIST_FRT_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_DIST_TAX_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_DIST_TAX_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_FRT_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_FRT_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_TAX_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_TAX_PRO_AMT | NUMBER | Oracle internal use only | ||
| ACTIVITY_BUCKET | VARCHAR2 | 30 | Oracle internal use only | |
| BUC_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_CHRG_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_CHRG_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_ED_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_ED_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_ED_CHRG_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_ED_CHRG_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_ED_FRT_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_ED_FRT_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_ED_TAX_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_ED_TAX_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_FRT_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_FRT_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_TAX_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_TAX_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_UNED_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_UNED_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_UNED_CHRG_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_UNED_CHRG_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_UNED_FRT_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_UNED_FRT_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_UNED_TAX_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_UNED_TAX_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| CCID | NUMBER | Oracle internal use only | ||
| CCID_SECONDARY | NUMBER | Oracle internal use only | ||
| CHRG_REM_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| CHRG_REM_AMT | NUMBER | Oracle internal use only | ||
| DET_ID | NUMBER | Oracle internal use only | ||
| DIST_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| DIST_AMT | NUMBER | Oracle internal use only | ||
| DIST_CHRG_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| DIST_CHRG_AMT | NUMBER | Oracle internal use only | ||
| DIST_ED_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| DIST_ED_AMT | NUMBER | Oracle internal use only | ||
| DIST_ED_CHRG_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| DIST_ED_CHRG_AMT | NUMBER | Oracle internal use only | ||
| DIST_ED_FRT_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| DIST_ED_FRT_AMT | NUMBER | Oracle internal use only | ||
| DIST_ED_TAX_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| DIST_ED_TAX_AMT | NUMBER | Oracle internal use only | ||
| DIST_FRT_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| DIST_FRT_AMT | NUMBER | Oracle internal use only | ||
| DIST_TAX_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| DIST_TAX_AMT | NUMBER | Oracle internal use only | ||
| DIST_UNED_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| DIST_UNED_AMT | NUMBER | Oracle internal use only | ||
| DIST_UNED_CHRG_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| DIST_UNED_CHRG_AMT | NUMBER | Oracle internal use only | ||
| DIST_UNED_FRT_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| DIST_UNED_FRT_AMT | NUMBER | Oracle internal use only | ||
| DIST_UNED_TAX_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| DIST_UNED_TAX_AMT | NUMBER | Oracle internal use only | ||
| DUE_ORIG_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| DUE_ORIG_AMT | NUMBER | Oracle internal use only | ||
| DUE_REM_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| DUE_REM_AMT | NUMBER | Oracle internal use only | ||
| ELMT_CHRG_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_CHRG_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_ED_CHRG_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_ED_CHRG_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_ED_FRT_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_ED_FRT_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_ED_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_ED_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_ED_TAX_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_ED_TAX_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_FRT_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_FRT_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_TAX_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_TAX_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_UNED_CHRG_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_UNED_CHRG_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_UNED_FRT_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_UNED_FRT_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_UNED_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_UNED_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_UNED_TAX_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_UNED_TAX_PRO_AMT | NUMBER | Oracle internal use only | ||
| FROM_ACCTD_AMT_CR | NUMBER | Oracle internal use only | ||
| FROM_ACCTD_AMT_DR | NUMBER | Oracle internal use only | ||
| FROM_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| FROM_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| FROM_CURRENCY | VARCHAR2 | 30 | Oracle internal use only | |
| FRT_ADJ_REM_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| FRT_ADJ_REM_AMT | NUMBER | Oracle internal use only | ||
| FRT_ORIG_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| FRT_ORIG_AMT | NUMBER | Oracle internal use only | ||
| FRT_REM_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| FRT_REM_AMT | NUMBER | Oracle internal use only | ||
| GP_LEVEL | VARCHAR2 | 30 | Oracle internal use only | |
| GROUP_ID | VARCHAR2 | 1000 | Oracle internal use only | |
| GT_ID | NUMBER | 18 | Oracle internal use only | |
| LINE_ID | NUMBER | Oracle internal use only | ||
| LINE_TYPE | VARCHAR2 | 30 | Oracle internal use only | |
| REF_CUSTOMER_TRX_ID | NUMBER | Oracle internal use only | ||
| REF_CUSTOMER_TRX_LINE_ID | NUMBER | Oracle internal use only | ||
| REF_CUST_TRX_LINE_GL_DIST_ID | NUMBER | Oracle internal use only | ||
| REF_DET_ID | NUMBER | Oracle internal use only | ||
| REF_LINE_ID | NUMBER | Oracle internal use only | ||
| SET_OF_BOOKS_ID | NUMBER | Oracle internal use only | ||
| SE_GT_ID | VARCHAR2 | 30 | Oracle internal use only | |
| SOB_TYPE | VARCHAR2 | 2 | Oracle internal use only | |
| SOURCE_DATA_KEY1 | VARCHAR2 | 150 | Oracle internal use only | |
| SOURCE_DATA_KEY2 | VARCHAR2 | 150 | Oracle internal use only | |
| SOURCE_DATA_KEY3 | VARCHAR2 | 150 | Oracle internal use only | |
| SOURCE_DATA_KEY4 | VARCHAR2 | 150 | Oracle internal use only | |
| SOURCE_DATA_KEY5 | VARCHAR2 | 150 | Oracle internal use only | |
| SOURCE_ID | NUMBER | Oracle internal use only | ||
| SOURCE_TABLE | VARCHAR2 | 30 | Oracle internal use only | |
| SOURCE_TYPE | VARCHAR2 | 30 | Oracle internal use only | |
| SUM_GP_LINE_CHRG_REM_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| SUM_GP_LINE_CHRG_REM_AMT | NUMBER | Oracle internal use only | ||
| SUM_GP_LINE_FRT_ORIG_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| SUM_GP_LINE_FRT_ORIG_AMT | NUMBER | Oracle internal use only | ||
| SUM_GP_LINE_FRT_REM_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| SUM_GP_LINE_FRT_REM_AMT | NUMBER | Oracle internal use only | ||
| SUM_GP_LINE_ORIG_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| SUM_GP_LINE_ORIG_AMT | NUMBER | Oracle internal use only | ||
| SUM_GP_LINE_REM_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| SUM_GP_LINE_REM_AMT | NUMBER | Oracle internal use only | ||
| SUM_GP_LINE_TAX_ORIG_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| SUM_GP_LINE_TAX_ORIG_AMT | NUMBER | Oracle internal use only | ||
| SUM_GP_LINE_TAX_REM_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| SUM_GP_LINE_TAX_REM_AMT | NUMBER | Oracle internal use only | ||
| SUM_LINE_CHRG_REM_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| SUM_LINE_CHRG_REM_AMT | NUMBER | Oracle internal use only | ||
| SUM_LINE_FRT_ORIG_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| SUM_LINE_FRT_ORIG_AMT | NUMBER | Oracle internal use only | ||
| SUM_LINE_FRT_REM_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| SUM_LINE_FRT_REM_AMT | NUMBER | Oracle internal use only | ||
| SUM_LINE_ORIG_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| SUM_LINE_ORIG_AMT | NUMBER | Oracle internal use only | ||
| SUM_LINE_REM_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| SUM_LINE_REM_AMT | NUMBER | Oracle internal use only | ||
| SUM_LINE_TAX_ORIG_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| SUM_LINE_TAX_ORIG_AMT | NUMBER | Oracle internal use only | ||
| SUM_LINE_TAX_REM_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| SUM_LINE_TAX_REM_AMT | NUMBER | Oracle internal use only | ||
| TAX_INC_FLAG | VARCHAR2 | 1 | Oracle internal use only | |
| TAX_LINK_ID | NUMBER | Oracle internal use only | ||
| TAX_ORIG_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| TAX_ORIG_AMT | NUMBER | Oracle internal use only | ||
| TAX_REM_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| TAX_REM_AMT | NUMBER | Oracle internal use only | ||
| TL_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| TL_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| TL_CHRG_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| TL_CHRG_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| TL_ED_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| TL_ED_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| TL_ED_CHRG_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| TL_ED_CHRG_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| TL_ED_FRT_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| TL_ED_FRT_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| TL_ED_TAX_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| TL_ED_TAX_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| TL_FRT_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| TL_FRT_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| TL_TAX_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| TL_TAX_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| TL_UNED_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| TL_UNED_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| TL_UNED_CHRG_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| TL_UNED_CHRG_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| TL_UNED_FRT_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| TL_UNED_FRT_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| TL_UNED_TAX_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| TL_UNED_TAX_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| TO_CURRENCY | VARCHAR2 | 30 | Oracle internal use only | |
| REF_MF_DIST_FLAG | VARCHAR2 | 15 | Oracle internal use only | |
| CHRG_ORIG_AMT | NUMBER | Oracle internal use only | ||
| CHRG_ORIG_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| CHRG_ADJ_REM_AMT | NUMBER | Oracle internal use only | ||
| CHRG_ADJ_REM_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| SUM_LINE_CHRG_ORIG_AMT | NUMBER | Oracle internal use only | ||
| SUM_LINE_CHRG_ORIG_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| SUM_GP_LINE_CHRG_ORIG_AMT | NUMBER | Oracle internal use only | ||
| SUM_GP_LINE_CHRG_ORIG_ACCTD_AM | NUMBER | Oracle internal use only | ||
| INT_LINE_AMOUNT | NUMBER | Oracle internal use only | ||
| INT_TAX_AMOUNT | NUMBER | Oracle internal use only | ||
| INT_ED_LINE_AMOUNT | NUMBER | Oracle internal use only | ||
| INT_ED_TAX_AMOUNT | NUMBER | Oracle internal use only | ||
| INT_UNED_LINE_AMOUNT | NUMBER | Oracle internal use only | ||
| INT_UNED_TAX_AMOUNT | NUMBER | Oracle internal use only | ||
| SUM_INT_LINE_AMOUNT | NUMBER | Oracle internal use only | ||
| SUM_INT_TAX_AMOUNT | NUMBER | Oracle internal use only | ||
| SUM_INT_ED_LINE_AMOUNT | NUMBER | Oracle internal use only | ||
| SUM_INT_ED_TAX_AMOUNT | NUMBER | Oracle internal use only | ||
| SUM_INT_UNED_LINE_AMOUNT | NUMBER | Oracle internal use only | ||
| SUM_INT_UNED_TAX_AMOUNT | NUMBER | Oracle internal use only | ||
| TAX_CODE_ID | NUMBER | 18 | Tax rate code identifier. | |
| LOCATION_SEGMENT_ID | NUMBER | 18 | Location segment identifier. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| RA_AR_N1 | Non Unique | GT_ID, REF_CUSTOMER_TRX_ID, GP_LEVEL, SOURCE_DATA_KEY1, SOURCE_DATA_KEY2, SOURCE_DATA_KEY3, SOURCE_DATA_KEY4, SOURCE_DATA_KEY5, REF_CUSTOMER_TRX_LINE_ID, REF_CUST_TRX_LINE_GL_DIST_ID |
| RA_AR_N2 | Non Unique | GT_ID, REF_CUSTOMER_TRX_ID, GP_LEVEL, REF_CUSTOMER_TRX_LINE_ID, REF_CUST_TRX_LINE_GL_DIST_ID |