![]() ![]() Type of transportation used to ship the product, such as truck, air or boat. NameĬolumns Columns that are associated with the table. Primary Key Details of the primary key for the table. You enter document header information in the Header region of the Purchase Orders, RFQs, and Quotations windows. ![]() ![]() Because future versions of Oracle Purchasing will use them, SUMMARY_FLAG and ENABLED_FLAG should always be 'N' and 'Y' respectively. Oracle Purchasing does not use SUMMARY_FLAG and ENABLED_FLAG. Oracle Purchasing also uses FROM_TYPE_LOOKUP_CODE to indicate that you copied the quotation from an RFQ. 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 only uses BLANKET_TOTAL_AMOUNT for blanket purchase orders or contract purchase orders. 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. If APPROVED_FLAG is 'Y', the purchase order is approved. You can uniquely identify a row in PO_HEADERS_ALL using PRC_BU_ID, SEGMENT1, and TYPE_LOOKUP_CODE, or using PO_HEADER_ID. ![]() Different document types can share the same numbers. SEGMENT1 is not unique for the entire table. 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 the system-assigned number you use to identify the document in forms and reports. PO_HEADER_ID is the unique system-generated primary key and is invisible to the user. Oracle Purchasing uses this information to record information that is related to a complete document. Each row contains buyer information, supplier information, brief notes, foreign currency information, terms and conditions information, and the status of the document. There are six types of documents that use PO_HEADERS_ALL. You need one row for each document you create. PO_HEADERS_ALL contains header information for your purchasing documents. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |