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