AR_BASE_DIST_AMTS_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 |
|---|---|---|---|---|
| GT_ID | NUMBER | 18 | Oracle internal use only | |
| GP_LEVEL | VARCHAR2 | 30 | Oracle internal use only | |
| REF_CUSTOMER_TRX_ID | NUMBER | 18 | Oracle internal use only | |
| REF_CUSTOMER_TRX_LINE_ID | NUMBER | 18 | Oracle internal use only | |
| BASE_DIST_AMT | NUMBER | Oracle internal use only | ||
| BASE_DIST_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_DIST_CHRG_AMT | NUMBER | Oracle internal use only | ||
| BASE_DIST_CHRG_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_DIST_FRT_AMT | NUMBER | Oracle internal use only | ||
| BASE_DIST_FRT_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_DIST_TAX_AMT | NUMBER | Oracle internal use only | ||
| BASE_DIST_TAX_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_DIST_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_DIST_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_DIST_CHRG_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_DIST_CHRG_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_DIST_FRT_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_DIST_FRT_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_DIST_TAX_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_DIST_TAX_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_DIST_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_DIST_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_DIST_CHRG_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_DIST_CHRG_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_DIST_FRT_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_DIST_FRT_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_DIST_TAX_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_DIST_TAX_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| SET_OF_BOOKS_ID | NUMBER | 18 | Oracle internal use only | |
| SOB_TYPE | VARCHAR2 | 2 | Oracle internal use only | |
| SOURCE_TABLE | VARCHAR2 | 30 | Oracle internal use only | |
| SOURCE_ID | NUMBER | 18 | Oracle internal use only | |
| SOURCE_TYPE | VARCHAR2 | 30 | Oracle internal use only |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| AR_BASE_DIST_AMTS_GT_N1 | Non Unique | GT_ID, GP_LEVEL, REF_CUSTOMER_TRX_LINE_ID, REF_CUSTOMER_TRX_ID, SET_OF_BOOKS_ID, SOB_TYPE |
| AR_BASE_DIST_AMTS_GT_U1 | Unique | GT_ID, GP_LEVEL, REF_CUSTOMER_TRX_LINE_ID, REF_CUSTOMER_TRX_ID, SET_OF_BOOKS_ID, SOURCE_TABLE, SOURCE_TYPE |