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: TableSQLAP.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_CHECKS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHECK_ID
AP_CHECKS_U3 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDOC_SEQUENCE_ID
ColumnDOC_SEQUENCE_VALUE
AP_CHECKS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHECK_DATE
AP_CHECKS_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFUTURE_PAY_DUE_DATE
AP_CHECKS_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCE_BANK_ACCT_USE_ID
AP_CHECKS_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYMENT_ID
AP_CHECKS_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYMENT_INSTRUCTION_ID
AP_CHECKS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHECK_NUMBER
AP_CHECKS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHECKRUN_NAME
AP_CHECKS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYMENT_TYPE_FLAG
AP_CHECKS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
AP_CHECKS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_ID
AP_CHECKS_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_SITE_ID
AP_CHECKS_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHECKRUN_ID
AP_CHECKS_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMPLETED_PMTS_GROUP_ID
AP_FC_PAYMENT_N1 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNVL("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:

SchemaAP
ViewAP_CHECKS_ALL#