eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: RATECO

Product:	AR - Receivables
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT RATESTATE.GEOSTATE
, RATESTATE.RECEFFDATE STRECEFFDATE
, RATESTATE.STRECTYPE
, RATESTATE.STRATE1
, RATESTATE.STRATETYPE1
, RATESTATE.STRATETAXTYPE1
, RATESTATE.STRATEEFFDATE1
, RATESTATE.STRATE2
, RATESTATE.STRATETYPE2
, RATESTATE.STRATETAXTYPE2
, RATESTATE.STRATEEFFDATE2
, RATESTATE.STRATE3
, RATESTATE.STRATETYPE3
, RATESTATE.STRATETAXTYPE3
, RATESTATE.STRATEEFFDATE3
, RATESTATE.STRATE4
, RATESTATE.STRATETYPE4
, RATESTATE.STRATETAXTYPE4
, RATESTATE.STRATEEFFDATE4
, RATESTATE.STRATE5
, RATESTATE.STRATETYPE5
, RATESTATE.STRATETAXTYPE5
, RATESTATE.STRATEEFFDATE5
, RATESTATE.STINTERSTATE
, RATESTATE.STINTRASTATESALE
, RATESTATE.STINTRASTATERENT
, RATESTATE.STINTRASTATESERV
, RATESTATE.STINTRASTATERULE
, RATESTATE.STRENTLEASETAXTYPE
, RATESTATE.STSERVTRANSINOUT
, RATESTATE.STSERVTRANSOUTIN
, RATESTATE.STSERVICETAXDEFAULT
, RATESTATE.STMAXRULE
, RATESTATE.STROUNDINGRULE
, RATECOUNTY.GEOCOUNTY
, RATECOUNTY.RECEFFDATE CORECEFFDATE
, RATECOUNTY.CORECTYPE
, RATECOUNTY.CORATE1
, RATECOUNTY.CORATETYPE1
, RATECOUNTY.CORATETAXTYPE1
, RATECOUNTY.CORATEEFFDATE1
, RATECOUNTY.CORATE2
, RATECOUNTY.CORATETYPE2
, RATECOUNTY.CORATETAXTYPE2
, RATECOUNTY.CORATEEFFDATE2
, RATECOUNTY.CORATE3
, RATECOUNTY.CORATETYPE3
, RATECOUNTY.CORATETAXTYPE3
, RATECOUNTY.CORATEEFFDATE3
, RATECOUNTY.CORATE4
, RATECOUNTY.CORATETYPE4
, RATECOUNTY.CORATETAXTYPE4
, RATECOUNTY.CORATEEFFDATE4
, RATECOUNTY.CORATE5
, RATECOUNTY.CORATETYPE5
, RATECOUNTY.CORATETAXTYPE5
, RATECOUNTY.CORATEEFFDATE5
, RATECOUNTY.CORATE6
, RATECOUNTY.CORATETYPE6
, RATECOUNTY.CORATETAXTYPE6
, RATECOUNTY.CORATEEFFDATE6
, RATECOUNTY.CORATE7
, RATECOUNTY.CORATETYPE7
, RATECOUNTY.CORATETAXTYPE7
, RATECOUNTY.CORATEEFFDATE7
, RATECOUNTY.COINTERSTATE
, RATECOUNTY.COINTRASTATECODE
, RATECOUNTY.COISLOCALADMIN
, RATECOUNTY.COTAXBASEAMT
, RATECOUNTY.COMAXTAXCODE
, RATECOUNTY.COGSTFLAG
, RATECOUNTY.COFILINGCODE
, RATECOUNTY.COSERVICETAXDEFAULT
, RATECOUNTY.COSERVICEMAXBASEAMT
, RATECOUNTY.CODISTRICTTAXTYPES
FROM RATESTATE
, RATECOUNTY
WHERE (RATESTATE.GEOSTATE = RATECOUNTY.GEOSTATE)

Columns

Name
GEOSTATE
STRECEFFDATE
STRECTYPE
STRATE1
STRATETYPE1
STRATETAXTYPE1
STRATEEFFDATE1
STRATE2
STRATETYPE2
STRATETAXTYPE2
STRATEEFFDATE2
STRATE3
STRATETYPE3
STRATETAXTYPE3
STRATEEFFDATE3
STRATE4
STRATETYPE4
STRATETAXTYPE4
STRATEEFFDATE4
STRATE5
STRATETYPE5
STRATETAXTYPE5
STRATEEFFDATE5
STINTERSTATE
STINTRASTATESALE
STINTRASTATERENT
STINTRASTATESERV
STINTRASTATERULE
STRENTLEASETAXTYPE
STSERVTRANSINOUT
STSERVTRANSOUTIN
STSERVICETAXDEFAULT
STMAXRULE
STROUNDINGRULE
GEOCOUNTY
CORECEFFDATE
CORECTYPE
CORATE1
CORATETYPE1
CORATETAXTYPE1
CORATEEFFDATE1
CORATE2
CORATETYPE2
CORATETAXTYPE2
CORATEEFFDATE2
CORATE3
CORATETYPE3
CORATETAXTYPE3
CORATEEFFDATE3
CORATE4
CORATETYPE4
CORATETAXTYPE4
CORATEEFFDATE4
CORATE5
CORATETYPE5
CORATETAXTYPE5
CORATEEFFDATE5
CORATE6
CORATETYPE6
CORATETAXTYPE6
CORATEEFFDATE6
CORATE7
CORATETYPE7
CORATETAXTYPE7
CORATEEFFDATE7
COINTERSTATE
COINTRASTATECODE
COISLOCALADMIN
COTAXBASEAMT
COMAXTAXCODE
COGSTFLAG
COFILINGCODE
COSERVICETAXDEFAULT
COSERVICEMAXBASEAMT
CODISTRICTTAXTYPES