[Home] [Help] [Dependency Information]
Object Name: | JE_NO_GL_VAT_REP |
---|---|
Object Type: | TABLE |
Owner: | JE |
FND Design Data: | JE.JE_NO_GL_VAT_REP |
Subobject Name: | |
Status: | VALID |
This table stores information about transactions which have been reported to the Norwegians Tax Authorities.
When the Norwegian VAT Reconciliation Report is running in final mode, all transactions have to be inserted to this table so the report should not be able to select them again. REQUEST_ID stores the request Id when anyone runs the report in final mode. The REQUEST_ID makes it possible to reprint the previous final report.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JE_NO_GL_VAT_REP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
REQUEST_ID
SET_OF_BOOKS_ID TRX_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of Books Id |
TRX_ID | NUMBER | Yes | Trx Id | |
DISTRIBUTION_ID | NUMBER | Yes | Distribution Id | |
REQUEST_ID | NUMBER | (15) | Yes | Request Id |
GL_DATE | DATE | Yes | GL Date | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
LAST_UPDATE_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Optional Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Optional Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Optional Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Optional Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Optional Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT SET_OF_BOOKS_ID
, TRX_ID
, DISTRIBUTION_ID
, REQUEST_ID
, GL_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_BY
, LAST_UPDATE_DATE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, LAST_UPDATED_BY
FROM JE.JE_NO_GL_VAT_REP;
JE.JE_NO_GL_VAT_REP does not reference any database object
JE.JE_NO_GL_VAT_REP is referenced by following:
|
|
|