AR_RECEIPTS_GT

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

Details

• Schema: FUSION

• Object owner: AR

• Object type: TABLE

Columns

Name

PAYMENT_SCHEDULE_IDNUMBER18Oracle internal use only. CUSTOMER_TRX_IDNUMBER18Oracle internal use only. CASH_RECEIPT_IDNUMBER18Oracle internal use only. PAYING_CUSTOMER_IDNUMBER18Oracle internal use only. PAYING_SITE_USE_IDNUMBER18Oracle internal use only. PAYMENT_TRXN_EXTENSION_IDNUMBER18Oracle internal use only. DUE_DATEDATEOracle internal use only. AMOUNT_DUE_REMAININGNUMBEROracle internal use only. CUSTOMER_BANK_ACCOUNT_IDNUMBER18Oracle internal use only. CUST_MIN_AMOUNTNUMBEROracle internal use only. RECEIPT_NUMBERVARCHAR230Oracle internal use only. PAYMENT_CHANNEL_CODEVARCHAR230Oracle internal use only. PAYMENT_INSTRUMENTVARCHAR230Oracle internal use only. AUTHORIZATION_IDNUMBEROracle internal use only. GT_IDNUMBER18Oracle internal use only.

Indexes

Index	Uniqueness	Columns
AR_RECEIPTS_GT_N1	Non Unique	GT_ID, CASH_RECEIPT_ID, RECEIPT_NUMBER
AR_RECEIPTS_GT_N2	Non Unique	PAYMENT_SCHEDULE_ID, PAYING_CUSTOMER_ID, PAYMENT_INSTRUMENT, PAYING_SITE_USE_ID, DUE_DATE, PAYMENT_TRXN_EXTENSION_ID