DBA Data[Home] [Help] [Dependency Information]


TABLE: AR.RA_TAX_EXEMPTIONS_ALL

Object Details
Object Name: RA_TAX_EXEMPTIONS_ALL
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.RA_TAX_EXEMPTIONS_ALL
Subobject Name:
Status: VALID


The RA_TAX_EXEMPTIONS_ALL table stores tax exemptions for either customers and sites or items. Each tax exemption that you define includes a particular tax code and a particular exemption percentage. For example, a customer site can be 100% exempt from a particular tax code.
.
The primary key for this table is TAX_EXEMPTION_ID.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RA_TAX_EXEMPTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAX_EXEMPTION_ID
RA_TAX_EXEMPTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_ID
ColumnSTATUS
RA_TAX_EXEMPTIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
ColumnSTATUS
RA_TAX_EXEMPTIONS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSITE_USE_ID
ColumnSTATUS
RA_TAX_EXEMPTIONS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCATION_ID_SEGMENT_1
ColumnSTATUS
Columns
Name Datatype Length Mandatory Comments
TAX_EXEMPTION_ID NUMBER (15) Yes Internal exemption identifier
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
STATUS VARCHAR2 (30) Yes Approval status for this exemption
INVENTORY_ITEM_ID NUMBER (15)
Inventory item that this exemption applies to
CUSTOMER_ID NUMBER (15)
Ship-to customer whom this exemption applies to
SITE_USE_ID NUMBER (15)
Ship-to site use that this exemption applies to
EXEMPTION_TYPE VARCHAR2 (30) Yes Exemptions can be for customers at a location, or for items at a location, but not for customers and items at a location.
TAX_CODE VARCHAR2 (50) Yes Tax code that this exemption applies to
PERCENT_EXEMPT NUMBER
Yes Percentage that is exempt from tax. 100% means that this is a full exemption from tax.
CUSTOMER_EXEMPTION_NUMBER VARCHAR2 (80)
Exemption certificate number
START_DATE DATE
Yes First date that this exemption is effective
END_DATE DATE

Last date that this exemption is effective
LOCATION_CONTEXT VARCHAR2 (30)
Location structure identifier, internal ID of the Sales Tax Location Flexfield
LOCATION_ID_SEGMENT_1 NUMBER (15)
Internal location ID for the 1st segment of the Location Flexfield
LOCATION_ID_SEGMENT_2 NUMBER (15)
Internal location ID for the 2nd segment of the Location Flexfield
LOCATION_ID_SEGMENT_3 NUMBER (15)
Internal location ID for the 3rd segment of the Location Flexfield
LOCATION_ID_SEGMENT_4 NUMBER (15)
Internal location ID for the 4th segment of the Location Flexfield
LOCATION_ID_SEGMENT_5 NUMBER (15)
Internal location ID for the 5th segment of the Location Flexfield
LOCATION_ID_SEGMENT_6 NUMBER (15)
Internal location ID for the 6th segment of the Location Flexfield
LOCATION_ID_SEGMENT_7 NUMBER (15)
Internal location ID for the 7th segment of the Location Flexfield
LOCATION_ID_SEGMENT_8 NUMBER (15)
Internal location ID for the 8th segment of the Location Flexfield
LOCATION_ID_SEGMENT_9 NUMBER (15)
Internal location ID for the 9th segment of the Location Flexfield
LOCATION_ID_SEGMENT_10 NUMBER (15)
Internal location ID for the 10th segment of the Location Flexfield
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
IN_USE_FLAG VARCHAR2 (1) Yes Indicates if the exemptions have been used for invoice lines. Y for Yes, N for No.
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
REASON_CODE VARCHAR2 (30)
The reason for this exemption
ORG_ID NUMBER (15)
Organization identifier
EXEMPT_CONTEXT VARCHAR2 (30)
The context for this exemption
EXEMPT_PERCENT1 NUMBER

Percentage of the exemption to apply to this portion of the Sales Tax Location Flexfield
EXEMPT_PERCENT2 NUMBER

Percentage of the exemption to apply to this portion of the Sales Tax Location Flexfield
EXEMPT_PERCENT3 NUMBER

Percentage of the exemption to apply to this portion of the Sales Tax Location Flexfield
EXEMPT_PERCENT4 NUMBER

Percentage of the exemption to apply to this portion of the Sales Tax Location Flexfield
EXEMPT_PERCENT5 NUMBER

Percentage of the exemption to apply to this portion of the Sales Tax Location Flexfield
EXEMPT_PERCENT6 NUMBER

Percentage of the exemption to apply to this portion of the Sales Tax Location Flexfield
EXEMPT_PERCENT7 NUMBER

Percentage of the exemption to apply to this portion of the Sales Tax Location Flexfield
EXEMPT_PERCENT8 NUMBER

Percentage of the exemption to apply to this portion of the Sales Tax Location Flexfield
EXEMPT_PERCENT9 NUMBER

Percentage of the exemption to apply to this portion of the Sales Tax Location Flexfield
EXEMPT_PERCENT10 NUMBER

Percentage of the exemption to apply to this portion of the Sales Tax Location Flexfield
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TAX_EXEMPTION_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      STATUS
,      INVENTORY_ITEM_ID
,      CUSTOMER_ID
,      SITE_USE_ID
,      EXEMPTION_TYPE
,      TAX_CODE
,      PERCENT_EXEMPT
,      CUSTOMER_EXEMPTION_NUMBER
,      START_DATE
,      END_DATE
,      LOCATION_CONTEXT
,      LOCATION_ID_SEGMENT_1
,      LOCATION_ID_SEGMENT_2
,      LOCATION_ID_SEGMENT_3
,      LOCATION_ID_SEGMENT_4
,      LOCATION_ID_SEGMENT_5
,      LOCATION_ID_SEGMENT_6
,      LOCATION_ID_SEGMENT_7
,      LOCATION_ID_SEGMENT_8
,      LOCATION_ID_SEGMENT_9
,      LOCATION_ID_SEGMENT_10
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      IN_USE_FLAG
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      REASON_CODE
,      ORG_ID
,      EXEMPT_CONTEXT
,      EXEMPT_PERCENT1
,      EXEMPT_PERCENT2
,      EXEMPT_PERCENT3
,      EXEMPT_PERCENT4
,      EXEMPT_PERCENT5
,      EXEMPT_PERCENT6
,      EXEMPT_PERCENT7
,      EXEMPT_PERCENT8
,      EXEMPT_PERCENT9
,      EXEMPT_PERCENT10
FROM AR.RA_TAX_EXEMPTIONS_ALL;

Dependencies

[top of page]

AR.RA_TAX_EXEMPTIONS_ALL does not reference any database object

AR.RA_TAX_EXEMPTIONS_ALL is referenced by following:

SchemaAR
ViewRA_TAX_EXEMPTIONS_ALL#