Base Tables for Oracle Procure To Pay Cycle (P2P)

Base Tables for Oracle Procure To Pay Cycle (P2P)

Procure To Pay Cycle

Requisition
1)po_requisition_headers_all ( segment1 column in table represent requisition number)
2)po_requisition_lines_all
3)po_req_distributions_all
Note: requisition_header_id is the link between po_requisition_headers_all and po_requisition_lines_all
requisition_line_id is the link between po_requisition_lines_all and po_req_distributions_all

Purchase order
1)po_headers_all
2)po_lines_all
3)po_distributions_all
4)po_line_locations_all
Note: po_header_id is the link between all these tables

Receipt
1)rcv_shipment_headers
2)rcv_shipment_lines
3)rcv_transactions
Note: shipment_header_id is the link between rcv_shipment_headers and rcv_shipment_line po_header_id   is the link between rcv_shipment_headers and rcv_transaction

Invoices
1)ap_invoices_all
2)ap_invoice_distributions_all
Note: invoice_id is the link between ap_invoices_all and ap_invoice_distributions_all

Payments
1)ap_checks_all
2)ap_invoice_payments_all
3)ap_payment_schedules_all

Payment Reconcillation
1)ap_banks
2)ap_bank_branches

GL Transfer
1)gl_periods
2)gl_period_status
3)gl_set_of_books