SALES ORDER DETAIL Table
View exposing sales order detail including sales-order and line-item identifiers, pricing and material references, cost collector, requested delivery date, amount, sold-to and ship-to customer information, and order-creation attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMOUNT |
Amount associated with the record. |
NUMBER |
13,2 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
CUSTOMER_SHIP_TO_CITY |
Customer ship to city associated with the record. |
VARCHAR2 |
35 |
CUSTOMER_SHIP_TO_COUNTRY |
Customer ship to country associated with the record. |
VARCHAR2 |
15 |
CUSTOMER_SHIP_TO_KEY |
Surrogate key identifying the customer ship to. |
VARCHAR2 |
11 |
CUSTOMER_SHIP_TO_NAME |
Customer ship to name associated with the person or organization. |
VARCHAR2 |
50 |
CUSTOMER_SHIP_TO_NUMBER |
Customer ship to number associated with the record. |
VARCHAR2 |
10 |
CUSTOMER_SHIP_TO_PHONE |
Customer ship to phone associated with the record. |
VARCHAR2 |
16 |
CUSTOMER_SHIP_TO_STATE |
Customer ship to state associated with the record. |
VARCHAR2 |
3 |
CUSTOMER_SHIP_TO_STREET |
Customer ship to street associated with the record. |
VARCHAR2 |
35 |
CUSTOMER_SHIP_TO_ZIP |
Customer ship to zip associated with the record. |
VARCHAR2 |
10 |
CUSTOMER_SOLD_TO_CITY |
Customer sold to city associated with the record. |
VARCHAR2 |
35 |
CUSTOMER_SOLD_TO_COUNTRY |
Customer sold to country associated with the record. |
VARCHAR2 |
15 |
CUSTOMER_SOLD_TO_KEY |
Surrogate key identifying the customer sold to. |
VARCHAR2 |
11 |
CUSTOMER_SOLD_TO_NAME |
Customer sold to name associated with the person or organization. |
VARCHAR2 |
50 |
CUSTOMER_SOLD_TO_NUMBER |
Customer sold to number associated with the record. |
VARCHAR2 |
10 |
CUSTOMER_SOLD_TO_PHONE |
Customer sold to phone associated with the record. |
VARCHAR2 |
16 |
CUSTOMER_SOLD_TO_STATE |
Customer sold to state associated with the record. |
VARCHAR2 |
3 |
CUSTOMER_SOLD_TO_STREET |
Customer sold to street associated with the record. |
VARCHAR2 |
35 |
CUSTOMER_SOLD_TO_ZIP |
Customer sold to zip associated with the record. |
VARCHAR2 |
10 |
DOCUMENT_TYPE |
Document type associated with the record. |
VARCHAR2 |
4 |
MATERIAL_KEY |
Surrogate key identifying the material. |
VARCHAR2 |
18 |
PRICING_ELEMENT_KEY |
Surrogate key identifying the pricing element. |
VARCHAR2 |
10 |
REQUESTED_DELIVERY_DATE |
Date associated with requested delivery. |
DATE |
|
SALES_ORDER_CREATE_DATE |
Date associated with sales order create. |
DATE |
|
SALES_ORDER_CREATE_USER |
Sales order create user associated with the record. |
VARCHAR2 |
12 |
SALES_ORDER_LINE_ITEM |
Sales order line item associated with the record. |
NUMBER |
6 |
SALES_ORDER_NUMBER |
Sales order number associated with the record. |
VARCHAR2 |
10 |
SALES_ORDER_ORGANIZATION |
Sales order organization associated with the record. |
VARCHAR2 |
10 |
SALES_ORDER_PARTNER_KEY |
Surrogate key identifying the sales order partner. |
VARCHAR2 |
20 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |