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     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 16     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
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