outbound_order_line
Primary key (PK)
The table below lists the colum names that are uniquely identified in the data entity.
Name | Column |
---|---|
outbound_order_line | id,cust_order_id, product_id |
The table below lists the column names supported by the data entity:
Column | Data type | Required | Description |
---|---|---|---|
id |
string |
Yes1 |
Outbound order line ID. |
cust_order_id |
string |
Yes1 |
Outbound order ID. |
company_id2 |
string |
No |
Company ID. |
order_date |
timestamp |
No |
Date and time when customer order was placed. |
product_id2 |
string |
Yes1 |
Product ID. |
product_group_id2 |
string |
No |
Product group ID. |
customer_tpartner_id2 |
string |
No |
Trading partner ID for customer. |
status |
string |
No |
Status of the customer order. |
init_quantity_requested |
double |
No |
Original order quantity. |
final_quantity_requested |
double |
No |
Final quantity after any cancellations or changes. |
quantity_uom |
string |
No |
Quantity unit of measure for the order line. |
requested_delivery_date |
timestamp |
No |
Requested delivery date for order line. |
promised_delivery_date |
timestamp |
No |
Delivery date promised for order lines. |
actual_delivery_date |
timestamp |
No |
Actual delivery date for order line. |
list_price |
double |
No |
List price for product in order lines.. |
sold_price |
double |
No |
Selling price for product in order line, after any promotions, price changes, discounts, and so on. |
discount |
double |
No |
Discount applied for order line for this product. |
discount_code |
string |
No |
Discount code used on order line. |
currency_uom |
string |
No |
UUOM for currency. |
tax |
double |
No |
Tax amount for order line. |
incoterm1 |
string |
No |
Place of ownership transfer. |
incoterm2 |
string |
No |
Place of ownership transfer. |
ship_from_site_id2 |
string |
No |
Site ID where the product is shipped from. |
ship_to_site_id2 |
string |
No |
Site ID where the product is shipped to. |
ship_to_site_address_1 |
string |
No |
Address of ship-to site. |
ship_to_site_address_2 |
string |
No |
Address of ship-to site. |
ship_to_site_address_city |
string |
No |
City of ship-to site. |
ship_to_site_address_state |
string |
No |
State of ship-to site. |
ship_to_site_address_country |
string |
No |
Country of ship-to site. |
ship_to_site_address_zip |
string |
No |
Postal code of ship-to site. |
availability_status |
string |
No |
In-stock availability status of the product at the time of order. |
quantity_promised |
double |
No |
Quantity promised on order line. |
quantity_delivered |
double |
No |
Quantity delivered against this order line. |
channel_id |
string |
No |
Channel ID that was used to place this order. |
sap_2lis_11_vahdr__vbeln |
string |
No |
Reference document number. Predicate key for SAP mapping. Upsert key for VEDA. |
sap_2lis_11_vaitm__kunnr |
string |
No |
Sold to party. Predicate key for SAP mapping. Upsert key for 0CUST_SALES_ATTR. |
sap_2lis_11_vaitm__vkorg |
string |
No |
Sales organization. Predicate key for SAP mapping. Upsert key for 0CUST_SALES_ATTR. |
sap_2lis_11_vaitm__vtweg |
string |
No |
Distribution channel. Predicate key for SAP mapping. Upsert key for 0CUST_SALES_ATTR. |
sap_2lis_11_vaitm__spart |
string |
No |
Division. Predicate key for SAP mapping. Upsert key for 0CUST_SALES_ATTR. |
sap_2lis_11_vaitm__pkunre |
string |
No |
Bill-to party. Predicate key for SAP mapping. |
source |
string |
No |
Source of data. |
source_event_id |
string |
No |
ID of the event created in the source system. |
source_update_dttm |
timestamp |
No |
Date time stamp of the update made in the source system. |
1You must enter a value. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED.
2Foreign key
Foreign key (FK)
The table below lists the columns with the associated foreign key.
Column | Category | FK/Data entity | FK/Column |
---|---|---|---|
company_id | Organization | company | id |
product_id | Product | product | id |
product_group_id | Product | product_hierarchy | id |
customer_tpartner_id | Organization | trading_partner | id |
ship_from_site_id, ship_to_site_id | Network | site | id |