P2P Table Descriptions

P2P Tables With Details

1.PO_REQUISITION_HEADERS_ALL

2.PO_REQUISITION_LINES_ALL

When you raise the Requisition these tables effected 

3.PO_REQUISITION_HEADER_ID is the join between the tables

4.PO_REQ_DISTRIBUTIONS_ALL

It distribute the Requisition Account information.

5.PO_HEADERS_ALL  (PO_HEADER_ID)

6.PO_LINES_ALL

When PO Created PO stores in tables(PO_HEADER_ID) is the join for tables

7.PO_DISTRIBUTIONS_ALL

It will distribute the PO# Account information

8.PO_ACTION_HISTORY

Here you can get Approvals notification Status

9.PO_VENDORS  (VENDOR_ID)

10.PO_VENDOR_SITES_ALL  (VENDOR_SITE_ID)

11.PO_VENDOR_CONTACTS  (VENDOR_CONTACT_ID)

Contacts Vendor ,Vendor site and contact information Vendor_id,Vendor_contact_id, (VENDOR_SITE_ID)

12. RCV_SHIPMENT_HEADERS   (SHIPMENT_HEADER_ID)

Common information about the source of your receipts or expected receipts

13. RCV_SHIPMENT_LINES

When you issue the receipt The recipient number , Shipment location stores in the table.

14. RCV_TRANSACTIONS  (TRANSACTION_ID)

15. MTL_MATERIAL_TRANSACTIONS  (TRANSACTION_ID)

Stores material transaction information (Transaction_id)

16.PO_RELEASES_ALL

To see the which purchase order is released.

17.PO_AGENTS

Contains information about buyers and purchasing managers.

18.PO_NOTIFICATION_CONTROLS

Contains information about the notification control rules for blanket, planned, and contract purchase orders.

19.PO_APPROVAL_LIST_HEADERS

List of approves for the purchasing document used for requisition approvals only

20.PO_APPROVAL_LIST_LINES

Approval list lines for the requisition approval list.

21.PO_POSITION_CONTROLS_ALL

Assignment of control groups to jobs and/or positions

22.PO_DOCUMENT_TYPES_ALL_B

Default, control, and option information you provide to customize

23.PO_CONTROL_GROUPS_ALL

Control groups you use in your business

24.PO_RFQ_VENDORS

Information about the set of suppliers assigned to a request for quotation (RFQ)

25.PO_VENDOR_LIST_HEADERS  (VENDOR_LIST_HEADER_ID)

Stores information about supplier quotation lists you create.

26.FINANCIALS_SYSTEM_PARAMS_ALL

This Tables stores common and default information between AP and PO.