Common PeopleSoft Tables for Financial Systems General Ledger CF_ATTRIB_TBL oe CF_ATTRIB_VALUE ‘Stores all atbutes that have been defined for each ChanField “JRNL_HEADER “Journal Headers, “TRNL_IN “Joumal Lines ~ Contains ACTUALS and STD_BUDG tansacions. ‘Actuals Ledger, This ledger consis of summarized balances resuting LepcER from detailed transactions. LEDGER = ACTUALS. ‘Stores deta payrol encumbrance information forthe current period UM_ENCUMBER_TMP only. This isthe source for payroll encumbrance drildowns on the Web reports. UM_ PAYROLL JRNL for drildouns on the Web. CharfField Tables ACCT_TYPE_TBL ‘Stores the ChanFleld value and the attributes that have been assigned “Bridge Table" ~ Stores deta payroll information. This is the source Description of Account Types ~ Asset, Liabilities, Revenues, and Expenses. CLASS_oF_TaL ‘tase description DEPT_TaL ~ | Deptid description FUNDTOL Fund deception GL_ACCOUNT_TeL ‘Account descipton. ‘PROGRAM_TBL Program descnpton PROJECT Project descipton. ‘SPEEDCHART_HOR ‘Contains effective status (active inactive) for MoCode. ‘SPEEDCHART_OTL ‘Contains CharFied information for MoCode 29Accounts Receivable BILHDR ‘See Biting tables. 8% Biling tables. ‘CUSTOMER ‘Sores the deta for the customers used in the Grants and/or Biling. Ientifes the invoice/online pending Nem store original and balance of, ire item. ITEM ACTIVITY | Stores each activity against the item. PAYMENT ‘Stores all the payments received in the system for biling, PENDING ITEM ‘Sores the group information for Bling and Accounts Receivable. Billing ‘BI_ACCT_ENTRY ‘Sores the Accounting Enty for the invoices. BI_HOR ‘Stores the data for grant and non-grant invoices. BI_LINE ‘Stores the line detal forthe invoices. BI_LINE_DST The Distribution forthe items. BI_LINE_TAX_DTL. ‘etal tax data for non-grant invoices, ‘CUSTOMER ‘Stores the data for the customers used in the Grants and/or Bling ‘TAX_AUTHORITY (CF to charge the taxes on non-grant invoices. Asset Management ‘ASSET ‘This table contains asset goneral information. ‘ASSET_ACQ_DETAIL “This table contains all the Information needed relating tothe inal purchase of an asset ‘ASSET _NBV_TBL "Asset Net Book Valve Table. ‘cost This table contains al information relating to ASSET cost DEPRECIATION Depreciation Transactions. DisT_LN “Tis teble contains information about accounting enies related to the 30Commitment Control KK_ACTIVITY_LOG KK_SOURCE_HOR kW_SOURCE_LN Contains actusls, encumbrances and pre-encumbrances transaction details. KK_BUDGET_HOR ‘Commitment Cantrot Budget Jourel header information. KK_BUDGET_LN KKFILTER ‘Contains KK budget rules and definitions. Primarily used by Budget ‘Commitment Controt Budget journal lines information. Offices. LeDoeR_suDG Standard Budget Ledger: This ledger consists of summarized balances resuting from detailed transactions. LEDGE! D_BUDG. The standard budget portion of the LEDGER_BUDG table remains here, but the conte’ budget portion has been moved to LEDGER_KK. LEDGER_KK ‘Commimment Control (Contolled Budget) Ledger: ‘This ledger consists of summarized bs ces resulting from detailed transactions for controlled budgets, expenditures, encumbrances, pre-encumbrances, collected revenues, and recognized revenues at the appropriate budget pool level. These balances are stored in ledger groups that are ma up of detailed ledgers. UM_BUDGET_OATA ‘This table contains the budget and actual information used in the UM ‘Budget Development application. New year budget entries are stored here until the nightly process collects them and creates standard budget jourais. UM_LEDGER_KK_WW ‘Commitment Control Ledger: This Is a View of LEDGER. KK that reformats LEDGER_KK to present all the information for a specific. CchartField on one record ‘UM_ORG_DEPTID Flattened DeptiO Table. 31‘Commitment Control Security KSEC_CLSS_RULES KSEC_DYN_RULES. KSEC_OPR_RULES KSEC_RULES, KSEC_RULES_6U KSEC_RULES_ENTR KSEC_RULES_EVNT Budget Offce Use Only: Contains the Commitment Control Security setup and rules. Grants ‘Contracts ‘CABILL_PLAN List what required falds must be populated to process en invice, (CA_BP_EVENTS ‘Store dates for xed price invoices. ‘CA_CONTR_HDR List information on the contract (0... status, bil-io-customer, type) ‘CA_DETAIL Details ~ LOC Doc 1D, Bil Pan. (CA_DETAIL_PROJ INTEC. BI Unk between the contract and project id Error from the biling process. Proposais/Awards List information on the award (@.9., Pl ype, customer, begin and end oM_AWARD date, status). GM_AWD_ATTR ‘Store any attributes on the award. (GM_AWD_CERT ‘Stores the certication on the award. GM_AWD_COMMENT ‘Stores comment to the award. ‘GM_AWD_FUND_PD “Total awarded amount with dates. ‘GM_AWD_KEYWORD Keywords associated to the award. (GM_AWD_MILE Links Milestone (Reporting requirements) on the award ‘GM_AWD_MOD ‘Stores all Award Modifcation for the award, ‘QM_BUD_FA_HDR FRA Rate Information forthe proposal ‘GM_BUD_FA_RATE ‘Sores the Rate Type and Rate % on the proposal by project. (GM_BUD_PERIOD ‘Proposals FA and total amount by periods. (GM_FA_BASE_CAT GM_PRI_ERR ‘Stores the budget categories for the FA Base, FA Errors for projects. 32GM_PROP_CERT ‘Stores the certification on the proposal ‘OM_PROP_KEY Keywords associated to the proposal. ‘GM_PROP_PROF List name of those on the proposal and their role on the proposal ‘GM_PROP_PROJ ‘Temp project and or created project to the proposal. List information on the propesal(e.9., Pl, type, customer, bagin and ‘GM_PROPOSAL fend date, status). General PROJ_RESOURCE. Stores all ransaction for grants, use to calculate the F&A and biting Payables DISTRIB_LINE ‘This teble containg information about vouchers, Including accounting distibuton, VCHR_ACCTG_LINE ‘This table contains information about vouchers, including accounting ‘and journal dates. VENDOR ‘This table contains default header (overall) information about vendors VENDOR_ADDR, ‘This table containe elfective-dated vendor address data ‘This table contains information about vouchers, including Invoice and voucHER vendor ‘This table contains dotaled information for each voucher line, VOUCHER_LINE escrption, and amount. Purchasing PO_HOR “Table contains information from the purchase order header. PO_LINE ‘Table contains information from the purchase order lines. PO_LINE_ DISTRI ‘Table contains the accounting entry Information from the purchase order PO_LINE_MATCHED PO line biled amounts. PO_LINE_SHIP ‘Table contains the shipping information from the purchase order. RECV_HOR [Recv_un Accra ‘Table contains information from the receiver header. ‘Receiver accountng line table. RECV_LN SHIP ‘Table contains the shipping schedule from the receiver. 33UM-Created Tables UM_GM_AWARD_LST (Created during the night production, used for the Award Listing Report #7 on the Web. ‘UM_GM_AWD_SHR_C ‘Stores the shared credit data on the award at the project level UM_GM_FA ALLOW ‘Stores the Comments on the FBA rate alowed on the proposal ‘UM_GM_FA_AWD_TB ‘Stores the Comments on the FAA rate alowed on the project. UM_GM_FA_CALC (Created during the nighty production, used for the F&A Calculation Repor #8 on the Web. UM_GM_OSP_REC ‘Stores emplid end date ofthe reviewer and signer on the proposal, nd comments. date received and reviewed in OSPA, ‘UM_ORG_DEPTID Fiattened Dept Table ‘UM_PAYROLL_JRNL “Bridge Table” ~ Stoves detail payrot information. This is the source for evitdowns on the Web. 34