GPFR_PAY_EMP_S

(SQL View)
Index Back

View on GPFR_PAYMENT

View on GPFR_PAYMENT - Not used (???)

SELECT SRC_BANK_ID , CURRENCY_CD , RECIPIENT_ID , PAY_ENTITY , PMT_TYPE , PAYMENT_MTHD , PMT_STATUS , GPFR_BANK_CD , GPFR_BRANCH_EC_CD , GPFR_ACCOUNT_EC_ID , BANK_TRANSFER_ID , GPFR_BANK_NAME , GPFR_BANK_PAY_DT FROM PS_GPFR_PAYMENT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID
2 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
3 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
4 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
5 PMT_TYPE Character(2) VARCHAR2(2) NOT NULL Payment Type
01=Net Pay Distribution
02=General Recipient Deduction
03=Individual Recipient Deduction
6 PAYMENT_MTHD Character(1) VARCHAR2(1) NOT NULL Payment Method
A=Cash
C=Check
O=Pay Primary Account Only
P=Postal Order
T=Bank Transfer
U=Use Normal Distribution
W=Wire Transfer
7 PMT_STATUS Character(1) VARCHAR2(1) NOT NULL Status field for a generated payment transaction
F=Finalized
M=Manually Paid
N=No Active Allocations
P=Prepared
T=Payment Transferred
V=Hold
W=Void
8 GPFR_BANK_CD Character(11) VARCHAR2(11) NOT NULL GPFR: Bank ID
9 GPFR_BRANCH_EC_CD Character(17) VARCHAR2(17) NOT NULL GPFR: Bank Branch ID
10 GPFR_ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL GPFR: Account #
11 BANK_TRANSFER_ID Character(15) VARCHAR2(15) NOT NULL Bank Transfer ID
12 GPFR_BANK_NAME Character(24) VARCHAR2(24) NOT NULL GPFR: Receiver's Bank Name
13 GPFR_BANK_PAY_DT Character(5) VARCHAR2(5) NOT NULL GPFR: Payment Date After Formating