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