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