AR_CLEARING_GT

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

Details

• Schema: FUSION

• Object owner: AR

• Object type: TABLE

Columns

Name

CASH_RECEIPT_IDNUMBER18Oracle internal use only CASH_RECEIPT_HISTORY_ID_OLDNUMBER18Oracle internal use only CASH_RECEIPT_HISTORY_ID_NEWNUMBER18Oracle internal use only EXCHANGE_DATE_OLDDATEOracle internal use only EXCHANGE_DATE_NEWDATEOracle internal use only EXCHANGE_RATE_OLDNUMBEROracle internal use only EXCHANGE_RATE_NEWNUMBEROracle internal use only EXCHANGE_RATE_TYPE_OLDVARCHAR230Oracle internal use only EXCHANGE_RATE_TYPE_NEWVARCHAR230Oracle internal use only HISTORY_STATUS_OLDVARCHAR230Oracle internal use only TRX_DATEDATEOracle internal use only GL_DATEDATEOracle internal use only CRH_AMOUNT_OLDNUMBEROracle internal use only CRH_AMOUNT_NEWNUMBEROracle internal use only CRH_ACCTD_AMOUNT_OLDNUMBEROracle internal use only CRH_ACCTD_AMOUNT_NEWNUMBEROracle internal use only RECEIPT_ACCTD_AMOUNT_OLDNUMBEROracle internal use only RECEIPT_ACCTD_AMOUNT_NEWNUMBEROracle internal use only PROCESS_STATUSVARCHAR230Oracle internal use only ERROR_MESSAGEVARCHAR22000Oracle internal use only ORG_IDNUMBER18YesIndicates the identifier of the business unit associated to the row. RECEIPT_CURRENCYVARCHAR215Oracle internal use only BANK_CURRENCYVARCHAR215Oracle internal use only RECEIPT_AMOUNTNUMBEROracle internal use only BANK_EXCHANGE_RATENUMBEROracle internal use only BANK_EXCHANGE_DATEDATEOracle internal use only BANK_EXCHANGE_TYPEVARCHAR230Oracle internal use only PAY_FROM_CUSTOMERNUMBER18Oracle internal use only CUSTOMER_SITE_USE_IDNUMBER18Oracle internal use only FACTOR_FLAGVARCHAR21Oracle internal use only FACTOR_DISCOUNT_AMOUNT_OLDNUMBEROracle internal use only FACTOR_DISCOUNT_AMOUNT_NEWNUMBEROracle internal use only ACCTD_FACTOR_DISC_AMOUNT_OLDNUMBEROracle internal use only ACCTD_FACTOR_DISC_AMOUNT_NEWNUMBEROracle internal use only CRH_BATCH_ID_OLDNUMBER18Oracle internal use only PRV_STAT_CASH_RECEIPT_HIST_IDNUMBER18Oracle internal use only RECEIPT_METHOD_IDNUMBER18Oracle internal use only BANK_CHARGE_ACCOUNT_CCIDNUMBER18Oracle internal use only REMIT_BANK_ACCT_USE_IDNUMBER18Oracle internal use only CLEARED_AMOUNTNUMBEROracle internal use only ACTUAL_VALUE_DATEDATEOracle internal use only CODE_COMBINATION_IDNUMBER18Oracle internal use only SET_OF_BOOKS_IDNUMBER18Oracle internal use only

Indexes

Index	Uniqueness	Columns
AR_CLEARING_GT_U1	Unique	CASH_RECEIPT_HISTORY_ID_OLD
AR_CLEARING_GT_U2	Unique	CASH_RECEIPT_HISTORY_ID_NEW
AR_CLEARING_GT_U3	Unique	CASH_RECEIPT_ID