PO_LINES_DRAFT_ALL
PO_LINES_DRAFT_ALL stores draft changes to PO lines that have not been accepted by buyer. A record in this table contains the proposed values for the corresponding record in the transaction table PO_LINES_ALL. When the draft changes are accepted, the record is moved to PO_LINES_ALL. Changes from buyer are automatically accepted. PO_LINES_DRAFT_ALL contains all columns from PO_LINES_ALL, as well as the following additional columns: DRAFT_ID: primary key of the table; foreign key to PO_DRAFTS; CHANGE_ACCEPTED_FLAG: acceptance status of the draft record; DELETE_FLAG: flag indicating whether the corresponding record in transaction table should be deleted when the draft change is accepted.
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PO_LINES_DRAFT_ALL_PK |
PO_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| PO_LINE_ID | NUMBER | 18 | Yes | Unique identifier for PO line | ||
| 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 | |||
| 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. | |||
| 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 | |||
| EXTERNAL_CHANGE_FLAG | VARCHAR2 | 1 | indicates if the change is external(supplier facing or not | |||
| REJECTED_REASON | VARCHAR2 | 240 | Rejection Reason | |||
| REASON_FOR_CHANGE | VARCHAR2 | 240 | The column documents the reason for changing the line | |||
| PRC_BU_ID | NUMBER | 18 | Yes | Procurement Business Unit Unique Identifier | ||
| REJECTED_BY | VARCHAR2 | 25 | This column Documents who rejected the line | |||
| REJECTED_BY_ROLE | VARCHAR2 | 25 | This column Documents the role who rejected this line | |||
| REQ_BU_ID | NUMBER | 18 | Requisitioning Business Unit Unique Identifier | |||
| ENTITY_CHANGE_TYPE_CODE | VARCHAR2 | 1 | Indicates if the row is new or changed. | |||
| 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.) | |||
| 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.) | |||
| QTY_RCV_TOLERANCE | NUMBER | Quantity received tolerance percentage | ||||
| 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 | |||
| 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 | |||
| 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 | ||
| 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. | |||
| CHANGE_ACCEPTED_FLAG | VARCHAR2 | 1 | Acceptance status of the draft record | |||
| 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 | ||||
| SUPPLIER_PART_AUXID | VARCHAR2 | 255 | Supplier Part Auxiliary Id | |||
| RECOUPMENT_RATE | NUMBER | Maximum percentage of the invoice amount against which previous prepayments can be applied | ||||
| TAX_ATTRIBUTE_UPDATE_CODE | VARCHAR2 | 15 | Keeps track of create/update actions on this entity | |||
| ORIGINAL_INTERFACE_LINE_ID | NUMBER | 18 | This column is only used by PDOI to indicate the interface line record that creates the draft line record. | |||
| 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 | |||
| CO_QUANTITY_CANCELLED | NUMBER | CO_QUANTITY_CANCELLED | ||||
| CO_AMOUNT_CANCELLED | NUMBER | CO_AMOUNT_CANCELLED | ||||
| 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 Document revision number | ||||
| 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 | ||||
| CO_SHIPPING_QUANTITY_CANCELLED | NUMBER | Changed quantity in shipping unit of measure canceled up until today | ||||
| CREDIT_FLAG | VARCHAR2 | 1 | Indicates whether the line is a credit line. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PO_LINES_DRAFT_ALL | egp_categories_b | CATEGORY_ID |
| PO_LINES_DRAFT_ALL | po_line_types_b | LINE_TYPE_ID |
| PO_LINES_DRAFT_ALL | po_un_numbers_b | UN_NUMBER_ID |
| PO_LINES_DRAFT_ALL | po_hazard_classes_b | HAZARD_CLASS_ID |
| PO_LINES_DRAFT_ALL | po_headers_all | FROM_HEADER_ID |
| PO_LINES_DRAFT_ALL | po_lines_all | FROM_LINE_ID |
| po_attribute_values_tlp_draft | po_lines_draft_all | PO_LINE_ID |
| po_line_locations_draft_all | po_lines_draft_all | PO_LINE_ID |
| po_attribute_values_draft | po_lines_draft_all | PO_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PO_LINES_DRAFT_N1 | Non Unique | Default | ITEM_ID |
| PO_LINES_DRAFT_N10 | Non Unique | Default | LAST_UPDATE_DATE |
| PO_LINES_DRAFT_N11 | Non Unique | Default | CONTRACT_ID |
| PO_LINES_DRAFT_N12 | Non Unique | Default | PARENT_ITEM_ID |
| PO_LINES_DRAFT_N13 | Non Unique | Default | FROM_HEADER_ID |
| PO_LINES_DRAFT_N14 | Non Unique | Default | PO_HEADER_ID, LINE_NUM |
| PO_LINES_DRAFT_N2 | Non Unique | Default | CREATION_DATE |
| PO_LINES_DRAFT_N3 | Non Unique | Default | CATEGORY_ID |
| PO_LINES_DRAFT_N4 | Non Unique | Default | FROM_LINE_ID |
| PO_LINES_DRAFT_N5 | Non Unique | Default | ITEM_DESCRIPTION |
| PO_LINES_DRAFT_N6 | Non Unique | Default | VENDOR_PRODUCT_NUM |
| PO_LINES_DRAFT_N7 | Non Unique | Default | BASE_MODEL_ID |
| PO_LINES_DRAFT_N8 | Non Unique | Default | TOP_MODEL_ID |
| PO_LINES_DRAFT_N9 | Non Unique | Default | CANCELLED_BY |
| PO_LINES_DRAFT_U1 | Unique | Default | PO_LINE_ID |