AP_PAYMENT_KEY_IND_ALL
AP_PAYMENT_KEY_IND stores compiled payment information for the Key Indicators Report. There is one row for each period for which you report on payment key indicators. The information in this table is denormalized for reporting purposes.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: SUMMARY
Primary Key
| Name | Columns |
|---|---|
|
AP_PAYMMENT_KEY_IND_PK |
CALENDAR_NAME, PERIOD_NAME, ORG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PERIOD_NAME | VARCHAR2 | 15 | Yes | Name of the key indicator calendar period. | |
| CALENDAR_NAME | VARCHAR2 | 15 | Yes | Name of the calendar for the selected period. | |
| 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_AUTO_PAYMENTS | NUMBER | Number of invoices paid by automatic payments | |||
| NUM_MANUAL_PAYMENTS | NUMBER | Number of invoices paid by manual payments | |||
| AMOUNT_AUTO_PAYMENTS | NUMBER | Amount of invoices paid by automatic payments | |||
| AMOUNT_MANUAL_PAYMENTS | NUMBER | Amount of invoices paid by manual payments | |||
| NUM_INVOICES_PAID | NUMBER | Number of invoices paid in the calendar period. | |||
| NUM_AUTO_CHECKS | NUMBER | Number of automatic payments printed | |||
| NUM_MANUAL_CHECKS | NUMBER | Number of manual checks entered | |||
| AMOUNT_AUTO_CHECKS | NUMBER | Amount of automatic payments printed | |||
| AMOUNT_MANUAL_CHECKS | NUMBER | Amount of manual checks entered | |||
| NUM_DISCOUNTS_TAKEN | NUMBER | Number of discounts taken on invoices paid | |||
| AMOUNT_DISCOUNTS_TAKEN | NUMBER | Amount of discounts taken on invoices paid | |||
| NUM_CHECKS_VOIDED | NUMBER | Number of payments voided in the calendar period. | |||
| NUM_STOP_PAYMENTS | NUMBER | Number of stop payments recorded | |||
| NUM_SPOILED | NUMBER | Number of spoiled payments recorded | |||
| NUM_OUTSTANDING | NUMBER | Number of payments which have not been reconciled to bank account | |||
| NUM_CLEARED_CHECKS | NUMBER | Number of payments cleared in the calendar period. | |||
| AMOUNT_CLEARED_CHECKS | NUMBER | Payment amount cleared in the calendar 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 | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| AMOUNT_OUTSTANDING | NUMBER | Sum of the payment amounts that were not reconciled to a bank account. | |||
| NUM_REFUND_PAYMENTS | NUMBER | Total number of invoices paid as refund payments. | |||
| AMOUNT_REFUND_PAYMENTS | NUMBER | Sum of the invoice amounts paid by refund payments. | |||
| 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_PAYMENT_KEY_IND_U1 | Unique | Default | CALENDAR_NAME, PERIOD_NAME, ORG_ID |