Oracle common background table query
QUANWEIRU 2021-07-28 09:26:07

modular

English table name

Chinese table name

GL

gl_balances

Try the balance sheet

GL

gl_code_combinations

Chart of account codes

GL

gl_je_batches

Journal batch

GL

gl_je_headers

Journal header

GL

gl.gl_je_lines

Journal lines

GL

gl_import_references

Import reference table

GL

gl_interface

GL interface table

AP

ap_liability_balance

Trial balance of accounts payable

AP

ap_invoices_all

** surface

AP

ap_invoice_distributions_all

** Distribution table

AP

ap_invoice_payments_all

Payment write off table

AP

ap_checks_all

Payment schedule

AP

ap_payment_schedules_all

Payment schedule

AP

ap_ae_headers_all

Entry header table

AP

ap_ae_lines_all

Entry line table

AP

po_vendors

Supplier list

AP

po_accrual_reconcile_temp_all

Reconciliation of accrued liabilities

AR

ra_customer_trx_all

Transaction table

AR

ra_customer_trx_lines_all

Transaction row table

AR

ra_cust_trx_line_gl_dist_all

** Entry table

AR

ar_cash_receipts_all

Collection form

AR

ar_distributions_all

Collection entry table

AR

ar_cash_receipt_history_all

Collection history table

AR

ar_receivable_applications_all

Collection write off table

AR

ra_interface_lines_all

receivable ** Interface table

AR

ra_customers

Customer list

FA

fa_transaction_headers

Transaction header table

FA

fa_transfer_details

Transaction schedule

FA

fa_additions_b/tl

Statement of assets increase

FA

fa_category_books

Asset class

FA

fa_mass_additions

Increase in batches

FA

fa_deprn_detail

Depreciation schedule

FA

fa_adjustments

Asset adjustment

FA

fa_deprn_basis_rules

Depreciation rule table

FA

fa_distribution_accounts

Asset allocation statement

PO

po_headers_all

Order header

PO

po_lines_all

Order line

PO

po_line_locations_all

Order delivery run

PO

po_distributions_all

Order allocation line

PO

rcv_transactions

Receive transactions

PO

rcv_shipment_headers

Receiving head

PO

rcv_shipment_lines

Receiving line

PO

rcv_receiving_sub_ledger

Receive entry table

INV

mtl_system_items_b

Material list

INV

mtl_onhand_quantities_detail

Existing scales

INV

mtl_material_transctions

Material transaction

INV

mtl_transaction_accounts

Material transaction entries

INV

cst_item_costs

Project cost

INV

cst_standard_costs

Project historical cost

WIP

wip_discrete_jobs

WIP Task list

WIP

wip_requirement_operations

WIP Component requirements

WIP

wip_entities

WIP Task name table

WIP

wip_transactions

WIP Transaction processing

WIP

wip_transaction_accounts

WIP Transaction entries

WIP

wip_period_balances

WIP Period balance sheet

 

Please bring the original link to reprint ,thank
Similar articles