1. Tables and Views for SCM
  2. DOO_ORDER_LINES_ALL_INT

DOO_ORDER_LINES_ALL_INT

This interface table contains order line data. It is used when importing an order.

Details

  • Schema: FUSION

  • Object owner: DOO

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Not-null Comments
SOURCE_TRANSACTION_ID VARCHAR2 50 Unique identifier of the transaction in the system that captured the transaction.
COVERED_PRODUCT_SRCSYS_REF VARCHAR2 255 Reference that represents the covered item in the system that captured the transaction. Order Management uses this attribute for cancelling coverage item without a reference order.
AGREEMENT_NUMBER VARCHAR2 150 Number that uniquely identifies the sales agreement on the order line.
COVERED_PRODUCT_IDENTIFIER NUMBER 18 Value that uniquely identifies the inventory item that the coverage item covers. Order Management uses this attribute to cancel the coverage item without a reference order.
COVERED_CUSTOMER_PRODUCT_NUM VARCHAR2 150 Number that identifies the customer item that the coverage item covers. This value applies only when the sales order or the return order includes the customer. Order Management uses this attribute to cancel the coverage item without a reference order.
COVERED_CUSTOMER_PRODUCT_DESC VARCHAR2 240 Description of the customer item that the coverage item covers. This value applies only when the sales order or the return order includes the customer. Order Management uses this attribute to cancel the coverage item without a reference order.
SERVICE_CANCEL_DATE DATE Date when the cancellation of the service item becomes effective. Order Management uses this attribute to cancel the service item without a reference order.
COVERED_PRODUCT_NUMBER VARCHAR2 300 Stock Keeping Unit (SKU) of the inventory item that the coverage item covers. Order Management uses this attribute to cancel the coverage item without a reference order.
COVERED_PRODUCT_DESCRIPTION VARCHAR2 240 Description of the inventory item that the coverage item covers. Order Management uses this attribute to cancel the coverage item without a reference order.
COVERED_CUSTOMER_PRODUCT_ID NUMBER 18 Value that uniquely identifies the customer item that the coverage item covers. This value applies only when the sales order or the return order includes the customer. Order Management uses this attribute to cancel the coverage item without a reference order.
AGREEMENT_HEADER_ID NUMBER 18 Value that uniquely identifies the sales agreement on the order line.
CREDIT_CHK_AUTH_NUM VARCHAR2 240 The unique identifier for the approved credit authorization created in credit management system on the requested authorized amount for the customer account specified. This is only applicable for credit check of type `Authorization' and `Re-Authorization'.
CREDIT_CHK_AUTH_EXP_DATE TIMESTAMP The date on which the approved credit authorization will expire.
SOURCE_TRANSACTION_SYSTEM VARCHAR2 30 System or application that submitted the order request.
SOURCE_TRANSACTION_LINE_ID VARCHAR2 50 Unique identifier of the transaction line from the system that captured the transaction.
SOURCE_TRANSACTION_SCHEDULE_ID VARCHAR2 50 Unique identifier of a schedule, shipment, or subline, as assigned by the system that captured the transaction.
SOURCE_TRANSACTION_SCHEDULE_NO VARCHAR2 50 Number of a schedule, shipment, or subline, as assigned by the system that captured the transaction.
SOURCE_TRANSACTION_LINE_NO VARCHAR2 50 Number of the transaction line from the system that captured the transaction.
PRODUCT_ID NUMBER 18 Unique identifier of the inventory item.
PRODUCT_NUMBER VARCHAR2 300 SKU of product that is being fulfilled.
PRODUCT_DESCRIPTION VARCHAR2 240 Display Name of the product that is being fulfilled.
ORDERED_QUANTITY NUMBER Quantity of an ordered good or service.
ORDERED_UOM_CODE VARCHAR2 3 Unit of measure for the quantity ordered. A predetermined amount, quantity, or quality that is adopted as a standard of measurement. Examples: length, time, heat, value.
ORDERED_UOM VARCHAR2 25 Name of the unit of measure for the quantity ordered. A predetermined amount, quantity, or quality that is adopted as a standard of measurement. Examples: length, time, heat, value.
REQUESTED_FULFILLMENT_ORG_ID NUMBER 18 Unique identifier of the fulfillment organization.
REQUESTED_FULFILLMENT_ORG_CODE VARCHAR2 18 Code that represents the organization from which the product was shipped.
REQUESTED_FULFILLMENT_ORG_NAME VARCHAR2 240 Name that represents the organization from which the product was shipped.
BUSINESS_UNIT_ID NUMBER 18 Unique identifier of the business unit that is associated with the row.
BUSINESS_UNIT_NAME VARCHAR2 240 Internal organization that is fulfilling the order.
REQUESTING_BUSINESS_UNIT_ID NUMBER 18 Unique identifier of the organization that is associated with the source order.
REQUESTING_BUSINESS_UNIT_NAME VARCHAR2 240 Internal organization that initiated this transaction.
CANCEL_REASON_CODE VARCHAR2 1000 Code that represents the reason the line was canceled.
CANCEL_REASON VARCHAR2 1000 Reason the line was canceled.
SUBSTITUTION_ALLOWED_FLAG VARCHAR2 1 Indicates that items on the fulfillment line can be substituted for various reasons like shortage of material, or as a goodwill gesture to the customer.
SUBSTITUTION_REASON_CODE VARCHAR2 30 Code that describes why an item was substituted on a fulfillment line.
SUBSTITUTION_REASON VARCHAR2 240 Reason why an item was substituted on a fulfillment line.
CUSTOMER_PO_NUMBER VARCHAR2 50 Commercial document that is used to request that a seller supply a product or service in return for payment.
CUSTOMER_PO_LINE_NUMBER VARCHAR2 50 Unique identifier of the line record of a transaction. The purchase order line describes an item or service, with a price and quantity ordered.
CUSTOMER_PO_SCHEDULE_NUMBER VARCHAR2 50 Contains the customer's purchase order shipment schedule number, if specified, while submitting an order.
CUSTOMER_PRODUCT_ID NUMBER 18 Unique identifier of the customer item.
CUSTOMER_PRODUCT_NUMBER VARCHAR2 150 Product number on the customer item table, if a customer item number was used for ordering.
CUSTOMER_PRODUCT_DESCRIPTION VARCHAR2 240 Product description on the customer item table, if a customer item description was used for ordering.
TRANSACTION_LINE_TYPE_CODE VARCHAR2 30 Defines the system behavior for the order line transaction, in terms of values required, defaulted, and displayed.
TRANSACTION_LINE_TYPE VARCHAR2 240 Type of line or action in the channel system. Some example values are Buy, Replace With, Return For Credit, and Upgrade.
PARENT_LINE_REFERENCE VARCHAR2 50 Alphanumeric reference of the line that is the immediate parent of this line in a configurable product hierarchy or in any other situation with parent-child relationships.
ROOT_PARENT_LINE_REFERENCE VARCHAR2 50 Alphanumeric reference of the line at the root of the configurable product hierarchy that the line is a component of.
SHIPPING_INSTRUCTIONS VARCHAR2 1000 Message on a document that provides details about cargo and any requirements for its physical movement.
PACKING_INSTRUCTIONS VARCHAR2 1000 Document that contains information concerning the packing of an item.
INVOICING_RULE_CODE VARCHAR2 1000 Code that represents invoicing rules that determine when to recognize a receivable for invoices.
INVOICING_RULE VARCHAR2 30 Invoicing rule that determine when to recognize a receivable for invoices.
ACCOUNTING_RULE_CODE VARCHAR2 1000 Code that represents an accounting rule that determines the accounting period or periods in which the revenue distributions for an invoice line are recorded.
ACCOUNTING_RULE VARCHAR2 30 Accounting rule that determines the accounting period or periods in which the revenue distributions for an invoice line are recorded.
REQUESTED_SHIP_DATE DATE Original date the customer requested the item to ship.
REQUESTED_ARRIVAL_DATE DATE Original date the customer requested the to item arrive.
SCHEDULE_SHIP_DATE DATE Date when goods are expected to be shipped.
SCHEDULE_ARRIVAL_DATE DATE Date the shipment is scheduled to arrive.
DEMAND_CLASS_CODE VARCHAR2 1000 Demand class used by the order promising engine to consume target allocation amounts.
DEMAND_CLASS VARCHAR2 1000 Grouping of customers. Demand classes can represent different sources of demand, such as retail, mail order, and wholesale.
SHIPPING_CARRIER_CODE VARCHAR2 1000 Code that represents the shipping carrier that delivered the goods.
SHIPPING_CARRIER VARCHAR2 1000 Shipping carrier that delivered the goods.
PAYMENT_TERM_CODE VARCHAR2 1000 Code that represents payment terms to apply to collect this payment.
PAYMENT_TERM VARCHAR2 1000 Payment terms to apply to collect this payment.
TRANSACTION_CATEGORY_CODE VARCHAR2 30 Code used to group and process journal entries with similar characteristics, such as adjustments, accruals, or reclassifications.
RETURN_REASON_CODE VARCHAR2 1000 Code that represents the justification for a return of a specific product. Many companies have standard reasons that are assigned to returns to be used to analyze the quantity and types of returns.
RETURN_REASON VARCHAR2 1000 Reason expressed by customer for wanting to return the product.
SHIPPING_SERVICE_LEVEL_CODE VARCHAR2 1000 Code that represents the priority of transportation that affects how quickly goods are transported.
SHIPPING_SERVICE_LEVEL VARCHAR2 1000 Level of service to be used for delivery of the shipment.
SHIPPING_MODE_CODE VARCHAR2 1000 Code that represents the type of transportation used to ship the product, such as truck, air, or boat.
SHIPPING_MODE VARCHAR2 1000 Shipping mode that was actually used to deliver the goods.
SHIPMENT_PRIORITY_CODE VARCHAR2 1000 Code that represents the priority of the fulfillment lines to be shipped.
SHIPMENT_PRIORITY VARCHAR2 1000 Priority categorization that can be used to group shipments by urgency.
INVENTORY_ORGANIZATION_ID NUMBER 18 Unique identifier of the inventory organization.
INVENTORY_ORGANIZATION_CODE VARCHAR2 18 Code of the inventory organization that the product belongs to.
INVENTORY_ORGANIZATION_NAME VARCHAR2 240 Name of the inventory organization that the product belongs to.
FREIGHT_TERMS_CODE VARCHAR2 1000 Code that represents the terms specifying the responsibility for freight charges.
FREIGHT_TERMS VARCHAR2 1000 Terms specifying the responsibility for freight charges, such as paid by shipper, collect, or prepaid.
REQUEST_CANCEL_DATE TIMESTAMP Date that the customer canceled the line.
ORIGINAL_PRODUCT_ID NUMBER 18 Unique identifier of the original inventory item that was populated on the fulfillment line before the item was substituted.
ORIGINAL_PRODUCT_NUMBER VARCHAR2 300 Number of the original inventory item that was populated on the fulfillment line before the item was substituted.
ORIGINAL_PRODUCT_DESCRIPTION VARCHAR2 240 Description of the original inventory item that was populated on the fulfillment line before the item was substituted.
PARTIAL_SHIP_ALLOWED_FLAG VARCHAR2 1 Indicates that the items on the order can be shipped in multiple shipments, rather than as one shipment.
FULFILLMENT_LINE_ID NUMBER 18 Unique identifier of a fulfillment line.
COMMENTS VARCHAR2 2000 Comments for the line.
UNIT_LIST_PRICE NUMBER Base selling price before applying discounts. It typically defaults from the item definition.
UNIT_SELLING_PRICE NUMBER Price per unit that a buyer paid for an item.
EXTENDED_AMOUNT NUMBER Monetary amount of the order line quantity.
EARLIEST_ACCEPTABLE_SHIP_DATE DATE Earliest date that the customer is willing to receive a shipment.
LATEST_ACCEPTABLE_SHIP_DATE DATE Latest date that the customer is willing to have a warehouse ship a product.
EARLIEST_ACCEPTABLE_ARR_DATE DATE Earliest date the customer can accept arrival.
LATEST_ACCEPTABLE_ARRIVAL_DATE DATE Latest date that the customer is willing to receive a product.
PROMISE_SHIP_DATE DATE Date that was promised to the customer that the item would ship.
PROMISE_ARRIVAL_DATE DATE Date that was promised to the customer that the item would arrive.
SUBINVENTORY_CODE VARCHAR2 10 Code that represents the physical or logical location of the item.
SUBINVENTORY VARCHAR2 50 Physical or logical location of the item.
SHIP_SET_NAME VARCHAR2 50 Group of order lines within an order that need to ship together from their common origin to a common destination and which have the same scheduled ship date.
TAX_EXEMPT_FLAG VARCHAR2 1 Indicates that a quote or fulfillment line is exempt from taxes.
TAX_CLASSIFICATION_CODE VARCHAR2 1000 Code that represents a grouping of taxes for reporting and processing purposes.
TAX_CLASSIFICATION VARCHAR2 1000 Grouping of taxes for reporting and processing purposes.
TAX_EXEMPTION_CERTIFICATE_NO VARCHAR2 80 Certification number of tax exemption granted by taxing authority for tax exempt customers.
TAX_EXEMPT_REASON_CODE VARCHAR2 1000 Code that represent the reason a tax exemption was granted and taken.
TAX_EXEMPT_REASON VARCHAR2 1000 Reason that a tax exemption was granted and taken.
DEFAULT_TAXATION_COUNTRY VARCHAR2 2 Country used for tax calculation purposes.
DEFAULT_TAX_COUNTRY_SHORT_NAME VARCHAR2 80 Specifies the taxation country for tax calculation purposes.
FIRST_PARTY_TAX_REGISTRATION NUMBER 18 Registration number that is quoted to the supplier. The supplier uses this number to tax the transaction.
FIRST_PARTY_TAX_REG_NUMBER VARCHAR2 50 Registration number that is quoted to the supplier. Supplier uses this number to tax the transaction.
THIRD_PARTY_TAX_REGISTRATION NUMBER 18 Registration number specified by the customer in the purchase order.
THIRD_PARTY_TAX_REG_NUMBER VARCHAR2 50 Customer registration number that is specified by the customer on the purchase order.
DOCUMENT_SUBTYPE VARCHAR2 240 Classification that is used for tax calculation and tax reporting, depending upon the requirements of different countries.
DOCUMENT_SUBTYPE_NAME VARCHAR2 240 Used for tax calculation and tax reporting, depending upon the requirements of different countries.
PRODUCT_FISCAL_CATEGORY_ID NUMBER 18 Unique identifier of the classification of the products by tax authority for tax purposes.
PRODUCT_FISCAL_CATEGORY_NAME VARCHAR2 250 Classification of the product by tax authority for tax purposes.
PRODUCT_TYPE VARCHAR2 240 Product-related classification in Oracle Fusion Tax. The value of the product type specifies whether the transaction line is for a good or service, or whether it is a memo line.
PRODUCT_TYPE_NAME VARCHAR2 80 Product-related classification in Oracle Fusion Tax. The value of product type specifies whether the transaction line is for a good, or a service, or it is a memo line.
PRODUCT_CATEGORY VARCHAR2 240 Product classification for tax purposes.
PRODUCT_CATEGORY_NAME VARCHAR2 240 Used to classify products for tax purposes. It is used where Oracle Fusion Inventory is not installed, or is installed but not used for classifying products for tax purposes.
TRANSACTION_BUSINESS_CATEGORY VARCHAR2 240 Classification of a transaction for tax purposes as required by a tax authority.
TXN_BUSINESS_CATEGORY_NAME VARCHAR2 240 Classification or categorization of a transaction for tax purposes as required by a tax authority.
ASSESSABLE_VALUE NUMBER Price at which a product is valued by a tax authority for a given tax.
USER_DEFINED_FISCAL_CLASS VARCHAR2 30 Classification of the transaction into different categories for tax purposes.
USER_DEFINED_FISC_CLASS_NAME VARCHAR2 240 Classification of the transaction into different categories for tax purposes.
INTENDED_USE_CLASSIFICATION_ID NUMBER 18 Unique identifier of the classification for intended use of the item for tax calculation purposes.
INTENDED_USE_CLASS_NAME VARCHAR2 240 Classification name for intended use for tax calculation purposes.
FOB_POINT_CODE VARCHAR2 1000 Code that indicates the point at which the responsibility of the goods transfers from shipper to buyer.
FOB_POINT VARCHAR2 1000 Point at which the responsibility of the goods transfers from shipper to buyer.
ORIG_SYS_DOCUMENT_REFERENCE VARCHAR2 50 Original document reference of the orchestration order in the system that captured the transaction.
ORIG_SYS_DOC_LINE_REFERENCE VARCHAR2 50 Original document reference of the order line in the system that captured the transaction.
SOURCE_SYS_PRODUCT_REFERENCE VARCHAR2 150 Reference that represents the product in the system that captured the transaction.
QUANTITY_PER_MODEL NUMBER Component quantity for a single model.
OPERATION_MODE VARCHAR2 30 One mechanism to designate that the line is being canceled.
CONFIG_HEADER_ID NUMBER 18 Header ID of the configuration. It is populated only for the root line by Oracle Fusion Configurator.
CONFIG_REVISION_NUMBER NUMBER 18 Revision number of the configuration. It is populated for the root line by Oracle Fusion Configurator.
IS_VALID_CONFIGURATION VARCHAR2 1 Indicates whether the configuration is valid. It is populated only for the root line. The calling application is expected to not allow an order to be booked if this value is false.
CONFIGURATOR_PATH VARCHAR2 2000 Run time representation of the inventory item ID path to the component. It is populated and used by Oracle Fusion Configurator.
COMPONENT_ID_PATH VARCHAR2 2000 Inventory item ID path to the parent of this item line.
UNIT_QUANTITY NUMBER Requested component quantity of a child option for one unit of a parent item component in a configuration.
SORT_LINE_NUMBER NUMBER 9 Line number that is used for sorting.
CONTRACT_START_DATE DATE Start date of the contract.
CONTRACT_END_DATE DATE End date of the contract.
REQUIRED_FULFILLMENT_DATE TIMESTAMP Customer required fulfillment date.
TOTAL_CONTRACT_QUANTITY NUMBER Total quantity covered by the contract.
TOTAL_CONTRACT_AMOUNT NUMBER Total amount covered by the contract.
SERVICE_DURATION NUMBER Captures duration for the coverage or subscription product on the fulfillment line.
SERVICE_DURATION_PERIOD_CODE VARCHAR2 10 Identifies duration unit of measure for the coverage or subscription product on the fulfillment line.
SERVICE_DURATION_PERIOD_NAME VARCHAR2 25 Name of the Service duration unit of measure for the coverage or subscription product that is being ordered.
SALESPERSON_ID NUMBER 18 Primary Sales person id.
SALESPERSON VARCHAR2 360 Primary Sales person name.
ASSET_GROUP_NUMBER VARCHAR2 30 Asset Group Number. Used for grouping customer assets together.
LOAD_REQUEST_ID NUMBER 18 Identifier of the process that populates the interface table.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 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.
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.
FULFILL_LINE_ID NUMBER 18 Unique identifier for the sales order line. This is an internal column.
BATCH_ID NUMBER 18 Id of the batch as part of which this line will be processed
PROCESS_ID NUMBER 18 Id of the assigned process for order. This column is not used currently.
PROCESS_NAME VARCHAR2 80 This column will accept valid/active value from DOO_PROCESS_DEFINITION table's PROCESS_NAME attribute. This value will be used to select the orchestration process to process that order line. To find the valid value for this column, please use Orchestration Process Maintenance user interface. This value will be accepted as part of import only for new lines; for both CREATE and UPDATE flows. Update of Process Name is not possible for lines which are already submitted in UPDATE flow. For UPDATE flow, make sure you provide Process Name for all new lines; if you have provided Process Name value for lines in CREATE flow.
PROCESS_DISPLAY_NAME VARCHAR2 80 Display name of the assigned process. This column is not used currently.
VALIDATION_BITSET NUMBER 20 Oracle internal use only. This is used to identify attributes that failed validation.
SELLING_PROFIT_CENTER_BU_ID NUMBER 18 Reference to Unique Identifier of Profit Center Business Unit.
INVENTORY_TRANSACTION_FLAG VARCHAR2 1 Contains Y, N, or empty. Y: Order management sends a request to inventory management to do an inventory transaction when fulfilling the order line instead of using the pick wave, pick, pack, and ship flow. N or empty: Order management uses the pick wave, pick, pack, and ship flow to fulfill the order line. The Order Entry Specialist sets the value for this attribute in the Order Management work area, or order management sets it during order import.
SUBSCRIPTION_PROFILE_ID NUMBER 18 Value that uniquely identifies the subscription profile.
SUBSCRIPTION_PROFILE_NAME VARCHAR2 300 Value that identifies with the name of the subscription profile.
EXTERNAL_PRICE_BOOK_NAME VARCHAR2 80 Price book or price list name in the external pricing application.
ACTION_TYPE_CODE VARCHAR2 30 Abbreviation that identifies the Type of action for subscription or coverage: Add, Terminate, or Amend. The ORA_QP_ACTION_TYPES lookup type contains the values that you can use for this attribute.
ACTION_TYPE VARCHAR2 80 Value that identifies the name of the type of the action with respect to the Subscription or the Coverage product.
END_REASON_CODE VARCHAR2 30 Abbreviation that identifies the Reason to end or amend the subscription or coverage. The ORA_OSS_CLOSE_REASONS lookup type contains the values that you can use for this attribute.
END_REASON VARCHAR2 80 Value that identifies the name of the Reason for ending or amending the subscription or coverage.
END_CREDIT_METHOD_CODE VARCHAR2 30 Abbreviation that identifies the credit method for ending or amending the subscription or coverage. The ORA_OSS_CLOSE_CREDIT_METHOD lookup type contains the values that you can use for this attribute.
END_CREDIT_METHOD VARCHAR2 80 Value that identifies the name of the credit method used for ending or amending a subscription or coverage.
END_DATE TIMESTAMP Date when the subscription or coverage is ended.
DEMAND_SOURCE_LINE_REFERENCE VARCHAR2 400 Value that uniquely identifies demand, such as the line in a shopping cart on a web store or in an ecommerce application. You create a sales order in a web store, the web store sends a request to Global Order Promising to schedule it, Global Order Promising schedules the demand and sends a reply to the web store, the web store sends the sales order to Order Management, then Order Management manages the order through fulfillment.
REQUESTED_RATE_PLAN_ID NUMBER 18 Value that uniquely identifies the rate plan requested by the user. The rate plan is maintained in Oracle Fusion Cloud Pricing. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions and Rate Usage With Events features.
REQUESTED_RATE_PLAN_NUMBER VARCHAR2 120 Number that identifies the rate plan requested by the user. The rate plan is maintained in Oracle Fusion Cloud Pricing. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions and Rate Usage With Events features.
CANCEL_BACKORDERS_FLAG VARCHAR2 1 Contains Y or N. Y: Allow user to cancel sales orders or order lines that have items that are on back order. N: Don't allow.
ENFORCE_SINGLE_SHIPMENT_FLAG VARCHAR2 1 Contains Y or N. Y: Allow user to cancel the part of the order line's quantity that they can't ship in one shipment. N: Don't allow.

Indexes

Index Uniqueness Tablespace Columns
DOO_ORDER_LINES_ALL_INT_N1 Non Unique Default SOURCE_TRANSACTION_ID, SOURCE_TRANSACTION_SYSTEM, LOAD_REQUEST_ID, SOURCE_TRANSACTION_LINE_ID
DOO_ORDER_LINES_ALL_INT_N2 Non Unique Default BATCH_ID