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

SOURCE_TBL

"Transaction Source": characterizes the origin or type of a transaction. Mimics the legacy "tran-code". Not to be confused with "Source" (Chartfield2)
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".
.
DESCR Description Example:
Type: character Format: lowercase Length: 30 Decimals: 0
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.
.
SOURCE Source Example: 000
Type: character Format: uppercase Length: 3 Decimals: 0
Transaction Source: the subsystem where the tranaction originates. NOT the same as CHARTFIELD2-SOURCE. Equivalent to Legacy Data Warehouse tran_code.
.
Fields deemed insignificant at UD, or of limited use to general campus users.
APPR_RULE_SET Approval Rule Set
APPR_RULE_SET_BD Approval Rule Set - Budgets
BASE_CUR_ADJ_OPTN Base Currency Adjust Option
BD_JRNL_APPR_OPTN Budget Journal Approval Optn
BUSPROCNAME Business Process Name
BUSPROCNAME_BD Business Process Name - Budget
CONTROL_TOTAL_OPTN Control Total Option
CURRENCY_BAL_OPTN Currency Balancing Option
DOC_TYPE Document Type
DOC_TYPE_OPTN Document Type Option
JRNL_AMT_ERR_OPTN Journal Amount Errors Option
JRNL_APPRVL_OPTN Journal Approval Option
JRNL_BALANCE_OPTN Journal Balance Option
JRNL_DT_ERR_OPTN Journal Date < Open From Date
JRNL_DT_ERR_OPTN2 Journal Date > Open To Date
JRNL_EDIT_ERR_OPTN Journal Edit Errors Option
JRNL_FOREIGN_OPTN Foreign Currencies per Journal
POST_ZERO_SW Post Zero Amount Journal Lines
TAX_CD_VAT VAT Code
TAX_CD_VAT_FLG VAT Code Option
VAT_CALC_TYPE Calculation Type
VAT_CALC_TYPE_FLG VAT Calculation Type
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