RA_AR_AMOUNTS_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 | |
| BASE_REC_ROWID | VARCHAR2 | 30 | 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_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_FRT_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_FRT_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_TAX_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_TAX_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_CHRG_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_CHRG_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_FRT_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_FRT_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_TAX_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_TAX_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_CHRG_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_CHRG_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_FRT_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_FRT_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_TAX_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_TAX_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_CHRG_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_CHRG_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_FRT_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_FRT_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_TAX_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_TAX_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_CHRG_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_ED_CHRG_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_ED_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_ED_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_ED_FRT_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_ED_FRT_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_ED_TAX_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_ED_TAX_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_ED_CHRG_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_ED_CHRG_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_ED_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_ED_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_ED_FRT_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_ED_FRT_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_ED_TAX_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_ED_TAX_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_ED_CHRG_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_ED_CHRG_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_FRT_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_FRT_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_TAX_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_TAX_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_CHRG_PRO_AMT | NUMBER | Oracle internal use only | ||
| BASE_UNED_CHRG_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_UNED_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_UNED_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_UNED_FRT_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_UNED_FRT_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_UNED_TAX_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_UNED_TAX_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| ELMT_UNED_CHRG_PRO_AMT | NUMBER | Oracle internal use only | ||
| ELMT_UNED_CHRG_PRO_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_UNED_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_UNED_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_UNED_FRT_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_UNED_FRT_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_UNED_TAX_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_UNED_TAX_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only | ||
| BUC_UNED_CHRG_ALLOC_AMT | NUMBER | Oracle internal use only | ||
| BUC_UNED_CHRG_ALLOC_ACCTD_AMT | NUMBER | Oracle internal use only |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| RA_AR_AMOUNTS_GT_N1 | Non Unique | GT_ID, CHARTOROWID("BASE_REC_ROWID") |