Sales Order

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

Canceled sales orders are always hidden.

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

Table	Description
tdsls400	Sales Orders

This table shows the attribute mapping for the dimension:

Attribute	Mapping
Company	tdsls400_compnr
Goods Acceptance Date	tdsls400.acdt
Order Confirmation Date	tdsls400.cfdt
Order Discount	tdsls400.disc
Sales Order	tdsls400.orno
Unknown	1 for null records, else 0
deleted	1 if deleted in LN, else 0
Customer Defined Fields	Standard list of fields