PJB_REV_DISTRIBUTIONS

This table stores the revenue lines distributions.

Details

  • Schema: FUSION

  • Object owner: PJB

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

PJB_REV_DISTRIBUTIONS_PK

REV_DISTRIBUTION_ID

Columns

Name Datatype Length Precision Not-null Comments
REV_DISTRIBUTION_ID NUMBER 18 Yes Identifier of the Revenue Line *****
LOC_NUMBER VARCHAR2 240 Letter of Credit Number on Grants contract BillPlan
DOC_NUMBER VARCHAR2 240 Document Number on Grants Contract Billplan
BILL_TRX_ID NUMBER 18 Yes The identifier of the expenditure item/event that is revenue distributed by the distribution line *****
CONTRACT_ID NUMBER 18 Yes Identifier of the contract *****
MAJOR_VERSION NUMBER 18 Yes Version number of contract *****
CONTRACT_LINE_ID NUMBER 18 Yes Identifier of the contract line *****
REVENUE_PLAN_ID NUMBER 18 Yes Identifier of the revenue plan *****
CONTRACT_PROJECT_LINKAGE_ID NUMBER 18 Identifier of the contract project linkage *****
LINKED_PROJECT_ID NUMBER 18 Identifier of project that is linked to contract *****
LINKED_TASK_ID NUMBER 18 Identifier of task that is linked to contract *****
TRANSACTION_ID NUMBER 18 Yes The identifier of the expenditure item/event that is revenue distributed by the distribution line *****
BILL_TRANSACTION_TYPE_CODE VARCHAR2 30 Yes Billing Transaciton Type Code *****
TRANSACTION_TYPE_ID NUMBER 18 Yes Identifier of Event Type or Expenditure Item Type *****
TRANSACTION_DATE DATE Date when transaction occurs *****
TRANSACTION_PROJECT_ID NUMBER 18 Identifier of transaction Project ID *****
TRANSACTION_TASK_ID NUMBER 18 Identifier of transaction task id *****
LINE_NUM NUMBER 18 Yes Line Number *****
REVENUE_CATEGORY_CODE VARCHAR2 30 Revneue category code *****
BILL_RATE NUMBER Transaction Bill Rate *****
REVENUE_AMOUNT_CALC_CODE VARCHAR2 30 Audit Column for rate derivation. Valid values are Indirect(I), Overrides(O), Extension (E), Bill rates (B) , Labor Multiplier (L) *****
REVENUE_RATE_SOURCE_ID NUMBER 18 Audit Column for bill rate derivation. It stores the rate schedule id of bill rate schedule was used, override id if override used *****
REVENUE_DENOM_RATE_ID NUMBER 18 Identifier of the Revenue DENOM RATE ID *****
REV_BURDEN_COMPILE_SET_ID NUMBER 18 dentifier of the compiled set used to calculate a burden schedule *****
REV_DISCOUNT_REASON_CODE VARCHAR2 30 Reason code for discount override or rate override *****
REVENUE_DISCOUNT_PERCENTAGE NUMBER Discount Percentage is used to calculate the adjusted revenue and rate *****
REVENUE_LABOR_MULTIPLIER NUMBER Audit Column for rate derivation *****
REVENUE_MARKUP_PERCENTAGE NUMBER Audit Column for bill rate derivation. Markup Percentage used in derving bill rate was based on a markup in bill rate schedule. *****
REV_INCREMENTAL_PERCENTAGE NUMBER Revenue incremental percentage *****
REVENUE_RECOGNIZED_FLAG VARCHAR2 1 Revenue Recognized Flag to know if it is partially or fully recognized *****
TRNS_CURRENCY_CODE VARCHAR2 30 Transaction currency for the expenditure or events. *****
TRNS_CURR_REVENUE_AMT NUMBER Transaction currency revenue amount *****
CONTRACT_CURRENCY_CODE VARCHAR2 30 Identifier of the Contract currency code *****
CONT_CURR_REV_RATE_TYPE VARCHAR2 30 Contract Currency Rate Type Code *****
CONT_CURR_REV_EXCHG_RATE NUMBER Contract currency exchange rate *****
CONT_CURR_REV_EXCHG_DATE DATE Identifier of the Contract currency date *****
CONT_CURR_REVENUE_AMT NUMBER Amount in contract currency *****
REVENUE_CURR_AMT NUMBER Revenue Currency Amount *****
REVENUE_CURRENCY_CODE VARCHAR2 30 Revenue currency code *****
PROJECT_CURRENCY_CODE VARCHAR2 30 Project currency code *****
PROJECT_CURR_RATE_TYPE VARCHAR2 30 Project Currency Rate Type *****
PROJECT_CURR_EXCHG_RATE NUMBER Identifier of the Project Exchange Rate *****
PROJECT_CURRENCY_EXCHG_DATE DATE Identifier of the Project Exchange date *****
PROJECT_CURR_REVENUE_AMT NUMBER Amount in Project Currency *****
LEDGER_CURRENCY_CODE VARCHAR2 30 Ledger currency code *****
LEDGER_CURR_REV_RATE_TYPE VARCHAR2 30 Ledger Currency Rate Type *****
LEDGER_CURR_REV_EXCHG_DATE DATE Ledger Exchange date *****
LEDGER_CURR_REV_EXCHG_RATE NUMBER Ledger currency exchange rate *****
LEDGER_CURR_REVENUE_AMT NUMBER Ledger currency billed amount *****
INVOICE_DATE DATE Invoice date *****
RBS_ELEMENT_ID NUMBER 18 Identifier of resource breakdown structure element *****
TXN_ACCUM_HEADER_ID NUMBER 18 Transaction accum header id *****
PJS_SUMMARY_ID NUMBER 18 Identifier of the PJS_SUMMARY_ID *****
REVERSED_REV_DISTRIBUTION_ID NUMBER 18 Identifier of the REVERSED_REV_DISTRIBUTION_ID *****
REVERSED_FLAG VARCHAR2 1 Reversed Flag *****
LINE_NUM_REVERSED VARCHAR2 20 Reversed Line Number *****
GL_PERIOD_NAME VARCHAR2 30 GL_PERIOD_NAME *****
PA_PERIOD_NAME VARCHAR2 30 PA_PERIOD_NAME *****
GL_DATE DATE GL_DATE *****
PA_DATE DATE PA_DATE *****
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
SLA_EVENT_ID NUMBER 18 Identifier of the SLA_EVENT_ID *****
REV_BILLING_CONTROL_ID1 NUMBER 18 Identifier of billing control for revenue funding limit *****
REV_BILLING_CONTROL_ID2 NUMBER 18 Identifier of billing control for revenue funding limit *****
REV_BILLING_CONTROL_ID3 NUMBER 18 Identifier of billing control for revenue funding limit *****
REV_BILLING_CONTROL_ID4 NUMBER 18 Identifier of billing control for revenue funding limit *****
REV_BILLING_CONTROL_ID5 NUMBER 18 Identifier of billing control for revenue funding limit *****
REV_BILLING_CONTROL_ID6 NUMBER 18 Identifier of billing control for revenue funding limit *****
REV_BILLING_CONTROL_ID7 NUMBER 18 Identifier of billing control for revenue funding limit *****
REV_BILLING_CONTROL_ID8 NUMBER 18 Identifier of billing control for revenue funding limit *****
REV_BILLING_CONTROL_ID9 NUMBER 18 Identifier of billing control for revenue funding limit *****
REV_BILLING_CONTROL_ID10 NUMBER 18 Identifier of billing control for revenue funding limit *****
REV_BILLING_CONTROL_ID11 NUMBER 18 Identifier of billing control for revenue funding limit *****
REV_BILLING_CONTROL_ID12 NUMBER 18 Identifier of billing control for revenue funding limit *****
REV_BILLING_CONTROL_ID13 NUMBER 18 Identifier of billing control for revenue funding limit *****
REV_BILLING_CONTROL_ID14 NUMBER 18 Identifier of billing control for revenue funding limit *****
REV_BILLING_CONTROL_ID15 NUMBER 18 Identifier of billing control for revenue funding limit *****
REV_BILLING_CONTROL_ID16 NUMBER 18 Identifier of billing control for revenue funding limit *****
REV_BILLING_CONTROL_ID17 NUMBER 18 Identifier of billing control for revenue funding limit *****
REV_BILLING_CONTROL_ID18 NUMBER 18 Identifier of billing control for revenue funding limit *****
REV_BILLING_CONTROL_ID19 NUMBER 18 Identifier of billing control for revenue funding limit *****
REV_BILLING_CONTROL_ID20 NUMBER 18 Identifier of billing control for revenue funding limit *****
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
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.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
BILLING_TYPE_CODE VARCHAR2 30 Yes Identifies for which billing type the line has got created *****
PRVDR_LEGAL_ENTITY_ID NUMBER 18 Identifier of the PRVDR_LEGAL_ENTITY_ID *****
RECVR_LEGAL_ENTITY_ID NUMBER 18 Identifier of the RECVR_LEGAL_ENTITY_ID *****
LEDGER_ID NUMBER 18 Identifier of the LEDGER_ID *****
SYSTEM_LINKAGE_FUNCTION VARCHAR2 10 SYSTEM_LINKAGE_FUNCTION *****
BILL_JOB_ID NUMBER 18 Identifier of the BILL_JOB_ID *****
PERSON_ID NUMBER 18 Identifier of the Person Id *****
QUANTITY NUMBER Quantity as obtained from the transaction.
DENOM_RAW_COST NUMBER DENOM_RAW_COST *****
DENOM_BURDEN_COST NUMBER DENOM_BURDEN_COST *****
PROJECT_RATE_DATE_TYPE VARCHAR2 30 PROJECT_RATE_DATE_TYPE *****
LEDGER_RATE_DATE_TYPE VARCHAR2 30 LEDGER_RATE_DATE_TYPE *****
CONTRACT_RATE_DATE_TYPE VARCHAR2 30 CONTRACT_RATE_DATE_TYPE *****
REV_LABOR_RATE_TYPE_CODE VARCHAR2 30 REV_LABOR_RATE_TYPE_CODE *****
REV_NL_RATE_TYPE_CODE VARCHAR2 30 REV_NL_RATE_TYPE_CODE *****
IC_TP_AMT_TYPE_CODE VARCHAR2 30 IC_TP_AMT_TYPE_CODE *****
TP_REV_SCH_LINE_PERCENTAGE NUMBER TP_REV_SCH_LINE_PERCENTAGE *****
TP_REV_RULE_PERCENTAGE NUMBER TP_REV_RULE_PERCENTAGE *****
IC_TP_BASE_CODE VARCHAR2 30 Identifier of the IC_TP_BASE_CODE *****
INV_LABOR_RATE_TYPE_CODE VARCHAR2 30 INV_LABOR_RATE_TYPE_CODE *****
INV_NL_RATE_TYPE_CODE VARCHAR2 30 INV_NL_RATE_TYPE_CODE *****
EVENT_NUM NUMBER 18 Identifier of the Event Number *****
REV_RATE_SOURCE_TYPE_CODE VARCHAR2 30 REV_RATE_SOURCE_TYPE_CODE *****
NON_LABOR_RESOURCE_ID NUMBER 18 Identifier of the NON_LABOR_RESOURCE_ID *****
NON_LABOR_ORG_ID NUMBER 18 Identifier of the NON_LABOR_ORG_ID *****
TP_BASE_AMOUNT NUMBER Transfer Price Base Amount *****
REVENUE_CURR_RATE_TYPE VARCHAR2 30 Rate Type of the Revenue Currency.
REVENUE_CURR_DATE_TYPE VARCHAR2 30 Rate Date type of the Revenue Currency.
REVENUE_CURR_EXCHG_RATE NUMBER Exchange Rate of the Revenue Currency
REVENUE_CURR_EXCHG_DATE DATE Exchange Date of the Revenue Currency.
EXPORT_PROCESS_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the revenue export job for co-existence
CONT_CURR_OVERRIDE_ID NUMBER 18 Identifier for Contract Currency Conversion Override
REV_CURR_OVERRIDE_ID NUMBER 18 Identifer for Invoice Currency Conversion Override.
WORK_TYPE_ID NUMBER 18 Identifier for a worktype assigned to a transaction.
MIGRATION_FLAG VARCHAR2 1 Flag to indicate migrated transaction.
INVENTORY_ITEM_ID NUMBER 18 Identifier of the inventory item.
ITEM_ORGANIZATION_ID NUMBER 18 Identifier of the inventory item organization.
UOM_CODE VARCHAR2 30 Code for the unit of measure.
TRNS_CURR_UNIT_PRICE NUMBER Unit price in transaction currency.
REV_RECOGNZD_QUANTITY NUMBER Quantity that has been revenue recognized.
VRM_EXTRACTED_FLAG VARCHAR2 1 Indicates whether the revenue distribution has been extracted, hasn't yet been extracted, couldn't be extracted, or was rejected for extract to revenue management as a satisfaction event.
VRM_SATISFACTION_PERCENT NUMBER The portion, expressed as a percentage of a contract line amount, that reflects the consideration to which an entity expects to be entitled in exchange for the transfer of goods or services to customers on the revenue distribution.
CONTRACT_LINE_AMT NUMBER The contract line amount in contract currency, used to compute the satisfaction percent for revenue management.

Foreign Keys

Table Foreign Table Foreign Key Column
PJB_REV_DISTRIBUTIONS pjb_bill_trxs BILL_TRX_ID
PJB_REV_DISTRIBUTIONS okc_k_headers_all_b CONTRACT_ID, MAJOR_VERSION
PJB_REV_DISTRIBUTIONS okc_k_lines_b CONTRACT_LINE_ID, MAJOR_VERSION
PJB_REV_DISTRIBUTIONS pjf_rbs_elements RBS_ELEMENT_ID
PJB_REV_DISTRIBUTIONS egp_system_items_b INVENTORY_ITEM_ID, ITEM_ORGANIZATION_ID
pjb_acct_sweeper_logs pjb_rev_distributions REV_DISTRIBUTION_ID

Indexes

Index Uniqueness Tablespace Columns
PJB_REV_DISTRIBUTIONS_N1 Non Unique Default CONTRACT_ID, CONTRACT_LINE_ID
PJB_REV_DISTRIBUTIONS_N10 Non Unique Default LAST_UPDATE_DATE
PJB_REV_DISTRIBUTIONS_N15 Non Unique Default SLA_EVENT_ID
PJB_REV_DISTRIBUTIONS_N2 Non Unique Default TRANSACTION_PROJECT_ID
PJB_REV_DISTRIBUTIONS_N3 Non Unique Default LINKED_PROJECT_ID
PJB_REV_DISTRIBUTIONS_N4 Non Unique Default BILL_TRX_ID
PJB_REV_DISTRIBUTIONS_N5 Non Unique Default BILL_TRANSACTION_TYPE_CODE, TRANSACTION_ID
PJB_REV_DISTRIBUTIONS_N6 Non Unique Default REVERSED_FLAG, LINE_NUM_REVERSED
PJB_REV_DISTRIBUTIONS_N7 Non Unique Default ORG_ID, GL_PERIOD_NAME
PJB_REV_DISTRIBUTIONS_N8 Non Unique Default PJS_SUMMARY_ID
PJB_REV_DISTRIBUTIONS_N9 Non Unique Default REQUEST_ID
PJB_REV_DISTRIBUTIONS_U1 Unique Default REV_DISTRIBUTION_ID