LED_TMP_PST

(SQL View)
 Index Back

SELECT A.SETID ,A.LEDGER_GROUP ,'STANDARD' , B.LEDGER_TYPE , A.LEDGER_GROUP_TYPE , B.RECNAME , B.RECNAME_JRNL_LN , 'LEDGER_TMP' , 'LEDGER_TMP2' , 'JP_JLN_TAO' , 'LEDGER_ADB_HLD' ,B.RECNAME_SLED_STG ,B.RECNAME_LL_STG ,B.FIELDNAME_TOTAL_NT ,B.FIELDNAME_TOTAL_DR ,B.FIELDNAME_TOTAL_CR ,B.FIELDNAME_MON_AMT ,B.FIELDNAME_STAT_AMT FROM PS_LED_GRP_TBL A ,PS_LED_TMPLT_TBL B WHERE B.LEDGER_TEMPLATE = A.LEDGER_TEMPLATE AND B.LEDGER_TEMPLATE= 'STANDARD' UNION SELECT A.SETID ,A.LEDGER_GROUP ,'BUDGET' , B.LEDGER_TYPE , A.LEDGER_GROUP_TYPE , B.RECNAME ,B.RECNAME_JRNL_LN ,'LEDGER_TMP_BUDG' , 'LEDGER_TMP_BUD2' ,'JRNL_LN_TMP' , 'LEDGER_ADB_HLD' ,B.RECNAME_SLED_STG ,B.RECNAME_LL_STG ,B.FIELDNAME_TOTAL_NT ,B.FIELDNAME_TOTAL_DR ,B.FIELDNAME_TOTAL_CR ,B.FIELDNAME_MON_AMT ,B.FIELDNAME_STAT_AMT FROM PS_LED_GRP_TBL A ,PS_LED_TMPLT_TBL B WHERE B.LEDGER_TEMPLATE = A.LEDGER_TEMPLATE AND B.LEDGER_TEMPLATE= 'BUDGET' UNION SELECT A.SETID ,A.LEDGER_GROUP ,B.LEDGER_TEMPLATE , B.LEDGER_TYPE , A.LEDGER_GROUP_TYPE , B.RECNAME ,B.RECNAME_JRNL_LN ,B.RECNAME_LED_TMP , B.RECNAME_LED_TMP2 ,B.RECNAME_JRNL_TMP , 'LEDGER_ADB_HLD' ,B.RECNAME_SLED_STG ,B.RECNAME_LL_STG ,B.FIELDNAME_TOTAL_NT ,B.FIELDNAME_TOTAL_DR ,B.FIELDNAME_TOTAL_CR ,B.FIELDNAME_MON_AMT ,B.FIELDNAME_STAT_AMT FROM PS_LED_GRP_TBL A ,PS_LED_TMPLT_TBL B WHERE B.LEDGER_TEMPLATE = A.LEDGER_TEMPLATE AND B.LEDGER_TEMPLATE NOT IN ('STANDARD', 'BUDGET')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
3 LEDGER_TEMPLATE Character(10) VARCHAR2(10) NOT NULL Ledger Template
4 LEDGER_TYPE Character(1) VARCHAR2(1) NOT NULL Ledger Type
D=Detail Ledger
K=Commitment Control Ledger
S=Summary Ledger

Default Value: D

5 LEDGER_GROUP_TYPE Character(1) VARCHAR2(1) NOT NULL Ledger Group Type
A=Average Daily Balance
B=Budget
E=Commitment Control Expense
R=Commitment Control Revenue
S=Standard
T=Translation
6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: RECDEFN_VW

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

Prompt Table: RECDEFN_VW

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

Prompt Table: RECDEFN_VW

9 RECNAME_LED_TMP2 Character(15) VARCHAR2(15) NOT NULL Ledger Tmp2

Prompt Table: RECDEFN_VW

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

Prompt Table: RECDEFN_VW

11 RECNAME_ADBLD_TAO3 Character(15) VARCHAR2(15) NOT NULL Ledger ADB Tmp3
12 RECNAME_SLED_STG Character(15) VARCHAR2(15) NOT NULL Incremental Ledger Stage Tbl

Prompt Table: RECDEFN_VW

13 RECNAME_LL_STG Character(15) VARCHAR2(15) NOT NULL Ledger Load Staging table

Prompt Table: RECDEFN_VW

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

Prompt Table: RECFLDDB_VW

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

Prompt Table: RECFLDDB_VW

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

Prompt Table: RECFLDDB_VW

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

Prompt Table: RECFLD_JRNL_VW

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

Prompt Table: RECFLD_JRNL_VW