HMCSOSTraining_AP01                                Show Active Out of State Vendors                                                                                                                                                                                                                               Accounts Payable                                  McsosTrainingFY0506.dbo.viwRTVendors.RemitState <> 'AZ'  
 AND
McsosTrainingFY0506.dbo.viwRTVendors.IsActive <> 0  
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
DMCSOSTraining_AP01                                viwRTVendors                                                                                                                                                                                                                                                   RemitName                                                                                                                                                                                                                                                      RemitName                                                                                           00000000010000000000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
DMCSOSTraining_AP01                                viwRTVendors                                                                                                                                                                                                                                                   UseTaxFlag                                                                                                                                                                                                                                                     UseTaxFlag                                                                                          00000000020000000000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
DMCSOSTraining_AP01                                viwRTVendors                                                                                                                                                                                                                                                   RemitState                                                                                                                                                                                                                                                     RemitState                                                                                          00000000030000000000