AR_AE_ALLOC_REC_GT

This is a temporary table which is used internally by Oracle.

Details

• Schema: FUSION

• Object owner: AR

• Object type: TABLE

Columns

Name

AE_IDNUMBER18Oracle internal use only AE_ACCOUNT_CLASSVARCHAR220Oracle internal use only AE_CUSTOMER_TRX_IDNUMBER18Oracle internal use only AE_CUSTOMER_TRX_LINE_IDNUMBER18Oracle internal use only AE_LINK_TO_CUST_TRX_LINE_IDNUMBER18Oracle internal use only AE_TAX_TYPEVARCHAR230Oracle internal use only AE_CODE_COMBINATION_IDNUMBER18Oracle internal use only AE_COLLECTED_TAX_CCIDNUMBER18Oracle internal use only AE_LINE_AMOUNTNUMBEROracle internal use only AE_AMOUNTNUMBEROracle internal use only AE_ACCTD_AMOUNTNUMBEROracle internal use only AE_TAX_IDNUMBEROracle internal use only AE_TAXABLE_AMOUNTNUMBEROracle internal use only AE_TAXABLE_ACCTD_AMOUNTNUMBEROracle internal use only AE_SUM_ALLOC_AMTNUMBEROracle internal use only AE_SUM_ALLOC_ACCTD_AMTNUMBEROracle internal use only AE_ADJ_CCIDNUMBER18Oracle internal use only AE_EDISC_CCIDNUMBER18Oracle internal use only AE_UNEDISC_CCIDNUMBER18Oracle internal use only AE_FINCHRG_CCIDNUMBER18Oracle internal use only AE_ADJ_NON_REC_TAX_CCIDNUMBER18Oracle internal use only AE_EDISC_NON_REC_TAX_CCIDNUMBER18Oracle internal use only AE_UNEDISC_NON_REC_TAX_CCIDNUMBER18Oracle internal use only AE_FINCHRG_NON_REC_TAX_CCIDNUMBER18Oracle internal use only AE_OVERRIDE_CCID1NUMBER18Oracle internal use only AE_OVERRIDE_CCID2NUMBER18Oracle internal use only AE_TAX_LINK_IDNUMBEROracle internal use only AE_TAX_LINK_ID_ED_ADJNUMBEROracle internal use only AE_TAX_LINK_ID_UNEDNUMBEROracle internal use only AE_TAX_LINK_ID_ACTNUMBEROracle internal use only AE_PRO_AMTNUMBEROracle internal use only AE_PRO_ACCTD_AMTNUMBEROracle internal use only AE_PRO_FRT_CHRG_AMTNUMBEROracle internal use only AE_PRO_FRT_CHRG_ACCTD_AMTNUMBEROracle internal use only AE_PRO_TAXABLE_AMTNUMBEROracle internal use only AE_PRO_TAXABLE_ACCTD_AMTNUMBEROracle internal use only AE_PRO_SPLIT_TAXABLE_AMTNUMBEROracle internal use only AE_PRO_SPLIT_TAXABLE_ACCTD_AMTNUMBEROracle internal use only AE_PRO_RECOV_TAXABLE_AMTNUMBEROracle internal use only AE_PRO_RECOV_TAXABLE_ACCTD_AMTNUMBEROracle internal use only AE_PRO_DEF_TAX_AMTNUMBEROracle internal use only AE_PRO_DEF_TAX_ACCTD_AMTNUMBEROracle internal use only AE_COUNTED_FLAGVARCHAR21Oracle internal use only AE_AUTOTAXVARCHAR21Oracle internal use only AE_NEG_INDNUMBEROracle internal use only AE_SUM_REV_AMTNUMBEROracle internal use only AE_SUM_REV_ACCTD_AMTNUMBEROracle internal use only AE_COUNTNUMBEROracle internal use only AE_TAX_LINE_COUNTNUMBEROracle internal use only AE_SUMMARIZE_FLAGVARCHAR21Oracle internal use only AE_LINE_TYPEVARCHAR230Oracle internal use only AE_LINE_TYPE_SECONDARYVARCHAR230Oracle internal use only AE_SOURCE_IDNUMBER18Oracle internal use only AE_SOURCE_TABLEVARCHAR210Oracle internal use only AE_ACCOUNTNUMBER18Oracle internal use only AE_ENTERED_DRNUMBEROracle internal use only AE_ENTERED_CRNUMBEROracle internal use only AE_ACCOUNTED_DRNUMBEROracle internal use only AE_ACCOUNTED_CRNUMBEROracle internal use only AE_SOURCE_ID_SECONDARYNUMBER18Oracle internal use only AE_SOURCE_TABLE_SECONDARYVARCHAR210Oracle internal use only AE_CURRENCY_CODEVARCHAR215Oracle internal use only AE_CURRENCY_CONVERSION_RATENUMBEROracle internal use only AE_CURRENCY_CONVERSION_TYPEVARCHAR230Oracle internal use only AE_CURRENCY_CONVERSION_DATEDATEOracle internal use only AE_THIRD_PARTY_IDNUMBER18Oracle internal use only AE_THIRD_PARTY_SUB_IDNUMBER18Oracle internal use only AE_TAX_GROUP_CODE_IDNUMBER18Oracle internal use only AE_TAX_CODE_IDNUMBER18Oracle internal use only AE_LOCATION_SEGMENT_IDNUMBER18Oracle internal use only AE_TAXABLE_ENTERED_DRNUMBEROracle internal use only AE_TAXABLE_ENTERED_CRNUMBEROracle internal use only AE_TAXABLE_ACCOUNTED_DRNUMBEROracle internal use only AE_TAXABLE_ACCOUNTED_CRNUMBEROracle internal use only AE_REVERSED_SOURCE_IDNUMBER18Oracle internal use only AE_INV_LINENUMBER18Oracle internal use only AE_AMOUNT_DUE_ORIGINALNUMBEROracle internal use only AE_ACCTD_AMOUNT_DUE_ORIGINALNUMBEROracle internal use only AE_AMOUNT_DUE_REMAININGNUMBEROracle internal use only AE_ACCTD_AMOUNT_DUE_REMAININGNUMBEROracle internal use only AE_CUST_TRX_LINE_GL_DIST_IDNUMBEROracle internal use only AE_REF_LINE_IDNUMBEROracle internal use only AE_PRO_CHRG_AMTNUMBEROracle internal use only AE_PRO_CHRG_ACCTD_AMTNUMBEROracle internal use only AE_SUM_ADJ_AMTNUMBEROracle internal use only AE_SUM_ADJ_ACCTD_AMTNUMBEROracle internal use only AE_CHRG_AMOUNT_REMAININGNUMBEROracle internal use only AE_CHRG_ACCTD_AMOUNT_REMAININGNUMBEROracle internal use only AE_SUM_CHRG_AMOUNT_REMNUMBEROracle internal use only AE_SUM_CHRG_ACCTD_AMOUNT_REMNUMBEROracle internal use only AE_CHRG_AMOUNTNUMBEROracle internal use only AE_CHRG_ACCTD_AMOUNTNUMBEROracle internal use only AE_SUM_ADJ_CHRG_AMTNUMBEROracle internal use only AE_SUM_ADJ_CHRG_ACCTD_AMTNUMBEROracle internal use only AE_ORIG_INSERTVARCHAR230Oracle internal use only AE_FROM_PRO_AMTNUMBEROracle internal use only AE_FROM_PRO_ACCTD_AMTNUMBEROracle internal use only AE_FROM_PRO_CHRG_AMTNUMBEROracle internal use only AE_FROM_PRO_CHRG_ACCTD_AMTNUMBEROracle internal use only AE_FROM_AMOUNT_DRNUMBEROracle internal use only AE_FROM_AMOUNT_CRNUMBEROracle internal use only AE_FROM_ACCTD_AMOUNT_DRNUMBEROracle internal use only AE_FROM_ACCTD_AMOUNT_CRNUMBEROracle internal use only AFF_CLASSVARCHAR230Oracle internal use only BUCKETVARCHAR230Oracle internal use only REF_DIST_CCIDNUMBEROracle internal use only REF_MF_DIST_FLAGVARCHAR215Oracle internal use only REF_ACCOUNT_CLASSVARCHAR230Oracle internal use only ACTIVITY_BUCKETVARCHAR230Oracle internal use only

Indexes

Index	Uniqueness	Columns
AR_AE_ALLOC_REC_GT_N1	Non Unique	AE_ID, AE_ACCOUNT_CLASS, AE_CUSTOMER_TRX_LINE_ID
AR_AE_ALLOC_REC_GT_N3	Non Unique	AE_ID, AE_ACCOUNT_CLASS, AE_LINK_TO_CUST_TRX_LINE_ID
AR_AE_ALLOC_REC_GT_N4	Non Unique	AE_ID, REF_ACCOUNT_CLASS, AE_TAX_LINK_ID
AR_AE_ALLOC_REC_GT_N2	Non Unique	AE_ID, AE_ACCOUNT_CLASS, AE_TAX_TYPE, AE_TAX_ID, AE_TAX_LINE_COUNT, AE_COUNTED_FLAG