Hello,
Can anyone tell me the DB values for the INPIDetail.Status field? I need to check the status of a Physical Inventory Detail Line in a Generic Inquiry.
Thank you,
Dan Concannon
Answer
DB Values for INPIDetail.Status
+2Best answer by lauraj46
Hi
The values are:
- E (Entered)
- N (Not Entered)
- S (Skipped)
If you don’t have a local install with direct SQL access, you can investigate the database values for a field in a DAC by leaving the Schema Field column empty and entering a formula rather than selecting the field in the dropdown.
Hope this helps!
Laura
+8Hi
The values are:
- E (Entered)
- N (Not Entered)
- S (Skipped)
If you don’t have a local install with direct SQL access, you can investigate the database values for a field in a DAC by leaving the Schema Field column empty and entering a formula rather than selecting the field in the dropdown.
Hope this helps!
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.