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 |