POS_FCLTY_FEE_V (SQL View)	Index Back
Facility fee Cash Flows Record Added BASE_CURRENCY_BNK - PAY_CYCLE_SEQ_NUM (JRC 02/26/98) Added TRANSACTION_LINE (JRC 03/11/98) 5/20/99 DJJ: Removed the following FCLTY_ID = TR_SOURCE_ID and FEE_TYPE = '1'

POS_FCLTY_FEE_V

(SQL View)

Facility fee Cash Flows Record

Added BASE_CURRENCY_BNK - PAY_CYCLE_SEQ_NUM (JRC 02/26/98) Added TRANSACTION_LINE (JRC 03/11/98) 5/20/99 DJJ: Removed the following FCLTY_ID = TR_SOURCE_ID and FEE_TYPE = '1'

SELECT C.TR_SOURCE_ID, C.ACCT_BUS_UNIT_GL, C.BUSINESS_DATE, C.SOURCE_BUS_UNIT, C.AMOUNT, C.CURRENCY_CD, C.BANK_SETID, C.BANK_CD_CUST, C.BANK_CD, C.BANK_ACCT_KEY, C.BNK_ID_NBR, C.BANK_ACCOUNT_NUM, C.RECONCILE_DT, C.RECON_STATUS, C.STTLMNT_DT_ACTUAL, C.CPTY_REFERENCE, C.PYMNT_METHOD, C.PYMNT_ID, C.CURRENCY_CD_BASE, C.BASE_AMT, C.BASE_CURRENCY_BNK, C.BNK_RATE_DIV, C.BNK_RATE_MULT, C.CUR_RT_TYPE_BNK, C.CURRENCY_PYMNT, C.PAID_AMT, C.PAID_AMT_BNK_BSE, C.PAID_AMT_BSE, C.PYMNT_RATE_DIV, C.PYMNT_RATE_MULT, D.CALENDAR_DATE, -AMOUNT, F.TRANSACTION_DT FROM PS_CASH_FLOW_TR C, PS_TR_FEE_SEQ F, PS_POS_DAYS_TBL D WHERE C.TR_SOURCE_CD = 'F' and NET_STATUS <> 'D' and C.BANK_CD = F.BANK_CD and C.BANK_ACCT_KEY = F.BANK_ACCT_KEY and D.CALENDAR_DATE = %CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FCLTY_ID Character(12) VARCHAR2(12) NOT NULL A unique key identifier that represents a given counterparty facility.

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_TRD_NONVW

3 BUSINESS_DATE Date(10) DATE Represents a date upon which business is conducted within a given company in a given country.

4 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

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

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

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

8 BANK_CD_CUST Character(5) VARCHAR2(5) NOT NULL Represents the customer bank or counterparty in a relationship that pairs differing sets of b

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

10 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_DEFN

11 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
Prompt Table: BANK_ID_VW

12 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
Prompt Table: BANK_ACCTKEY_VW

13 RECONCILE_DT Date(10) DATE The transaction reconciliation date.

14 RECON_STATUS Character(3) VARCHAR2(3) NOT NULL Reconciliation Status
ALG=Alignment Check
AMB=Ambiguous Match
AMT=Amounts Not Equal
CUR=Currency not Defined
DAT=Tran Date <> Value Date
DPI=Duplicate Input Transactions
DUP=Duplicate Transaction
MSC=Miscellaneous Transaction
NAM=Payee Names Not Equal
NTB=Not Found in Statement
NTF=Not Found In System
NTP=Not Found in POS Data
NUL=Null Transaction ID Ref
OVR=Overflow
PND=Pending Reconciliation
REC=Reconciled
RPR=Reprinted Check
RR=Requires Review - BSAC
STP=Stop Payment
TYP=Wrong Transaction Type
UNR=Unreconciled
VOI=Voided Check
Default Value: UNR

15 STTLMNT_DT_ACTUAL Date(10) DATE Date in which a deal transaction is actually settled with a counterparty.

16 CPTY_REFERENCE Character(15) VARCHAR2(15) NOT NULL A reference identifier associated with a dealing counterparty transaction.

17 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

18 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number

19 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

20 BASE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents a transaction amount calculated and stored in the base currency of its associated General Ledger bus

21 BASE_CURRENCY_BNK Character(3) VARCHAR2(3) NOT NULL The base currency of the subject bank general ledger business unit.

22 BNK_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determining whether a currency exchange spot rate is store

23 BNK_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determining whether a currency exchange spot rate is stored either as

24 CUR_RT_TYPE_BNK Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

25 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency

26 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount

27 PAID_AMT_BNK_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount - Base Bank Unit

28 PAID_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Paid Amount

29 PYMNT_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determining whether a currency exchange rate is store

30 PYMNT_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determining whether a currency exchange rate is stored

31 FORECAST_DATE Date(10) DATE Forecast Date

32 INVERSE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Inverse amount used for Actual v Projected.

33 TRANSACTION_DT Date(10) DATE Transaction date (often used as trade date)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FCLTY_ID	Character(12)	VARCHAR2(12) NOT NULL	A unique key identifier that represents a given counterparty facility.
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_TRD_NONVW
3	BUSINESS_DATE	Date(10)	DATE	Represents a date upon which business is conducted within a given company in a given country.
4	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
5	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
7	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty. Prompt Table: BANK_SETID_VW
8	BANK_CD_CUST	Character(5)	VARCHAR2(5) NOT NULL	Represents the customer bank or counterparty in a relationship that pairs differing sets of b
9	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: BANK_CD_TBL
10	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_DEFN
11	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. Prompt Table: BANK_ID_VW
12	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account. Prompt Table: BANK_ACCTKEY_VW
13	RECONCILE_DT	Date(10)	DATE	The transaction reconciliation date.
14	RECON_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Reconciliation Status ALG=Alignment Check AMB=Ambiguous Match AMT=Amounts Not Equal CUR=Currency not Defined DAT=Tran Date <> Value Date DPI=Duplicate Input Transactions DUP=Duplicate Transaction MSC=Miscellaneous Transaction NAM=Payee Names Not Equal NTB=Not Found in Statement NTF=Not Found In System NTP=Not Found in POS Data NUL=Null Transaction ID Ref OVR=Overflow PND=Pending Reconciliation REC=Reconciled RPR=Reprinted Check RR=Requires Review - BSAC STP=Stop Payment TYP=Wrong Transaction Type UNR=Unreconciled VOI=Voided Check Default Value: UNR
15	STTLMNT_DT_ACTUAL	Date(10)	DATE	Date in which a deal transaction is actually settled with a counterparty.
16	CPTY_REFERENCE	Character(15)	VARCHAR2(15) NOT NULL	A reference identifier associated with a dealing counterparty transaction.
17	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
18	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number
19	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
20	BASE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents a transaction amount calculated and stored in the base currency of its associated General Ledger bus
21	BASE_CURRENCY_BNK	Character(3)	VARCHAR2(3) NOT NULL	The base currency of the subject bank general ledger business unit.
22	BNK_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange spot rate is store
23	BNK_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange spot rate is stored either as
24	CUR_RT_TYPE_BNK	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
25	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
26	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount
27	PAID_AMT_BNK_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount - Base Bank Unit
28	PAID_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Paid Amount
29	PYMNT_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange rate is store
30	PYMNT_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange rate is stored
31	FORECAST_DATE	Date(10)	DATE	Forecast Date
32	INVERSE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Inverse amount used for Actual v Projected.
33	TRANSACTION_DT	Date(10)	DATE	Transaction date (often used as trade date)