13 Aug 2011

Purchase Order Authorization Status





There are 8 authorization status that a purchase order can have. The table below lists all the statuses along with their meanings.





You can use the query below to see the information listed in the table above :

SELECT lookup_code, displayed_field, description
  FROM po_lookup_codes
 WHERE lookup_type = 'AUTHORIZATION STATUS';


select authorization_status from po_headers_all pha where 1=1;


 LOOKUP CODE  DISPLAYED FIELD  DESCRIPTION
APPROVED Approved Document has been Approved
CANCELLED Cancelled Document has been Cancelled
IN PROCESS In Process Document is still undergoing Approval
INCOMPLETE Incomplete Document is not yet Complete
PRE-APPROVED Pre-Approved Document is Approved but not yet Accepted
REJECTED Rejected Document as been Rejected
REQUIRES REAPPROVAL Requires Reapproval Requires Reapproval
RETURNED Returned Document has been Returned

No comments:

Post a Comment