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

TABLE: JE.JE_IL_VAT_LIMITS

Object Details
Object Name: JE_IL_VAT_LIMITS
Object Type: TABLE
Owner: JE
FND Design Data: TableJE.JE_IL_VAT_LIMITS
Subobject Name:
Status: VALID


This table is used to capture the VAT limits for each tax period


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PERIOD_SET_NAME VARCHAR2 (15) Yes Tax Calendar Name
PERIOD_NAME VARCHAR2 (15) Yes Tax Period Name
PERIOD_NUM NUMBER (15) Yes Period Number
PERIOD_YEAR NUMBER (15) Yes Period Year
MAX_RECOVERABLE_PERCENTAGE NUMBER (15)
Max Recoverable Percentage
MAX_RECOVERABLE_AMT NUMBER

Max Recoverable Amount
MIN_RECOVERABLE_AMT NUMBER
Yes Min Recoverable Amount
VAT_AGGREGATE_LIMIT_AMT NUMBER
Yes VAT Aggregation Limit
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column - Date when this row was created
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who updated this row FK to FND_USER.USER_ID
LAST_UPDATE_DATE DATE
Yes Standard who column - date when the user last updated this row
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row FK FND_LOIGNS.LOGIN_ID
Query Text

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


SELECT PERIOD_SET_NAME
,      PERIOD_NAME
,      PERIOD_NUM
,      PERIOD_YEAR
,      MAX_RECOVERABLE_PERCENTAGE
,      MAX_RECOVERABLE_AMT
,      MIN_RECOVERABLE_AMT
,      VAT_AGGREGATE_LIMIT_AMT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM JE.JE_IL_VAT_LIMITS;

Dependencies

[top of page]

JE.JE_IL_VAT_LIMITS does not reference any database object

JE.JE_IL_VAT_LIMITS is referenced by following:

SchemaJE
ViewJE_IL_VAT_LIMITS#