LM_LDGR_ACCT_VW (SQL View)	Index Back
Accounting Detail Sub-Ledger Inqury Accounting Detail Page

LM_LDGR_ACCT_VW

(SQL View)

Accounting Detail

Sub-Ledger Inqury Accounting Detail Page

SELECT C.LM_SUBLEDGER_ID ,C.LM_SUBLEDGR_LN_NUM ,C.LM_ROW_MAINT_OPRID ,C.LM_JOURNAL_ID ,C.LM_JOURNAL_DATE ,C.LM_ACCOUNTING_DT FROM PS_LM_ACCTG_LN C

# 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_SUBLEDGR_LN_NUM Number(20,0) DECIMAL(20) NOT NULL Subledger Line Number

3 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid

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

5 LM_JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.

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

#	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_SUBLEDGR_LN_NUM	Number(20,0)	DECIMAL(20) NOT NULL	Subledger Line Number
3	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid
4	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.
5	LM_JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
6	LM_ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple