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

PAYMENT_TBL

Contains the AP payment information including check, ACH, manual payments, payment date, remit vendor. This is like an AP check register.
BANK_ACCT_KEY Bank Account Example: CHCK
KEY 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
KEY Type: character Format: uppercase Length: 5 Decimals: 0
Identifies an individual bank.
.
BANK_SETID Bank SetID Example: UOD01
KEY Type: character Format: uppercase Length: 5 Decimals: 0
Represents the processing rules attached to a bank.
.
PYMNT_ID Payment Number Example: 0000000009
KEY Type: character Format: uppercase Length: 10 Decimals: 0
The payment identifier. (check number)
.
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.
.
ADDRESS1 Address Line 1 Example: 222 . CHAPEL STREET
Type: character Format: mixed Length: 55 Decimals:
First line of the address.
.
ADDRESS2 Address Line 2 Example: SUITE 101
Type: character Format: mixed 55Length: 55
Second line of the address.
.
ADDRESS3 Address Line 3 Example: BUILDING A
Type: character Format: mixed Length: 55 Decimals:
Third line of the address.
.
ADDRESS4 Address Line 4 Example: ROOM 201
Type: character Format: mixed Length: 55 Decimals:
Fourth line of the address.
.
CITY City Example: NEWARK
Type: character Format: mixed Length: 30 Decimals:
City or town of address.
.
COUNTRY Country Example: USA
Type: character Format: uppercase Length: 3 Decimals:
Country portion of the address.
.
EMPLID EmplID Example:
Type: character Format: uppercase Length: 11 Decimals: 0
Employee ID from HR system.
.
NAME1 Name 1 Example: UNIGLOBE CHARLIE B TRAVELS
Type: character Format: lowercase Length: 40 Decimals: 0
First line of the name of who an A/P payment is made to.
.
POST_STATUS_AP Post Status Example: P
Type: character Format: uppercase Length: 1 Decimals: 0
Whether the A/P payment has been posted to the general ledger.
.
POSTAL Postal Code Example: 19716-0000
Type: character Format: custom Length: 12 Decimals:
Zip code or equivalent.
.
PYMNT_AMT Payment Amount Example: 250.000
Type: signed number Format: uppercase Length: 28 Decimals: 3
Amount paid to a vendor.
.
PYMNT_DT Payment Date Example: 11/26/2002
Type: date Format: uppercase Length: 10 Decimals: 0
Date the A/P payment was made.
.
PYMNT_STATUS Payment Status Example: P, V
char character Type: character Format: uppercase Length: 1 Decimals: 0
Status of the payment. Void, reissued, paid.
.
REMIT_VENDOR Remit Vendor Example: 0000000101
Type: character Format: uppercase Length: 10 Decimals: 0
Vendor the payment was made to.
.
STATE State Example: DE
Type: character Format: uppercase Length: 6 Decimals:
State in an address.
.
Fields deemed insignificant at UD, or of limited use to general campus users.
ACHIEVE_DT Achieve Date
ADDR_FIELD1 Address Field 1
ADDR_FIELD2 Address Field 2
ADDR_FIELD3 Address Field 3
BANK_ACCOUNT_NUM Bank Account #
BNK_ID_NBR External Bank ID
BRANCH_ID Branch ID
BRANCH_NAME Branch Name
BUSINESS_UNIT_GL General Ledger Unit
CANCEL_ACTION Cancel Action
CANCEL_DT Date Cancelled
CANCEL_POST_STATUS Cancel Post Status
CASH_CLEARED_DT Cash Cleared Date
CASH_CLEARED_FLG Cash Cleared Flag
CHECK_DIGIT Check Digit
COUNTY County
CREATION_DT Creation Date
CURRENCY_PYMNT Payment Currency
DESCRLONG Description
DFI_ID_NUM DFI ID
DFI_ID_QUAL DFI Qualifier
DFT_APPROVAL_DT Draft Approval Date
DFT_APPROVE_FLAG Draft Issue Approval Required
DFT_CONTROL_ID Draft Control ID
DFT_DRAWEE Draft Drawee
DFT_MASTER_ID Draft Master ID
DFT_MAT_DT Draft Maturity Date
DFT_OPT_FLG Draft Optimization
DFT_STATUS Draft Payment Status
DFT_STMP_TAX_AMT Draft StampTax Amount
DFT_TYPE Draft Type
DFT_WO_ACCT Draft writeOff Account
DFT_WO_ALTACCT Write-off Alt Acct
DFT_WO_DT Draft Write-Off Date
DOC_SEQ_DATE Document Sequence Date
DOC_SEQ_NBR Document Sequence Number
DOC_SEQ_STATUS Document Sequencing Status
DOC_TYPE Document Type
EFT_PYMNT_FMT_CD Payment Format
EFT_TRANS_HANDLING Transaction Handling
ESCHEATED_DT Stale Date
FORM_NBR_CONFIRMED Check Number Confirmed
GEO_CODE Tax Vendor Geographical Code
HOUSE_TYPE House Type
IN_CITY_LIMIT In City Limit
IN_PROCESS_FLG In Process
LC_ID Letter of Credit ID
MICR_LINE MICR Line
NAME2 Name 2
NUM1 Number 1
NUM2 Number 2
OPRID User ID
PAY_CYCLE Pay Cycle
PAY_CYCLE_SEQ_NUM Pay Cycle Sequence Number
POSITIVE_PAY_DT Positive Payment Date
POSITIVE_PAY_STAT Positive Payment Status
PREFERRED_LANGUAGE Preferred Language
PROCESS_INSTANCE Process Instance
PYMNT_HANDLING_CD Payment Handling
PYMNT_ID_REF Payment Reference
PYMNT_METHOD Payment Method
PYMNT_RECONCILE_DT Date Reconciled
PYMNT_TYPE Document Type
RECON_CYCLE_NBR Statement ID
RECON_STATUS Recon Status
RECON_TYPE Reconciliation Type
RECONCILE_OPRID User ID
REMIT_BANK_ACCOUNT Bank Account Number
REMIT_BRANCH_ID Branch ID
REMIT_CHECK_DIGIT Check Digit
REMIT_SETID Remit SetID
REP_RTNG_NUM Routing Code
REPLACED_DT Replacement Date
SCHEDULE_ID Schedule ID
SOURCE_TXN Source Transaction
STTLMNT_DT_ACTUAL Actual Settlement Date
STTLMNT_DT_EST Est Settlement Date
TREASURY_PMT_NBR Payment Confirm Number
VALUE_DT Payment Date
VNDR_LOC Vendor Location