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

VOUCHER_LINE

Contains detailed information for each AP voucher, such as description of goods/services, quantity, unit price, purchase order ID.
This record is a child of VOUCHER.
Further details are in this record's child: DISTRIB_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).
.
VOUCHER_ID Voucher ID Example: 00000016
KEY Type: character Format: uppercase Length: 8 Decimals: 0
Identifier of the voucher.
.
VOUCHER_LINE_NUM Voucher Line Number Example: 1, 2
KEY Type: number Format: uppercase Length: 5 Decimals: 0
Line number on a voucher.
.
CNTRCT_ID Buying Agreement ID Example: ???
Type: character Format: uppercase Length: 25 Decimals: 0
Identifier of an individual contract.
.
CNTRCT_LINE_NBR Buying Agreement Line Nbr Example: 1, 2
Type: number Format: uppercase Length: 5 Decimals: 0
A line number of a contract.
.
DESCR Description Example: bookshelf
Type: character Format: lowercase Length: 30 Decimals: 0
Description
.
LINE_NBR Line Number Example: 1, 2
numb number Type: number Format: uppercase Length: 5 Decimals: 0
The line number of the voucher.
.
MATCH_LINE_STATUS Match Line Status Example: ???
Type: character Format: uppercase Length: 1 Decimals: 0
Denotes if the line number has been matched.
.
MERCHANDISE_AMT Merchandise Amt Example: 50.500
Type: signed number Format: uppercase Length: 28 Decimals: 3
The dollar amount of goods and services on an individual voucher line.
.
PO_ID Purchase Order Example: 0000000015
Type: character Format: uppercase Length: 10 Decimals: 0
Identifies a particular Purchase Order
.
QTY_VCHR Quantity Vouchered Example: 6.0000
Type: signed number Format: uppercase Length: 17 Decimals: 4
Numeric amount of goods and services (quantity).
.
UNIT_PRICE Unit Price Example: 16.990
Type: signed number Format: uppercase Length: 17 Decimals: 5
Price per unit.
.
Fields deemed insignificant at UD, or of limited use to general campus users.
AMT_ONLY_FLG Amount Only
BASE_CURRENCY Base Currency
BUS_UNIT_RELATED AP Business Unit
BUSINESS_UNIT_PO PO Business Unit
BUSINESS_UNIT_RECV Receiving Business Unit
BUSINESS_UNIT_RTV RTV Business Unit
CURRENCY_CD Currency Code
DESCR254_MIXED (No Description)
DISTRIB_MTHD_FLG Distribute by
DSCNT_APPL_FLG Apply Discount
ECQUEUEINSTANCE EC Queue Instance
ECTRANSID EC Transaction ID
ECTRANSINOUTSW Inbound / Outbound Switch
ERROR_FLAG Error Flag
FINAL_REF_IND Final Reference Indicator
FISCAL_REGIME Fiscal Regime
FRGHT_PRORATE_FLG Prorate Freight Charges
GEO_CODE Tax Vendor Geographical Code
INSPECT_DT Inspection Date
INV_ITEM_ID Item ID
ITM_SETID Item SetID
MATCH_LINE_OPT Match Line Option
MAX_DISTRIB_LINE Highest Distribution Line
MERCH_AMT_BSE Base Merchandise Amount
NATURE_OF_TXN1 Nature of Transaction 1
NATURE_OF_TXN2 Nature of Transaction 2
PROCESS_INSTANCE Process Instance
RECEIPT_DT Received Date
RECEIVER_ID Receipt Number
RECV_LN_NBR Receipt Line
RECV_SHIP_SEQ_NBR Receiver Shipping Sequence
RELEASE_NBR Release Number
RTV_ID Return To Vendor ID
RTV_LN_NBR Return To Vendor Line
SCHED_NBR Schedule Number
SHIPTO_ID Ship To Location
SPEEDCHART_KEY SpeedChart Key
STATISTIC_AMOUNT Statistic Amount
SUT_APPLICABILITY Sales/Use Tax Applicability
SUT_BASE_ID Sales/Use Tax Destination
SUT_EXCPTN_CERTIF Sales/Use Tax Exception Certif
SUT_EXCPTN_TYPE Sales/Use Tax Exception Type
TAX_CD_SUT Tax Code - Sales and Use Tax
TAX_CD_VAT VAT Code
TOTAL_DISTRIBS Total Number of Distributions
TXN_CURRENCY_CD Transaction Currency
ULTIMATE_USE_CD Ultimate Use Code
UNIT_OF_MEASURE Unit of Measure
VAT_APPLICABILITY VAT Applicability
VAT_ENTITY VAT Reporting Entity
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_RECOVERY_PCT VAT Recovery Percent
VAT_TXN_TYPE_CD VAT Transaction Type
VAT_USE_ID VAT Use Type
VCHR_AMT_FORCE_FLG Force Unit Price
VENDOR_ID Vendor ID
VNDR_LOC Vendor Location
VOUCHER_ID_RELATED Related Voucher
WTHD_CD Withholding Code
WTHD_SETID Withholding Setid
WTHD_SW Withholding Applicable