[Home] [Help] [Dependency Information]
Object Name: | JL_CO_GL_MG_HEADERS |
---|---|
Object Type: | TABLE |
Owner: | JL |
FND Design Data: | JL.JL_CO_GL_MG_HEADERS |
Subobject Name: | |
Status: | VALID |
JL_CO_GL_MG_HEADERS stores the header information related to magnetic media movements. One row is inserted in this table for each run of the get movement program, if associated detail lines are inserted in the JL_CO_GL_MG_LINES table. Each row in this table includes reported year and status. STATUS is 'N' when the row is created and 'Y' when the final magnetic media ASCII file is generated.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JL_CO_GL_MG_HEADERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | MG_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MG_HEADER_ID | NUMBER | (15) | Yes | Magnetic Media header identifier |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of Books identifier |
REPORTED_YEAR | NUMBER | (4) | Yes | Reported year |
STATUS | VARCHAR2 | (1) | Yes | Status indicating whether the flat file is generated for sending to DIAN ('Y' for final generation of file) |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT MG_HEADER_ID
, SET_OF_BOOKS_ID
, REPORTED_YEAR
, STATUS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM JL.JL_CO_GL_MG_HEADERS;
JL.JL_CO_GL_MG_HEADERS does not reference any database object
JL.JL_CO_GL_MG_HEADERS is referenced by following:
|
|
|