Oracle Table Reference

AP_INVOICES_ALL

Invoice header — supplier, amount, invoice date, payment terms, currency.

AP_INVOICE_LINES_ALL

Invoice line detail — item/expense lines tied to a header.

AP_INVOICE_DISTRIBUTIONS_ALL

Accounting distributions generated from invoice lines for GL posting.

AP_PAYMENT_SCHEDULES_ALL

Scheduled payment installments for an invoice, including due dates and amounts remaining.

AP_INVOICE_PAYMENTS_ALL

Links invoices to the payments (checks/EFT) that settled them.

AP_HOLDS_ALL

Holds placed on an invoice (matching, tax, variance, etc.) that block payment/accounting.

AP_CHECKS_ALL

Payment (check/EFT) header issued to a supplier.

RA_CUSTOMER_TRX_ALL

AR transaction header — invoice, credit memo, or debit memo issued to a customer.

RA_CUSTOMER_TRX_LINES_ALL

Transaction line detail — revenue, tax, freight, and rounding lines.

RA_CUST_TRX_LINE_GL_DIST_ALL

GL distribution generated from transaction lines for accounting.

AR_CASH_RECEIPTS_ALL

Customer receipt header — amount received and receipt method.

AR_RECEIVABLE_APPLICATIONS_ALL

Links a cash receipt to the transaction(s) it pays, closing the AR balance.

GL_JE_HEADERS

Journal entry header — batch, ledger, period, source, status.

GL_JE_LINES

Journal entry line — account, debit/credit amount.

GL_CODE_COMBINATIONS

Chart of accounts code combinations — the valid account segment strings journals post to.

GL_BALANCES

Period-level actual/budget/encumbrance balances by code combination.

GL_PERIODS

Accounting period definitions and open/close status.

XLA_AE_HEADERS

Subledger accounting event header — the accounting entry generated from a subledger transaction, before/alongside its GL journal.

XLA_AE_LINES

Subledger accounting event line — the account and debit/credit amount for one accounting distribution.

FA_ADDITIONS_B

Asset header — description, category, and unique asset identifier.

FA_BOOKS

Assigns an asset to a depreciation book — cost, life, method, and in-service date for that book.

FA_DEPRECIATION_HISTORY

Depreciation expense recorded for an asset in a given period, by depreciation run.

CE_BANK_ACCOUNTS

Internal bank account definitions used for payments, receipts, and reconciliation.

CE_STATEMENT_HEADERS_ALL

Bank statement header — one row per statement loaded for reconciliation.

CE_STATEMENT_LINES

Individual bank statement line — one transaction to be matched/reconciled against a payment or receipt.

ZX_LINES

Tax line calculated by the tax engine for a transaction line — tax rate, amount, and jurisdiction.

ZX_TAXES_B

Tax definitions — the configured taxes (e.g. VAT, Sales Tax) available to be applied.

HZ_PARTIES

Trading Community Architecture (TCA) party master — the underlying person or organization, independent of any role (customer, supplier, contact) it plays.

HZ_RELATIONSHIPS

Generic party-to-party relationship — e.g. a person party related to an organization party as its contact.

HZ_ORG_CONTACTS

Specializes a HZ_RELATIONSHIPS row into a named contact for an organization party, carrying the contact's role attributes.

HZ_CONTACT_POINTS

Actual contact-method details (phone, email, etc.) for a party — this, not HZ_PARTY_SITES, is where phone/email actually live.

HZ_CUST_ACCOUNTS

Customer account — the transactable 'customer' entity AR and Order Management actually bill and ship to, layered on top of a TCA party.

HZ_PARTY_SITES

A physical site (address) tied to a party, independent of any specific customer account's use of it.

HZ_CUST_ACCT_SITES_ALL

Links a customer account to one of its party's sites, making that address usable for that specific account.

HZ_CUST_SITE_USES_ALL

The business-purpose assignment of an account site (Bill-To, Ship-To, etc.) — what AR and Order Management actually reference when defaulting an address onto a transaction.

PO_REQUISITION_HEADERS_ALL

Requisition header — preparer, requisitioning BU, status.

PO_REQUISITION_LINES_ALL

Requisition line — item, quantity, need-by date, destination.

PO_HEADERS_ALL

Purchase order header — supplier, PO type, status.

PO_LINES_ALL

PO line — item, quantity, unit price.

PO_DISTRIBUTIONS_ALL

PO distribution — charge account and quantity ordered per accounting distribution.

RCV_SHIPMENT_HEADERS

Receipt header — supplier shipment received against one or more POs.

RCV_SHIPMENT_LINES

Receipt line — item and quantity received against a PO line.

POZ_SUPPLIERS

Supplier (vendor) header — the master record for a company or individual that Procurement and Payables transact with.

POZ_SUPPLIER_SITES_ALL_M

Supplier site — a specific address and purpose (ordering, pay/remit-to, RFQ) for a supplier; purchase orders and invoices reference a site, not just the supplier header.

DOO_HEADERS_ALL

Sales order header — customer, order type, business unit, order status.

DOO_LINES_ALL

Sales order line — item, quantity, and requested schedule for a header.

DOO_FULFILL_LINES_ALL

Fulfillment line tracking the orchestration/fulfillment status of a sales order line (scheduling, reservation, shipping, invoicing).

WSH_NEW_DELIVERIES

Delivery header grouping one or more lines for pick/ship confirm.

WSH_DELIVERY_DETAILS

Delivery line — item and quantity being picked/shipped, linked back to the order fulfillment line.

WSH_DELIVERY_ASSIGNMENTS

Links a delivery detail (line) to the delivery it's currently grouped into.

WSH_TRIPS

Trip header — a transportation run (e.g. one truck's route) that one or more deliveries are planned onto.

WSH_TRIP_STOPS

A stop (pickup or dropoff location) on a trip — deliveries are planned onto a stop, not the trip directly.

EGP_SYSTEM_ITEMS_B

Item master — one row per item per organization, with attributes like item type, status, and UOM.

MTL_ONHAND_QUANTITIES_DETAIL

Current on-hand quantity for an item by subinventory/locator.

MTL_SECONDARY_INVENTORIES

Subinventory definition — a named storage area within an inventory organization (e.g. Stores, Staging, Damaged, Finished Goods) that on-hand quantity and transactions are tracked against.

MTL_ITEM_LOCATIONS

Locator definition — a specific row/rack/bin (or other physical subdivision) within a subinventory, used where locator control tracks inventory at that granularity.

MTL_MATERIAL_TRANSACTIONS

Historical log of every inventory transaction (receipt, issue, transfer, adjustment) that moved or changed on-hand quantity.

MTL_PARAMETERS

Inventory organization definition and parameters.

MTL_TRANSACTION_TYPES

Lookup of predefined inventory transaction types (Miscellaneous Issue, Miscellaneous Receipt, Subinventory Transfer, etc.) that classify each row on MTL_MATERIAL_TRANSACTIONS.

MTL_LOT_NUMBERS

Lot definition for a lot-controlled item — one row per lot number, with expiration and grade attributes where applicable.

MTL_SERIAL_NUMBERS

Serial number definition and current status/location for a serial-controlled item — one row per physical unit.

WIP_ENTITIES

Work order (discrete job) identity — number, type, and the item it produces.

WIP_DISCRETE_JOBS

Discrete job header — quantities, dates, and status for a work order.

CST_ITEM_COST_DETAILS

Current cost of an item by cost element (material, overhead, etc.) and cost level, within a cost organization/book.

CST_LAYER_COST_DETAILS

Perpetual (average/FIFO) cost layer detail — the quantity/cost layers a perpetual costing method maintains as receipts and issues consume them.

CST_AE_HEADERS

Cost accounting distribution header — the accounting entry Cost Accounting generates from a costed inventory/WIP transaction, ahead of its GL journal.

CST_AE_LINES

Cost accounting distribution line — the account and debit/credit amount for one cost accounting distribution.