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
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. You can't join across them in OTBI — the owned conformed model joins them on shared 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.