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. This column is not in use. | ||
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. This column is not in use. |
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 |