[Home] [Help] [Dependency Information]
Object Name: | AP_PAYMENT_KEY_IND_ALL# |
---|---|
Object Type: | VIEW |
Owner: | AP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERIOD_NAME | VARCHAR2 | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
NUM_AUTO_PAYMENTS | NUMBER | |||
NUM_MANUAL_PAYMENTS | NUMBER | |||
AMOUNT_AUTO_PAYMENTS | NUMBER | |||
AMOUNT_MANUAL_PAYMENTS | NUMBER | |||
NUM_INVOICES_PAID | NUMBER | |||
NUM_AUTO_CHECKS | NUMBER | |||
NUM_MANUAL_CHECKS | NUMBER | |||
AMOUNT_AUTO_CHECKS | NUMBER | |||
AMOUNT_MANUAL_CHECKS | NUMBER | |||
NUM_DISCOUNTS_TAKEN | NUMBER | |||
AMOUNT_DISCOUNTS_TAKEN | NUMBER | |||
NUM_CHECKS_VOIDED | NUMBER | |||
NUM_STOP_PAYMENTS | NUMBER | |||
NUM_SPOILED | NUMBER | |||
NUM_OUTSTANDING | NUMBER | |||
NUM_CLEARED_CHECKS | NUMBER | |||
AMOUNT_CLEARED_CHECKS | NUMBER | |||
VALUE1 | NUMBER | |||
VALUE2 | NUMBER | |||
VALUE3 | NUMBER | |||
VALUE4 | NUMBER | |||
VALUE5 | NUMBER | |||
VALUE6 | NUMBER | |||
VALUE7 | NUMBER | |||
VALUE8 | NUMBER | |||
VALUE9 | NUMBER | |||
VALUE10 | NUMBER | |||
ORG_ID | NUMBER | (15) | ||
AMOUNT_OUTSTANDING | NUMBER | |||
NUM_REFUND_PAYMENTS | NUMBER | |||
AMOUNT_REFUND_PAYMENTS | NUMBER |
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#;
|
|
|