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

TABLE: JG.JG_ZZ_VAT_ALLOC_RULES

Object Details
Object Name: JG_ZZ_VAT_ALLOC_RULES
Object Type: TABLE
Owner: JG
FND Design Data: TableJG.JG_ZZ_VAT_ALLOC_RULES
Subobject Name:
Status: VALID


For each source, financial and VAT transaction type captures allocation
rules. These rules are used by allocation process to allocate VAT box
to each transaction lines for reporting purpose. Each line contains
VAT box for lines of type TAX and TAXABLE.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JG_ZZ_VAT_ALLOC_RULES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnALLOCATION_RULE_ID
JG_ZZ_VAT_ALLOC_RULES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnVAT_REPORTING_ENTITY_ID
ColumnSOURCE
ColumnFINANCIAL_DOCUMENT_TYPE
ColumnVAT_TRANSACTION_TYPE
ColumnTAX_CODE
ColumnTAX_STATUS
ColumnTAX_JURISDICTION_CODE
ColumnTAX_RATE_CODE
ColumnPERIOD_TYPE
ColumnEFFECTIVE_FROM_DATE
ColumnTAX_BOX_RECOVERABLE
ColumnTAX_BOX_NON_RECOVERABLE
ColumnTAXABLE_BOX_RECOVERABLE
ColumnTAXABLE_BOX_NON_RECOVERABLE
ColumnTAX_RATE_ID
Columns
Name Datatype Length Mandatory Comments
ALLOCATION_RULE_ID NUMBER (15) Yes Allocation Rules Identifier
VAT_REPORTING_ENTITY_ID NUMBER (15) Yes Reporting entity Identifier for the rule
SOURCE VARCHAR2 (30)
Transaction source. Possible values are AP, AR and GL.
FINANCIAL_DOCUMENT_TYPE VARCHAR2 (20)
Financial transaction type
VAT_TRANSACTION_TYPE VARCHAR2 (30)
VAT transaction type
TAX_ID NUMBER (15)
Tax Identifier
TAX_CODE VARCHAR2 (50)
Tax code
TAX_STATUS VARCHAR2 (30)
Tax Status
TAX_JURISDICTION_CODE VARCHAR2 (30)
Tax Jurisdiction
TAX_RATE_CODE VARCHAR2 (50)
Tax rate code
TAX_RATE_ID NUMBER (15)
Tax rate Identifier
TAX_BOX_RECOVERABLE VARCHAR2 (15)
Indicates recoverable VAT box number for tax lines.
TAX_BOX_NON_RECOVERABLE VARCHAR2 (15)
Indicates nonrecoverable VAT box number for tax lines.
TAXABLE_BOX_RECOVERABLE VARCHAR2 (15)
Indicates recoverable VAT box number for taxable lines.
TAXABLE_BOX_NON_RECOVERABLE VARCHAR2 (15)
Indicates nonrecoverable VAT box number for taxable lines
TOTAL_BOX VARCHAR2 (15)
Total VAT box number
EFFECTIVE_FROM_DATE DATE

Indicates date from which rule is effective.
EFFECTIVE_TO_DATE DATE

Indicates till what date rule is effective. NULL value means effective for ever
PERIOD_TYPE VARCHAR2 (15)
Period type
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
TAX_REC_SIGN_FLAG VARCHAR2 (1)
Sign flag for recoverable tax amount
TAX_NON_REC_SIGN_FLAG VARCHAR2 (1)
Sign flag for nonrecoverable tax amount
TAXABLE_REC_SIGN_FLAG VARCHAR2 (1)
Sign flag for recoverable taxable amount
TAXABLE_NON_REC_SIGN_FLAG VARCHAR2 (1)
Sign flag for nonrecoverable taxable amount
Query Text

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


SELECT ALLOCATION_RULE_ID
,      VAT_REPORTING_ENTITY_ID
,      SOURCE
,      FINANCIAL_DOCUMENT_TYPE
,      VAT_TRANSACTION_TYPE
,      TAX_ID
,      TAX_CODE
,      TAX_STATUS
,      TAX_JURISDICTION_CODE
,      TAX_RATE_CODE
,      TAX_RATE_ID
,      TAX_BOX_RECOVERABLE
,      TAX_BOX_NON_RECOVERABLE
,      TAXABLE_BOX_RECOVERABLE
,      TAXABLE_BOX_NON_RECOVERABLE
,      TOTAL_BOX
,      EFFECTIVE_FROM_DATE
,      EFFECTIVE_TO_DATE
,      PERIOD_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TAX_REC_SIGN_FLAG
,      TAX_NON_REC_SIGN_FLAG
,      TAXABLE_REC_SIGN_FLAG
,      TAXABLE_NON_REC_SIGN_FLAG
FROM JG.JG_ZZ_VAT_ALLOC_RULES;

Dependencies

[top of page]

JG.JG_ZZ_VAT_ALLOC_RULES does not reference any database object

JG.JG_ZZ_VAT_ALLOC_RULES is referenced by following:

SchemaJG
ViewJG_ZZ_VAT_ALLOC_RULES#