PO_LINES_ARCHIVE_ALL
PO_LINES_ARCHIVE_ALL contains archived purchase order line information. Oracle Purchasing only archives lines for the following documents: Standard purchase orders and Blanket purchase orders. When you modify a purchasing line, 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 revisions of the purchase order line using this table. The latest archived revision will have LATEST_EXTERNAL_FLAG set to 'Y'. You need one row for each document line you archive. Each row contains the same information as the PO_LINES_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_LINES_ARCHIVE_ALL_PK |
PO_LINE_ID, FROM_CO_SEQ |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PO_LINE_ID | NUMBER | 18 | Yes | Document line unique identifier | |
| LINE_START_DATE | DATE | The effective start date of a blanket purchase agreement line denotes the date when the agreement line becomes available for sourcing. | |||
| 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 | ||
| LIST_PRICE | NUMBER | The original price per unit of the item or service offered | |||
| 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 | ||
| ENTITY_CHANGE_TYPE_CODE | VARCHAR2 | 1 | Indicates if the row is new or changed. | ||
| FUNDS_STATUS | VARCHAR2 | 25 | status to indicate whether funds have been reserved on the line 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. | ||
| 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 | OPTIONS_PRICE | |||
| 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 | ||
| PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for project-related standardized cost collection. | ||
| 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.) | ||
| SOURCE_DOC_REV_NUM | NUMBER | Source Document revision number | |||
| RETROACTIVE_DATE | DATE | Column used to store the timestamp of a retroactive price change | |||
| EXTERNAL_CHANGE_FLAG | VARCHAR2 | 1 | indicates if the change is external (supplier facing ) or not | ||
| FROM_CO_SEQ | NUMBER | Yes | The starting point of the co sequence range within which the record is valid (Inclusive) | ||
| TO_CO_SEQ | NUMBER | Yes | The ending point of the co sequence range within which the record is valid (Exclusive) | ||
| PRC_BU_ID | NUMBER | 18 | Yes | Procurement Business Unit Unique Identifier | |
| 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 | ||
| REASON_FOR_CHANGE | VARCHAR2 | 240 | Reason for change | ||
| REJECTED_BY | VARCHAR2 | 25 | User that rejects the entity record | ||
| REJECTED_BY_ROLE | VARCHAR2 | 25 | Role of the user rejecting the entity record | ||
| REJECTED_REASON | VARCHAR2 | 240 | Rejected Reason | ||
| REQ_BU_ID | NUMBER | 18 | Requisitioning Business Unit Unique Identifier | ||
| 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 | |
| LINE_TYPE_ID | NUMBER | 18 | Yes | Line type unique identifier | |
| 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 | ||
| ITEM_REVISION | VARCHAR2 | 18 | Item revision | ||
| CATEGORY_ID | NUMBER | 18 | Item category unique identifier | ||
| ITEM_DESCRIPTION | VARCHAR2 | 240 | Item description | ||
| UOM_CODE | VARCHAR2 | 3 | Unit of measure for the quantity ordered. (References INV_UNITS_OF_MEASURE.uom_code.) | ||
| QUANTITY_COMMITTED | NUMBER | Quantity agreed for an agreement line | |||
| COMMITTED_AMOUNT | NUMBER | Amount agreed for an agreement line | |||
| ALLOW_PRICE_OVERRIDE_FLAG | VARCHAR2 | 1 | Indicates whether or not you can change the price on releases | ||
| NOT_TO_EXCEED_PRICE | NUMBER | Price limit that you cannot exceed on a release shipment | |||
| LIST_PRICE_PER_UNIT | NUMBER | List price for the item on the line | |||
| UNIT_PRICE | NUMBER | Unit price for the line | |||
| 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 | ||
| HAZARD_CLASS_ID | NUMBER | 18 | Hazard class unique identifier | ||
| NOTE_TO_VENDOR | VARCHAR2 | 1000 | Short note to supplier | ||
| FROM_HEADER_ID | NUMBER | 18 | Quotation unique identifier | ||
| FROM_LINE_ID | NUMBER | 18 | Quotation line unique identifier | ||
| QTY_RCV_TOLERANCE | NUMBER | Quantity received tolerance percentage | |||
| OVER_TOLERANCE_ERROR_FLAG | VARCHAR2 | 25 | Indicates whether you reject receipts exceeding the tolerance or not | ||
| MARKET_PRICE | NUMBER | Market price for the item on the line | |||
| UNORDERED_FLAG | VARCHAR2 | 1 | Indicates whether the line was created from unordered receipts or not | ||
| 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 | ||
| 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 product number | ||
| TAXABLE_FLAG | VARCHAR2 | 1 | Indicates whether the document line is taxable or not | ||
| TAX_NAME | VARCHAR2 | 30 | Tax code applying to the line | ||
| 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. | ||
| 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. | ||
| 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. | ||
| REFERENCE_NUM | VARCHAR2 | 25 | Reference number (Unused since release version 7.0) | ||
| 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. | |||
| MIN_RELEASE_AMOUNT | NUMBER | Minimum amount that can be released against a planned purchase order or blanket agreement lines | |||
| PRICE_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Price type of the line | ||
| PRICE_BREAK_LOOKUP_CODE | VARCHAR2 | 25 | Describes the pricing scheme for blanket agreement line price breaks | ||
| GOVERNMENT_CONTEXT | VARCHAR2 | 30 | USSGL descriptive flexfield context column | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| PROGRAM_NAME | VARCHAR2 | 30 | PROGRAM_NAME | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | PROGRAM_APP_NAME | ||
| SOLDTO_BU_ID | NUMBER | 18 | Sold to Business Unit Unique Identifier | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| EXPIRATION_DATE | DATE | Expiration Date For Catalog Lines | |||
| QC_GRADE | VARCHAR2 | 25 | Quality control grade wanted for the purchase order line | ||
| BASE_UOM | VARCHAR2 | 25 | Base unit of measure (UOM) for the item ordered | ||
| BASE_QTY | NUMBER | Ordered quantity converted from transaction UOM to base UOM | |||
| LINE_REFERENCE_NUM | VARCHAR2 | 25 | Value used to identify the line record in the external system from where it was imported. | ||
| TAX_CODE_ID | NUMBER | 18 | Unique identifier for the tax code | ||
| SECONDARY_QUANTITY | NUMBER | Quantity ordered in secondary unit of measure | |||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | OPM: Secondary unit of measure for the quantity ordered | ||
| PREFERRED_GRADE | VARCHAR2 | 150 | Preferred quality grade of the item ordered | ||
| AUCTION_HEADER_ID | NUMBER | 18 | reference to sourcing auction id | ||
| AUCTION_DISPLAY_NUMBER | VARCHAR2 | 240 | reference to sourcing auction number | ||
| AUCTION_LINE_NUMBER | NUMBER | reference to sourcing auction line number | |||
| BID_NUMBER | NUMBER | reference to the sourcing bud number | |||
| BID_LINE_NUMBER | NUMBER | reference to sourcing big line number | |||
| 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. | ||
| SUPPLIER_REF_NUMBER | VARCHAR2 | 150 | Tracking code that links to a specific configuration of an item. Generated by a configuration engine maintained by suppliers. | ||
| CONTRACT_ID | NUMBER | 18 | Contract PA reference of a Line. Apply to Standard PO only. Foreign key to PO_HEADER_ID in PO_HEADERS_ALL | ||
| JOB_ID | NUMBER | 18 | Reference to HR Job for service lines | ||
| AMOUNT | NUMBER | Amount for service lines | |||
| START_DATE | DATE | Assignment start date for contractor | |||
| CONTRACTOR_FIRST_NAME | VARCHAR2 | 240 | Contractor First Name for Service lines | ||
| CONTRACTOR_LAST_NAME | VARCHAR2 | 240 | Contractor Last Name for Service lines | ||
| ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Value Basis of the line type | ||
| PURCHASE_BASIS | VARCHAR2 | 30 | Purchase Basis of the line type | ||
| MATCHING_BASIS | VARCHAR2 | 30 | Matching Basis of the line type | ||
| 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 | ||
| 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 | Specifies Whether the Description can be updated or not. | ||
| 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_ARCHIVE_ALL | po_headers_all | PO_HEADER_ID |
| PO_LINES_ARCHIVE_ALL | po_headers_all | FROM_HEADER_ID |
| PO_LINES_ARCHIVE_ALL | po_line_types_b | LINE_TYPE_ID |
| PO_LINES_ARCHIVE_ALL | po_un_numbers_b | UN_NUMBER_ID |
| PO_LINES_ARCHIVE_ALL | po_hazard_classes_b | HAZARD_CLASS_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PO_LINES_ARCHIVE_ALL_U1 | Unique | Default | PO_HEADER_ID, LINE_NUM, FROM_CO_SEQ |
| PO_LINES_ARCHIVE_N2 | Non Unique | Default | ITEM_ID |
| PO_LINES_ARCHIVE_N4 | Non Unique | Default | CANCELLED_BY |
| PO_LINES_ARCHIVE_N5 | Non Unique | Default | FROM_HEADER_ID |
| PO_LINES_ARCHIVE_U1 | Unique | Default | PO_LINE_ID, FROM_CO_SEQ |