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

Canceled purchase order lines are always hidden.

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

Table	Description
tdpur401	Purchase Order Lines

This table shows the attribute mapping for the dimension:

Attribute	Mapping
Actual Receipt Date	tdpur401.ddte
Changed Receipt Date	tdpur401.ddtd
Company	tdpur401_compnr
Confirmed Receipt Date	tdpur401.ddtc
Current Planned Receipt Date	tdpur401.ddtb
Order Confirmation Date	tdpur401.ddtf
Order Date	tdpur401.odat
Planned Load Date	tdpur401.ldat
Planned Receipt Date	tdpur401.ddta
Purchase Order	tdpur401.orno
Purchase Order Line	tdpur401.pono
Release Date	tdpur401.rdta
Sequence Number	tdpur401.sqnb
deleted	1 if deleted in LN, else 0
Customer Defined Fields	Standard list of fields