Purchase 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 purchase order that does not have status Closed and is deleted in LN, is hidden in the degenerate dimension in Birst. Purchase orders with status Closed that are deleted when archiving orders, are not hidden and remain available for analysis.

Canceled purchase orders are always hidden.

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

Table	Description
tdpur400	Purchase Orders

This table shows the attribute mapping for the dimension:

Attribute	Mapping
Company	tdpur400_compnr
Purchase Order	tdpur400.orno
Unknown	1 for null records, else 0
deleted	1 if deleted in LN, else 0
Customer Defined Fields	Standard list of fields