UD PeopleSoft Financial System - Data Dictionary
Last updated for this Record on 6/7/2003.

GL_ACCOUNT_TBL

This is the Account Table, which contains short and long descriptions as of an effective date. The "Account" chartfield classifies transactions as a particular category of expenditure, revenue, asset, liability or net assets. (eg. 141000: Office Supplies). Corresponds to the legacy "Object code".
ACCOUNT Account Example: 1SC000
KEY Type: character Format: uppercase Length: 10 Decimals: 0
Chartfield which characterizes the type of transaction as part of the transaction string. It identifies the type of revenue, expense, liability or asset. Corresponds to the legacy 3-digit Object Code (eg. 410: Office Supplies).
.
EFFDT Effective Date Example: 01/01/1951
KEY Type: date Format: uppercase Length: 10 Decimals: 0
The date on which this row of data takes effect.
.
SETID SetID Example: UOD01
KEY Type: character Format: uppercase Length: 5 Decimals: 0
The only valid value at UD at this time is "UOD01".
.
ACCOUNT_TYPE Account Type Example: E
Type: character Format: uppercase Length: 1 Decimals: 0
Characterizes an account, transaction or balance broadly as Expense, Revenue, Asset, Liability, or Net Asset.
.
BUDGETARY_ONLY Budgetary Only Example: N
Type: character Format: uppercase Length: 1 Decimals: 0
This is a Budget item, but not one that ever contains actual transactions? For tree building?...
.
DESCR Description Example: SUPPLEMENTAL PAY-FACULTY
Type: character Format: lowercase Length: 30 Decimals: 0
Description
.
DESCRSHORT Short Description Example: SUPPL FAC
Type: character Format: lowercase Length: 10 Decimals: 0
Short Description
.
EFF_STATUS Status as of Effective Date Example: A
Type: character Format: uppercase Length: 1 Decimals: 0
Indicates whether the row of data is active or inactive.
.
Fields deemed insignificant at UD, or of limited use to general campus users.
AB_ACCOUNT_SW ABM Account
ACCOUNTING_OWNER Accounting Owner
BAL_SHEET_IND Balance Sheet Indicator
BALANCE_FWD_SW Balance Forward
BOOK_CODE Book Code
BUDG_OVERRIDE_ACCT Budget Override Account
CONTROL_FLAG Control Flag
CURRENCY_CD Currency Code
GL_ACCOUNT_SW General Ledger Account
OPEN_ITEM OpenItem Account
OPEN_ITEM_DESCR Description of OpenItem
OPEN_ITEM_EDIT_FLD OpenItem Edit Field
OPEN_ITEM_EDIT_REC OpenItem Edit Record
OPEN_ITEM_PROMPT Open Item Prompt Table
OPEN_ITEM_TOL_AMT Reconcile Tolerance
PF_ACCOUNT_SW Performance Measurement
STATISTICS_ACCOUNT Statistical Account
TAX_CD_VAT VAT Code
TAX_CD_VAT_FLG VAT Code Option
UNIT_OF_MEASURE Unit of Measure
VAT_ACCOUNT_FLG VAT Account Flag
VAT_APPLICABLE VAT Applicable
VAT_CALC_TYPE Calculation Type
VAT_CALC_TYPE_FLG VAT Calculation Type
VAT_DST_ACCT_TYPE Account Type
VAT_RCRD_INPT_FLG Record Input VAT
VAT_RCRD_OUTPT_FLG Record Output VAT
VAT_TOL_AMT VAT Tolerance Amount
VAT_TOL_CUR_CD Currency
VAT_TOL_FLG VAT Tolerance Check Indicator
VAT_TOL_PCT VAT Tolerance Percentage
VAT_TOL_RT_TYPE Rate Type
VAT_TXN_CD_FLG VAT Transaction Code
VAT_TXN_TYPE_CD VAT Transaction Type
VAT_USE_ID VAT Use Type
VAT_USE_ID_FLG VAT Use ID Flag