[Home] [Help] [Dependency Information]
Object Name: | AR_TRX_TAX_L_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AR.AR_TRX_TAX_L_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TAX_LOC_ADJ_CCID | NUMBER | (15) | Code combination ID of the accounting flexfield for the expense/revenue account for adjustments | |
TAX_LOC_ADJ_NON_REC_TAX_CCID | NUMBER | (15) | Code combination ID of the accounting flexfield for the non-recoverable tax account for adjustments | |
TAX_LOC_EDISC_CCID | NUMBER | (15) | Code combination ID of the accounting flexfield for the expense account for earned discounts | |
TAX_LOC_EDISC_NON_REC_TAX_CCID | NUMBER | (15) | Code combination ID of the accounting flexfield for the non-recoverable tax account for earned discounts | |
TAX_LOC_FCHRG_CCID | NUMBER | (15) | Code combination ID of the accounting flexfield for the revenue account for finance charges | |
TAX_LOC_FCHRG_NON_REC_TAX_CCID | NUMBER | (15) | Code combination ID of the accounting flexfield for the non-recoverable tax account for finance charges | |
TAX_LOC_INTERIM_TAX_CCID | NUMBER | (15) | Code combination ID of the accounting flexfield for the deferred tax account | |
TAX_LOC_TAX_ACCOUNT_CCID | NUMBER | (15) | Code combination ID for the tax account | |
TAX_LOC_UNED_CCID | NUMBER | (15) | Code combination ID of the accounting flexfield for the expense account for unearned discounts | |
TAX_LOC_UNED_NON_REC_TAX_CCID | NUMBER | (15) | Code combination ID of the accounting flexfield for the non-recoverable tax account for unearned discounts | |
SALES_TAX_FROM_POSTAL_CODE | VARCHAR2 | (30) | Low range of a postal code that this rate is active for against this location | |
SALES_TAX_ID | NUMBER | (15) | Internal primary key that is populated from the AR_SALES_TAX_S sequence, used as a foreign key in the RA_CUSTOMER_TRX_LINES table | |
SALES_TAX_RATE | NUMBER | Compiled sales tax rate, sum of every tax rate, taking into account overrides, for each segment of your structure | ||
SALES_TAX_TO_POSTAL_CODE | VARCHAR2 | (30) | High range of a postal code that this rate is active for against this location | |
TAX_EXEMPTION_NUMBER | VARCHAR2 | (80) | Exemption certificate number | |
TAX_EXEMPTION_TYPE | VARCHAR2 | (30) | Exemptions can be for customers at a location, or for items at a location, but not for customers and items at a location. | |
TAX_EXEMPTION_PERCENT_EXEMPT | NUMBER | Percentage that is exempt from tax. 100% means that this is a full exemption from tax. | ||
TAX_EXEMPTION_REASON_CODE | VARCHAR2 | (30) | The reason for this exemption | |
TAX_EXEMPTION_STATUS | VARCHAR2 | (30) | Approval status for this exemption | |
TAX_CODE_EXEMPTED | VARCHAR2 | (50) | Tax code that this exemption applies to | |
TAX_EXEMPTION_ID | NUMBER | (15) | Internal exemption identifier | |
VAT_TAX_ADJ_CCID | NUMBER | (15) | Code combination identifier of accounting flexfield for expense or revenue account for adjustments | |
VAT_TAX_ADJ_NON_REC_TAX_CCID | NUMBER | (15) | Code combination identifier of accounting flexfield for non-recoverable tax account for adjustments | |
VAT_TAX_DESCRIPTION | VARCHAR2 | (60) | Description of tax code, for Italian legal requirement | |
VAT_TAX_EDISC_CCID | NUMBER | (15) | Code combination identifier of accounting flexfield for expense account for earned discounts | |
VAT_TAX_EDISC_NON_REC_TAX_CCID | NUMBER | (15) | Code combination identifier of accounting flexfield for non-recoverable tax account for earned discounts | |
VAT_TAX_FCHRG_CCID | NUMBER | (15) | Code combination identifier of accounting flexfield for revenue account for finance charges | |
VAT_TAX_FCHRG_NON_REC_TAX_CCID | NUMBER | (15) | Code combination identifier of accounting flexfield for non-recoverable tax account for finance charges | |
VAT_TAX_INTERIM_TAX_CCID | NUMBER | (15) | Code combination identifier of accounting flexfield for deferred tax account | |
VAT_TAX_TAXABLE_BASIS | VARCHAR2 | (30) | AR_TAXABLE_BASIS lookup type for determining taxable amount | |
VAT_TAX_TAX_ACCOUNT_ID | NUMBER | (15) | Code combination identifier of accounting flexfield that tax should be posted to | |
VAT_TAX_TAX_CLASS | VARCHAR2 | (1) | Input for tax codes on purchase transactions or output for tax codes on sales transactions | |
VAT_TAX_TAX_CODE | VARCHAR2 | (50) | The tax code associated with a rate user specified in the Tax Codes and Rates window | |
VAT_TAX_TAX_RATE | NUMBER | The tax rate associated with the tax code the user specified in the Tax Codes and Rates window | ||
VAT_TAX_TAX_TYPE | VARCHAR2 | (30) | Lookup column that uses the TAX_TYPE lookup type | |
VAT_TAX_UNED_CCID | NUMBER | (15) | Code combination identifier of accounting flexfield for expense account for unearned discounts | |
VAT_TAX_UNED_NON_REC_TAX_CCID | NUMBER | (15) | Code combination identifier of accounting flexfield for non-recoverable tax account for unearned discounts | |
VAT_TAX_VAT_TAX_ID | NUMBER | (15) | Unique identifier | |
VAT_CODE_DESCRIPTION | VARCHAR2 | (60) | Description of tax code, for Italian legal requirement | |
VAT_TAXABLE_BASIS | VARCHAR2 | (30) | AR_TAXABLE_BASIS lookup type for determining taxable amount | |
VAT_TAX_ACCOUNT_ID | NUMBER | (15) | Code combination identifier of accounting flexfield that tax should be posted to | |
VAT_TAX_CLASS | VARCHAR2 | (1) | Input for tax codes on purchase transactions or output for tax codes on sales transactions | |
VAT_TAX_CODE | VARCHAR2 | (50) | The tax code associated with a rate user specified in the Tax Codes and Rates window | |
VAT_TAX_GLOBAL_ATTR1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
VAT_TAX_GLOBAL_ATTR2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
VAT_TAX_GLOBAL_ATTR3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
VAT_TAX_GLOBAL_ATTR4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
VAT_TAX_GLOBAL_ATTR5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
VAT_TAX_GLOBAL_ATTR6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
VAT_TAX_GLOBAL_ATTR7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
VAT_TAX_GLOBAL_ATTR_CAT | VARCHAR2 | (30) | Reserved for country-specific functionality | |
VAT_TAX_ID | NUMBER | (15) | Unique identifier | |
VAT_TAX_RATE | NUMBER | The tax rate associated with the tax code the user specified in the Tax Codes and Rates window | ||
VAT_TAX_TRX_TYPE | VARCHAR2 | (30) | VAT transaction type | |
VAT_TAX_TYPE | VARCHAR2 | (30) | Lookup column that uses the TAX_TYPE lookup type | |
TAX_LOC_VALUE_ACCT_ID | NUMBER | (15) | Primary key of the table | |
EVENT_ID | NUMBER | (15) | ||
LINE_NUMBER | NUMBER | (15) | ||
LANGUAGE | VARCHAR2 | (20) | ||
LEDGER_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT TAX_LOC_ADJ_CCID
, TAX_LOC_ADJ_NON_REC_TAX_CCID
, TAX_LOC_EDISC_CCID
, TAX_LOC_EDISC_NON_REC_TAX_CCID
, TAX_LOC_FCHRG_CCID
, TAX_LOC_FCHRG_NON_REC_TAX_CCID
, TAX_LOC_INTERIM_TAX_CCID
, TAX_LOC_TAX_ACCOUNT_CCID
, TAX_LOC_UNED_CCID
, TAX_LOC_UNED_NON_REC_TAX_CCID
, SALES_TAX_FROM_POSTAL_CODE
, SALES_TAX_ID
, SALES_TAX_RATE
, SALES_TAX_TO_POSTAL_CODE
, TAX_EXEMPTION_NUMBER
, TAX_EXEMPTION_TYPE
, TAX_EXEMPTION_PERCENT_EXEMPT
, TAX_EXEMPTION_REASON_CODE
, TAX_EXEMPTION_STATUS
, TAX_CODE_EXEMPTED
, TAX_EXEMPTION_ID
, VAT_TAX_ADJ_CCID
, VAT_TAX_ADJ_NON_REC_TAX_CCID
, VAT_TAX_DESCRIPTION
, VAT_TAX_EDISC_CCID
, VAT_TAX_EDISC_NON_REC_TAX_CCID
, VAT_TAX_FCHRG_CCID
, VAT_TAX_FCHRG_NON_REC_TAX_CCID
, VAT_TAX_INTERIM_TAX_CCID
, VAT_TAX_TAXABLE_BASIS
, VAT_TAX_TAX_ACCOUNT_ID
, VAT_TAX_TAX_CLASS
, VAT_TAX_TAX_CODE
, VAT_TAX_TAX_RATE
, VAT_TAX_TAX_TYPE
, VAT_TAX_UNED_CCID
, VAT_TAX_UNED_NON_REC_TAX_CCID
, VAT_TAX_VAT_TAX_ID
, VAT_CODE_DESCRIPTION
, VAT_TAXABLE_BASIS
, VAT_TAX_ACCOUNT_ID
, VAT_TAX_CLASS
, VAT_TAX_CODE
, VAT_TAX_GLOBAL_ATTR1
, VAT_TAX_GLOBAL_ATTR2
, VAT_TAX_GLOBAL_ATTR3
, VAT_TAX_GLOBAL_ATTR4
, VAT_TAX_GLOBAL_ATTR5
, VAT_TAX_GLOBAL_ATTR6
, VAT_TAX_GLOBAL_ATTR7
, VAT_TAX_GLOBAL_ATTR_CAT
, VAT_TAX_ID
, VAT_TAX_RATE
, VAT_TAX_TRX_TYPE
, VAT_TAX_TYPE
, TAX_LOC_VALUE_ACCT_ID
, EVENT_ID
, LINE_NUMBER
, LANGUAGE
, LEDGER_ID
FROM APPS.AR_TRX_TAX_L_V;
APPS.AR_TRX_TAX_L_V is not referenced by any database object
|
|
|