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?