JG_REPORTING_TRANSACTION_T
This temporary table contains details of General Ledger, Accounts Payables, Accounts Receivable, Payments, Receipts, Assets and their corresponding master data for audit data reporting purposes.
Details
-
Schema: FUSION
-
Object owner: JG
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
JG_REPORTING_TRANSACTION_T_PK |
REPORTING_RECORD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REPORTING_RECORD_ID | NUMBER | Yes | Processed record line identifier. | ||
| CONTEXT_ID | NUMBER | Yes | Indicates the foreign key reference column from the context table. | ||
| CONTEXT_REQUEST_ID | NUMBER | Yes | Indicates the request ID of the job that created or last updated the row for the report. | ||
| SECTION_CODE | VARCHAR2 | 30 | Yes | Section identifier for processed data. | |
| SUB_SECTION_CODE | VARCHAR2 | 30 | Subsection identifier for processed data. | ||
| LEDGER_ID | NUMBER | Ledger identifier for legal or management entities. | |||
| LEGAL_ENTITY_ID | NUMBER | Legal entity identifier of submitted parameter. | |||
| ENTITY_CODE | VARCHAR2 | 30 | ENTITY_CODE | ||
| ENTITY_ID | NUMBER | Transaction identifier for the data section. | |||
| ENTITY_LINE_CODE | VARCHAR2 | 30 | Table identifier for the entity line. | ||
| ENTITY_LINE_ID | NUMBER | Internal identifier of entity line. | |||
| SOURCE_ENTITY_CODE | VARCHAR2 | 30 | Table name identifier for the source entity. | ||
| SOURCE_ENTITY_ID | NUMBER | Transaction identifier for the data subsection. | |||
| SOURCE_ENTITY_LINE_CODE | VARCHAR2 | 30 | Table name identifier for the source entity line. | ||
| SOURCE_ENTITY_LINE_ID | NUMBER | Reference identifier for the subsection record. | |||
| INFO_CHAR1 | VARCHAR2 | 50 | Oracle internal use only | ||
| INFO_CHAR2 | VARCHAR2 | 50 | Oracle internal use only | ||
| INFO_CHAR3 | VARCHAR2 | 50 | Oracle internal use only | ||
| INFO_CHAR4 | VARCHAR2 | 50 | Oracle internal use only | ||
| INFO_CHAR5 | VARCHAR2 | 50 | Oracle internal use only | ||
| INFO_CHAR6 | VARCHAR2 | 50 | Oracle internal use only | ||
| INFO_CHAR7 | VARCHAR2 | 50 | Oracle internal use only | ||
| INFO_CHAR8 | VARCHAR2 | 50 | Oracle internal use only | ||
| INFO_CHAR9 | VARCHAR2 | 50 | Oracle internal use only | ||
| INFO_CHAR10 | VARCHAR2 | 50 | Oracle internal use only | ||
| INFO_CHAR11 | VARCHAR2 | 150 | Oracle internal use only | ||
| INFO_CHAR12 | VARCHAR2 | 150 | Oracle internal use only | ||
| INFO_CHAR13 | VARCHAR2 | 150 | Oracle internal use only | ||
| INFO_CHAR14 | VARCHAR2 | 150 | Oracle internal use only | ||
| INFO_CHAR15 | VARCHAR2 | 150 | Oracle internal use only | ||
| INFO_CHAR16 | VARCHAR2 | 150 | Oracle internal use only | ||
| INFO_CHAR17 | VARCHAR2 | 150 | Oracle internal use only | ||
| INFO_CHAR18 | VARCHAR2 | 150 | Oracle internal use only | ||
| INFO_CHAR19 | VARCHAR2 | 150 | Oracle internal use only | ||
| INFO_CHAR20 | VARCHAR2 | 150 | Oracle internal use only | ||
| INFO_CHAR21 | VARCHAR2 | 150 | Oracle internal use only | ||
| INFO_CHAR22 | VARCHAR2 | 150 | Oracle internal use only | ||
| INFO_CHAR23 | VARCHAR2 | 150 | Oracle internal use only | ||
| INFO_CHAR24 | VARCHAR2 | 150 | Oracle internal use only | ||
| INFO_CHAR25 | VARCHAR2 | 150 | Oracle internal use only | ||
| INFO_CHAR26 | VARCHAR2 | 150 | Oracle internal use only | ||
| INFO_CHAR27 | VARCHAR2 | 150 | Oracle internal use only | ||
| INFO_CHAR28 | VARCHAR2 | 150 | Oracle internal use only | ||
| INFO_CHAR29 | VARCHAR2 | 150 | Oracle internal use only | ||
| INFO_CHAR30 | VARCHAR2 | 150 | Oracle internal use only | ||
| INFO_CHAR31 | VARCHAR2 | 240 | Oracle internal use only | ||
| INFO_CHAR32 | VARCHAR2 | 240 | Oracle internal use only | ||
| INFO_CHAR33 | VARCHAR2 | 240 | Oracle internal use only | ||
| INFO_CHAR34 | VARCHAR2 | 240 | Oracle internal use only | ||
| INFO_CHAR35 | VARCHAR2 | 240 | Oracle internal use only | ||
| INFO_CHAR36 | VARCHAR2 | 240 | Oracle internal use only | ||
| INFO_CHAR37 | VARCHAR2 | 240 | Oracle internal use only | ||
| INFO_CHAR38 | VARCHAR2 | 240 | Oracle internal use only | ||
| INFO_CHAR39 | VARCHAR2 | 240 | Oracle internal use only | ||
| INFO_CHAR40 | VARCHAR2 | 240 | Oracle internal use only | ||
| INFO_CHAR41 | VARCHAR2 | 360 | Oracle internal use only | ||
| INFO_CHAR42 | VARCHAR2 | 360 | Oracle internal use only | ||
| INFO_CHAR43 | VARCHAR2 | 360 | Oracle internal use only | ||
| INFO_CHAR44 | VARCHAR2 | 360 | Oracle internal use only | ||
| INFO_CHAR45 | VARCHAR2 | 360 | Oracle internal use only | ||
| INFO_CHAR46 | VARCHAR2 | 500 | Oracle internal use only | ||
| INFO_CHAR47 | VARCHAR2 | 500 | Oracle internal use only | ||
| INFO_CHAR48 | VARCHAR2 | 500 | Oracle internal use only | ||
| INFO_CHAR49 | VARCHAR2 | 1000 | Oracle internal use only | ||
| INFO_CHAR50 | VARCHAR2 | 1000 | Oracle internal use only | ||
| INFO_CHAR51 | VARCHAR2 | 1 | Oracle internal use only | ||
| INFO_CHAR52 | VARCHAR2 | 1 | Oracle internal use only | ||
| INFO_CHAR53 | VARCHAR2 | 1 | Oracle internal use only | ||
| INFO_CHAR54 | VARCHAR2 | 1 | Oracle internal use only | ||
| INFO_CHAR55 | VARCHAR2 | 1 | Oracle internal use only | ||
| INFO_NUMBER1 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER2 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER3 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER4 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER5 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER6 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER7 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER8 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER9 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER10 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER11 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER12 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER13 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER14 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER15 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER16 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER17 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER18 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER19 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER20 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER21 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER22 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER23 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER24 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER25 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER26 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER27 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER28 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER29 | NUMBER | Oracle internal use only | |||
| INFO_NUMBER30 | NUMBER | Oracle internal use only | |||
| INFO_DATE1 | DATE | Oracle internal use only | |||
| INFO_DATE2 | DATE | Oracle internal use only | |||
| INFO_DATE3 | DATE | Oracle internal use only | |||
| INFO_DATE4 | DATE | Oracle internal use only | |||
| INFO_DATE5 | DATE | Oracle internal use only | |||
| INFO_DATE6 | DATE | Oracle internal use only | |||
| INFO_DATE7 | DATE | Oracle internal use only | |||
| INFO_DATE8 | DATE | Oracle internal use only | |||
| INFO_DATE9 | DATE | Oracle internal use only | |||
| INFO_DATE10 | DATE | Oracle internal use only | |||
| INFO_DATE11 | DATE | Oracle internal use only | |||
| INFO_DATE12 | DATE | Oracle internal use only | |||
| INFO_DATE13 | DATE | Oracle internal use only | |||
| INFO_DATE14 | DATE | Oracle internal use only | |||
| INFO_DATE15 | DATE | Oracle internal use only | |||
| INFO_TIMESTAMP1 | TIMESTAMP | Oracle internal use only | |||
| INFO_TIMESTAMP2 | TIMESTAMP | Oracle internal use only | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: Indicates the request ID of the interface load job that created the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JG_REPORTING_TRANSACTION_T_N1 | Non Unique | FUSION_TS_TX_DATA | CONTEXT_REQUEST_ID, SECTION_CODE, SUB_SECTION_CODE, SOURCE_ENTITY_ID, SOURCE_ENTITY_LINE_ID |
| JG_REPORTING_TRANSACTION_T_U1 | Unique | FUSION_TS_TX_DATA | REPORTING_RECORD_ID |