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_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_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_ALL
when 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_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 approvers 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