PO_LINE_LOCATIONS_ALL
PO_LINE_LOCATIONS_ALL contains information about purchase order shipment schedules and blanket agreement price breaks. You need one row for each schedule or price break you attach to a document line. There are seven types of documents that use shipment schedules: RFQs, Quotations, Standard purchase orders, Planned purchase orders, Planned purchase order releases, Blanket purchase orders and Blanket purchase order releases. Each row includes the location, quantity, and dates for each shipment schedule. Oracle Purchasing uses this information to record delivery schedule information for purchase orders, and price break information for blanket purchase orders, quotations and RFQs. PO_RELEASE_ID applies only to blanket purchase order release shipments. PO_RELEASE_ID identifies the release on which you placed this shipment. SOURCE_SHIPMENT_ID applies only to planned purchase order release shipments. It identifies the planned purchase order shipment you chose to release from. PRICE_OVERRIDE always equals the purchase order line price for standard purchase order shipments. For blanket and planned purchase orders, PRICE_OVERRIDE depends on the values of the ALLOW_PRICE_OVERRIDE_FLAG and NOT_TO_EXCEED_PRICE in the corresponding row in PO_LINES_ALL: If ALLOW_PRICE_OVERRIDE_FLAG is 'N', then PRICE_OVERRIDE equals UNIT_PRICE in PO_LINES_ALL. If ALLOW_PRICE_OVERRIDE_FLAG is 'Y', the PRICE_OVERRIDE can take any value that is smaller than NOT_TO_EXCEED_PRICE in PO_LINES_ALL. The QUANTITY field corresponds to the total quantity ordered on all purchase order distribution lines (found in PO_DISTRIBUTIONS_ALL). Oracle Purchasing automatically updates QUANTITY_RECEIVED, QUANTITY_ACCEPTED, and QUANTITY_REJECTED when you receive, return, or inspect goods or services. Oracle Payables automatically updates QUANTITY_BILLED when you match an invoice with a purchase order shipment. Oracle Purchasing automatically updates QUANTITY_CANCELLED when you cancel a purchase order shipment. Oracle Purchasing sets APPROVED_FLAG to 'Y' when you approve the corresponding purchase order if there are no problems associated with the shipment and its related distributions. Oracle Purchasing sets ENCUMBERED_FLAG to 'Y' and enters the ENCUMBERED_DATE when you approve a purchase order if you use encumbrance.
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PO_LINE_LOCATIONS_ALL_PK |
LINE_LOCATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| LINE_LOCATION_ID | NUMBER | 18 | Yes | Document shipment schedule unique identifier | ||
| 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. | |||
| 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. | |||
| FIRM_FLAG | VARCHAR2 | 1 | Indicates whether the shipment is firmed or not. | |||
| ORCHESTRATION_CODE | VARCHAR2 | 20 | A code that indicates of the integrating application is orchestrating changes between their application and Fusion Procurement. | |||
| MODE_OF_TRANSPORT | VARCHAR2 | 30 | Type of transportation used to ship the product, such as truck, air or boat. | |||
| SERVICE_LEVEL | VARCHAR2 | 30 | Priority of transportation that affects how quickly goods are transported | |||
| 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. | ||||
| FUNDS_STATUS | VARCHAR2 | 25 | Indicates whether the schedule amount is reserved or not | |||
| 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. | |||
| DESTINATION_TYPE_CODE | VARCHAR2 | 25 | Final destination of the purchased items | |||
| AUTO_CLOSURE_MODE | VARCHAR2 | 25 | Auto-closure mode | |||
| SCHEDULE_STATUS | VARCHAR2 | 25 | Shipment status(applicable only to SPO) | |||
| UNIT_OF_MEASURE_CLASS | VARCHAR2 | 25 | Unit of Measure Class | |||
| TRX_BUSINESS_CATEGORY | VARCHAR2 | 240 | The Transaction Business Category is a classification or categorization of a transaction for tax purposes as required by a tax authority | |||
| PRODUCT_CATEGORY | VARCHAR2 | 240 | The Product Category is used to classify products for tax purposes | |||
| PRODUCT_FISC_CLASSIFICATION | VARCHAR2 | 240 | The Product Fiscal Classification is a classification of the product(s) by tax authority for tax purposes. It is based on the inventory item category | |||
| LINE_INTENDED_USE | VARCHAR2 | 240 | Intended Use is the purpose for which a product is likely to be used in the business by the purchaser | |||
| PRC_BU_ID | NUMBER | 18 | Yes | PRC_BU_ID | ||
| REQ_BU_ID | NUMBER | 18 | REQ_BU_ID | |||
| PRODUCT_TYPE | VARCHAR2 | 240 | The value of product type specifies whether the transaction line is for a good, or a service, or it is a memo line. | |||
| USER_DEFINED_FISC_CLASS | VARCHAR2 | 30 | The User Defined Fiscal Classification is an additional classification of the transaction for tax purposes | |||
| ASSESSABLE_VALUE | NUMBER | Assessable value of the product | ||||
| INPUT_TAX_CLASSIFICATION_CODE | VARCHAR2 | 30 | 'Tax Classification' is a new attribute, which is introduced to replace the existing Tax Codes and Tax Groups in the application products. Tax classification is provided only for backward compatibility only | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| PO_HEADER_ID | NUMBER | 18 | Yes | Document header unique identifier. (References PO_HEADERS_ALL.po_header_id.). For Release shipments, this references the Unique identifier of Blanket PO | ||
| PO_LINE_ID | NUMBER | 18 | Yes | Document line unique identifier (References PO_LINES_ALL.po_line_id). For Release Shipments, this references the unique line identifier of Blanket PO | ||
| 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. | ||
| QUANTITY | NUMBER | Quantity ordered or break quantity for blanket purchase orders, RFQs and quotations | ||||
| QUANTITY_RECEIVED | NUMBER | Quantity received until today | ||||
| QUANTITY_ACCEPTED | NUMBER | Quantity accepted after inspection, up until today | ||||
| QUANTITY_REJECTED | NUMBER | Quantity rejected after inspection, up until today | ||||
| QUANTITY_BILLED | NUMBER | Quantity invoiced by Oracle Payables, up until today | ||||
| QUANTITY_CANCELLED | NUMBER | Quantity cancelled | ||||
| UOM_CODE | VARCHAR2 | 3 | Unit of measure for the quantity ordered. (References INV_UNITS_OF_MEASURE.uom_code.) | |||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | Unique identifier for the ship-to location (References HR_LOCATIONS_ALL.location_id) | |||
| CARRIER_ID | NUMBER | 18 | Type of carrier for the RFQ or quotation shipment (References INV_ORG_FREIGHT_TL.freight_code) | |||
| NEED_BY_DATE | DATE | Requested Delivery Date. A date that the buying company requests the ordered item or service to be delivered. | ||||
| PROMISED_DATE | DATE | Promised Delivery Date. A date that the supplier has promised to deliver the ordered item or service. | ||||
| LAST_ACCEPT_DATE | DATE | Latest acceptable receipt date for the shipment | ||||
| PRICE_OVERRIDE | NUMBER | Order shipment price or break price for blanket purchase orders, RFQs, and quotations | ||||
| ENCUMBERED_FLAG | VARCHAR2 | 1 | Indicates whether the shipment is encumbered or not | |||
| ENCUMBERED_DATE | DATE | Date of encumbrance for the shipment | ||||
| UNENCUMBERED_QUANTITY | NUMBER | Encumbered quantity to date (Unused since release version 7.0) | ||||
| FOB_LOOKUP_CODE | VARCHAR2 | 25 | Type of free-on-board terms for the shipment (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='FOB') | |||
| FREIGHT_TERMS_LOOKUP_CODE | VARCHAR2 | 25 | Type of freight terms for the RFQ or quotation shipment (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='FREIGHT TERMS') | |||
| TAXABLE_FLAG | VARCHAR2 | 1 | Indicates whether the shipment is taxable | |||
| TAX_NAME | VARCHAR2 | 30 | Tax code for the shipment (References AP_TAX_CODES_ALL.name) | |||
| ESTIMATED_TAX_AMOUNT | NUMBER | Estimated tax amount for the purchase order shipment (Unused since release version 6.0) | ||||
| FROM_HEADER_ID | NUMBER | 18 | Unique identifier of the RFQ used to autocreate the quotation. For Standard Purchase Orders referencing Global Agreements, this field captures the unique Identifier of Global Agreements(References: PO_HEADERS_ALL.PO_HEADER_ID) | |||
| FROM_LINE_ID | NUMBER | 18 | Unique identifier of the RFQ line used to autocreate the quotation line. For Standard PO Lines that reference Global Agreement lines, this field captures the unique identifier of Global Agreement line (References PO_LINES_ALL.po_line_id) | |||
| FROM_LINE_LOCATION_ID | NUMBER | 18 | Unique identifier of the RFQ shipment used to autocreate a quotation shipment. For Standard POs that reference Global Agreements, this field captures the Global Agreement Price Break Unique Identifier (references PO_LINE_LOCATIONS_ALL.line_location_id) | |||
| 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) | ||||
| 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) | ||||
| TERMS_ID | NUMBER | 18 | Payment terms unique identifier(References AP_TERMS.term_id) | |||
| CANCEL_FLAG | VARCHAR2 | 1 | Indicates whether the shipment is cancelled or not | |||
| CANCELLED_BY | NUMBER | 18 | Unique identifier of the employee who cancelled the shipment (References to HR_EMPLOYEES.employee_id) | |||
| CANCEL_DATE | DATE | Cancellation date | ||||
| CANCEL_REASON | VARCHAR2 | 240 | Cancellation reason provided by the employee | |||
| FIRM_STATUS_LOOKUP_CODE | VARCHAR2 | 25 | Indicates whether you want to prevent this Shipment from being automatically rescheduled by your manufacturing application. | |||
| FIRM_DATE | DATE | Date the shipment is firmed | ||||
| FIRMED_BY | NUMBER | 18 | Unique identifier of the employee who firmed the shipment (References to HR_EMPLOYEES.employee_id) | |||
| FIRM_REASON | VARCHAR2 | 240 | Why the shipment is firmed | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ENCUMBER_NOW | VARCHAR2 | 1 | Indicates whether the shipment should be encumbered (Unused since release version 7.0) | |||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Schedules (PO_LINE_LOCATIONS) | |||
| 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 | |||
| QTY_RCV_TOLERANCE | NUMBER | Maximum over-receipt tolerance percentage | ||||
| QTY_RCV_EXCEPTION_CODE | VARCHAR2 | 25 | Describes what action is taken when the quantity received tolerance is exceeded | |||
| 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 | |||
| 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 | Describes what action is 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 | ||||
| SHIP_TO_ORGANIZATION_ID | NUMBER | 18 | Ship-to organization unique identifier(References HR_ORGANIZATION_UNITS.organization_id) | |||
| SHIPMENT_NUM | NUMBER | Yes | Shipment line number | |||
| SOURCE_SHIPMENT_ID | NUMBER | 18 | Unique identifier of the planned purchase order shipment(also stored in PO_LINE_LOCATIONS_ALL) that was referenced when creating this scheduled release shipment | |||
| SHIPMENT_TYPE | VARCHAR2 | 25 | Yes | Type of the shipment | ||
| 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 | |||
| GOVERNMENT_CONTEXT | VARCHAR2 | 30 | USSGL descriptive flexfield context column | |||
| RECEIVING_ROUTING_ID | NUMBER | 18 | Receipt routing unique identifier(References RCV_ROUTING_HEADERS.routing_header_id) | |||
| ACCRUE_ON_RECEIPT_FLAG | VARCHAR2 | 1 | Indicates whether items are accrued upon receipt | |||
| CLOSED_REASON | VARCHAR2 | 240 | Why the shipment is closed | |||
| CLOSED_DATE | DATE | Date the shipment is closed | ||||
| CLOSED_BY | NUMBER | 18 | Unique identifier of employee who closed the shipment(References HR_EMPLOYEES.employee_id.) | |||
| SOLDTO_BU_ID | NUMBER | 18 | Sold to Business Unit Unique Identifier | |||
| QUANTITY_SHIPPED | NUMBER | Quantity shipped | ||||
| 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. | ||||
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Country of manufacture for this shipment | |||
| TAX_USER_OVERRIDE_FLAG | VARCHAR2 | 1 | Indicator of whether somone overrode the default tax | |||
| MATCH_OPTION | VARCHAR2 | 25 | Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt | |||
| TAX_CODE_ID | NUMBER | 18 | Unique identifier for the tax code(References AP_TAX_CODES_ALL.tax_id) | |||
| CALCULATE_TAX_FLAG | VARCHAR2 | 1 | Indicator of whether tax needs to be calculated | |||
| CHANGE_PROMISED_DATE_REASON | VARCHAR2 | 240 | Obsolete - Reason for changing the promised-by date | |||
| NOTE_TO_RECEIVER | VARCHAR2 | 1000 | Shipment level Note to receiver, which would hold the note to receiver info coming from req lines. | |||
| SECONDARY_QUANTITY | NUMBER | Ordered quantity in secondary unit of measure | ||||
| PREFERRED_GRADE | VARCHAR2 | 150 | Preferred quality grade for the ordered item | |||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | Secondary unit of measure for the quantity ordered | |||
| SECONDARY_QUANTITY_RECEIVED | NUMBER | Quantity in secondary unit of measure received until today | ||||
| SECONDARY_QUANTITY_ACCEPTED | NUMBER | Quantity accepted in secondary unit of measure after inspection, up until today | ||||
| SECONDARY_QUANTITY_REJECTED | NUMBER | Quantity rejected in secondary unit of measure after inspection, up until today | ||||
| SECONDARY_QUANTITY_CANCELLED | NUMBER | Quantity cancelled in secondary unit of measure after inspection, up until today | ||||
| VMI_FLAG | VARCHAR2 | 1 | Indicates VMI shipment line with value = 'Y' | |||
| CONSIGNED_FLAG | VARCHAR2 | 1 | Indicates shipment is consigned | |||
| RETROACTIVE_DATE | DATE | Column used to store the date of a retroactive price change | ||||
| SUPPLIER_ORDER_LINE_NUMBER | VARCHAR2 | 25 | Used to store a supplier change request | |||
| AMOUNT | NUMBER | Stores the amount on the shipments for service lines | ||||
| AMOUNT_RECEIVED | NUMBER | Stores the amount received for service lines | ||||
| AMOUNT_BILLED | NUMBER | Stores the amount billed for service lines | ||||
| AMOUNT_CANCELLED | NUMBER | Amount cancelled for service lines | ||||
| AMOUNT_REJECTED | NUMBER | Amount rejected for service lines | ||||
| AMOUNT_ACCEPTED | NUMBER | Amount Accepted for service lines | ||||
| DROP_SHIP_FLAG | VARCHAR2 | 1 | Indicates whether the Shipment has a backing Sales Order Line. | |||
| SALES_ORDER_UPDATE_DATE | DATE | The date/time when any of referenced data elements on the backing Sales Order Line is updated. | ||||
| TRANSACTION_FLOW_HEADER_ID | NUMBER | 18 | Transaction flow header identifier. | |||
| SECONDARY_QUANTITY_SHIPPED | NUMBER | Quantity in secondary unit of measure shipped up until today | ||||
| FINAL_MATCH_FLAG | VARCHAR2 | 1 | This flag indicates if the shipment is finally matched by AP invoice. This field is not upgraded. Hence may not reflect accurately for old data. This field is only used by AP as of 11.5.10 | |||
| MANUAL_PRICE_CHANGE_FLAG | VARCHAR2 | 1 | Only for Blanket Release shipments: Y if the user has manually entered a price overriding the Blanket Agreement price, N or null otherwise. | |||
| SHIPMENT_CLOSED_DATE | DATE | Date when the Shipment is closed for both Receiving and Invoice | ||||
| CLOSED_FOR_RECEIVING_DATE | DATE | Date when the Shipment is closed for receiving | ||||
| CLOSED_FOR_INVOICE_DATE | DATE | Date when the Shipment is closed for Invoice | ||||
| VALUE_BASIS | VARCHAR2 | 25 | Value basis of the line location | |||
| MATCHING_BASIS | VARCHAR2 | 30 | Matching basis of the line location | |||
| PAYMENT_TYPE | VARCHAR2 | 30 | Pay Item type | |||
| GROUP_NAME | VARCHAR2 | 80 | GROUP_NAME | |||
| DESCRIPTION | VARCHAR2 | 240 | Pay Item description | |||
| WORK_APPROVER_ID | NUMBER | 18 | FND User ID of the Pay Item's Work Confirmation Owner | |||
| BID_PAYMENT_ID | NUMBER | 18 | References the Bid Pay Item if it was negotiated in Sourcing | |||
| QUANTITY_FINANCED | NUMBER | For Financing Pay Items, the number of units which have been pre-paid | ||||
| AMOUNT_FINANCED | NUMBER | For Advances or Financing Pay Items, the amount which has been pre-paid | ||||
| QUANTITY_RECOUPED | NUMBER | For Financing Pay Items, the number of units for which prepayments have been liquidated | ||||
| AMOUNT_RECOUPED | NUMBER | For Advances or Financing Pay Items, the amount of the prepayments which has been liquidated | ||||
| RETAINAGE_WITHHELD_AMOUNT | NUMBER | The total amount withheld as Retainage against this Pay Item | ||||
| RETAINAGE_RELEASED_AMOUNT | NUMBER | The amount of Retainage released for this Pay Item | ||||
| AMOUNT_SHIPPED | NUMBER | Amount pending for Work Confirmation | ||||
| OUTSOURCED_ASSEMBLY | NUMBER | Yes | This column identifies whether the item is a shikyu item or not | |||
| TAX_ATTRIBUTE_UPDATE_CODE | VARCHAR2 | 15 | Keeps track of create/update actions on this entity | |||
| ORIGINAL_SHIPMENT_ID | NUMBER | 18 | Holds the line_location_id of the shipment from which this shipment was copied/split over | |||
| 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. | ||
| PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for project-related standardized cost collection. | |||
| ORIG_SCHEDULE_STATUS | VARCHAR2 | 25 | To store the original schedule status when the schedule is put on hold so that it can be reverted when hold is reverted | |||
| PRODUCT_FISC_CLASS_ID | NUMBER | 18 | The Product Fiscal Classification is a classification of the product(s) by tax authority for tax purposes. It is based on the inventory item category. We store the ID for internal use. | |||
| LINE_INTENDED_USE_ID | NUMBER | 18 | Intended Use is the purpose for which a product is likely to be used in the business by the purchaser. We store ID For internal use | |||
| EXTERNAL_SYS_RCV_INTF_STATUS | VARCHAR2 | 25 | To be set by Receiving to indicate if the PO Schedule has been interfaced. | |||
| 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 | |||
| CANCEL_BUDGET_DATE_OPTION | VARCHAR2 | 30 | Option which determines the cancel budget date, if it should be sys date or userspecified | |||
| REINSTATE_BUDGET_DATE_OPTION | VARCHAR2 | 30 | option to determine the budget date used for reinstating the budget date | |||
| CANCEL_BUDGET_DATE | DATE | budget date used for document cancellation | ||||
| REINSTATE_BUDGET_DATE | DATE | budget date used for reinstating backing req during cancellation | ||||
| FINAL_DISCHARGE_LOCATION_ID | NUMBER | 18 | The final discharge location identifier. | |||
| REOPEN_FINAL_CLOSE_DATE | DATE | Date on which the action to reopen a finally closed shedule is taken | ||||
| 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. | |||
| ANTICIPATED_ARRIVAL_DATE | DATE | The date of delivery the ordered goods based on the current projected date of shipping. | ||||
| DELIVERY_DATE_CONFIRMATION_REQ | VARCHAR2 | 1 | Indicates if supplier has confirmed the requested delivery date. | |||
| TAX_EXCLUSIVE_PRICE | NUMBER | The purchase order schedule price that is exclusive of all the taxes. | ||||
| EXTERNAL_SYS_RCV_GROUP_ID | NUMBER | 18 | This column is used by receiving. The generate receipt advice REST API identifies all open schedules that need to be interfaced to an external warehouse management system and mark those schedules by setting this column with a unique identifier. Subsequently, the Receipt Advice Lines REST API will query the marked schedules using this group identifer. | |||
| 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_RECEIVED | NUMBER | Quantity in shipping unit of measure received until today | ||||
| SHIPPING_UOM_QUANTITY_ACCEPTED | NUMBER | Quantity accepted in shipping unit of measure after inspection, up until today | ||||
| SHIPPING_UOM_QUANTITY_REJECTED | NUMBER | Quantity rejected in shipping unit of measure after inspection, up until today | ||||
| SHIPPING_UOM_QUANTITY_SHIPPED | NUMBER | Quantity in shipping unit of measure shipped up until today | ||||
| SHIPPING_UOM_QUANTITY_CANCELED | NUMBER | Quantity in shipping unit of measure canceled up until today | ||||
| SHIPPING_UOM_QUANTITY | NUMBER | Quantity in shipping unit of measure |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PO_LINE_LOCATIONS_ALL | po_headers_all | PO_HEADER_ID |
| PO_LINE_LOCATIONS_ALL | po_headers_all | FROM_HEADER_ID |
| PO_LINE_LOCATIONS_ALL | po_lines_all | FROM_LINE_ID |
| PO_LINE_LOCATIONS_ALL | po_line_locations_all | FROM_LINE_LOCATION_ID |
| PO_LINE_LOCATIONS_ALL | po_line_locations_all | SOURCE_SHIPMENT_ID |
| PO_LINE_LOCATIONS_ALL | po_lines_all | PO_LINE_ID |
| rcv_transactions | po_line_locations_all | PO_LINE_LOCATION_ID |
| po_line_locations_all | po_line_locations_all | FROM_LINE_LOCATION_ID |
| po_line_locations_all | po_line_locations_all | SOURCE_SHIPMENT_ID |
| po_line_locations_draft_all | po_line_locations_all | FROM_LINE_LOCATION_ID |
| inv_supply | po_line_locations_all | PO_LINE_LOCATION_ID |
| cmr_purchase_order_dtls | po_line_locations_all | PO_LINE_LOCATION_ID |
| ap_invoice_lines_all | po_line_locations_all | PO_LINE_ID |
| ap_invoice_lines_all | po_line_locations_all | PO_LINE_LOCATION_ID |
| ap_holds_all | po_line_locations_all | LINE_LOCATION_ID |
| rcv_supply | po_line_locations_all | PO_LINE_LOCATION_ID |
| rcv_transactions_interface | po_line_locations_all | PO_LINE_LOCATION_ID |
| rcv_shipment_lines | po_line_locations_all | PO_LINE_LOCATION_ID |
| po_line_locations_archive_all | po_line_locations_all | FROM_LINE_LOCATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| PO_LINE_LOCATIONS_F1 | Non Unique | Default | TRUNC(NVL("ANTICIPATED_ARRIVAL_DATE",(NVL("PROMISED_DATE","NEED_BY_DATE")))) | |
| PO_LINE_LOCATIONS_N1 | Non Unique | Default | PO_LINE_ID | Obsolete |
| PO_LINE_LOCATIONS_N10 | Non Unique | Default | CLOSED_DATE | |
| PO_LINE_LOCATIONS_N11 | Non Unique | Default | LAST_UPDATE_DATE | |
| PO_LINE_LOCATIONS_N12 | Non Unique | Default | FROM_HEADER_ID | |
| PO_LINE_LOCATIONS_N13 | Non Unique | Default | SCHEDULE_STATUS | |
| PO_LINE_LOCATIONS_N14 | Non Unique | Default | SHIP_TO_ORGANIZATION_ID | |
| PO_LINE_LOCATIONS_N15 | Non Unique | Default | PRC_BU_ID | |
| PO_LINE_LOCATIONS_N16 | Non Unique | Default | ORIGINAL_SHIPMENT_ID | |
| PO_LINE_LOCATIONS_N17 | Non Unique | Default | PO_LINE_ID, SHIPMENT_NUM | |
| PO_LINE_LOCATIONS_N18 | Non Unique | Default | CARRIER_ID | |
| PO_LINE_LOCATIONS_N19 | Non Unique | Default | SHIP_TO_CUST_ID | |
| PO_LINE_LOCATIONS_N2 | Non Unique | Default | PO_HEADER_ID, PO_LINE_ID | |
| PO_LINE_LOCATIONS_N20 | Non Unique | Default | SHIP_TO_CUST_CONTACT_ID | |
| PO_LINE_LOCATIONS_N21 | Non Unique | Default | EXTERNAL_SYS_RCV_GROUP_ID | |
| PO_LINE_LOCATIONS_N22 | Non Unique | Default | PO_HEADER_ID, SCHEDULE_STATUS | |
| PO_LINE_LOCATIONS_N3 | Non Unique | Default | SHIP_TO_LOCATION_ID | |
| PO_LINE_LOCATIONS_N4 | Non Unique | Default | PROMISED_DATE | |
| PO_LINE_LOCATIONS_N6 | Non Unique | Default | CLOSED_BY | |
| PO_LINE_LOCATIONS_N7 | Non Unique | Default | CANCELLED_BY | |
| PO_LINE_LOCATIONS_N9 | Non Unique | Default | FROM_LINE_LOCATION_ID | |
| PO_LINE_LOCATIONS_U1 | Unique | Default | LINE_LOCATION_ID |