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: AP_TAX_CODES_V

Product:	AP - Payables
Description:	(Release 10SC Only)
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ATC.ROWID ROW_ID
, ATC.ATTRIBUTE1 ATTRIBUTE1
, ATC.ATTRIBUTE10 ATTRIBUTE10
, ATC.ATTRIBUTE11 ATTRIBUTE11
, ATC.ATTRIBUTE12 ATTRIBUTE12
, ATC.ATTRIBUTE13 ATTRIBUTE13
, ATC.ATTRIBUTE14 ATTRIBUTE14
, ATC.ATTRIBUTE15 ATTRIBUTE15
, ATC.ATTRIBUTE2 ATTRIBUTE2
, ATC.ATTRIBUTE3 ATTRIBUTE3
, ATC.ATTRIBUTE4 ATTRIBUTE4
, ATC.ATTRIBUTE5 ATTRIBUTE5
, ATC.ATTRIBUTE6 ATTRIBUTE6
, ATC.ATTRIBUTE7 ATTRIBUTE7
, ATC.ATTRIBUTE8 ATTRIBUTE8
, ATC.ATTRIBUTE9 ATTRIBUTE9
, ATC.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATC.AWT_PERIOD_LIMIT AWT_PERIOD_LIMIT
, ATC.AWT_PERIOD_TYPE AWT_PERIOD_TYPE
, ATC.AWT_VENDOR_ID AWT_VENDOR_ID
, ATC.AWT_VENDOR_SITE_ID AWT_VENDOR_SITE_ID
, ATC.CREATED_BY CREATED_BY
, ATC.CREATION_DATE CREATION_DATE
, ATC.DESCRIPTION DESCRIPTION
, ATC.INACTIVE_DATE INACTIVE_DATE
, ATC.LAST_UPDATED_BY LAST_UPDATED_BY
, ATC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ATC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ATC.NAME NAME
, ATC.RANGE_AMOUNT_BASIS RANGE_AMOUNT_BASIS
, ATC.RANGE_PERIOD_BASIS RANGE_PERIOD_BASIS
, ATC.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ATC.TAX_CODE_COMBINATION_ID TAX_CODE_COMBINATION_ID
, ATC.TAX_RATE TAX_RATE
, ATC.TAX_TYPE TAX_TYPE
, ATC.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, ATC.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, ATC.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, ATC.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, ATC.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, ATC.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, ATC.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, ATC.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, ATC.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, ATC.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, ATC.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, ATC.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, ATC.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, ATC.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, ATC.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, ATC.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, ATC.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, ATC.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, ATC.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, ATC.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, ATC.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, ATC.TAX_ID
, ATC.START_DATE
, ATC.ENABLED_FLAG
, ATC.AWT_RATE_TYPE
FROM AP_TAX_CODES ATC

Columns

Name
ROW_ID
ATTRIBUTE1
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE_CATEGORY
AWT_PERIOD_LIMIT
AWT_PERIOD_TYPE
AWT_VENDOR_ID
AWT_VENDOR_SITE_ID
CREATED_BY
CREATION_DATE
DESCRIPTION
INACTIVE_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
NAME
RANGE_AMOUNT_BASIS
RANGE_PERIOD_BASIS
SET_OF_BOOKS_ID
TAX_CODE_COMBINATION_ID
TAX_RATE
TAX_TYPE
GLOBAL_ATTRIBUTE_CATEGORY
GLOBAL_ATTRIBUTE1
GLOBAL_ATTRIBUTE2
GLOBAL_ATTRIBUTE3
GLOBAL_ATTRIBUTE4
GLOBAL_ATTRIBUTE5
GLOBAL_ATTRIBUTE6
GLOBAL_ATTRIBUTE7
GLOBAL_ATTRIBUTE8
GLOBAL_ATTRIBUTE9
GLOBAL_ATTRIBUTE10
GLOBAL_ATTRIBUTE11
GLOBAL_ATTRIBUTE12
GLOBAL_ATTRIBUTE13
GLOBAL_ATTRIBUTE14
GLOBAL_ATTRIBUTE15
GLOBAL_ATTRIBUTE16
GLOBAL_ATTRIBUTE17
GLOBAL_ATTRIBUTE18
GLOBAL_ATTRIBUTE19
GLOBAL_ATTRIBUTE20
TAX_ID
START_DATE
ENABLED_FLAG
AWT_RATE_TYPE