You can have several different PIT report. Stock, status, state of an order for one defined dateā¦
The EDW should be structured based on the subject areas in your Enterprise Data Model.