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") |