UD PeopleSoft Financial System - Data Dictionary
Last updated for this Record on 6/7/2003.

PO_LINE_DISTRIB

Contains the accounting distribution (chartfields) entries when a PO is saved.
This record is a child of PO_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: 1
KEY Type: number Format: uppercase Length: 5 Decimals: 0
Line of a transaction from accounts payable.
.
DST_ACCT_TYPE Accounting Entry Type Example: DST
KEY Type: character Format: uppercase Length: 4 Decimals: 0
Designates account type (expense/liability) of a transaction.
.
LINE_NBR Line Number Example: 3
KEY Type: number Format: uppercase Length: 5 Decimals: 0
The line number of the accounting string for each PO line item. Each PO line number may have many distribution lines.
.
PO_ID Purchase Order Example: 0000000015
KEY Type: character Format: uppercase Length: 10 Decimals: 0
Identifies a particular Purchase Order
.
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
.
ACTIVITY_ID Activity ID (TBD w/ Projects) 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.
.
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
.
EMPLID EmplID Example:
Type: character Format: uppercase Length: 11 Decimals: 0
Employee ID from HR system.
.
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: 2500.000
Type: signed number Format: uppercase Length: 28 Decimals: 3
The dollar amount of goods and services on a PO line by chartfield string.
.
MONETARY_AMOUNT Monetary Amount Example: 606.000
Type: signed number Format: uppercase Length: 28 Decimals: 3
The total dollar amount for a chartfield string for the PO line that can include freight and taxes.
.
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.
.
REQ_ID Requisition ID Example: 0000000030
Type: character Format: uppercase Length: 10 Decimals: 0
Identifier of a requisition.
.
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
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_IN Inventory Business Unit
BUSINESS_UNIT_PC PC Business Unit
BUSINESS_UNIT_REQ Requesting Business Unit
CAP_NUM Capital Acquisition Plan #
CAP_SEQUENCE CAP Sequence
CHARTFIELD_STATUS Chartfield Status
CLOSE_AMOUNT Close Amount
CLOSE_AMOUNT_BSE Close Base Amount
CONSIGNED_FLAG Consigned Flag
COST_TYPE Cost Type
CURRENCY_CD Currency Code
CURRENCY_CD_BASE Business Unit Base Currency
DIST_PROCESSED_FLG Distribution Processed
DISTRIB_LN_STATUS Distribution Line Status
DISTRIB_PCT Distribution Percentage
DISTRIB_TYPE Distrib. Type
DOC_TOL_LN_STATUS Document Tol Line Status
ENTRY_EVENT Entry Event
FINANCIAL_ASSET_SW Capitalized Asset
FREIGHT_AMT Freight Amount
FREIGHT_AMT_BSE Base Freight Amount
FREIGHT_AMT_NP Freight Amount
FREIGHT_AMT_NP_BSE Base Freight Amount
INVOICE_CLOSE_IND Invoice Close Indicator
KK_CLOSE_FLAG Commitment Control Close Flag
KK_CLOSE_PRIOR Close Prior Transaction
KK_PROCESS_PRIOR Process Prior Document
LOCATION Location Code
MERCH_AMT_BSE Base Merchandise Amount
MISC_AMT Misc. Amount
MISC_AMT_BSE Base Misc. Amount
MISC_AMT_NP Misc. Amount
MISC_AMT_NP_BSE Base Misc. Amount
MONETARY_AMT_BSE Monetary Amount - VCHR BU Base
OPERATING_UNIT Operating Unit
PC_DISTRIB_AMT PC Distribution Amount
PC_DISTRIB_AMT_BSE PC Distribution Base Amount
PC_DISTRIB_STATUS PC Distribution Status
PO_POST_AMT Post Amount
PO_POST_AMT_BSE Post Base Amount
PO_POST_STATUS Post Status
PROCESS_INSTANCE Process Instance
PROCESS_MAN_CLOSE Process Manual Close
PRODUCT Product
PROFILE_ID Asset Profile ID
PUBLISHED_IBU Inventory Business Unit
QTY_PO Purchase Order Quantity
QTY_REQ Requisition Quantity
RATE_DIV Rate Divisor
RATE_MULT Rate Multiplier
REQ_DISTRIB_NBR Requisition Distrib Number
REQ_LINE_NBR Requisition Line Number
REQ_SCHED_NBR Requisition Schedule Number
RESOURCE_CATEGORY Resource Category
RESOURCE_SUB_CAT Resource SubCategory
RESOURCE_TYPE Resource Type
ROLL_STAT_R Rolled
RT_TYPE Rate Type
SALETX_AMT Sales Tax Amount
SALETX_AMT_BSE Base Sales Tax Amount
SALETX_PRORATE_FLG Prorate Sales Tax
SCHED_NBR Schedule Number
STATISTIC_AMOUNT Statistic Amount
STATISTICS_CODE Statistics Code
SUT_APPLICABILITY Sales/Use Tax Applicability
SYSTEM_SOURCE System Source
TAG_NUMBER Tag Number
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
USETAX_PRORATE_FLG Prorate Use Tax
VAT_AMT VAT Amount
VAT_AMT_BASE VAT Amount - Base Currency
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_TYPE Calculation Type
VAT_NRCVR_PRO_FLG Prorate Non-Recoverable VAT
VAT_PRORATE_FLG Prorate VAT
VAT_RCVRY_AMT VAT Recovery Amt
VAT_RCVRY_AMT_BSE VAT Recovery Amt in Base Curr
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_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_TXN_TYPE_CD VAT Transaction Type
VAT_USE_ID VAT Use Type