JG_REPORTING_CONTEXT_T
This temporary table contains the information of the data sections processed for the reporting context.
Details
-
Schema: FUSION
-
Object owner: JG
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
JG_REPORTING_CONTEXT_T_PK |
CONTEXT_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| CONTEXT_ID | NUMBER | Yes | Reporting context unique identifier. | |
| LEDGER_ID | NUMBER | Yes | Ledger identifier for legal or management entities. | |
| LEGAL_ENTITY_ID | NUMBER | Yes | Legal entity identifier of submitted parameter. | |
| ACCOUNTING_PERIOD_FROM | VARCHAR2 | 15 | Yes | Starting accounting period for the report. |
| ACCOUNTING_PERIOD_TO | VARCHAR2 | 15 | Yes | Ending accounting period for the report. |
| TAX_PERIOD_FROM | VARCHAR2 | 15 | Starting tax period for the report. | |
| TAX_PERIOD_TO | VARCHAR2 | 15 | Ending tax period for the report. | |
| TOP_LEVEL_ACCOUNT | VARCHAR2 | 25 | Yes | Top level account of the report. |
| VAT_REPORTING_ENTITY_ID | NUMBER | VAT reporting entity identifier of submitted parameter. | ||
| GL_ACCOUNT_DONE_FLAG | VARCHAR2 | 1 | Indicates that GL accounts section is processed. | |
| CUSTOMER_DONE_FLAG | VARCHAR2 | 1 | Indicates that customers section is processed. | |
| SUPPLIER_DONE_FLAG | VARCHAR2 | 1 | Indicates that suppliers section is processed. | |
| TAX_DONE_FLAG | VARCHAR2 | 1 | Indicates that tax section is processed. | |
| ANALYSIS_DONE_FLAG | VARCHAR2 | 1 | Indicates that analysis section is processed. | |
| PRODUCT_DONE_FLAG | VARCHAR2 | 1 | Indicates that products section is processed. | |
| ASSETS_MASTER_DONE_FLAG | VARCHAR2 | 1 | Indicates that assets master section is processed. | |
| OWNERS_DONE_FLAG | VARCHAR2 | 1 | Indicates that owners section is processed. | |
| PHYSICAL_STOCK_DONE_FLAG | VARCHAR2 | 1 | Indicates that physical stock section is processed. | |
| JOURNALS_DONE_FLAG | VARCHAR2 | 1 | Indicates that journals section is processed. | |
| PAYABLE_INVOICES_DONE_FLAG | VARCHAR2 | 1 | Indicates that Payables invoices section is processed. | |
| RECEIVABLES_INVOICES_DONE_FLAG | VARCHAR2 | 1 | Indicates that Receivables invoices section is processed. | |
| PAYMENTS_DONE_FLAG | VARCHAR2 | 1 | Indicates that payments section is processed. | |
| RECEIPTS_DONE_FLAG | VARCHAR2 | 1 | Indicates that receipts section is processed. | |
| ASSETS_DONE_FLAG | VARCHAR2 | 1 | Indicates that assets section is processed. | |
| MOVEMENT_OF_GOODS_DONE_FLAG | VARCHAR2 | 1 | Indicates that movement of goods section is processed. | |
| BATCH_NUMBER | NUMBER | Indicates the last processed batch number. | ||
| COUNTRY_CODE | VARCHAR2 | 2 | Indicates the country code of the report. | |
| DATE_FROM | DATE | From date identifier of the report. | ||
| DATE_TO | DATE | To date identifier of the report. | ||
| CONTEXT_REQUEST_ID | NUMBER | Yes | Indicates the request ID of the job that created or last updated the row for the report. | |
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JG_REPORTING_CONTEXT_T_U1 | Unique | FUSION_TS_TX_DATA | CONTEXT_ID |
| JG_REPORTING_CONTEXT_T_U2 | Unique | FUSION_TS_TX_DATA | CONTEXT_REQUEST_ID |