PO_HEADERS_GT
Purchase Order Headers Global Temporary table.
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
PO_HEADERS_GT_PK |
PO_HEADER_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
PO_HEADER_ID | NUMBER | 18 | Yes | PO header id | |
CHECKLIST_ID | NUMBER | 18 | Value that uniquely identifies the checklist on a Purchasing Document. | ||
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. 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 | 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 | This checkbox will indicate whether self-billing is enabled for consumption of consigned material. Values: Y/N. Applicable only to BPA. | ||
ENTITY_CHANGE_TYPE_CODE | VARCHAR2 | 1 | Indicates entity change type - added or updated | ||
DOCUMENT_STATUS | VARCHAR2 | 25 | Yes | Document status | |
STYLE_ID | NUMBER | 18 | Determines the Purchasing Style of the document. | ||
PRC_BU_ID | NUMBER | 18 | procurement bu id | ||
REQ_BU_ID | NUMBER | 18 | requisition bu id | ||
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 | Closed date | |||
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 | 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. | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
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. | |||
CLOSED_CODE | VARCHAR2 | 25 | Describes the closure status of the document | ||
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 | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
VENDOR_ORDER_NUM | VARCHAR2 | 25 | Indicates supplier document number, it gets copied from PO_HEADERS_INTERFACE.vendor_doc_num | ||
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 | Key Flexfield summary flag | ||
ENABLED_FLAG | VARCHAR2 | 1 | Yes | Key Flexfield enabled flag | |
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. | ||
START_DATE_ACTIVE | DATE | Key Flexfield start date | |||
END_DATE_ACTIVE | DATE | Key Flexfield end date | |||
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 | ||
CARRIER_ID | NUMBER | 18 | Carrier ID (Party ID) | ||
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 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 | |||
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 | 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 | ||
CONFIRMING_ORDER_FLAG | VARCHAR2 | 1 | Indicates whether the purchase order is a confirming order or not | ||
COMMENTS | VARCHAR2 | 240 | Descriptive comments for the document | ||
SEGMENT2 | VARCHAR2 | 20 | Key Flexfield: segment of the key flexfield. | ||
AGENT_ID | NUMBER | 18 | Yes | Buyer unique identifier. (References PO_AGENTS.agent_id) | |
SOLDTO_BU_ID | NUMBER | 18 | Sold to Business Unit Unique Identifier | ||
EDI_PROCESSED_FLAG | VARCHAR2 | 1 | EDI processed flag | ||
EDI_PROCESSED_STATUS | VARCHAR2 | 10 | EDI processed status flag | ||
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 | 150 | Audit trail reference (needed for 832 EDI transaction) | ||
REFERENCE_NUM | VARCHAR2 | 120 | Audit trail reference (needed for 832 EDI transaction) | ||
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 | 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. | |||
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 | ||
ENCUMBRANCE_REQUIRED_FLAG | VARCHAR2 | 1 | Blanket or Global Agreement only: Indicates whether the document is to be encumbred or not | ||
DISABLE_AUTOSOURCING_FLAG | VARCHAR2 | 1 | Disable Automatic Sourcing Flag | ||
PUNCHOUT_SOURCING_ONLY_FLAG | VARCHAR2 | 1 | Automatic Sourcing of Punchout Requests Only | ||
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. | ||
TXN_END_DATE | DATE | Effective date of the document (Transaction all table) | |||
TXN_START_DATE | DATE | Expiration date of the document (Transaction all table) | |||
TXN_CURRENCY_CODE | VARCHAR2 | 15 | Unique identifier for the currency (Transaction all table) | ||
TXN_PRC_BU_ID | NUMBER | 18 | procurement bu id (Transaction all table) | ||
TXN_CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row.(Transaction all table) | |||
TXN_AMOUNT_LIMIT | NUMBER | Blanket, Planned PO or Contract only: Maximum amount that can be released. (Transaction all table) | |||
TXN_DOCUMENT_STATUS | VARCHAR2 | 25 | Document status (Transaction all table) | ||
TXN_VENDOR_ID | NUMBER | 18 | Supplier unique identifier (References PO_VENDORS.vendor_id). )Transaction all table) | ||
TXN_MIN_RELEASE_AMOUNT | NUMBER | Minimum amount that can be released against a blanket or planned purchase order (Transaction all table) | |||
TXN_ALLOW_MULTIPLE_SITES_FLAG | VARCHAR2 | 1 | A flag to indicate that an agreement can be used across all supplier sites for a given supplier.(Transaction all table) | ||
TXN_AMOUNT_RELEASED | NUMBER | Amount released against this agreement - sum of all the approved standard PO amounts. (Transaction all table) | |||
TXN_LAST_BILLED_DATE | DATE | Field to capture when the consumption transaction on the agreement was last billed.(Transaction all table) | |||
TXN_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.(Transaction all table) | ||
TXN_BCEA_FLAG | VARCHAR2 | 1 | Flag to indicate if Budgetary conrol was enabled at the time of Purchase Order creation. Not applicable to Agreements. | ||
TXN_VENDOR_SITE_ID | NUMBER | 18 | Supplier site unique identifier (References PO_VENDOR_SITES_ALL.vendor_site_id) (Transaction all table) | ||
MANUAL_BCCD_OVERRIDE_FLAG | VARCHAR2 | 1 | Flag to indicate if Billing Cycle Closing Date has been edited manually. | ||
BUDGET_CONTROL_ENABLED_FLAG | VARCHAR2 | 1 | Flag to indicate if Budgetary conrol was enabled at the time of Purchase Order creation. Not applicable to Agreements. | ||
TXN_PO_HEADER_ID | NUMBER | 18 | PO header id (transaction all table) | ||
TXN_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Type of the document. (Combined with segment1and bu to form unique key; References PO_DOCUMENT_TYPES_ALL_B.document_subtype)(Transaction all table) | ||
TXN_SEGMENT1 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. (Transaction all table) | ||
OVERRIDING_APPROVER_ID | NUMBER | 18 | Overriding approver on purchase orders and change orders for approval routing. | ||
SOURCING_PRIORITY | NUMBER | Indicates the numerical value to determine the sourcing priority. Applicable only to BPA. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
PO_HEADERS_GT_U1 | Unique | PO_HEADER_ID |