Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

What does the respective value of the APPROVAL_STATUS field in AP_INVOICES_ALL table mean?

Summary:

Hi,

To my best knowledge, The 'APPROVAL_STATUS' field in 'AP_INVOICES_ALL' table refers to validation status.

In BI, Running the bleow query retrieves the records below

Query :
SELECT APPROVAL_STATUS
FROM AP_INVOICES_ALL
GROUP BY APPROVAL_STATUS

Records retrieved :
CANCELLED
NEVER APPROVED
UNPAID
APPROVED
AVAILABLE
FULL
INCOMPLETE
PERMANENT
NEEDS REAPPROVAL

From the KM Note, I've learded the meanings for a couple of status as follows

APPROVED - Validated
NEVER APPROVED - Not Validated
NEEDS REAPPROVAL - Needs revalidation

But, I was wondering what the all the status above mean respectively

CANCELLED
NEVER APPROVED
UNPAID
APPROVED
AVAILABLE

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!