[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PO_HEADERS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | PO |
| FND Design Data: |  PO.PO_HEADERS_ALL
|
| Subobject Name: | |
| Status: | VALID |
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:
.
{{"bul:1"}}RFQs
.
{{"bul:1"}}Quotations
.
{{"bul:1"}}Standard purchase orders
.
{{"bul:1"}}Planned purchase orders
.
{{"bul:1"}}Blanket purchase orders
.
{{"bul:1"}}Contracts
.
{{"bodytext"}}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 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.
.
You enter document header information in the Header region of the
Purchase Orders, RFQs, and Quotations windows.
.
.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PO_HEADERS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PO_HEADER_ID
|
| PO_HEADERS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
SEGMENT1
TYPE_LOOKUP_CODE
ORG_ID
|
| PO_HEADERS_F1 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DECODE("CONSIGNED_CONSUMPTION_FLAG",'Y',DECODE("CLOSED_CODE",'FINALLY CLOSED',NULL,'Y'),NULL)
|
| PO_HEADERS_F2 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
NVL("AUTHORIZATION_STATUS",'INCOMPLETE')
|
| PO_HEADERS_F3 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
UPPER("SEGMENT1")
|
| PO_HEADERS_F5 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
NVL("CLM_DOCUMENT_NUMBER","SEGMENT1")
|
| PO_HEADERS_F6 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
UPPER(NVL("CLM_DOCUMENT_NUMBER","SEGMENT1"))
|
| PO_HEADERS_F7 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DECODE(RTRIM("SEGMENT1",'0123456789'),NULL,TO_NUMBER("SEGMENT1"),(-1))
|
| PO_HEADERS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
VENDOR_ID
VENDOR_SITE_ID
TYPE_LOOKUP_CODE
|
| PO_HEADERS_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
STYLE_ID
|
| PO_HEADERS_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
AUTHORIZATION_STATUS
|
| PO_HEADERS_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ENCUMBRANCE_REQUIRED_FLAG
|
| PO_HEADERS_N13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
UDA_TEMPLATE_ID
|
| PO_HEADERS_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
AME_APPROVAL_ID
|
| PO_HEADERS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CREATION_DATE
|
| PO_HEADERS_N20 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
OTM_RECOVERY_FLAG
|
| PO_HEADERS_N21 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CLM_DOCUMENT_NUMBER
|
| PO_HEADERS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
AGENT_ID
AUTHORIZATION_STATUS
|
| PO_HEADERS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FROM_HEADER_ID
|
| PO_HEADERS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
WF_ITEM_TYPE
WF_ITEM_KEY
|
| PO_HEADERS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CLOSED_DATE
|
| PO_HEADERS_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
QUOTE_VENDOR_QUOTE_NUMBER
|
| PO_HEADERS_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
VENDOR_ORDER_NUM
|
| PO_HEADERS_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LAST_UPDATE_DATE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PO_HEADER_ID | NUMBER | Yes | Document header unique identifier | |
| AGENT_ID | NUMBER | (9) | Yes | Buyer unique identifier. (References PO_AGENTS.agent_id) |
| TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Yes | Type of the document. (Combined with segment1and org_id to form unique key; References PO_DOCUMENT_TYPES_ALL_B.document_subtype) |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| SEGMENT1 | VARCHAR2 | (20) | Yes | Key flexfield segment |
| SUMMARY_FLAG | VARCHAR2 | (1) | Yes | Key Flexfield summary flag |
| ENABLED_FLAG | VARCHAR2 | (1) | Yes | Key Flexfield enabled flag |
| SEGMENT2 | VARCHAR2 | (20) | Key flexfield segment | |
| SEGMENT3 | VARCHAR2 | (20) | Key flexfield segment | |
| SEGMENT4 | VARCHAR2 | (20) | Key flexfield segment | |
| SEGMENT5 | VARCHAR2 | (20) | Key flexfield segment | |
| START_DATE_ACTIVE | DATE | Key Flexfield start date | ||
| END_DATE_ACTIVE | DATE | Key Flexfield end date | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
| VENDOR_ID | NUMBER | Supplier unique identifier (References PO_VENDORS.vendor_id) | ||
| VENDOR_SITE_ID | NUMBER | Supplier site unique identifier (References PO_VENDOR_SITES_ALL.vendor_site_id) | ||
| VENDOR_CONTACT_ID | NUMBER | Supplier contact unique identifier (References PO_VENDOR_CONTACTS.vendor_contact_id) | ||
| SHIP_TO_LOCATION_ID | NUMBER | Ship-to location unique identifier (References HR_LOCATIONS_ALL.location_id) | ||
| BILL_TO_LOCATION_ID | NUMBER | Bill-to location unique identifier (References HR_LOCATIONS_ALL.location_id) | ||
| TERMS_ID | NUMBER | Payment terms unique identifier (References to AP_TERMS_TL.term_id) | ||
| SHIP_VIA_LOOKUP_CODE | VARCHAR2 | (25) | Type of carrier to be used (References ORG_FREIGHT_TL.freight_code) | |
| FOB_LOOKUP_CODE | VARCHAR2 | (25) | Type of free-on-board terms for the document (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='FOB') | |
| FREIGHT_TERMS_LOOKUP_CODE | VARCHAR2 | (25) | Type of freight terms for the document (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='FREIGHT TERMS') | |
| STATUS_LOOKUP_CODE | VARCHAR2 | (25) | Status of the RFQ or Quotation (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='RFQ/QUOTE STATUS') | |
| 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 | Unique identifier of the quotation (standard or planned POs only) or global agreement (standard POs only) referenced by this line (References PO_HEADERS_ALL.po_header_id) | ||
| FROM_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Document type of the document used to 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 | ||
| AUTHORIZATION_STATUS | VARCHAR2 | (25) | Authorization status of the purchase order (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='AUTHORIZATION STATUS') | |
| 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 | (240) | Not currently used | |
| NOTE_TO_VENDOR | VARCHAR2 | (480) | Note to the supplier | |
| NOTE_TO_RECEIVER | VARCHAR2 | (480) | Note to the receiver of the purchase order | |
| PRINT_COUNT | NUMBER | Number of times the document was printed | ||
| PRINTED_DATE | DATE | Date the document was last printed | ||
| 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 | |
| REPLY_DATE | DATE | RFQ and Quotation only: Date the supplier replied to the RFQ | ||
| REPLY_METHOD_LOOKUP_CODE | VARCHAR2 | (25) | RFQ and Quotation only: Method the supplier should use to reply to the RFQ | |
| RFQ_CLOSE_DATE | DATE | RFQ and Quotation only: Date the RFQ will be closed | ||
| QUOTE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | RFQ and Quotation only: Type of quotation (References PO_DOCUMENT_TYPES_ALL_B.document_subtype) | |
| QUOTATION_CLASS_CODE | VARCHAR2 | (25) | RFQ and Quotation only: Class of quotation | |
| QUOTE_WARNING_DELAY_UNIT | VARCHAR2 | (25) | Warning delay unit of measure (Unused since release 7.0) | |
| QUOTE_WARNING_DELAY | NUMBER | Quotation only: Number of days prior to the expiration of the quotation that you want to be notified | ||
| QUOTE_VENDOR_QUOTE_NUMBER | VARCHAR2 | (25) | Quotation only: Number of the quotation for the supplier | |
| 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 | ||
| USER_HOLD_FLAG | VARCHAR2 | (1) | Indicates whether the purchase order is on hold or not | |
| APPROVAL_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether a quote or RFQ requires approval | |
| 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 | |
| SUPPLY_AGREEMENT_FLAG | VARCHAR2 | (1) | Supply agreement flag for Supplier Scheduling | |
| 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 column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CLOSED_CODE | VARCHAR2 | (25) | Describes the closure status of the document (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='DOCUMENT STATE') | |
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | United States standard general ledger transaction code (References GL_USSGL_TRANSACTION_CODES.USSGL_TRANSACTION_CODE) | |
| GOVERNMENT_CONTEXT | VARCHAR2 | (30) | USSGL descriptive flexfield context column | |
| REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
| PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
| ORG_ID | NUMBER | Organization identifier | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| INTERFACE_SOURCE_CODE | VARCHAR2 | (25) | Audit trail reference (needed for 832 EDI transaction) | |
| REFERENCE_NUM | VARCHAR2 | (25) | Audit trail reference (needed for 832 EDI transaction) | |
| WF_ITEM_TYPE | VARCHAR2 | (8) | Workflow approval item type (References WF_ITEMS.item_type) | |
| WF_ITEM_KEY | VARCHAR2 | (240) | Workflow approval item key (References WF_ITEMS.item_key) | |
| MRC_RATE_TYPE | VARCHAR2 | (2000) | Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID and currency conversion rate type pairs | |
| MRC_RATE_DATE | VARCHAR2 | (2000) | Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID and currency conversion date pairs | |
| MRC_RATE | VARCHAR2 | (2000) | Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID and currency conversion rate pairs | |
| PCARD_ID | NUMBER | (15) | 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. | ||
| GLOBAL_AGREEMENT_FLAG | VARCHAR2 | (1) | Global agreement flag | |
| 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 | ||
| ENCUMBRANCE_REQUIRED_FLAG | VARCHAR2 | (1) | Blanket or Global Agreement only: Indicates whether the document is to be encumbred or not | |
| 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. | |
| 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 | (30) | Supplier Fax Number | |
| EMAIL_ADDRESS | VARCHAR2 | (2000) | Supplier Email Address | |
| RETRO_PRICE_COMM_UPDATES_FLAG | VARCHAR2 | (1) | Communicate price updates flag | |
| RETRO_PRICE_APPLY_UPDATES_FLAG | VARCHAR2 | (1) | Retroactively apply price updates to existing POs flag. | |
| 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 | 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. | ||
| LOCK_OWNER_ROLE | VARCHAR2 | (10) | Role of the user locking the document | |
| LOCK_OWNER_USER_ID | NUMBER | User who is locking the document | ||
| SUPPLIER_AUTH_ENABLED_FLAG | VARCHAR2 | (1) | Supplier Auth Enabled Flag | |
| CAT_ADMIN_AUTH_ENABLED_FLAG | VARCHAR2 | (1) | Cat Admin Auth Enabled Flag | |
| STYLE_ID | NUMBER | 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. | |
| ENABLE_ALL_SITES | VARCHAR2 | (1) | Enable all the vendor sites for this GPBA | |
| PAY_WHEN_PAID | VARCHAR2 | (1) | This is done as a part of E&C ER- Phase 1 | |
| COMM_REV_NUM | NUMBER | Comm Revision number | ||
| CLM_DOCUMENT_NUMBER | VARCHAR2 | (50) | Unique Document Number for the user | |
| OTM_STATUS_CODE | VARCHAR2 | (80) | Status of OTM Communication | |
| OTM_RECOVERY_FLAG | VARCHAR2 | (1) | Flag to indicate whether OTM communication needs to be recovered | |
| UDA_TEMPLATE_ID | NUMBER | Uda Template id | ||
| UDA_TEMPLATE_DATE | DATE | Uda Template date | ||
| USER_DOCUMENT_STATUS | VARCHAR2 | (30) | User extensible status | |
| AME_APPROVAL_ID | NUMBER | Unique identifier for approval transaction | ||
| DRAFT_ID | NUMBER | Dummy attribute for UDA | ||
| CLM_EFFECTIVE_DATE | DATE | Effective Date of the Document | ||
| CLM_VENDOR_OFFER_NUMBER | VARCHAR2 | (400) | Vendor Offer number | |
| CLM_AWARD_ADMINISTRATOR | VARCHAR2 | (400) | Administrator for the Document. | |
| CLM_NO_SIGNED_COPIES_TO_RETURN | NUMBER | Number of Signed copies to return | ||
| CLM_MIN_GUARANTEE_AWARD_AMT | NUMBER | Minimum amount that can be guaranteed on a CLM document. | ||
| CLM_MIN_GUAR_AWARD_AMT_PERCENT | NUMBER | Percentage of minimun amount guaranteed on the CLM award. | ||
| CLM_MIN_ORDER_AMOUNT | NUMBER | Minimum Order Amount used for Ordering Constraints | ||
| CLM_MAX_ORDER_AMOUNT | NUMBER | Maximum Order Amount used for Ordering Constraints | ||
| CLM_AMT_SYNCED_TO_AGREEMENT | VARCHAR2 | (1) | Amount synched onto the agreement. | |
| CLM_AMOUNT_RELEASED | NUMBER | Amount Released. | ||
| CLM_EXTERNAL_IDV | VARCHAR2 | (2000) | External System IDV Number | |
| CLM_SUPPLIER_NAME | VARCHAR2 | (400) | Supplier Name - Denormalised | |
| CLM_SUPPLIER_SITE_NAME | VARCHAR2 | (400) | Supplier Site Name - Denormalised | |
| CLM_SOURCE_DOCUMENT_ID | NUMBER | Sourcing Document id | ||
| CLM_ISSUING_OFFICE | VARCHAR2 | (1000) | CLM Issuing Office. | |
| CLM_COTR_OFFICE | VARCHAR2 | (2000) | CLM COTR Office. | |
| CLM_COTR_CONTACT | VARCHAR2 | (200) | Contact of COTR. | |
| CLM_PRIORITY_CODE | VARCHAR2 | (200) | Maintains the CLM priority code. | |
| CLM_MOD_ISSUING_OFFICE | VARCHAR2 | (1000) | Modification issuing office. | |
| CLM_STANDARD_FORM | VARCHAR2 | (200) | Standard Form code for PDF generation | |
| CLM_DOCUMENT_FORMAT | VARCHAR2 | (200) | Document Format code for PDF generation | |
| AME_TRANSACTION_TYPE | VARCHAR2 | (50) | AME Transaction Type used for the Document approval | |
| CLM_AWARD_TYPE | VARCHAR2 | (100) | Type of Award | |
| CLM_CONTRACT_OFFICER | NUMBER | Contracting Officer of the document | ||
| CLM_CLOSEOUT_STATUS | VARCHAR2 | (25) | Closeout status for CLM Documents | |
| UMBRELLA_PROGRAM_ID | NUMBER | Stores the Umbrella program reference to PON_UMBRELLA_PROGRAMS table | ||
| FON_REF_ID | NUMBER | Stores the Fair Opportunity Notice reference to PON_AUCTION_HEADERS_ALL table | ||
| CLM_DEFAULT_DIST_FLAG | VARCHAR2 | (1) | Flag to indicate whether Distributions should default automatically for CLM Documents | |
| CLM_EDAGEN_DATE | DATE | Stores the date on which the EDA was generated | ||
| CLM_CONTRACT_FINANCE_CODE | VARCHAR2 | (30) | ||
| CLM_PAYMENT_INSTR_CODE | VARCHAR2 | (30) | ||
| CLM_SPECIAL_CONTRACT_TYPE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT PO_HEADER_ID
, AGENT_ID
, TYPE_LOOKUP_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, SEGMENT1
, SUMMARY_FLAG
, ENABLED_FLAG
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, VENDOR_ID
, VENDOR_SITE_ID
, VENDOR_CONTACT_ID
, SHIP_TO_LOCATION_ID
, BILL_TO_LOCATION_ID
, TERMS_ID
, SHIP_VIA_LOOKUP_CODE
, FOB_LOOKUP_CODE
, FREIGHT_TERMS_LOOKUP_CODE
, STATUS_LOOKUP_CODE
, CURRENCY_CODE
, RATE_TYPE
, RATE_DATE
, RATE
, FROM_HEADER_ID
, FROM_TYPE_LOOKUP_CODE
, START_DATE
, END_DATE
, BLANKET_TOTAL_AMOUNT
, AUTHORIZATION_STATUS
, REVISION_NUM
, REVISED_DATE
, APPROVED_FLAG
, APPROVED_DATE
, AMOUNT_LIMIT
, MIN_RELEASE_AMOUNT
, NOTE_TO_AUTHORIZER
, NOTE_TO_VENDOR
, NOTE_TO_RECEIVER
, PRINT_COUNT
, PRINTED_DATE
, VENDOR_ORDER_NUM
, CONFIRMING_ORDER_FLAG
, COMMENTS
, REPLY_DATE
, REPLY_METHOD_LOOKUP_CODE
, RFQ_CLOSE_DATE
, QUOTE_TYPE_LOOKUP_CODE
, QUOTATION_CLASS_CODE
, QUOTE_WARNING_DELAY_UNIT
, QUOTE_WARNING_DELAY
, QUOTE_VENDOR_QUOTE_NUMBER
, ACCEPTANCE_REQUIRED_FLAG
, ACCEPTANCE_DUE_DATE
, CLOSED_DATE
, USER_HOLD_FLAG
, APPROVAL_REQUIRED_FLAG
, CANCEL_FLAG
, FIRM_STATUS_LOOKUP_CODE
, FIRM_DATE
, FROZEN_FLAG
, SUPPLY_AGREEMENT_FLAG
, EDI_PROCESSED_FLAG
, EDI_PROCESSED_STATUS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CLOSED_CODE
, USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, INTERFACE_SOURCE_CODE
, REFERENCE_NUM
, WF_ITEM_TYPE
, WF_ITEM_KEY
, MRC_RATE_TYPE
, MRC_RATE_DATE
, MRC_RATE
, PCARD_ID
, PRICE_UPDATE_TOLERANCE
, PAY_ON_CODE
, XML_FLAG
, XML_SEND_DATE
, XML_CHANGE_SEND_DATE
, GLOBAL_AGREEMENT_FLAG
, CONSIGNED_CONSUMPTION_FLAG
, CBC_ACCOUNTING_DATE
, CONSUME_REQ_DEMAND_FLAG
, CHANGE_REQUESTED_BY
, SHIPPING_CONTROL
, CONTERMS_EXIST_FLAG
, CONTERMS_ARTICLES_UPD_DATE
, CONTERMS_DELIV_UPD_DATE
, ENCUMBRANCE_REQUIRED_FLAG
, PENDING_SIGNATURE_FLAG
, CHANGE_SUMMARY
, DOCUMENT_CREATION_METHOD
, SUBMIT_DATE
, SUPPLIER_NOTIF_METHOD
, FAX
, EMAIL_ADDRESS
, RETRO_PRICE_COMM_UPDATES_FLAG
, RETRO_PRICE_APPLY_UPDATES_FLAG
, UPDATE_SOURCING_RULES_FLAG
, AUTO_SOURCING_FLAG
, CREATED_LANGUAGE
, CPA_REFERENCE
, LOCK_OWNER_ROLE
, LOCK_OWNER_USER_ID
, SUPPLIER_AUTH_ENABLED_FLAG
, CAT_ADMIN_AUTH_ENABLED_FLAG
, STYLE_ID
, TAX_ATTRIBUTE_UPDATE_CODE
, LAST_UPDATED_PROGRAM
, ENABLE_ALL_SITES
, PAY_WHEN_PAID
, COMM_REV_NUM
, CLM_DOCUMENT_NUMBER
, OTM_STATUS_CODE
, OTM_RECOVERY_FLAG
, UDA_TEMPLATE_ID
, UDA_TEMPLATE_DATE
, USER_DOCUMENT_STATUS
, AME_APPROVAL_ID
, DRAFT_ID
, CLM_EFFECTIVE_DATE
, CLM_VENDOR_OFFER_NUMBER
, CLM_AWARD_ADMINISTRATOR
, CLM_NO_SIGNED_COPIES_TO_RETURN
, CLM_MIN_GUARANTEE_AWARD_AMT
, CLM_MIN_GUAR_AWARD_AMT_PERCENT
, CLM_MIN_ORDER_AMOUNT
, CLM_MAX_ORDER_AMOUNT
, CLM_AMT_SYNCED_TO_AGREEMENT
, CLM_AMOUNT_RELEASED
, CLM_EXTERNAL_IDV
, CLM_SUPPLIER_NAME
, CLM_SUPPLIER_SITE_NAME
, CLM_SOURCE_DOCUMENT_ID
, CLM_ISSUING_OFFICE
, CLM_COTR_OFFICE
, CLM_COTR_CONTACT
, CLM_PRIORITY_CODE
, CLM_MOD_ISSUING_OFFICE
, CLM_STANDARD_FORM
, CLM_DOCUMENT_FORMAT
, AME_TRANSACTION_TYPE
, CLM_AWARD_TYPE
, CLM_CONTRACT_OFFICER
, CLM_CLOSEOUT_STATUS
, UMBRELLA_PROGRAM_ID
, FON_REF_ID
, CLM_DEFAULT_DIST_FLAG
, CLM_EDAGEN_DATE
, CLM_CONTRACT_FINANCE_CODE
, CLM_PAYMENT_INSTR_CODE
, CLM_SPECIAL_CONTRACT_TYPE
FROM PO.PO_HEADERS_ALL;
PO.PO_HEADERS_ALL does not reference any database object
PO.PO_HEADERS_ALL is referenced by following:
PO
PO_HEADERS_ALL#
|
|
|
|