LED_DEFN_VW

(SQL View)
Index Back

Ledger Defn/Template View


SELECT A.SETID ,A.LEDGER ,A.DESCR ,A.EFFDT , B.LEDGER_TEMPLATE ,B.LEDGER_TYPE ,B.RECNAME , B.RECNAME_JRNL_HDR ,B.RECNAME_JHDR_TMP , B.RECNAME_JRNL_LN ,B.RECNAME_LED_TMP , B.RECNAME_LED_TMP2 , B.RECNAME_ADB_LED ,B.RECNAME_JRNL_TMP , B.RECNAME_JRNLGEN ,B.RECNAME_RPTG_VW , B.RECNAME_ACCOUNT ,B.RECNAME_CONSOL_LOG , B.RECNAME_CURR_WRK ,B.RECNAME_CURR_LOG , B.RECNAME_CLOSE_LOG ,B.RECNAME_CLOSE_TMP , B.RECNAME_EARN_TMP ,B.FIELDNAME_TOTAL_NT , B.FIELDNAME_TOTAL_DR ,B.FIELDNAME_TOTAL_CR , B.FIELDNAME_MON_AMT ,B.FIELDNAME_STAT_AMT , B.FIELDNAME_ACCOUNT FROM PS_LED_DEFN_TBL A , PS_LED_TMPLT_TBL B WHERE A.LEDGER_TEMPLATE = B.LEDGER_TEMPLATE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 EFFDT Date(10) DATE Effective Date
5 LEDGER_TEMPLATE Character(10) VARCHAR2(10) NOT NULL Ledger Template
6 LEDGER_TYPE Character(1) VARCHAR2(1) NOT NULL Ledger Type
D=Detail Ledger
K=Commitment Control Ledger
S=Summary Ledger
7 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: RECDEFN_VW

8 RECNAME_JRNL_HDR Character(15) VARCHAR2(15) NOT NULL Journal Header

Prompt Table: RECDEFN_VW

9 RECNAME_JHDR_TMP Character(15) VARCHAR2(15) NOT NULL Journal Header Tmp

Prompt Table: RECDEFN_VW

10 RECNAME_JRNL_LN Character(15) VARCHAR2(15) NOT NULL Journal Line

Prompt Table: RECDEFN_VW

11 RECNAME_LED_TMP Character(15) VARCHAR2(15) NOT NULL Ledger Tmp

Prompt Table: RECDEFN_VW

12 RECNAME_LED_TMP2 Character(15) VARCHAR2(15) NOT NULL Ledger Tmp2
13 RECNAME_ADB_LED Character(15) VARCHAR2(15) NOT NULL ADB Ledger

Prompt Table: RECDEFN_VW

14 RECNAME_JRNL_TMP Character(15) VARCHAR2(15) NOT NULL Journal Line Tmp

Prompt Table: RECDEFN_VW

15 RECNAME_JRNLGEN Character(15) VARCHAR2(15) NOT NULL Jrnl Gen Tmp
16 RECNAME_RPTG_VW Character(15) VARCHAR2(15) NOT NULL Secured Rptg Vw

Prompt Table: RECDEFN_VW

17 RECNAME_ACCOUNT Character(15) VARCHAR2(15) NOT NULL Account ChartField

Prompt Table: RECDEFN_VW

18 RECNAME_CONSOL_LOG Character(15) VARCHAR2(15) NOT NULL Consolidations Log

Prompt Table: RECDEFN_VW

19 RECNAME_CURR_WRK Character(15) VARCHAR2(15) NOT NULL MultiCurrency Tmp

Prompt Table: RECDEFN_VW

20 RECNAME_CURR_LOG Character(15) VARCHAR2(15) NOT NULL MultiCurrency Log

Prompt Table: RECDEFN_VW

21 RECNAME_CLOSE_LOG Character(15) VARCHAR2(15) NOT NULL Closing Log

Prompt Table: RECDEFN_VW

22 RECNAME_CLOSE_TMP Character(15) VARCHAR2(15) NOT NULL Closing Tmp

Prompt Table: RECDEFN_VW

23 RECNAME_EARN_TMP Character(15) VARCHAR2(15) NOT NULL Closing RE Tmp

Prompt Table: RECDEFN_VW

24 FIELDNAME_TOTAL_NT Character(18) VARCHAR2(18) NOT NULL Posted Total Amount

Prompt Table: RECFIELD_VW

25 FIELDNAME_TOTAL_DR Character(18) VARCHAR2(18) NOT NULL Posted Total Debits

Prompt Table: RECFIELD_VW

26 FIELDNAME_TOTAL_CR Character(18) VARCHAR2(18) NOT NULL Posted Total Credits

Prompt Table: RECFIELD_VW

27 FIELDNAME_MON_AMT Character(18) VARCHAR2(18) NOT NULL Monetary Amount

Prompt Table: RECFLD_JRNL_VW

28 FIELDNAME_STAT_AMT Character(18) VARCHAR2(18) NOT NULL Statistical Amount

Prompt Table: RECFLD_JRNL_VW

29 FIELDNAME_ACCOUNT Character(18) VARCHAR2(18) NOT NULL Account

Prompt Table: RECFLD_ACCT2_VW