1. Tables and Views for Project Management
  2. PJB_BI_REPORT_DETAILS_GT

PJB_BI_REPORT_DETAILS_GT

PJB_BI_REPORT_DETAILS_GT is used to store temporary report data for BI report

Details

  • Schema: FUSION

  • Object owner: PJB

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Not-null Comments Status
ID NUMBER 18 Yes ID Active
REPORT_NAME VARCHAR2 30 Yes REPORT_NAME Active
REPORT_LINE_TYPE VARCHAR2 250 Yes REPORT_LINE_TYPE Active
REPORT_LINE_NUM NUMBER 18 Yes REPORT_LINE_NUM Active
REPORT_LINE_ID NUMBER 18 Yes REPORT_LINE_ID Active
ORG_ID NUMBER 18 Indicates the identifier of the business unit associated to the row. Active
BILLING_TYPE_NAME VARCHAR2 80 BILLING_TYPE_NAME Active
BILLING_EXTENSION_NAME VARCHAR2 30 BILLING_EXTENSION_NAME Active
EVENT_TYPE VARCHAR2 240 EVENT_TYPE Active
COST_PLAN_TYPE VARCHAR2 240 COST_PLAN_TYPE Active
BUSINESS_UNIT_NAME VARCHAR2 240 BUSINESS_UNIT_NAME Active
LEGAL_ENTITY_NAME VARCHAR2 240 LEGAL_ENTITY_NAME Active
CONTRACT_NUMBER VARCHAR2 120 CONTRACT_NUMBER Active
CONTRACT_NAME VARCHAR2 300 CONTRACT_NAME Active
CONTRACT_DESC VARCHAR2 600 CONTRACT_DESC Active
CONTRACT_TYPE VARCHAR2 150 CONTRACT_TYPE Active
BILL_TO_ACCOUNT_NAME VARCHAR2 360 BILL_TO_ACCOUNT_NAME Active
STS_NAME VARCHAR2 80 STS_NAME Active
MAJOR_VERSION NUMBER 18 MAJOR_VERSION Active
BILL_PLAN_NAME VARCHAR2 240 BILL_PLAN_NAME Active
BILL_METHOD_NAME VARCHAR2 50 BILL_METHOD_NAME Active
CONTRACT_LINE_NUMBER VARCHAR2 150 CONTRACT_LINE_NUMBER Active
PROJECT_NAME VARCHAR2 255 PROJECT_NAME Active
PROJ_ELEM_NAME VARCHAR2 255 PROJ_ELEM_NAME Active
TRANSACTION_ID NUMBER 18 TRANSACTION_ID Active
BILLABLE_FLAG VARCHAR2 1 BILLABLE_FLAG Active
BILLABLE_FLAG_DESC VARCHAR2 80 BILLABLE_FLAG_DESC Active
HOLD_FLAG VARCHAR2 1 HOLD_FLAG Active
HOLD_FLAG_DESC VARCHAR2 80 HOLD_FLAG_DESC Active
PLAN_HOLD_FLAG VARCHAR2 1 PLAN_HOLD_FLAG Active
PLAN_HOLD_FLAG_DESC VARCHAR2 80 PLAN_HOLD_FLAG_DESC Active
TRANSACTION_DATE DATE TRANSACTION_DATE Active
TRANSACTION_TYPE_CODE VARCHAR2 30 TRANSACTION_TYPE_CODE Active
INVOICE_ID NUMBER 18 INVOICE_ID Active
INVOICE_NUM NUMBER 18 INVOICE_NUM Active
EVENT_NUM NUMBER 18 EVENT_NUM Active
READY_TO_ACCRUE_FLAG VARCHAR2 1 READY_TO_ACCRUE_FLAG Active
READY_TO_ACC_DESC VARCHAR2 30 Ready to accrue description Active
RA_INVOICE_NUM VARCHAR2 20 RA_INVOICE_NUM Active
SYSTEM_REFERENCE NUMBER 18 SYSTEM_REFERENCE Active
ACCOUNTING_EVENT_TYPE VARCHAR2 80 ACCOUNTING_EVENT_TYPE Active
INVOICE_DATE DATE INVOICE_DATE Active
INVOICE_CURRENCY_CODE_DESC VARCHAR2 30 INVOICE_CURRENCY_CODE_DESC Active
INVOICE_CURRENCY_AMOUNT NUMBER INVOICE_CURRENCY_AMOUNT Active
LEDGER_CURRENCY_CODE_DESC VARCHAR2 30 LEDGER_CURRENCY_CODE_DESC Active
LEDGER_CURRENCY_AMOUNT NUMBER LEDGER_CURRENCY_AMOUNT Active
ACCOUNTING_DATE DATE ACCOUNTING_DATE Active
ACCOUNTING_PERIOD VARCHAR2 30 ACCOUNTING_PERIOD Active
ERROR_CODE_1 VARCHAR2 30 ERROR_CODE_1 Active
ERROR_CODE_2 VARCHAR2 30 ERROR_CODE_2 Active
ERROR_CODE_3 VARCHAR2 30 ERROR_CODE_3 Active
ERROR_CODE_4 VARCHAR2 30 ERROR_CODE_4 Active
ERROR_CODE_5 VARCHAR2 30 ERROR_CODE_5 Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
RUN_ID VARCHAR2 4000 Indicates the run id when record is populated from Diagnostics.
EXECUTION_ID VARCHAR2 4000 Indicates the execution id when record is populated from Diagnostics. This is used in combination with Run id to determine the unique run of Diagnostics.
PROCESS_MODE VARCHAR2 30 Indicates whether record is populated from Diagnostics or otherwise . If populated from Diagnostics the record shall have value of 'DIAGNOSTICS' else 'REPORT'.
SHIP_TO_ACCOUNT_NAME VARCHAR2 360 Identifier of Ship to Account Name.
SHIP_TO_SITE_NAME VARCHAR2 360 Identifier for Ship to Site Name.
SOLD_TO_ACCOUNT_NAME VARCHAR2 360 Identifier for Sold to Account Name.
SOLD_TO_SITE_NAME VARCHAR2 360 Identifier for Sold to Site name.
BILL_TO_SITE_NAME VARCHAR2 360 Identifier for Bill to Site name.
BILL_TO_SITE_USE_ID NUMBER 18 Identifier for Bill to site use id.
BILL_TO_CUST_ACCT_ID NUMBER 18 Identifier for Bill to customer account.
SHIP_TO_SITE_USE_ID NUMBER 18 Identifier for Ship to Site use.
SHIP_TO_ACCT_ID NUMBER 18 Identifier for Ship to Account.
SOLD_TO_ACCT_ID NUMBER 18 Identifier for Sold to Account.
SOLD_TO_SITE_ID NUMBER 18 Identifier for Sold to Site.
BILL_PLAN_ID NUMBER 18 Identifier for Bill Plan.
CONFIGURATION_ID NUMBER 18 Unique identifier of configuration.
ERROR_CODE1_TOKEN1 VARCHAR2 30 First message token pertaining to message ERROR_CODE_1.
ERROR_CODE1_TOKEN2 VARCHAR2 30 Second message token pertaining to message ERROR_CODE_1.
ERROR_CODE2_TOKEN1 VARCHAR2 30 Message Token pertaining ERROR_CODE_2.
ERROR_CODE3_TOKEN1 VARCHAR2 30 Message Token pertaining ERROR_CODE_3.
ERROR_CODE4_TOKEN1 VARCHAR2 30 Message Token pertaining ERROR_CODE_4.
ERROR_CODE5_TOKEN1 VARCHAR2 30 Message Token pertaining ERROR_CODE_5.
ERROR_CODE1_VALUE1 VARCHAR2 2000 First message token value pertaining to ERROR_CODE_1.
ERROR_CODE1_VALUE2 VARCHAR2 2000 Second message token value pertaining to ERROR_CODE_1.
ERROR_CODE2_VALUE1 VARCHAR2 2000 Message Token value pertaining to ERROR_CODE_2.
ERROR_CODE3_VALUE1 VARCHAR2 2000 Message Token value pertaining to ERROR_CODE_3.
ERROR_CODE4_VALUE1 VARCHAR2 2000 Message Token value pertaining to ERROR_CODE_4.
ERROR_CODE5_VALUE1 VARCHAR2 2000 Message Token value pertaining to ERROR_CODE_5.
ADDL_INFO1 VARCHAR2 2000 Additional information related to ineligibility.
ADDL_INFO2 VARCHAR2 2000 Additional information related to ineligibility.

Indexes

Index Uniqueness Columns Status
PJB_BI_REPORT_DETAILS_GT_N10 Non Unique PROCESS_MODE, REPORT_NAME, RUN_ID
PJB_BI_REPORT_DETAILS_GT_N2 Non Unique REPORT_LINE_NUM Active
PJB_BI_REPORT_DETAILS_GT_N3 Non Unique ERROR_CODE_1 Active
PJB_BI_REPORT_DETAILS_GT_N4 Non Unique ERROR_CODE_2 Active
PJB_BI_REPORT_DETAILS_GT_N5 Non Unique ERROR_CODE_3 Active
PJB_BI_REPORT_DETAILS_GT_N6 Non Unique ERROR_CODE_4 Active
PJB_BI_REPORT_DETAILS_GT_N7 Non Unique ERROR_CODE_5 Active
PJB_BI_REPORT_DETAILS_GT_N8 Non Unique REPORT_LINE_ID, TRANSACTION_ID Active
PJB_BI_REPORT_DETAILS_GT_N9 Non Unique REQUEST_ID, TRANSACTION_ID, REPORT_NAME, REPORT_LINE_ID
PJB_BI_REPORT_DETAILS_GT_U1 Unique ID Active