FND Design Data [Home] [Help]

View: RATECI

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
, 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)

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
GEOCITY
CIRECEFFDATE
CIRECTYPE
CIRATE1
CIRATETYPE1
CIRATETAXTYPE1
CIRATEEFFDATE1
CIRATE2
CIRATETYPE2
CIRATETAXTYPE2
CIRATEEFFDATE2
CIRATE3
CIRATETYPE3
CIRATETAXTYPE3
CIRATEEFFDATE3
CIRATE4
CIRATETYPE4
CIRATETAXTYPE4
CIRATEEFFDATE4
CIRATE5
CIRATETYPE5
CIRATETAXTYPE5
CIRATEEFFDATE5
CIRATE6
CIRATETYPE6
CIRATETAXTYPE6
CIRATEEFFDATE6
CIRATE7
CIRATETYPE7
CIRATETAXTYPE7
CIRATEEFFDATE7
CIRATE8
CIRATETYPE8
CIRATETAXTYPE8
CIRATEEFFDATE8
CIINTERSTATE
CIINTRASTATECODE
CITAXBASEAMT
CIOVERRIDE
CIISLOCALADMIN
CIMULTICOUNTY
CIEXTRACITYTAX
CIMAXTAXCODE
CIFILINGCODE
CISERVICETAXDEFAULT
CISERVICEMAXBASEAMT
CIDISTRICTTAXTYPES
CIOVERTAXTYPESFULLCO
CIOVERTAXTYPESFULLST
CIOVERTAXTYPESPARTCO
CIOVERTAXTYPESPARTST