Rep_TaxAreaDetailView

Reference No: 25189

(V 02.00.15-00)

Details

The Rep_TaxAreaDetailView can be used to generate custom reports to view the details of Tax Areas defined in the system. The details of the view are given in Table 1.0.

Table 1.0 Column Details for Rep_TaxAreaDetailView

Column Name	Description
TAXAREAIID	Unique IID of Tax Area.
TAXAREAID	Unique ID of Tax Area.
TAXREGIONID	Unique ID of Tax Region.
TAXINTERSECTIID	Unique IID of Tax Intersect.
TAXSCHEDULEIID	Unique IID of the Tax Schedule.
TAXSCHEDULEID	Unique ID of the Tax Schedule.
TYPE	Tax Schedule applicable for different types (city, country, country local and so on).
EFFECTIVEFROM	The date from when this Tax Schedule is effective, as defined in the Effective Date field of the Tax Schedule Details window.
DESCRIPTION	Description of the Tax Area
RATE	The defined Tax Rate for this Tax Area.
MAXAMOUNT	The Maximum Amount defined for Tax Schedule in Tax Schedule Details window.
RESOLVEENDLIMIT	The value selected in the Resolve End field in Tax Schedule Details window. This will be applicable only if the Use Tax Table check box is selected in this window. The possible values are: Loop Back Use Tax Percent Use Last Percent
OVERRUN	Null
COMPOUNDTOID	The Tax Schedule as selected in the Compound To field in Tax Schedule Details window.
TAXTABLEID	Unique ID of the Tax table.
USETAXTABLE	The status of the check box in the Tax Schedule Details window.
GLCODE	The GL CODE, as defined in the Tax Schedule Details window.
ACTIVE	The status of the Tax Region Group which is tagged to this Tax Area, as defined in the Tax Region Group window.