PJB_BILLING_EVENTS
PJB_BILLING_EVENTS stores events assigned to a task that generate revenue and/or billing activities that are not directly associated to the cost and revenue generated by expenditure items. . .
Details
-
Schema: FUSION
-
Object owner: PJB
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJB_BILLING_EVENTS_PK |
EVENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| EVENT_ID | NUMBER | 18 | Yes | Primary key for table. | ||
| SOURCENAME | VARCHAR2 | 80 | SOURCENAME represents the external source from where the event is created | |||
| SOURCEREF | VARCHAR2 | 80 | SOURCEREF is the event reference id in the external source. | |||
| BUSINESS_UNIT_ID | NUMBER | 18 | Yes | The identifier of Business Unit for which event is created ***** | ||
| BILLING_TYPE_CODE | VARCHAR2 | 30 | Yes | Indicates the code of Billing Type of the event whether created for External, InterCompany or InterProject Contracts. ***** | ||
| CONTRACT_ID | NUMBER | 18 | Yes | The identifier of the contract to which event is assigned. ***** | ||
| CONTRACT_LINE_ID | NUMBER | 18 | Yes | The identifier of the contract line to which event is assigned. ***** | ||
| MAJOR_VERSION | NUMBER | 18 | Yes | Major Version denotes version number of Contract/ Contract Line of Event for audit purpose. ***** | ||
| CONTRACT_TYPE_ID | NUMBER | 18 | Yes | The identifier of the contract type of the contract to which event is assigned. ***** | ||
| EVENT_NUM | NUMBER | 18 | Yes | The sequential number that identifies the event. | ||
| PROJECT_ID | NUMBER | 18 | The identifier of the project to which event is assigned. | |||
| TASK_ID | NUMBER | 18 | The identifier of the top level task to which the event is assigned | |||
| LINKAGE_ID | NUMBER | 18 | The identifier of the project contract linkage at which the event is created. ***** | |||
| LINKED_TASK_ID | NUMBER | 18 | The identifier of the linked task when task level linkage is present on the created event ***** | |||
| EVENT_TYPE_ID | NUMBER | 18 | Yes | Identifier of the event type ***** | ||
| EVENT_TYPE_CODE | VARCHAR2 | 1 | Yes | The event type that classifies the event whether applicable for Revenue/ Invoice or both ***** | ||
| COMPLETION_DATE | DATE | The date on which the event is complete and on or after which the event is processed for revenue accrual and/or invoicing | ||||
| EVENT_DESC | VARCHAR2 | 240 | Yes | The free text description of the event. For billing events, the description is displayed as the invoice line description ***** | ||
| ADJUST_DESC | VARCHAR2 | 240 | The free text adjust description of the event. For billing events, the description is displayed for the SLA description ***** | |||
| ORGANIZATION_ID | NUMBER | 18 | Yes | The unique identifier of the organization for the event. For example, this may be used to credit revenue to different organization. | ||
| BILL_TRNS_AMOUNT | NUMBER | Yes | Event amount in Bill transaction currency ***** | |||
| BILL_TRNS_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Transaction currency code of the event. ***** | ||
| BILL_HOLD_FLAG | VARCHAR2 | 1 | Flag that indicates that the event is held from invoicing | |||
| REVENUE_HOLD_FLAG | VARCHAR2 | 1 | This column indicates whether this event is on hold for revenue processing or not.Valid values Y or N. | |||
| REVERSE_ACCRUAL_FLAG | VARCHAR2 | 1 | Flag that indicates whether or not the event should automatically reverse in the next period ***** | |||
| AUTOMATIC_FLAG | VARCHAR2 | 1 | Flag that indicates that the event created is automatic event ***** | |||
| CALC_ELEMENT_CODE | VARCHAR2 | 30 | Indicates the code of Calculation Element whether event is created from Percent Spent ('PS') or Percent Complete ('PC'). ***** | |||
| BILLING_EXTENSION_ID | NUMBER | 18 | The unique identifier of billing extension that is basis for creating the automatic event ***** | |||
| BILLING_ASSIGNMENT_ID | NUMBER | 18 | The unique identifier of billing extention assignment that is basis for creating the automatic event. | |||
| BILLING_ASGMT_DETAIL_ID | NUMBER | 18 | The unique identifier of billing assignment details that is basis for creating the automatic event ***** | |||
| RBS_ELEMENT_ID | NUMBER | 18 | The identifier of resource billing element. ***** | |||
| ADJUSTED_EVENT_ID | NUMBER | 18 | The identifier of the event from which it is adjusted ***** | |||
| EVENT_NUM_REVERSED | NUMBER | 18 | The event_num of the event that this automatic event is reversing when the invoice that the original event was on gets cancelled. | |||
| TXN_ACCUM_HEADER_ID | NUMBER | 18 | Transaction header identifier ***** | |||
| BILL_CURR_OPT_CODE | VARCHAR2 | 30 | Indicates the code of Billing currency used for invoicing whether it should be Contract currency or transaction currency. ***** | |||
| CALL_LOCATION | VARCHAR2 | 30 | The place in the program that called the Billing Extension which created this event ***** | |||
| CALL_PROCESS | VARCHAR2 | 30 | The process that called the Billing Extension that created this event ***** | |||
| AUDIT_COST_PLAN_TYPE_ID | NUMBER | 18 | Audit cost Fin Plan id used for calculation of cost Fin plan amounts | |||
| AUDIT_REV_PLAN_TYPE_ID | NUMBER | 18 | Audit revenue fin plan id used for calculation of revenue Fin Plan amounts | |||
| CONTRACT_CURR_AMT | NUMBER | Event amount in Contract Currency. ***** | ||||
| CONTRACT_CURR_CODE | VARCHAR2 | 30 | Currency of Contract entered on the event. ***** | |||
| CONTRACT_CURR_RATE_TYPE | VARCHAR2 | 30 | Rate Type of the Contract Currency. ***** | |||
| CONTRACT_CURR_EXCHG_RATE | NUMBER | Exchange Rate of the Contract Currency. ***** | ||||
| CONTRACT_CURR_EXCHG_DATE | DATE | Exchange Date of the Contract Currency. ***** | ||||
| CONTRACT_RATE_DATE_TYPE | VARCHAR2 | 30 | Rate Date Type of the Contract Currency. ***** | |||
| INVOICED_FLAG | VARCHAR2 | 1 | Flag that indicates revenue is generated on the event ('P'-Partial, 'U'-Uninvoiced, 'F'-Fully) ***** | |||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 30 | Invoice currency code ***** | |||
| INVOICED_AMT | NUMBER | Invoice amount in Invoice Currency ***** | ||||
| INVOICED_PERCENTAGE | NUMBER | Invoiced Percentage ***** | ||||
| REVENUE_RECOGNZD_FLAG | VARCHAR2 | 1 | Flag that indicates revenue is generated on the event ('P'-Partial, 'U'-Unrecognized, 'F'-Fully) ***** | |||
| REVENUE_CURRENCY_CODE | VARCHAR2 | 30 | Revenue currency code ***** | |||
| REVENUE_RECOGNZD_PERCENTAGE | NUMBER | Revenue accrued percenatge ***** | ||||
| REVENUE_AMT | NUMBER | Revenue amount in Revenue Currency ***** | ||||
| LEDGER_CURRENCY_CODE | VARCHAR2 | 30 | Ledger currency code ***** | |||
| LEDGER_REVENUE_AMT | NUMBER | Revenue amount in Ledger currency ***** | ||||
| LEDGER_INVOICE_AMT | NUMBER | Invoice amount in Ledger currency ***** | ||||
| PROJECT_CURRENCY_CODE | VARCHAR2 | 30 | Project currency code. | |||
| PROJECT_REVENUE_AMT | NUMBER | Revenue Amount in Project Currency. This is calculated by applying the Project Currency setup conversion rules to the bill transaction base revenue amount during revenue generation. ***** | ||||
| PROJECT_INVOICE_AMT | NUMBER | Invoice Amount in Project Currency ***** | ||||
| NON_UPDATEABLE_FLAG | VARCHAR2 | 1 | This column indicates whether event is updateable or not.Valid values Y or N. | |||
| REVENUE_EXCEPTION_FLAG | VARCHAR2 | 1 | Yes | This column indicates whether exception occured on the event during revenue generation. ***** | ||
| INVOICE_EXCEPTION_FLAG | VARCHAR2 | 1 | Yes | This column indicates whether exception occured on the event during invoice generation. ***** | ||
| CALCULATION_INVOICE_ID | NUMBER | 18 | The identifier of the invoice to be stamped on automatic event created from Invoice processing. ***** | |||
| QUANTITY_BILLED | NUMBER | Quantity that has been invoiced. | ||||
| UOM_CODE | VARCHAR2 | 3 | Unit of measure of the inventory item on the event. | |||
| UNIT_PRICE | NUMBER | Unit price of the inventory item on the event. | ||||
| INVOICE_CURR_POT_AMT | NUMBER | Potential Amount of the Invoice Currency | ||||
| INVOICE_CURR_RATE_TYPE | VARCHAR2 | 30 | Rate Type of Invoice Currency | |||
| INVOICE_CURR_DATE_TYPE | VARCHAR2 | 30 | Rate Date Type of Invoice Currency | |||
| INVOICE_CURR_EXCHG_RATE | NUMBER | Exchange Rate of Invoice Currency | ||||
| INVOICE_CURR_EXCHG_DATE | DATE | Exchange Date of Invoice Currency | ||||
| INV_EXCLUDE_FLAG | VARCHAR2 | 1 | Exclude Events Processing if Invoice is in Approved/Rejected/Submitted status | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Billing Events (PJB_BILLING_EVENTS_FLEX) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Events (PJB_BILLING_EVENTS_FLEX) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Events (PJB_BILLING_EVENTS_FLEX) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Events (PJB_BILLING_EVENTS_FLEX) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Events (PJB_BILLING_EVENTS_FLEX) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Events (PJB_BILLING_EVENTS_FLEX) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Events (PJB_BILLING_EVENTS_FLEX) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Events (PJB_BILLING_EVENTS_FLEX) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Events (PJB_BILLING_EVENTS_FLEX) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Events (PJB_BILLING_EVENTS_FLEX) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Events (PJB_BILLING_EVENTS_FLEX) | ||
| AUDIT_AMT1 | NUMBER | Audit amount column to know the audit amounts for events with automatic event type classification ***** | ||||
| AUDIT_AMT2 | NUMBER | Audit amount column to know the audit amounts for events with automatic event type classification ***** | ||||
| AUDIT_AMT3 | NUMBER | Audit amount column to know the audit amounts for events with automatic event type classification ***** | ||||
| AUDIT_AMT4 | NUMBER | Audit amount column to know the audit amounts for events with automatic event type classification ***** | ||||
| AUDIT_AMT5 | NUMBER | Audit amount column to know the audit amounts for events with automatic event type classification ***** | ||||
| AUDIT_AMT6 | NUMBER | Audit amount column to know the audit amounts for events with automatic event type classification ***** | ||||
| AUDIT_AMT7 | NUMBER | Audit amount column to know the audit amounts for events with automatic event type classification ***** | ||||
| AUDIT_AMT8 | NUMBER | Audit amount column to know the audit amounts for events with automatic event type classification ***** | ||||
| AUDIT_AMT9 | NUMBER | Audit amount column to know the audit amounts for events with automatic event type classification ***** | ||||
| AUDIT_AMT10 | NUMBER | Audit amount column to know the audit amounts for events with automatic event type classification ***** | ||||
| REFERENCE1 | VARCHAR2 | 240 | Generic Reference Column | |||
| REFERENCE2 | VARCHAR2 | 240 | Generic Reference Column | |||
| REFERENCE3 | VARCHAR2 | 240 | Generic Reference Column | |||
| REFERENCE4 | VARCHAR2 | 240 | Generic Reference Column | |||
| REFERENCE5 | VARCHAR2 | 240 | Generic Reference Column | |||
| REFERENCE6 | VARCHAR2 | 240 | Generic Reference Column | |||
| REFERENCE7 | VARCHAR2 | 240 | Generic Reference Column | |||
| REFERENCE8 | VARCHAR2 | 240 | Generic Reference Column | |||
| REFERENCE9 | VARCHAR2 | 240 | Generic Reference Column | |||
| REFERENCE10 | VARCHAR2 | 240 | Generic Reference Column | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| 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. | |||
| CREATED_REQUEST_ID | NUMBER | 20 | Identifier of the latest created request. ***** | |||
| 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. | ||
| CONT_CURR_OVERRIDE_ID | NUMBER | 18 | Identifier for Contract Currency Conversion Override. | |||
| INV_CURR_OVERRIDE_ID | NUMBER | 18 | Identifier for Invoice Currency Conversion Override. | |||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR21 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR22 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR23 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR24 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR25 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR26 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR27 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR28 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR29 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR30 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| INVENTORY_ITEM_ID | NUMBER | 18 | Identifier of the inventory item. | |||
| ITEM_ORGANIZATION_ID | NUMBER | 18 | Identifier of the inventory item organization. | |||
| QUANTITY | NUMBER | Quantity of the inventory item on the event. | ||||
| QUANTITY_REV_RECOGNZD | NUMBER | Quantity that has been revenue recognized. | ||||
| ITEM_EVENT_FLAG | VARCHAR2 | 1 | Yes | Indicates if the event is item based or non-item based. If the value is Y, the event is item based and item and quantity should be populated on the event. If the value is N, event is non item based and amount should be populated on the event. | ||
| CONTRACT_EVENT_ID | NUMBER | 18 | Unique identifier of the contract event, such as a milestone. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJB_BILLING_EVENTS | pjf_projects_all_b | PROJECT_ID |
| PJB_BILLING_EVENTS | pjf_proj_elements_b | TASK_ID |
| PJB_BILLING_EVENTS | egp_system_items_b | INVENTORY_ITEM_ID, ITEM_ORGANIZATION_ID |
| pjb_errors | pjb_billing_events | EVENT_ID |
| pjb_calculation_elements | pjb_billing_events | EVENT_ID |
| pjb_event_adj_activities | pjb_billing_events | EVENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJB_BILLING_EVENTS_N1 | Non Unique | Default | BILLING_ASSIGNMENT_ID |
| PJB_BILLING_EVENTS_N10 | Non Unique | Default | COMPLETION_DATE |
| PJB_BILLING_EVENTS_N11 | Non Unique | Default | REQUEST_ID |
| PJB_BILLING_EVENTS_N12 | Non Unique | Default | PROJECT_ID, TASK_ID |
| PJB_BILLING_EVENTS_N13 | Non Unique | Default | ADJUSTED_EVENT_ID, EVENT_NUM_REVERSED |
| PJB_BILLING_EVENTS_N14 | Non Unique | Default | CALC_ELEMENT_CODE, AUTOMATIC_FLAG |
| PJB_BILLING_EVENTS_N15 | Non Unique | Default | REVENUE_HOLD_FLAG |
| PJB_BILLING_EVENTS_N16 | Non Unique | Default | REVERSE_ACCRUAL_FLAG |
| PJB_BILLING_EVENTS_N17 | Non Unique | Default | BILL_HOLD_FLAG |
| PJB_BILLING_EVENTS_N18 | Non Unique | Default | INVOICED_FLAG, REQUEST_ID |
| PJB_BILLING_EVENTS_N19 | Non Unique | Default | REVENUE_RECOGNZD_FLAG, REQUEST_ID |
| PJB_BILLING_EVENTS_N2 | Non Unique | Default | EVENT_TYPE_CODE, EVENT_TYPE_ID |
| PJB_BILLING_EVENTS_N20 | Non Unique | Default | BILL_TRNS_AMOUNT |
| PJB_BILLING_EVENTS_N21 | Non Unique | Default | BILL_TRNS_CURRENCY_CODE |
| PJB_BILLING_EVENTS_N22 | Non Unique | Default | CONTRACT_CURR_AMT |
| PJB_BILLING_EVENTS_N23 | Non Unique | Default | CONTRACT_TYPE_ID |
| PJB_BILLING_EVENTS_N24 | Non Unique | Default | LAST_UPDATE_DATE |
| PJB_BILLING_EVENTS_N25 | Non Unique | PJB_BILLING_EVENTS_N25 | INVENTORY_ITEM_ID, ITEM_ORGANIZATION_ID |
| PJB_BILLING_EVENTS_N3 | Non Unique | Default | BUSINESS_UNIT_ID, BILLING_TYPE_CODE, CONTRACT_ID, CONTRACT_EVENT_ID, CONTRACT_LINE_ID |
| PJB_BILLING_EVENTS_N6 | Non Unique | Default | EVENT_NUM |
| PJB_BILLING_EVENTS_N7 | Non Unique | Default | LINKAGE_ID, CONTRACT_ID, CONTRACT_LINE_ID, PROJECT_ID |
| PJB_BILLING_EVENTS_N8 | Non Unique | Default | LINKAGE_ID, LINKED_TASK_ID |
| PJB_BILLING_EVENTS_N9 | Non Unique | Default | RBS_ELEMENT_ID |
| PJB_BILLING_EVENTS_U1 | Unique | Default | CONTRACT_ID, EVENT_NUM, CONTRACT_LINE_ID |
| PJB_BILLING_EVENTS_U2 | Unique | Default | EVENT_ID |
| PJB_BILLING_EVENTS_U3 | Unique | Default | SOURCENAME, SOURCEREF |