DOO_ORDER_HEADERS_ALL_INT
This interface table contains details of Header for an imported Source Sales 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 from the system that captured the transaction. | ||
| AGREEMENT_NUMBER | VARCHAR2 | 150 | Number that uniquely identifies the sales agreement on the order header. | ||
| AGREEMENT_HEADER_ID | NUMBER | 18 | Value that uniquely identifies the sales agreement on the order header. | ||
| PRE_CREDIT_CHECKED_FLAG | VARCHAR2 | 1 | The attribute is used to indicate if an Order has already been credit checked within upstream channel systems or not. | ||
| SOURCE_TRANSACTION_SYSTEM | VARCHAR2 | 30 | System or application that submitted the order request. | ||
| SOURCE_TRANSACTION_NUMBER | VARCHAR2 | 50 | Document number in the system that captured the transaction. | ||
| SOURCE_TRANSACTION_REVISION_NO | NUMBER | 18 | Revision number of the transaction. | ||
| BUYING_PARTY_CONTACT_ID | NUMBER | 18 | Unique identifier of the person who placed the order or is the primary contact for the order. | ||
| BUYING_PARTY_CONTACT_NAME | VARCHAR2 | 360 | Person who placed the order or is the primary contact for the order. This person is sometimes called the sold-to customer. | ||
| BUYING_PARTY_CONTACT_NUMBER | VARCHAR2 | 30 | Reference number of the person who placed the order or is the primary contact for the order. | ||
| BUYING_PARTY_ID | NUMBER | 18 | Unique identifier of the person, company, or organization that placed the order. This is sometimes known as the sold-to customer ID. | ||
| BUYING_PARTY_NAME | VARCHAR2 | 360 | Name of the person, company, or organization that placed the order. This is sometimes known as the sold-to customer name. | ||
| BUYING_PARTY_NUMBER | VARCHAR2 | 30 | Number of the person, company, or organization that placed the order. This is sometimes known as the sold-to customer number. | ||
| BUYING_PARTY_FIRST_NAME | VARCHAR2 | 150 | First name of the party or account contact who placed the order or is the primary contact for the order. | ||
| BUYING_PARTY_LAST_NAME | VARCHAR2 | 150 | Last name of the party or account contact who placed the order or is the primary contact for the order. | ||
| BUYING_PARTY_MIDDLE_NAME | VARCHAR2 | 60 | Middle name of the party or account contact who placed the order or is the primary contact for the order. | ||
| BUYING_PARTY_NAME_SUFFIX | VARCHAR2 | 30 | Suffix of the party or account contact who placed the order or is the primary contact for the order. | ||
| BUYING_PARTY_TITLE | VARCHAR2 | 60 | Title of the party or account contact who placed the order or is the primary contact for the order | ||
| BUYING_CONTACT_FIRST_NAME | VARCHAR2 | 150 | First name of the person who placed the order or is the primary contact for the order. | ||
| BUYING_CONTACT_LAST_NAME | VARCHAR2 | 150 | Last name of the person who placed the order or is the primary contact for the order. | ||
| BUYING_CONTACT_MIDDLE_NAME | VARCHAR2 | 60 | Middle name of the person who placed the order or is the primary contact for the order. | ||
| BUYING_CONTACT_NAME_SUFFIX | VARCHAR2 | 30 | Suffix of the person who placed the order or is the primary contact for the order. | ||
| BUYING_CONTACT_TITLE | VARCHAR2 | 60 | Title of the person who placed the order or is the primary contact for the order. | ||
| BUYING_PARTY_TYPE | VARCHAR2 | 30 | Identifies the type of the party who placed the sales order. The party type can be a person or an organization. | ||
| BUYING_PARTY_CONTACT_EMAIL | VARCHAR2 | 320 | E-mail of the contact who placed the order or who is the primary contact for the order | ||
| BUYING_PARTY_PERSON_EMAIL | VARCHAR2 | 320 | E-mail of the person who placed the order | ||
| BUYING_PARTY_ORG_EMAIL | VARCHAR2 | 320 | E-mail of the organization that placed the order | ||
| PREF_SOLD_TO_CONTACT_POINT_ID | NUMBER | 18 | Unique identifier of the preferred sold-to party contact point | ||
| PREF_SOLD_CONT_PT_ORIG_SYS_REF | VARCHAR2 | 240 | Preferred sold-to party contact point reference from the system that originally captured the transaction. | ||
| CUSTOMER_PO_NUMBER | VARCHAR2 | 50 | Purchase order number the customer sends as an identifier of this order. | ||
| TRANSACTIONAL_CURRENCY_CODE | VARCHAR2 | 1000 | Currency code used for pricing the transaction. | ||
| TRANSACTIONAL_CURRENCY_NAME | VARCHAR2 | 1000 | Currency Name used for pricing the transaction. | ||
| TRANSACTION_ON | DATE | Date and time that the transaction was started. In the case of sales order-based orchestration order requests, the timestamp is the date that the customer committed to purchase the items in the order. Timestamp is used to measure the time it took to fulfill an order. | |||
| REQUESTING_BUSINESS_UNIT_ID | NUMBER | 18 | Unique identifier of the internal organization that sold the order. | ||
| REQUESTING_BUSINESS_UNIT | VARCHAR2 | 240 | The internal organization that sold the order. | ||
| TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Type of transaction as determined by the system that captured the transaction. | ||
| TRANSACTION_DOCUMENT_TYPE_CODE | VARCHAR2 | 50 | Indicates whether this request is based on a sales order, purchase order, or internal material transfer. | ||
| REQUEST_CANCEL_DATE | TIMESTAMP | Date and time on which the cancellation was requested. | |||
| CANCEL_REASON_CODE | VARCHAR2 | 1000 | Code that represents the reason the order was canceled. | ||
| CANCEL_REASON | VARCHAR2 | 1000 | Reason to cancel the sales order. | ||
| COMMENTS | VARCHAR2 | 2000 | Free-form text that can be used to capture any high-level information about the transaction. | ||
| BATCH_NAME | VARCHAR2 | 50 | Name of the batch that contains the record | ||
| SUB_BATCH_NAME | VARCHAR2 | 50 | Batch name assigned during the import based on the orders grouped for processing. | ||
| REQUESTING_LEGAL_UNIT_ID | NUMBER | 18 | Unique identifier of the legal entity that formed a contract with the customer. | ||
| REQUESTING_LEGAL_UNIT | VARCHAR2 | 240 | Legal entity that formed a contract with the customer. | ||
| ORIG_SYS_DOCUMENT_REFERENCE | VARCHAR2 | 50 | Document number from the system that originally captured the transaction. | ||
| PARTIAL_SHIP_ALLOWED_FLAG | VARCHAR2 | 1 | Indicates whether a shipment can be split. | ||
| BUYING_PARTY_ORIG_SYS_REF | VARCHAR2 | 255 | Unique identifier that represents the buying party in the system that captured the transaction. | ||
| BUYING_PARTY_CONT_ORIG_SYS_REF | VARCHAR2 | 255 | Unique identifier that represents the buying party contact in the system that captured the transaction. | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 1000 | Foreign currency conversion type. | ||
| CURRENCY_CONVERSION_RATE | NUMBER | Foreign currency conversion rate. | |||
| CURRENCY_CONVERSION_DATE | DATE | Foreign currency conversion date. | |||
| PRICED_ON | TIMESTAMP | Date when the document is priced. This attribute is populated with the system date at the beginning of a pricing process. | |||
| FREEZE_PRICING | VARCHAR2 | 1 | Indicates whether an order must be priced. | ||
| FREEZE_SHIPPING_CHARGE | VARCHAR2 | 1 | Indicates whether shipping charges for an order must be recalculated. | ||
| FREEZE_TAX | VARCHAR2 | 1 | Indicates whether tax charges for an order must be recalculated. | ||
| OPERATION_MODE | VARCHAR2 | 30 | Indicates that the order is being canceled. | ||
| CREATE_CUSTOMER_INFO_FLAG | VARCHAR2 | 1 | Indicates if the customer information should be used to create a new customer entry. | ||
| SUBMIT_FLAG | VARCHAR2 | 1 | Indicates if the order should be submitted or created. | ||
| 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. | |
| INTERFACE_STATUS_CODE | VARCHAR2 | 30 | Status of the data in the interface table. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Unique identifier of the import request | ||
| REVISION_SOURCE_TXN_SYSTEM | VARCHAR2 | 30 | This attribute column tracks the source system which is revising the order | ||
| SALES_CHANNEL_CODE | VARCHAR2 | 30 | Code for the type of Sales Channel that was used like Web,Phone, CPQ, webstore,etc | ||
| SALES_CHANNEL | VARCHAR2 | 80 | Name of the type of Sales Channel that was used like Web,Phone, CPQ, webstore,etc | ||
| SALESPERSON_ID | NUMBER | 18 | Unique identifier of primary salesperson. | ||
| SALESPERSON | VARCHAR2 | 360 | Name of the primary salesperson. | ||
| HEADER_ID | NUMBER | 18 | Unique identifier for the sales order. This is an internal column. | ||
| BATCH_ID | NUMBER | 18 | Id of the batch as part of which this order will be processed | ||
| VALIDATION_BITSET | NUMBER | 20 | Oracle internal use only. This is used to identify attributes that failed validation. | ||
| CREATION_MODE | VARCHAR2 | 30 | Oracle internal use only. This is used to identify whether the order is coming via regular batch import or high volume order import. | ||
| ORDER_REQUEST_ID | NUMBER | 18 | Unique identifier assigned to each sales order while loading of the sales order into interface table. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| DOO_ORDER_HEADERS_ALL_INT_N1 | Non Unique | Default | INTERFACE_STATUS_CODE |
| DOO_ORDER_HEADERS_ALL_INT_N10 | Non Unique | Default | BATCH_ID |
| DOO_ORDER_HEADERS_ALL_INT_N11 | Non Unique | Default | ORDER_REQUEST_ID |
| DOO_ORDER_HEADERS_ALL_INT_N2 | Non Unique | Default | BATCH_NAME |
| DOO_ORDER_HEADERS_ALL_INT_N3 | Non Unique | Default | CREATION_DATE |
| DOO_ORDER_HEADERS_ALL_INT_N4 | Non Unique | Default | SOURCE_TRANSACTION_SYSTEM |
| DOO_ORDER_HEADERS_ALL_INT_N5 | Non Unique | Default | SOURCE_TRANSACTION_ID, SOURCE_TRANSACTION_SYSTEM, LOAD_REQUEST_ID |
| DOO_ORDER_HEADERS_ALL_INT_N6 | Non Unique | Default | SUB_BATCH_NAME |
| DOO_ORDER_HEADERS_ALL_INT_N7 | Non Unique | Default | BUYING_PARTY_NAME |
| DOO_ORDER_HEADERS_ALL_INT_N8 | Non Unique | Default | BUYING_PARTY_NUMBER |
| DOO_ORDER_HEADERS_ALL_INT_N9 | Non Unique | Default | TRANSACTION_ON |