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 |