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