DW_PROJECT_REVENUE_CF

This table stores data for revenue distributions generated for expenditure items and billing events

Details

Module: Project Billing

Key Columns

REV_DISTRIBUTION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
REV_DISTRIBUTION_ID NUMBER 38 0 True Identifier of the revenue distribution
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. System Generated Unique Identifier
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_LEDGER_ID NUMBER 38 0 Contract ledger identifier DW_LEDGER_D LEDGER_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_LEDGER_ID NUMBER 38 0 Project ledger identifier DW_LEDGER_D LEDGER_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_NAME VARCHAR2 32 The GL period in which the transaction is posted. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
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 set name DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
PA_PERIOD_NAME VARCHAR2 32 The PA period name DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
PA_PERIOD_TYPE VARCHAR2 16 The PA period type DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
PA_PERIOD_SETNAME VARCHAR2 16 PA Calendar Name DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
PROJECT_FISCAL_PERIOD_TYPE VARCHAR2 16 The GL period type of Project in which the transaction is posted. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
PROJECT_FISCAL_PERIOD_SET_NAME VARCHAR2 16 GL Calendar set name of Project. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
GL_DATE DATE Revenue GL Date DW_FISCAL_DAY_D FISCAL_DAY_DATE
PA_DATE DATE Project Accounting Date DW_FISCAL_DAY_D FISCAL_DAY_DATE
EXPENDITURE_ITEM_ID NUMBER 38 0 The identifier of the expenditure item
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
QUANTITY NUMBER Quantity as obtained from the transaction
REV_RECOGNZD_QUANTITY NUMBER Quantity that has been revenue recognized
UOM_CODE VARCHAR2 32 Base unit of measure DW_PROJECT_UNIT_OF_MEASURE_TL UOM_CODE
EVENT_ORGANIZATION_ID NUMBER 38 0 The unique identifier of the organization for the event DW_INTERNAL_ORG_D ORGANIZATION_ID
GLOBAL_CURRENCY_CODE VARCHAR2 32 Global Currency Code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
CONTRACT_CURRENCY_CODE VARCHAR2 32 Contract currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
LEDGER_CURRENCY_CODE VARCHAR2 32 Ledger currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
PROJECT_CURRENCY_CODE VARCHAR2 32 Project currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
REVENUE_CURRENCY_CODE VARCHAR2 32 Revenue currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
TRNS_CURRENCY_CODE VARCHAR2 32 Transaction currency DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
PROJECT_LEDGER_CURRENCY_CODE VARCHAR2 16 Project functional currency. The default value is the value entered for the associated ledger.
GLOBAL_RATE_TYPE VARCHAR2 32 Rate type used to convert costs from the ledger currency to the Global currency. DW_CONVERSION_RATE_TYPE_D CONVERSION_TYPE
GLOBAL_RATE_DATE DATE Rate date used to convert costs from the ledger currency to the Global currency.
GLOBAL_EXCHANGE_RATE NUMBER Exchange rate used to convert costs from the ledger currency to the Global currency.
CONT_CURR_REV_RATE_TYPE VARCHAR2 32 Contract Currency Rate Type Code DW_CONVERSION_RATE_TYPE_D CONVERSION_TYPE
CONT_CURR_REV_EXCHG_DATE DATE Contract currency exchange date
CONT_CURR_REV_EXCHG_RATE NUMBER Contract currency exchange rate
LEDGER_CURR_REV_RATE_TYPE VARCHAR2 32 Ledger Currency Rate Type Code DW_CONVERSION_RATE_TYPE_D CONVERSION_TYPE
LEDGER_CURR_REV_EXCHG_DATE DATE Ledger currency exchange date
LEDGER_CURR_REV_EXCHG_RATE NUMBER Ledger currency exchange rate
PROJECT_CURR_RATE_TYPE VARCHAR2 32 Project Currency Rate Type Code DW_CONVERSION_RATE_TYPE_D CONVERSION_TYPE
PROJECT_CURRENCY_EXCHG_DATE DATE Project currency exchange date
PROJECT_CURR_EXCHG_RATE NUMBER Project currency exchange rate
REVENUE_CURR_RATE_TYPE VARCHAR2 32 Revneue Currency Rate Type Code DW_CONVERSION_RATE_TYPE_D CONVERSION_TYPE
REVENUE_CURR_EXCHG_DATE DATE Revenue currency exchange date
REVENUE_CURR_EXCHG_RATE NUMBER Revenue currency exchange rate
GLOBAL_CURR_REVENUE_AMT NUMBER Amount in global currency
CONT_CURR_REVENUE_AMT NUMBER Amount in contract currency
LEDGER_CURR_REVENUE_AMT NUMBER Amount in ledger currency
PROJECT_CURR_REVENUE_AMT NUMBER Amount in project currency
REVENUE_CURR_REVENUE_AMT NUMBER Amount in revenue currency
TRNS_CURR_REVENUE_AMT NUMBER Amount in transaction currency
REV_DISCOUNT_REASON_CODE VARCHAR2 32 Reason code for discount override or rate override DW_REVENUE_DISCOUNT_REASON_LKP_TL DISCOUNT_REASON_CODE
INV_LABOR_RATE_TYPE_CODE VARCHAR2 32 Invoice Labor rate type code DW_LABOR_SCHEDULE_LKP_TL LABOR_RATE_TYPE_CODE
INV_NL_RATE_TYPE_CODE VARCHAR2 32 Invoice Non Labor rate type code DW_NONLABOR_SCHEDULE_LKP_TL NONLABOR_RATE_TYPE_CODE
REV_LABOR_RATE_TYPE_CODE VARCHAR2 32 Revenue Labor rate type code DW_LABOR_SCHEDULE_LKP_TL LABOR_RATE_TYPE_CODE
REV_NL_RATE_TYPE_CODE VARCHAR2 32 Revenue Non Labor rate type code DW_NONLABOR_SCHEDULE_LKP_TL NONLABOR_RATE_TYPE_CODE
IC_TP_BASE_CODE VARCHAR2 32 Intercompany transfer price base code DW_TP_RULE_BASE_LKP_TL TP_RULE_BASE_CODE
IC_TP_AMT_TYPE_CODE VARCHAR2 32 Intercompany transfer amount type code DW_TP_SCH_AMT_LKP_TL TP_SCH_AMT_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
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_NUM NUMBER 38 0 Event Number
EVENT_ITEM_BASED_FLAG VARCHAR2 16 Item based event flag DW_Y_N_D_TL CODE
EVENT_COMPLETION_DATE DATE Event Completion Date
EVENT_DESC VARCHAR2 256 Event Description
EVENT_SOURCE VARCHAR2 128 Event Source
EVENT_NUM_REVERSED NUMBER 38 0 Reversed Event Number
BILL_TRX_ID NUMBER 38 0 Billing Transaction Identifier of the expenditure item/event that is revenue distributed by the distribution line
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_RATE NUMBER Transaction Bill Rate
REVENUE_LABOR_MULTIPLIER NUMBER Audit Column for rate derivation
REVENUE_MARKUP_PERCENTAGE NUMBER Markup Percentage used in derving bill rate was based on a markup in bill rate schedule
REVENUE_DISCOUNT_PERCENTAGE NUMBER Discount Percentage is used to calculate the adjusted revenue and rate
TP_REV_RULE_PERCENTAGE NUMBER Transfer price revenue rule percent
TP_REV_SCH_LINE_PERCENTAGE NUMBER Transfer price revenue schedule percent
TRANSACTION_DATE DATE Date when transaction occurs
INVOICE_DATE DATE Invoice date
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
AWARD_BUDGET_PERIOD_ID NUMBER 38 0 Award Budget period identifier. DW_AWARD_BUDGET_PERIOD_D AWARD_BUDGET_PERIOD_ID
ACCOUNTED_FLAG VARCHAR2 16 Flag to identify if Revenue is Accounted. DW_Y_N_D_TL CODE