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