UD PeopleSoft Financial System -
Data Dictionary
Last updated for this Record on 9/8/2003.
JRNL_HEADER
Contains summary information about Journals.
Further details are in this record's child: JRNL_LN.
|
| BUSINESS_UNIT
| Business Unit
| Example: UOD01
|
| KEY
| Type: character
| Format: uppercase
| Length: 5
| Decimals: 0
|
| | Legal entity with a tax ID number. Only one exists at UD at this time
(UOD01)
|
| |
|
| .
|
| JOURNAL_DATE
| Journal Date
| Example: 07/31/2003
|
| KEY
| Type: date
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Date the journal is entered.
|
| |
|
| .
|
| JOURNAL_ID
| Journal ID
| Example: 0000000001
|
| KEY
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Identifies and individual journal.
|
| |
|
| .
|
| UNPOST_SEQ
| UnPost Sequence
| Example:
|
| KEY
| Type: number
| Format: uppercase
| Length: 2
| Decimals: 0
|
| | Whether a journal has been unposted or not.
|
| |
|
| .
|
| ACCOUNTING_PERIOD
| Accounting Period
| Example: 001
|
|
| Type: number
| Format: uppercase
| Length: 3
| Decimals: 0
|
| | Represents the time span where the transactions are recorded. Accounting
periods 1-12 correspond to a month and periods 991 and 992 correspond to
year end close periods.
|
| |
|
| .
|
| ADJUSTING_ENTRY
| Adjusting Entry
| Example: Y
|
|
| Type: character
| Format: uppercase
| Length: 1
| Decimals: 0
|
| | Journal entry made as part of closing process. Limited to period 991 &
992
|
| |
|
| .
|
| DESCR
| Description
| Example: TO TRANSFER EXPENSES
|
|
| Type: character
| Format: lowercase
| Length: 30
| Decimals: 0
|
| | Description
|
| |
|
| .
|
| DTTM_STAMP_SEC
| Last Update DateTime
| Example: 2002-12-10-16.28.52.000000
|
|
| Type: date-time
| Format: seconds
| Length: 26
| Decimals: 0
|
| | Date and time when the journal was last modified.
|
| |
|
| .
|
| FISCAL_YEAR
| Fiscal Year
| Example: 2004
|
|
| Type: number
| Format: uppercase
| Length: 4
| Decimals: 0
|
| | UD fiscal transaction year. The year runs from 7/1/XX to 6/30/XY..
|
| |
|
| .
|
| GL_ADJUST_TYPE
| Adjustment Type
| Example:
|
|
| Type: character
| Format: uppercase
| Length: 4
| Decimals: 0
|
| | Represents type of adjusting entry for year-end closing.
|
| |
|
| .
|
| JRNL_TOT_CREDITS
| Journal Total Credits
| Example: 0.000
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | Shows you the total credits in a journal.
|
| |
|
| .
|
| JRNL_TOTAL_DEBITS
| Journal Total Debits
| Example: 0.000
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | Shows total debits in a journal.
|
| |
|
| .
|
| LEDGER_GROUP
| Ledger Group
| Example: ACTUALS
|
|
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Name of the ledger that the row is attached.
|
| |
|
| .
|
| POSTED_DATE
| Date Posted
| Example: 07/31/2003
|
|
| Type: date
| Format: uppercase
| 10Length: 10
| 0
|
| | Date the journal was posted to the ledger.
|
| |
|
| .
|
| 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.
|
| | Lookup values and translations in
SOURCE_TBL
|
| .
Fields deemed insignificant at UD, or of limited use to general campus users.
|
| ACCTG_DEF_NAME
| Accounting Definition Name
|
| ADB_DATE
| Average Daily Balance Date
|
| AUTO_GEN_LINES
| Auto Generate Lines
|
| BUDGET_HDR_STATUS
| Budget Checking Header Status
|
| BUSINESS_UNIT_IU
| Business Unit
|
| CONTROL_TOTAL_STAT
| Control Total Status
|
| CUR_EFFDT
| Currency Effective Date
|
| CURRENCY_CD
| Currency Code
|
| DESCR254
| Long Description
|
| DOC_SEQ_DATE
| Document Sequence Date
|
| DOC_SEQ_NBR
| Document Sequence Number
|
| DOC_SEQ_STATUS
| Document Sequencing Status
|
| DOC_TYPE
| Document Type
|
| EE_HDR_STATUS
| Entry Event Header Status
|
| EVENT_OCCURRENCE
| Event Occurrence
|
| FOREIGN_CURRENCY
| Foreign Currency Code
|
| IU_SYS_TRAN_CD
| System Transaction
|
| IU_TRAN_CD
| Transaction Code
|
| JOURNAL_CLASS
| Journal Class
|
| JOURNAL_DATE_ORIG
| Orignial Journal Date
|
| JOURNAL_LOCKED
| Journal Locked for Change
|
| JRNL_BALANCE_STAT
| Journal Balance Status
|
| JRNL_EDIT_ERR_STAT
| Journal Edit Error Status
|
| JRNL_HDR_STATUS
| Journal Header Status
|
| JRNL_NET_UNITS
| Journal Net Statistical Units
|
| JRNL_PROCESS_REQST
| Journal Processing Request
|
| JRNL_SUMLED_REQST
| Post to Summary Ledger
|
| JRNL_TOTAL_LINES
| Journal Total Lines
|
| KK_AMOUNT_TYPE
| Commitment Control Amount Type
|
| KK_SKIP
| Skip Commitment Control In GL
|
| KK_TRAN_BYPAS_FLAG
| Bypass Budget Checking
|
| KK_TRAN_OVER_DTTM
| Override Date
|
| KK_TRAN_OVER_FLAG
| Override Transaction
|
| KK_TRAN_OVER_OPRID
| Override User ID
|
| LAST_LN_COMMITTED
| Last Line Committed
|
| LEDGER
| Ledger
|
| OPRID
| User ID
|
| PC_DISTRIB_STATUS
| PC Distribution Status
|
| PROC_PART_ID
| Process Partition ID
|
| PROCESS_INSTANCE
| Process Instance
|
| RATE_DIV
| Rate Divisor
|
| RATE_MULT
| Rate Multiplier
|
| REVERSAL_ADJ_PER
| Adjustment Period
|
| REVERSAL_CD
| Reversal Code
|
| REVERSAL_CD_ADB
| ADB Reversal Code
|
| REVERSAL_DATE
| Reversal Date
|
| REVERSAL_DATE_ADB
| ADB Reversal Date
|
| RT_TYPE
| Rate Type
|
| SCHEDULE
| Schedule ID
|
| SJE_TYPE
| Standard Journal Entry Type
|
| SOURCE_INSTANCE
| Source Instance
|
| SUSP_RECON_STATUS
| Suspense Reconciliation Status
|
| SYSTEM_SOURCE
| System Source
|
| TRANS_REF_NUM
| Reference Number
|
| TRANSACTION_DATE
| Transaction Date
|
| UNPOST_JRNL_DATE
| Unpost Date