GP_PYMT_ID_ASGN (SQL Table)	Index Back
Payment ID Assignment This table contains the assignment of Payment ID to a source bank and a payment method.

GP_PYMT_ID_ASGN

(SQL Table)

Payment ID Assignment

This table contains the assignment of Payment ID to a source bank and a payment method.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID
Prompt Table: SRC_BANK

2 PAYMENT_MTHD1 Character(1) VARCHAR2(1) NOT NULL Zero Net payment method
N=Negative Net
Z=Zero Net
Prompt Table: GP_X_PMTMTH3_VW

3 PYMT_ID Character(6) VARCHAR2(6) NOT NULL Payment Identification
Prompt Table: GP_PYMT_ID_DEFN

4 RECON_STAT Character(2) VARCHAR2(2) NOT NULL Reconciliation Status
01=Unreconciled
02=Reconciled
03=Date Difference
04=Not Found
05=Amount Difference
06=Duplicate
07=Expired
08=Stop Payment
09=Unclaimed
10=Different Pay Method
11=Void
12=Re-Numbered

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID Prompt Table: SRC_BANK
2	PAYMENT_MTHD1	Character(1)	VARCHAR2(1) NOT NULL	Zero Net payment method N=Negative Net Z=Zero Net Prompt Table: GP_X_PMTMTH3_VW
3	PYMT_ID	Character(6)	VARCHAR2(6) NOT NULL	Payment Identification Prompt Table: GP_PYMT_ID_DEFN
4	RECON_STAT	Character(2)	VARCHAR2(2) NOT NULL	Reconciliation Status 01=Unreconciled 02=Reconciled 03=Date Difference 04=Not Found 05=Amount Difference 06=Duplicate 07=Expired 08=Stop Payment 09=Unclaimed 10=Different Pay Method 11=Void 12=Re-Numbered