HMCSOSTraining_AP02                                Show Active Out of State Vendors with Invoices                                                                                                                                                                                                                 Accounts Payable                                  McsosTrainingFY0506.dbo.viwRTVendors.RemitState <> 'AZ'  
 AND
McsosTrainingFY0506.dbo.viwRTVendors.IsActive <> 0  
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
DMCSOSTraining_AP02                                viwRTVendors                                                                                                                                                                                                                                                   RemitName                                                                                                                                                                                                                                                      RemitName                                                                                           00000000010000000000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
DMCSOSTraining_AP02                                viwRTVendors                                                                                                                                                                                                                                                   UseTaxFlag                                                                                                                                                                                                                                                     UseTaxFlag                                                                                          00000000020000000000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
DMCSOSTraining_AP02                                viwRTVendors                                                                                                                                                                                                                                                   RemitState                                                                                                                                                                                                                                                     RemitState                                                                                          00000000030000000000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
DMCSOSTraining_AP02                                viwRTRequisitions                                                                                                                                                                                                                                              TotalAmt                                                                                                                                                                                                                                                       TotalAmt                                                                                            00000000040000000000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
DMCSOSTraining_AP02                                viwRTRequisitions                                                                                                                                                                                                                                              TotalPaid                                                                                                                                                                                                                                                      TotalPaid                                                                                           00000000050000000000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
DMCSOSTraining_AP02                                viwRTRequisitions                                                                                                                                                                                                                                              TotalUseTax                                                                                                                                                                                                                                                    TotalUseTax                                                                                         00000000060000000000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
DMCSOSTraining_AP02                                viwRTRequisitions                                                                                                                                                                                                                                              TotalStTax                                                                                                                                                                                                                                                     TotalStTax                                                                                          00000000070000000000