Invoice Validation
Statuses:
Logical
Sequence:
• Incomplete. An
incomplete invoice is an invoice created from an invoice image that has invalid
or missing data.
• Not Validated. Validation has never
tested the invoice.
• Validated. The
Invoice Validation program has tested and validated the invoice
and it is available
for payment and accounting.
• Needs
Revalidation. Validation has tested the invoice and has applied one or more
holds to the invoice.
Before you can pay the invoice, you must manually release the
holds or resolve the
problems causing the holds, then resubmit Validation.
• Cancelled. You
have cancelled the invoice.
Prepayment
Invoice statuses:
• Available
prepayment. Temporary prepayment that has an amount available to be applied
to an
invoice.
• Fully Applied
prepayment. Temporary prepayment that has been fully applied to one or more
invoices.
• Unpaid
prepayment. Prepayment that is not yet paid.
• Unvalidated
prepayment. Prepayment has not been validated.
• Permanent
prepayment. Permanent prepayment that has been fully paid.
How to implement this as a query in oracle fusion?
ReplyDelete