DW_PJB_ACCOUNTING_EN

This table stores accounting events which are created for a Contract and Contract Line and period to balance UBR and DFR

Details

Module: Project Costing

Key Columns

ACCOUNTING_EVENT_ID

Columns

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