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

BNK_RCN_DEALS_V

(SQL View)

Recon view: TR Cashflows

Reconciliation view over CASH_FLOW_TR for Treasury Cashflows

SELECT TR_SOURCE_CD , SOURCE_BUS_UNIT , TR_SOURCE_ID , BUSINESS_DATE , CASH_FLOW_LINE , CASH_FLOW_LEG , SEQ_NBR , PAY_DOC_SEQ , CASH_TYPE , AMOUNT , CURRENCY_CD , BANK_SETID , BANK_CD_CUST , BANK_CD , BANK_ACCT_KEY , ACCT_BUS_UNIT_GL , BNK_ID_NBR , BANK_ACCOUNT_NUM , TRANSACTION_LINE , RECONCILE_DT , RECONCILE_OPRID , RECON_TYPE , RECON_STATUS , RECON_CYCLE_NBR , RECORD_SEQ_NUMBER , STTLMNT_DT_ACTUAL , NET_STATUS , SELECTED_OPRID , SELECTED_DTTM , APPROVAL_OPRID , APPROVAL_DTTM , CPTY_REFERENCE , NET_REF_ID , CF_SOURCE_REF_ID , CP_NETTOR , PYMNT_METHOD , SETTLEMENT_ID , PYMNT_SELCT_STATUS , APPROVAL_FLG_TR , APPROV_SUBMITTED , PYMNT_ID , CURRENCY_CD_BASE , BASE_AMT , BASE_CURRENCY_BNK , BNK_RATE_DIV , BNK_RATE_MULT , CUR_RT_TYPE_BNK , CURRENCY_PYMNT , PAID_AMT , PAID_AMT_BNK_BSE , PAID_AMT_BSE , PYMNT_RATE_DIV , PYMNT_RATE_MULT , PAY_CYCLE , PAY_CYCLE_SEQ_NUM , BANK_STMT_DT , RECON_RUN_ID , BANK_ACCT_RVL_AMT , STL_THROUGH , EVENT_TRACKING_ID , REPETITVE_TRNFR_CD , DRAWDOWN_FLG , PMT_ID , PMT_STATUS , FORMAT_ID , TRP_BUSINESS_UNIT , POOL_ID , CD , PRTRY , BSE_RATE_DIV , BSE_RATE_MULT FROM PS_CASH_FLOW_TR WHERE TR_SOURCE_CD IN ('D', 'X', 'W', 'F', 'E', 'R', 'T', 'N') AND CASH_TYPE = '01' AND NET_STATUS IN ('O', 'N') AND BANK_CD_CUST = BANK_CD AND PYMNT_ID = ' ' AND ((PYMNT_SELCT_STATUS IN ('P', 'Y') AND APPROVAL_FLG_TR = 'A') OR (PYMNT_SELCT_STATUS = 'X' AND AMOUNT > 0) OR (PYMNT_SELCT_STATUS = 'X' AND AMOUNT < 0 AND PYMNT_METHOD = 'DD') OR ((PYMNT_METHOD = 'MAN' OR PYMNT_METHOD = 'CHK') AND PYMNT_SELCT_STATUS = 'N' AND (APPROVAL_FLG_TR = 'N' OR APPROVAL_FLG_TR = 'A')) OR (PYMNT_SELCT_STATUS = 'N' AND APPROVAL_FLG_TR = 'N'))

# 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 CASH_TYPE Character(2) VARCHAR2(2) NOT NULL Represents the type of cash flow stored in the Treasury database.
01=Actual
02=Provisional
03=Sample
04=Deactivated

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

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

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

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

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

15 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

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

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

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

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

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

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

22 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

23 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

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

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

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

27 NET_STATUS Character(1) VARCHAR2(1) NOT NULL Indicates the counterparty netting status of a given settlement transaction.
D=Netted
N=Net
O=Not Netted

28 SELECTED_OPRID Character(30) VARCHAR2(30) NOT NULL Selected Operator

29 SELECTED_DTTM DateTime(26) TIMESTAMP Selected Date

30 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.

31 APPROVAL_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a given transaction is approved by an oper

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

33 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

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

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

36 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

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

38 PYMNT_SELCT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Selection Status
C=Closed
D=Negative Voucher Sum
E=Externally Paid
F=Federal Sanctions Error
I=In Process - EFT
N=Not Selected for Payment
O=Financial Sanctions Review
P=Paid
R=Requested for Payment
S=Settlement Payment
V=Convert Error
X=Canceled
Y=Prepaid

39 APPROVAL_FLG_TR Character(1) VARCHAR2(1) NOT NULL An internal work field that indicates that a given treasury transaction has been approved by
A=Approved
D=Denied
N=None Required
P=Pending Approval

40 APPROV_SUBMITTED Character(1) VARCHAR2(1) NOT NULL An internal work field that indicates whether a treasury deal review and/or confirmation transac

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

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

43 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

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

45 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

46 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

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

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

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

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

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

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

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

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

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

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

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

58 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.

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

60 EVENT_TRACKING_ID Number(10,0) DECIMAL(10) NOT NULL The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.

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

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

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

64 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

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

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

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

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

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

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

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

#	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	CASH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Represents the type of cash flow stored in the Treasury database. 01=Actual 02=Provisional 03=Sample 04=Deactivated
10	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
13	BANK_CD_CUST	Character(5)	VARCHAR2(5) NOT NULL	Represents the customer bank or counterparty in a relationship that pairs differing sets of b
14	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
15	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
16	ACCT_BUS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	The general ledger business unit associated with a given bank/counterparty account.
17	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
18	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
19	TRANSACTION_LINE	Number(3,0)	SMALLINT NOT NULL	The separate and distinct base instrument type components of a given deal transaction.
20	RECONCILE_DT	Date(10)	DATE	The transaction reconciliation date.
21	RECONCILE_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The user ID that performed the reconciliation for a given transaction.
22	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
23	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
24	RECON_CYCLE_NBR	Number(10,0)	DECIMAL(10) NOT NULL	The bank statement ID.
25	RECORD_SEQ_NUMBER	Number(10,0)	DECIMAL(10) NOT NULL	An internal work field utilized to enumerate database records in bank statement processing.
26	STTLMNT_DT_ACTUAL	Date(10)	DATE	Date in which a deal transaction is actually settled with a counterparty.
27	NET_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Indicates the counterparty netting status of a given settlement transaction. D=Netted N=Net O=Not Netted
28	SELECTED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Selected Operator
29	SELECTED_DTTM	DateTime(26)	TIMESTAMP	Selected Date
30	APPROVAL_OPRID	Character(30)	VARCHAR2(30) NOT NULL	A system generated value that reflects the operator that approved a given transaction.
31	APPROVAL_DTTM	DateTime(26)	TIMESTAMP	A system generated value that reflects the date and time a given transaction is approved by an oper
32	CPTY_REFERENCE	Character(15)	VARCHAR2(15) NOT NULL	A reference identifier associated with a dealing counterparty transaction.
33	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
34	CF_SOURCE_REF_ID	Character(40)	VARCHAR2(40) NOT NULL	Reference identifier for a treasury system cash flow.
35	CP_NETTOR	Character(30)	VARCHAR2(30) NOT NULL	Allows the user to indicate whether a given dealing counterparty permits netting of inbound and outbou
36	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
37	SETTLEMENT_ID	Character(5)	VARCHAR2(5) NOT NULL	A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc
38	PYMNT_SELCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Selection Status C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid
39	APPROVAL_FLG_TR	Character(1)	VARCHAR2(1) NOT NULL	An internal work field that indicates that a given treasury transaction has been approved by A=Approved D=Denied N=None Required P=Pending Approval
40	APPROV_SUBMITTED	Character(1)	VARCHAR2(1) NOT NULL	An internal work field that indicates whether a treasury deal review and/or confirmation transac
41	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number
42	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
43	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
44	BASE_CURRENCY_BNK	Character(3)	VARCHAR2(3) NOT NULL	The base currency of the subject bank general ledger business unit.
45	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
46	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
47	CUR_RT_TYPE_BNK	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
48	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
49	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount
50	PAID_AMT_BNK_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount - Base Bank Unit
51	PAID_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Paid Amount
52	PYMNT_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange rate is store
53	PYMNT_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange rate is stored
54	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
55	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
56	BANK_STMT_DT	Date(10)	DATE	"The bank statement date
57	RECON_RUN_ID	Character(15)	VARCHAR2(15) NOT NULL	Recon Run ID
58	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.
59	STL_THROUGH	Character(2)	VARCHAR2(2) NOT NULL	Settle through 01=Financial Gateway 02=Pay Cycle
60	EVENT_TRACKING_ID	Number(10,0)	DECIMAL(10) NOT NULL	The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.
61	REPETITVE_TRNFR_CD	Character(15)	VARCHAR2(15) NOT NULL	Repetitive Transfer Code assigned by customers Bank
62	DRAWDOWN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Drawdown Transfer Flag, either yes or no. N=No Y=Yes
63	PMT_ID	Character(15)	VARCHAR2(15) NOT NULL	Payment id
64	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
65	FORMAT_ID	Character(10)	VARCHAR2(10) NOT NULL	Format ID
66	TRP_BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Pool Business Unit
67	POOL_ID	Character(10)	VARCHAR2(10) NOT NULL	Pool ID field.
68	CD	Character(30)	VARCHAR2(30) NOT NULL	Code
69	PRTRY	Character(30)	VARCHAR2(30) NOT NULL	Proprietary
70	BSE_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Base Rate Divisor for Exchange Rates
71	BSE_RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Base Rate Multiplier for Exchange Rates