Wednesday, November 23, 2011

PO_HEADERS_ALL

Purchasing
Table Or View: Table
Important columns: 
PO_HEADER_ID , 
SEGMENT1,
VENDOR_ID ,
VENDOR_SITE_ID

Description: 
PO_HEADERS_ALL contains header information for all purchasing documents.
You need one row for each document you create. There are six types of documents that use PO_HEADERS_ALL:
  • RFQs
  • Quotations
  • Standard purchase orders
  • Planned purchase orders
  • Blanket purchase orders
  • Contracts
Each row contains all the header level informations like : buyer information, supplier information, brief notes, foreign currency information, terms and conditions information, and the status of the document. Oracle Purchasing uses this information to record information that is related to a complete document.
 
PO_HEADER_ID is the unique system-generated primary key and is invisible to the user.
SEGMENT1 is the system-assigned number you use to identify the document in forms and reports. Oracle Purchasing generates SEGMENT1 using the 

PO_UNIQUE_IDENTIFIER_CONT_ALL table if you choose to let Oracle Purchasing generate document numbers for you. SEGMENT1 is not unique for the entire table. Different document types can share the same numbers. You can uniquely identify a row in PO_HEADERS_ALL using ORG_ID, SEGMENT1, and TYPE_LOOKUP_CODE, or using PO_HEADER_ID.
 
If APPROVED_FLAG is 'Y', the purchase order is approved. If your document type is a blanket purchase order, contract purchase order, RFQ, or quotation, Oracle Purchasing uses START_DATE and END_DATE to store the valid date range for the document. Oracle Purchasing only uses BLANKET_TOTAL_AMOUNT for blanket purchase orders or contract purchase orders.
 
If you autocreate a quotation from an RFQ using the Copy Document window, Oracle Purchasing stores the foreign key to your original RFQ in FROM_HEADER_ID. Oracle Purchasing also uses FROM_TYPE_LOOKUP_CODE to indicate that you copied the quotation from an RFQ.

Oracle Purchasing does not use SUMMARY_FLAG and ENABLED_FLAG. Because future versions of Oracle Purchasing will use them, SUMMARY_FLAG and ENABLED_FLAG should always be 'N' and 'Y' respectively.

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect