AR_IREC_APPLY_CREDIT_GT

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

Details

• Schema: FUSION

• Object owner: AR

• Object type: TABLE

Columns

Name

CUSTOMER_IDNUMBER18Oracle internal use only CUSTOMER_SITE_USE_IDNUMBER18Oracle internal use only ACCOUNT_NUMBERVARCHAR230Oracle internal use only CUSTOMER_TRX_IDNUMBER18Oracle internal use only TRX_NUMBERVARCHAR230Oracle internal use only TRX_DATEDATEOracle internal use only TRX_CLASSVARCHAR220Oracle internal use only DUE_DATEDATEOracle internal use only PAYMENT_SCHEDULE_IDNUMBER18Oracle internal use only STATUSVARCHAR230Oracle internal use only PAYMENT_TERMSVARCHAR230Oracle internal use only NUMBER_OF_INSTALLMENTSNUMBEROracle internal use only TERMS_SEQUENCE_NUMBERNUMBEROracle internal use only LINE_AMOUNTNUMBEROracle internal use only TAX_AMOUNTNUMBEROracle internal use only FREIGHT_AMOUNTNUMBEROracle internal use only FINANCE_CHARGESNUMBEROracle internal use only CURRENCY_CODEVARCHAR215Oracle internal use only AMOUNT_DUE_ORIGINALNUMBEROracle internal use only AMOUNT_DUE_REMAININGNUMBEROracle internal use only PAYMENT_AMTNUMBEROracle internal use only SERVICE_CHARGENUMBEROracle internal use only DISCOUNT_AMOUNTNUMBEROracle internal use only RECEIPT_DATEDATEOracle internal use only RECEIPT_NUMBERNUMBEROracle internal use only PO_NUMBERVARCHAR250Oracle internal use only SO_NUMBERVARCHAR250Oracle internal use only PRINTING_OPTIONVARCHAR220Oracle internal use only ATTRIBUTE_CATEGORYVARCHAR230Descriptive Flexfield: structure definition of the user descriptive flexfield. ATTRIBUTE1VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE2VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE3VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE4VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE5VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE6VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE7VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE8VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE9VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE10VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE11VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE12VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE13VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE14VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE15VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. INTERFACE_HEADER_CONTEXTVARCHAR230Oracle internal use only INTERFACE_HEADER_ATTRIBUTE1VARCHAR230Oracle internal use only INTERFACE_HEADER_ATTRIBUTE2VARCHAR230Oracle internal use only INTERFACE_HEADER_ATTRIBUTE3VARCHAR230Oracle internal use only INTERFACE_HEADER_ATTRIBUTE4VARCHAR230Oracle internal use only INTERFACE_HEADER_ATTRIBUTE5VARCHAR230Oracle internal use only INTERFACE_HEADER_ATTRIBUTE6VARCHAR230Oracle internal use only INTERFACE_HEADER_ATTRIBUTE7VARCHAR230Oracle internal use only INTERFACE_HEADER_ATTRIBUTE8VARCHAR230Oracle internal use only INTERFACE_HEADER_ATTRIBUTE9VARCHAR230Oracle internal use only INTERFACE_HEADER_ATTRIBUTE10VARCHAR230Oracle internal use only INTERFACE_HEADER_ATTRIBUTE11VARCHAR230Oracle internal use only INTERFACE_HEADER_ATTRIBUTE12VARCHAR230Oracle internal use only INTERFACE_HEADER_ATTRIBUTE13VARCHAR230Oracle internal use only INTERFACE_HEADER_ATTRIBUTE14VARCHAR230Oracle internal use only INTERFACE_HEADER_ATTRIBUTE15VARCHAR230Oracle internal use only LAST_UPDATE_DATETIMESTAMPYesWho column: indicates the date and time of the last update of the row. LAST_UPDATED_BYVARCHAR264YesWho column: indicates the user who last updated the row. CREATION_DATETIMESTAMPYesWho column: indicates the date and time of the creation of the row. CREATED_BYVARCHAR264YesWho column: indicates the user who created the row. LAST_UPDATE_LOGINVARCHAR232Who column: indicates the session login associated to the user who last updated the row. APPLICATION_AMOUNTNUMBEROracle internal use only CASH_RECEIPT_IDNUMBER18Oracle internal use only PAY_FOR_CUSTOMER_IDNUMBER18Oracle internal use only PAY_FOR_CUSTOMER_SITE_IDNUMBER18Oracle internal use only