Hello. We use Peoplesoft 9.1 and I need to create a query that will show me POs that have/have not been finalized. Can anyone help me find the field that I need to include in a query that shows that information? Thank you!
PURCHASE ORDERS PO_HDR Purchase Order Header - Header Record for Purchase Order PO_LINE Purchase Order Line - Line Record for Purchase Order PO_LINE_DISTRIB PO Line Accounting Entries - Accounting Distribution for Purchase Order PO_LINE_MATCHED PO Line Billed Amounts - Match Information for PO (Voucher, Receipt, PO) PO_APPROVAL Purchase Order Approval - Approval Information for Purchase Order PO_LINE_SHIP PO Line Shipping Schedule - Shipment Details for Purchase Order
Maybe PeopleBooks on Financials has more or better information.