This table requires activation of Advanced Collections functional area. Stores receivable application details for Advanced Collections.
Module: Advanced Collections
RECEIVABLE_APPLICATION_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| RECEIVABLE_APPLICATION_ID | NUMBER | 38 | 0 | True | Receivable application identifier. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. Source record identifier. | ||||
| LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal entity identifier. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID | |
| LEDGER_ID | NUMBER | 38 | 0 | Ledger identifier. | DW_LEDGER_D | LEDGER_ID | |
| ORG_ID | NUMBER | 38 | 0 | Business unit organization identifier. | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
| PAYMENT_SCHEDULE_ID | NUMBER | 38 | 0 | Payment schedule identifier. | |||
| APPLIED_PAYMENT_SCHEDULE_ID | NUMBER | 38 | 0 | Applied payment schedule identifier. | |||
| CASH_RECEIPT_ID | NUMBER | 38 | 0 | Cash receipt identifier. | |||
| RECEIPT_NUMBER | VARCHAR2 | 64 | Receipt number. | ||||
| RECEIPT_DATE | DATE | Receipt date. | |||||
| RECEIPT_TYPE | VARCHAR2 | 32 | Receipt type. | DW_AR_RECEIPT_TYPE_LKP_TL | AR_RECEIPT_TYPE_LKP_CODE | ||
| RECEIPT_STATUS | VARCHAR2 | 32 | Receipt status. | DW_AR_RECEIPT_STATUS_LKP_TL | RECEIPT_STATUS_CODE | ||
| RECEIPT_METHOD_ID | VARCHAR2 | 32 | Receipt method identifier. | DW_AR_RECEIPT_METHOD_LKP_TL | AR_RECEIPT_METHOD_LKP_CODE | ||
| APPLICATION_TYPE | VARCHAR2 | 32 | Application type. | DW_APPTYPE_CODE_VALUES_LKP_TL | CODE | ||
| APPLICATION_STATUS | VARCHAR2 | 32 | Application status. | DW_AR_APP_STATUS_LKP_TL | AR_APP_STATUS_CODE | ||
| RECEIPT_CUSTOMER_ID | NUMBER | 38 | 0 | Receipt customer party identifier. | DW_PARTY_D | PARTY_ID | |
| RECEIPT_CUSTOMER_ACCOUNT_ID | NUMBER | 38 | 0 | Receipt customer account identifier. | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID | |
| RECEIPT_CUSTOMER_SITE_USE_ID | NUMBER | 38 | 0 | Receipt customer site use identifier. | DW_CUSTOMER_SITE_USES_D | CUSTOMER_SITE_USE_ID | |
| RECEIPT_CUSTOMER_LOCATION_ID | NUMBER | 38 | 0 | Receipt customer location identifier. | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID | |
| RECEIPT_CUSTOMER_COLLECTOR_ID | NUMBER | 38 | 0 | Receipt collector identifier. | DW_AC_AR_COLLECTORS_D | COLLECTOR_ID | |
| RECEIPT_CUST_ACCOUNT_PROFILE_ID | NUMBER | 38 | 0 | Receipt customer profile identifier. | DW_AC_HZ_CUSTOMER_PROFILES_F_D | ||
| TRANSACTION_DATE | DATE | Transaction date associated with the application. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE | |||
| PAYMENT_DUE_DATE | DATE | Payment due date associated with the application. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE | |||
| PAYMENT_TERMS_ID | NUMBER | 38 | 0 | Payment terms identifier. | DW_AR_PAYMENT_TERMS_D | PAYMENT_TERM_ID | |
| CURRENCY_CODE_APPLIED_FROM | VARCHAR2 | 16 | Source transaction currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| CURRENCY_CODE_APPLIED_TO | VARCHAR2 | 16 | Applied transaction currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| LEDGER_CURRENCY_CODE | VARCHAR2 | 16 | Ledger currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| GLOBAL_CURRENCY_EXCH_RATE | NUMBER | Global currency exchange rate. | |||||
| APPLY_DATE | DATE | Application date. | |||||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
| CREATION_DATE_1 | DATE | Who column date in DATE format. | |||||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||||
| LAST_UPDATE_DATE_1 | DATE | Last update date in DATE format. | |||||
| FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Accounting calendar name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME | ||
| FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Accounting period type. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE | ||
| FISCAL_PERIOD_NAME | VARCHAR2 | 64 | Accounting period name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME | ||
| AMOUNT_APPLIED | NUMBER | Amount applied in transaction currency. | |||||
| ACCTD_AMOUNT_APPLIED_FROM | NUMBER | Applied amount from in ledger currency. | |||||
| ACCTD_AMOUNT_APPLIED_TO | NUMBER | Applied amount to in ledger currency. | |||||
| GLOBAL_AMOUNT_APPLIED_FROM | NUMBER | Applied amount from in global currency. | |||||
| GLOBAL_AMOUNT_APPLIED_TO | NUMBER | Applied amount to in global currency. |
Copyright © 2019, 2026, Oracle and/or its affiliates.