UD PeopleSoft Financial System -
Data Dictionary
Last updated for this Record on 6/7/2003.
DISTRIB_LINE
Contains the accounting distribution (chartfields) entries when an AP voucher is saved. Monetary
amount includes freight or discounts prorated to each distribution line.
This record is a child of VOUCHER_LINE.
|
| 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)
|
| |
|
| .
|
| DISTRIB_LINE_NUM
| Distribution Line Number
| Example: 2
|
| KEY
| Type: number
| Format: uppercase
| Length: 5
| Decimals: 0
|
| | Line of a transaction from accounts payable.
|
| |
|
| .
|
| VOUCHER_ID
| Voucher ID
| Example: 00000046
|
| KEY
| Type: character
| Format: uppercase
| Length: 8
| Decimals: 0
|
| | Identifier of the voucher.
|
| |
|
| .
|
| VOUCHER_LINE_NUM
| Voucher Line Number
| Example: 1
|
| 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.
|
| |
|
| .
|
| 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.
|
| |
|
| .
|
| 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
|
| .
|
| 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
|
| .
|
| MERCHANDISE_AMT
| Merchandise Amt
| Example: 29.990
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | Dollar amount of the goods or services on an invoice.
|
| |
|
| .
|
| MONETARY_AMOUNT
| Monetary Amount
| Example: 101.000
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | The total dollar amount including freight and taxes by chartfield string
for each distributed line on a voucher.
|
| |
|
| .
|
| PO_ID
| Purchase Order
| Example: 0000000015
|
|
| Type: character
| Format: uppercase
| Length: 10
| 0
|
| | Identifies a particular Purchase Order
|
| .
|
| PROFILE_ID
| Asset Profile ID
| Example: (TBD w/ Asset Mgt)
|
|
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Not significant at UD until Asset Management Module goes live.
|
| |
|
| .
|
| 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
| Decimals: 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.
|
| |
Lookup values and translations in
PROJECT_ID_VW
|
| .
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
|
| BASE_CURRENCY
| Base Currency
|
| 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_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
|
| COST_TYPE
| Cost Type
|
| CUR_RATE_DIV
| Interunit excahnge divisor
|
| CUR_RATE_MULT
| Inter Unit Exchange Rate
|
| CUR_RT_TYPE
| Exchange Rate Type
|
| CURRENCY_CD
| Currency Code
|
| CURRENCY_RPTG
| Reporting Currency
|
| DESCR
| Description
|
| DOC_TOL_LN_STATUS
| Document Tol Line Status
|
| DSCNT_AMT
| Discount Amount
|
| DSCNT_AMT_BSE
| Base Discount Amount
|
| DSCNT_AMT_GL
| Discount Amount
|
| DSCNT_AMT_NP
| Non Prorated Discount Amount
|
| DSCNT_AMT_NP_BSE
| Non Prorated Dscnt Amount Base
|
| DSCNT_AMT_NP_GL
| Non-Prorated Discount GL Curr
|
| ECQUEUEINSTANCE
| EC Queue Instance
|
| ECTRANSID
| EC Transaction ID
|
| ECTRANSINOUTSW
| Inbound / Outbound Switch
|
| ENTRY_EVENT
| Entry Event
|
| ERROR_FLAG
| Error Flag
|
| FINAL_REF_IND
| Final Reference Indicator
|
| FOREIGN_AMOUNT
| Foreign Amount
|
| FREIGHT_AMT
| Freight Amount
|
| FREIGHT_AMT_BSE
| Base Freight Amount
|
| FREIGHT_AMT_GL
| Freight Amount
|
| FREIGHT_AMT_NP
| Freight Amount
|
| FREIGHT_AMT_NP_BSE
| Base Freight Amount
|
| FREIGHT_AMT_NP_GL
| Non-Prorated Freight GL Curr
|
| JRNL_LN_REF
| Journal Line Reference
|
| KK_CLOSE_PRIOR
| Close Prior Transaction
|
| KK_PROCESS_PRIOR
| Process Prior Document
|
| LEDGER
| Ledger
|
| LEDGER_GROUP
| Ledger Group
|
| LINE_NBR
| Line Number
|
| MEMO_AMT
| Memo Amount
|
| MEMO_AMT_BSE
| Memo Amt Base
|
| MEMO_AMT_GL
| Memo Amount
|
| MERCH_AMT_BSE
| Base Merchandise Amount
|
| MERCH_AMT_GL
| Amount In GL Bus Unit Currency
|
| MISC_AMT
| Misc. Amount
|
| MISC_AMT_BSE
| Base Misc. Amount
|
| MISC_AMT_GL
| Misc. Amount
|
| MISC_AMT_NP
| Misc. Amount
|
| MISC_AMT_NP_BSE
| Base Misc. Amount
|
| MISC_AMT_NP_GL
| Non-Prorated Misc Chgs GL Curr
|
| MONETARY_AMT_BSE
| Monetary Amount - VCHR BU Base
|
| OPEN_ITEM_STATUS
| Open Item Status
|
| OPERATING_UNIT
| Operating Unit
|
| PO_DIST_LINE_NUM
| PO Distribution Line Number
|
| PROCESS_INSTANCE
| Process Instance
|
| PRODUCT
| Product
|
| 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
|
| SALETX_AMT_GL
| Sales Tax Amount
|
| SALETX_AMT_NP
| Sales Tax Amount
|
| SALETX_AMT_NP_BSE
| Base Sales Tax Amount
|
| SALETX_AMT_NP_GL
| Non-Prorated Sales tax GL Curr
|
| SALETX_CALC_AMT
| Calculated Sales Tax Amount
|
| SALETX_CLC_AMT_BSE
| Calculated Sales Tax Base Amt
|
| SCHED_NBR
| Schedule Number
|
| SHIPTO_ID
| Ship To Location
|
| STATISTIC_AMOUNT
| Statistic Amount
|
| STATISTICS_CODE
| Statistics Code
|
| SUSPENSE_REF_NUM
| Suspense Reference Number
|
| SUT_APPLICABILITY
| Sales/Use Tax Applicability
|
| SUT_BASE_ID
| Sales/Use Tax Destination
|
| 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
|
| TXN_CURRENCY_CD
| Transaction Currency
|
| USETAX_AMT
| Amount
|
| USETAX_AMT_BSE
| Base Use Tax Amount
|
| USETAX_AMT_GL
| Amount
|
| USETAX_AMT_NP
| Base Use Tax Amount
|
| USETAX_AMT_NP_BSE
| Base Use Tax Amount
|
| USETAX_AMT_NP_GL
| Non-Prorated UseTax GL Curr
|
| VAT_APORT_CNTRL
| VAT Apportionment Control
|
| 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_DSCNT_ADJ
| VAT Dscnt Adj
|
| VAT_DSCNT_ADJ_BSE
| VAT Discount Adjust Base Curr
|
| VAT_DSCNT_ADJ_GL
| VAT Discount Adjust Base Curr
|
| VAT_DSCNT_RCVR_BSE
| VAT Discnt Recovery Base Curr
|
| VAT_DSCNT_RCVR_GL
| 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_GL
| VAT Invoice Amount Base Sum
|
| 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_NONINV_AMT_GL
| VAT Non-invoice Amt Base Sum
|
| VAT_NR_AMT_NP
| Non Prorated Non Recover VAT
|
| VAT_NR_AMT_NP_BSE
| Non Prorated Non Recover VAT
|
| VAT_NR_AMT_NP_GL
| Non Prorated Non Recover VAT
|
| VAT_NRCVR_AMT
| VAT Non Recoverable
|
| VAT_NRCVR_AMT_BSE
| VAT NonRecoverable Amount
|
| VAT_NRCVR_AMT_GL
| VAT NonRecoverable Amount
|
| VAT_RCVRY_AMT
| VAT Recovery Amt
|
| VAT_RCVRY_AMT_BSE
| VAT Recovery Amt in Base Curr
|
| VAT_RCVRY_AMT_GL
| VAT Recovery Amt Base Sum
|
| VAT_RCVRY_PCT_SRC
| VAT Recovery Percent Source
|
| VAT_REBATE_AMT
| VAT Rebate Amt
|
| VAT_REBATE_AMT_BSE
| VAT Rebate Amt in Base Curr
|
| VAT_REBATE_AMT_GL
| VAT Rebate Amt Base Sum
|
| VAT_REBATE_PCT
| VAT Rebate Percent
|
| VAT_REBATE_PCT_SRC
| VAT Rebate Percent Source
|
| VAT_RECOVERY_PCT
| VAT Recovery Percent
|
| VAT_TRANS_AMT
| VAT Transaction Amount
|
| VAT_TRANS_AMT_BSE
| VAT Trans Amt Base Currency
|
| VAT_TRANS_AMT_GL
| VAT Transaction Amount
|
| VAT_TRANS_AMT_RPTG
| VAT Transaction Amt Reporting
|
| VAT_TXN_TYPE_CD
| VAT Transaction Type
|
| VAT_USE_ID
| VAT Use Type
|
| WTHD_CD
| Withholding Code
|
| WTHD_SETID
| Withholding Setid
|
| WTHD_SW
| Withholding Applicable