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