PO_LINES_ALL
PO_LINES_ALL stores current information about each purchase order line. You need one row for each line you attach to a document. There are five document types that use lines: RFQs, Quotations, Standard purchase orders, Blanket purchase orders and Planned purchase orders. Each row includes the line number, item number, category, unit, price, tax information, matching information, and quantity ordered for the line. Oracle Purchasing uses this information to record and update item and price information for purchase orders, quotations, and RFQs. PO_LINE_ID is the unique system-generated line number invisible to the user. LINE_NUM is the number of the line on the purchase order. Oracle Purchasing uses CONTRACT_ID to reference a contract purchase order from a standard purchase order line. Oracle Purchasing uses ALLOW_PRICE_OVERRIDE_FLAG, COMMITTED_AMOUNT, QUANTITY_COMMITTED, MIN_RELEASE_AMOUNT only for blanket and planned purchase order lines. The QUANTITY field stores the total quantity of all purchase order shipment lines (found in PO_LINE_LOCATIONS_ALL).
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PO_LINES_ALL_PK |
PO_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| PO_LINE_ID | NUMBER | 18 | Yes | Document line unique identifier | ||
| 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. | ||||
| SH_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Segment used to identify the special handling context for special handling purchase order lines | |||
| DISCOUNT_TYPE | VARCHAR2 | 25 | Type that indicates whether the discount is based on percent or amount | |||
| DISCOUNT | NUMBER | Value which indicates the discount percent or amount of the purchase order line | ||||
| DISCOUNT_REASON | VARCHAR2 | 240 | Description of the reason for the discount | |||
| LIST_PRICE | NUMBER | The original price per unit of the item or service offered | ||||
| FUNDS_STATUS | VARCHAR2 | 25 | Indicates whether the line amount is reserved or not | |||
| CONFIGURED_ITEM_FLAG | VARCHAR2 | 1 | Yes | (PO Only, CTO Only) Flag to indicate whether document should support model items and options. | ||
| PARENT_ITEM_ID | NUMBER | 18 | (BPA Only, CTO Only) The buying organization's identification number or code corresponding to the parent option class or model for the option/item or model. | |||
| SUPPLIER_PARENT_ITEM | VARCHAR2 | 300 | (BPA Only, CTO Only) The supplier's identification number or code for the option class or model associated with the option/item or model. | |||
| TOP_MODEL_ID | NUMBER | 18 | (BPA Only, CTO Only) The buying organization's identification number or code for the top model associated with the option/option class/submodel. | |||
| SUPPLIER_TOP_MODEL | VARCHAR2 | 300 | (BPA Only, CTO Only) The supplier's identification number or code for the top model associated with the option/option class/submodel. | |||
| COMPONENT_AMOUNT_RELEASED | NUMBER | (BPA Only, CTO Only, txn Only) The total quantity of goods ordered related to a purchase agreement resulting from selection of the blanket line item as an optional component of a larger configuration. | ||||
| AMOUNT_RELEASED | NUMBER | The total value of goods and services ordered related to a purchase agreement. For lines where the line item is a model item, this value represents the amount of configurations purchased with this item as the base model. | ||||
| BASE_MODEL_ID | NUMBER | 18 | (PO Only, CTO Only) The buying organization's identification number or code for the model on which the unique configuration is built. | |||
| BASE_MODEL_PRICE | NUMBER | (PO Only, CTO Only) Unit price of the base model only. | ||||
| OPTIONS_PRICE | NUMBER | (PO Only, CTO Only) Sum of the extended price of all options chosen per unit of the purchased configuration | ||||
| AGING_PERIOD_DAYS | NUMBER | 5 | Indicates the maximum number of days the material may be on consignment. Only positive values are allowed. Applicable only to BPA Lines. | |||
| CONSIGNMENT_LINE_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the item on line will be purchased under consignment arrangement from supplier. Values: Y/N. Applicable to both BPA and PO Lines. | ||
| CATALOG_NAME | VARCHAR2 | 255 | Catalog Name | |||
| LINE_STATUS | VARCHAR2 | 25 | Line status | |||
| 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. | ||
| PO_HEADER_ID | NUMBER | 18 | Yes | Document header unique identifier. (References PO_HEADERS_ALL.po_header_id.) | ||
| LINE_TYPE_ID | NUMBER | 18 | Yes | Line type unique identifier (References PO_LINE_TYPES_B.line_type_id.) | ||
| LINE_NUM | NUMBER | Yes | Line number | |||
| 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. | ||
| ITEM_ID | NUMBER | 18 | Item unique identifier. (References EGP_SYSTEM_ITEMS_B.inventory_item_id.) | |||
| ITEM_REVISION | VARCHAR2 | 18 | Item revision. (References EGP_ITEM_REVISIONS_B.revision.) | |||
| CATEGORY_ID | NUMBER | 18 | Item category unique identifier. (References EGP_CATEGORIES_B.category_id.) | |||
| ITEM_DESCRIPTION | VARCHAR2 | 240 | Item description. (Defaulted from EGP_SYSTEM_ITEMS_TL.description.) | |||
| UOM_CODE | VARCHAR2 | 3 | Unit of measure for the quantity ordered. (References INV_UNITS_OF_MEASURE.uom_code.) | |||
| QUANTITY_COMMITTED | NUMBER | Blankets only: Quantity agreed for an agreement line | ||||
| COMMITTED_AMOUNT | NUMBER | Blankets only: Amount agreed for an agreement line | ||||
| ALLOW_PRICE_OVERRIDE_FLAG | VARCHAR2 | 1 | Blankets or planned POs only: Indicates whether you can change the price on release shipments | |||
| NOT_TO_EXCEED_PRICE | NUMBER | Blankets or planned POs only: Price limit that you cannot exceed on a release shipment | ||||
| LIST_PRICE_PER_UNIT | NUMBER | List price for the item on the line. (Defaulted from EGP_SYSTEM_ITEMS_B.list_price_per_unit.) | ||||
| UNIT_PRICE | NUMBER | Unit price for the line. (Defaulted from EGP_SYSTEM_ITEMS_B.list_price_per_unit, converted to the document's currency.) | ||||
| QUANTITY | NUMBER | Quantity ordered on the line | ||||
| TAX_EXCLUSIVE_PRICE | NUMBER | The purchase order line price that is exclusive of all the taxes. | ||||
| UN_NUMBER_ID | NUMBER | 18 | UN number unique identifier. (References PO_UN_NUMBERS_B.un_number_id.) | |||
| HAZARD_CLASS_ID | NUMBER | 18 | Hazard class unique identifier. (References PO_HAZARD_CLASSES_B.hazard_class_id.) | |||
| NOTE_TO_VENDOR | VARCHAR2 | 1000 | Short note to supplier | |||
| FROM_HEADER_ID | NUMBER | 18 | 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_LINE_ID | NUMBER | 18 | Unique identifier of the quotation line (standard or planned POs only) or global agreement line (standard POs only) referenced by this line. (References PO_LINES_ALL.po_line_id.) | |||
| QTY_RCV_TOLERANCE | NUMBER | Quantity received tolerance percentage | ||||
| PRC_BU_ID | NUMBER | 18 | Yes | PRC_BU_ID | ||
| REQ_BU_ID | NUMBER | 18 | REQ_BU_ID | |||
| OVER_TOLERANCE_ERROR_FLAG | VARCHAR2 | 25 | Indicates whether or not you reject receipts exceeding the tolerance | |||
| MARKET_PRICE | NUMBER | Market price for the item on the line. (Defaulted from EGP_SYSTEM_ITEMS_B.market_price.) | ||||
| UNORDERED_FLAG | VARCHAR2 | 1 | Indicates whether or not the line was created from unordered receipts | |||
| CANCEL_FLAG | VARCHAR2 | 1 | Indicates whether the line is cancelled or not | |||
| CANCELLED_BY | NUMBER | 18 | Unique identifier of the employee who cancelled the line. (References HR_EMPLOYEES.employee_id.) | |||
| CANCEL_DATE | DATE | Cancellation date | ||||
| CANCEL_REASON | VARCHAR2 | 240 | Cancellation reason provided by employee | |||
| FIRM_STATUS_LOOKUP_CODE | VARCHAR2 | 30 | Firming status of the line (Unused since release version 7.0) | |||
| FIRM_DATE | DATE | Date the line becomes firmed (Unused since release version 7.0) | ||||
| VENDOR_PRODUCT_NUM | VARCHAR2 | 300 | Supplier item number | |||
| TAXABLE_FLAG | VARCHAR2 | 1 | Indicates whether the document line is taxable or not | |||
| TAX_NAME | VARCHAR2 | 30 | Tax code applying to the line. (References AP_TAX_CODES_ALL.name.) | |||
| TYPE_1099 | VARCHAR2 | 10 | 1099 type for the purchase order line | |||
| CAPITAL_EXPENSE_FLAG | VARCHAR2 | 1 | Indicates whether the line is for a capital expense or not | |||
| NEGOTIATED_BY_PREPARER_FLAG | VARCHAR2 | 1 | Indicates whether the buyer negotiated the price or not | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| REFERENCE_NUM | VARCHAR2 | 25 | Reference number (Unused since release version 7.0) | |||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Lines (PO_LINES) | |||
| MIN_RELEASE_AMOUNT | NUMBER | Blankets or planned POs only: Minimum amount that can be released against a planned or blanket agreement line. | ||||
| PRICE_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Price type of the line. (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='PRICE TYPE'.) | |||
| PRICE_BREAK_LOOKUP_CODE | VARCHAR2 | 25 | Blankets only: Pricing scheme for the price breaks of this line (cumulative or non-cumulative). | |||
| 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 | |||
| CLOSED_DATE | DATE | Date the line is closed | ||||
| CLOSED_REASON | VARCHAR2 | 240 | Describes why the line is closed | |||
| CLOSED_BY | NUMBER | 18 | Unique identifier of the employee who closed the line. (References HR_EMPLOYEES.employee_id.) | |||
| SOLDTO_BU_ID | NUMBER | 18 | Sold to Business Unit Unique Identifier | |||
| QC_GRADE | VARCHAR2 | 25 | OPM: Stores the quality control grade wanted on the purchase order line | |||
| BASE_UOM | VARCHAR2 | 25 | OPM: Stores the base unit of measure (UOM) for the item ordered | |||
| BASE_QTY | NUMBER | OPM: Ordered quantity converted from transaction UOM to base UOM | ||||
| 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. | ||||
| LINE_REFERENCE_NUM | VARCHAR2 | 25 | Value used to identify the line record in the external system from where it was imported. | |||
| EXPIRATION_DATE | DATE | Blanket, quotation, or RFQ only: Date after which the item on this catalog line can no longer be ordered | ||||
| TAX_CODE_ID | NUMBER | 18 | Unique identifier for the tax code. (References AP_TAX_CODES.tax_id.) | |||
| OKE_CONTRACT_HEADER_ID | NUMBER | 18 | Contract identifier from Oracle Contracts. (References OKC_K_HEADERS_B.id.) | |||
| OKE_CONTRACT_VERSION_ID | NUMBER | 18 | Version identifier for contract. | |||
| SECONDARY_QUANTITY | NUMBER | OPM: Secondary Quantity ordered on the line | ||||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | OPM: Secondary unit of measure for the quantity ordered | |||
| PREFERRED_GRADE | VARCHAR2 | 150 | Preferred quality grade for the item ordered | |||
| AUCTION_HEADER_ID | NUMBER | 18 | Reference to the negotiation id in sourcing. (References PON_AUCTION_HEADERS_ALL.auction_header_id.) | |||
| AUCTION_DISPLAY_NUMBER | VARCHAR2 | 240 | Reference to the negotiation number in sourcing | |||
| AUCTION_LINE_NUMBER | NUMBER | Reference to the negotiation line number in Sourcing | ||||
| BID_NUMBER | NUMBER | Reference to the bid number in sourcing | ||||
| BID_LINE_NUMBER | NUMBER | Reference to the Bid line in sourcing | ||||
| RETROACTIVE_DATE | DATE | Column used to store the timestamp of a retroactive price change | ||||
| SUPPLIER_REF_NUMBER | VARCHAR2 | 150 | Tracking code for a specific configuration of an item. Generated by a configuration engine maintained by suppliers. | |||
| CONTRACT_ID | NUMBER | 18 | Standard POs only: Contract PA reference of a line. (References PO_HEADERS_ALL.po_header_id.) | |||
| START_DATE | DATE | Assignment start Date for the contingent worker | ||||
| AMOUNT | NUMBER | Budget Amout for temp labor standard PO lines | ||||
| JOB_ID | NUMBER | 18 | Stores the HR Job identifier | |||
| CONTRACTOR_FIRST_NAME | VARCHAR2 | 240 | First name of the contingent worker | |||
| CONTRACTOR_LAST_NAME | VARCHAR2 | 240 | Last name of the contingent worker | |||
| FROM_LINE_LOCATION_ID | NUMBER | 18 | Unique identifier of the Price Break (standard POs only) referenced by this line. (References PO_LINE_LOCATIONS_ALL.line_location_id.) | |||
| ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Yes | Value basis of the line | ||
| PURCHASE_BASIS | VARCHAR2 | 30 | Yes | Purchase basis of the line type | ||
| MATCHING_BASIS | VARCHAR2 | 30 | Yes | Matching basis of the line type | ||
| SVC_AMOUNT_NOTIF_SENT | VARCHAR2 | 1 | Temp Labor lines (i.e. PURCHASE_BASIS='TEMP LABOR') on Standard POs only: Y if an Amount Billed Approaching Budget reminder notification has been sent for this line, NULL otherwise. | |||
| SVC_COMPLETION_NOTIF_SENT | VARCHAR2 | 1 | Temp Labor lines (i.e. PURCHASE_BASIS='TEMP LABOR') on Standard POs only: Y if a Contractor Assignment Nearing Completion reminder notification has been sent for this line, NULL otherwise. | |||
| BASE_UNIT_PRICE | NUMBER | Base Unit Price | ||||
| MANUAL_PRICE_CHANGE_FLAG | VARCHAR2 | 1 | Only for Standard PO lines referencing a Global Agreement, Contract, or Quotation: Y if the user has manually entered a price overriding the source document price, N or null otherwise. | |||
| RETAINAGE_RATE | NUMBER | Obsolete - Maximum percentage that can be withheld from an invoice as Retainage | ||||
| MAX_RETAINAGE_AMOUNT | NUMBER | The maximum amount that can be withheld as Retainage against a contract line | ||||
| PROGRESS_PAYMENT_RATE | NUMBER | Percentage applied to the completed work on a financing Pay Item to determine the amount eligible for payment | ||||
| RECOUPMENT_RATE | NUMBER | Maximum percentage of the invoice amount against which previous prepayments can be applied | ||||
| SUPPLIER_PART_AUXID | VARCHAR2 | 255 | Supplier Part Auxiliary Id | |||
| 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. | |||
| 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. | ||
| ALLOW_DESCRIPTION_UPDATE_FLAG | VARCHAR2 | 1 | ALLOW_DESCRIPTION_UPDATE_FLAG | |||
| PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for project-related standardized cost collection. | |||
| SOURCE_DOC_REV_NUM | NUMBER | SOURCE_DOC_REV_NUM | ||||
| NEXT_CONSUMPTION_ADV_GEN_DATE | DATE | Indicates the date when this line would be picked for Consumption Advice generation. | ||||
| WORK_ORDER_PRODUCT | VARCHAR2 | 300 | Indicates the finished good product of the contract manufacturing work order. | |||
| MANUFACTURER | VARCHAR2 | 700 | Name of the company that manufactures the item being purchased. | |||
| MANUFACTURER_PART_NUM | VARCHAR2 | 700 | Number that uniquely identifies the item as provided by the manufacturer. | |||
| SHIPPING_UOM_CODE | VARCHAR2 | 3 | Unit of measure that the supplier is requested to ship in. (References INV_UNITS_OF_MEASURE.uom_code.) | |||
| SHIPPING_UOM_QUANTITY | NUMBER | Quantity in shipping unit of measure | ||||
| CREDIT_FLAG | VARCHAR2 | 1 | Indicates whether the line is a credit line. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PO_LINES_ALL | po_headers_all | PO_HEADER_ID |
| PO_LINES_ALL | egp_categories_b | CATEGORY_ID |
| PO_LINES_ALL | po_line_types_b | LINE_TYPE_ID |
| PO_LINES_ALL | po_un_numbers_b | UN_NUMBER_ID |
| PO_LINES_ALL | po_hazard_classes_b | HAZARD_CLASS_ID |
| PO_LINES_ALL | po_headers_all | FROM_HEADER_ID |
| PO_LINES_ALL | po_lines_all | FROM_LINE_ID |
| po_attribute_values | po_lines_all | PO_LINE_ID |
| rcv_transactions | po_lines_all | PO_LINE_ID |
| po_line_locations_all | po_lines_all | FROM_LINE_ID |
| po_line_locations_all | po_lines_all | PO_LINE_ID |
| po_attribute_values_tlp | po_lines_all | PO_LINE_ID |
| inv_supply | po_lines_all | PO_LINE_ID |
| rcv_supply | po_lines_all | PO_LINE_ID |
| rcv_transactions_interface | po_lines_all | PO_LINE_ID |
| ap_invoice_lines_interface | po_lines_all | PO_LINE_ID |
| rcv_shipment_lines | po_lines_all | PO_LINE_ID |
| po_lines_all | po_lines_all | FROM_LINE_ID |
| po_lines_draft_all | po_lines_all | FROM_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PO_LINES_F1 | Non Unique | Default | UPPER("ITEM_DESCRIPTION") |
| PO_LINES_F2 | Non Unique | Default | NVL("FROM_HEADER_ID","CONTRACT_ID") |
| PO_LINES_N1 | Non Unique | Default | ITEM_ID |
| PO_LINES_N10 | Non Unique | Default | LAST_UPDATE_DATE |
| PO_LINES_N11 | Non Unique | Default | CONTRACT_ID |
| PO_LINES_N13 | Non Unique | Default | FROM_HEADER_ID |
| PO_LINES_N14 | Non Unique | Default | LINE_STATUS |
| PO_LINES_N15 | Non Unique | Default | PRC_BU_ID |
| PO_LINES_N16 | Non Unique | Default | PO_HEADER_ID, LINE_NUM |
| PO_LINES_N17 | Non Unique | Default | LINE_REFERENCE_NUM |
| PO_LINES_N2 | Non Unique | Default | CREATION_DATE |
| PO_LINES_N3 | Non Unique | Default | CATEGORY_ID |
| PO_LINES_N4 | Non Unique | Default | FROM_LINE_ID |
| PO_LINES_N5 | Non Unique | Default | ITEM_DESCRIPTION |
| PO_LINES_N6 | Non Unique | Default | VENDOR_PRODUCT_NUM |
| PO_LINES_N8 | Non Unique | Default | CLOSED_BY |
| PO_LINES_N9 | Non Unique | Default | CANCELLED_BY |
| PO_LINES_U1 | Unique | Default | PO_LINE_ID |