Oracle Fusion · Data dictionary
AP_CHECKS_ALL
PayablesUsed in 6 subject areas44 reporting columns
Payables (AP), payments / checks issued (electronic or paper).
Primary key: CHECK_ID
Joins (inferred from key columns): PAYMENT_METHOD_CODE → IBY_PAYMENT_METHODS_B
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ADDRESS_LINE1 | ● | Address line1. | |
| ADDRESS_LINE2 | ● | Address line2. | |
| ADDRESS_LINE3 | ● | Address line3. | |
| ADDRESS_LINE4 | ● | Address line4. | |
| AMOUNT | ● | Amount. | |
| BANK_ACCOUNT_TYPE | ● | Type of bank account. | |
| BANK_CHARGE_BEARER | ● | Bank charge bearer. | |
| BANK_NUM | ● | Bank number. | |
| BASE_AMOUNT | ● | Base amount. | |
| CHECKRUN_NAME | ● | Name of the checkrun. | |
| CHECK_DATE | ● | Check date. | |
| CHECK_ID | PK | ○ | Identifier for the check. |
| CHECK_NUMBER | ● | Check number. | |
| CHECK_VOUCHER_NUM | ● | Check voucher number. | |
| CITY | ● | City. | |
| CLEARED_AMOUNT | ● | Cleared amount. | |
| CLEARED_DATE | ● | Cleared date. | |
| COUNTRY | ● | Country. | |
| COUNTY | ● | County. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| DESCRIPTION | ● | Description. | |
| DOC_SEQUENCE_VALUE | ● | Doc sequence value. | |
| EXCHANGE_DATE | ● | Exchange date. | |
| EXCHANGE_RATE | ● | Exchange rate. | |
| FUTURE_PAY_DUE_DATE | ● | Future pay due date. | |
| IBAN_NUMBER | ● | Iban number. | |
| MATURITY_EXCHANGE_DATE | ● | Maturity exchange date. | |
| MATURITY_EXCHANGE_RATE | ● | Maturity exchange rate. | |
| MATURITY_EXCHANGE_RATE_TYPE | ● | Type of maturity exchange rate. | |
| PAYMENT_METHOD_CODE | ● | Code identifying the payment method. | |
| PAYMENT_TYPE_FLAG | ● | Indicator (Y/N) for the payment type. | |
| PROVINCE | ● | Province. | |
| RECON_FLAG | ● | Indicator (Y/N) for the recon. | |
| RELEASED_DATE | ● | Released date. | |
| REMIT_TO_ADDRESS_NAME | ● | Name of the remit to address. | |
| REMIT_TO_SUPPLIER_NAME | ● | Name of the remit to supplier. | |
| SETTLEMENT_PRIORITY | ● | Settlement priority. | |
| STATE | ● | State. | |
| STATUS_LOOKUP_CODE | ● | Lookup code for the status. | |
| STOPPED_DATE | ● | Stopped date. | |
| VENDOR_NAME | ● | Name of the vendor. | |
| VENDOR_SITE_CODE | ● | Code identifying the vendor site. | |
| VOID_DATE | ● | Void date. | |
| X_CURR_RATE_TYPE | ● | Type of x currency rate. | |
| ZIP | ● | Zip. |
11 reports read from this table
Change a column here and these are the reports that move with it, the blast radius for any change to AP_CHECKS_ALL.
- Auto Reconciliation Execution Report
- Cash to General Ledger Reconciliation Report
- AP Vendor Financing Batch Creation Inquiry Report
- Key Indicators Payment Report
- Vietnam Payment Voucher Report
- Unclaimed Property Report (United States)
- Payables Payment Register
- Payment Audit by Voucher Number Report
- Escheated Payments Listing Report
- Update Matured Bills Payable Status
- Cash in Transit Report
Where this surfaces in OTBI
The OTBI subject areas that expose this table. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
- Payables Invoices - Prepayment Applications Real Time
- Payables Invoices - Transactions Real Time
- Payables Payments - Disbursements Real Time
- Payables Payments - Payment History Real Time
- Procurement - Spend Real Time
- Subledger Accounting - Journals Real Time
Need the extract + dbt staging for AP_CHECKS_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table