Sales Order Line

When a record is deleted in LN, a record with deleted = 1 is stored in the dimension. Records are not removed from the dimension. Sales order lines for a sales order that does not have status Closed and are deleted in LN, are hidden in the degenerate dimension in Birst. Sales order lines of a sales order with status Closed that are deleted when archiving orders, are not hidden and remain available for analysis.

Canceled sales order lines are always hidden.

This table shows the table from which fields are retrieved for the dimension:

Table	Description
tdsls401	Sales Order Lines

This table shows the attribute mapping for the dimension:

Attribute	Mapping
Company	tdsls401_compnr
Customer Requested Delivery Date	tdsls401.ddtc
Delivery Date	tdsls401.dldt
Initial Requested Delivery Date	tdsls401.ddtb
Invoice Date	tdsls401.invd
Order Date	tdsls401.odat
Original Promised Delivery Date	tdsls401.ddtd
Planned Delivery Date	tdsls401.ddta
Planned Receipt Date	tdsls401.prdt
Release Date	tdsls401.rdta
Sales Order	tdsls401.orno
Sales Order Line	tdsls401.pono
Sequence Number	tdsls401.sqnb
deleted	1 if deleted in LN, else 0
Customer Defined Fields	Standard list of fields