PROCESS_INSTANCEERR=Error
OLD=History Item Not Posted
PEN=Pending
POS=Posted
UPD=Updated Since Posting
LM_FI_PREV_AET(SQL Table) |
Index Back |
|---|---|
Enrollment Intfc Previous LinePrevious Subledger Line for an Enrollment |
| # | 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. |
| 3 | LM_SUBLEDGR_LN_NUM | Number(20,0) | DECIMAL(20) NOT NULL | Subledger Line Number |
| 4 | LM_SUBLEDG_GL_STAT | Character(3) | VARCHAR2(3) NOT NULL |
Subledger Flag is used on the ELM Subledger. It indicates if a row on the Subledger has already been sent to GL.
ERR=Error OLD=History Item Not Posted PEN=Pending POS=Posted UPD=Updated Since Posting |
| 5 | LM_ENRLMT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Enrollment ID |