PO_LINE_LOCATIONS_INTERFACE
PO_LINE_LOCATIONS_INTERFACE is the interface table that holds line locations 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_LINE_LOCATIONS_INTERFA_PK |
INTERFACE_LINE_LOCATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_LINE_LOCATION_ID | NUMBER | 18 | Yes | Interface line location unique identifier | |
| INVOICE_MATCH_OPTION | VARCHAR2 | 25 | Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt.This column stores the displayed value. | ||
| INVOICE_MATCH_OPTION_CODE | VARCHAR2 | 25 | Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt.It is mapped to the column MATCH_OPTION on other PO_LINE_LOCATIONS_% table. | ||
| SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | 25 | Secondary Unit of measure | ||
| EXTERNAL_SYS_RCV_INTF_CO_SEQ | NUMBER | 18 | To be set by Receiving to track the last version of the PO Schedule that was interfaced. | ||
| ORCHESTRATION_CODE | VARCHAR2 | 20 | A code that indicates of the integrating application is orchestrating changes between their application and Fusion Procurement. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | LOAD_REQUEST_ID | ||
| INTERFACE_LINE_LOCATION_KEY | VARCHAR2 | 50 | Schedule record identifier, unique across LOAD_ REQUEST_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. | ||
| UOM_CODE | VARCHAR2 | 3 | UOM_CODE | ||
| ENFORCE_SHIP_TO_LOCATION_CODE | VARCHAR2 | 25 | ENFORCE_SHIP_TO_LOCATION_CODE | ||
| INTERFACE_HEADER_ID | NUMBER | 18 | Interface header unique identifier | ||
| INTERFACE_LINE_ID | NUMBER | 18 | Interface line unique identifier | ||
| PROCESSING_ID | NUMBER | Identifier for the line locations processed in current request | |||
| PROCESS_CODE | VARCHAR2 | 25 | Line status code for price/sales catalog update action (832 EDI transaction), such as NOTIFIED, ACCEPTED, or REJECTED | ||
| LINE_LOCATION_ID | NUMBER | 18 | Document shipment schedule unique identifier | ||
| SHIPMENT_TYPE | VARCHAR2 | 25 | Type of shipment | ||
| SHIPMENT_NUM | NUMBER | Document shipment number | |||
| SHIP_TO_ORGANIZATION_ID | NUMBER | 18 | Ship-to organization unique identifier | ||
| SHIP_TO_ORGANIZATION_CODE | VARCHAR2 | 18 | Ship-to organization code | ||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | Ship-to location unique identifier | ||
| SHIP_TO_LOCATION | VARCHAR2 | 60 | Ship-to location | ||
| TERMS_ID | NUMBER | 18 | Payment terms unique identifier | ||
| PAYMENT_TERMS | VARCHAR2 | 50 | Payment terms | ||
| QTY_RCV_EXCEPTION_CODE | VARCHAR2 | 25 | Action to be taken when the quantity received tolerance is exceeded | ||
| ALLOW_SUBSTITUTE_RECEIPTS_FLAG | VARCHAR2 | 1 | Indicates whether substitute items can be received in place of the ordered items | ||
| 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 | |||
| RECEIPT_DAYS_EXCEPTION_CODE | VARCHAR2 | 25 | Action to be taken when items are received earlier or later than the allowed number of days specified | ||
| 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 | |||
| RECEIVING_ROUTING_ID | NUMBER | 18 | Routing unique identifier | ||
| RECEIVING_ROUTING | VARCHAR2 | 30 | Routing | ||
| ACCRUE_ON_RECEIPT_FLAG | VARCHAR2 | 1 | Indicates whether items are accrued upon receipt | ||
| FIRM_FLAG | VARCHAR2 | 25 | Indicates whether you want to prevent this purchase order from being automatically rescheduled by your manufacturing application | ||
| NEED_BY_DATE | DATE | Date the goods are needed by | |||
| PROMISED_DATE | DATE | Date the goods are promised by | |||
| 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 | ||
| NOTE_TO_RECEIVER | VARCHAR2 | 1000 | Note to deliverer | ||
| 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 | ||
| QUANTITY | NUMBER | Quantity ordered on shipment | |||
| PRICE_DISCOUNT | NUMBER | Discount percentage for price break (applies to RFQs and quotations only) | |||
| START_DATE | DATE | Effective date of the price break (applies to RFQs and quotations only) | |||
| END_DATE | DATE | Expiration date of the price break (applies to RFQs and quotations only) | |||
| PRICE_OVERRIDE | NUMBER | Order shipment price or break price for blanket purchase orders, RFQs, and quotations | |||
| 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 | ||
| AMOUNT | NUMBER | Amount Ordered for Service line types | |||
| SECONDARY_QUANTITY | NUMBER | Quantity ordered on shipment in secondary unit of measure | |||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | Secondary unit of measure for the quantity ordered | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| 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. | |
| 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. | ||
| 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 | ||
| UNIT_OF_MEASURE | VARCHAR2 | 25 | Unit of measure | ||
| PAYMENT_TYPE | VARCHAR2 | 30 | Type of Pay Item | ||
| DESCRIPTION | VARCHAR2 | 240 | Pay Item description | ||
| WORK_APPROVER_ID | NUMBER | 18 | FND User ID of Work Confirmation Owner | ||
| VALUE_BASIS | VARCHAR2 | 25 | Value Basis of the line location | ||
| MATCHING_BASIS | VARCHAR2 | 30 | Matching Basis for the line location | ||
| PREFERRED_GRADE | VARCHAR2 | 150 | Preferred Grade | ||
| TAX_CODE_ID | NUMBER | 18 | Unique identifier for the tax code | ||
| TAX_NAME | VARCHAR2 | 30 | Tax name (or Tax classification code) | ||
| TAXABLE_FLAG | VARCHAR2 | 1 | Indicate whether shipment is taxable | ||
| QTY_RCV_TOLERANCE | NUMBER | Maximum over-receipt tolerance percentage | |||
| 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. | |
| TRX_BUSINESS_CATEGORY | VARCHAR2 | 240 | A classification or categorization of a transaction for tax purposes as required by a tax authority. | ||
| PRODUCT_CATEGORY | VARCHAR2 | 240 | Product Category is used to classify products for tax purposes. | ||
| PRODUCT_FISC_CLASSIFICATION | VARCHAR2 | 240 | A classification of the product(s) by tax authority for tax purposes. It is based on inventory item category. | ||
| PRODUCT_FISC_CLASS_ID | NUMBER | 18 | A classification of the product(s) by tax authority for tax purposes. It is based on inventory item category. | ||
| LINE_INTENDED_USE | VARCHAR2 | 240 | The purpose for which a product is likely to be used in the business by the purchaser. | ||
| LINE_INTENDED_USE_ID | NUMBER | 18 | The purpose for which a product is likely to be used in the business by the purchaser. | ||
| PRODUCT_TYPE | VARCHAR2 | 240 | The value of Product Type specifies whether the teansaction line is for a good, or a service, or it is a memo line. | ||
| USER_DEFINED_FISC_CLASS | VARCHAR2 | 30 | An additional classification of the transaction for tax purposes. | ||
| ASSESSABLE_VALUE | NUMBER | Assessable value of the product. | |||
| INPUT_TAX_CLASSIFICATION_CODE | VARCHAR2 | 30 | This attribute is introduced for backward compatibility only, used to replace the existing Tax Codes and Tax Groups. | ||
| DESTINATION_TYPE_CODE | VARCHAR2 | 25 | Final destination of the purchased items | ||
| CARRIER_ID | NUMBER | 18 | Id of the commercial company used to send item shipments from one address to another. | ||
| FREIGHT_CARRIER | VARCHAR2 | 360 | Name of the commercial company used to send item shipments from one address to another. | ||
| MODE_OF_TRANSPORT | VARCHAR2 | 80 | Type of transportation used to ship the product, such as truck, air or boat. This column stores the displayed value. | ||
| MODE_OF_TRANSPORT_CODE | VARCHAR2 | 30 | Type of transportation used to ship the product, such as truck, air or boat. It is mapped to the column MODE_OF_TRANSPORT on other PO_LINE_LOCATIONS_% table | ||
| SERVICE_LEVEL | VARCHAR2 | 80 | Priority of transportation that affects how quickly goods are transported. This column stores the displayed value. | ||
| SERVICE_LEVEL_CODE | VARCHAR2 | 30 | Priority of transportation that affects how quickly goods are transported. It is mapped to the column SERVICE_LEVEL on other PO_LINE_LOCATIONS_% table | ||
| 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 requested by the end customer. | ||
| 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 | ||
| FINAL_DISCHARGE_LOCATION_ID | NUMBER | 18 | The final discharge location identifier. | ||
| FINAL_DISCHARGE_LOCATION_CODE | VARCHAR2 | 60 | The final discharge location code. | ||
| WORK_ORDER_ID | NUMBER | 18 | Unique identifier for the contract manufacturing work order. | ||
| WORK_ORDER_NUMBER | VARCHAR2 | 120 | Indicates the contract manufacturing work order number. | ||
| REQUESTED_SHIP_DATE | DATE | A date that the buying company requests the ordered item ready to ship. | |||
| PROMISED_SHIP_DATE | DATE | A date that the supplier has promised to ship the item ordered by the buying company. | |||
| REQUESTED_DELIVERY_DATE | DATE | A date that the buying company requests the ordered item or service to be delivered. | |||
| PROMISED_DELIVERY_DATE | DATE | A date that the supplier has promised to deliver the ordered item or service. | |||
| TAX_EXCLUSIVE_PRICE | NUMBER | The purchase order schedule price that is exclusive of all the taxes. | |||
| RETAINAGE_RATE | NUMBER | Maximum percentage that can be withheld from an invoice as Retainage | |||
| 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 ordered on shipment in shipping unit of measure | |||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| po_distributions_interface | po_line_locations_interface | INTERFACE_LINE_LOCATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PO_LINE_LOCATIONS_INTERFACE_N1 | Non Unique | Default | INTERFACE_HEADER_ID |
| PO_LINE_LOCATIONS_INTERFACE_N2 | Non Unique | Default | INTERFACE_LINE_ID |
| PO_LINE_LOCATIONS_INTERFACE_N3 | Non Unique | Default | PROCESSING_ID |
| PO_LINE_LOCATIONS_INTERFACE_N4 | Non Unique | Default | LINE_LOCATION_ID |
| PO_LINE_LOCATIONS_INTERFACE_U1 | Unique | Default | INTERFACE_LINE_LOCATION_ID |
| PO_LINE_LOCATIONS_INTRF_N5 | Non Unique | Default | LOAD_REQUEST_ID, INTERFACE_LINE_KEY |
| PO_LINE_LOCATIONS_INTRF_N6 | Non Unique | Default | CARRIER_ID |