AP_INVOICE_KEY_IND_ALL
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.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: SUMMARY
Primary Key
| Name | Columns |
|---|---|
|
AP_INVOICE_KEY_IND_PK |
CALENDAR_NAME, PERIOD_NAME, ORG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PERIOD_NAME | VARCHAR2 | 15 | Yes | Period name of the payables calendar. | |
| CALENDAR_NAME | VARCHAR2 | 15 | Yes | Name of the payables calendar used. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| NUM_INVOICES | NUMBER | Number of invoices at the end of reporting period. | |||
| AMOUNT_INVOICES | NUMBER | Amount on the invoices at the end of reporting period. | |||
| NUM_DISTRIBUTION_LINES | NUMBER | Number of invoice distributions lines at end of reporting period. | |||
| NUM_BATCHES | NUMBER | Number of invoices batches at end of reporting period. | |||
| 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 at end of reporting period. | |||
| 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 at end of reporting period. | |||
| AMOUNT_EXPENSE_REPORTS | NUMBER | Amount on the expense reports at the end of reporting period. | |||
| NUM_PREPAYMENTS | NUMBER | Number of prepayments at end of reporting period. | |||
| AMOUNT_PREPAYMENTS | NUMBER | Amount of prepayments at end of reporting period. | |||
| NUM_RECURRING_PAYMENTS | NUMBER | Number of recurring payments at end of reporting period. | |||
| AMOUNT_RECURRING_PAYMENTS | NUMBER | Amount of recurring invoices at end of reporting period. | |||
| NUM_RECURRING_PAYMENTS_DEF | NUMBER | Number of recurring invoice definitions | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| NUM_INVOICE_LINES | NUMBER | Number of invoice lines at end of reporting period. | |||
| NUM_DISTRIBUTIONS | NUMBER | Number of invoice distributions at end of reporting period. | |||
| 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 | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_INVOICE_KEY_IND_U1 | Unique | Default | CALENDAR_NAME, PERIOD_NAME, ORG_ID |