PO_LINE_LOCATIONS_ARCHIVE_ALL
PO_LINE_LOCATIONS_ARCHIVE_ALL contains archived purchase order shipment information. Oracle Purchasing only archives shipments for the following documents: Standard purchase orders, Planned purchase orders, Planned purchase order releases and Blanket purchase order releases. When you modify a shipment, Oracle Purchasing will archive it after you (re)approve the purchase order or after you print it (this depends on the purchasing system options). You can retrieve revisions of the shipments using this table. The latest archived revision will have LATEST_EXTERNAL_FLAG set to 'Y'. You need one row for each shipment archive. Each row contains the same information as the PO_LINE_LOCATIONS_ALL table. Oracle Purchasing uses this information to ensure you keep copies of your legal documents.
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
PO_LINE_LOCATIONS_ARCHIVE_PK |
LINE_LOCATION_ID, FROM_CO_SEQ |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
LINE_LOCATION_ID | NUMBER | 18 | Yes | Document shipment schedule unique identifier | |
WORK_ORDER_OPERATION_ID | NUMBER | 18 | The unique indentifier of a work order operation sequence. | ||
WORK_ORDER_SUB_TYPE | VARCHAR2 | 30 | The display name used to identify the subtype of the manufacturing work order. | ||
ENTITY_CHANGE_TYPE_CODE | VARCHAR2 | 1 | Indicates if the row is new or changed. | ||
WORK_ORDER_OPERATION_SEQ | NUMBER | Indicates execution sequence of the work order operation. | |||
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 | status to indicate whether funds have been reserved on the schedule 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. | ||
PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for project-related standardized cost collection. | ||
CO_QUANTITY_CANCELLED | NUMBER | CO_QUANTITY_CANCELLED | |||
CO_AMOUNT_CANCELLED | NUMBER | CO_AMOUNT_CANCELLED | |||
DESTINATION_TYPE_CODE | VARCHAR2 | 25 | Final destination of the purchased items | ||
EXTERNAL_CHANGE_FLAG | VARCHAR2 | 1 | indicates if the change is external (supplier facing ) or not | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
FROM_CO_SEQ | NUMBER | 18 | Yes | The starting point of the co sequence range within which the record is valid (Inclusive) | |
TO_CO_SEQ | NUMBER | 18 | The ending point of the co sequence range within which the record is valid (Exclusive) | ||
ENTITY_CO_DISPOSITION | VARCHAR2 | 25 | "Approval Status of the archive record. It reflects the action taken against this record during archival. Possible values are:? APPROVED? REJECTED? CANCELED " | ||
REASON_FOR_CHANGE | VARCHAR2 | 240 | Reason for change | ||
REJECTED_BY | NUMBER | 18 | User that rejects the entity record | ||
REJECTED_BY_ROLE | VARCHAR2 | 25 | Role of the user rejecting the entity record | ||
REJECTED_REASON | VARCHAR2 | 240 | Rejected Reason | ||
PRC_BU_ID | NUMBER | 18 | Yes | procurement bu id | |
REQ_BU_ID | NUMBER | 18 | requisition bu id | ||
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 | |
PO_LINE_ID | NUMBER | 18 | Yes | Document line unique identifier | |
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 | |||
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 | ||
CARRIER_ID | NUMBER | 18 | Type of carrier for the RFQ or quotation shipment | ||
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 price break for blanket purchase orders, RFQs and quotations | |||
ENCUMBERED_FLAG | VARCHAR2 | 1 | Indicates whether the shipment is encumbered | ||
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 | ||
FREIGHT_TERMS_LOOKUP_CODE | VARCHAR2 | 25 | Type of freight terms for the shipment | ||
TAXABLE_FLAG | VARCHAR2 | 1 | Indicates whether the shipment is taxable | ||
TAX_NAME | VARCHAR2 | 30 | Tax code for the shipment | ||
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 | ||
FROM_LINE_ID | NUMBER | 18 | Unique identifier of the RFQ line used to autocreate the quotation line | ||
FROM_LINE_LOCATION_ID | NUMBER | 18 | Unique identifier of the RFQ shipment used to autocreate a quotation shipment | ||
START_DATE | DATE | Effective date of the price break (applies to RFQs and quotations only) | |||
END_DATE | DATE | Expiration date of the price break information (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 | ||
CANCEL_FLAG | VARCHAR2 | 1 | Indicates whether the shipment is cancelled | ||
CANCELLED_BY | NUMBER | 18 | Unique identifier of the employee who cancelled the shipment | ||
CANCEL_DATE | DATE | Cancellation date | |||
CANCEL_REASON | VARCHAR2 | 240 | Cancellation reason provided by the employee | ||
FIRM_STATUS_LOOKUP_CODE | VARCHAR2 | 25 | Indicates whether the shipment is firmed | ||
FIRM_DATE | DATE | Date the shipment becomes firmed | |||
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. | ||
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. | ||
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. | |||
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 | ||
SHIP_TO_ORGANIZATION_ID | NUMBER | 18 | Ship-to organization unique identifier | ||
SHIPMENT_NUM | NUMBER | Shipment line number | |||
SOURCE_SHIPMENT_ID | NUMBER | 18 | Unique identifier of the planned purchase order shipment that was referenced when creating this scheduled release shipment | ||
SHIPMENT_TYPE | VARCHAR2 | 25 | Yes | Type of shipment | |
GOVERNMENT_CONTEXT | VARCHAR2 | 30 | USSGL descriptive flexfield context column | ||
RECEIVING_ROUTING_ID | NUMBER | 18 | Receipt routing unique identifier | ||
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 | Identifies the concurrent program | ||
PROGRAM_APP_NAME | VARCHAR2 | 50 | Concurrent Program application name | ||
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 | |||
ACCRUE_ON_RECEIPT_FLAG | VARCHAR2 | 1 | Indicates whether items are accrued upon receipt | ||
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. | |||
TAX_USER_OVERRIDE_FLAG | VARCHAR2 | 1 | Indicator of whether someone 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 | ||
CHANGE_PROMISED_DATE_REASON | VARCHAR2 | 240 | Obsolete - Reason for changing the promised-by date | ||
SECONDARY_QUANTITY | NUMBER | Ordered quantity in secondary unit of measure | |||
SECONDARY_UOM_CODE | VARCHAR2 | 3 | Secondary unit of measure for the quantity ordered | ||
PREFERRED_GRADE | VARCHAR2 | 150 | Preferred quality grade of the item ordered | ||
CONSIGNED_FLAG | VARCHAR2 | 1 | Consigned Flag | ||
SUPPLIER_ORDER_LINE_NUMBER | VARCHAR2 | 25 | Used to store the supplier change order number | ||
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Country of manufacture for this shipment | ||
CALCULATE_TAX_FLAG | VARCHAR2 | 1 | Indicator of whether tax needs to be calculated | ||
NOTE_TO_RECEIVER | VARCHAR2 | 1000 | Shipment level Note to receiver, which would hold the note to receiver info coming from req lines. | ||
AMOUNT | NUMBER | Amount for service lines | |||
VMI_FLAG | VARCHAR2 | 1 | Indicates VMI shipment line with value = 'Y' | ||
RETROACTIVE_DATE | DATE | Column used to store the date of a retroactive price change | |||
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 | ||
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. | ||
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 | ||
BID_PAYMENT_ID | NUMBER | 18 | References the Bid Pay Item if it was negotiated in Sourcing | ||
OUTSOURCED_ASSEMBLY | NUMBER | Yes | This column identifies whether the item is a shikyu item or not | ||
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 | 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
SOLDTO_BU_ID | NUMBER | 18 | Sold-to Business Unit Id | ||
UNIT_OF_MEASURE_CLASS | VARCHAR2 | 25 | Unit of measure class | ||
ORIGINAL_SHIPMENT_ID | NUMBER | 18 | Holds the line_location_id of the shipment from which this shipment was copied/split over | ||
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 to determine the budget date for cancellation | ||
REINSTATE_BUDGET_DATE_OPTION | VARCHAR2 | 30 | option to determine budget date for re instating backing req | ||
REINSTATE_BUDGET_DATE | DATE | budget date for reinstate req | |||
CANCEL_BUDGET_DATE | DATE | budget date for cancellation | |||
FINAL_DISCHARGE_LOCATION_ID | NUMBER | 18 | The final discharge location identifier. | ||
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. | ||
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 in shipping unit of measure | |||
CO_SHIPPING_QUANTITY_CANCELLED | NUMBER | Changed quantity in shipping unit of measure canceled up until today | |||
FIRMED_BY | NUMBER | 18 | Unique identifier of the employee who firmed the shipment. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
PO_LINE_LOCATIONS_ARCHIVE_ALL | po_headers_all | PO_HEADER_ID |
PO_LINE_LOCATIONS_ARCHIVE_ALL | po_headers_all | FROM_HEADER_ID |
PO_LINE_LOCATIONS_ARCHIVE_ALL | po_line_locations_all | FROM_LINE_LOCATION_ID |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
PO_LINE_LOCATIONS_ARCHIVE_N2 | Non Unique | Default | PO_HEADER_ID, PO_LINE_ID | |
PO_LINE_LOCATIONS_ARCHIVE_N4 | Non Unique | Default | CANCELLED_BY | |
PO_LINE_LOCATIONS_ARCHIVE_N5 | Non Unique | Default | PO_LINE_ID, SHIPMENT_NUM | Obsolete |
PO_LINE_LOCATIONS_ARCHIVE_U1 | Unique | Default | LINE_LOCATION_ID, FROM_CO_SEQ | |
PO_LINE_LOC_ARCHIVE_ALL_N6 | Non Unique | Default | CARRIER_ID | |
PO_LINE_LOC_ARCHIVE_ALL_N7 | Non Unique | Default | SHIP_TO_CUST_ID | |
PO_LINE_LOC_ARCHIVE_ALL_N8 | Non Unique | Default | SHIP_TO_CUST_CONTACT_ID | |
PO_LINE_LOC_ARCHIVE_ALL_U1 | Unique | Default | PO_LINE_ID, SHIPMENT_NUM, FROM_CO_SEQ |