I'm looking at the PurchTable table via Data Lake and can see a field "PurchStatus". The old Purchase Order Header entity has the text description of the PO status, but the table itself only has an integer in each record "PurchStatus" field. I'm having a wild guess that:
1 = Open Order2 = Received3 = Invoiced4 = Cancelled
but can't find a reference to check i'm correct. Any ideas?
Ian W.
This is the enum value you need.
Magic. Thank you.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,167
André Arnaud de Cal... 867 Super User 2025 Season 2
Sohaib Cheema 617 User Group Leader