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: AR.AR_TAX_INTERFACE#

Source

View Text - Preformatted


select REQUEST_ID REQUEST_ID, INTERFACE_LINE_ID INTERFACE_LINE_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, SEGMENT_QUALIFIER SEGMENT_QUALIFIER, RATE_TYPE RATE_TYPE, LOCATION_ID LOCATION_ID, LOCATION_VALUE LOCATION_VALUE, LOCATION_DESCRIPTION LOCATION_DESCRIPTION, PARENT_LOCATION_ID PARENT_LOCATION_ID, FROM_POSTAL_CODE FROM_POSTAL_CODE, TO_POSTAL_CODE TO_POSTAL_CODE, START_DATE START_DATE, END_DATE END_DATE, TAX_RATE TAX_RATE, CHANGE_FLAG CHANGE_FLAG, STATUS STATUS, ERROR_MESSAGE ERROR_MESSAGE, OVERRIDE_CONTROL OVERRIDE_CONTROL, LOCATION_SEGMENT_ID LOCATION_SEGMENT_ID, LOCATION_ATTRIBUTE_CATEGORY LOCATION_ATTRIBUTE_CATEGORY, LOCATION_ATTRIBUTE1 LOCATION_ATTRIBUTE1, LOCATION_ATTRIBUTE2 LOCATION_ATTRIBUTE2, LOCATION_ATTRIBUTE3 LOCATION_ATTRIBUTE3, LOCATION_ATTRIBUTE4 LOCATION_ATTRIBUTE4, LOCATION_ATTRIBUTE5 LOCATION_ATTRIBUTE5, LOCATION_ATTRIBUTE6 LOCATION_ATTRIBUTE6, LOCATION_ATTRIBUTE7 LOCATION_ATTRIBUTE7, LOCATION_ATTRIBUTE8 LOCATION_ATTRIBUTE8, LOCATION_ATTRIBUTE9 LOCATION_ATTRIBUTE9, LOCATION_ATTRIBUTE10 LOCATION_ATTRIBUTE10, LOCATION_ATTRIBUTE11 LOCATION_ATTRIBUTE11, LOCATION_ATTRIBUTE12 LOCATION_ATTRIBUTE12, LOCATION_ATTRIBUTE13 LOCATION_ATTRIBUTE13, LOCATION_ATTRIBUTE14 LOCATION_ATTRIBUTE14, LOCATION_ATTRIBUTE15 LOCATION_ATTRIBUTE15, RATE_ATTRIBUTE_CATEGORY RATE_ATTRIBUTE_CATEGORY, RATE_ATTRIBUTE1 RATE_ATTRIBUTE1, RATE_ATTRIBUTE2 RATE_ATTRIBUTE2, RATE_ATTRIBUTE3 RATE_ATTRIBUTE3, RATE_ATTRIBUTE4 RATE_ATTRIBUTE4, RATE_ATTRIBUTE5 RATE_ATTRIBUTE5, RATE_ATTRIBUTE6 RATE_ATTRIBUTE6, RATE_ATTRIBUTE7 RATE_ATTRIBUTE7, RATE_ATTRIBUTE8 RATE_ATTRIBUTE8, RATE_ATTRIBUTE9 RATE_ATTRIBUTE9, RATE_ATTRIBUTE10 RATE_ATTRIBUTE10, RATE_ATTRIBUTE11 RATE_ATTRIBUTE11, RATE_ATTRIBUTE12 RATE_ATTRIBUTE12, RATE_ATTRIBUTE13 RATE_ATTRIBUTE13, RATE_ATTRIBUTE14 RATE_ATTRIBUTE14, RATE_ATTRIBUTE15 RATE_ATTRIBUTE15, OVERRIDE_STRUCTURE_ID OVERRIDE_STRUCTURE_ID, OVERRIDE_RATE1 OVERRIDE_RATE1, OVERRIDE_RATE2 OVERRIDE_RATE2, OVERRIDE_RATE3 OVERRIDE_RATE3, OVERRIDE_RATE4 OVERRIDE_RATE4, OVERRIDE_RATE5 OVERRIDE_RATE5, OVERRIDE_RATE6 OVERRIDE_RATE6, OVERRIDE_RATE7 OVERRIDE_RATE7, OVERRIDE_RATE8 OVERRIDE_RATE8, OVERRIDE_RATE9 OVERRIDE_RATE9, OVERRIDE_RATE10 OVERRIDE_RATE10, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID from "AR"."AR_TAX_INTERFACE"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, INTERFACE_LINE_ID INTERFACE_LINE_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, SEGMENT_QUALIFIER SEGMENT_QUALIFIER
, RATE_TYPE RATE_TYPE
, LOCATION_ID LOCATION_ID
, LOCATION_VALUE LOCATION_VALUE
, LOCATION_DESCRIPTION LOCATION_DESCRIPTION
, PARENT_LOCATION_ID PARENT_LOCATION_ID
, FROM_POSTAL_CODE FROM_POSTAL_CODE
, TO_POSTAL_CODE TO_POSTAL_CODE
, START_DATE START_DATE
, END_DATE END_DATE
, TAX_RATE TAX_RATE
, CHANGE_FLAG CHANGE_FLAG
, STATUS STATUS
, ERROR_MESSAGE ERROR_MESSAGE
, OVERRIDE_CONTROL OVERRIDE_CONTROL
, LOCATION_SEGMENT_ID LOCATION_SEGMENT_ID
, LOCATION_ATTRIBUTE_CATEGORY LOCATION_ATTRIBUTE_CATEGORY
, LOCATION_ATTRIBUTE1 LOCATION_ATTRIBUTE1
, LOCATION_ATTRIBUTE2 LOCATION_ATTRIBUTE2
, LOCATION_ATTRIBUTE3 LOCATION_ATTRIBUTE3
, LOCATION_ATTRIBUTE4 LOCATION_ATTRIBUTE4
, LOCATION_ATTRIBUTE5 LOCATION_ATTRIBUTE5
, LOCATION_ATTRIBUTE6 LOCATION_ATTRIBUTE6
, LOCATION_ATTRIBUTE7 LOCATION_ATTRIBUTE7
, LOCATION_ATTRIBUTE8 LOCATION_ATTRIBUTE8
, LOCATION_ATTRIBUTE9 LOCATION_ATTRIBUTE9
, LOCATION_ATTRIBUTE10 LOCATION_ATTRIBUTE10
, LOCATION_ATTRIBUTE11 LOCATION_ATTRIBUTE11
, LOCATION_ATTRIBUTE12 LOCATION_ATTRIBUTE12
, LOCATION_ATTRIBUTE13 LOCATION_ATTRIBUTE13
, LOCATION_ATTRIBUTE14 LOCATION_ATTRIBUTE14
, LOCATION_ATTRIBUTE15 LOCATION_ATTRIBUTE15
, RATE_ATTRIBUTE_CATEGORY RATE_ATTRIBUTE_CATEGORY
, RATE_ATTRIBUTE1 RATE_ATTRIBUTE1
, RATE_ATTRIBUTE2 RATE_ATTRIBUTE2
, RATE_ATTRIBUTE3 RATE_ATTRIBUTE3
, RATE_ATTRIBUTE4 RATE_ATTRIBUTE4
, RATE_ATTRIBUTE5 RATE_ATTRIBUTE5
, RATE_ATTRIBUTE6 RATE_ATTRIBUTE6
, RATE_ATTRIBUTE7 RATE_ATTRIBUTE7
, RATE_ATTRIBUTE8 RATE_ATTRIBUTE8
, RATE_ATTRIBUTE9 RATE_ATTRIBUTE9
, RATE_ATTRIBUTE10 RATE_ATTRIBUTE10
, RATE_ATTRIBUTE11 RATE_ATTRIBUTE11
, RATE_ATTRIBUTE12 RATE_ATTRIBUTE12
, RATE_ATTRIBUTE13 RATE_ATTRIBUTE13
, RATE_ATTRIBUTE14 RATE_ATTRIBUTE14
, RATE_ATTRIBUTE15 RATE_ATTRIBUTE15
, OVERRIDE_STRUCTURE_ID OVERRIDE_STRUCTURE_ID
, OVERRIDE_RATE1 OVERRIDE_RATE1
, OVERRIDE_RATE2 OVERRIDE_RATE2
, OVERRIDE_RATE3 OVERRIDE_RATE3
, OVERRIDE_RATE4 OVERRIDE_RATE4
, OVERRIDE_RATE5 OVERRIDE_RATE5
, OVERRIDE_RATE6 OVERRIDE_RATE6
, OVERRIDE_RATE7 OVERRIDE_RATE7
, OVERRIDE_RATE8 OVERRIDE_RATE8
, OVERRIDE_RATE9 OVERRIDE_RATE9
, OVERRIDE_RATE10 OVERRIDE_RATE10
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
FROM "AR"."AR_TAX_INTERFACE"