《tracking - arizona state university跟踪-亚利桑那州国家大学》由会员分享，可在线阅读，更多相关《tracking - arizona state university跟踪-亚利桑那州国家大学（76页珍藏版）》请在金锄头文库上搜索。
1、ADVANTAGETable Look UpsArizona State UniversityComptrollers Office10/1/98ContentsOpen Document Table Updating1Accessing Open Tables from the Custom Desktop2Navigating Open Tables5Maximizing Windows6Looking Up Internal Purchase Orders7OPOH- Open PO Header Table8OPOL- Open PO Line Table10OPOD- Open PO
2、 Header by Document Inquiry11Looking Up Off-Campus Order Documents (PC, PD, and SC)By Document ID12OPHD- Open PC/PD/SC Header by Document Inquiry13OPLD- Open PC/PD/SC Accounting Line by Document Inquiry16OPCD- Open PC/PD/SC Commodity Line by Document Inquiry17OPPD- Open PC/PD/SC by Document Number20
3、By Vendor ID21OPPH- Open PC/PD/SC Header by Vendor22OPPL- Open PC/PD/SC Line Table24OPPC- Open PC/PD/SC Commodity Table25By Agency/Org26OPIV- Open PC/PD/SC by Agency Org and Vendor Inquiry27Looking Up Off-Campus Order Modification Documents29MPPH- Open PC/PD/SC Header Modification Inquiry30MPPL- Ope
4、n PC/PD/SC Account Line Modification Inquiry32MPPC- Open PC/PD/SC Commodity Line Modification Inquiry33Looking Up Payment Voucher (PV) Documents34OPVD- Open Payment Voucher by Document Number Inquiry35OPVH- Open Payment Voucher Header Table37OPVL- Open Payment Voucher Line (1 of 2)38OPV2- Open Payme
5、nt Voucher Line (2 of 2)40Looking Up Receiver (RC) Documents41ORCH- Open Receiver Header Table42ORCL- Open Receiver Accounting Line Table44Looking Up Requisition (RX) Documents45ORQH- Open RX Header Table46ORQL- Open RX Account Line Table49ORQC- Open RX Commodity Line Table50RQST- Requisition Status
6、 Table51RSTA- Requisition Status Code Table53Looking Up ASU Stores Stock Requisition (SR) Documents54OSRH- Open Stock Requisition Header Inquiry55OSRL- Open Stock Requisition Account Line Inquiry57OSRC- Open Stock Requisition Line Inquiry58OSRI- Open Stock Requisition Items Issue Inquiry59Looking Up
7、 Vendor Invoice (VI) Documents60OVIH- Open Vendor Invoice Header61OVIL- Open Vendor Invoice Line64Looking Up Check Status65OPCH- Open Check Header66OPCL- Open Check Line68Document History Tables69DXRF- Document Cross-Reference70DHIS- Document History72RQST- Requisition Status Table73Open Document Ta
8、ble UpdatingDOCUMENTSTABLESPOOPODOpen PO by Document InquiryOPOHOpen PO Header TableOPOLOpen PO Line TablePC, PD, SCS(by Document ID)OPHDOpen PC Header by Document InquiryOPLDOpen PC Account Line by Document InquiryOPCDOpen PC Commodity Line by Document InquiryOPPDOpen PC by Document NumberPC, PD, S
9、CS(by Vendor ID)OPPHOpen PC Header by VendorOPPLOpen PC Line TableOPPCOpen PC Commodity TableOPIVOpen PC by Agency Org and Vendor InquiryPVOPVDOpen Payment Voucher Header by Doc NumberOPVHOpen Payment Voucher HeaderOPVLOpen Payment Voucher Line (1 of 2)OPV2Open Payment Voucher Line (2 of 2)RCORCHOpe
10、n Receiver Header TableORCLOpen Receiver Line TableRXORQHOpen RX Header TableORQLOpen RX Line TableORQCOpen RX Commodity TableRQSTRequisition Status TableSROSRHOpen Stores Requisition Header InquiryOSRLOpen Stores Requisition Account Line InquiryOSRCOpen Stores Requisition Line InquiryOSRIOpen Store
11、s Requisition Items Issue InquiryVIOVIHOpen Vendor Invoice HeaderOVILOpen Vendor Invoice LineAD & MWOPCHOpen Check HeaderOPCLOpen Check LineALL DOCUMENTSDXRFDocument Cross Reference Table DHISDocument History Detail TableThe above tables update immediately except for the DXRF and DHIS tables, which
12、update during nightly processing. All documents that are accepted into Advantage appear on Monthly Reports after month-end close.Open Tables 10/1/9874Accessing Open Tables from the Custom DesktopOne of the features of the Custom Desktop in Advantage is a drop-down menu that allows you to access the
13、Open Tables for a specific series of documents. To access the Open Tables Window from the Custom Desktop: Click on the Business Area drop-down menu. Select Open Tables.The Open Tables WindowThe Open Tables window will appear. From this window, you can select the series of Open Tables which contain i
14、nformation on the type of document you wish to view. Click on the button that corresponds to Open Tables for the type of document you wish to view. Refer to the chart on the next page for a detailed listing of the tables linked to each button on this screen.The following chart illustrates the tables
15、 you can access by clicking on a particular button:Clicking this button:Allows you to access these tables:Clicking this button:Allows you to access these tables:The Suspense File.OPIVDXRF, DHIS, and RQSTMPPH, MPPL, and MPPCOPOH, OPOL, and OPODOPVD, OPVH, OPVL, and OPV2ORQH, ORQL, ORQC, RQST, and RSTAOVIH and OVILORCH and ORCL
