[Home] [Help] [Dependency Information]
Object Name: | AP_INVOICE_KEY_IND_ALL |
---|---|
Object Type: | TABLE |
Owner: | AP |
FND Design Data: | SQLAP.AP_INVOICE_KEY_IND_ALL |
Subobject Name: | |
Status: | VALID |
AP_INVOICE_KEY_IND stores compiled invoice information
for the Key Indicators Report. There is one row for
each period for which you report on invoice key
indicators. The information in this table is
denormalized for reporting purposes.
.
This table has no foreign keys.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AP_INVOICE_KEY_IND_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
PERIOD_NAME
ORG_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERIOD_NAME | VARCHAR2 | (15) | Yes | Period name |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
NUM_INVOICES | NUMBER | Number of invoices | ||
AMOUNT_INVOICES | NUMBER | Amount of invoices | ||
NUM_DISTRIBUTION_LINES | NUMBER | Number of distribution lines | ||
NUM_BATCHES | NUMBER | Number of invoice batches | ||
NUM_INVOICE_VARIANCES | NUMBER | Number of invoices where, at end of reporting period, invoice amount does not match invoice distribution | ||
AMOUNT_INVOICE_VARIANCES | NUMBER | Amount of invoices where, at end of reporting period, invoice amount does not match invoice distribution | ||
NUM_PAYMENT_SCHEDULES | NUMBER | Number of scheduled payments | ||
NUM_INVOICES_HELD | NUMBER | Number of invoices on invoice hold (not including matching hold) at end of reporting period | ||
AMOUNT_INVOICES_HELD | NUMBER | Amount of invoices on invoice hold (not including matching hold) at end of reporting period | ||
NUM_INVOICES_MATCHED | NUMBER | Number of invoices matched to purchase orders | ||
AMOUNT_INVOICES_MATCHED | NUMBER | Amount of invoices matched to purchase orders | ||
NUM_INVOICES_MATCH_HOLD | NUMBER | Number of invoices on matching hold at end of reporting period | ||
AMOUNT_INVOICES_MATCH_HOLD | NUMBER | Amount of invoices on matching hold at end of reporting period | ||
VALUE1 | NUMBER | Value for custom statistical tracking | ||
VALUE2 | NUMBER | Value for custom statistical tracking | ||
VALUE3 | NUMBER | Value for custom statistical tracking | ||
VALUE4 | NUMBER | Value for custom statistical tracking | ||
VALUE5 | NUMBER | Value for custom statistical tracking | ||
VALUE6 | NUMBER | Value for custom statistical tracking | ||
VALUE7 | NUMBER | Value for custom statistical tracking | ||
VALUE8 | NUMBER | Value for custom statistical tracking | ||
VALUE9 | NUMBER | Value for custom statistical tracking | ||
VALUE10 | NUMBER | Value for custom statistical tracking | ||
NUM_EXPENSE_REPORTS | NUMBER | Number of expense reports | ||
AMOUNT_EXPENSE_REPORTS | NUMBER | Amount of expense reports | ||
NUM_PREPAYMENTS | NUMBER | Number of prepayments | ||
AMOUNT_PREPAYMENTS | NUMBER | Amount of prepayments | ||
NUM_RECURRING_PAYMENTS | NUMBER | Number of recurring invoices | ||
AMOUNT_RECURRING_PAYMENTS | NUMBER | Amount of recurring invoices | ||
NUM_RECURRING_PAYMENTS_DEF | NUMBER | Number of recurring invoice definitions | ||
ORG_ID | NUMBER | (15) | Organization identifier | |
NUM_INVOICE_LINES | NUMBER | Number of Invoice Lines | ||
NUM_DISTRIBUTIONS | NUMBER | Number of Distributions | ||
NUM_INVOICE_LINE_VARIANCES | NUMBER | Number of invoices at the end of the reporting period that have a difference between the invoice amount and the lines total amount | ||
AMOUNT_INVOICE_LINE_VARIANCES | NUMBER | Sum of the invoice amounts of the invoices at the end of the reporting period that have a difference between the invoice amount and the lines total amount | ||
NUM_INVOICE_DIST_VARIANCES | NUMBER | Number of invoices at the end of the reporting period that have a difference between the invoice amount and the distribution total amount | ||
AMOUNT_INVOICE_DIST_VARIANCES | NUMBER | Sum of the invoice amounts of the invoices at the end of the reporting period that a difference between the invoice amount and the distributions total amount |
Cut, paste (and edit) the following text to query this object:
SELECT PERIOD_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, NUM_INVOICES
, AMOUNT_INVOICES
, NUM_DISTRIBUTION_LINES
, NUM_BATCHES
, NUM_INVOICE_VARIANCES
, AMOUNT_INVOICE_VARIANCES
, NUM_PAYMENT_SCHEDULES
, NUM_INVOICES_HELD
, AMOUNT_INVOICES_HELD
, NUM_INVOICES_MATCHED
, AMOUNT_INVOICES_MATCHED
, NUM_INVOICES_MATCH_HOLD
, AMOUNT_INVOICES_MATCH_HOLD
, VALUE1
, VALUE2
, VALUE3
, VALUE4
, VALUE5
, VALUE6
, VALUE7
, VALUE8
, VALUE9
, VALUE10
, NUM_EXPENSE_REPORTS
, AMOUNT_EXPENSE_REPORTS
, NUM_PREPAYMENTS
, AMOUNT_PREPAYMENTS
, NUM_RECURRING_PAYMENTS
, AMOUNT_RECURRING_PAYMENTS
, NUM_RECURRING_PAYMENTS_DEF
, ORG_ID
, NUM_INVOICE_LINES
, NUM_DISTRIBUTIONS
, NUM_INVOICE_LINE_VARIANCES
, AMOUNT_INVOICE_LINE_VARIANCES
, NUM_INVOICE_DIST_VARIANCES
, AMOUNT_INVOICE_DIST_VARIANCES
FROM AP.AP_INVOICE_KEY_IND_ALL;
AP.AP_INVOICE_KEY_IND_ALL does not reference any database object
AP.AP_INVOICE_KEY_IND_ALL is referenced by following:
|
|
|