# DW_AC_AR_RCV_APPLICATIONS_CF (Preview)

This table requires activation of Advanced Collections functional area. Stores receivable application details for Advanced Collections.

## Details

Module: Advanced Collections

## Key Columns

RECEIVABLE_APPLICATION_ID

## Columns

Columns
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.