DW_PROJECT_SLA_REVENUE_CF

This table stores SLA level data for project revenue distributions

Details

Module: Project Billing

Key Columns

AE_HEADER_ID, REV_DISTRIBUTION_ID, REF_AE_HEADER_ID, APPLICATION_ID, TEMP_LINE_NUM

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
REV_DISTRIBUTION_ID NUMBER 38 0 True Revenue Distribution Number    
AE_HEADER_ID NUMBER 38 0 True Subledger journal entry identifier.    
TEMP_LINE_NUM NUMBER 38 0 True Intermediary line number generated by the accounting engine when the entries are in most detail form.    
APPLICATION_ID NUMBER 38 0 True Identifier of a functional area within a software suite of products. For example: Financials, or Payroll.    
REF_AE_HEADER_ID NUMBER 38 0 True Reversed subledger journal entry header identifier.    
SOURCE_RECORD_ID VARCHAR2 256     This column is for Oracle Internal use only. System Generated Unique Identifier    
SUBLEDGER_FACT_LINKAGE_ID VARCHAR2 128     Column concat of ae_header_id, ref_ae_header_id, temp_line_num    
LINE_NUM NUMBER 38 0   Line Number    
MAJOR_VERSION NUMBER 38 0   Version number of contract    
CONTRACT_HEADER_ID NUMBER 38 0   Identifier of the contract DW_CONTRACT_HEADER_D CONTRACT_HEADER_ID
CONTRACT_LINE_ID NUMBER 38 0   Identifier of the contract line DW_CONTRACT_LINE_CF CONTRACT_LINE_ID
CONTRACT_LEGAL_ENTITY_ID NUMBER 38 0   Contract legal entity identifier DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
CONTRACT_BUSINESS_UNIT_ID NUMBER 38 0   Contract business unit identifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
CONTRACT_ORGANIZATION_ID NUMBER 38 0   Contract organization identifier DW_INTERNAL_ORG_D ORGANIZATION_ID
LINKED_PROJECT_ID NUMBER 38 0   Identifier of project that is linked to contract DW_PROJECT_D PROJECT_ID
LINKED_TASK_ID NUMBER 38 0   Identifier of task that is linked to contract DW_PROJECT_ELEMENT_D PROJ_ELEMENT_ID
TRANSACTION_PROJECT_ID NUMBER 38 0   Identifier of transaction Project Identifier DW_PROJECT_D PROJECT_ID
TRANSACTION_TASK_ID NUMBER 38 0   Identifier of transaction task identifier DW_PROJECT_ELEMENT_D PROJ_ELEMENT_ID
PROJECT_LEGAL_ENTITY_ID NUMBER 38 0   Project legal entity identifier DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
PROJECT_BUSINESS_UNIT_ID NUMBER 38 0   Project business unit identifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
PROJECT_ORGANIZATION_ID NUMBER 38 0   Project organization identifier DW_INTERNAL_ORG_D ORGANIZATION_ID
PROJECT_UNIT_ID NUMBER 38 0   Project Unit Identifier DW_INTERNAL_ORG_D ORGANIZATION_ID
BILL_PLAN_ID NUMBER 38 0   Bill Plan Identifier DW_CONTRACT_BILL_PLAN_D BILL_PLAN_ID
CONTRACT_PROJECT_LINKAGE_ID NUMBER 38 0   Identifier of contract project linkage DW_PROJECT_FUNDING_CF LINK_ID
FISCAL_PERIOD_TYPE VARCHAR2 16     The GL period type in which the transaction is posted. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
FISCAL_PERIOD_SET_NAME VARCHAR2 16     GL Calendar Name for Provider business unit. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_NAME VARCHAR2 64     Accounting period name. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
GL_DATE DATE       Revenue GL Date DW_FISCAL_DAY_D FISCAL_DAY_DATE
EXPENDITURE_ITEM_ID NUMBER 38 0   The identifier of the expenditure item DW_PJC_EXP_ITEMS_EN EXPENDITURE_ITEM_ID
EXPENDITURE_TYPE_ID NUMBER 38 0   Identifier of the expenditure type DW_PROJECT_EXPENDITURE_TYPE_D EXPENDITURE_TYPE_ID
EXPENDITURE_TYPE_CLASS_CODE VARCHAR2 16     The system linkage that classifies the expenditure type in order to drive system processing for the items classified by the expenditure type DW_PROJECT_SYSTEM_LINKAGE_TL SYSTEM_LINKAGE_FUNCTION
EXPENDITURE_CATEGORY_ID NUMBER 38 0   Category of the expenditure type DW_PROJECT_EXP_CATEGORY_D EXPENDITURE_CATEGORY_ID
EXPENDITURE_ORGANIZATION_ID NUMBER 38 0   Expenditure Organization for the Expenditure item. DW_INTERNAL_ORG_D ORGANIZATION_ID
REVENUE_PLAN_ID NUMBER 38 0   Identifier of the revenue plan DW_CONTRACT_BILL_PLAN_D BILL_PLAN_ID
INVENTORY_ITEM_ID NUMBER 38 0   Inventory item identifier DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
ITEM_ORGANIZATION_ID NUMBER 38 0   Identifier of the inventory item organization DW_INTERNAL_ORG_D ORGANIZATION_ID
BILL_JOB_ID NUMBER 38 0   The identifier of the job DW_JOB_D JOB_ID
PERSON_ID NUMBER 38 0   Identifier of employee DW_PERSON_D PERSON_ID
NON_LABOR_RESOURCE_ID NUMBER 38 0   Identifier of the non labor resource DW_PROJECT_NON_LABOR_RES_TL NON_LABOR_RESOURCE_ID
NON_LABOR_ORG_ID NUMBER 38 0   The identifier of the organization that owns the non-labor resource that was utilized as the work was performed. DW_INTERNAL_ORG_D ORGANIZATION_ID
RBS_ELEMENT_ID NUMBER 38 0   Identifier of resource breakdown structure element DW_RBS_ELEMENT_D RBS_ELEMENT_ID
UOM_CODE VARCHAR2 32     Base unit of measure DW_PROJECT_UNIT_OF_MEASURE_TL UOM_CODE
GL_CODE_COMBINATION_ID NUMBER 38 0   Accounting code combination identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
GL_BALANCING_SEGMENT VARCHAR2 32     Balancing segment for the ledger. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64     Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
COST_CENTER_SEGMENT VARCHAR2 32     Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64     Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32     Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64     Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 VARCHAR2 32     Accounting segment 1. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64     Accounting segment 1 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 VARCHAR2 32     Accounting segment 2. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64     Accounting segment 2 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 VARCHAR2 32     Accounting segment 3. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64     Accounting segment 3 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 VARCHAR2 32     Accounting segment 4. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64     Accounting segment 4 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 VARCHAR2 32     Accounting segment 5. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64     Accounting segment 5 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 VARCHAR2 32     Accounting segment 6. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64     Accounting segment 6 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 VARCHAR2 32     Accounting segment 7. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64     Accounting segment 7 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 VARCHAR2 32     Accounting segment 8. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64     Accounting segment 8 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 VARCHAR2 32     Accounting segment 9. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64     Accounting segment 9 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 VARCHAR2 32     Accounting segment 10. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64     Accounting segment 10 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
XLA_TRANSACTION_AMOUNT BIGDECIMAL   10   Unrounded entered debit amount for the journal line minus Unrounded entered credit amount for the journal line.    
XLA_LEDGER_AMOUNT BIGDECIMAL   10   Unrounded accounted debit for journal entry line minus Unrounded accounted credit for journal entry line.    
XLA_ENTERED_DR BIGDECIMAL   10   Unrounded entered debit amount for the journal line.    
XLA_ENTERED_CR BIGDECIMAL   10   Unrounded entered credit amount for the journal line.    
XLA_ACCOUNTED_DR BIGDECIMAL   10   Unrounded accounted debit for journal entry line.    
XLA_ACCOUNTED_CR BIGDECIMAL   10   Unrounded accounted credit for journal entry line.    
XLA_MANUAL_OVERRIDE_FLAG VARCHAR2 16     Flag to identify if the CCID is overridden. DW_Y_N_D_TL CODE
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global Currency Code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
XLA_GLOBAL_AMOUNT BIGDECIMAL   10   XLA Amount in Global Currency    
XLA_GLOBAL_DR_AMOUNT BIGDECIMAL   10   Unrounded debit amount for the journal line in Global Currency.    
XLA_GLOBAL_CR_AMOUNT BIGDECIMAL   10   Unrounded Credit amount for the journal line in Global Currency.    
XLA_LINE_TRANSACTION_AMOUNT BIGDECIMAL   10   XLA Line Amount in transaction Currency    
XLA_LINE_ENTERED_DR_AMOUNT BIGDECIMAL   10   Unrounded entered debit amount for the journal line.    
XLA_LINE_ENTERED_CR_AMOUNT BIGDECIMAL   10   Unrounded entered credit amount for the journal line.    
XLA_LINE_LEDGER_AMOUNT BIGDECIMAL   10   XLA Line Amount in Ledger Currency    
XLA_LINE_ACCOUNTED_DR_AMOUNT BIGDECIMAL   10   Unrounded accounted debit amount of the journal entry line.    
XLA_LINE_ACCOUNTED_CR_AMOUNT BIGDECIMAL   10   Unrounded accounted credit amount of the journal entry line.    
XLA_LINE_GLOBAL_AMOUNT BIGDECIMAL   10   XLA Line Amount in Global Currency    
XLA_LINE_GLOBAL_DR_AMOUNT BIGDECIMAL   10   Unrounded Global debit amount of the journal entry line.    
XLA_LINE_GLOBAL_CR_AMOUNT BIGDECIMAL   10   Unrounded Global credit amount of the journal entry line.    
XLA_LEDGER_ID NUMBER 38 0   Self-contained accounting information set for single or multiple legal or management entities. DW_LEDGER_D LEDGER_ID
XLA_LEDGER_CURRENCY_CODE VARCHAR2 16     Functional currency of the ledger. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
XLA_TRANSACTION_CURRENCY_CODE VARCHAR2 16     Entered currency for the transaction data DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
XLA_ACCOUNTING_DATE DATE       Date, referenced from Oracle Fusion General Ledger, used to determine the accounting period for transactions. DW_FISCAL_DAY_D FISCAL_DAY_DATE
ACCOUNTING_CLASS_CODE VARCHAR2 32     Short name of a lookup type that is shared across application used to classify journal entry lines. DW_XLA_ACCOUNT_CLASS_LKP_TL ACCOUNTING_CLASS_CODE
SOURCE_DISTRIBUTION_TYPE VARCHAR2 32     Classification of transaction source distribution    
ACCOUNTING_LINE_CODE VARCHAR2 32     Short name of a rule to convert transactional data into a journal entry line.    
ACCOUNTING_LINE_TYPE_CODE VARCHAR2 16     Type of journal line rule: Debit, Credit, Gain or Loss.    
AE_LINE_NUM NUMBER 38 0   Number that is associated with each subledger journal entry line.    
BILL_TRX_ID NUMBER 38 0   Billing Transaction Identifier of the expenditure item/event that is revenue distributed by the distribution line    
EVENT_ID NUMBER 38 0   Identifier of the event    
EVENT_TYPE_ID NUMBER 38 0   Identifier of the event type DW_PROJECT_EVENT_TYPE_D EVENT_TYPE_ID
EVENT_ORGANIZATION_ID NUMBER 38 0   The unique identifier of the organization for the event DW_INTERNAL_ORG_D ORGANIZATION_ID
EVENT_NUM NUMBER 38 0   Event Number    
EVENT_COMPLETION_DATE DATE       Event Completion Date    
TRANSACTION_DATE DATE       Date when transaction occurs    
BILLING_TYPE_CODE VARCHAR2 32     Identifies for which billing type the line has got created DW_PJB_BILLING_TYPE_LKP_TL BILLING_TYPE_CODE
BILL_TRANSACTION_TYPE_CODE VARCHAR2 32     Billing Transaction Type Code DW_BILL_TRANSACTION_TYPE_LKP_TL BILL_TRANSACTION_TYPE_CODE
REVENUE_CATEGORY_CODE VARCHAR2 32     Revenue category code DW_REVENUE_CATEGORY_LKP_TL REVENUE_CATEGORY_CODE
REVENUE_RECOGNIZED_FLAG VARCHAR2 16     Revenue Recognized Flag to know if it is partially or fully recognized DW_REVENUE_RECOGNIZED_LKP_TL REVENUE_RECOGNIZED_FLAG
REVERSED_FLAG VARCHAR2 16     Flag that indicates if the distribution line is reversed by another distribution line DW_Y_N_D_TL CODE
REVERSED_REV_DISTRIBUTION_ID NUMBER 38 0   Identifier of the reversed distribution    
LINE_NUM_REVERSED VARCHAR2 32     Reversed Line Number    
REV_DISTRIBUTION_CREATION_DATE TIMESTAMP       Date and time of the creation of revenue distribution row    
CREATED_BY VARCHAR2 64     Indicates the user who created the distribution record DW_USER_D USERNAME
XLA_CREATION_DATE TIMESTAMP       Date and time of the creation of XLA distribution row    
AWARD_BUDGET_PERIOD_ID NUMBER 38 0   Award Budget period identifier. DW_AWARD_BUDGET_PERIOD_D AWARD_BUDGET_PERIOD_ID

Copyright © 2019, 2024, Oracle and/or its affiliates.