outbound_order_line - AWS Supply Chain

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