PeopleSoft

General Ledger Tables

Set Up Tables
Set ID and Set Control Tables
PS_SETID_TBL
PS_SET_CNTRL_TBL
PS_SET_CNTRL_GROUP
PS_SET_CNTRL_REC

Installation Options

SELECT * FROM PS_INSTALLATION;

SELECT * FROM PS_INSTALLATION_AM;

SELECT * FROM PS_INSTALLATION_AP;

SELECT * FROM PS_INSTALLATION_AR;

SELECT * FROM PS_INSTALLATION_AU;

SELECT * FROM PS_INSTALLATION_BI;

SELECT * FROM PS_INSTALLATION_CA;

SELECT * FROM PS_INSTALLATION_CS;

SELECT * FROM PS_INSTALLATION_CU;

SELECT * FROM PS_INSTALLATION_DC;

SELECT * FROM PS_INSTALLATION_EE;

SELECT * FROM PS_INSTALLATION_EM;

SELECT * FROM PS_INSTALLATION_EX;

SELECT * FROM PS_INSTALLATION_FD;

SELECT * FROM PS_INSTALLATION_FG;

SELECT * FROM PS_INSTALLATION_FO;

SELECT * FROM PS_INSTALLATION_FS;

SELECT * FROM PS_INSTALLATION_GL;

SELECT * FROM PS_INSTALLATION_GM;

SELECT * FROM PS_INSTALLATION_IN;

SELECT * FROM PS_INSTALLATION_KK;

SELECT * FROM PS_INSTALLATION_MG;

SELECT * FROM PS_INSTALLATION_OM;

SELECT * FROM PS_INSTALLATION_PC;

SELECT * FROM PS_INSTALLATION_PL;

SELECT * FROM PS_INSTALLATION_PO;

SELECT * FROM PS_INSTALLATION_RE;

SELECT * FROM PS_INSTALLATION_RS;

SELECT * FROM PS_INSTALLATION_SP;

SELECT * FROM PS_INSTALLATION_TR;

SELECT * FROM PS_INSTALLATION_WM;

SELECT * FROM PS_INSTALLATION_WV;

SELECT * FROM PS_INSTALL_AMINTFC;

SELECT * FROM PS_INSTALL_PGM;

SELECT * FROM PS_ACCT_ATTRIB_TBL;

SELECT * FROM PS_ALT_CHAR_TBL;

SELECT * FROM PS_PARALLEL_AR;

SELECT * FROM PS_RS_INSTALLTN_TT;

SELECT * FROM PS_SDN_SRCH_LISTS;

SELECT * FROM PS_SDN_SRCH_SETUP;

--Tax Provider Information

SELECT * FROM PS_TAX_PROV_INFO;

COUNTRY & STATE TABLE

SELECT * FROM PS_COUNTRY_TBL;

SELECT * FROM PS_STATE_TBL;

SELECT * FROM PS_CNTRY_STAT_TBL;

CURRENCY CODE & RATES

SELECT * FROM PS_CURRENCY_CD_TBL;

SELECT * FROM PS_CURRENCY_EURO;

SELECT * FROM PS_RT_INDEX_TBL;

SELECT * FROM PS_RT_TYPE_TBL;

SELECT * FROM PS_RT_RATE_DEF_TBL;

SELECT * FROM PS_CURR_QUOTE_TBL;

SELECT * FROM PS_RT_RATE_TBL;

Unit of Measure

PS_UNITS_CVT_TBL
PS_UNITS_TBL

LOCATION TABLES

SELECT * FROM PS_LOCATION_TBL;

SELECT * FROM PS_DIV_AREA_CD;

--Account Type

SELECT * FROM PS_ACCT_TYPE_TBL;

--Department Table

SELECT * FROM PS_DEPT_TBL;

SELECT * FROM PS_CF_ATTRIB_TBL;

SELECT * FROM PS_CF_ATTRIB_VALUE;

SELECT * FROM PS_PERSONAL_DATA;

--Adjustment Type

SELECT * FROM PS_ADJUST_TYPE_TBL;

--Alt Account

SELECT * FROM PS_ALTACCT_TBL;

--Budget Scenarios

SELECT * FROM PS_BD_SCENARIO_TBL;

--Book Code

SELECT * FROM PS_BOOK_CODE_TBL;

--Book Code Distribution Group

SELECT * FROM PS_BKC_DST_GRP_DTL;

SELECT * FROM PS_BKC_DST_GRP_TBL;

--Budget Reference

SELECT * FROM PS_BUD_REF_TBL;

SELECT * FROM PS_CF_ATTRIB_TBL;

SELECT * FROM PS_CF_ATTRIB_VALUE;

--Chartfield Attribute

SELECT * FROM PS_ATTRIBUTE_TBL;

SELECT * FROM PS_CF_ATTRIB_VALUE;

--Chartfield1,2,3

SELECT * FROM PS_CHARTFIELD1_TBL;

SELECT * FROM PS_CHARTFIELD2_TBL;

SELECT * FROM PS_CHARTFIELD3_TBL;

--Class

SELECT * FROM PS_CLASS_CF_TBL;

--Fund Code

SELECT * FROM PS_FUND_TBL;

--Operating Unit

SELECT * FROM PS_OPER_UNIT_TBL;

--GL Account

SELECT Account FROM PS_GL_ACCOUNT_TBL where account like '106%' and eff_status = 'A';

--Product

SELECT * FROM PS_PRODUCT_TBL;

--Program

SELECT * FROM PS_PROGRAM_TBL;

--Project

SELECT * FROM PS_PROJECT;

--Statistics Code

SELECT * FROM PS_STAT_TBL;

--Chartfield Inheritance

SELECT * FROM PS_CF_INHERIT_TBL;

SELECT * FROM PS_FS_CF_TEMPLATE;

--Account Balancing Group

SELECT * FROM PS_ACCT_ATTRIB_TBL;

SELECT * FROM PS_ACT_BAL_GRP;

SELECT * FROM PS_ACT_BAL_GRP_DTL;

--Combination Editing

SELECT * FROM PS_COMBO_CF_DEFN;

SELECT * FROM PS_COMBO_FLDS_TBL;

--Detail Calendar

SELECT * FROM PS_BUS_UNIT_TBL_AM;

SELECT * FROM PS_CAL_ADJP_TBL;

SELECT * FROM PS_CAL_DEFN_TBL;

SELECT * FROM PS_CAL_DETP_TBL;

SELECT * FROM PS_DEPR_CAL_CV_TBL;

--Budget Period Calander

SELECT * FROM PS_CAL_BP_TBL;

SELECT * FROM PS_CAL_DEFN_TBL;

--Schedules

SELECT * FROM PS_EVENTS_TBL;

SELECT * FROM PS_PSOPTIONS;

SELECT * FROM PS_SCHEDULE_TBL;

--InterUnit Map

SELECT * FROM PS_IU_SYS_TRAN_TBL;

SELECT * FROM PS_IU_TRAN_CD_TBL;

SELECT * FROM PS_IU_TRAN_MAP_OPT;

SELECT * FROM PS_IU_TRAN_MAP_TBL;

--Journal Class

SELECT * FROM PS_JRNL_CLASS_TBL;

--Entry Event Process

SELECT * FROM PS_EE_PRCS_HDR;

SELECT * FROM PS_EE_PRCS_STEP;

SELECT * FROM PS_EE_STEP_FLDS;

--Bank Related

SELECT * FROM PS_BNK_ID_QUAL_TBL;

SELECT * FROM PS_IBAN_FORMAT_TBL;

SELECT * FROM PS_CM_LC_GROUP;

--Payment Format

SELECT * FROM PS_PYMNT_FMT_TBL;

--Agency Loc

SELECT * FROM PS_AGENCY_LOC_CD;

SELECT * FROM PS_AGENCY_LOC_CD2;

--Region Code

SELECT * FROM PS_CARRIER_ID;

SELECT * FROM PS_REGION_CD;

SELECT * FROM PS_REGION_CD_PHONE;

SELECT * FROM PS_REGION_TYPE;

SELECT * FROM PS_REGION_VNDR_LOC;

--Ship Via Code

SELECT * FROM PS_SHIP_METHOD;

--Chartfield Value Set

SELECT * FROM PS_CFV_SET_CFV_TBL;

SELECT * FROM PS_CFV_SET_CF_TBL;

SELECT * FROM PS_CFV_SET_TBL;

--Combo Rules

SELECT * FROM PS_COMBO_CF2_REQ;

SELECT * FROM PS_COMBO_CF2_TBL;

SELECT * FROM PS_COMBO_CF_TBL;

SELECT * FROM PS_COMBO_FLDS_TBL;

SELECT * FROM PS_COMBO_RULE_TBL;

SELECT * FROM PS_COMBO_VAL2_TBL;

SELECT * FROM PS_COMBO_VAL_TBL;

--Speed Type

SELECT * FROM PS_SPEEDTYP_TBL;

SELECT * FROM PS_SPEED_USER_TBL;

--Holiday Calendar

SELECT * FROM PS_BUS_CAL_HOL_DFN;

SELECT * FROM PS_CUR_HOL_ID_XREF;

--Personal Data

SELECT * FROM PS_EX_EE_ORG_DTA;

SELECT * FROM PS_PERSONAL_DATA;

SELECT * FROM PS_PERS_DATA_EFFDT;

--Combination Group

SELECT * FROM PS_COMBO_GROUP_TBL;

SELECT * FROM PS_COMBO_GRRUL_TBL;

SELECT * FROM PS_COMBO_RULE_TBL;

--Treasury Counterparties

SELECT * FROM PS_BANK_CD_TBL;

SELECT * FROM PS_BANK_RATINGS;

SELECT * FROM PS_BANK_SETTLEMENT;

SELECT * FROM PS_CREDIT_RTG_TBL;

--Data should come up in this view to be seen in treasury counterparties

SELECT * FROM PS_BANK_CD_DLR_VW;

--Treasury Contact

SELECT * FROM PS_TR_CONTACT_TBL;

--Bank Cut off

SELECT * FROM PS_BANK_CUTOFF;

--Bank Branch Information

SELECT * FROM PS_BANK_BRANCH_CNT;

SELECT * FROM PS_BANK_BRANCH_TBL;

--COMBO EDIT TEMPLATE

SELECT * FROM PS_COMBO_EDIT_LNS;

SELECT * FROM PS_COMBO_EDIT_TMPL;

--STANDARD CONFIGURATION

SELECT * FROM PS_FS_CF_DEMO_WS;

SELECT * FROM PS_FS_CF_LABEL;

SELECT * FROM PS_FS_CF_LNG_LABEL;

SELECT * FROM PS_FS_CF_PRMPT_LOG;

SELECT * FROM PSTIMEZONE;

--BUSINESS CALANDER

SELECT * FROM PS_BUS_CAL_HOLIDAY;

SELECT * FROM PS_BUS_CAL_HOL_DFN;

SELECT * FROM PSOPTIONS;

--Document Sequencing

SELECT * FROM PS_SEQ_RANGE_DEFN;

SELECT * FROM PS_SEQ_RANGE_DETL;

--Ledger Templates

SELECT * FROM PS_LED_TMPLT_TBL;

--Journal Entry Template

SELECT * FROM PS_GL_JRNL_CYDWN;

SELECT * FROM PS_GL_JRNL_TMPLT;

--InterUnit Transaction Code

SELECT * FROM PS_IU_TRAN_CD_TBL;

--Entry Event Source Definition

SELECT * FROM PS_EE_SRC_DEFN;

--Detail Ledger

SELECT * FROM PS_LED_DEFN_TBL;

SELECT * FROM PS_LED_TMPLT_TBL;

--Journal Type

SELECT * FROM PS_JRNL_TYPE_TBL;

--Ledger File Formats

SELECT * FROM PS_LEDGER_FILE_TBL;

--Ledger Codes

SELECT * FROM PS_BOOK_CODE_TBL;

SELECT * FROM PS_LEDGER_CODE_DTL;

SELECT * FROM PS_LEDGER_CODE_TBL;

--Ledger Groups

SELECT * FROM PS_LED_GRP_FLD_TBL;

SELECT * FROM PS_LED_GRP_LED_TBL;

SELECT * FROM PS_LED_GRP_TBL;

SELECT * FROM PS_LED_TMPLT_TBL;

--Document Sequencing - Journal Code

SELECT * FROM PS_JRNL_CODE_TBL;

SELECT * FROM PS_JRNL_TYPE_TBL;

--Time Spans

SELECT * FROM PS_TIME_SPANS;

--Equitization Rules

SELECT * FROM PS_CFV_SET_TBL;

SELECT * FROM PS_EQTZ_MINEXP_TBL;

SELECT * FROM PS_EQTZ_MINLIA_TBL;

SELECT * FROM PS_EQTZ_OFF_CR_TBL;

SELECT * FROM PS_EQTZ_OFF_DR_TBL;

SELECT * FROM PS_EQTZ_RULE_TBL;

SELECT * FROM PS_EQTZ_SRCCFV_TBL;

SELECT * FROM PS_EQTZ_TG_CR_TBL;

SELECT * FROM PS_EQTZ_TG_DR_TBL;

--Journal Generator Accounting Entry Definition

SELECT * FROM PS_JRNLGEN_DEFMB;

SELECT * FROM PS_JRNLGEN_DEFN;

SELECT * FROM PS_JRNLGEN_DEFNV;

--Journal Source

SELECT * FROM PS_SOURCE_TBL;

SELECT * FROM PS_SRC_JE_AS_CFS;

SELECT * FROM PS_SRC_JE_AS_SET;

SELECT * FROM PS_SRC_JE_BS_CFS;

SELECT * FROM PS_SRC_JE_BS_SET;

SELECT * FROM PS_SRC_JE_ES_CFS;

SELECT * FROM PS_SRC_JE_ES_SET;

--Journal Generator Template

SELECT * FROM PS_JGEN_DOC_MAP;

SELECT * FROM PS_JRNLGEN_APPL_ID;

SELECT * FROM PS_JRNLGEN_SUMV;

--Standard Budget Copy

SELECT * FROM PS_ALLOC_AMT_TBL;

SELECT * FROM PS_ALLOC_AMT_TMP;

SELECT * FROM PS_ALLOC_BASF_TBL;

SELECT * FROM PS_ALLOC_BASV_TBL;

SELECT * FROM PS_ALLOC_OFFV_TBL;

SELECT * FROM PS_ALLOC_POOLF_TBL;

SELECT * FROM PS_ALLOC_POOLV_TBL;

SELECT * FROM PS_ALLOC_RNDLN_TBL;

SELECT * FROM PS_ALLOC_STEP_TBL;

SELECT * FROM PS_ALLOC_TARGV_TBL;

SELECT * FROM PS_IU_TRAN_CD_TBL;

SELECT * FROM PS_ALLOC_BASX_TBL;

SELECT * FROM PS_ALLOC_POOLX_TBL;

--Closing Rules

SELECT * FROM PS_CLOSE_ADJP_TBL;

SELECT * FROM PS_CLOSE_DEFN_TBL;

SELECT * FROM PS_CLOSE_DFLT_TBL;

SELECT * FROM PS_CLOSE_FROM_TBL;

SELECT * FROM PS_CLOSE_LINE_TBL;

SELECT * FROM PS_CLOSE_OFFST_TBL;

SELECT * FROM PS_CLOSE_PLFWD_TBL;

SELECT * FROM PS_CLOSE_TO_TBL;

--Allocation Group

SELECT * FROM PS_ALLOC_GROUP_TBL;

SELECT * FROM PS_ALLOC_GRSTP_TBL;

Business Unit Set Up
PS_BUS_UNIT_TBL_GL
PS_BUS_UNIT_GL_LOC
PS_BUS_UNIT_TBL_FS
PS_BUS_UNIT_TBL_TR

User Preferences
PS_OPR_DEF_TBL_FS

Account Type
PS_ACCT_TYPE_TBL
If you customize Account Types, you will need to customize the Closing Trial Balance sqr report, GLS1003.sqr
PS_GL_ACCOUNT_TBL
PS_OPER_UNIT_TBL
PS_FUND_TBL
PS_DEPT_TBL
PS_PROGRAM_TBL

Detail Calender
PS_CAL_DETP_TBL
PS_CAL_DEFN_TBL

Tree Tables
PSTREEDEFN
PSTREEBRANCH
PSTREELEVEL
PSTREENODE
PSTREELEAF
PSTREEDEFNLANG
PSTREEPROMPT
PS_TREE_NODE_TBL
PS_TREE_LEVEL_TBL

User Preferences

PS_OPR_DEF_PYCYCL

PS_OPR_DEF_TBL_AM

PS_OPR_DEF_TBL_AP

PS_OPR_DEF_TBL_AR

PS_OPR_DEF_TBL_BI

PS_OPR_DEF_TBL_CA

PS_OPR_DEF_TBL_CS

PS_OPR_DEF_TBL_FO

PS_OPR_DEF_TBL_GL

PS_OPR_DEF_TBL_IN

PS_OPR_DEF_TBL_IT

PS_OPR_DEF_TBL_MG

PS_OPR_DEF_TBL_OLE

PS_OPR_DEF_TBL_OM

PS_OPR_DEF_TBL_OM2

PS_OPR_DEF_TBL_OM3

PS_OPR_DEF_TBL_PC

PS_OPR_DEF_TBL_PL

PS_OPR_DEF_TBL_PM

PS_OPR_DEF_TBL_RTM

PS_OPR_DEF_TBL_SS

PS_OPR_DEF_TBL_TD

PS_OPR_DEF_TBL_VND

PS_OPR_DEF_TBL_WM

Other Set Up tables

PS_BU_LED_GRP_TBL

PS_BU_LED_TBL

PS_CAL_ADJP_TBL

PS_CAL_BLDR_VW

PS_CAL_DEFN_TBL

PS_CDM_AUTH

PS_CDM_LIST

PS_CDR_USER

PS_CF_INHERIT_TBL

PS_CFV_SET_CF_TBL

PS_CFV_SET_CFV_TBL

PS_CFV_SET_TBL

PS_CLOSE_DEFN_TBL

PS_CLOSE_DFLT_TBL

PS_CONSOL_DETL_TBL

PS_CONSOL_ELIM_TBL

PS_CONSOL_MIN_TBL

PS_CONSOL_TBL

PS_ELIM_CHRTFD_TBL

PS_ELIM_DIFFCR_TBL

PS_ELIM_DIFFDR_TBL

PS_ELIM_LINE_TBL

PS_ELIM_SET_TBL

PS_EQTZ_GROUP_TBL

PS_EQTZ_GRP_LN_TBL

PS_EQTZ_MINEXP_TBL

PS_EQTZ_MINLIA_TBL

PS_EQTZ_RULE_TBL

PS_EQTZ_SRCCFV_TBL

PS_EQTZ_TG_CR_TBL

PS_EQTZ_TG_DR_TBL

PS_FIN_BU_LGRP_TBL

PS_FIN_OPEN_ADJ

PS_FIN_OPEN_OPTN

PS_FIN_OPEN_PERIOD

PS_GL_JRNL_CYDWN

PS_GL_JRNL_TMPLT

PS_INSTALLATION_EE

PS_IU_INTER_CF_DVW

PS_IU_INTER_TMPLT

PS_IU_INTER_TRAN

PS_IU_INTERGRP_DVW

PS_IU_TRAN_CD_TBL

PS_IU_TRAN_MAP_TBL

PS_LED_DEFN_TBL

PS_LED_FLDS_TBL

PS_LED_GRP_FLD_TBL

PS_LED_GRP_LED_TBL

PS_LED_GRP_TBL

PS_PRCSRQSTDIST

PS_RE_OPR_DFLTS

PS_RT_INDEX_TBL

PS_RT_RATE_DEF_TBL

PS_RT_TYPE_TBL

PS_SCHEDULE_TBL

PS_SET_CNTRL_GROUP

PS_SET_CNTRL_REC

PS_SET_CNTRL_TBL

PS_SET_CTL_GRP_TMP

PS_SET_CTL_REC_TMP

PS_SOURCE_TBL

PS_TIME_SPANS

Transaction Tables
**********************
*When a Journal is Saved*
**********************
PS_JRNL_CF_BAL_TBL
PS_JRNL_HEADER
PS_JRNL_LN
PS_INSTALLATION_FS

PS_LEDGER