[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AR_ARCHIVE_CONTROL_DETAIL |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.AR_ARCHIVE_CONTROL_DETAIL
|
| Subobject Name: | |
| Status: | VALID |
The AR_ARCHIVE_CONTROL_DETAIL table stores historical, statistical data that is created by running the Archive and Purge program. Oracle Receivables creates one record in this table for each General Ledger period that is archived during the archive process. This table stores the transaction type, record count, and amount and then groups the count and amount by transaction type. Receivables uses the information in this table to generate the Archive Summary report.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ARCHIVE_ID | VARCHAR2 | (15) | Yes | Identifier of the archive process |
| PERIOD_NUMBER | NUMBER | Period number | ||
| PERIOD_NAME | VARCHAR2 | (15) | Period name | |
| INVOICES_CNT | NUMBER | Number of invoices archived/purged | ||
| CREDIT_MEMOS_CNT | NUMBER | Number of credit memos archived/purged | ||
| DEBIT_MEMOS_CNT | NUMBER | Number of debit memos archived/purged | ||
| CHARGEBACKS_CNT | NUMBER | Number of chargebacks archived/purged | ||
| DEPOSITS_CNT | NUMBER | Number of deposits archived/purged | ||
| ADJUSTMENTS_CNT | NUMBER | Number of adjustments archived/purged | ||
| CASH_RECEIPTS_CNT | NUMBER | Number of cash receipts archived/purged | ||
| INVOICES_NO_REC_CNT | NUMBER | Number of invoices not open to receivables archived/purged | ||
| CREDIT_MEMOS_NO_REC_CNT | NUMBER | Number of credit memos not open to receivables archived/purged | ||
| DEBIT_MEMOS_NO_REC_CNT | NUMBER | Number of debit memos not open to receivables archived/purged | ||
| CHARGEBACKS_NO_REC_CNT | NUMBER | Number of chargebacks not open to receivables archived/purged | ||
| DEPOSITS_NO_REC_CNT | NUMBER | Number of deposits not open to receivables archived/purged | ||
| GUARANTEES_CNT | NUMBER | Number of guarantees archived/purged | ||
| MISC_RECEIPTS_CNT | NUMBER | Number of miscellaneous transactions archived/purged | ||
| INVOICES_TOTAL | NUMBER | Total functional amount of invoices | ||
| CREDIT_MEMOS_TOTAL | NUMBER | Total functional amount of credit memos | ||
| DEBIT_MEMOS_TOTAL | NUMBER | Total functional amount of debit memos | ||
| CHARGEBACKS_TOTAL | NUMBER | Total functional amount of chargebacks | ||
| DEPOSITS_TOTAL | NUMBER | Total functional amount of deposits | ||
| ADJUSTMENTS_TOTAL | NUMBER | Total functional amount of adjustments | ||
| CASH_RECEIPTS_TOTAL | NUMBER | Total functional amount of cash receipts | ||
| DISCOUNTS_TOTAL | NUMBER | Total functional amount of discounts taken | ||
| EXCHANGE_GAIN_LOSS_TOTAL | NUMBER | Total functional amount of exchange rate gain/loss | ||
| INVOICES_NO_REC_TOTAL | NUMBER | Total functional amount of invoices not open to receivables | ||
| CREDIT_MEMOS_NO_REC_TOTAL | NUMBER | Total functional amount of credit memos not open to receivables | ||
| DEBIT_MEMOS_NO_REC_TOTAL | NUMBER | Total functional amount of debit memos not open to receivables | ||
| CHARGEBACKS_NO_REC_TOTAL | NUMBER | Total functional amount of chargebacks not open to receivables | ||
| DEPOSITS_NO_REC_TOTAL | NUMBER | Total functional amount of deposits not open to receivables | ||
| GUARANTEES_TOTAL | NUMBER | Total functional amount of guarantees | ||
| MISC_RECEIPTS_TOTAL | NUMBER | Total functional amount of miscellaneous transactions |
Cut, paste (and edit) the following text to query this object:
SELECT ARCHIVE_ID
, PERIOD_NUMBER
, PERIOD_NAME
, INVOICES_CNT
, CREDIT_MEMOS_CNT
, DEBIT_MEMOS_CNT
, CHARGEBACKS_CNT
, DEPOSITS_CNT
, ADJUSTMENTS_CNT
, CASH_RECEIPTS_CNT
, INVOICES_NO_REC_CNT
, CREDIT_MEMOS_NO_REC_CNT
, DEBIT_MEMOS_NO_REC_CNT
, CHARGEBACKS_NO_REC_CNT
, DEPOSITS_NO_REC_CNT
, GUARANTEES_CNT
, MISC_RECEIPTS_CNT
, INVOICES_TOTAL
, CREDIT_MEMOS_TOTAL
, DEBIT_MEMOS_TOTAL
, CHARGEBACKS_TOTAL
, DEPOSITS_TOTAL
, ADJUSTMENTS_TOTAL
, CASH_RECEIPTS_TOTAL
, DISCOUNTS_TOTAL
, EXCHANGE_GAIN_LOSS_TOTAL
, INVOICES_NO_REC_TOTAL
, CREDIT_MEMOS_NO_REC_TOTAL
, DEBIT_MEMOS_NO_REC_TOTAL
, CHARGEBACKS_NO_REC_TOTAL
, DEPOSITS_NO_REC_TOTAL
, GUARANTEES_TOTAL
, MISC_RECEIPTS_TOTAL
FROM AR.AR_ARCHIVE_CONTROL_DETAIL;
AR.AR_ARCHIVE_CONTROL_DETAIL does not reference any database object
AR.AR_ARCHIVE_CONTROL_DETAIL is referenced by following:
AR
AR_ARCHIVE_CONTROL_DETAIL#
|
|
|
|