BNK_RCN_PAYMR (SQL View)	Index Back
Revaluation: AR Payments View that revalues AR Payments into bank account's default currency

BNK_RCN_PAYMR

(SQL View)

Revaluation: AR Payments

View that revalues AR Payments into bank account's default currency

SELECT A.DEPOSIT_BU , A.DEPOSIT_ID , A.PAYMENT_SEQ_NUM , A.PAYMENT_ID , A.PAYMENT_AMT , A.PAYMENT_STATUS , A.PAYMENT_METHOD , A.BNK_ID_NBR , A.BANK_ACCOUNT_NUM , A.ENTRY_DT , A.ACCOUNTING_DT , A.POST_DT , A.SEL_CUST_ID , A.SEL_PO , A.SEL_REMIT , A.SEL_CORP_ACCT , A.SEL_MICR , A.SEL_OPEN_ITEM , A.SEL_DOCUMENT , A.SEL_REF_RANGE , A.ID_SEQ_CUST , A.ID_SEQ_ITEM , A.AMT_SEL , A.AMT_ADJ , A.AMT_REM , A.DISC_TAKEN , A.DISC_EARNED , A.DISC_UNEARNED , A.WS_COUNT , A.WS_DTTM , A.WS_SEQ_ITEM , A.GL_DISTRIB_STATUS , A.DST_DT , A.JOURNAL_ID , A.JOURNAL_DATE , A.GROUP_ID , A.PP_SW , A.DISC_USED_SW , A.WO_USED_SW , A.WO_ITEM_AMT , A.WO_ADJ_USED_SW , A.WS_UPDATED_SW , A.LOCKBOX_PYMNT_ID , A.PP_METHOD , A.ALGORITHM_GROUP , A.WS_REF_MATCH_TYPE , A.ALGORITHM , A.PAYMENT_CURRENCY , A.PYMT_RT_TYPE , A.PYMT_RATE_MULT , A.PYMT_RATE_DIV , C.BASE_CURRENCY_BNK , A.PP_STATUS , A.PP_RQ , A.PP_RQ_HIT , A.APPLIED_OPRID , A.MISC_PAYMENT , A.MISC_DST_BAL , A.CREATE_PEND_ITEMS , A.PROCESS_INSTANCE , A.CASH_CNTRL_USE , A.RECON_TYPE , A.RECON_STATUS , A.RECONCILE_OPRID , A.RECONCILE_DT , A.RECON_CYCLE_NBR , A.RECORD_SEQ_NUMBER , A.STTLMNT_DT_ACTUAL , A.STTLMNT_DT_EST , %Round(%DecMult(%DecDiv(A.PAYMENT_AMT , C.RATE_DIV) , C.RATE_MULT) , C.DECIMAL_POSITIONS) , A.RECON_RUN_ID FROM PS_BNK_RCN_PAYMENT A , PS_BNK_RCN_DEPOSIT B , PS_BNK_CURR_RVL_VW C WHERE B.DEPOSIT_BU = A.DEPOSIT_BU AND B.DEPOSIT_ID = A.DEPOSIT_ID AND C.SETID = B.BANK_SETID AND C.BANK_CD = B.BANK_CD AND C.BANK_ACCT_KEY = B.BANK_ACCT_KEY AND C.BNK_ID_NBR = B.BNK_ID_NBR AND C.BANK_ACCOUNT_NUM = B.BANK_ACCOUNT_NUM AND C.TXN_CURRENCY_CD = A.PAYMENT_CURRENCY AND C.EFFDT = ( SELECT MAX(EFFDT) FROM PS_BNK_CURR_RVL_V2 WHERE SETID = C.SETID AND BANK_CD = C.BANK_CD AND BANK_ACCT_KEY = C.BANK_ACCT_KEY AND BASE_CURRENCY_BNK = C.BASE_CURRENCY_BNK AND TXN_CURRENCY_CD = C.TXN_CURRENCY_CD AND RATE_INDEX = C.RATE_INDEX AND CUR_RT_TYPE = C.CUR_RT_TYPE AND EFFDT <= A.ACCOUNTING_DT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.

2 DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.

3 PAYMENT_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.

4 PAYMENT_ID Character(15) VARCHAR2(15) NOT NULL Identifies a customer payment. This is usually a check number but may be some other identifying number.

5 PAYMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a customer payment.

6 PAYMENT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Status
A=Applied
B=Bounced
C=Complete
E=Identified - Express
I=Identified
J=Directly Journalled
R=Unposted Direct Journal
U=Unidentified
W=Worksheet

7 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report

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

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

10 ENTRY_DT Date(10) DATE Specifies the date that a group of pending items was entered into the system. This date may be later or the same as the date that the items were received by the organization (See RECEIVED_DT).

11 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

12 POST_DT Date(10) DATE The Date a transaction was Posted.

13 SEL_CUST_ID Character(1) VARCHAR2(1) NOT NULL Select items via Customer ID

14 SEL_PO Character(1) VARCHAR2(1) NOT NULL Select items via Postal

15 SEL_REMIT Character(1) VARCHAR2(1) NOT NULL Select items via REMIT TO

16 SEL_CORP_ACCT Character(1) VARCHAR2(1) NOT NULL Select items via CORP ACCT

17 SEL_MICR Character(1) VARCHAR2(1) NOT NULL Select items via MICR ID

18 SEL_OPEN_ITEM Character(1) VARCHAR2(1) NOT NULL Select items via OPEN ITEM

19 SEL_DOCUMENT Character(1) VARCHAR2(1) NOT NULL Select items via DOCUMENT

20 SEL_REF_RANGE Character(1) VARCHAR2(1) NOT NULL Range of References

21 ID_SEQ_CUST Number(3,0) SMALLINT NOT NULL Sequence control for CUST ID

22 ID_SEQ_ITEM Number(5,0) INTEGER NOT NULL Sequence control for ITEM

23 AMT_SEL Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount selected

24 AMT_ADJ Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Adjusted

25 AMT_REM Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Remaining

26 DISC_TAKEN Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Taken

27 DISC_EARNED Signed Number(28,3) DECIMAL(26,3) NOT NULL Discounts Earned

28 DISC_UNEARNED Signed Number(28,3) DECIMAL(26,3) NOT NULL Unearned Discounts

29 WS_COUNT Number(5,0) INTEGER NOT NULL Worksheet Items

30 WS_DTTM DateTime(26) TIMESTAMP Worksheet Created Date/Time

31 WS_SEQ_ITEM Number(5,0) INTEGER NOT NULL Worksheet item sequence number

32 GL_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Status
C=Available to Contracts
D=Distributed
G=Generated
H=Hold
I=Ignored
J=Creating Journals
M=Modified
N=None
P=To be processed
X=Waiting for Reversal

33 DST_DT Date(10) DATE Distribution Date

34 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.

35 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.

36 GROUP_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.

37 PP_SW Character(1) VARCHAR2(1) NOT NULL Payment Predictor

38 DISC_USED_SW Character(1) VARCHAR2(1) NOT NULL Discount used switch

39 WO_USED_SW Character(1) VARCHAR2(1) NOT NULL Write Off's Used

40 WO_ITEM_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Write Off Item

41 WO_ADJ_USED_SW Character(1) VARCHAR2(1) NOT NULL Write Off Adjustmet from WS

42 WS_UPDATED_SW Character(1) VARCHAR2(1) NOT NULL Worksheet updated switch

43 LOCKBOX_PYMNT_ID Character(15) VARCHAR2(15) NOT NULL Lockbox Payment Id

44 PP_METHOD Character(15) VARCHAR2(15) NOT NULL Payment Predictor Method

45 ALGORITHM_GROUP Character(15) VARCHAR2(15) NOT NULL Algorithm Group for Payment Predictor

46 WS_REF_MATCH_TYPE Character(1) VARCHAR2(1) NOT NULL Worksheet Reference Match Type
E=Exact Match
L=Like Match

47 ALGORITHM Character(7) VARCHAR2(7) NOT NULL Algorithm Identifier

48 PAYMENT_CURRENCY Character(3) VARCHAR2(3) NOT NULL Identifies the currency of a customer payment. This is generally the same as the currency specified for the deposit but it can be different.

49 PYMT_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Specifies the type of exchange rate to be used when the currency of a customer payment is converted to the base currency of a business unit. The exchange rate type is also called the market rate type. Examples are spot rate current rate and official rate.

50 PYMT_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL Specifies the number (the multiplier) required to convert a payment amount from its entry currency to the business unit base currency. The number is based on the exchange rate specified for the transaction. It is used in conjunction with PYMT_ RATE_DIV. Refer to documentation on the Triangulation Process for the exact calculation.

51 PYMT_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Specifies the number (the divisor) required to convert a payment amount from its entry currency to the business unit base currency. The number is based on the exchange rate specified for the transaction. It is used in conjunction with PYMT_RATE_MULT. Refer to documentation on the Triangulation Process for the exact calculation.

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

53 PP_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Predictor Status
A=Applied
N=Not Processed
P=Processed
W=Worksheet Generated

54 PP_RQ Number(7,0) INTEGER NOT NULL Reference Qualifier Count

55 PP_RQ_HIT Number(7,0) INTEGER NOT NULL Reference Qualifier Hits

56 APPLIED_OPRID Character(30) VARCHAR2(30) NOT NULL Applied Operator

57 MISC_PAYMENT Character(1) VARCHAR2(1) NOT NULL Journal Directly

58 MISC_DST_BAL Character(1) VARCHAR2(1) NOT NULL Non Customer Dist Balanced
C=Journal Complete
I=Balanced
N=No Distribution
O=Out of Balance

59 CREATE_PEND_ITEMS Character(1) VARCHAR2(1) NOT NULL Create Pending Items
A=Do Not Post
L=Batch Standard
N=Batch Priority

60 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

61 CASH_CNTRL_USE Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a payment group created by a payment worksheet or by Payment Predictor includes a cash control entry debiting cash.

62 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

63 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

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

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

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

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

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

69 STTLMNT_DT_EST Date(10) DATE Date in which a deal transaction is estimated to be settled with a counterparty.

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted.
2	DEPOSIT_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
3	PAYMENT_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
4	PAYMENT_ID	Character(15)	VARCHAR2(15) NOT NULL	Identifies a customer payment. This is usually a check number but may be some other identifying number.
5	PAYMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a customer payment.
6	PAYMENT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Status A=Applied B=Bounced C=Complete E=Identified - Express I=Identified J=Directly Journalled R=Unposted Direct Journal U=Unidentified W=Worksheet
7	PAYMENT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats. ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report
8	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
9	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
10	ENTRY_DT	Date(10)	DATE	Specifies the date that a group of pending items was entered into the system. This date may be later or the same as the date that the items were received by the organization (See RECEIVED_DT).
11	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
12	POST_DT	Date(10)	DATE	The Date a transaction was Posted.
13	SEL_CUST_ID	Character(1)	VARCHAR2(1) NOT NULL	Select items via Customer ID
14	SEL_PO	Character(1)	VARCHAR2(1) NOT NULL	Select items via Postal
15	SEL_REMIT	Character(1)	VARCHAR2(1) NOT NULL	Select items via REMIT TO
16	SEL_CORP_ACCT	Character(1)	VARCHAR2(1) NOT NULL	Select items via CORP ACCT
17	SEL_MICR	Character(1)	VARCHAR2(1) NOT NULL	Select items via MICR ID
18	SEL_OPEN_ITEM	Character(1)	VARCHAR2(1) NOT NULL	Select items via OPEN ITEM
19	SEL_DOCUMENT	Character(1)	VARCHAR2(1) NOT NULL	Select items via DOCUMENT
20	SEL_REF_RANGE	Character(1)	VARCHAR2(1) NOT NULL	Range of References
21	ID_SEQ_CUST	Number(3,0)	SMALLINT NOT NULL	Sequence control for CUST ID
22	ID_SEQ_ITEM	Number(5,0)	INTEGER NOT NULL	Sequence control for ITEM
23	AMT_SEL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount selected
24	AMT_ADJ	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Adjusted
25	AMT_REM	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Remaining
26	DISC_TAKEN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Taken
27	DISC_EARNED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discounts Earned
28	DISC_UNEARNED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Unearned Discounts
29	WS_COUNT	Number(5,0)	INTEGER NOT NULL	Worksheet Items
30	WS_DTTM	DateTime(26)	TIMESTAMP	Worksheet Created Date/Time
31	WS_SEQ_ITEM	Number(5,0)	INTEGER NOT NULL	Worksheet item sequence number
32	GL_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Status C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal
33	DST_DT	Date(10)	DATE	Distribution Date
34	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
35	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
36	GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
37	PP_SW	Character(1)	VARCHAR2(1) NOT NULL	Payment Predictor
38	DISC_USED_SW	Character(1)	VARCHAR2(1) NOT NULL	Discount used switch
39	WO_USED_SW	Character(1)	VARCHAR2(1) NOT NULL	Write Off's Used
40	WO_ITEM_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Write Off Item
41	WO_ADJ_USED_SW	Character(1)	VARCHAR2(1) NOT NULL	Write Off Adjustmet from WS
42	WS_UPDATED_SW	Character(1)	VARCHAR2(1) NOT NULL	Worksheet updated switch
43	LOCKBOX_PYMNT_ID	Character(15)	VARCHAR2(15) NOT NULL	Lockbox Payment Id
44	PP_METHOD	Character(15)	VARCHAR2(15) NOT NULL	Payment Predictor Method
45	ALGORITHM_GROUP	Character(15)	VARCHAR2(15) NOT NULL	Algorithm Group for Payment Predictor
46	WS_REF_MATCH_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Worksheet Reference Match Type E=Exact Match L=Like Match
47	ALGORITHM	Character(7)	VARCHAR2(7) NOT NULL	Algorithm Identifier
48	PAYMENT_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Identifies the currency of a customer payment. This is generally the same as the currency specified for the deposit but it can be different.
49	PYMT_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Specifies the type of exchange rate to be used when the currency of a customer payment is converted to the base currency of a business unit. The exchange rate type is also called the market rate type. Examples are spot rate current rate and official rate.
50	PYMT_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	Specifies the number (the multiplier) required to convert a payment amount from its entry currency to the business unit base currency. The number is based on the exchange rate specified for the transaction. It is used in conjunction with PYMT_ RATE_DIV. Refer to documentation on the Triangulation Process for the exact calculation.
51	PYMT_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Specifies the number (the divisor) required to convert a payment amount from its entry currency to the business unit base currency. The number is based on the exchange rate specified for the transaction. It is used in conjunction with PYMT_RATE_MULT. Refer to documentation on the Triangulation Process for the exact calculation.
52	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
53	PP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Predictor Status A=Applied N=Not Processed P=Processed W=Worksheet Generated
54	PP_RQ	Number(7,0)	INTEGER NOT NULL	Reference Qualifier Count
55	PP_RQ_HIT	Number(7,0)	INTEGER NOT NULL	Reference Qualifier Hits
56	APPLIED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Applied Operator
57	MISC_PAYMENT	Character(1)	VARCHAR2(1) NOT NULL	Journal Directly
58	MISC_DST_BAL	Character(1)	VARCHAR2(1) NOT NULL	Non Customer Dist Balanced C=Journal Complete I=Balanced N=No Distribution O=Out of Balance
59	CREATE_PEND_ITEMS	Character(1)	VARCHAR2(1) NOT NULL	Create Pending Items A=Do Not Post L=Batch Standard N=Batch Priority
60	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
61	CASH_CNTRL_USE	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a payment group created by a payment worksheet or by Payment Predictor includes a cash control entry debiting cash.
62	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
63	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
64	RECONCILE_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The user ID that performed the reconciliation for a given transaction.
65	RECONCILE_DT	Date(10)	DATE	The transaction reconciliation date.
66	RECON_CYCLE_NBR	Number(10,0)	DECIMAL(10) NOT NULL	The bank statement ID.
67	RECORD_SEQ_NUMBER	Number(10,0)	DECIMAL(10) NOT NULL	An internal work field utilized to enumerate database records in bank statement processing.
68	STTLMNT_DT_ACTUAL	Date(10)	DATE	Date in which a deal transaction is actually settled with a counterparty.
69	STTLMNT_DT_EST	Date(10)	DATE	Date in which a deal transaction is estimated to be settled with a counterparty.
70	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.
71	RECON_RUN_ID	Character(15)	VARCHAR2(15) NOT NULL	Recon Run ID