PJB_ACCOUNTING_EVENTS
This table is to store accounting events which are created for a Contract, Contract Line, period to balance UBR and DFR
Details
-
Schema: FUSION
-
Object owner: PJB
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PJB_ACCOUNTING_EVENTS_PK |
ACCOUNTING_EVENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ACCOUNTING_EVENT_ID | NUMBER | 18 | Yes | Accounting Event Id (Primary key of the table) ***** | |
| ACCOUNTING_EVENT_TYPE | VARCHAR2 | 30 | Yes | Type of the Accounting Event ***** | |
| CONTRACT_ID | NUMBER | 18 | Contract Id for which this event got created ***** | ||
| MAJOR_VERSION | NUMBER | 18 | Version Number of Contract for which this event got created ***** | ||
| CONTRACT_LINE_ID | NUMBER | 18 | Contract Line Id for which this event got created ***** | ||
| LINE_NUM | NUMBER | 18 | Yes | Line Number of this event for a Contract, Contract Line ***** | |
| BILLING_TYPE_CODE | VARCHAR2 | 30 | Yes | Billing Type Code of this event. Possible values are 'EX', 'IN' and 'IP' ***** | |
| ENTERED_CURR_CODE | VARCHAR2 | 30 | Yes | Currency Code of the amount for which event got created ***** | |
| ENTERED_CURR_AMT | NUMBER | Yes | Amount for which this event got created ***** | ||
| ITD_ENT_CURR_REV_AMT | NUMBER | ITD Revenue Amount in Entered Currency Code ***** | |||
| ITD_ENT_CURR_BILLED_AMT | NUMBER | ITD Billed Amount in Entered Currency Code ***** | |||
| PTD_ENT_CURR_RECLASSIFY_AMT | NUMBER | Aggregate Period to Date Reclassification Amount for this Contract, Contract Line in Entered Currency Code (Running Amount). Audit Column ***** | |||
| RECLASSIFICATION_DATE | DATE | Date on which Reclassification event got created ***** | |||
| DESCRIPTION | VARCHAR2 | 240 | Yes | Description of the event ***** | |
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| LEDGER_ID | NUMBER | 18 | Primary Ledger Id of org_id (Denormalized column) ***** | ||
| LEDGER_CURR_CODE | VARCHAR2 | 30 | Ledger Currency Code ***** | ||
| LEDGER_CURR_RATE_TYPE | VARCHAR2 | 30 | Ledger Currency Rate Type ***** | ||
| LEDGER_CURR_EXCHG_RATE | NUMBER | Ledger Currency Exchange Rate ***** | |||
| LEDGER_CURR_RATE_DATE_TYPE | VARCHAR2 | 30 | Ledger Currency Exchange Rate Date Type ***** | ||
| LEDGER_CURR_EXCHG_DATE | DATE | Ledger Currency Exchange Date ***** | |||
| LEDGER_CURR_AMT | NUMBER | Amount in Ledger Currency ***** | |||
| ACCOUNTING_DATE | DATE | Yes | End Date of GL period in which this event got created ***** | ||
| ACCOUNTING_PERIOD | VARCHAR2 | 30 | Yes | GL Period in which this event got created ***** | |
| PA_DATE | DATE | Project period in which this event got created ***** | |||
| PA_PERIOD | VARCHAR2 | 30 | Project Period in which this event got created ***** | ||
| SLA_EVENT_ID | NUMBER | 18 | SLA Event Id for the event ***** | ||
| REVERSED_ACCOUNTING_EVENT_ID | NUMBER | 18 | Accounting Event Id of the event for which reversal event is being created. For normal events, this is NULL ***** | ||
| REVERSED_FLAG | VARCHAR2 | 1 | Flag which determines whether reversal event has to be created or not ***** | ||
| REVERSED_LINE_NUM | NUMBER | 18 | Line Number of the event for which this event is reversal event (for a Contract, Contract Line). For normal events, this is NULL ***** | ||
| 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. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated 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. | |
| CONTRACT_LINE_AMT | NUMBER | Contract Line Amount for Performance Obligation Events. | |||
| CONT_CURR_ACCTTRANS_AMT | NUMBER | Accounting Transaction Amount Calculated in Contract Currency. | |||
| ITD_CONT_CURR_PERF_AMT | NUMBER | ITD Performance Obligation Amounts in Contract Currency. | |||
| CONTRACT_CURRENCY_CODE | VARCHAR2 | 30 | Identifier of the Contract Currency Code. | ||
| INVOICE_CURR_RATE_TYPE | VARCHAR2 | 30 | Rate Type for the Invoice Currency. | ||
| INVOICE_CURR_DATE_TYPE | VARCHAR2 | 30 | Rate Date type of the Invoice Currency. | ||
| INVOICE_CURR_EXCHG_RATE | NUMBER | Exchange Rate of the Invoice Currency. | |||
| INVOICE_CURR_EXCHG_DATE | DATE | Exchange Date of the Invoice Currency. | |||
| INV_CURR_OVERRIDE_ID | NUMBER | 18 | Identifier for Invoice Currency Override. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJB_ACCOUNTING_EVENTS | okc_k_headers_all_b | CONTRACT_ID, MAJOR_VERSION |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJB_ACCOUNTING_EVENTS_U1 | Unique | Default | ACCOUNTING_EVENT_ID |
| PJB_ACCOUNTING_EVENTS_U2 | Unique | Default | ACCOUNTING_EVENT_TYPE, CONTRACT_ID, CONTRACT_LINE_ID, LINE_NUM |