PO_HEADERS_ALL
PO_HEADERS_ALL contains header information for your 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 and Contracts. Each row contains 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 PRC_BU_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. You enter document header information in the Header region of the Purchase Orders, RFQs, and Quotations windows.
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
PO_HEADERS_ALL_PK |
PO_HEADER_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
---|---|---|---|---|---|---|
PO_HEADER_ID | NUMBER | 18 | Yes | Document header unique identifier | ||
CHECKLIST_ID | NUMBER | 18 | Value that uniquely identifies the checklist on a Purchasing Document. | |||
SCHEDULE_GROUP | VARCHAR2 | 30 | User-defined value used as a criterion for scheduling order creation | |||
SIGNATURE_REQUIRED_FLAG | VARCHAR2 | 1 | Yes | Checkbox to indicate if signatures are required on the document before it can be opened. | ||
MODE_OF_TRANSPORT | VARCHAR2 | 30 | Type of transportation used to ship the product, such as truck, air or boat. | |||
SERVICE_LEVEL | VARCHAR2 | 30 | Priority of transportation that affects how quickly goods are transported | |||
BUYER_MANAGED_TRANSPORT_FLAG | VARCHAR2 | 1 | Yes | A flag to indicate that the buying company is responsible for arranging the transportation, from picking up the requested goods to delivering to ship-to locations specified on the order. The value is Y/N. | ||
BILLTO_BU_ID | NUMBER | 18 | Bill-to Business Unit unique identifier. This captures the business unit which vouches the supplier invoices received for a purchase order. | |||
SOLDTO_LE_ID | NUMBER | 18 | Sold to Legal Entity unique identifier. Indicates the party which is financially responsible for the purchases on a purchase order. | |||
DEFAULT_PO_TRADE_ORG_ID | NUMBER | 18 | Unique identifier for Purchasing Trade Organization. Purchasing Trade Organization is the inventory organization reporting to the Sold-to Legal Entity identified in a Purchase Order. This organization is used for cost accounting the transactions in the Sold-to Legal Entity. | |||
ORCHESTRATION_ORDER_FLAG | VARCHAR2 | 1 | Indicates whether this purchase order is an orchestrated purchase order. Valid values are Y/N. A value of 'Y' implies that this is an orchestrated order. A value of 'N' implies that this is not an orchestrated order. | |||
AGING_PERIOD_DAYS | NUMBER | 5 | Indicates the maximum number of days the material may be on consignment. It defaults a value for the same term on the document line. Only positive values are allowed. Applicable only to BPA. | |||
AGING_ONSET_POINT | VARCHAR2 | 30 | Indicates the mutually agreed event point at which consigned material begins to age. The possible values are None / Receipt / Shipment. Values from Lookups. Applicable only to BPA. | |||
CONSUMPTION_ADVICE_FREQUENCY | VARCHAR2 | 30 | Indicates the default value of the frequency at which the 'Create Consumption Advice' program will be run for all consumption transactions for consigned inventory purchased under this agreement. It defaults a value for the same term on the document line. The possible values are Daily / Weekly / Monthly. Values from Lookups. Applicable only to BPA. | |||
CONSUMPTION_ADVICE_SUMMARY | VARCHAR2 | 30 | Indicates the granularity at which consumption advices will be generated. The possible values are Inventory Organization / Item and Transaction Date / Inventory Organization and Item / Inventory Organization / All Inventory Organizations. Values from Lookups. Applicable only to BPA. | |||
BILLING_CYCLE_CLOSING_DATE | DATE | Field to capture when the current billing period for an agreement ends. This is applicable only for a BPA with consignment terms enabled. | ||||
LAST_BILLED_DATE | DATE | Field to capture when the consumption transaction on the agreement was last billed. | ||||
DEFAULT_CONSIGNMENT_LINE_FLAG | VARCHAR2 | 1 | Yes | Indicates the default value for the Consignment line attribute on the agreement line. Values: Y/N. Applicable only to BPA. | ||
PAY_ON_USE_FLAG | VARCHAR2 | 1 | Yes | This checkbox will indicate whether self-billing is enabled for consumption of consigned material. Values: Y/N. Applicable only to BPA. | ||
ACTIVE_VERSION_FLAG | VARCHAR2 | 1 | A flag to indicate whether the inital draft or change order of the document is still being processed (i.e incomplete status or in the middle of approval process) | |||
ACCEPTANCE_WITHIN_DAYS | NUMBER | Used for Acknowledge within days | ||||
AMOUNT_RELEASED | NUMBER | Amount released against this agreement - sum of all the approved standard PO amounts | ||||
LAST_RELEASE_DATE | DATE | Latest date on which a purchase order got implemented against this agreement | ||||
CURRENT_VERSION_ID | NUMBER | 18 | Current version of the Header | |||
GENERATE_ORDERS_AUTOMATIC | VARCHAR2 | 1 | Automatically Generate Orders flag | |||
SUBMIT_APPROVAL_AUTOMATIC | VARCHAR2 | 1 | Automatically Submit for Approval flag | |||
GROUP_REQUISITIONS | VARCHAR2 | 1 | Group Requisitions flag | |||
GROUP_REQUISITION_LINES | VARCHAR2 | 1 | Group Requisition Lines flag | |||
USE_NEED_BY_DATE | VARCHAR2 | 1 | Use need by date falg | |||
USE_SHIP_TO | VARCHAR2 | 1 | Use ship to organization and location flag | |||
DOCUMENT_STATUS | VARCHAR2 | 25 | Yes | Header status | ||
PRC_BU_ID | NUMBER | 18 | Yes | PRC_BU_ID | ||
REQ_BU_ID | NUMBER | 18 | REQ_BU_ID | |||
DEFAULT_TAXATION_COUNTRY | VARCHAR2 | 2 | The country for taxation for tax calculation purposes | |||
TAX_DOCUMENT_SUBTYPE | VARCHAR2 | 240 | Country Specific classification of the document used for tax calculation and reporting putposes | |||
AGENT_ID | NUMBER | 18 | Yes | Buyer unique identifier. (References PO_AGENTS.agent_id) | ||
TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Yes | Type of the document. (Combined with segment1and bu to form unique key; References PO_DOCUMENT_TYPES_ALL_B.document_subtype) | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
SEGMENT1 | VARCHAR2 | 30 | Yes | Key Flexfield: segment of the key flexfield. | ||
SUMMARY_FLAG | VARCHAR2 | 1 | Yes | Key Flexfield summary flag | ||
CARRIER_ID | NUMBER | 18 | Carrier ID (Party ID) | |||
ENABLED_FLAG | VARCHAR2 | 1 | Yes | Key Flexfield enabled flag | ||
SEGMENT2 | VARCHAR2 | 20 | Key Flexfield: segment of the key flexfield. | |||
SEGMENT3 | VARCHAR2 | 20 | Key Flexfield: segment of the key flexfield. | |||
SEGMENT4 | VARCHAR2 | 20 | Key Flexfield: segment of the key flexfield. | |||
SEGMENT5 | VARCHAR2 | 20 | Key Flexfield: segment of the key flexfield. | |||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
VENDOR_ID | NUMBER | 18 | Supplier unique identifier (References PO_VENDORS.vendor_id) | |||
VENDOR_SITE_ID | NUMBER | 18 | Supplier site unique identifier (References PO_VENDOR_SITES_ALL.vendor_site_id) | |||
VENDOR_CONTACT_ID | NUMBER | 18 | Supplier contact unique identifier (References PO_VENDOR_CONTACTS.vendor_contact_id) | |||
SHIP_TO_LOCATION_ID | NUMBER | 18 | Ship-to location unique identifier (References HR_LOCATIONS_ALL.location_id) | |||
BILL_TO_LOCATION_ID | NUMBER | 18 | Bill-to location unique identifier (References HR_LOCATIONS_ALL.location_id) | |||
TERMS_ID | NUMBER | 18 | Payment terms unique identifier (References to AP_TERMS_TL.term_id) | |||
FOB_LOOKUP_CODE | VARCHAR2 | 30 | Type of free-on-board terms for the document (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='FOB') | |||
FREIGHT_TERMS_LOOKUP_CODE | VARCHAR2 | 30 | Type of freight terms for the document (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='FREIGHT TERMS') | |||
CURRENCY_CODE | VARCHAR2 | 15 | Unique identifier for the currency (References FND_CURRENCIES.currency_code) | |||
RATE_TYPE | VARCHAR2 | 30 | Currency conversion rate type (References GL_DAILY_CONVERSION_TYPES.conversion_type) | |||
RATE_DATE | DATE | Currency conversion date | ||||
RATE | NUMBER | Currency conversion rate | ||||
FROM_HEADER_ID | NUMBER | 18 | Unique identifier of document from which this document is copied (References PO_HEADERS_ALL.po_header_id) | |||
FROM_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Document type of the document used to copy or autocreate another document (References: PO_DOCUMENT_TYPES_ALL_B.document_subtype) | |||
START_DATE | DATE | Effective date of the document | ||||
END_DATE | DATE | Expiration date of the document | ||||
BLANKET_TOTAL_AMOUNT | NUMBER | Amount agreed for the planned or blanket purchase order | ||||
REVISION_NUM | NUMBER | Document revision number | ||||
REVISED_DATE | DATE | Date the document was last revised | ||||
APPROVED_FLAG | VARCHAR2 | 1 | Indicates whether the purchase order is approved or not | |||
APPROVED_DATE | DATE | Date the purchase order was last approved | ||||
AMOUNT_LIMIT | NUMBER | Blanket, Planned PO or Contract only: Maximum amount that can be released | ||||
MIN_RELEASE_AMOUNT | NUMBER | Minimum amount that can be released against a blanket or planned purchase order | ||||
NOTE_TO_AUTHORIZER | VARCHAR2 | 1000 | Not currently used | |||
NOTE_TO_VENDOR | VARCHAR2 | 1000 | Note to the supplier | |||
NOTE_TO_RECEIVER | VARCHAR2 | 1000 | Note to the receiver of the purchase order | |||
VENDOR_ORDER_NUM | VARCHAR2 | 25 | Indicates supplier document number, it gets copied from PO_HEADERS_INTERFACE.vendor_doc_num | |||
CONFIRMING_ORDER_FLAG | VARCHAR2 | 1 | Indicates whether the purchase order is a confirming order or not | |||
COMMENTS | VARCHAR2 | 240 | Descriptive comments for the document | |||
ACCEPTANCE_REQUIRED_FLAG | VARCHAR2 | 1 | Indicates whether acceptance from the supplier is required or not | |||
ACCEPTANCE_DUE_DATE | DATE | Date by which the supplier should accept the purchase order | ||||
CLOSED_DATE | DATE | Date the document was closed | ||||
CANCEL_FLAG | VARCHAR2 | 1 | Indicates whether the purchase order is cancelled or not | |||
FIRM_STATUS_LOOKUP_CODE | VARCHAR2 | 30 | Indicates whether you want to prevent this purchase order from being automatically rescheduled by your manufacturing application | |||
FIRM_DATE | DATE | Date from which the purchase order is firmed | ||||
FROZEN_FLAG | VARCHAR2 | 1 | Indicates whether the document is frozen or not | |||
EDI_PROCESSED_FLAG | VARCHAR2 | 1 | EDI processed flag | |||
EDI_PROCESSED_STATUS | VARCHAR2 | 10 | EDI processing status flag | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
GOVERNMENT_CONTEXT | VARCHAR2 | 30 | USSGL descriptive flexfield context column | |||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | |||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | |||
PROGRAM_NAME | VARCHAR2 | 30 | PROGRAM_NAME | |||
PROGRAM_APP_NAME | VARCHAR2 | 50 | PROGRAM_APP_NAME | |||
SOLDTO_BU_ID | NUMBER | 18 | Sold to Business Unit Unique Identifier | |||
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
INTERFACE_SOURCE_CODE | VARCHAR2 | 25 | Identifier for upstream integrating module. Reserved for internal use. | |||
REFERENCE_NUM | VARCHAR2 | 120 | Audit trail reference (needed for 832 EDI transaction) | |||
PCARD_ID | NUMBER | 18 | Unique identifer for the procurement card used for the order (References AP_CARDS_ALL.card_id) | |||
PRICE_UPDATE_TOLERANCE | NUMBER | Maximum percentage increase allowed in price/sales catalog update (832 EDI transaction) sent by supplier | ||||
PAY_ON_CODE | VARCHAR2 | 25 | Indicator of whether the purchase order will be paid upon receipt (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='PAY ON CODE') | |||
XML_FLAG | VARCHAR2 | 3 | Indicator whether the delivery option is through XML. Y if so. | |||
XML_SEND_DATE | DATE | Date on which XML document is created, if XML delivery is used. | ||||
XML_CHANGE_SEND_DATE | DATE | Date on which the po change XML document generation date, if delivery option is XML. | ||||
CONSIGNED_CONSUMPTION_FLAG | VARCHAR2 | 1 | Flag indicates that the purchase order is a consumption advice | |||
CBC_ACCOUNTING_DATE | DATE | Column used to store the accounting action date for dual budgetary control functionality. | ||||
CONSUME_REQ_DEMAND_FLAG | VARCHAR2 | 1 | Used by Oracle Sourcing- Tells whether user wanted to consume the req demand when creating a blanket | |||
CHANGE_REQUESTED_BY | VARCHAR2 | 20 | Change Requested By will track changes to Purchase Document from Supplier/ Requester | |||
SHIPPING_CONTROL | VARCHAR2 | 30 | Indicator of who is responsible for arranging transportation (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='SHIPPING CONTROL') | |||
CONTERMS_EXIST_FLAG | VARCHAR2 | 1 | Indicates if contract terms template is attached to the purchasing document or not. Applicable to Purchasing document of type Standard, Contract, Blanket | |||
CONTERMS_ARTICLES_UPD_DATE | DATE | Timestamp for the last update to Contract Clauses. Applicable to Purchasing document of type Standard, Contract, Blanket | ||||
CONTERMS_DELIV_UPD_DATE | DATE | Timestamp for the last update to Contract Deliverables. Applicable to Purchasing document of type Standard, Contract, Blanket | ||||
PENDING_SIGNATURE_FLAG | VARCHAR2 | 1 | Indicates if the purchasing document is waiting for the signatures or not. Applicable to Purchasing document of type Standard, Contract, Blanket | |||
CHANGE_SUMMARY | VARCHAR2 | 2000 | Description of changes made. This information is entered by the Buyer when submitting the document for approval and may be used in generating an amendment document. | |||
ENCUMBRANCE_REQUIRED_FLAG | VARCHAR2 | 1 | Blanket or Global Agreement only: Indicates whether the document is to be encumbred or not | |||
DOCUMENT_CREATION_METHOD | VARCHAR2 | 30 | Method in which the document got created - Autocreate, enter PO , etc... | |||
SUBMIT_DATE | DATE | Date when document was first submitted for approval | ||||
SUPPLIER_NOTIF_METHOD | VARCHAR2 | 25 | Supplier Notification Method | |||
FAX | VARCHAR2 | 60 | Supplier Fax Number | |||
EMAIL_ADDRESS | VARCHAR2 | 2000 | Email address of the supplier for communication | |||
USE_ORDER_DATE_IN_PRICING_FLAG | VARCHAR2 | 1 | This flag on the agreement indicates whether or not the order date should be used to derive price on the orders referencing the agreement | |||
RETRO_PRICE_COMM_UPDATES_FLAG | VARCHAR2 | 1 | This flag on the agreement indicates whether or not orders that were repriced because of a price change on the referenced agreement should be communicated to the supplier. | |||
RETRO_PRICE_APPLY_UPDATES_FLAG | VARCHAR2 | 1 | This flag on the agreement indicates whether or not price updates on the agreement should be propagated to orders referencing the agreement. | |||
UPDATE_SOURCING_RULES_FLAG | VARCHAR2 | 1 | Update sourcing rules flag | |||
AUTO_SOURCING_FLAG | VARCHAR2 | 1 | Enable automatic sourcing flag | |||
CREATED_LANGUAGE | VARCHAR2 | 4 | Language code in which the GBPA was created. | |||
CPA_REFERENCE | NUMBER | 18 | This is to support the iP catalog upgrade for items that had a CPA reference prior to Release 12. This column is just for information purpose. | |||
STYLE_ID | NUMBER | 18 | Yes | Determines the Purchasing Style of the document. | ||
TAX_ATTRIBUTE_UPDATE_CODE | VARCHAR2 | 15 | Keeps track of create/update actions on this entity | |||
LAST_UPDATED_PROGRAM | VARCHAR2 | 255 | The program name that last updated the row. | |||
CAT_ADMIN_AUTH_ENABLED_FLAG | VARCHAR2 | 1 | Cat Admin Auth Enabled Flag | |||
RELEASE_METHOD | VARCHAR2 | 25 | Release Method for ASL creation (Only for PA) | |||
REVIEW_AUTOGENERATED_RELEASES | VARCHAR2 | 25 | Review Autogenerated Releases(Only for PA) | |||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
MERGE_REQUEST_ID | NUMBER | 18 | Merge Request ID Unique Identifier(References POZ_SUPPLIER_MERGE_REQUESTS.merge_request_id) | |||
USE_SALES_ORDER_NUMBER_FLAG | VARCHAR2 | 1 | Indicates whether requisition lines should be grouped by Sales Order Number to create distinct purchase order. | |||
FUNDS_STATUS | VARCHAR2 | 25 | status to indicate whether funds have been reserved on the document or not | |||
FIRST_PTY_REG_ID | NUMBER | 18 | First Party Tax Registration ID for the transaction. | |||
THIRD_PTY_REG_ID | NUMBER | 18 | Third Party Tax Registration ID for the transaction. | |||
DISABLE_AUTOSOURCING_FLAG | VARCHAR2 | 1 | Disable Automatic Sourcing Flag | |||
PUNCHOUT_SOURCING_ONLY_FLAG | VARCHAR2 | 1 | Automatic Sourcing of Punchout Requests Only | |||
BUDGET_CONTROL_ENABLED_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate if Budgetary conrol was enabled at the time of Purchase Order creation. Not applicable to Agreements. | ||
RETRO_PRICE_OPEN_ORDER_FLAG | VARCHAR2 | 1 | This flag on the agreement indicates whether or not the retroactive price update background process should only reprice open unfulfilled orders referencing the agreement. | |||
RETRO_PRICE_INIT_APPROVAL_FLAG | VARCHAR2 | 1 | This flag on the agreement indicates whether or not the retroactive price update background process should be initiated upon agreement approval. | |||
REBUILD_INDEX | VARCHAR2 | 1 | This column has an oracle text domain index defined to support keyword search. | |||
REFRESH_INDEX | VARCHAR2 | 1 | This column is updated anytime new document is created or an existing one is changed. Based on update to this column value, REBUILD INDEX is updated via ESS. | |||
ALLOW_MULTIPLE_SITES_FLAG | VARCHAR2 | 1 | Yes | A flag to indicate that an agreement can be used across all supplier sites for a given supplier. | ||
USE_SHIP_TO_FOR_GROUP_REQS | VARCHAR2 | 1 | Yes | Checkbox to indicate whether to use ship-to organization and location when grouping requisitions | ||
MASTER_CONTRACT_ID | NUMBER | 18 | The Master Contract Identifier. The master contract refers to the general contract that primarily serves to set the terms and conditions between parties at a high level that govern subsequent, more specific, contractual agreements. | |||
CC_EMAIL_ADDRESS | VARCHAR2 | 2000 | Email address to which a copy of the email is sent | |||
BCC_EMAIL_ADDRESS | VARCHAR2 | 2000 | Email address to which a copy of the email is sent without letting other recipients know | |||
OVERRIDING_APPROVER_ID | NUMBER | 18 | Overriding approver on purchase orders and change orders for approval routing. | |||
SKIP_ELECTRONIC_COMM_FLAG | VARCHAR2 | 1 | Indicates whether electronic communication should be skipped | |||
ALT_CONTACT_EMAIL_ADDRESS | VARCHAR2 | 2000 | Alternate Supplier Contact Email address of the supplier for communication | |||
SOURCING_PRIORITY | NUMBER | Indicates the numerical value to determine the sourcing priority. Applicable only to BPA. | ||||
SH_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Segment used to identify the special handling context for special handling purchase order headers. | |||
SH_ATTRIBUTE1 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE2 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE3 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE4 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE5 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE6 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE7 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE8 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE9 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE10 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE11 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE12 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE13 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE14 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE15 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE16 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE17 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE18 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE19 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE20 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE_NUMBER1 | NUMBER | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_NUMBER2 | NUMBER | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_NUMBER3 | NUMBER | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_NUMBER4 | NUMBER | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_NUMBER5 | NUMBER | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_NUMBER6 | NUMBER | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_NUMBER7 | NUMBER | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_NUMBER8 | NUMBER | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_NUMBER9 | NUMBER | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_NUMBER10 | NUMBER | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_DATE1 | DATE | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_DATE2 | DATE | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_DATE3 | DATE | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_DATE4 | DATE | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_DATE5 | DATE | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_DATE6 | DATE | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_DATE7 | DATE | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_DATE8 | DATE | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_DATE9 | DATE | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_DATE10 | DATE | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SPECIAL_HANDLING_TYPE_CODE | VARCHAR2 | 30 | Special handling type of the document. (References PO_SPCL_HANDLING_TYPES_B.SPECIAL_HANDLING_TYPE_CODE) |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
PO_HEADERS_ALL | poz_suppliers | VENDOR_ID |
PO_HEADERS_ALL | poz_supplier_merge_requests | MERGE_REQUEST_ID |
PO_HEADERS_ALL | gl_daily_conversion_types | RATE_TYPE |
po_attribute_values | po_headers_all | PO_HEADER_ID |
por_doc_upload_jobs | po_headers_all | PO_HEADER_ID |
po_recent_activities | po_headers_all | OBJECT_ID |
pon_bid_po_numbers | po_headers_all | PO_HEADER_ID |
po_distributions_archive_all | po_headers_all | PO_HEADER_ID |
pon_bid_po_numbers_history | po_headers_all | PO_HEADER_ID |
rcv_transactions | po_headers_all | PO_HEADER_ID |
po_lines_archive_all | po_headers_all | PO_HEADER_ID |
po_lines_archive_all | po_headers_all | FROM_HEADER_ID |
po_line_locations_all | po_headers_all | PO_HEADER_ID |
po_line_locations_all | po_headers_all | FROM_HEADER_ID |
po_ga_org_assignments | po_headers_all | PO_HEADER_ID |
inv_supply | po_headers_all | PO_HEADER_ID |
inv_cons_advice_headers | po_headers_all | AGREEMENT_HEADER_ID |
ap_invoice_lines_all | po_headers_all | PO_HEADER_ID |
rcv_supply | po_headers_all | PO_HEADER_ID |
rcv_transactions_interface | po_headers_all | PO_HEADER_ID |
po_notification_ctrl_archive | po_headers_all | PO_HEADER_ID |
ap_invoice_lines_interface | po_headers_all | PO_HEADER_ID |
po_notification_controls | po_headers_all | PO_HEADER_ID |
rcv_shipment_lines | po_headers_all | PO_HEADER_ID |
po_lines_all | po_headers_all | PO_HEADER_ID |
po_lines_all | po_headers_all | FROM_HEADER_ID |
ap_invoices_all | po_headers_all | PO_HEADER_ID |
po_lines_draft_all | po_headers_all | FROM_HEADER_ID |
po_line_locations_archive_all | po_headers_all | PO_HEADER_ID |
po_line_locations_archive_all | po_headers_all | FROM_HEADER_ID |
por_smart_forms_all_b | po_headers_all | AGREEMENT_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
PO_HEADERS_F2 | Non Unique | Default | UPPER("SEGMENT1"), BILLTO_BU_ID |
PO_HEADERS_F3 | Non Unique | Default | UPPER("VENDOR_ORDER_NUM") |
PO_HEADERS_N1 | Non Unique | Default | VENDOR_ID, VENDOR_SITE_ID, TYPE_LOOKUP_CODE |
PO_HEADERS_N10 | Non Unique | Default | STYLE_ID |
PO_HEADERS_N11 | Non Unique | Default | DOCUMENT_STATUS, TYPE_LOOKUP_CODE, PRC_BU_ID, SOLDTO_LE_ID |
PO_HEADERS_N12 | Non Unique | Default | CAT_ADMIN_AUTH_ENABLED_FLAG |
PO_HEADERS_N13 | Non Unique | Default | ACTIVE_VERSION_FLAG, AGENT_ID |
PO_HEADERS_N14 | Non Unique | Default | AGENT_ID, TYPE_LOOKUP_CODE, END_DATE |
PO_HEADERS_N15 | Non Unique | Default | CARRIER_ID |
PO_HEADERS_N16 | Non Unique | Default | PRC_BU_ID, REQ_BU_ID, TYPE_LOOKUP_CODE, DOCUMENT_STATUS |
PO_HEADERS_N17 | Non Unique | Default | CHECKLIST_ID |
PO_HEADERS_N2 | Non Unique | Default | CREATION_DATE |
PO_HEADERS_N3 | Non Unique | Default | AGENT_ID, DOCUMENT_STATUS |
PO_HEADERS_N4 | Non Unique | Default | FROM_HEADER_ID |
PO_HEADERS_N6 | Non Unique | Default | CLOSED_DATE |
PO_HEADERS_N8 | Non Unique | Default | VENDOR_ORDER_NUM |
PO_HEADERS_N9 | Non Unique | Default | LAST_UPDATE_DATE |
PO_HEADERS_U1 | Unique | Default | PO_HEADER_ID |
PO_HEADERS_U2 | Unique | Default | SEGMENT1, TYPE_LOOKUP_CODE, CASE WHEN "TYPE_LOOKUP_CODE" = 'STANDARD' THEN "SOLDTO_LE_ID" ELSE "PRC_BU_ID" END |
PO_SEARCH_INDEX | Non Unique | Default | REBUILD_INDEX |