PSC_ERP_JE_DET

Details

Schema: FUSION
Object owner: PSC_CC
Object type: TABLE
Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
PSC_ERP_JE_DET_LINE_PK	JE_HEADER_ID, JE_LINE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
JE_HEADER_ID	NUMBER		18	Yes	Unique identifier of a journal.	Active
JE_LINE_ID	NUMBER		18	Yes	Unique identifier of a journal line.	Active
LINE_NUMBER	NUMBER		9	Yes	System assigned sequence number for journal lines
AGENCY_ID	NUMBER		8	Yes	Agency identifier associated with this journal.	Active
EVENT_LINE_ID	NUMBER		18		Key to the associated event log entry.	Active
JOURNAL_SUM_LINE_ID	NUMBER		18		Reserved for key to summarized journal line.	Active
ACCOUNTING_DATE	DATE			Yes	Accounting Date associated with this journal.	Active
LEDGER_ID	VARCHAR2	30		Yes	Ledger this journal in intended for.	Active
ACCOUNTING_EVENT_ID	VARCHAR2	30			Accounting Event identifier associated with this journal.	Active
ACCOUNTING_RULE_GROUP	VARCHAR2	50			Accounting Rule Group, if any, associated with this journal.	Active
ACCOUNTING_RULE_ID	VARCHAR2	50			Accounting Rule identifier associated with this journal.	Active
ACCOUNT_ID	VARCHAR2	30			This column is used to indicate Account identifier.	Active
DIVISION_ID	VARCHAR2	30			This column is used to indicate Division identifier.	Active
DEPARTMENT_ID	VARCHAR2	30			This column is used to indicate Department identifier.	Active
FUND_ID	VARCHAR2	30			This column is used to indicate Fund identifier.	Active
FUNCTION_ID	VARCHAR2	30			This column is used to indicate Function identifier.	Active
PROGRAM_ID	VARCHAR2	30			This column is used to indicate Program identifier.	Active
ENTERED_DR	NUMBER			Yes	This column is used to indicate Entered debit amount.	Active
ENTERED_CR	NUMBER			Yes	This column is used to indicate Entered credit amount.	Active
CURRENCY_CODE	VARCHAR2	3		Yes	This column is used to indicate Currency code.	Active
ACCOUNTED_DR	NUMBER			Yes	This column is used to indicate Calculated debit amount.	Active
ACCOUNTED_CR	NUMBER			Yes	This column is used to indicate Calculated credit amount.	Active
BASE_CURRENCY	VARCHAR2	3		Yes	This column is used to indicate Base currency.	Active
JE_LINE_STATUS	VARCHAR2	1			This column is used to indicate Journal line status.	Active
BATCH_REQUEST_ID	VARCHAR2	30			Batch request ID that created or updated this journal.	Active
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.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active

Foreign Keys

Table	Foreign Table	Foreign Key Column
PSC_ERP_JE_DET_LINE	psc_erp_je_det_header	JE_HEADER_ID
PSC_ERP_JE_DET_LINE	psc_erp_event_trans_line	EVENT_LINE_ID
psc_erp_je_line_error	psc_erp_je_det_line	JE_HEADER_ID, JE_LINE_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
PSC_ERP_JE_DET_LINE_FK2	Non Unique	Default	EVENT_LINE_ID	Active
PSC_ERP_JE_DET_LINE_PK	Unique	Default	JE_HEADER_ID, JE_LINE_ID	Active