Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
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
, RATECITY.GEOCITY
, RATECITY.RECEFFDATE CIRECEFFDATE
, RATECITY.CIRECTYPE
, RATECITY.CIRATE1
, RATECITY.CIRATETYPE1
, RATECITY.CIRATETAXTYPE1
, RATECITY.CIRATEEFFDATE1
, RATECITY.CIRATE2
, RATECITY.CIRATETYPE2
, RATECITY.CIRATETAXTYPE2
, RATECITY.CIRATEEFFDATE2
, RATECITY.CIRATE3
, RATECITY.CIRATETYPE3
, RATECITY.CIRATETAXTYPE3
, RATECITY.CIRATEEFFDATE3
, RATECITY.CIRATE4
, RATECITY.CIRATETYPE4
, RATECITY.CIRATETAXTYPE4
, RATECITY.CIRATEEFFDATE4
, RATECITY.CIRATE5
, RATECITY.CIRATETYPE5
, RATECITY.CIRATETAXTYPE5
, RATECITY.CIRATEEFFDATE5
, RATECITY.CIRATE6
, RATECITY.CIRATETYPE6
, RATECITY.CIRATETAXTYPE6
, RATECITY.CIRATEEFFDATE6
, RATECITY.CIRATE7
, RATECITY.CIRATETYPE7
, RATECITY.CIRATETAXTYPE7
, RATECITY.CIRATEEFFDATE7
, RATECITY.CIRATE8
, RATECITY.CIRATETYPE8
, RATECITY.CIRATETAXTYPE8
, RATECITY.CIRATEEFFDATE8
, RATECITY.CIINTERSTATE
, RATECITY.CIINTRASTATECODE
, RATECITY.CITAXBASEAMT
, RATECITY.CIOVERRIDE
, RATECITY.CIISLOCALADMIN
, RATECITY.CIMULTICOUNTY
, RATECITY.CIEXTRACITYTAX
, RATECITY.CIMAXTAXCODE
, RATECITY.CIFILINGCODE
, RATECITY.CISERVICETAXDEFAULT
, RATECITY.CISERVICEMAXBASEAMT
, RATECITY.CIDISTRICTTAXTYPES
, RATECITY.CIOVERTAXTYPESFULLCO
, RATECITY.CIOVERTAXTYPESFULLST
, RATECITY.CIOVERTAXTYPESPARTCO
, RATECITY.CIOVERTAXTYPESPARTST
FROM RATESTATE
, RATECOUNTY
, RATECITY
WHERE (RATESTATE.GEOSTATE = RATECOUNTY.GEOSTATE)
AND (RATECOUNTY.GEOSTATE = RATECITY.GEOSTATE)
AND (RATECOUNTY.GEOCOUNTY = RATECITY.GEOCOUNTY)