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

PYMNT_VCHR_XREF

This record is the bridge between the VOUCHER table and the PAYMENT_TBL. It contains the payment due dates.
This record is a child of VOUCHER.

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)
.
PYMNT_CNT Payments Example: 1
KEY Type: number Format: uppercase Length: 5 Decimals: 0
The check number.
.
VOUCHER_ID Voucher ID Example: 00000013
KEY Type: character Format: uppercase Length: 8 Decimals: 0
Identifier of the voucher.
.
APPLIED_PYMNT_ID Payment Number Example: ???
Type: character Format: uppercase Length: 10 Decimals: 0
Identifies a particular check to a particular voucher.
.
BANK_ACCT_KEY Bank Account Example: CHCK
Type: character Format: uppercase Length: 4 Decimals: 0
Designates the bank account from which the check is being cut.
.
BANK_CD Bank Code Example: 01
Type: character Format: uppercase Length: 5 Decimals: 0
Identifies an individual bank.
.
BANK_SETID Bank SetID Example: UOD01
Type: character uppe uppercase Format: uppercase Length: 5 Decimals: 0
Represents the processing rules attached to a bank.
.
DSCNT_DUE_DT Discount Due Date Example: 11/03/2003
Type: date Format: uppercase Length: 10 Decimals: 0
Designates the discount deadline date.
.
DUE_DT Due Date Example: 11/15/2003
Type: date Format: uppercase Length: 10 Decimals: 0
Due date of the voucher.
.
PAID_AMT Paid Amount Example: 1002.300
Type: signed number Format: uppercase Length: 28 Decimals: 3
The payment amount to a vendor.
.
PYMNT_ID Payment Number Example: 0000000025
Type: character Format: uppercase Length: 10 Decimals: 0
The payment identifier. (check number)
.
PYMNT_TYPE Document Type Example: R
Type: character Format: uppercase Length: 1 Decimals: 0
Describes how the payment was made - check, wire transfer, etc.
.
SCHEDULED_PAY_DT Scheduled to Pay Example: 02/20/2003
Type: date Format: uppercase Length: 10 Decimals: 0
The date the payment is scheduled to be made.
.
Fields deemed insignificant at UD, or of limited use to general campus users.
APPL_CREDIT_STATUS Apply Credit Status
BANK_ACCT_SEQ_NBR Bank Account Seq Nbr
BASE_CURRENCY Base Currency
BASE_CURRENCY_BNK Base Currency of Bank GL Unit
BNK_RATE_DIV Bank Exchange Rate Divisor
BNK_RATE_MULT Exchange Rate
BUS_UNIT_RELATED AP Business Unit
BUSINESS_UNIT_BANK Bank Business Unit
CUR_RT_TYPE_BNK Currency Rate Type
CUR_RT_TYPE_PAID Payment Rate Type
CUR_RT_TYPE_PYMNT Payment Currency Rate Type
CURRENCY_PYMNT Payment Currency
DESCR254_MIXED (No Description)
DFT_CREATE_KEY Draft Create Key
DFT_GROUP_CD Draft Group Code
DFT_MASTER_ID Draft Master ID
DFT_MAT_DT Draft Maturity Date
DFT_SCHED_MAT_DT Draft Scheduled Maturity Date
DFT_SIGHT_CD Draft Sight Code
DSCNT_AMT_BSE Base Discount Amount
DSCNT_PAY_AMT Payment Discount Amount
ECN_DSCNT_DNIE_FLG Discount Denied
EFT_PYMNT_FMT_CD Payment Format
ERROR_FLAG Error Flag
GROSS_AMT_BSE Base Gross Amount
GRP_PYMNT_DT Group by Payment Date
HOL_PROC_DAYS Days before/after Holiday
HOL_PROC_OPT Holiday Processing Option
HOL_PROC_OVERFL Allow due date in next month
LATE_CHRG_AMT Late Charge Amount
LATE_CHRG_AMT_BSE Late Charge Amount Base
LATE_CHRG_CD Late Charge Code
LATE_CHRG_DNIE Late Charge Denied
LATE_CHRG_DNIE_BSE Late Charge Paid Base
LATE_CHRG_OPT Late Charge Option
LATE_CHRG_PAID Late Charge Paid
LATE_CHRG_PAID_BSE Late Charge Paid Base
LC_ID Letter of Credit ID
NET_REF_ID Netting Reference ID
NET_SELCT_STATUS Netting Select Status
NET_TXN_STATUS Transaction Status
ORIG_PYMNT_CNT Original Payment Count
PAID_AMT_BNK_BSE Paid Amount - Base Bank Unit
PAID_AMT_BSE Base Paid Amount
PAID_AMT_DSCNT Discount on Paid Amount
PAID_AMT_DSCNT_BSE Base Discount Paid Amount
PAID_AMT_GROSS Gross Paid Amount
PAID_AMT_GROSS_BSE Base Gross Payment Amount
PAID_RATE_DIV Payment Exchange Rate Divisor
PAID_RATE_MULT Payment Exchange Rate Mult
PAY_CYCLE Pay Cycle
PAY_CYCLE_SEQ_NUM Pay Cycle Sequence Number
POST_STATUS_AP Post Status
POST_STATUS_WTHD Withholding Post Status
PREPAID_APPL_PYMNT Applied Payment Count
PREPAID_APPL_VCHR Applied Voucher ID
PREPAID_APPLIED_BU Applied Business Unit
PREPAID_STATUS Prepaid Status
PROCESS_INSTANCE Process Instance
PYMNT_ACTION Payment Action
PYMNT_APPR_STATUS Approval Status
PYMNT_CNT_RELATED Payment
PYMNT_GROSS_AMT Gross Payment Amount
PYMNT_GROUP_CD Pay Group Code
PYMNT_HANDLING_CD Payment Handling
PYMNT_HOLD Hold Payment
PYMNT_HOLD_CD Payment Hold Code
PYMNT_HOLD_REASON Hold Reason
PYMNT_HOLD_WTHD On Withholding Hold
PYMNT_MESSAGE Payment Message
PYMNT_METHOD Payment Method
PYMNT_RATE_DIV Payment Exchange Rate Divisor
PYMNT_RATE_MULT Payment Exchange Rate Mult
PYMNT_REASON_CD Payment Reason Code
PYMNT_SELCT_STATUS Payment Selection Status
PYMNT_SEPARATE Separate Payment
RATE_DIV Rate Divisor
RATE_MULT Rate Multiplier
REMIT_ADDR_SEQ_NUM Remitting Location
REMIT_BANK_CD Remit Bank Code
REMIT_BANK_SETID Remit Bank Setid
REMIT_BNK_ACCT_KEY Remit Bank Account
REMIT_SETID Remit SetID
REMIT_VENDOR Remit Vendor
RT_TYPE Rate Type
RVL_AMT_BSE Revalued Amount
RVL_AMT_DSCNT_BSE Revalued Discount Amount
RVL_DTTM Revaluation DateTime
RVL_RATE_DIV Revaluation Exchange Rate Div
RVL_RATE_MULT Revaluation Exchange Rate Mult
RVL_RT_TYPE Rate Type
SCHEDULE_ID Schedule ID
SINGLE_PYMNT_FLG Single Payment
SOURCE_TXN Source Transaction
SPEC_PYMNT_EX_RT Specify Pymnt Ex Rate
TXN_CURRENCY_CD Transaction Currency
VNDR_LOC Vendor Location
VNDR_PYMNT_HLD_FLG Vendor Payment Hold
VOUCHER_ID_RELATED Related Voucher
WTHD_ADDTL_GROSS Additional Withheld Gross Amt
WTHD_PYMNT_CNT Wthd Payment Count