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
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)
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.
