[Home] [Help] [Dependency Information]
Object Name: | AR_ARCHIVE_CONTROL_DETAIL# |
---|---|
Object Type: | VIEW |
Owner: | AR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ARCHIVE_ID | VARCHAR2 | (15) | Yes | |
PERIOD_NUMBER | NUMBER | |||
PERIOD_NAME | VARCHAR2 | (15) | ||
INVOICES_CNT | NUMBER | |||
CREDIT_MEMOS_CNT | NUMBER | |||
DEBIT_MEMOS_CNT | NUMBER | |||
CHARGEBACKS_CNT | NUMBER | |||
DEPOSITS_CNT | NUMBER | |||
ADJUSTMENTS_CNT | NUMBER | |||
CASH_RECEIPTS_CNT | NUMBER | |||
INVOICES_NO_REC_CNT | NUMBER | |||
CREDIT_MEMOS_NO_REC_CNT | NUMBER | |||
DEBIT_MEMOS_NO_REC_CNT | NUMBER | |||
CHARGEBACKS_NO_REC_CNT | NUMBER | |||
DEPOSITS_NO_REC_CNT | NUMBER | |||
GUARANTEES_CNT | NUMBER | |||
MISC_RECEIPTS_CNT | NUMBER | |||
INVOICES_TOTAL | NUMBER | |||
CREDIT_MEMOS_TOTAL | NUMBER | |||
DEBIT_MEMOS_TOTAL | NUMBER | |||
CHARGEBACKS_TOTAL | NUMBER | |||
DEPOSITS_TOTAL | NUMBER | |||
ADJUSTMENTS_TOTAL | NUMBER | |||
CASH_RECEIPTS_TOTAL | NUMBER | |||
DISCOUNTS_TOTAL | NUMBER | |||
EXCHANGE_GAIN_LOSS_TOTAL | NUMBER | |||
INVOICES_NO_REC_TOTAL | NUMBER | |||
CREDIT_MEMOS_NO_REC_TOTAL | NUMBER | |||
DEBIT_MEMOS_NO_REC_TOTAL | NUMBER | |||
CHARGEBACKS_NO_REC_TOTAL | NUMBER | |||
DEPOSITS_NO_REC_TOTAL | NUMBER | |||
GUARANTEES_TOTAL | NUMBER | |||
MISC_RECEIPTS_TOTAL | NUMBER |
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#;
|
|
|