UD PeopleSoft Financial System -
Data Dictionary
Last updated for this Record on 6/7/2003.
VCHR_ACCTG_LINE
This record is populated after the AP vouchers are posted. These entries are the complete AP
sub-system entries including AP offset, charges and cash entries. This record contains detailed
AP voucher information before it is summarized in the General Ledger.
|
| 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)
|
| |
|
| .
|
| CF_BAL_LINE_NUM
| Chart Field Balancing Line Num
| Example:
|
| KEY
| Type: number
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Not significant at UD.
|
| |
|
| .
|
| DISTRIB_LINE_NUM
| Distribution Line Number
| Example: 1, 2
|
| KEY
| Type: number
| Format: uppercase
| Length: 5
| Decimals: 0
|
| | Line of a transaction from accounts payable.
|
| |
|
| .
|
| DST_ACCT_TYPE
| Accounting Entry Type
| Example: DST, UNP, UNR,CAS
|
| KEY
| Type: character
| Format: uppercase
| Length: 4
| Decimals: 0
|
| | Designates account type (expense/liability) of a transaction.
|
| |
|
| .
|
| LEDGER
| Ledger
| Example: ACTUALS
|
| KEY
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Name of the ledger that the row is attached.
|
| |
|
| .
|
| PYMNT_CNT
| Payments
| Example: 1
|
| KEY
| Type: number
| Format: uppercase
| Length: 5
| Decimals: 0
|
| | The check number.
|
| |
|
| .
|
| UNPOST_SEQ
| UnPost Sequence
| Example: 1 or 0
|
| KEY
| Type: number
uppe | uppercase Format: uppercase
| Length: 2
| Decimals: 0
|
| | Whether a journal has been unposted or not.
|
| |
|
| .
|
| VOUCHER_ID
| Voucher ID
| Example: 00000013
|
| KEY
| Type: character
| Format: uppercase
| Length: 8
| Decimals: 0
|
| | Identifier of the voucher.
|
| |
|
| .
|
| VOUCHER_LINE_NUM
| Voucher Line Number
| Example: 1, 99999
|
| KEY
| Type: number
| Format: uppercase
| Length: 5
| Decimals: 0
|
| | Line number on a voucher.
|
| |
|
| .
|
| ACCOUNT
| Account
| Example: 141000
|
|
| 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.
|
| |
Lookup values and translations in
GL_ACCOUNT_TBL
|
| .
|
| ACCOUNTING_DT
| Accounting Date
| Example: 11/26/2002
|
|
| Type: date
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | The date the transaction is recorded in the ledger.
|
| |
|
| .
|
| ACCOUNTING_PERIOD
| Accounting Period
| Example: 6
|
|
| 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.
|
| |
|
| .
|
| ACTIVITY_ID
| Activity ID
| Example: (TBD w/ Projects)
|
|
| Type: character
| Format: uppercase
| Length: 15
| Decimals: 0
|
| | Chartfield used for Projects. Represents a specific task for which expense
or revenue are recorded.
|
| |
|
| .
|
| AM_DISTRIB_STATUS
| AM Distribution Status
| Example: (TBD w/ Asset Mgt)
|
|
| Type: character
| Format: uppercase
| Length: 1
| Decimals: 0
|
| | Not significant at this time. Will be when Asset Management Module goes
live
|
| |
|
| .
|
| ANALYSIS_TYPE
| Resource Analysis Type
| Example: (TBD w/ Projects)
|
|
| Type: character
| Format: uppercase
| Length: 3
| Decimals: 0
|
| | Projects and Grant chartfield that is used to track activities and events
that are billable to a third party.
|
| |
|
| .
|
| ASSET_FLG
| Assets Applicable
| Example: (TBD w/ Asset Mgt)
|
|
| Type: character
| Format: uppercase
| Length: 1
| Decimals: 0
|
| | This field is used to tell Procurement to move the transaction into the
Asset Management Module.
|
| |
|
| .
|
| ASSET_ID
| Asset Identification
| Example: (TBD w/ Asset Mgt)
|
|
| Type: character
| Format: uppercase
| Length: 12
| Decimals: 0
|
| | Identifies an individual asset. This field will be used when Asset
Management Module is implemented.
|
| |
|
| .
|
| BUDGET_REF
| Budget Reference
| Example: 1999
|
|
| Type: character
| Format: uppercase
| Length: 8
| Decimals: 0
|
| | The Budget Year (Fiscal).
|
| |
|
| .
|
| CHARTFIELD1
| Purpose
| Example: ENGL110000
|
|
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Purpose chartfield. Replaces legacy 11 digit account code.
|
| | Lookup values and translations in
CHARTFIELD1_TBL
|
| .
|
| CHARTFIELD2
| Source
| Example: 3300003000
|
|
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Source chartfield which tags and tracks contract and grant agency
information, and capital projects.
|
| | Lookup values and translations in
CHARTFIELD2_TBL
|
| .
|
| CHARTFIELD3
| UD Chartfield
| Example: 0000000001
|
|
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | The Chartfield which tags transactions with a code that each UDFS user can
interpret as (s)he finds useful (eg. USRVAL1 might mean "Paris" to one user
or department, but mean "Fall lecture series" to another).
|
| |
|
| .
|
| CLASS_FLD
| Class Field
| Example: 001
|
|
| Type: character
| Format: uppercase
| Length: 5
| Decimals: 0
|
| | The Chartfield which identifies the faculty member or the staff position to
which salary items apply. Corresponds to the legacy line number.
|
| | Lookup values and translations in
CLASS_CF_TBL
|
| .
|
| DEPTID
| Department
| Example: 02553
|
|
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Identifies the administrative budget unit controling one or more Purposes.
Some entries are not actual departments, but are merely nodes on a tree
that organizes departments into a hierarchy for reporting purposes.
|
| | Lookup values and translations in
DEPT_TBL
|
| .
|
| FISCAL_YEAR
| Fiscal Year
| Example: 2003
|
|
| Type: number
| Format: uppercase
| Length: 4
| Decimals: 0
|
| | UD fiscal transaction year. The year runs from 7/1/XX to 6/30/XY..
|
| |
|
| .
|
| FUND_CODE
| Fund Code
| Example: OPBAS
|
|
| Type: character
| Format: uppercase
| Length: 5
| Decimals: 0
|
| | Each Fund represents a self-balancing entity that produces balance sheets.
Loosely corresponds to Legacy Data Warehouse ACCT_TYPE.
|
| | Lookup values and translations in
FUND_TBL
|
| .
|
| GL_DISTRIB_STATUS
| Distribution Status
| Example:
|
|
| Type: character
| Format: uppercase
| Length: 1
| Decimals: 0
|
| | Represents whether the line of data has been sent to the general ledger.
|
| |
|
| .
|
| JOURNAL_DATE
| Journal Date
| Example: 01/31/2004
|
|
| Type: date
| Format: uppercase
| Length: 10
| 0
|
| | Date the journal is entered.
|
| .
|
| JOURNAL_ID
| Journal ID
| Example: AP00000004
|
|
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Identifies and individual journal.
|
| |
|
| .
|
| JOURNAL_LINE
| GL Journal Line Number
| Example: 0, 1, 2
|
|
| Type: number
| Format: uppercase
| Length: 9
| Decimals: 0
|
| | Sequencial number of lines in journal.
|
| |
|
| .
|
| MERCHANDISE_AMT
| Merchandise Amt
| Example: 100.000
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | The dollar amount of the goods and services by chartfield string on a
voucher line.
|
| |
|
| .
|
| MONETARY_AMOUNT
| Monetary Amount
| Example: 200.000
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | The total dollar amount for a chartfield string for the voucher line that
can include freight and taxes.
|
| |
|
| .
|
| PO_ID
| Purchase Order
| Example: 0000000015
|
|
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Identifies a particular Purchase Order
|
| |
|
| .
|
| PROGRAM_CODE
| Program Code
| Example: INST2
|
|
| Type: character
| Format: uppercase
| Length: 5
| Decimals: 0
|
| | Identifies the major University function to which a transaction pertains
among an initial list of 3 dozen.
|
| | Lookup values and translations in
PROGRAM_TBL
|
| .
|
| PROJECT_ID
| Project
| Example: 10000RNOV175355
|
|
| Type: character
| Format: uppercase
| Length: 15
| 0
|
| | Chartfield which identifies contract and grant activities and facilities
projects (eg. ARTC37211199000). Adds designators to a "Purpose" (eg.
ARTC372111) indicating fiscal year, building, or other coded details. Joins
to PROJECT_ID_VW for translation.
|
| |
|
| .
Fields deemed insignificant at UD, or of limited use to general campus users.
|
| AFFILIATE
| Affiliate
|
| AFFILIATE_INTRA1
| Fund Affiliate
|
| AFFILIATE_INTRA2
| Operating Unit Affiliate
|
| ALTACCT
| Alternate Account
|
| APPL_JRNL_ID
| Journal Template
|
| BCM_LINE_STATUS
| Budget Checking Line Status
|
| BCM_POST_AMOUNT
| BCM Post Amount
|
| BCM_POST_AMT_TOT
| BCM Total Post Amount
|
| BUDGET_DT
| Budget Date
|
| BUDGET_HDR_STATUS
| Budget Checking Header Status
|
| BUDGET_LINE_STATUS
| Budget Checking Line Status
|
| BUSINESS_UNIT_AM
| Asset Management Business Unit
|
| BUSINESS_UNIT_GL
| General Ledger Unit
|
| BUSINESS_UNIT_PC
| PC Business Unit
|
| BUSINESS_UNIT_PO
| PO Business Unit
|
| BUSINESS_UNIT_RECV
| Receiving Business Unit
|
| CHART_EDIT_STATUS
| Chart Edit Status
|
| CLOSE_STATUS
| Close Status Indicator
|
| COST_TYPE
| Cost Type
|
| CURRENCY_CD
| Currency Code
|
| CURRENCY_RPTG
| Reporting Currency
|
| DESCR
| Description
|
| DOC_SEQ_DATE
| Document Sequence Date
|
| DOC_SEQ_NBR
| Document Sequence Number
|
| DOC_SEQ_STATUS
| Document Sequencing Status
|
| DOC_TYPE
| Document Type
|
| DSCNT_AMT
| Discount Amount
|
| DSCNT_AMT_BSE
| Base Discount Amount
|
| EE_PROC_STATUS
| Entry Event Line Status
|
| ENTRY_EVENT
| Entry Event
|
| ERROR_FLAG
| Error Flag
|
| FINAL_REF_IND
| Final Reference Indicator
|
| FOREIGN_AMOUNT
| Foreign Amount
|
| FOREIGN_CURRENCY
| Foreign Currency Code
|
| FREIGHT_AMT
| Freight Amount
|
| FREIGHT_AMT_BSE
| Base Freight Amount
|
| IST_DISTRIB_STATUS
| Intrastat Distribution Status
|
| IU_ANCHOR_FLG
| InterUnit Anchor
|
| IU_SYS_TRAN_CD
| System Transaction
|
| IU_TRAN_CD
| Transaction Code
|
| JRNL_LN_REF
| Journal Line Reference
|
| KK_TRAN_OVER_DTTM
| Override Date
|
| KK_TRAN_OVER_FLAG
| Override Transaction
|
| KK_TRAN_OVER_OPRID
| Override User ID
|
| LEDGER_GROUP
| Ledger Group
|
| LINE_NBR
| Line Number
|
| MERCH_AMT_BSE
| Base Merchandise Amount
|
| MOVEMENT_FLAG
| Movement Flag
|
| OPERATING_UNIT
| Operating Unit
|
| PC_DISTRIB_STATUS
| PC Distribution Status
|
| PO_DIST_LINE_NUM
| PO Distribution Line Number
|
| POSTING_DATE
| Posting Date
|
| POSTING_PROCESS
| Posting Process
|
| PRIMARY_LEDGER
| Primary Ledger
|
| PROCESS_INSTANCE
| Process Instance
|
| PRODUCT
| Product
|
| PROFILE_ID
| Asset Profile ID
|
| QTY_VCHR
| Quantity Vouchered
|
| RATE_DIV
| Rate Divisor
|
| RATE_MULT
| Rate Multiplier
|
| RECEIVER_ID
| Receipt Number
|
| RECV_DIST_LINE_NUM
| Receiver Distrib Line
|
| RECV_LN_NBR
| Receipt Line
|
| RECV_SHIP_SEQ_NBR
| Receiver Shipping Sequence
|
| REF_CLOSED
| Reference Closed
|
| REF_DIST_LINE
| Ref Dist Line
|
| REF_LINE_NUMBER
| Reference Line Number
|
| REFERENCE_NUMBER
| Reference Number
|
| RESOURCE_CATEGORY
| Resource Category
|
| RESOURCE_SUB_CAT
| Resource SubCategory
|
| RESOURCE_TYPE
| Resource Type
|
| RT_TYPE
| Rate Type
|
| SALETX_AMT
| Sales Tax Amount
|
| SALETX_AMT_BSE
| Base Sales Tax Amount
|
| SCHED_NBR
| Schedule Number
|
| SHIPTO_ID
| Ship To Location
|
| STATISTIC_AMOUNT
| Statistic Amount
|
| STATISTICS_CODE
| Statistics Code
|
| SUT_APPLICABILITY
| Sales/Use Tax Applicability
|
| SUT_BASE_ID
| Sales/Use Tax Destination
|
| TAX_AUTHORITY_CD
| Tax Authority
|
| TAX_CD_SUT
| Tax Code - Sales and Use Tax
|
| TAX_CD_SUT_PCT
| Sales/Use Tax Code Percent
|
| TAX_CD_VAT
| VAT Code
|
| TAX_CD_VAT_PCT
| VAT Tax Code Aggregate Pct
|
| USETAX_AMT
| Amount
|
| USETAX_AMT_BSE
| Base Use Tax Amount
|
| VAT_APPLICABILITY
| VAT Applicability
|
| VAT_BASIS_AMT
| VAT Basis Amt
|
| VAT_BASIS_AMT_BSE
| VAT Basis Amt in Base Curr
|
| VAT_CALC_AMT
| VAT Calculated Amount
|
| VAT_CALC_AMT_BSE
| VAT Calculated Amount Base Cur
|
| VAT_DCLRTN_DT
| VAT Declaration Date
|
| VAT_DISTRIB_STATUS
| VAT Distribution Status
|
| VAT_DSCNT_ADJ
| VAT Dscnt Adj
|
| VAT_DSCNT_ADJ_BSE
| VAT Discount Adjust Base Curr
|
| VAT_DSCNT_RCVR_BSE
| VAT Discnt Recovery Base Curr
|
| VAT_DSCNT_RCVRY
| VAT Dscnt Adj Rcvr
|
| VAT_ENTITY
| VAT Reporting Entity
|
| VAT_INV_AMT
| VAT Invoice Amount
|
| VAT_INV_AMT_BSE
| VAT Invoice Amt Base Curr
|
| VAT_INV_AMT_RPTG
| VAT Amt in Reporting Currency
|
| VAT_LN_ENT_AMT
| VAT Line Entered Amount
|
| VAT_LN_ENT_AMT_BSE
| VAT Line Entered Amt Base Curr
|
| VAT_MBASIS_AMT
| VAT Memo Basis Amount
|
| VAT_MBASIS_AMT_BSE
| VAT Memo Basis Amt Base Curr
|
| VAT_MTRANS_AMT
| VAT Memo Transaction Amount
|
| VAT_MTRANS_AMT_BSE
| VAT Memo Trans Amt Base Curr
|
| VAT_NONINV_AMT
| VAT Non-Invoice Amount
|
| VAT_NONINV_AMT_BSE
| VAT Non-Invoice Amt Base Curr
|
| VAT_RCVRY_AMT
| VAT Recovery Amt
|
| VAT_RCVRY_AMT_BSE
| VAT Recovery Amt in Base Curr
|
| VAT_REBATE_AMT
| VAT Rebate Amt
|
| VAT_REBATE_AMT_BSE
| VAT Rebate Amt in Base Curr
|
| VAT_REBATE_PCT
| VAT Rebate Percent
|
| VAT_RECOVERY_PCT
| VAT Recovery Percent
|
| VAT_TRANS_AMT
| VAT Transaction Amount
|
| VAT_TRANS_AMT_BSE
| VAT Trans Amt Base Currency
|
| VAT_TRANS_AMT_RPTG
| VAT Transaction Amt Reporting
|
| VAT_TXN_TYPE_CD
| VAT Transaction Type
|
| VAT_USE_ID
| VAT Use Type