PO_LINES_INTERFACE
PO_LINES_INTERFACE is the interface table that holds lines information for the PDOI program to create standard/blanket purchase orders and catalog quotations. The PDOI program validates your data, derives or defaults additional information and writes an error message for every validation that fails into the PO_INTERFACE_ERRORS table. Scope: public Product: PO Display Name: PO Lines Interface Category: BUSINESS_ENTITY PO_BLANKET_PURCHASE_AGREEMENT Category: BUSINESS_ENTITY PO_CONTRACT_PURCHASE_AGREEMENT Category: BUSINESS_ENTITY PO_GLOBAL_BLANKET_AGREEMENT Category: BUSINESS_ENTITY PO_GLOBAL_CONTRACT_AGREEMENT Category: BUSINESS_ENTITY PO_PRICE_BREAKS Category: BUSINESS_ENTITY PO_STANDARD_PURCHASE_ORDER
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PO_LINES_INTERFACE_PK |
INTERFACE_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_HEADER_ID | NUMBER | 18 | Interface header unique identifier | ||
| 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 | ||
| SOURCE_AGREEMENT_PRC_BU_NAME | VARCHAR2 | 240 | Name of the procurement BU of suggested source agreement. | ||
| SOURCE_AGREEMENT | VARCHAR2 | 30 | Suggested source blanket agreement or contract agreement number. | ||
| SOURCE_AGREEMENT_LINE | NUMBER | Suggested source blanket agreement line num | |||
| WORK_ORDER_SUB_TYPE | VARCHAR2 | 30 | The display name used to identify the subtype of the manufacturing work order. | ||
| WORK_ORDER_OPERATION_SEQ | NUMBER | Indicates execution sequence of the work order operation. | |||
| WORK_ORDER_OPERATION_ID | NUMBER | 18 | The unique identifier of a work order operation sequence. | ||
| SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | 25 | Secondary Unit of measure | ||
| WORK_ORDER_NUMBER | VARCHAR2 | 120 | Indicates the contract manufacturing work order number. | ||
| WORK_ORDER_ID | NUMBER | 18 | Unique identifier for the contract manufacturing work order. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | LOAD_REQUEST_ID | ||
| INTERFACE_HEADER_KEY | VARCHAR2 | 50 | Header record identifier, unique across LOAD_RE QUEST_ID. Reserved for data uploaded through Cloud Interface only. | ||
| INTERFACE_LINE_KEY | VARCHAR2 | 50 | Line record identifier, unique across LOAD_REQU EST_ID. Reserved for data uploaded through Cloud Interface only. | ||
| SFO_PTR_ID | NUMBER | 18 | Unique identifier of a Primary Trade Relationship in an Orchestration Agreement. | ||
| SFO_AGREEMENT_NUMBER | VARCHAR2 | 100 | Indicates the orchestration agreement entered into between the legal entities, business units and trade organizations establishing a trade relationship. | ||
| SFO_AGREEMENT_LINE_NUMBER | NUMBER | 18 | Orchestration Agreement Line Number. | ||
| PO_TRADING_ORGANIZATION_ID | NUMBER | 18 | Purchasing Trading Organization unique identifier. Indicates the inventory organization where the trade buy-sell transaction defined by the orchestration agreement is cost accounted. | ||
| 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 | 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 | ||
| DESTINATION_TYPE_CODE | VARCHAR2 | 25 | Final destination of the purchased items | ||
| INTERFACE_LINE_ID | NUMBER | 18 | Yes | Interface line unique identifier | |
| GROUP_CODE | VARCHAR2 | 25 | Indicates the grouping of the requisition lines | ||
| REQUISITION_LINE_ID | NUMBER | 18 | Requisition line unique identifier | ||
| PO_HEADER_ID | NUMBER | 18 | Document header unique identifier | ||
| LINE_NUM | NUMBER | Document line number | |||
| PO_LINE_ID | NUMBER | 18 | Document line unique identifier | ||
| SHIPMENT_NUM | NUMBER | Document shipment number | |||
| LINE_LOCATION_ID | NUMBER | 18 | Document shipment unique identifier | ||
| SOURCE_SHIPMENT_ID | NUMBER | 18 | Source shipment for scheduled releases | ||
| SHIPMENT_TYPE | VARCHAR2 | 25 | Type of shipment | ||
| LINE_TYPE | VARCHAR2 | 30 | Line type | ||
| LINE_TYPE_ID | NUMBER | 18 | Line type unique identifier | ||
| ITEM | VARCHAR2 | 300 | Item | ||
| ITEM_ID | NUMBER | 18 | Item unique identifier | ||
| ITEM_REVISION | VARCHAR2 | 18 | Item revision | ||
| CATEGORY | VARCHAR2 | 2000 | Category | ||
| CATEGORY_ID | NUMBER | 18 | Category unique identifier | ||
| ITEM_DESCRIPTION | VARCHAR2 | 240 | Item description | ||
| UNIT_OF_MEASURE | VARCHAR2 | 25 | Unit of measure | ||
| QUANTITY | NUMBER | Quantity ordered on shipment | |||
| TAX_EXCLUSIVE_PRICE | NUMBER | The purchase order line price that is exclusive of all the taxes. | |||
| COMMITTED_AMOUNT | NUMBER | Amount agreed for an agreement line | |||
| UNIT_PRICE | NUMBER | Unit price for the line | |||
| LIST_PRICE_PER_UNIT | NUMBER | List price for the item on the line | |||
| MARKET_PRICE | NUMBER | Market price for the item on the line | |||
| ALLOW_PRICE_OVERRIDE_FLAG | VARCHAR2 | 1 | Indicates whether you can change the price on a release | ||
| NOT_TO_EXCEED_PRICE | NUMBER | Price limit that you cannot exceed on a release shipment | |||
| NEGOTIATED_BY_PREPARER_FLAG | VARCHAR2 | 1 | Indicates whether the buyer negotiated the price | ||
| UN_NUMBER | VARCHAR2 | 25 | UN number | ||
| UN_NUMBER_ID | NUMBER | 18 | UN number unique identifier | ||
| HAZARD_CLASS | VARCHAR2 | 40 | Hazard class | ||
| HAZARD_CLASS_ID | NUMBER | 18 | Hazard class unique identifier | ||
| NOTE_TO_VENDOR | VARCHAR2 | 1000 | Short note to supplier | ||
| VENDOR_PRODUCT_NUM | VARCHAR2 | 300 | Supplier item number | ||
| TAXABLE_FLAG | VARCHAR2 | 1 | Indicates whether line is taxable | ||
| TAX_NAME | VARCHAR2 | 30 | Tax 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 | ||
| INSPECTION_REQUIRED_FLAG | VARCHAR2 | 1 | Indicates whether shipment must be inspected before the invoice is paid | ||
| RECEIPT_REQUIRED_FLAG | VARCHAR2 | 1 | Indicates whether shipment must be received before the invoice is paid | ||
| PAYMENT_TERMS | VARCHAR2 | 50 | Payment terms | ||
| TERMS_ID | NUMBER | 18 | Payment terms unique identifier | ||
| PRICE_TYPE | VARCHAR2 | 25 | Price type | ||
| MIN_RELEASE_AMOUNT | NUMBER | Minimum release amount for the line | |||
| PRICE_BREAK_LOOKUP_CODE | VARCHAR2 | 25 | Price break type for blanket agreement line | ||
| CLOSED_REASON | VARCHAR2 | 240 | Close reason | ||
| CLOSED_DATE | DATE | Close date | |||
| CLOSED_BY | NUMBER | 18 | This is the user id of the person who closed the document | ||
| RECEIVE_CLOSE_TOLERANCE | NUMBER | Percentage tolerance within which a shipment is automatically closed for receiving | |||
| FIRM_STATUS_LOOKUP_CODE | VARCHAR2 | 30 | Firm Status | ||
| DAYS_EARLY_RECEIPT_ALLOWED | NUMBER | Maximum acceptable number of days items can be received early | |||
| DAYS_LATE_RECEIPT_ALLOWED | NUMBER | Maximum acceptable number of days items can be received late | |||
| ENFORCE_SHIP_TO_LOCATION_CODE | VARCHAR2 | 25 | Describes what action is taken when the receiving location differs from the ship-to location | ||
| ALLOW_SUBSTITUTE_RECEIPTS_FLAG | VARCHAR2 | 1 | Indicates whether substitute items can be received in place of the ordered items | ||
| RECEIVING_ROUTING | VARCHAR2 | 30 | Routing | ||
| RECEIVING_ROUTING_ID | NUMBER | Routing unique identifier | |||
| QTY_RCV_TOLERANCE | NUMBER | Maximum over-receipt tolerance percentage | |||
| OVER_TOLERANCE_ERROR_FLAG | VARCHAR2 | 25 | Percentage tolerance within which a shipment is automatically closed for invoicing when billed | ||
| QTY_RCV_EXCEPTION_CODE | VARCHAR2 | 25 | Action to be taken when the quantity received tolerance is exceeded | ||
| RECEIPT_DAYS_EXCEPTION_CODE | VARCHAR2 | 25 | Action to be taken when items are received earlier or later than the allowed number of days specified | ||
| SHIP_TO_ORGANIZATION_ID | NUMBER | 18 | Ship-to organization unique identifier | ||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | Ship-to location unique identifier | ||
| NEED_BY_DATE | DATE | Date the goods are needed by | |||
| REQUESTED_SHIP_DATE | DATE | A date that the buying company requests the ordered item ready to ship. | |||
| PROMISED_DATE | DATE | Date the goods are promised by | |||
| PROMISED_SHIP_DATE | DATE | A date that the supplier has promised to ship the item ordered by the buying company. | |||
| ACCRUE_ON_RECEIPT_FLAG | VARCHAR2 | 1 | Indicates whether items are accrued upon receipt | ||
| LEAD_TIME | NUMBER | Lead time for the price break (applies to RFQs and quotations only) | |||
| LEAD_TIME_UNIT | VARCHAR2 | 25 | Unit of measure for the lead time | ||
| PRICE_DISCOUNT | NUMBER | Discount percentage for price break (applies to RFQs and quotations only) | |||
| FREIGHT_CARRIER | VARCHAR2 | 360 | Type of carrier for the RFQ or quotation shipment | ||
| FOB | VARCHAR2 | 25 | Type of free-on-board terms for the shipment | ||
| FREIGHT_TERMS | VARCHAR2 | 25 | Type of freight terms for the RFQ or quotation shipment | ||
| FROM_HEADER_ID | NUMBER | 18 | Unique identifier of the RFQ used to autocreate the quotation | ||
| FROM_LINE_ID | NUMBER | 18 | Unique identifier of the RFQ line used to autocreate the quotation line | ||
| FROM_LINE_LOCATION_ID | NUMBER | 18 | Unique identifier of the RFQ shipment used to autocreate a quotation shipment | ||
| LINE_ATTRIBUTE_CATEGORY_LINES | VARCHAR2 | 30 | Descriptive flexfield segment | ||
| LINE_ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| LINE_ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| LINE_ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| LINE_ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| LINE_ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| LINE_ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| LINE_ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| LINE_ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| LINE_ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| LINE_ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| LINE_ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| LINE_ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| LINE_ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| LINE_ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| LINE_ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition 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. | |||
| SHIPMENT_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive flexfield segment | ||
| SHIPMENT_ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| SHIPMENT_ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| SHIPMENT_ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| SHIPMENT_ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| SHIPMENT_ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| SHIPMENT_ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| SHIPMENT_ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| SHIPMENT_ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| SHIPMENT_ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| SHIPMENT_ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| SHIPMENT_ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| SHIPMENT_ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| SHIPMENT_ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| SHIPMENT_ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| SHIPMENT_ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive flexfield segment | ||
| 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. | |
| 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. | |
| 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 | ||
| ACTION | VARCHAR2 | 25 | Action to be completed: New or Add | ||
| DOCUMENT_NUM | NUMBER | Document number | |||
| UOM_CODE | VARCHAR2 | 3 | 3-letter unit of measure code | ||
| FIRM_FLAG | VARCHAR2 | 25 | Indicates whether you want to prevent this purchase order from being automatically rescheduled by your manufacturing application | ||
| SHIP_TO_ORGANIZATION_CODE | VARCHAR2 | 18 | Ship-to organization code | ||
| SHIP_TO_LOCATION | VARCHAR2 | 60 | Ship-to location | ||
| EFFECTIVE_DATE | DATE | Effective date of the price break (applies to RFQs and quotations only) | |||
| EXPIRATION_DATE | DATE | Expiration date of the price break (applies to RFQs and quotations only) | |||
| INVOICE_CLOSE_TOLERANCE | NUMBER | Percentage tolerance within which a shipment is automatically closed for invoicing when billed | |||
| ORGANIZATION_ID | NUMBER | 18 | Needed for 832 EDI transaction | ||
| ITEM_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Needed for 832 EDI transaction | ||
| ITEM_ATTRIBUTE1 | VARCHAR2 | 150 | Needed for 832 EDI transaction | ||
| ITEM_ATTRIBUTE2 | VARCHAR2 | 150 | Needed for 832 EDI transaction | ||
| ITEM_ATTRIBUTE3 | VARCHAR2 | 150 | Needed for 832 EDI transaction | ||
| ITEM_ATTRIBUTE4 | VARCHAR2 | 150 | Needed for 832 EDI transaction | ||
| ITEM_ATTRIBUTE5 | VARCHAR2 | 150 | Needed for 832 EDI transaction | ||
| ITEM_ATTRIBUTE6 | VARCHAR2 | 150 | Needed for 832 EDI transaction | ||
| ITEM_ATTRIBUTE7 | VARCHAR2 | 150 | Needed for 832 EDI transaction | ||
| ITEM_ATTRIBUTE8 | VARCHAR2 | 150 | Needed for 832 EDI transaction | ||
| ITEM_ATTRIBUTE9 | VARCHAR2 | 150 | Needed for 832 EDI transaction | ||
| ITEM_ATTRIBUTE10 | VARCHAR2 | 150 | Needed for the 832 EDI transaction | ||
| ITEM_ATTRIBUTE11 | VARCHAR2 | 150 | Needed for the 832 EDI transaction | ||
| ITEM_ATTRIBUTE12 | VARCHAR2 | 150 | Needed for the 832 EDI transaction | ||
| ITEM_ATTRIBUTE13 | VARCHAR2 | 150 | Needed for the 832 EDI transaction | ||
| ITEM_ATTRIBUTE14 | VARCHAR2 | 150 | Needed for the 832 EDI transaction | ||
| ITEM_ATTRIBUTE15 | VARCHAR2 | 150 | Needed for 832 EDI transaction | ||
| UNIT_WEIGHT | NUMBER | Needed for 832 EDI transaction | |||
| WEIGHT_UOM_CODE | VARCHAR2 | 3 | Needed for 832 EDI transaction | ||
| WEIGHT_UNIT_OF_MEASURE | VARCHAR2 | 25 | WEIGHT_UNIT_OF_MEASURE | ||
| VOLUME_UOM_CODE | VARCHAR2 | 3 | Needed for 832 EDI transaction | ||
| VOLUME_UNIT_OF_MEASURE | VARCHAR2 | 25 | VOLUME_UNIT_OF_MEASURE | ||
| UNIT_VOLUME | NUMBER | Needed for 832 EDI transaction | |||
| TEMPLATE_ID | NUMBER | 18 | Needed for 832 EDI transaction | ||
| TEMPLATE_NAME | VARCHAR2 | 30 | Needed for 832 EDI transaction | ||
| LINE_REFERENCE_NUM | VARCHAR2 | 25 | Value used to identify the line record in the external system from where it was imported. | ||
| SOURCING_RULE_NAME | VARCHAR2 | 50 | Name of the sourcing rule created by purchasing documents open interface | ||
| TAX_STATUS_INDICATOR | VARCHAR2 | 30 | Tax status such as nonexempt or exempt | ||
| PROCESS_CODE | VARCHAR2 | 25 | Line status code for price/sales catalog update action (832 EDI transaction), such as NOTIFIED, ACCEPTED, or REJECTED | ||
| PRICE_CHG_ACCEPT_FLAG | VARCHAR2 | 1 | Indicator of whether the price increase in a price/sales catalog update (832 EDI transaction) has been accepted by the buyer | ||
| PRICE_BREAK_FLAG | VARCHAR2 | 1 | Indicator of whether the record is a price break for the price/sales catalog update (832 EDI transaction). Both line and price break records are stored in this table. | ||
| PRICE_UPDATE_TOLERANCE | NUMBER | Maximum percentage increase allowed to price , without buyer approval in price/sales catalog update (832 EDI transaction) sent by supplier | |||
| TAX_USER_OVERRIDE_FLAG | VARCHAR2 | 1 | Indicator of whether someone has overridden the default tax | ||
| TAX_CODE_ID | NUMBER | 18 | Unique identifier for the tax code | ||
| NOTE_TO_RECEIVER | VARCHAR2 | 1000 | Note to deliverer | ||
| OKE_CONTRACT_HEADER_ID | NUMBER | 18 | Oracle project contracts unique id for contract number | ||
| OKE_CONTRACT_HEADER_NUM | VARCHAR2 | 120 | Oracle project contracts contract number | ||
| OKE_CONTRACT_VERSION_ID | NUMBER | 18 | Oracle project contracts version number | ||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | OPM: Secondary unit of measure for the quantity ordered | ||
| SECONDARY_QUANTITY | NUMBER | Quantity ordered on shipment in secondary unit of measure | |||
| PREFERRED_GRADE | VARCHAR2 | 150 | Preferred quality grade of the item ordered | ||
| VMI_FLAG | VARCHAR2 | 1 | Indicates VMI shipment line with value = 'Y' | ||
| AUCTION_HEADER_ID | NUMBER | 18 | Auction Unique identifier from pon_auction_headers, Oracle Sourcing | ||
| AUCTION_LINE_NUMBER | NUMBER | Auction line number from pon_auction_item_prices, Oracle Sourcing | |||
| AUCTION_DISPLAY_NUMBER | VARCHAR2 | 240 | This will be the concatenation of auction_header_id_orig_round and auction_round_number for multiround auctions, These columns are referenced from pon_auction_headers | ||
| BID_NUMBER | NUMBER | Bid unique identifier from pon_bid_headers, Oracle sourcing | |||
| BID_LINE_NUMBER | NUMBER | Bid line number from pon_bid_item_prices, Oracle Sourcing | |||
| ORIG_FROM_REQ_FLAG | VARCHAR2 | 1 | Indicates whether this interface record is Originated from a req or not, Oracle sourcing would populate this column with 'N' from excess award negotiations and any negotiations which are directly createad in oracle sourcing. | ||
| CONSIGNED_FLAG | VARCHAR2 | 1 | Indicates shipment is consigned | ||
| SUPPLIER_PART_AUXID | VARCHAR2 | 255 | Supplier Part Auxiliary Id | ||
| 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 Reference Information of a Line. Links back to a record with type_lookup_code = 'CONTRACT' in PO_HEADERS_ALL | ||
| JOB_ID | NUMBER | 18 | Reference to the HR Job for service lines | ||
| AMOUNT | NUMBER | Amount Ordered for Service line types | |||
| JOB_NAME | VARCHAR2 | 240 | HR job name for temporary labor lines | ||
| CONTRACTOR_FIRST_NAME | VARCHAR2 | 240 | Contractor first name | ||
| CONTRACTOR_LAST_NAME | VARCHAR2 | 240 | Contractor Last Name for Temporary labor lines | ||
| DROP_SHIP_FLAG | VARCHAR2 | 1 | Indicates whether the Shipment has a backing Sales Order Line. | ||
| BASE_UNIT_PRICE | NUMBER | Base Unit Price | |||
| TRANSACTION_FLOW_HEADER_ID | NUMBER | 18 | Unique transaction flow identifier for relation between purchasing OU and ship to OU. This column is meant for Internal use only | ||
| JOB_BUSINESS_GROUP_ID | NUMBER | 18 | ID of the business group to which the job title (HR job for services lines) in the interface table belongs. References PER_BUSINESS_GROUPS_PERF.business_group_id. | ||
| JOB_BUSINESS_GROUP_NAME | VARCHAR2 | 240 | Name of the business group to which the job title (HR job for services lines) in the interface table belongs. References PER_BUSINESS_GROUPS_PERF.name. | ||
| TRACKING_QUANTITY_IND | VARCHAR2 | 30 | Indicator to define whether item is tracked in primary unit of measure or also in secondary unoit of measure | ||
| SECONDARY_DEFAULT_IND | VARCHAR2 | 30 | Indicator to define the secondary default of the item. | ||
| DUAL_UOM_DEVIATION_HIGH | NUMBER | Deviation allowed at the high end of the item | |||
| DUAL_UOM_DEVIATION_LOW | NUMBER | Deviation allowed at the low end of the item | |||
| PROCESSING_ID | NUMBER | Identifier for records to be processed in a caertain PDOI run | |||
| LINE_LOC_POPULATED_FLAG | VARCHAR2 | 1 | Indicate whether user has already added shipment information to PO_LINE_LOCATIONS_INTERFACE table. NULL or 'N' indicates that no record is populated to PO_LINE_LOCATIONS_INTERFACE for this record | ||
| RETAINAGE_RATE | NUMBER | Maximum percentage that can be withheld from invoices for Pay Items | |||
| MAX_RETAINAGE_AMOUNT | NUMBER | Maximum retainage to withhold for this 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 | |||
| ADVANCE_AMOUNT | NUMBER | Amount that can be paid as an Advance against this line | |||
| FILE_LINE_NUMBER | NUMBER | This column is used by catalog upload. The value indicates the record number in the uploaded file. | |||
| PARENT_INTERFACE_LINE_ID | NUMBER | 18 | This column is only used by PDOI to indicate the parent interface line. This is populated when the interface line has UPDATE action against another line in the interface table. | ||
| FILE_LINE_LANGUAGE | VARCHAR2 | 4 | Internal use only. This column is used by catalog upload to indicate the language of the catalog line. Only the columns supported by catalog upload will honor the value of this flag | ||
| 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. | |
| BACK_TO_BACK_FLAG | VARCHAR2 | 1 | Indicates the purchase order schedule has a backing sales order that is fulfilled using a back to back order. | ||
| CUSTOMER_PO_NUMBER | VARCHAR2 | 50 | Customer PO number on the Sales Order. PO number reference that represents the commercial document that is used to request a seller to supply a product or service in return for payment. | ||
| CUSTOMER_PO_LINE_NUMBER | VARCHAR2 | 50 | An identifier of the customer PO line record. The customer PO line describes an item or service requested by the end customer. | ||
| CUSTOMER_PO_SCHEDULE_NUMBER | VARCHAR2 | 50 | An identifier of the customer PO schedule record. The customer PO schedule describes an item or service requested by the end customer. | ||
| CUSTOMER_ITEM | VARCHAR2 | 25 | An alternate key for the internal item used by customers to uniquely identify the item. This number will have a cross- reference to the internal item. | ||
| CUSTOMER_ITEM_DESC | VARCHAR2 | 240 | Description of the item identifier used by customers. | ||
| SALES_ORDER_NUMBER | VARCHAR2 | 50 | Backing Sales Order Number | ||
| SALES_ORDER_LINE_NUMBER | VARCHAR2 | 50 | Backing Sales Order Line Number | ||
| SALES_ORDER_SCHEDULE_NUMBER | VARCHAR2 | 50 | Backing Sales Order Schedule Number | ||
| SHIP_TO_CUST_LOCATION_ID | NUMBER | 18 | Location where the supplier should ship the goods. | ||
| SHIP_TO_CUST_ID | NUMBER | 18 | Customer to whom merchandise is being sent. | ||
| SHIP_TO_CUST_CONTACT_ID | NUMBER | 18 | Contact from the company where the good are shipped. | ||
| PARENT_ITEM | VARCHAR2 | 300 | (BPA Only, CTO Only) The buying organization's parent option class or model for the option/item or model. | ||
| 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 | VARCHAR2 | 300 | (BPA Only, CTO Only) The buying organization's top model associated with the option/option class/submodel. | ||
| 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. | |||
| WORK_ORDER_PRODUCT | VARCHAR2 | 300 | Indicates the finished good product of the contract manufacturing work order. | ||
| QUANTITY_COMMITTED | NUMBER | Quantity agreed for the agreement line between the buying and selling organization. | |||
| ALLOW_DESCRIPTION_UPDATE_FLAG | VARCHAR2 | 1 | Determines if item description can be updated on order lines referencing this agreement line. | ||
| GROUP_REQUISITION_LINES | VARCHAR2 | 1 | This flag is used to indicate whether the line needs to be considered for grouping of PO Lines. | ||
| SHIPPING_UOM_CODE | VARCHAR2 | 3 | Unit of measure that the supplier is requested to ship in. (References INV_UNITS_OF_MEASURE.uom_code.) | ||
| SHIPPING_UNIT_OF_MEASURE | VARCHAR2 | 25 | Shipping Unit of Measure Name that the supplier is requested to ship in. (References INV_UNITS_OF_MEASURE_TL.unit_of_measure.) | ||
| SHIPPING_UOM_QUANTITY | NUMBER | Quantity ordered on line in shipping unit of measure | |||
| 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 |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| po_attr_values_interface | po_lines_interface | INTERFACE_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PO_LINES_INTERFACE_N10 | Non Unique | Default | SHIP_TO_CUST_ID |
| PO_LINES_INTERFACE_N2 | Non Unique | Default | INTERFACE_HEADER_ID, LINE_TYPE_ID |
| PO_LINES_INTERFACE_N3 | Non Unique | Default | LINE_NUM |
| PO_LINES_INTERFACE_N4 | Non Unique | Default | REQUISITION_LINE_ID |
| PO_LINES_INTERFACE_N5 | Non Unique | Default | AUCTION_HEADER_ID, AUCTION_LINE_NUMBER |
| PO_LINES_INTERFACE_N6 | Non Unique | Default | PROCESSING_ID |
| PO_LINES_INTERFACE_N8 | Non Unique | Default | PO_LINE_ID |
| PO_LINES_INTERFACE_N9 | Non Unique | Default | INTERFACE_HEADER_KEY, LOAD_REQUEST_ID |
| PO_LINES_INTERFACE_U1 | Unique | Default | INTERFACE_LINE_ID |