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

TABLE: IGI.IGI_AP_TRAN_TEMP

Object Details
Object Name: IGI_AP_TRAN_TEMP
Object Type: TABLE
Owner: IGI
FND Design Data: TableIGI.IGI_AP_TRAN_TEMP
Subobject Name:
Status: VALID


IGI_AP_TRAN_TEMP is an upgrade table for Gross Based VAT migration from 10.7/11.03 solution to 11i Recoverable tax by IGI upgrade scripts.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
INV_ID NUMBER

Invoice Identifier
DIST_ID NUMBER

Distribution identifier
DIST_LINE_NUM NUMBER

Distribution line number
LINE_TYPE VARCHAR2 (25)
Line type
VAT_CODE VARCHAR2 (15)
Vat Code
AMOUNT NUMBER

Amount
TAX_RECOVERY_RATE NUMBER

Reovery Rate for the new functionality.
TAX_RECOVERABLE_FLAG VARCHAR2 (25)
Whether the Tax is recoverable.
TAX_RECOVERY_OVERRIDE_FLAG VARCHAR2 (25)
Override Flag for Recovery rate.
TAX_CODE_OVERRIDE_FLAG VARCHAR2 (25)
Whether the Tax code can be overriden.
JE_UK_VAT_LINK_TO_LINE_TO_LNK NUMBER

Links the tax line to the releated item line to be linked to.
JE_UK_VAT_LINK_TO_LINE_NUM NUMBER

Link to the distribution item line.
JE_UK_VAT_RECLAIM_TYPE VARCHAR2 (1)
Tax Reclaim type
ORG_ID NUMBER

Organization identifier
Query Text

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


SELECT INV_ID
,      DIST_ID
,      DIST_LINE_NUM
,      LINE_TYPE
,      VAT_CODE
,      AMOUNT
,      TAX_RECOVERY_RATE
,      TAX_RECOVERABLE_FLAG
,      TAX_RECOVERY_OVERRIDE_FLAG
,      TAX_CODE_OVERRIDE_FLAG
,      JE_UK_VAT_LINK_TO_LINE_TO_LNK
,      JE_UK_VAT_LINK_TO_LINE_NUM
,      JE_UK_VAT_RECLAIM_TYPE
,      ORG_ID
FROM IGI.IGI_AP_TRAN_TEMP;

Dependencies

[top of page]

IGI.IGI_AP_TRAN_TEMP does not reference any database object

IGI.IGI_AP_TRAN_TEMP is referenced by following:

SchemaIGI
ViewIGI_AP_TRAN_TEMP#