FCST_FG_PAY_VW (SQL View)	Index Back
Forecast FG Payment

FCST_FG_PAY_VW

(SQL View)

Forecast FG Payment

SELECT p.pmt_id , p.src_ref_id , p.pmt_source , p.business_unit , p.acct_bus_unit_gl , p.amount , p.amount_currency_cd , p.pymnt_dt , p.pmt_status , p.bank_setid , p.bank_cd , p.bank_acct_key , p.pymnt_method , d.calendar_date FROM PS_PMT_DETAIL_TBL p , ps_pos_days_tbl d WHERE d.calendar_date = %CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PMT_ID Character(15) VARCHAR2(15) NOT NULL Payment id

2 SRC_REF_ID Character(20) VARCHAR2(20) NOT NULL Source ref id

3 PMT_SOURCE Character(10) VARCHAR2(10) NOT NULL Source System Name

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

5 ACCT_BUS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL The general ledger business unit associated with a given bank/counterparty account.

6 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

7 AMOUNT_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

8 PYMNT_DT Date(10) DATE Payment Date

9 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

10 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

11 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

12 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

13 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

14 CALENDAR_DATE Date(10) DATE An internal work field utilized to store calendar dates for a given calendar year. The dates are displa

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PMT_ID	Character(15)	VARCHAR2(15) NOT NULL	Payment id
2	SRC_REF_ID	Character(20)	VARCHAR2(20) NOT NULL	Source ref id
3	PMT_SOURCE	Character(10)	VARCHAR2(10) NOT NULL	Source System Name
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	ACCT_BUS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	The general ledger business unit associated with a given bank/counterparty account.
6	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
7	AMOUNT_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
8	PYMNT_DT	Date(10)	DATE	Payment Date
9	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
10	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
11	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
12	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
13	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
14	CALENDAR_DATE	Date(10)	DATE	An internal work field utilized to store calendar dates for a given calendar year. The dates are displa