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