Constraints, indexes, Table Structure

PO_HEADERS_ALL: PO Table Columns & Indexes

Mohit Saxena

PO_HEADERS_ALL is the base table used by Oracle Fusion to store the Purchase Order Header data. in this blog we will discuss the table structure, indexes and constraints of the table. But in case you are interested in getting the query to fetch the purchase order details, please click here.

Also PO_HEADERS_ALL table is the parent table of PO_LINES_ALL table which is used to store the line level details of a purchase order.

By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports or SQL queries. Try them only when nothing else works.. kind of SOS...
https://www.amazon.in/gp/product/B093CC1CLD?ie=UTF8&tag=oraclebytes-21&camp=3638&linkCode=xm2&creativeASIN=B093CC1CLD

PO_HEADERS_ALL Table Structure

COLUMN_NAMEDATA_TYPENULLABLE
 PO_HEADER_IDNUMBERN 
 SCHEDULE_GROUPVARCHAR2(120)Y 
 SIGNATURE_REQUIRED_FLAGVARCHAR2(4)N 
 MODE_OF_TRANSPORTVARCHAR2(120)Y 
 SERVICE_LEVELVARCHAR2(120)Y 
 BUYER_MANAGED_TRANSPORT_FLAGVARCHAR2(4)N 
 BILLTO_BU_IDNUMBERY 
 SOLDTO_LE_IDNUMBERY 
 DEFAULT_PO_TRADE_ORG_IDNUMBERY 
 ORCHESTRATION_ORDER_FLAGVARCHAR2(4)Y 
 AGING_PERIOD_DAYSNUMBERY 
 AGING_ONSET_POINTVARCHAR2(120)Y 
 CONSUMPTION_ADVICE_FREQUENCYVARCHAR2(120)Y 
 CONSUMPTION_ADVICE_SUMMARYVARCHAR2(120)Y 
 BILLING_CYCLE_CLOSING_DATEDATEY 
 LAST_BILLED_DATEDATEY 
 DEFAULT_CONSIGNMENT_LINE_FLAGVARCHAR2(4)N 
 PAY_ON_USE_FLAGVARCHAR2(4)N 
 ACTIVE_VERSION_FLAGVARCHAR2(4)Y 
 ACCEPTANCE_WITHIN_DAYSNUMBERY 
 AMOUNT_RELEASEDNUMBERY 
 LAST_RELEASE_DATEDATEY 
 CURRENT_VERSION_IDNUMBERY 
 GENERATE_ORDERS_AUTOMATICVARCHAR2(4)Y 
 SUBMIT_APPROVAL_AUTOMATICVARCHAR2(4)Y 
 GROUP_REQUISITIONSVARCHAR2(4)Y 
 GROUP_REQUISITION_LINESVARCHAR2(4)Y 
 USE_NEED_BY_DATEVARCHAR2(4)Y 
 USE_SHIP_TOVARCHAR2(4)Y 
 DOCUMENT_STATUSVARCHAR2(100)N 
 PRC_BU_IDNUMBERN 
 REQ_BU_IDNUMBERY 
 DEFAULT_TAXATION_COUNTRYVARCHAR2(8)Y 
 TAX_DOCUMENT_SUBTYPEVARCHAR2(960)Y 
 AGENT_IDNUMBERN 
 TYPE_LOOKUP_CODEVARCHAR2(100)N 
 LAST_UPDATE_DATETIMESTAMP(6)N 
 LAST_UPDATED_BYVARCHAR2(256)N 
 SEGMENT1VARCHAR2(120)N 
 SUMMARY_FLAGVARCHAR2(4)N 
 CARRIER_IDNUMBERY 
 ENABLED_FLAGVARCHAR2(4)N 
 SEGMENT2VARCHAR2(80)Y 
 SEGMENT3VARCHAR2(80)Y 
 SEGMENT4VARCHAR2(80)Y 
 SEGMENT5VARCHAR2(80)Y 
 LAST_UPDATE_LOGINVARCHAR2(128)Y 
 CREATION_DATETIMESTAMP(6)N 
 CREATED_BYVARCHAR2(256)N 
 VENDOR_IDNUMBERY 
 VENDOR_SITE_IDNUMBERY 
 VENDOR_CONTACT_IDNUMBERY 
 SHIP_TO_LOCATION_IDNUMBERY 
 BILL_TO_LOCATION_IDNUMBERY 
 TERMS_IDNUMBERY 
 FOB_LOOKUP_CODEVARCHAR2(120)Y 
 FREIGHT_TERMS_LOOKUP_CODEVARCHAR2(120)Y 
 CURRENCY_CODEVARCHAR2(60)Y 
 RATE_TYPEVARCHAR2(120)Y 
 RATE_DATEDATEY 
 RATENUMBERY 
 FROM_HEADER_IDNUMBERY 
 FROM_TYPE_LOOKUP_CODEVARCHAR2(100)Y 
 START_DATEDATEY 
 END_DATEDATEY 
 BLANKET_TOTAL_AMOUNTNUMBERY 
 REVISION_NUMNUMBERY 
 REVISED_DATEDATEY 
 APPROVED_FLAGVARCHAR2(4)Y 
 APPROVED_DATEDATEY 
 AMOUNT_LIMITNUMBERY 
 MIN_RELEASE_AMOUNTNUMBERY 
 NOTE_TO_AUTHORIZERVARCHAR2(4000)Y 
 NOTE_TO_VENDORVARCHAR2(4000)Y 
 NOTE_TO_RECEIVERVARCHAR2(4000)Y 
 VENDOR_ORDER_NUMVARCHAR2(100)Y 
 CONFIRMING_ORDER_FLAGVARCHAR2(4)Y 
 COMMENTSVARCHAR2(960)Y 
 ACCEPTANCE_REQUIRED_FLAGVARCHAR2(4)Y 
 ACCEPTANCE_DUE_DATEDATEY 
 CLOSED_DATEDATEY 
 CANCEL_FLAGVARCHAR2(4)Y 
 FIRM_STATUS_LOOKUP_CODEVARCHAR2(120)Y 
 FIRM_DATEDATEY 
 FROZEN_FLAGVARCHAR2(4)Y 
 EDI_PROCESSED_FLAGVARCHAR2(4)Y 
 EDI_PROCESSED_STATUSVARCHAR2(40)Y 
 ATTRIBUTE_CATEGORYVARCHAR2(120)Y 
 ATTRIBUTE1- ATTRIBUTE20VARCHAR2(600)Y 
 ATTRIBUTE_NUMBER1- ATTRIBUTE_NUMBER10NUMBERY 
 ATTRIBUTE_DATE1- ATTRIBUTE_DATE10DATEY 
 ATTRIBUTE_TIMESTAMP1- ATTRIBUTE_TIMESTAMP10TIMESTAMP(6)Y 
 GOVERNMENT_CONTEXTVARCHAR2(120)Y 
 REQUEST_IDNUMBERY 
 JOB_DEFINITION_NAMEVARCHAR2(400)Y 
 JOB_DEFINITION_PACKAGEVARCHAR2(3600)Y 
 PROGRAM_NAMEVARCHAR2(120)Y 
 PROGRAM_APP_NAMEVARCHAR2(200)Y 
 SOLDTO_BU_IDNUMBERY 
 GLOBAL_ATTRIBUTE_CATEGORYVARCHAR2(600)Y 
 GLOBAL_ATTRIBUTE1- GLOBAL_ATTRIBUTE20VARCHAR2(600)Y 
 GLOBAL_ATTRIBUTE_DATE1 – GLOBAL_ATTRIBUTE_DATE5DATEY 
 GLOBAL_ATTRIBUTE_NUMBER1 –  GLOBAL_ATTRIBUTE_NUMBER5NUMBERY 
 INTERFACE_SOURCE_CODEVARCHAR2(100)Y 
 REFERENCE_NUMVARCHAR2(480)Y 
 PCARD_IDNUMBERY 
 PRICE_UPDATE_TOLERANCENUMBERY 
 PAY_ON_CODEVARCHAR2(100)Y 
 XML_FLAGVARCHAR2(12)Y 
 XML_SEND_DATEDATEY 
 XML_CHANGE_SEND_DATEDATEY 
 CONSIGNED_CONSUMPTION_FLAGVARCHAR2(4)Y 
 CBC_ACCOUNTING_DATEDATEY 
 CONSUME_REQ_DEMAND_FLAGVARCHAR2(4)Y 
 CHANGE_REQUESTED_BYVARCHAR2(80)Y 
 SHIPPING_CONTROLVARCHAR2(120)Y 
 CONTERMS_EXIST_FLAGVARCHAR2(4)Y 
 CONTERMS_ARTICLES_UPD_DATEDATEY 
 CONTERMS_DELIV_UPD_DATEDATEY 
 PENDING_SIGNATURE_FLAGVARCHAR2(4)Y 
 CHANGE_SUMMARYVARCHAR2(4000)Y 
 ENCUMBRANCE_REQUIRED_FLAGVARCHAR2(4)Y 
 DOCUMENT_CREATION_METHODVARCHAR2(120)Y 
 SUBMIT_DATEDATEY 
 SUPPLIER_NOTIF_METHODVARCHAR2(100)Y 
 FAXVARCHAR2(240)Y 
 EMAIL_ADDRESSVARCHAR2(4000)Y 
 RETRO_PRICE_COMM_UPDATES_FLAGVARCHAR2(4)Y 
 RETRO_PRICE_APPLY_UPDATES_FLAGVARCHAR2(4)Y 
 UPDATE_SOURCING_RULES_FLAGVARCHAR2(4)Y 
 AUTO_SOURCING_FLAGVARCHAR2(4)Y 
 CREATED_LANGUAGEVARCHAR2(16)Y 
 CPA_REFERENCENUMBERY 
 STYLE_IDNUMBERN 
 TAX_ATTRIBUTE_UPDATE_CODEVARCHAR2(60)Y 
 LAST_UPDATED_PROGRAMVARCHAR2(1020)Y 
 CAT_ADMIN_AUTH_ENABLED_FLAGVARCHAR2(4)Y 
 RELEASE_METHODVARCHAR2(100)Y 
 REVIEW_AUTOGENERATED_RELEASESVARCHAR2(100)Y 
 OBJECT_VERSION_NUMBERNUMBERN 
 MERGE_REQUEST_IDNUMBERY 
 USE_SALES_ORDER_NUMBER_FLAGVARCHAR2(4)Y 
 FUNDS_STATUSVARCHAR2(100)Y 
 FIRST_PTY_REG_IDNUMBERY 
 THIRD_PTY_REG_IDNUMBERY 
 DISABLE_AUTOSOURCING_FLAGVARCHAR2(4)Y 
 PUNCHOUT_SOURCING_ONLY_FLAGVARCHAR2(4)Y 
 BUDGET_CONTROL_ENABLED_FLAGVARCHAR2(4)N 
 RETRO_PRICE_OPEN_ORDER_FLAGVARCHAR2(4)Y 
 RETRO_PRICE_INIT_APPROVAL_FLAGVARCHAR2(4)Y 
 REBUILD_INDEXVARCHAR2(4)Y 
 REFRESH_INDEXVARCHAR2(4)Y 
 ALLOW_MULTIPLE_SITES_FLAGVARCHAR2(4)N 
 USE_SHIP_TO_FOR_GROUP_REQSVARCHAR2(4)N 
 MASTER_CONTRACT_IDNUMBERY 
PO_HEADERS_ALL Table Columns

PO_HEADERS_ALL Indexes

INDEX_NAMEINDEX_TYPEUNIQUENESSCOLUMN_NAME
 PO_HEADERS_F2FUNCTION-BASED NORMALNONUNIQUESYS_NC00229$
 PO_HEADERS_F2FUNCTION-BASED NORMALNONUNIQUEBILLTO_BU_ID
 PO_HEADERS_F3FUNCTION-BASED NORMALNONUNIQUESYS_NC00216$
 PO_HEADERS_N1NORMALNONUNIQUEVENDOR_ID
 PO_HEADERS_N1NORMALNONUNIQUEVENDOR_SITE_ID
 PO_HEADERS_N1NORMALNONUNIQUETYPE_LOOKUP_CODE
 PO_HEADERS_N10NORMALNONUNIQUESTYLE_ID
 PO_HEADERS_N11NORMALNONUNIQUEDOCUMENT_STATUS
 PO_HEADERS_N11NORMALNONUNIQUETYPE_LOOKUP_CODE
 PO_HEADERS_N11NORMALNONUNIQUEPRC_BU_ID
 PO_HEADERS_N11NORMALNONUNIQUESOLDTO_LE_ID
 PO_HEADERS_N12NORMALNONUNIQUECAT_ADMIN_AUTH_ENABLED_FLAG
 PO_HEADERS_N13NORMALNONUNIQUEACTIVE_VERSION_FLAG
 PO_HEADERS_N13NORMALNONUNIQUEAGENT_ID
 PO_HEADERS_N14NORMALNONUNIQUEAGENT_ID
 PO_HEADERS_N14NORMALNONUNIQUETYPE_LOOKUP_CODE
 PO_HEADERS_N14NORMALNONUNIQUEEND_DATE
 PO_HEADERS_N15NORMALNONUNIQUECARRIER_ID
 PO_HEADERS_N16NORMALNONUNIQUEPRC_BU_ID
 PO_HEADERS_N16NORMALNONUNIQUEREQ_BU_ID
 PO_HEADERS_N16NORMALNONUNIQUETYPE_LOOKUP_CODE
 PO_HEADERS_N16NORMALNONUNIQUEDOCUMENT_STATUS
 PO_HEADERS_N2NORMALNONUNIQUECREATION_DATE
 PO_HEADERS_N3NORMALNONUNIQUEAGENT_ID
 PO_HEADERS_N3NORMALNONUNIQUEDOCUMENT_STATUS
 PO_HEADERS_N4NORMALNONUNIQUEFROM_HEADER_ID
 PO_HEADERS_N6NORMALNONUNIQUECLOSED_DATE
 PO_HEADERS_N8NORMALNONUNIQUEVENDOR_ORDER_NUM
 PO_HEADERS_N9NORMALNONUNIQUELAST_UPDATE_DATE
 PO_HEADERS_U1NORMALUNIQUEPO_HEADER_ID
 PO_HEADERS_U2FUNCTION-BASED NORMALUNIQUESEGMENT1
 PO_HEADERS_U2FUNCTION-BASED NORMALUNIQUETYPE_LOOKUP_CODE
 PO_HEADERS_U2FUNCTION-BASED NORMALUNIQUESYS_NC00231$
 PO_SEARCH_INDEXDOMAINNONUNIQUEREBUILD_INDEX

Related Posts:

Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.

Reference:
support.oracle.com

po_headers_all, Purchase Order


Check out the Amazon Deals of the day based on your interests..

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

2 thoughts on “PO_HEADERS_ALL: PO Table Columns & Indexes”

  1. Pingback: PO_LINES_ALL: Table Structure & Indexes - Oracle Bytes
  2. Pingback: PO_DISTRIBUTIONS_ALL: Table Structure & Indexes - Oracle Bytes

Comments are closed.