PO_HEADERS_ARCHIVE_ALL
PO_HEADERS_ARCHIVE_ALL contains archived purchase order header information. Oracle Purchasing only archives the following documents: Standard purchase orders, Blanket purchase orders and Contract purchase orders. When you modify a PO_HEADER row, Oracle Purchasing will archive it after you (re)approve the purchase order or after you print it (this depends on the purchasing system options). You can retrieve previous revisions of the purchase order header using this table. The latest archived revision will have LATEST_EXTERNAL_FLAG set to 'Y'. You need one row for each document header you archive. Each row contains the same information as the PO_HEADERS_ALL table. Oracle Purchasing uses this information to ensure you keep copies of your legal documents. Oracle Purchasing does not currently read or retrieve information in this table.
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PO_HEADERS_ARCHIVE_ALL_PK |
PO_HEADER_ID, FROM_CO_SEQ |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| 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 | ||
| ENTITY_CHANGE_TYPE_CODE | VARCHAR2 | 1 | Indicates if the row is new or changed. | ||
| 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. | |
| FUNDS_STATUS | VARCHAR2 | 25 | status to indicate whether funds have been reserved on the document or not | ||
| BILLTO_BU_ID | NUMBER | 18 | Bill-to Business Unit unique identifier. Indicates the business unit which vouches the supplier invoices received for this purchase order. | ||
| SOLDTO_LE_ID | NUMBER | 18 | Sold to Legal Entity unique identifier. Indicates the party which is financially responsible for the purchases on this 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. | |||
| 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. | |
| ACCEPTANCE_WITHIN_DAYS | NUMBER | Used for Acknowledge within days | |||
| EXTERNAL_CHANGE_FLAG | VARCHAR2 | 1 | indicates if the change is external (supplier facing ) or not | ||
| 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 flag | ||
| USE_SHIP_TO | VARCHAR2 | 1 | Use ship to organization and location flag | ||
| CANCEL_FLAG | VARCHAR2 | 1 | CANCEL_FLAG | ||
| 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 | ||
| FROM_CO_SEQ | NUMBER | Yes | The starting point of the co sequence range within which the record is valid (Inclusive) | ||
| PRC_BU_ID | NUMBER | 18 | Yes | Procurement Business Unit Unique Identifier | |
| REQ_BU_ID | NUMBER | 18 | Requisitioning Business Unit Unique Identifier | ||
| TO_CO_SEQ | NUMBER | The ending point of the co sequence range within which the record is valid (Exclusive) | |||
| ENTITY_CO_DISPOSITION | VARCHAR2 | 25 | Approval Status of the archive record. It reflects the action taken against this record during archival. Possible values are:· APPROVED· REJECTED· CANCELED | ||
| AGENT_ID | NUMBER | 18 | Yes | Buyer unique identifier | |
| CARRIER_ID | NUMBER | 18 | Carrier ID (Party ID) | ||
| TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Yes | Type of the document | |
| 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 | |
| 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 | ||
| VENDOR_SITE_ID | NUMBER | 18 | Supplier site unique identifier | ||
| VENDOR_CONTACT_ID | NUMBER | 18 | Supplier contact unique identifier | ||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | Unique identifier for the ship-to location | ||
| BILL_TO_LOCATION_ID | NUMBER | 18 | Unique identifier of the bill-to location for the document | ||
| TERMS_ID | NUMBER | 18 | Payment terms unique identifier | ||
| FOB_LOOKUP_CODE | VARCHAR2 | 30 | Type of free-on-board terms for the document | ||
| FREIGHT_TERMS_LOOKUP_CODE | VARCHAR2 | 30 | Type of freight terms for the document | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Unique identifier for the currency | ||
| RATE_TYPE | VARCHAR2 | 30 | Currency conversion rate type | ||
| RATE_DATE | DATE | Currency conversion date | |||
| RATE | NUMBER | Currency conversion rate | |||
| FROM_HEADER_ID | NUMBER | 18 | Unique identifier of the RFQ used to autocreate a quotation | ||
| FROM_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Document type of the document used to autocreate another document | ||
| START_DATE | DATE | Date the document becomes effective | |||
| END_DATE | DATE | Expiration date of the document | |||
| BLANKET_TOTAL_AMOUNT | NUMBER | Amount agreed for the purchase order (blanket or planned) | |||
| AMOUNT_LIMIT | NUMBER | Maximum amount that can be released against the purchase order (blanket, contract, or planned) | |||
| MIN_RELEASE_AMOUNT | NUMBER | Minimum amount that can be released against the purchase order (blanket or planned) | |||
| 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 | No longer used | ||
| 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 | |||
| 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 | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| GOVERNMENT_CONTEXT | VARCHAR2 | 30 | USSGL descriptive flexfield context column | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| 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. | |||
| PCARD_ID | NUMBER | 18 | Unique Identifer for Procurement Card | ||
| PRICE_UPDATE_TOLERANCE | NUMBER | Catalog Price Update Tolerance for EDI 832 Update Action | |||
| 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) | ||
| PAY_ON_CODE | VARCHAR2 | 25 | Indicator of whether the purchase order will be paid upon receipt | ||
| XML_FLAG | VARCHAR2 | 1 | Indicator if user has chosen to send the PO document through XML. Y if selected. | ||
| CONSIGNED_CONSUMPTION_FLAG | VARCHAR2 | 1 | Consigned Consumption Flag | ||
| 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 | ||
| 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 | |||
| ENCUMBRANCE_REQUIRED_FLAG | VARCHAR2 | 1 | Blanket or Global Agreement only: Indicates whether the document is to be encumbred or not | ||
| CONTERMS_DELIV_UPD_DATE | DATE | Timestamp for the last update to Contract Deliverables Definition. Applicable to Purchasing document of type Standard, Contract, Blanket | |||
| SHIPPING_CONTROL | VARCHAR2 | 30 | Indicator of who is responsible for arranging transportation | ||
| 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 | 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. | |
| 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. | ||
| 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 | 20 | This flag on the agreement indicates whether or not the retroactive price update background process should be initiated upon agreement approval. | ||
| 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_ARCHIVE_ALL | poz_suppliers | VENDOR_ID |
| PO_HEADERS_ARCHIVE_ALL | poz_supplier_contacts | VENDOR_CONTACT_ID |
| PO_HEADERS_ARCHIVE_ALL | ap_terms_b | TERMS_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PO_HEADERS_ARCHIVE_N1 | Non Unique | Default | VENDOR_ID, TYPE_LOOKUP_CODE |
| PO_HEADERS_ARCHIVE_N2 | Non Unique | Default | AGENT_ID |
| PO_HEADERS_ARCHIVE_N3 | Non Unique | Default | CARRIER_ID |
| PO_HEADERS_ARCHIVE_N4 | Non Unique | Default | CHECKLIST_ID |
| PO_HEADERS_ARCHIVE_U1 | Unique | Default | PO_HEADER_ID, FROM_CO_SEQ |
| PO_HEADERS_ARCHIVE_U2 | Unique | Default | SEGMENT1, TYPE_LOOKUP_CODE, FROM_CO_SEQ, CASE WHEN "TYPE_LOOKUP_CODE" = 'STANDARD' THEN "SOLDTO_LE_ID" ELSE "PRC_BU_ID" END |