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

TABLE: JL.JL_CO_GL_MG_LINES

Object Details
Object Name: JL_CO_GL_MG_LINES
Object Type: TABLE
Owner: JL
FND Design Data: TableJL.JL_CO_GL_MG_LINES
Subobject Name:
Status: VALID


JL_CO_GL_MG_LINES stores the detail information related to magnetic media movements, which is consolidated information based on the literal, third party ID, reported value, movement type and range of accounts, that will be sent to the DIAN. There is a one-to-many relationship between magnetic media headers and detail. Rows in this table are inserted by the get movements program. Each row in this table includes associated header ID, sub-literal ID, third party ID, third party name, reported value, base amounts or withholding amounts and VAT amounts or VAT withholding amounts. REPORTED_FLAG is 'Y' for records to be reported to DIAN, and 'N' for others. ORIGIN is 'A' for records inserted by the magnetic media get movement program, and 'I' for records inserted by the custom program for legacy data conversion.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JL_CO_GL_MG_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMG_LINE_ID
JL_CO_GL_MG_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMG_HEADER_ID
ColumnLITERAL_ID
ColumnREPORTED_VALUE
JL_CO_GL_MG_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMG_HEADER_ID
ColumnNIT_ID
JL_CO_GL_MG_LINES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMG_HEADER_ID
ColumnCONFIG_ID
ColumnRANGE_ID
Columns
Name Datatype Length Mandatory Comments
MG_LINE_ID NUMBER (15) Yes Magnetic Media line identifier
MG_HEADER_ID NUMBER (15) Yes Magnetic Media header identifier
LITERAL_ID NUMBER (15) Yes Sub-Literal identifier
REPORTED_VALUE VARCHAR2 (1) Yes Reported Value
REPORTED_FLAG VARCHAR2 (1) Yes Flag to indicate whether the record is reported to DIAN ('Y' for reporting and 'N' for not reporting)
NIT_ID NUMBER (15) Yes Third Party identifier
THIRD_PARTY_NAME VARCHAR2 (300)
Third Party name
FIRST_REPORTED_VALUE NUMBER (20)
Base Amount or Withholding Amount to be reported to DIAN
SECOND_REPORTED_VALUE NUMBER (20)
VAT Amount or VAT Withholding Amount to be reported to DIAN
CONFIG_ID NUMBER (15)
Configuration identifier
RANGE_ID NUMBER (15)
Range identifier
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
LITERAL_LITERAL_ID NUMBER (15)
Literal identifier of 2 digit Literal of this Sub-Literal
SEND_BACK_FLAG VARCHAR2 (1) Yes Reserved for future use
ORIGIN VARCHAR2 (1) Yes Flag indicating the origin of the record
THIRD_REPORTED_VALUE NUMBER (20)
Third Reported Value
FOURTH_REPORTED_VALUE NUMBER (20)
Fourth Reported Value
FIFTH_REPORTED_VALUE NUMBER (20)
Fifth Reported Value
SIXTH_REPORTED_VALUE NUMBER (20)
Sixth Reported Value
SEVENTH_REPORTED_VALUE NUMBER (20)
Seventh Reported Value
EIGHTH_REPORTED_VALUE NUMBER (20)
Eighth Reported Value
NINTH_REPORTED_VALUE NUMBER (20)
Ninth Reported Value
Query Text

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


SELECT MG_LINE_ID
,      MG_HEADER_ID
,      LITERAL_ID
,      REPORTED_VALUE
,      REPORTED_FLAG
,      NIT_ID
,      THIRD_PARTY_NAME
,      FIRST_REPORTED_VALUE
,      SECOND_REPORTED_VALUE
,      CONFIG_ID
,      RANGE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LITERAL_LITERAL_ID
,      SEND_BACK_FLAG
,      ORIGIN
,      THIRD_REPORTED_VALUE
,      FOURTH_REPORTED_VALUE
,      FIFTH_REPORTED_VALUE
,      SIXTH_REPORTED_VALUE
,      SEVENTH_REPORTED_VALUE
,      EIGHTH_REPORTED_VALUE
,      NINTH_REPORTED_VALUE
FROM JL.JL_CO_GL_MG_LINES;

Dependencies

[top of page]

JL.JL_CO_GL_MG_LINES does not reference any database object

JL.JL_CO_GL_MG_LINES is referenced by following:

SchemaJL
ViewJL_CO_GL_MG_LINES#