[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PO_LINES_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | PO |
| FND Design Data: |  PO.PO_LINES_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
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
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PO_LINES_INTERFACE_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 INTERFACE_LINE_ID
|
| PO_LINES_INTERFACE_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
INTERFACE_HEADER_ID
LINE_TYPE_ID
|
| PO_LINES_INTERFACE_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
LINE_NUM
|
| PO_LINES_INTERFACE_N4 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
REQUISITION_LINE_ID
|
| PO_LINES_INTERFACE_N5 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
AUCTION_HEADER_ID
AUCTION_LINE_NUMBER
|
| PO_LINES_INTERFACE_N6 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PROCESSING_ID
|
| PO_LINES_INTERFACE_N7 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
IP_CATEGORY_ID
INTERFACE_HEADER_ID
|
| PO_LINES_INTERFACE_N8 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PO_LINE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INTERFACE_LINE_ID | NUMBER | Yes | Interface line unique identifier | |
| INTERFACE_HEADER_ID | NUMBER | Yes | Interface header unique identifier | |
| ACTION | VARCHAR2 | (25) | Action to be completed: New or Add | |
| GROUP_CODE | VARCHAR2 | (25) | Indicates the grouping of the requisition lines | |
| LINE_NUM | NUMBER | Document line number | ||
| PO_LINE_ID | NUMBER | Document line unique identifier | ||
| SHIPMENT_NUM | NUMBER | Document shipment number | ||
| LINE_LOCATION_ID | NUMBER | Document shipment unique identifier | ||
| SHIPMENT_TYPE | VARCHAR2 | (25) | Type of shipment | |
| REQUISITION_LINE_ID | NUMBER | Requisition line unique identifier | ||
| DOCUMENT_NUM | NUMBER | Document number | ||
| RELEASE_NUM | NUMBER | Release number | ||
| PO_HEADER_ID | NUMBER | Document header unique identifier | ||
| PO_RELEASE_ID | NUMBER | Release unique identifier | ||
| SOURCE_SHIPMENT_ID | NUMBER | Source shipment for scheduled releases | ||
| CONTRACT_NUM | VARCHAR2 | (25) | Contract number that the line references. Obsoleted in PO FPJ 11.5.10 | |
| LINE_TYPE | VARCHAR2 | (25) | Line type | |
| LINE_TYPE_ID | NUMBER | Line type unique identifier | ||
| ITEM | VARCHAR2 | (1000) | Item | |
| ITEM_ID | NUMBER | Item unique identifier | ||
| ITEM_REVISION | VARCHAR2 | (3) | Item revision | |
| CATEGORY | VARCHAR2 | (2000) | Category | |
| CATEGORY_ID | NUMBER | Category unique identifier | ||
| ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
| VENDOR_PRODUCT_NUM | VARCHAR2 | (25) | Supplier item number | |
| UOM_CODE | VARCHAR2 | (3) | 3-letter unit of measure code | |
| UNIT_OF_MEASURE | VARCHAR2 | (25) | Unit of measure | |
| QUANTITY | NUMBER | Quantity ordered on shipment | ||
| COMMITTED_AMOUNT | NUMBER | Amount agreed for an agreement line | ||
| MIN_ORDER_QUANTITY | NUMBER | Minimum order quantity for a quotation line | ||
| MAX_ORDER_QUANTITY | NUMBER | Maximum order quantity for a quotation 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 | UN number unique identifier | ||
| HAZARD_CLASS | VARCHAR2 | (40) | Hazard class | |
| HAZARD_CLASS_ID | NUMBER | Hazard class unique identifier | ||
| NOTE_TO_VENDOR | VARCHAR2 | (480) | Short note to supplier | |
| TRANSACTION_REASON_CODE | VARCHAR2 | (25) | Nature of transaction | |
| 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 | 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 | |
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | United States standard general ledger transaction code | |
| CLOSED_CODE | VARCHAR2 | (25) | Close status | |
| CLOSED_REASON | VARCHAR2 | (240) | Close reason | |
| CLOSED_DATE | DATE | Close date | ||
| CLOSED_BY | NUMBER | This is the user id of the person who closed the document | ||
| INVOICE_CLOSE_TOLERANCE | NUMBER | Percentage tolerance within which a shipment is automatically closed for invoicing when billed | ||
| RECEIVE_CLOSE_TOLERANCE | NUMBER | Percentage tolerance within which a shipment is automatically closed for receiving | ||
| FIRM_FLAG | VARCHAR2 | (25) | Indicates whether you want to prevent this purchase order from being automatically rescheduled by your manufacturing application | |
| 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_CODE | VARCHAR2 | (3) | Ship-to organization code | |
| SHIP_TO_ORGANIZATION_ID | NUMBER | Ship-to organization unique identifier | ||
| SHIP_TO_LOCATION | VARCHAR2 | (60) | Ship-to location | |
| SHIP_TO_LOCATION_ID | NUMBER | Ship-to location unique identifier | ||
| NEED_BY_DATE | DATE | Date the goods are needed by | ||
| PROMISED_DATE | DATE | Date the goods are promised by | ||
| 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 | (80) | 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 | |
| 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) | ||
| FROM_HEADER_ID | NUMBER | Unique identifier of the RFQ used to autocreate the quotation | ||
| FROM_LINE_ID | NUMBER | Unique identifier of the RFQ line used to autocreate the quotation line | ||
| FROM_LINE_LOCATION_ID | NUMBER | 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 | |
| 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 | DATE | Standard Who column - date when a user last updated this row. | ||
| LAST_UPDATED_BY | NUMBER | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
| REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
| PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
| ORGANIZATION_ID | NUMBER | 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 | |
| VOLUME_UOM_CODE | VARCHAR2 | (3) | Needed for 832 EDI transaction | |
| UNIT_VOLUME | NUMBER | Needed for 832 EDI transaction | ||
| TEMPLATE_ID | NUMBER | Needed for 832 EDI transaction | ||
| TEMPLATE_NAME | VARCHAR2 | (30) | Needed for 832 EDI transaction | |
| LINE_REFERENCE_NUM | VARCHAR2 | (25) | Needed for 832 EDI transaction | |
| 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 | (15) | Unique identifier for the tax code | |
| NOTE_TO_RECEIVER | VARCHAR2 | (480) | Note to deliverer | |
| OKE_CONTRACT_HEADER_ID | NUMBER | Oracle project contracts unique id for contract number | ||
| OKE_CONTRACT_HEADER_NUM | VARCHAR2 | (120) | Oracle project contracts contract number | |
| OKE_CONTRACT_VERSION_ID | NUMBER | Oracle project contracts version number | ||
| SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | Secondary unit of measure | |
| SECONDARY_UOM_CODE | VARCHAR2 | (3) | Abbreviated secondary unit of measure | |
| 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 | 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 | (40) | 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_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 | Contract Reference Information of a Line. Links back to a record with type_lookup_code = 'CONTRACT' in PO_HEADERS_ALL | ||
| JOB_ID | NUMBER | 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 | 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 | (15) | 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. | |
| CATALOG_NAME | VARCHAR2 | (255) | This is to support the replacement of catalogs for CIF format | |
| SUPPLIER_PART_AUXID | VARCHAR2 | (255) | Supplier Part Auxiliary Id | |
| IP_CATEGORY_ID | NUMBER | IP Category Id for GBPA Lines (-2 stored for null values) | ||
| 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 | |
| IP_CATEGORY_NAME | VARCHAR2 | (250) | IP category name | |
| 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 | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_LINE_ID
, INTERFACE_HEADER_ID
, ACTION
, GROUP_CODE
, LINE_NUM
, PO_LINE_ID
, SHIPMENT_NUM
, LINE_LOCATION_ID
, SHIPMENT_TYPE
, REQUISITION_LINE_ID
, DOCUMENT_NUM
, RELEASE_NUM
, PO_HEADER_ID
, PO_RELEASE_ID
, SOURCE_SHIPMENT_ID
, CONTRACT_NUM
, LINE_TYPE
, LINE_TYPE_ID
, ITEM
, ITEM_ID
, ITEM_REVISION
, CATEGORY
, CATEGORY_ID
, ITEM_DESCRIPTION
, VENDOR_PRODUCT_NUM
, UOM_CODE
, UNIT_OF_MEASURE
, QUANTITY
, COMMITTED_AMOUNT
, MIN_ORDER_QUANTITY
, MAX_ORDER_QUANTITY
, UNIT_PRICE
, LIST_PRICE_PER_UNIT
, MARKET_PRICE
, ALLOW_PRICE_OVERRIDE_FLAG
, NOT_TO_EXCEED_PRICE
, NEGOTIATED_BY_PREPARER_FLAG
, UN_NUMBER
, UN_NUMBER_ID
, HAZARD_CLASS
, HAZARD_CLASS_ID
, NOTE_TO_VENDOR
, TRANSACTION_REASON_CODE
, TAXABLE_FLAG
, TAX_NAME
, TYPE_1099
, CAPITAL_EXPENSE_FLAG
, INSPECTION_REQUIRED_FLAG
, RECEIPT_REQUIRED_FLAG
, PAYMENT_TERMS
, TERMS_ID
, PRICE_TYPE
, MIN_RELEASE_AMOUNT
, PRICE_BREAK_LOOKUP_CODE
, USSGL_TRANSACTION_CODE
, CLOSED_CODE
, CLOSED_REASON
, CLOSED_DATE
, CLOSED_BY
, INVOICE_CLOSE_TOLERANCE
, RECEIVE_CLOSE_TOLERANCE
, FIRM_FLAG
, DAYS_EARLY_RECEIPT_ALLOWED
, DAYS_LATE_RECEIPT_ALLOWED
, ENFORCE_SHIP_TO_LOCATION_CODE
, ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, RECEIVING_ROUTING
, RECEIVING_ROUTING_ID
, QTY_RCV_TOLERANCE
, OVER_TOLERANCE_ERROR_FLAG
, QTY_RCV_EXCEPTION_CODE
, RECEIPT_DAYS_EXCEPTION_CODE
, SHIP_TO_ORGANIZATION_CODE
, SHIP_TO_ORGANIZATION_ID
, SHIP_TO_LOCATION
, SHIP_TO_LOCATION_ID
, NEED_BY_DATE
, PROMISED_DATE
, ACCRUE_ON_RECEIPT_FLAG
, LEAD_TIME
, LEAD_TIME_UNIT
, PRICE_DISCOUNT
, FREIGHT_CARRIER
, FOB
, FREIGHT_TERMS
, EFFECTIVE_DATE
, EXPIRATION_DATE
, FROM_HEADER_ID
, FROM_LINE_ID
, FROM_LINE_LOCATION_ID
, LINE_ATTRIBUTE_CATEGORY_LINES
, LINE_ATTRIBUTE1
, LINE_ATTRIBUTE2
, LINE_ATTRIBUTE3
, LINE_ATTRIBUTE4
, LINE_ATTRIBUTE5
, LINE_ATTRIBUTE6
, LINE_ATTRIBUTE7
, LINE_ATTRIBUTE8
, LINE_ATTRIBUTE9
, LINE_ATTRIBUTE10
, LINE_ATTRIBUTE11
, LINE_ATTRIBUTE12
, LINE_ATTRIBUTE13
, LINE_ATTRIBUTE14
, LINE_ATTRIBUTE15
, SHIPMENT_ATTRIBUTE_CATEGORY
, SHIPMENT_ATTRIBUTE1
, SHIPMENT_ATTRIBUTE2
, SHIPMENT_ATTRIBUTE3
, SHIPMENT_ATTRIBUTE4
, SHIPMENT_ATTRIBUTE5
, SHIPMENT_ATTRIBUTE6
, SHIPMENT_ATTRIBUTE7
, SHIPMENT_ATTRIBUTE8
, SHIPMENT_ATTRIBUTE9
, SHIPMENT_ATTRIBUTE10
, SHIPMENT_ATTRIBUTE11
, SHIPMENT_ATTRIBUTE12
, SHIPMENT_ATTRIBUTE13
, SHIPMENT_ATTRIBUTE14
, SHIPMENT_ATTRIBUTE15
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORGANIZATION_ID
, ITEM_ATTRIBUTE_CATEGORY
, ITEM_ATTRIBUTE1
, ITEM_ATTRIBUTE2
, ITEM_ATTRIBUTE3
, ITEM_ATTRIBUTE4
, ITEM_ATTRIBUTE5
, ITEM_ATTRIBUTE6
, ITEM_ATTRIBUTE7
, ITEM_ATTRIBUTE8
, ITEM_ATTRIBUTE9
, ITEM_ATTRIBUTE10
, ITEM_ATTRIBUTE11
, ITEM_ATTRIBUTE12
, ITEM_ATTRIBUTE13
, ITEM_ATTRIBUTE14
, ITEM_ATTRIBUTE15
, UNIT_WEIGHT
, WEIGHT_UOM_CODE
, VOLUME_UOM_CODE
, UNIT_VOLUME
, TEMPLATE_ID
, TEMPLATE_NAME
, LINE_REFERENCE_NUM
, SOURCING_RULE_NAME
, TAX_STATUS_INDICATOR
, PROCESS_CODE
, PRICE_CHG_ACCEPT_FLAG
, PRICE_BREAK_FLAG
, PRICE_UPDATE_TOLERANCE
, TAX_USER_OVERRIDE_FLAG
, TAX_CODE_ID
, NOTE_TO_RECEIVER
, OKE_CONTRACT_HEADER_ID
, OKE_CONTRACT_HEADER_NUM
, OKE_CONTRACT_VERSION_ID
, SECONDARY_UNIT_OF_MEASURE
, SECONDARY_UOM_CODE
, SECONDARY_QUANTITY
, PREFERRED_GRADE
, VMI_FLAG
, AUCTION_HEADER_ID
, AUCTION_LINE_NUMBER
, AUCTION_DISPLAY_NUMBER
, BID_NUMBER
, BID_LINE_NUMBER
, ORIG_FROM_REQ_FLAG
, CONSIGNED_FLAG
, SUPPLIER_REF_NUMBER
, CONTRACT_ID
, JOB_ID
, AMOUNT
, JOB_NAME
, CONTRACTOR_FIRST_NAME
, CONTRACTOR_LAST_NAME
, DROP_SHIP_FLAG
, BASE_UNIT_PRICE
, TRANSACTION_FLOW_HEADER_ID
, JOB_BUSINESS_GROUP_ID
, JOB_BUSINESS_GROUP_NAME
, CATALOG_NAME
, SUPPLIER_PART_AUXID
, IP_CATEGORY_ID
, TRACKING_QUANTITY_IND
, SECONDARY_DEFAULT_IND
, DUAL_UOM_DEVIATION_HIGH
, DUAL_UOM_DEVIATION_LOW
, PROCESSING_ID
, LINE_LOC_POPULATED_FLAG
, IP_CATEGORY_NAME
, RETAINAGE_RATE
, MAX_RETAINAGE_AMOUNT
, PROGRESS_PAYMENT_RATE
, RECOUPMENT_RATE
, ADVANCE_AMOUNT
, FILE_LINE_NUMBER
, PARENT_INTERFACE_LINE_ID
, FILE_LINE_LANGUAGE
FROM PO.PO_LINES_INTERFACE;
PO.PO_LINES_INTERFACE does not reference any database object
PO.PO_LINES_INTERFACE is referenced by following:
APPS
PO_LINES_INTERFACE
|
|
|
|