RUN_FG1003 (SQL Table)	Index Back
Payment Type Stats Run control Run control for FG report -Payment Type Statistics

RUN_FG1003

(SQL Table)

Payment Type Stats Run control

Run control for FG report -Payment Type Statistics

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: OPR_DEF_TBL_FS

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PMT_NONVW

4 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
Prompt Table: SP_BS_PMT_NONVW

5 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
Prompt Table: BANK_CD_SECVW

6 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
Prompt Table: BANK_ACCT_SECVW

7 PMT_STATUS Character(2) VARCHAR2(2) NOT NULL Payment status
C=Canceled
CM=Cancelled with Message
E=Error
H=Flagged for Hold
L=Awaiting Dispatch
N=Not Processed
P=Paid
PC=Pending Cancellation
PR=Pending Reversal
R=Received by Bank
RM=Reversed with Message
S=Dispatched to Bank
SC=In Process

8 PMT_TYPE Character(4) VARCHAR2(4) NOT NULL Payment type
BAX=Bank Transfer
BON=Bonus
COLL=Collection
DEAL=Deal Cash Flow
EFTR=EFT Request
EXAD=Exp Advance
EXPN=Expense Sheet
FEE=Fee
GR=General Recipient Deduction
IR=Individual Recipient Deduction
NP=Net Pay Distribution
OTHR=Other
SAL=Salary
VCHR=Voucher

9 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer

10 PMT_SOURCE Character(10) VARCHAR2(10) NOT NULL Source System Name
Prompt Table: PMT_SEC_SRC_VW

11 BEGIN_DT Date(10) DATE Begin Date

12 END_DT Date(10) DATE End Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPR_DEF_TBL_FS
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PMT_NONVW
4	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty. Prompt Table: SP_BS_PMT_NONVW
5	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: BANK_CD_SECVW
6	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank Prompt Table: BANK_ACCT_SECVW
7	PMT_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Payment status C=Canceled CM=Cancelled with Message E=Error H=Flagged for Hold L=Awaiting Dispatch N=Not Processed P=Paid PC=Pending Cancellation PR=Pending Reversal R=Received by Bank RM=Reversed with Message S=Dispatched to Bank SC=In Process
8	PMT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Payment type BAX=Bank Transfer BON=Bonus COLL=Collection DEAL=Deal Cash Flow EFTR=EFT Request EXAD=Exp Advance EXPN=Expense Sheet FEE=Fee GR=General Recipient Deduction IR=Individual Recipient Deduction NP=Net Pay Distribution OTHR=Other SAL=Salary VCHR=Voucher
9	PYMNT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer
10	PMT_SOURCE	Character(10)	VARCHAR2(10) NOT NULL	Source System Name Prompt Table: PMT_SEC_SRC_VW
11	BEGIN_DT	Date(10)	DATE	Begin Date
12	END_DT	Date(10)	DATE	End Date