Purchase Order tables

Purchase Order tables

Purchase Order

Purchase Order Tables

1.PO_REQUISITION_HEADESR_ALL
2.PO_REQUISITION_LINES_ALL
When you raise the Requisition these tables effected(PO_REQUISITION_HEADER_ID) is the join between the tables
4.PO_REQ_DISTRIBUTION_ALL
It distribute the Requisition Account information.5.PO_HEADERS_ALL (PO_HEADER_ID)
6.PO_LINES_ALLWhen 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_ALL(VENDOR_ID)10.PO_VENDOR_SITES_ALL(VENDOR_SITE_ID)11.PO_VENDOR_CONTACTS_ALL (VENDOR_CONTACT_ID)
Contacts Vendor ,Vendor site and conatct information(Vendor_id,Vendor_contact_id,VEDNOR_SITE_ID)
12.RCV_SHIPMENT_HEADERS_ALL(SHIPMENT_HEADER_ID)
common information about the source of your receipts or expected receipts
13.RCV_SHPMENT_LINES_ALLwhen you issue the recept The recepent 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_Release_allTO see the which purchase order is released.
17.PO_AGENTScontains information about buyers and purchasing managers.
18.PO_NOTIFICATION_CONTROLScontains information about the notification control rules for blanket, planned, and contract purchase orders.
19.PO_APPROVAL_LIST_HEADERS
list of approvers for the purchasing document used for requisition approvals only
20.PO_APPROVAL_LIST_LINESapproval list lines for the requisition approval list.
21.PO_POSITION_CONTROLS_ALLassignment of control groups to jobs and/or positions
22.PO_DOCUMENT_TYPES_ALL_Bdefault, control, and option information you provide to customize
23.PO_CONTROL_GROUPS_ALLcontrol 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