DBA Data[Home] [Help] [Dependency Information]

TABLE: AP.AP_PAYMENT_KEY_IND_ALL

Object Details
Object Name: AP_PAYMENT_KEY_IND_ALL
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_PAYMENT_KEY_IND_ALL
Subobject Name:
Status: VALID


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.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_PAYMENT_KEY_IND_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnPERIOD_NAME
ColumnORG_ID
Columns
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_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
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
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
AMOUNT_CLEARED_CHECKS NUMBER

Amount of payments cleared
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 (15)
Organization identifier
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.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PERIOD_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      NUM_AUTO_PAYMENTS
,      NUM_MANUAL_PAYMENTS
,      AMOUNT_AUTO_PAYMENTS
,      AMOUNT_MANUAL_PAYMENTS
,      NUM_INVOICES_PAID
,      NUM_AUTO_CHECKS
,      NUM_MANUAL_CHECKS
,      AMOUNT_AUTO_CHECKS
,      AMOUNT_MANUAL_CHECKS
,      NUM_DISCOUNTS_TAKEN
,      AMOUNT_DISCOUNTS_TAKEN
,      NUM_CHECKS_VOIDED
,      NUM_STOP_PAYMENTS
,      NUM_SPOILED
,      NUM_OUTSTANDING
,      NUM_CLEARED_CHECKS
,      AMOUNT_CLEARED_CHECKS
,      VALUE1
,      VALUE2
,      VALUE3
,      VALUE4
,      VALUE5
,      VALUE6
,      VALUE7
,      VALUE8
,      VALUE9
,      VALUE10
,      ORG_ID
,      AMOUNT_OUTSTANDING
,      NUM_REFUND_PAYMENTS
,      AMOUNT_REFUND_PAYMENTS
FROM AP.AP_PAYMENT_KEY_IND_ALL;

Dependencies

[top of page]

AP.AP_PAYMENT_KEY_IND_ALL does not reference any database object

AP.AP_PAYMENT_KEY_IND_ALL is referenced by following:

SchemaAPPS
SynonymAP_PAYMENT_KEY_IND
SynonymAP_PAYMENT_KEY_IND_ALL