LM_FI_GL_AET (SQL Table)	Index Back
ELM FI GL state record. State record for Financials Integration General Ledger process.

LM_FI_GL_AET

(SQL Table)

ELM FI GL state record.

State record for Financials Integration General Ledger process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 LM_SUBLEDGER_ID Number(15,0) DECIMAL(15) NOT NULL Sub-Ledger ID. System Generated.
Prompt Table: LM_SUBLEDGER_ID

3 LM_JOURNAL_DESCR Character(30) VARCHAR2(30) NOT NULL Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.

4 LM_ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

5 LM_APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
Prompt Table: LM_JRNLGEN_TMPL

6 LM_GL_RUN_DT Date(10) DATE Run At

7 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	LM_SUBLEDGER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Sub-Ledger ID. System Generated. Prompt Table: LM_SUBLEDGER_ID
3	LM_JOURNAL_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.
4	LM_ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
5	LM_APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template Prompt Table: LM_JRNLGEN_TMPL
6	LM_GL_RUN_DT	Date(10)	DATE	Run At
7	PROCESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Process Status A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now