1. Tables and Views for SCM
  2. INV_CST_SALES_ORDER_DETAILS_GT

INV_CST_SALES_ORDER_DETAILS_GT

This global temporary table is used for processing sales order related information from DOO, WSH, and RCV.

Details

  • Schema: FUSION

  • Object owner: INV

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Not-null Comments
BILL_TO_CUSTOMER_ID NUMBER 18 Reference to the unique identifier for the bill-to customer.
RMA_REFERENCE_DOO_FLINE_ID NUMBER 18 This column identifies the referenced DOO fulfill line id for RMA transactions.
CONVERSION_DATE DATE Date that the foreign exchange rate was valid.
CONVERSION_RATE VARCHAR2 10 Foreign exchange conversion rate used to convert the transactional currency into the standardized currency in the UI.
CONVERSION_TYPE_CODE VARCHAR2 30 Describes how the conversion rate was computed.
CUSTOMER_ID NUMBER 18 Reference to the unique identifier for the sold-to customer.
DOO_LINE_ID NUMBER 18 Unique identifier of the orchestration order line.
DOO_LINE_NUMBER NUMBER 9 Representation of a sales order line used in communication with fulfillment systems.
DOO_ORDER_CURRENCY VARCHAR2 15 Currency code captured at the order header level.
DOO_ORDER_HEADER_ID NUMBER 18 Unique identifier of the orchestration order.
DOO_ORDER_NUMBER VARCHAR2 150 Reference to the number of the originating sales order.
DOO_ORDERED_DATE TIMESTAMP Date when the items where ordered.
DOO_UNIT_SELLING_PRICE NUMBER The price per unit that a buyer paid for an item.
EXTERNAL_SYSTEM_REF_ID VARCHAR2 450 Yes Unique identifier for a fulfillment line. This value is the FULFILL_LINE_ID from the DOO_FULFILL_LINES_ALL table or a concatenated value from the WSH_DELIVERY_DETAILS or RCV_SHIPMENT_HEADERS tables.
EXTERNAL_SYSTEM_REFERENCE VARCHAR2 60 Yes Identifies the external source system reference.
INVENTORY_ITEM_ID NUMBER 18 Yes Reference to the unique identifier for the inventory item.
INVENTORY_ORGANIZATION_ID NUMBER 18 Yes Reference to the unique identifier for the inventory organization.
INV_TRANSACTION_ID NUMBER 18 Yes Identifies the inventory transaction for the sales order.
PARENT_FULFILL_LINE_ID NUMBER 18 Used in fulfillment line hierarchies (models) to identify the immediate parent fulfillment line.
REFERENCED_DOO_FULFILL_LINE_ID NUMBER 18 Used by change management to associate the change order's fulfillment line id with the original order's fulfillment line id.
ROOT_PARENT_FULFILL_LINE_ID NUMBER 18 Used in fulfillment line hierarchies (models) to identify the highest fulfillment line in the hierarchy.
SALES_REP_ID NUMBER 18 Identifies the sales representative of the sales order.
SELLING_LEGAL_ENTITY_ID NUMBER 18 Reference to the unique identifier for the legal entity.
SELLING_ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
SHIP_TO_CUSTOMER_ID NUMBER 18 Reference to the unique identifier for the ship-to customer.
SALES_ORDER_SHIPMENT_NUMBER VARCHAR2 150 Indicates the sales order shipment number from shipping.
CUSTOMER_ACCOUNT_ID NUMBER 18 Identifies the customer account of the sales order.
INVENTORY_INTERFACED_FLAG VARCHAR2 1 Contains Y, N, or empty. Y: Order management successfully interfaced the fulfillment line to inventory management. N or empty: Order management hasn't interfaced the fulfillment line. Order management updates this attribute when it directly reduces inventory to fulfill the order line.
BILL_TO_SITE_USE_ID NUMBER 18 Reference to the unique identifier for the bill-to customer location
SHIP_TO_PARTY_ID NUMBER 18 Reference to the unique identifier for ship-to Party.
SHIP_TO_PARTY_SITE_ID NUMBER 18 Reference to the unique identifier for the ship-to Party Site.
SOLD_TO_PARTY_ID NUMBER 18 Reference to the unique identifier for the sold-to Party.