This table stores accounting events which are created for a Contract and Contract Line and period to balance UBR and DFR
Module: Project Costing
ACCOUNTING_EVENT_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
ACCOUNTING_EVENT_ID | NUMBER | 38 | 0 | True | Accounting Event Id (Primary key of the table) | ||
SOURCE_RECORD_ID | VARCHAR2 | 32 | Type of the Accounting Event | ||||
SUBLEDGER_LINKAGE_HDR_ENTITY_ID | VARCHAR2 | 32 | Accounting Event Id | ||||
ACCOUNTING_EVENT_TYPE | VARCHAR2 | 32 | Type of the Accounting Event | ||||
CONTRACT_ID | NUMBER | 38 | 0 | Contract Id for which this event got created | |||
MAJOR_VERSION | NUMBER | 38 | 0 | Version Number of Contract for which this event got created | |||
CONTRACT_LINE_ID | NUMBER | 38 | 0 | Contract Line Id for which this event got created | |||
LINE_NUM | NUMBER | 38 | 0 | Line Number of this event for a Contract, Contract Line | |||
BILLING_TYPE_CODE | VARCHAR2 | 32 | Billing Type Code of this event. Possible values are 'EX', 'IN' and 'IP' | ||||
ENTERED_CURR_CODE | VARCHAR2 | 32 | Currency Code of the amount for which event got created | ||||
ENTERED_CURR_AMT | NUMBER | 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 | 256 | Description of the event | ||||
ORG_ID | NUMBER | 38 | 0 | Indicates the identifier of the business unit associated to the row. | |||
LEDGER_ID | NUMBER | 38 | 0 | Primary Ledger Id of org_id (Denormalized column) | |||
LEDGER_CURR_CODE | VARCHAR2 | 32 | Ledger Currency Code | ||||
LEDGER_CURR_RATE_TYPE | VARCHAR2 | 32 | Ledger Currency Rate Type | ||||
LEDGER_CURR_EXCHG_RATE | NUMBER | Ledger Currency Exchange Rate | |||||
LEDGER_CURR_RATE_DATE_TYPE | VARCHAR2 | 32 | 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 | End Date of GL period in which this event got created | |||||
ACCOUNTING_PERIOD | VARCHAR2 | 32 | GL Period in which this event got created | ||||
PA_DATE | DATE | Project period in which this event got created | |||||
PA_PERIOD | VARCHAR2 | 32 | Project Period in which this event got created | ||||
SLA_EVENT_ID | NUMBER | 38 | 0 | SLA Event Id for the event | |||
REVERSED_ACCOUNTING_EVENT_ID | NUMBER | 38 | 0 | Accounting Event Id of the event for which reversal event is being created. For normal events, this is NULL | |||
REVERSED_FLAG | VARCHAR2 | 16 | Flag which determines whether reversal event has to be created or not | ||||
REVERSED_LINE_NUM | NUMBER | 38 | 0 | 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 | 38 | 0 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
JOB_DEFINITION_NAME | VARCHAR2 | 128 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 1024 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
CREATED_BY | VARCHAR2 | 128 | Who column: indicates the user who created the row. | ||||
LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||||
LAST_UPDATED_BY | VARCHAR2 | 128 | Who column: indicates the user who last updated the row. | ||||
LAST_UPDATE_LOGIN | VARCHAR2 | 64 | Who column: indicates the session login associated to the user who last updated the row. | ||||
OBJECT_VERSION_NUMBER | NUMBER | 38 | 0 | 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 | 32 | Identifier of the Contract Currency Code. | ||||
INVOICE_CURR_RATE_TYPE | VARCHAR2 | 32 | Rate Type for the Invoice Currency. | ||||
INVOICE_CURR_DATE_TYPE | VARCHAR2 | 32 | 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 | 38 | 0 | Identifier for Invoice Currency Override. |