# outbound\$1order\$1line


**Primary key (PK)**

The table below lists the colum names that are uniquely identified in the data entity.


| Name | Column | 
| --- | --- | 
| outbound\$1order\$1line | id,cust\$1order\$1id, product\$1id | 

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\$1order\$1id  |  string  |  Yes1  |  Outbound order ID.  | 
|  company\$1id2  |  string  |  No  |  Company ID.  | 
|  order\$1date  |  timestamp  |  No  |  Date and time when customer order was placed.  | 
|  product\$1id2  |  string  |  Yes1  |  Product ID.  | 
|  product\$1group\$1id2  |  string  |  No  |  Product group ID.  | 
|  customer\$1tpartner\$1id2  |  string  |  No  |  Trading partner ID for customer.  | 
|  status  |  string  |  No  |  Status of the customer order.  | 
|  init\$1quantity\$1requested  |  double  |  No  |  Original order quantity.  | 
|  final\$1quantity\$1requested  |  double  |  No  |  Final quantity after any cancellations or changes.  | 
|  quantity\$1uom  |  string  |  No  |  Quantity unit of measure for the order line.  | 
|  requested\$1delivery\$1date  |  timestamp  |  No  |  Requested delivery date for order line.  | 
|  promised\$1delivery\$1date  |  timestamp  |  No  |  Delivery date promised for order lines.  | 
|  actual\$1delivery\$1date  |  timestamp  |  No  |   Actual delivery date for order line.  | 
|  list\$1price  |  double  |  No  |  List price for product in order lines..  | 
|  sold\$1price  |  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\$1code  |  string  |  No  |  Discount code used on order line.  | 
|  currency\$1uom  |  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\$1from\$1site\$1id2  |  string  |  No  |  Site ID where the product is shipped from.  | 
|  ship\$1to\$1site\$1id2  |  string  |  No  |  Site ID where the product is shipped to.  | 
|  ship\$1to\$1site\$1address\$11  |  string  |  No  |  Address of ship-to site.  | 
|  ship\$1to\$1site\$1address\$12  |  string  |  No  |  Address of ship-to site.  | 
|  ship\$1to\$1site\$1address\$1city  |  string  |  No  |  City of ship-to site.  | 
|  ship\$1to\$1site\$1address\$1state  |  string  |  No  |  State of ship-to site.  | 
|  ship\$1to\$1site\$1address\$1country  |  string  |  No  |  Country of ship-to site.  | 
|  ship\$1to\$1site\$1address\$1zip  |  string  |  No  |  Postal code of ship-to site.  | 
|  availability\$1status  |  string  |  No  |  In-stock availability status of the product at the time of order.  | 
|  quantity\$1promised  |  double  |  No  |  Quantity promised on order line.  | 
|  quantity\$1delivered  |  double  |  No  |  Quantity delivered against this order line.  | 
|  channel\$1id  |  string  |  No  |  Channel ID that was used to place this order.  | 
|  sap\$12lis\$111\$1vahdr\$1\$1vbeln  |  string  |  No  |  Reference document number. Predicate key for SAP mapping. Upsert key for VEDA.  | 
|  sap\$12lis\$111\$1vaitm\$1\$1kunnr  |  string  |  No  |  Sold to party. Predicate key for SAP mapping. Upsert key for 0CUST\$1SALES\$1ATTR.  | 
|  sap\$12lis\$111\$1vaitm\$1\$1vkorg  |  string  |  No  |  Sales organization. Predicate key for SAP mapping. Upsert key for 0CUST\$1SALES\$1ATTR.  | 
|  sap\$12lis\$111\$1vaitm\$1\$1vtweg  |  string  |  No  |  Distribution channel. Predicate key for SAP mapping. Upsert key for 0CUST\$1SALES\$1ATTR.  | 
|  sap\$12lis\$111\$1vaitm\$1\$1spart  |  string  |  No  |  Division. Predicate key for SAP mapping. Upsert key for 0CUST\$1SALES\$1ATTR.  | 
|  sap\$12lis\$111\$1vaitm\$1\$1pkunre  |  string  |  No  |  Bill-to party. Predicate key for SAP mapping.  | 
|  source  |  string  |  No  |  Source of data.  | 
|  source\$1event\$1id  |  string  |  No  |  ID of the event created in the source system.  | 
|  source\$1update\$1dttm  |  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\$1RESERVED\$1NO\$1VALUE\$1PROVIDED.

2Foreign key

**Foreign key (FK)**

The table below lists the columns with the associated foreign key.


| Column | Category | FK/Data entity | FK/Column | 
| --- | --- | --- | --- | 
| company\$1id | Organization | company | id | 
| product\$1id | Product | product | id | 
| product\$1group\$1id | Product | product\$1hierarchy | id | 
| customer\$1tpartner\$1id | Organization | trading\$1partner | id | 
| ship\$1from\$1site\$1id, ship\$1to\$1site\$1id | Network | site | id |