eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AP.AP_CHECKS_ALL

Object Details

Object Name:	AP_CHECKS_ALL
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_CHECKS_ALL
Subobject Name:
Status:	VALID

AP_CHECKS_ALL stores information about payments
issued to suppliers or refunds received from suppliers.
You need one row for each payment you issue to a
supplier or refund received from a supplier. Your Oracle
Payables application uses this information to record payments
you make to suppliers or refunds you receive from
suppliers. Your Oracle Payables application stores
the supplier name and bank account name for auditing
purposes, in case either one is changed after you create
the payment. Your Oracle Payables application stores
address information for all payments. If you allow changes
to the supplier payment address on manual payments or
Quick payments, your Oracle Payables application maintains
the new address information in this table. Your Oracle Payables
application uses BANK_ACCOUNT_NUM, BANK_NUM, and
BANK_ACCOUNT_TYPE for the supplier's bank information
when you use the Electronic payment method. Your Oracle
Payables application stores a dummy value for CHECK_STOCK_ID
for refunds, thus, CHECK_STOCK_ID should not be treated as a
foreign key to AP_CHECK_STOCKS_ALL in the case of refunds.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_CHECKS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHECK_ID
AP_CHECKS_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	DOC_SEQUENCE_ID DOC_SEQUENCE_VALUE
AP_CHECKS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHECK_DATE
AP_CHECKS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FUTURE_PAY_DUE_DATE
AP_CHECKS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CE_BANK_ACCT_USE_ID
AP_CHECKS_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_ID
AP_CHECKS_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_INSTRUCTION_ID
AP_CHECKS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHECK_NUMBER
AP_CHECKS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHECKRUN_NAME
AP_CHECKS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_TYPE_FLAG
AP_CHECKS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID
AP_CHECKS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID
AP_CHECKS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_SITE_ID
AP_CHECKS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHECKRUN_ID
AP_CHECKS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPLETED_PMTS_GROUP_ID
AP_FC_PAYMENT_N1	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NVL("ACTUAL_VALUE_DATE",NVL("ANTICIPATED_VALUE_DATE",NVL("FUTURE_PAY_DUE_DATE","CHECK_DATE")))

Columns

Name	Datatype	Length	Mandatory	Comments
AMOUNT	NUMBER		Yes	Payment amount
BANK_ACCOUNT_ID	NUMBER	(15)		No longer used
BANK_ACCOUNT_NAME	VARCHAR2	(80)	Yes	Bank account name
CHECK_DATE	DATE		Yes	Payment date
CHECK_ID	NUMBER	(15)	Yes	Payment identifier
CHECK_NUMBER	NUMBER	(15)	Yes	Payment number
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
PAYMENT_METHOD_LOOKUP_CODE	VARCHAR2	(25)		Name of payment method
PAYMENT_TYPE_FLAG	VARCHAR2	(25)	Yes	Flag that indicates the payment type
ADDRESS_LINE1	VARCHAR2	(240)		First address line of payment
ADDRESS_LINE2	VARCHAR2	(240)		Second address line of payment
ADDRESS_LINE3	VARCHAR2	(240)		Third address line of payment
CHECKRUN_NAME	VARCHAR2	(255)		Payment batch name
CHECK_FORMAT_ID	NUMBER	(15)		Check format identifier
CHECK_STOCK_ID	NUMBER	(15)		Payment document identifier
CITY	VARCHAR2	(60)		City
COUNTRY	VARCHAR2	(60)		Country
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
STATUS_LOOKUP_CODE	VARCHAR2	(25)		Status of payment (for example, NEGOTIABLE, SET UP, SPOILED)
VENDOR_NAME	VARCHAR2	(240)		Supplier name
VENDOR_SITE_CODE	VARCHAR2	(15)		Supplier site code
ZIP	VARCHAR2	(60)		State or province postal code
BANK_ACCOUNT_NUM	VARCHAR2	(30)		Supplier's bank account number for electronic payment purposes
BANK_ACCOUNT_TYPE	VARCHAR2	(25)		Supplier's bank account type code for electronic payment purposes
BANK_NUM	VARCHAR2	(30)		Supplier's bank number for electronic payment purposes
CHECK_VOUCHER_NUM	NUMBER	(16)		Payment voucher number
CLEARED_AMOUNT	NUMBER			Payment cleared amount
CLEARED_DATE	DATE			Payment cleared date
DOC_CATEGORY_CODE	VARCHAR2	(30)		Sequential Numbering (voucher number) document category for payment
DOC_SEQUENCE_ID	NUMBER			Sequential Numbering document sequence identifier
DOC_SEQUENCE_VALUE	NUMBER			Voucher number (sequential numbering) for payment
PROVINCE	VARCHAR2	(150)		No longer used
RELEASED_AT	VARCHAR2	(18)		No longer used
RELEASED_BY	NUMBER	(15)		User that released stop payment
STATE	VARCHAR2	(150)		State
STOPPED_AT	VARCHAR2	(18)		No longer used
STOPPED_BY	NUMBER	(15)		User that recorded stop payment
VOID_DATE	DATE			Payment void date
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive flexfield structure definition column.
FUTURE_PAY_DUE_DATE	DATE			Negotiable date for future dated payment
TREASURY_PAY_DATE	DATE			Date payment processed through internal clearing organization
TREASURY_PAY_NUMBER	NUMBER	(15)		Number assigned to payment processed through internal clearing organization
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		Transaction code for creating US Standard General Ledger journal entries
USSGL_TRX_CODE_CONTEXT	VARCHAR2	(30)		USSGL Transaction Code Descriptive Flexfield context column
WITHHOLDING_STATUS_LOOKUP_CODE	VARCHAR2	(25)		No longer used
RECONCILIATION_BATCH_ID	NUMBER	(15)		Supports integration with Oracle Cash Management
CLEARED_BASE_AMOUNT	NUMBER			Payment cleared amount in functional currency
CLEARED_EXCHANGE_RATE	NUMBER			Exchange rate at which the payment cleared, for foreign currency payments only
CLEARED_EXCHANGE_DATE	DATE			Date clearing exchange rate is effective, usually accounting date of a transaction
CLEARED_EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Exchange rate type at payment clearing time, for foreign currency payments only
ADDRESS_LINE4	VARCHAR2	(240)		Fourth address line of payment. Used for flexible address formatting
COUNTY	VARCHAR2	(150)		Used for flexible address formatting. Also used for matching AP and AR addresses
ADDRESS_STYLE	VARCHAR2	(30)		Used as context value in FAF descr flexs. Do not populate. Instead, join to FND_TERRITORIES where territory_code=country
ORG_ID	NUMBER	(15)		Organization identifier
VENDOR_ID	NUMBER	(15)		Supplier identifier. Supports integration with Oracle Cash Management
VENDOR_SITE_ID	NUMBER	(15)		Supplier site identifier. Supports integration with Oracle Cash Management
EXCHANGE_RATE	NUMBER			Exchange rate for foreign currency payment
EXCHANGE_DATE	DATE			Date exchange rate is effective. Usually the accounting date of the transaction
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Exchange rate for foreign currency payment
BASE_AMOUNT	NUMBER			Payment amount in functional currency
CHECKRUN_ID	NUMBER	(15)		Payment batch identifier
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
CLEARED_ERROR_AMOUNT	NUMBER			Cleared payment error amount
CLEARED_CHARGES_AMOUNT	NUMBER			Cleared payment charges amount
CLEARED_ERROR_BASE_AMOUNT	NUMBER			Cleared payment error amount in functional currency
CLEARED_CHARGES_BASE_AMOUNT	NUMBER			Cleared payment charges amount in functional currency
POSITIVE_PAY_STATUS_CODE	VARCHAR2	(25)		Set by and used by Positive Pay Report to select records
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
TRANSFER_PRIORITY	VARCHAR2	(25)		Transfer priority
EXTERNAL_BANK_ACCOUNT_ID	NUMBER	(15)		External bank account identifier
STAMP_DUTY_AMT	NUMBER			Stamp duty tax amount for globalization
STAMP_DUTY_BASE_AMT	NUMBER			Stamp duty tax amount in functional currency for globalization
MRC_CLEARED_BASE_AMOUNT	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and payment cleared amount pairs
MRC_CLEARED_EXCHANGE_RATE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion rate of cleared payment pairs
MRC_CLEARED_EXCHANGE_DATE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion date of cleared payment pairs
MRC_CLEARED_EXCHANGE_RATE_TYPE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion rate type at clearing time pairs
MRC_EXCHANGE_RATE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion rate pairs
MRC_EXCHANGE_DATE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion date pairs
MRC_EXCHANGE_RATE_TYPE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion rate type pairs
MRC_BASE_AMOUNT	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and payment amount pairs
MRC_CLEARED_ERROR_BASE_AMOUNT	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and cleared payment error base amount pairs
MRC_CLEARED_CHARGES_BASE_AMT	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and cleared payment charges base amount pairs
MRC_STAMP_DUTY_BASE_AMT	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and stamp duty tax pairs
MATURITY_EXCHANGE_DATE	DATE			Date maturity exchange rate is effective, usually the maturity date for the payment
MATURITY_EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Exchange rate type at future dated payment maturity time, for foreign currency payments only
MATURITY_EXCHANGE_RATE	NUMBER			Exchange rate at future dated payment maturity time, for foreign currency payments only
DESCRIPTION	VARCHAR2	(240)		Description
ACTUAL_VALUE_DATE	DATE			Actual Value Date. For use by Cash Management
ANTICIPATED_VALUE_DATE	DATE			Anticipated Value Date. For use by Cash Management
RELEASED_DATE	DATE			Date and time user released stop payment
STOPPED_DATE	DATE			Date and time user recorded stop payment
MRC_MATURITY_EXG_DATE	VARCHAR2	(2000)		Multiple reporting currencies only: Concatenated string of reporting set of books id and currency conversion date at maturity time pairs
MRC_MATURITY_EXG_RATE	VARCHAR2	(2000)		Multiple reporting currencies only: Concatenated string of reporting set of books id and currency conversion rate at maturity time pairs
MRC_MATURITY_EXG_RATE_TYPE	VARCHAR2	(2000)		Multiple reporting currencies only: Concatenated string of reporting set of books id and currency conversion type at maturity time pairs
IBAN_NUMBER	VARCHAR2	(40)		International bank account number. Used internationally to uniquely identify the account of a customer at a financial institution. During bank entry, the system validates the value to ensure that it is a valid IBAN.
CE_BANK_ACCT_USE_ID	NUMBER	(15)		Bank account identifier
PAYMENT_METHOD_CODE	VARCHAR2	(30)		Payment method identifier
PARTY_ID	NUMBER	(15)		Party identifier
PARTY_SITE_ID	NUMBER	(15)		Party Site identifier
PAYMENT_PROFILE_ID	NUMBER	(15)		Payment process profile identifier
SETTLEMENT_PRIORITY	VARCHAR2	(30)		The priority with which the financial institution or payment system should settle payment for this document. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY'
BANK_CHARGE_BEARER	VARCHAR2	(30)		Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER.
LEGAL_ENTITY_ID	NUMBER	(15)		Legal entity identifier
PAYMENT_DOCUMENT_ID	NUMBER	(15)		Payment document identifier
COMPLETED_PMTS_GROUP_ID	NUMBER	(15)		Completed payments group identifier
PAYMENT_ID	NUMBER	(15)		Oracle Payments payment identifier
PAYMENT_INSTRUCTION_ID	NUMBER	(15)		Payment Instruction Identifier
VOID_CHECK_NUMBER	NUMBER	(15)		Voided check number
VOID_CHECK_ID	NUMBER	(15)		Voided check unique identifier
REMIT_TO_SUPPLIER_NAME	VARCHAR2	(240)		Name of the third party payee
REMIT_TO_SUPPLIER_ID	NUMBER	(15)		ID of the third party payee
REMIT_TO_SUPPLIER_SITE	VARCHAR2	(240)		Site code of the third party payee
REMIT_TO_SUPPLIER_SITE_ID	NUMBER	(15)		Site id of the third party payee
RELATIONSHIP_ID	NUMBER	(15)		Relationship ID
PAYCARD_AUTHORIZATION_NUMBER	VARCHAR2	(30)		Authorization number to be used for payment card transaction
PAYCARD_REFERENCE_ID	NUMBER	(15)		Reference Id to payment card
ACKNOWLEDGED_FLAG	VARCHAR2	(1)		Acknowledged Flag for NOEX

Query Text

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


SELECT AMOUNT
,      BANK_ACCOUNT_ID
,      BANK_ACCOUNT_NAME
,      CHECK_DATE
,      CHECK_ID
,      CHECK_NUMBER
,      CURRENCY_CODE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      PAYMENT_METHOD_LOOKUP_CODE
,      PAYMENT_TYPE_FLAG
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      CHECKRUN_NAME
,      CHECK_FORMAT_ID
,      CHECK_STOCK_ID
,      CITY
,      COUNTRY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      STATUS_LOOKUP_CODE
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      ZIP
,      BANK_ACCOUNT_NUM
,      BANK_ACCOUNT_TYPE
,      BANK_NUM
,      CHECK_VOUCHER_NUM
,      CLEARED_AMOUNT
,      CLEARED_DATE
,      DOC_CATEGORY_CODE
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      PROVINCE
,      RELEASED_AT
,      RELEASED_BY
,      STATE
,      STOPPED_AT
,      STOPPED_BY
,      VOID_DATE
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE_CATEGORY
,      FUTURE_PAY_DUE_DATE
,      TREASURY_PAY_DATE
,      TREASURY_PAY_NUMBER
,      USSGL_TRANSACTION_CODE
,      USSGL_TRX_CODE_CONTEXT
,      WITHHOLDING_STATUS_LOOKUP_CODE
,      RECONCILIATION_BATCH_ID
,      CLEARED_BASE_AMOUNT
,      CLEARED_EXCHANGE_RATE
,      CLEARED_EXCHANGE_DATE
,      CLEARED_EXCHANGE_RATE_TYPE
,      ADDRESS_LINE4
,      COUNTY
,      ADDRESS_STYLE
,      ORG_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      EXCHANGE_RATE
,      EXCHANGE_DATE
,      EXCHANGE_RATE_TYPE
,      BASE_AMOUNT
,      CHECKRUN_ID
,      REQUEST_ID
,      CLEARED_ERROR_AMOUNT
,      CLEARED_CHARGES_AMOUNT
,      CLEARED_ERROR_BASE_AMOUNT
,      CLEARED_CHARGES_BASE_AMOUNT
,      POSITIVE_PAY_STATUS_CODE
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      TRANSFER_PRIORITY
,      EXTERNAL_BANK_ACCOUNT_ID
,      STAMP_DUTY_AMT
,      STAMP_DUTY_BASE_AMT
,      MRC_CLEARED_BASE_AMOUNT
,      MRC_CLEARED_EXCHANGE_RATE
,      MRC_CLEARED_EXCHANGE_DATE
,      MRC_CLEARED_EXCHANGE_RATE_TYPE
,      MRC_EXCHANGE_RATE
,      MRC_EXCHANGE_DATE
,      MRC_EXCHANGE_RATE_TYPE
,      MRC_BASE_AMOUNT
,      MRC_CLEARED_ERROR_BASE_AMOUNT
,      MRC_CLEARED_CHARGES_BASE_AMT
,      MRC_STAMP_DUTY_BASE_AMT
,      MATURITY_EXCHANGE_DATE
,      MATURITY_EXCHANGE_RATE_TYPE
,      MATURITY_EXCHANGE_RATE
,      DESCRIPTION
,      ACTUAL_VALUE_DATE
,      ANTICIPATED_VALUE_DATE
,      RELEASED_DATE
,      STOPPED_DATE
,      MRC_MATURITY_EXG_DATE
,      MRC_MATURITY_EXG_RATE
,      MRC_MATURITY_EXG_RATE_TYPE
,      IBAN_NUMBER
,      CE_BANK_ACCT_USE_ID
,      PAYMENT_METHOD_CODE
,      PARTY_ID
,      PARTY_SITE_ID
,      PAYMENT_PROFILE_ID
,      SETTLEMENT_PRIORITY
,      BANK_CHARGE_BEARER
,      LEGAL_ENTITY_ID
,      PAYMENT_DOCUMENT_ID
,      COMPLETED_PMTS_GROUP_ID
,      PAYMENT_ID
,      PAYMENT_INSTRUCTION_ID
,      VOID_CHECK_NUMBER
,      VOID_CHECK_ID
,      REMIT_TO_SUPPLIER_NAME
,      REMIT_TO_SUPPLIER_ID
,      REMIT_TO_SUPPLIER_SITE
,      REMIT_TO_SUPPLIER_SITE_ID
,      RELATIONSHIP_ID
,      PAYCARD_AUTHORIZATION_NUMBER
,      PAYCARD_REFERENCE_ID
,      ACKNOWLEDGED_FLAG
FROM AP.AP_CHECKS_ALL;

Dependencies

[top of page]

AP.AP_CHECKS_ALL does not reference any database object

AP.AP_CHECKS_ALL is referenced by following:

AP: AP_CHECKS_ALL#