LM_ACTGLN_VW(SQL View) |
Index Back |
|---|---|
ELM Account LineELM Account Line |
| SELECT LM_SUBLEDGER_ID , LM_GL_RUN_DT , LM_SUBLEDGR_LN_NUM , LM_ACCOUNTING_DT , LM_FOREIGN_AMOUNT , LM_MONETARY_AMOUNT , LM_ACCTNG_PERIOD , LM_APPL_JRNL_ID , BUSINESS_UNIT , BUSINESS_UNIT_GL , CURRENCY_CD , LM_FISCAL_YEAR , LM_FOREIGN_CURRNCY , LM_GL_DISTRIB_STAT , LM_JOURNAL_ID , LM_JOURNAL_DATE , LM_JOURNAL_LINE , LM_LEDGER , LM_LEDGER_GROUP , PROCESS_INSTANCE , LM_JOURNAL_DESCR , RATE_MULT , RATE_DIV , %subrec(LM_CF_SBR, A) , %subrec(LM_ROWAUDIT_SBR, A) FROM PS_LM_ACCTG_LN A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LM_SUBLEDGER_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Sub-Ledger ID. System Generated. |
| 2 | LM_GL_RUN_DT |
Date(10) | DATE | Run At |
| 3 | LM_SUBLEDGR_LN_NUM |
Number(20,0) | DECIMAL(20) NOT NULL | Subledger Line Number |
| 4 | LM_ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 5 | LM_FOREIGN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item. |
| 6 | LM_MONETARY_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account. |
| 7 | LM_ACCTNG_PERIOD | Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |
| 8 | LM_APPL_JRNL_ID | Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
| 9 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 10 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | General Ledger Business Unit |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 12 | LM_FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal year |
| 13 | LM_FOREIGN_CURRNCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency |
| 14 | LM_GL_DISTRIB_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Distribute Status
C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored M=Modified N=None P=To be processed |
| 15 | LM_JOURNAL_ID | Character(10) | VARCHAR2(10) NOT NULL | Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier. |
| 16 | LM_JOURNAL_DATE | Date(10) | DATE | Specifies the date the journal was created. |
| 17 | LM_JOURNAL_LINE | Number(9,0) | DECIMAL(9) NOT NULL | Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header. |
| 18 | LM_LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 19 | LM_LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 20 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 21 | 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. |
| 22 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 23 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 24 | LM_ACCOUNT | Character(20) | VARCHAR2(20) NOT NULL |
Account Chart Field
Prompt Table: %EDITTABLE9 |
| 25 | LM_ALTACCT | Character(20) | VARCHAR2(20) NOT NULL |
Alternate Account Chartfield
Prompt Table: %EDITTABLE11 |
| 26 | LM_BUDGET_REF | Character(20) | VARCHAR2(20) NOT NULL |
Budget Reference Chartfield
Prompt Table: %EDITTABLE13 |
| 27 | LM_CHARTFIELD1 | Character(20) | VARCHAR2(20) NOT NULL |
Chartfield 1
Prompt Table: %EDITTABLE15 |
| 28 | LM_CHARTFIELD2 | Character(20) | VARCHAR2(20) NOT NULL |
Chartfield 2
Prompt Table: %EDITTABLE16 |
| 29 | LM_CHARTFIELD3 | Character(20) | VARCHAR2(20) NOT NULL |
Chartfield 3
Prompt Table: %EDITTABLE17 |
| 30 | LM_CLASS_FLD | Character(20) | VARCHAR2(20) NOT NULL |
Class Chart Field
Prompt Table: %EDITTABLE7 |
| 31 | LM_FUND_CODE | Character(20) | VARCHAR2(20) NOT NULL |
Fund Code
Prompt Table: %EDITTABLE6 |
| 32 | LM_HR_DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: LM_DEPT_CF_VW |
| 33 | LM_OPERATING_UNIT | Character(20) | VARCHAR2(20) NOT NULL |
Operating Unit ChartField
Prompt Table: %EDITTABLE12 |
| 34 | LM_PRODUCT | Character(20) | VARCHAR2(20) NOT NULL |
Product Chartfield
Prompt Table: %EDITTABLE14 |
| 35 | LM_PROGRAM_CODE | Character(20) | VARCHAR2(20) NOT NULL |
Program Chart Field
Prompt Table: %EDITTABLE8 |
| 36 | LM_PROJECT_ID | Character(20) | VARCHAR2(20) NOT NULL |
Project Chart Field
Prompt Table: %EDITTABLE10 |
| 37 | LM_ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | Datetime Added |
| 38 | LM_ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
| 39 | LM_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP | Row Maintainted DateTime |
| 40 | LM_ROW_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Maintained Oprid |