PO_REQUISITION_INTERFACE_ALL

Purchasing

PO Requisitio

n

AUTHORIZATION_STATUSREQ_NUMBER_SEGMENT1HEADER_DESCRIPTIONDELIVER_TO_LOCATION_IDDESTINATION_ORGANIZATION_IDDESTINATION_TYPE_CODEINTERFACE_SOURCE_CODEPREPARER_NAMESUGGESTED_VENDOR_IDSUGGESTED_VENDOR_SITE_IDCURRENCY_CODEQUANTITYORG_IDITEM_DESCRIPTIONUNIT_PRICEUOM_CODELINE_TYPENEED_BY_DATECATEGORY_SEGMENT1CATEGORY_SEGMENT2

Refer above.

Purchasing

PO Requisitio

n

PO_REQUISITION_INTERFACE_ALL

PO_REQ_DIST_INTERFACE_ALL

Purchasing

PO Requisitio

n

ACCRUAL_ACCOUNT_IDCHARGE_ACCOUNT_IDDESTINATION_ORGANIZATION_IDDISTRIBUTION_NUMBERDIST_SEQUENCE_IDINTERFACE_SOURCE_CODEQUANTITYORG_IDVARIANCE_ACCOUNT_IDREQ_NUMBER_SEGMENT1DISTRIBUTION_ATTRIBUTE1DISTRIBUTION_ATTRIBUTE2

PO_HEADERS_INTERFACEPurchasin

gPurchase

Orders

INTERFACE_HEADER_IDINTERFACE_SOURCE_CODEPROCESS_CODEACTIONORG_IDDOCUMENT_TYPE_CODEDOCUMENT_NUMCURRENCY_CODE RATE_TYPERATE_TYPE_CODERATE_DATERATEAGENT_NAMEAGENT_IDVENDOR_NAMEVENDOR_IDVENDOR_SITE_CODEVENDOR_SITE_IDVENDOR_CONTACTVENDOR_CONTACT_IDSHIP_TO_LOCATIONSHIP_TO_LOCATION_IDBILL_TO_LOCATIONBILL_TO_LOCATION_IDVENDOR_NUMAPPROVAL_STATUSCOMMENTS(po_headers_interface_s.NEXTVAL, 'DATA MIGRATION', 'PENDING', 'ORIGINAL',ORG_ID,'STANDARD',)

PO_LINES_INTERFACE

Purchasing

Purchase Orders

INTERFACE_LINE_IDINTERFACE_HEADER_IDACTIONDOCUMENT_NUMSHIPMENT_NUMLINE_NUMLINE_TYPELINE_TYPE_IDITEM_IDITEM_DESCRIPTIONUOM_CODEQUANTITYUNIT_PRICESHIP_TO_ORGANIZATION_IDSHIP_TO_LOCATIONSHIP_TO_LOCATION_IDNEED_BY_DATEORGANIZATION_IDPROMISED_DATECATEGORYCATEGORY_ID(po_lines_interface_s.NEXTVAL, po_headers_interface_s.CURRVAL, 'ORIGINAL' )

PO_DISTRIBUTIONS_INTERFACE

INTERFACE_DISTRIBUTION_IDINTERFACE_HEADER_IDINTERFACE_DISTRIBUTION_IDDISTRIBUTION_NUMQUANTITY_ORDEREDDESTINATION_TYPEDELIVER_TO_LOCATIONDELIVER_TO_LOCATION_IDDELIVER_TO_PERSON_FULL_NAMEDELIVER_TO_PERSON_IDDESTINATION_ORGANIZATIONDESTINATION_ORGANIZATION_IDCHARGE_ACCOUNT_IDORG_ID

PO_REQUISITION_HEADERS_ALL

REQUISITION_HEADER_IDPREPARER_IDSEGMENT1(Requisition no)AUTHORIZATION_STATUSAPPROVED_DATE

Requisition Import Program'REQIMPORT'

Oracle Purchasing generates SEGMENT1 using the PO_UNIQUE_IDENTIFIER_CONTROL table if you choose to let Oracle Purchasing generate requisition numbers for you.

PO_REQUISITION_LINES_ALL REQUISITION_HEADER_IDREQUISITION_LINE_IDLINE_NUMLINE_TYPE_IDITEM_IDITEM DESCRIPTIONCATEGORY_IDNEED_BY_DATEUNIT_MEAS_LOOKUP_CODEUNIT_PRICEQUANTITYDELIVER_TO_LOCATION

LINE_LOCATION_ID identifies the purchase order shipment line on which you placed the requisition. LINE_LOCATION_ID is null if you have not placed the requisition line on a purchase order.

BLANKET_PO_HEADER_ID and BLANKET_PO_LINE_NUM store the suggested blanket purchase agreement or catalog quotation line information for the requisition line.

PARENT_REQ_LINE_ID contains the REQUISITION_LINE_ID from the original requisition line if you exploded or multi-sourced this requisition line.

PO_REQ_DISTRIBUTIONS_ALL

DISTRIBUTION_IDREQUISITION_LINE_IDCODE_COMBINATION_IDPROJECT_IDTASK_IDEXPENDITURE_TYPEDISTRIBUTION_NUM

Stores information about the accounting distributions associated with each requisition line

PO_HEADERS_ALL

PO_HEADER_IDSEGMENT1(PO Number)TYPE_LOOKUP_CODEAUTHORIZATION_STATUSCOMMENTSAPPROVAL_FLAGAPPROVED_DATEPRINT_COUNTPRINT_DATEVENDOR_IDVENDOR_SITE_IDVENDOR_CONTACT_IDAGENT_IDTERM_IDFROM_HEADER_ID ( For Quotations created from RFQ)FROM_TYPE_LOOKUP_CODECURRENCY_CODERATE_TYPERATE_DATERATEBILL_TO_LOCATION_IDSHIP_TO_LOCATION_IDSTART_DATE_ACTIVEEND_DATE_ACTIVESHIP_VIA_LOOKUP_CODEFREIGHT_TERMS_LOOKUP_CODEREVISION_NUMREVISED_DATE

Primary Key: (SEGMENT1 & TYPE_LOOKUP_CODE ) ORPO_HEADER_IDSEGMENT1 - Derives PO Number from PO_UNIQUE_IDENTIFIER_CONT_ALL table.There are six types of documents that use PO_HEADERS_ALL:

• RFQs

• Quotations

• Standard purchase orders

• Planned purchase orders

• Blanket purchase orders

• Contracts

Authorization Status: APPROVED,CANCELLED,IN PROCESS, INCOMPLETE, PRE-APPROVED,REJECTED,REQUIRES REAPPROVAL, RETURNED.

PO_LINES_ALL

PO_HEADER_IDPO_LINE_IDLINE_NUMLINE_TYPE_IDITEM_IDCATEGORY_IDUNIT_PRICEQUANTITYUNIT_MEAS_LOOKUP_CODECLOSED_CODECLOSED_FLAGCLOSED_DATECLOSED_REASONCLOSED_ BYCANCEL_FLAGCANCELLED_BYCANCEL_DATECANCEL_REASONCONTRACT_NUM

Closed code : APPROVED,CANCELLED,CLOSED,CLOSED FOR INVOICE,CLOSED FOR RECEIVING,FINALLY CLOSED,IN PROCESS, INCOMPLETE,OPEN,PRE-APPROVED,REJECTED,REQUIRES REAPPROVAL,RETURNED.CONTRACT_NUM: To reference a contract purchase order from a standard purchase order line.

PO_LINE_LOCATIONS_ALL

PO_HEADER_IDPO_LINE_IDLINE_LOCATION_IDQUANTITYQUANTITY_RECEIVEDQUANTITY ACCEPTEDQUANTITY_REJECTEDQUANTITY_BILLEDQUANTITY_CANCELLEDPO_RELEASE_IDSHIP_TO_LOCATION_IDSHIP_VIA_LOOKUP_CODENEED_BY_DATEPROMISED_DATEENCUMBERED_FLAGENCUMBERED_DATESHIP_TO_ORGANIZATION_IDSHIPMENT_NUMORG_IDMATCH_OPTION

Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt.

PO_DISTRIBUTIONS_ALL

PO_ACTION_HISTORY

PO_HEADER_IDPO_LINE_IDLINE_LOCATION_IDPO_DISTRIBUTION_IDREQ_DISTRIBUTION_ID

REQ_DISTRIBUTION_ID corresponds to the ID of the requisition distribution you copy on the purchase order.

If you do not autocreate the purchase order from onlinerequisitions, REQ_LINE_REFERENCE_NUM andREQ_HEADER_REFERENCE_NUM contain the requisitionnumber and requisition line number of the corresponding paper requisition. These two columns are not foreign keys to anothertable.

OBJECT_IDOBJECT_TYPE_CODEOBJECT_SUB_TYPE_CODESEQUENCE_NUMACTION_CODEACTION_DATEEMPLOYEE_ID