Thursday, December 11, 2008

Base tables for Procure To Pay

Requisition
po_requisition_headers_all
po_requisition_lines_all ( segment1 ========== requisition number)
po_req_distributions_all

Purchase order
po_headers_all
po_lines_all
po_distributions_all
po_line_locations_all

Receipt
rcv_shipment_headers
rcv_shipment_lines
rcv_transactions
quality result stored in qa_results table

Note: shipment_header_id is the link between rcv_shipment_headers and rcv_shipment_linespo_header_id is the link between rcv_shipment_headers and rcv_transaction

Invoices

ap_invoices_all
ap_invoice_distributions_all

Payments

ap_checks_all
ap_invoice_payments_all
ap_payment_schedules_all

Payment Reconcillation
ap_banks
ap_bank_branches

GL Transfer
gl_periods
gl_period_status
gl_set_of_books
glfv_charts_of_accounts

No comments: