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

VOUCHER

This is the main AP voucher table, it contains invoice number, invoice date, vendor, gross amount, freight.
Further details are in this record's child: PYMNT_VCHR_XREF.
Further details are in this record's child: VOUCHER_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: 00000010
KEY Type: character Format: uppercase Length: 8 Decimals: 0
Identifier of the voucher.
.
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.
.
ADDRESS_SEQ_NUM Address Sequence Number Example: 1
Type: number Format: uppercase Length: 3 Decimals: 0
Represents the sequence in which multiple addresses are recorded.
.
CLOSE_STATUS Close Status Indicator Example: O
Type: character Format: uppercase Length: 1 Decimals: 0
Designates whether or not a voucher is closed.
.
CNTRCT_ID Buying Agreement ID Example: ???
Type: character Format: uppercase Length: 25 Decimals: 0
Identifier of an individual contract.
.
ENTRY_STATUS Entry Status Example: P
Type: character Format: uppercase Length: 1 Decimals: 0
Status of the voucher entry. Posted = P; Approved= A; Error=E.
.
FREIGHT_AMT Freight Amount Example: 20.000
Type: signed number Format: uppercase Length: 28 Decimals: 3
Amount vendor charged for freight.
.
GROSS_AMT Gross Invoice Amount Example: 25.000
Type: signed number Format: uppercase Length: 28 Decimals: 3
Total dollar amount on the voucher.
.
INV_RECPT_DT Invoice Receipt Date Example: 03/11/2001
Type: date Format: uppercase Length: 10 Decimals: 0
Date the invoice is received in A/P.
.
MATCH_STATUS_VCHR Match Status Example: N, E, M
Type: character Format: uppercase Length: 1 Decimals: 0
Denotes if the PO has been matched to a voucher and possibly a receiver.
.
MERCHANDISE_AMT Merchandise Amt Example: 2002.600
Type: signed number Format: uppercase Length: 28 Decimals: 3
The dollar amount of goods and services on a voucher.
.
PO_ID Purchase Order Example: 0000000015
Type: character Format: uppercase Length: 10 Decimals: 0
Identifies a particular Purchase Order
.
POST_STATUS_AP Post Status Example: P=posted, U=unposted
Type: character Format: uppercase Length: 1 Decimals: 0
Whether a voucher has been posted to the general ledger.
.
VENDOR_ID Vendor ID Example: 0000000001
Type: character Format: uppercase Length: 10 Decimals: 0
Identifier of the vendor.
.
Fields deemed insignificant at UD, or of limited use to general campus users.
APPR_CHECK_FLG Approval Check Flag
APPR_INSTANCE Approval Instance
APPR_RULE_SET Approval Rule Set
APPR_STATUS Approval Status
BASE_CURRENCY Base Currency
BASIS_DATE Payment Terms Basis Date
BCM_HDR_STATUS Budget Checking Header Status
BCM_TRAN_TYPE Transaction Type
BUDGET_HDR_STATUS Budget Checking Header Status
BUDGET_MISC_STATUS Budget Checking Misc Status
BUSINESS_UNIT_GL General Ledger Unit
BUSINESS_UNIT_PO PO Business Unit
BUSPROCNAME Business Process Name
COUNTRY_SHIP_FROM Ship From Country
COUNTRY_SHIP_TO Ship to Country
COUNTRY_VAT_BILLFR Seller's Registration Country
COUNTRY_VAT_BILLTO Buyer's Registration Country
COUNTRY_VAT_RPTG VAT Reporting Country
CUR_RT_SOURCE Exchange Rate Source
CURRENCY_RPTG Reporting Currency
DATE_CALC_BASIS Date Calculation Basis
DELETE_DT Deletion Date
DESCR254_MIXED (No Description)
DOC_SEQ_DATE Document Sequence Date
DOC_SEQ_NBR Document Sequence Number
DOC_SEQ_STATUS Document Sequencing Status
DOC_TOL_HDR_STATUS Document Tolerance Status
DOC_TYPE Document Type
DSCNT_AMT Discount Amount
DSCNT_AMT_BSE Base Discount Amount
DSCNT_AMT_FLG Discount Amount Control
DSCNT_DUE_DT Discount Due Date
DSCNT_PRORATE_FLG Prorate Discount
DST_CNTRL_ID Accounting Template
DUE_DT Due Date
DUE_DT_FLG Due Date Control
DUP_INVOICE_STATUS Duplicate Invoice Status
ECQUEUEINSTANCE EC Queue Instance
ECTRANSID EC Transaction ID
ECTRANSINOUTSW Inbound / Outbound Switch
EIN_FEDERAL EIN Federal
EIN_STATE_LOCAL EIN State Local
ENTERED_DT Entered on
ERROR_FLAG Error Flag
ERS_INV_SEQ ERS Invoice Sequence
ERS_TAX_TYPE ERS Tax Type
ERS_TYPE ERS Type
FREIGHT_AMT_BSE Base Freight Amount
FRGHT_PRORATE_FLG Prorate Freight Charges
GROSS_AMT_BSE Base Gross Amount
GRP_AP_ID Control Group ID
IMAGE_DATE Image Date
IMAGE_REF_ID Image Reference ID
IN_PROCESS_FLG In Process
INSPECT_DT Inspection Date
INTERUNIT_ERR_FLG Inter Unit Error Flag
INVOICE_DT Invoice Date
INVOICE_ID Invoice Number
INVOICE_RCPT_DT Invoice Receipt Date
IST_TXN_FLG Intrastat Transaction Flag
KK_TRAN_OVER_DTTM Override Date
KK_TRAN_OVER_FLAG Override Transaction
KK_TRAN_OVER_OPRID Override User ID
LAST_UPDATE_DT Last Updated
LC_EXTRCT_STATUS Landed Cost Extract Status
LC_ID Letter of Credit ID
MANUAL_CLOSE_DT Manual Close Date
MATCH_ACTION Match Action
MATCH_OVERRIDE Match Override
MEMO_AMT Memo Amount
MEMO_AMT_BSE Memo Amt Base
MERCH_AMT_BSE Base Merchandise Amount
MISC_AMT Misc. Amount
MISC_AMT_BSE Base Misc. Amount
MISC_PRORATE_FLG Prorate Miscellaneous Charge
MTCH_LEVEL_OPT Matching Level
MTCH_LEVEL_STATUS Match Leve Status
OPRID User ID
OPRID_LAST_UPDT Last User to Update
ORIGIN Origin
PACKSLIP_NO Packing Slip Number
PAY_AMT Payment Amount
PAY_AMT_BASE Payment Amt - Base Curr
PAY_SCHEDULE_TYPE Pay Schedule Type
PAY_TRM_BSE_DT_OPT Payment Terms Basis Date Type
PO_RECPT_DT Purchase Order Receipt Date
POST_STATUS_WTHD Withholding Post Status
POST_VOUCHER Post Voucher Now
PREPAID_AUTO_APPLY Automatically Apply Prepayment
PREPAID_REF Prepayment Reference
PROCESS_INSTANCE Process Instance
PROCESS_MAN_CLOSE Process Manual Close
PYMNT_CNT_MAX Max payment count
PYMNT_CNT_TOTAL Total Payment Count
PYMNT_TERMS_CD Payment Terms ID
RATE_DIV Rate Divisor
RATE_DIV_VAT Rate Divisor
RATE_MULT Rate Multiplier
RATE_MULT_VAT Rate Multiplier
RECEIPT_DT Received Date
RECV_ONLY_MTCH_FLG Receipt Only Match
REMIT_ADDR_SEQ_NUM Remitting Location
REVALUE_FLAG Revaluation Flag
RT_TYPE Rate Type
SALETX_AMT Sales Tax Amount
SALETX_AMT_BSE Base Sales Tax Amount
SALETX_CALC_AMT Calculated Sales Tax Amount
SALETX_CLC_AMT_BSE Calculated Sales Tax Base Amt
SALETX_PRORATE_FLG Prorate Sales Tax
SBI_DOC_OPT SBI Numbering Options
SBI_FLG SBI Applicable
SBI_IN_PROCESS_FLG SBI In Process
SBI_NUM Self-Billed Invoice ID number
SBI_PROCESS_ID Process Instance
SHIP_DATE Item Shipping Date
TAX_CD_VAT VAT Code
TAX_EXEMPT Tax Exempt Flag
TAX_GRP Tax Group Code
TAX_PYMNT_TYPE Tax Payment Type Code
TERMS_BASIS_DT Payment Terms Basis Date
TIME_EDIT Cumulative Edit Time
TXN_CURRENCY_CD Transaction Currency
UNMTCH_PAY_FLG Pay UnMatched Voucher
UNMTCH_PAY_STATUS UnMatched Pay Status
USETAX_AMT Amount
USETAX_AMT_BSE Base Use Tax Amount
USETAX_PRORATE_FLG Prorate Use Tax
VAT_ADVPAY_FLG VAT on Advance Payments
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_CALC_FRGHT_FLG Include Freight
VAT_CALC_GROSS_NET Calculate at Gross or Net
VAT_CALC_MISC_FLG Include Miscellaneous
VAT_CALC_TYPE Calculation Type
VAT_CF_ANLSYS_TYPE VAT Chartfield Analysis
VAT_DCLRTN_DT VAT Declaration Date
VAT_DCLRTN_DT_SRC Declaration Date Source
VAT_DCLRTN_POINT Declaration Point
VAT_DCMNT_ID VAT Document ID
VAT_ENTITY VAT Reporting Entity
VAT_ENTRD_AMT Entered VAT Amount
VAT_EXCPTN_CERTIF VAT Certificate ID
VAT_EXCPTN_TYPE Exception Type
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_NONINV_AMT VAT Non-Invoice Amount
VAT_NONINV_AMT_BSE VAT Non-Invoice Amt Base Curr
VAT_NRCVR_AMT VAT Non Recoverable
VAT_NRCVR_AMT_BSE VAT NonRecoverable Amount
VAT_NRCVR_CHRG_CD ProrateVAT Non-Recovery
VAT_NRCVR_PRO_FLG Prorate Non-Recoverable VAT
VAT_RCRD_INPT_FLG Record Input VAT
VAT_RCRD_OUTPT_FLG Record Output VAT
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_RECALC_FLG Recalculate at Payment
VAT_RECOVERY_PCT VAT Recovery Percent
VAT_RGSTRN_SELLER Seller's VAT Registration
VAT_ROUND_RULE VAT Rounding Rule
VAT_RPTG_CURR_CTRL VAT Reporting Currency Control
VAT_RPTG_CURR_FLG Amounts in Reporting Currency
VAT_TRANS_AMT VAT Transaction Amount
VAT_TRANS_AMT_BSE VAT Trans Amt Base Currency
VAT_TRANS_AMT_RPTG VAT Transaction Amt Reporting
VAT_TREATMENT_PUR VAT Treatment Pur
VAT_TXN_TYPE_CD VAT Transaction Type
VAT_USE_ID VAT Use Type
VCHR_APPRVL_FLG Voucher Approval Flag
VCHR_BAL_ERR_FLG Voucher Balance Error
VCHR_MTCH_ADJ_OPT Match Exception Adjustment Opt
VCHR_POADJ_OPT Adjust Purchase Order
VCHR_SRC Voucher Source
VCHR_SYSGEN_FLG System Generated
VCHR_TEMPLATE_ID Template ID
VCHR_TMPLTE_DESCR Description
VCHR_TTL_LINES Lines Entered
VENDOR_SETID Vendor Set ID
VNDR_AFFILIATE Vendor Affiliate
VNDR_LOC Vendor Location
VNDR_TMPLTE_FLG Vendor Template Flag
VOUCHER_ID_RELATED Related Voucher
VOUCHER_STYLE Voucher Style
VOUCHER_TYPE Voucher Type
WTHD_ADJUST_FLG Withhodling Adjustments
WTHD_FISCAL_YR Withholding Year
WTHD_PREPAY_OPT Postpone Withholding?