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