BNK_RVL_TR_PYMN (SQL View)	Index Back
Recon view: TR Cashflows Reconciliation view over CASH_FLOW_TR for Treasury Cashflows

BNK_RVL_TR_PYMN

(SQL View)

Recon view: TR Cashflows

Reconciliation view over CASH_FLOW_TR for Treasury Cashflows

SELECT CF.TR_SOURCE_CD , CF.SOURCE_BUS_UNIT , CF.TR_SOURCE_ID , CF.BUSINESS_DATE , CF.CASH_FLOW_LINE , CF.CASH_FLOW_LEG , CF.SEQ_NBR , CF.PAY_DOC_SEQ , CF.AMOUNT , CF.CURRENCY_CD , CF.BANK_SETID , CF.BANK_CD_CUST , CF.BANK_CD , CF.BANK_ACCT_KEY , CF.ACCT_BUS_UNIT_GL , CF.BNK_ID_NBR , CF.BANK_ACCOUNT_NUM , CF.TRANSACTION_LINE , CF.RECONCILE_DT , CF.RECONCILE_OPRID , CF.RECON_TYPE , CF.RECON_STATUS , CF.RECON_CYCLE_NBR , CF.RECORD_SEQ_NUMBER , CF.STTLMNT_DT_ACTUAL , CF.CPTY_REFERENCE , CF.NET_REF_ID , CF.CF_SOURCE_REF_ID , CF.CP_NETTOR , CF.PYMNT_METHOD , CF.SETTLEMENT_ID , CF.PYMNT_ID , CF.CURRENCY_CD_BASE , CF.BASE_AMT , CF.BASE_CURRENCY_BNK , CF.BNK_RATE_DIV , CF.BNK_RATE_MULT , CF.CUR_RT_TYPE_BNK , CF.CURRENCY_PYMNT , CF.PAID_AMT , CF.PAID_AMT_BNK_BSE , CF.PAID_AMT_BSE , CF.PYMNT_RATE_DIV , CF.PYMNT_RATE_MULT , CF.PAY_CYCLE , CF.PAY_CYCLE_SEQ_NUM , CF.BANK_STMT_DT , CF.RECON_RUN_ID , %Round(%DecMult(%DecDiv(CF.AMOUNT , B.RATE_DIV) , B.RATE_MULT) , B.DECIMAL_POSITIONS) , CF.STL_THROUGH , CF.REPETITVE_TRNFR_CD , CF.DRAWDOWN_FLG , CF.PMT_ID , CF.FORMAT_ID , CF.TRP_BUSINESS_UNIT , CF.POOL_ID , CF.CD , CF.PRTRY , CF.BSE_RATE_DIV , CF.BSE_RATE_MULT , CF.PARTY_ID , CF.NAME1 , CF.ADDENDA_VALUE , CF.PMT_FIELD1 , CF.PMT_FIELD2 , CF.PMT_FIELD3 , CF.BANK_REF_ID , CF.MANDATE_BU , CF.PMT_MANDATE_ID , CF.PMT_FILE_ID , CF.FED_WIRE_ID FROM PS_BNK_RCN_TR_PYMN CF , PS_BNK_CURR_RVL_VW B WHERE B.SETID = CF.BANK_SETID AND B.BANK_CD = CF.BANK_CD AND B.BANK_ACCT_KEY = CF.BANK_ACCT_KEY AND B.BNK_ID_NBR = CF.BNK_ID_NBR AND B.BANK_ACCOUNT_NUM = CF.BANK_ACCOUNT_NUM AND B.TXN_CURRENCY_CD = CF.CURRENCY_CD AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_BNK_CURR_RVL_V2 WHERE SETID = B.SETID AND BANK_CD = B.BANK_CD AND BANK_ACCT_KEY = B.BANK_ACCT_KEY AND BASE_CURRENCY_BNK = B.BASE_CURRENCY_BNK AND TXN_CURRENCY_CD = B.TXN_CURRENCY_CD AND EFFDT <= CF.BUSINESS_DATE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TR_SOURCE_CD Character(1) VARCHAR2(1) NOT NULL Note: Changes to Translate Values must also be made to TRA_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync. Values that are inactive are for use in TR Accounting only
B=BSP
D=Deals
E=Deal Fees
F=Facility Fees
H=Hedges
I=Interest
M=Deal: Estimated Maturity Accr
N=Netted Deal
O=Other
P=Investment Pools
R=EFT Fees
S=Securities
T=LC Fees
W=EFT Requests
X=Bank Transfers

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

3 TR_SOURCE_ID Character(12) VARCHAR2(12) NOT NULL An internal work field that represents a unique identifier for records depicting a given treasury po

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

5 CASH_FLOW_LINE Number(15,0) DECIMAL(15) NOT NULL A sequential number that indicates the time order sequence of a given deal transaction's cash flows.

6 CASH_FLOW_LEG Number(1,0) SMALLINT NOT NULL A sequential number that indicates the relationship between a cash flow and its corresponding deal transaction leg

7 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

8 PAY_DOC_SEQ Number(5,0) INTEGER NOT NULL Advice Sequence

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

10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

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

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

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

14 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

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

16 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

17 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

18 TRANSACTION_LINE Number(3,0) SMALLINT NOT NULL The separate and distinct base instrument type components of a given deal transaction.

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

20 RECONCILE_OPRID Character(30) VARCHAR2(30) NOT NULL The user ID that performed the reconciliation for a given transaction.

21 RECON_TYPE Character(1) VARCHAR2(1) NOT NULL Represents a series of options as to how a treasury wishes to perform reconciliation for a given bank
A=Automatically Reconciled
B=Balance System(s) to BankTran
F=Forced to Reconcile
M=Manually Reconciled
S=Semi Manual
U=Unreconciled

22 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

23 RECON_CYCLE_NBR Number(10,0) DECIMAL(10) NOT NULL The bank statement ID.

24 RECORD_SEQ_NUMBER Number(10,0) DECIMAL(10) NOT NULL An internal work field utilized to enumerate database records in bank statement processing.

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

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

27 NET_REF_ID Character(12) VARCHAR2(12) NOT NULL A reference identifier associated with a cash transaction subject to netting with a given bank/count

28 CF_SOURCE_REF_ID Character(40) VARCHAR2(40) NOT NULL Reference identifier for a treasury system cash flow.

29 CP_NETTOR Character(30) VARCHAR2(30) NOT NULL Allows the user to indicate whether a given dealing counterparty permits netting of inbound and outbou

30 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

31 SETTLEMENT_ID Character(5) VARCHAR2(5) NOT NULL A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc

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

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

34 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

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

36 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

37 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

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

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

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

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

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

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

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

45 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle

46 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number

47 BANK_STMT_DT Date(10) DATE "The bank statement date

48 RECON_RUN_ID Character(15) VARCHAR2(15) NOT NULL Recon Run ID

49 BANK_ACCT_RVL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Field used to store the amount on a transaction revalued in the base currency of the transactions bank account.

50 STL_THROUGH Character(2) VARCHAR2(2) NOT NULL Settle through
01=Financial Gateway
02=Pay Cycle

51 REPETITVE_TRNFR_CD Character(15) VARCHAR2(15) NOT NULL Repetitive Transfer Code assigned by customers Bank

52 DRAWDOWN_FLG Character(1) VARCHAR2(1) NOT NULL Drawdown Transfer Flag, either yes or no.
N=No
Y=Yes

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

54 FORMAT_ID Character(10) VARCHAR2(10) NOT NULL Format ID

55 TRP_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Pool Business Unit

56 POOL_ID Character(10) VARCHAR2(10) NOT NULL Pool ID field.

57 CD Character(30) VARCHAR2(30) NOT NULL Code

58 PRTRY Character(30) VARCHAR2(30) NOT NULL Proprietary

59 BSE_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Base Rate Divisor for Exchange Rates

60 BSE_RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Base Rate Multiplier for Exchange Rates

61 PARTY_ID Character(30) VARCHAR2(30) NOT NULL Payee ID

62 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

63 ADDENDA_VALUE Character(254) VARCHAR2(254) NOT NULL Addend Value use for Bank Statement Accounting

64 PMT_FIELD1 Character(30) VARCHAR2(30) NOT NULL Payment field

65 PMT_FIELD2 Character(30) VARCHAR2(30) NOT NULL Payment field

66 PMT_FIELD3 Character(30) VARCHAR2(30) NOT NULL Payment field

67 BANK_REF_ID Character(16) VARCHAR2(16) NOT NULL A reference identifier associated with a given bank/counterparty transaction.

68 MANDATE_BU Character(5) VARCHAR2(5) NOT NULL Mandate Business Unit

69 PMT_MANDATE_ID Character(15) VARCHAR2(15) NOT NULL Mandate direct debit

70 PMT_FILE_ID Character(8) VARCHAR2(8) NOT NULL Payment File ID

71 FED_WIRE_ID Character(22) VARCHAR2(22) NOT NULL This field will hold the Federal Wire ID # that is given upon confirmation of a successful wire transfer.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TR_SOURCE_CD	Character(1)	VARCHAR2(1) NOT NULL	Note: Changes to Translate Values must also be made to TRA_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync. Values that are inactive are for use in TR Accounting only B=BSP D=Deals E=Deal Fees F=Facility Fees H=Hedges I=Interest M=Deal: Estimated Maturity Accr N=Netted Deal O=Other P=Investment Pools R=EFT Fees S=Securities T=LC Fees W=EFT Requests X=Bank Transfers
2	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
3	TR_SOURCE_ID	Character(12)	VARCHAR2(12) NOT NULL	An internal work field that represents a unique identifier for records depicting a given treasury po
4	BUSINESS_DATE	Date(10)	DATE	Represents a date upon which business is conducted within a given company in a given country.
5	CASH_FLOW_LINE	Number(15,0)	DECIMAL(15) NOT NULL	A sequential number that indicates the time order sequence of a given deal transaction's cash flows.
6	CASH_FLOW_LEG	Number(1,0)	SMALLINT NOT NULL	A sequential number that indicates the relationship between a cash flow and its corresponding deal transaction leg
7	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
8	PAY_DOC_SEQ	Number(5,0)	INTEGER NOT NULL	Advice Sequence
9	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
11	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
12	BANK_CD_CUST	Character(5)	VARCHAR2(5) NOT NULL	Represents the customer bank or counterparty in a relationship that pairs differing sets of b
13	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
14	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
15	ACCT_BUS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	The general ledger business unit associated with a given bank/counterparty account.
16	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
17	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
18	TRANSACTION_LINE	Number(3,0)	SMALLINT NOT NULL	The separate and distinct base instrument type components of a given deal transaction.
19	RECONCILE_DT	Date(10)	DATE	The transaction reconciliation date.
20	RECONCILE_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The user ID that performed the reconciliation for a given transaction.
21	RECON_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Represents a series of options as to how a treasury wishes to perform reconciliation for a given bank A=Automatically Reconciled B=Balance System(s) to BankTran F=Forced to Reconcile M=Manually Reconciled S=Semi Manual U=Unreconciled
22	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
23	RECON_CYCLE_NBR	Number(10,0)	DECIMAL(10) NOT NULL	The bank statement ID.
24	RECORD_SEQ_NUMBER	Number(10,0)	DECIMAL(10) NOT NULL	An internal work field utilized to enumerate database records in bank statement processing.
25	STTLMNT_DT_ACTUAL	Date(10)	DATE	Date in which a deal transaction is actually settled with a counterparty.
26	CPTY_REFERENCE	Character(15)	VARCHAR2(15) NOT NULL	A reference identifier associated with a dealing counterparty transaction.
27	NET_REF_ID	Character(12)	VARCHAR2(12) NOT NULL	A reference identifier associated with a cash transaction subject to netting with a given bank/count
28	CF_SOURCE_REF_ID	Character(40)	VARCHAR2(40) NOT NULL	Reference identifier for a treasury system cash flow.
29	CP_NETTOR	Character(30)	VARCHAR2(30) NOT NULL	Allows the user to indicate whether a given dealing counterparty permits netting of inbound and outbou
30	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
31	SETTLEMENT_ID	Character(5)	VARCHAR2(5) NOT NULL	A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc
32	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number
33	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
34	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
35	BASE_CURRENCY_BNK	Character(3)	VARCHAR2(3) NOT NULL	The base currency of the subject bank general ledger business unit.
36	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
37	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
38	CUR_RT_TYPE_BNK	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
39	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
40	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount
41	PAID_AMT_BNK_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount - Base Bank Unit
42	PAID_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Paid Amount
43	PYMNT_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange rate is store
44	PYMNT_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange rate is stored
45	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
46	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
47	BANK_STMT_DT	Date(10)	DATE	"The bank statement date
48	RECON_RUN_ID	Character(15)	VARCHAR2(15) NOT NULL	Recon Run ID
49	BANK_ACCT_RVL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Field used to store the amount on a transaction revalued in the base currency of the transactions bank account.
50	STL_THROUGH	Character(2)	VARCHAR2(2) NOT NULL	Settle through 01=Financial Gateway 02=Pay Cycle
51	REPETITVE_TRNFR_CD	Character(15)	VARCHAR2(15) NOT NULL	Repetitive Transfer Code assigned by customers Bank
52	DRAWDOWN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Drawdown Transfer Flag, either yes or no. N=No Y=Yes
53	PMT_ID	Character(15)	VARCHAR2(15) NOT NULL	Payment id
54	FORMAT_ID	Character(10)	VARCHAR2(10) NOT NULL	Format ID
55	TRP_BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Pool Business Unit
56	POOL_ID	Character(10)	VARCHAR2(10) NOT NULL	Pool ID field.
57	CD	Character(30)	VARCHAR2(30) NOT NULL	Code
58	PRTRY	Character(30)	VARCHAR2(30) NOT NULL	Proprietary
59	BSE_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Base Rate Divisor for Exchange Rates
60	BSE_RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Base Rate Multiplier for Exchange Rates
61	PARTY_ID	Character(30)	VARCHAR2(30) NOT NULL	Payee ID
62	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
63	ADDENDA_VALUE	Character(254)	VARCHAR2(254) NOT NULL	Addend Value use for Bank Statement Accounting
64	PMT_FIELD1	Character(30)	VARCHAR2(30) NOT NULL	Payment field
65	PMT_FIELD2	Character(30)	VARCHAR2(30) NOT NULL	Payment field
66	PMT_FIELD3	Character(30)	VARCHAR2(30) NOT NULL	Payment field
67	BANK_REF_ID	Character(16)	VARCHAR2(16) NOT NULL	A reference identifier associated with a given bank/counterparty transaction.
68	MANDATE_BU	Character(5)	VARCHAR2(5) NOT NULL	Mandate Business Unit
69	PMT_MANDATE_ID	Character(15)	VARCHAR2(15) NOT NULL	Mandate direct debit
70	PMT_FILE_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment File ID
71	FED_WIRE_ID	Character(22)	VARCHAR2(22) NOT NULL	This field will hold the Federal Wire ID # that is given upon confirmation of a successful wire transfer.