NVS_LEDGER_VW

(SQL View)
 Index Back

Ledger Info for nVision Rptg


SELECT l.setid ,b.business_unit ,l.ledger ,t.recname ,t.recname_rptg_vw ,t.fieldname_total_cr ,t.fieldname_total_dr ,t.fieldname_total_nt ,l.ledger_type ,b.detail_ledger ,g.inherit_base_cur ,g.base_currency ,b.calendar_id FROM ps_led_defn_tbl l , ps_led_grp_led_tbl g , ps_led_tmplt_tbl t , PS_BU_LED_GRP_TBL b , PS_BU_LED_GRP_TBL s WHERE t.ledger_template = l.ledger_template AND g.ledger_group=s.ledger_group AND s.business_unit=b.business_unit AND g.setid = l.setid AND (( g.ledger = l.ledger AND b.ledger_group = g.ledger_group AND b.ledger_type <> 'S') OR ( g.ledger = B.detail_ledger AND b.ledger=L.ledger AND b.ledger_type = 'S') )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
5 RECNAME_RPTG_VW Character(15) VARCHAR2(15) NOT NULL Secured Rptg Vw
6 FIELDNAME_TOTAL_CR Character(18) VARCHAR2(18) NOT NULL Posted Total Credits
7 FIELDNAME_TOTAL_DR Character(18) VARCHAR2(18) NOT NULL Posted Total Debits
8 FIELDNAME_TOTAL_NT Character(18) VARCHAR2(18) NOT NULL Posted Total Amount
9 LEDGER_TYPE Character(1) VARCHAR2(1) NOT NULL Ledger Type
D=Detail Ledger
K=Commitment Control Ledger
S=Summary Ledger
10 DETAIL_LEDGER Character(10) VARCHAR2(10) NOT NULL Detail Ledger ID
11 INHERIT_BASE_CUR Character(1) VARCHAR2(1) NOT NULL Inherit Base Currency
12 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
13 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID