[Home] [Help] [Dependency Information]
Object Name: | IGI_AP_TRAN_TEMP |
---|---|
Object Type: | TABLE |
Owner: | IGI |
FND Design Data: | IGI.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.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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;
IGI.IGI_AP_TRAN_TEMP does not reference any database object
IGI.IGI_AP_TRAN_TEMP is referenced by following:
|
|
|