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