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