BNK_RCN_DISSCHD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty. Prompt Table: BANK_ACCT_VW
2	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: BANK_ACCT_VW
3	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_VW
4	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number
5	TRAN_REF_ID	Character(20)	VARCHAR2(20) NOT NULL	Represents the unique transaction identifier in bank reconciliation processing.
6	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
7	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
8	BRANCH_ID	Character(10)	VARCHAR2(10) NOT NULL	The local branch office identifier associated with a given bank/counterparty.
9	CHECK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	Check Digit
10	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
11	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
12	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
13	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
14	NAME2	Character(40)	VARCHAR2(40) NOT NULL	Name 2
15	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
16	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
17	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
18	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
19	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
20	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit
21	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
22	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
23	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
24	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
25	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
26	TRAN_DT	Date(10)	DATE	Represents the transaction date in bank reconciliation processing. Default Value: %date
27	CREATION_DT	Date(10)	DATE	Creation Date
28	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
29	TRAN_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents a transaction amount in bank reconciliation processing.
30	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
31	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
32	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling
33	PYMNT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Status A=Alignment E=ACH/EFT Prenote L=Stale Dated Payment N=Reprinted with same ref number O=Overflow P=Paid R=Replaced S=Stopped T=Undo Escheatment U=Undo Cancel V=Void W=Escheated Check X=Deleted
34	PYMNT_RECONCILE_DT	Date(10)	DATE	Date Reconciled
35	CANCEL_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Cancel Action C=Do Not Reissue/Close Liability H=Re-Open Voucher(s)/Put on Hold N=No Cancel Action P=Processed R=Re-Open Voucher(s)/Re-Issue S=Stale Dated Check W=Escheated
36	CANCEL_DT	Date(10)	DATE	Date Cancelled
37	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
38	POST_STATUS_AP	Character(1)	VARCHAR2(1) NOT NULL	Post Status N=Payment Not Applied P=Posted U=Unposted Default Value: U
39	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
40	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
41	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
42	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 Default Value: U
43	RECON_CYCLE_NBR	Number(10,0)	DECIMAL(10) NOT NULL	The bank statement ID.
44	DFI_ID_NUM	Character(12)	VARCHAR2(12) NOT NULL	A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
45	DFI_ID_QUAL	Character(2)	VARCHAR2(2) NOT NULL	A banking industry convention identifier utilized to drive data validation for a given bank/counterparty. 01=Transit Number 02=Swift ID/BIC 03=CHIPS Participant ID 04=Canadian Bank Branch/Institute 05=CHIPS Universal ID ZZ=Mutually Defined
46	EFT_PYMNT_FMT_CD	Character(3)	VARCHAR2(3) NOT NULL	Payment Format 00=Standard SWIFT transfer 10=Urgent SWIFT 15=Euro-Transfer 21=Check, w/ receipt confirmation 22=Check, Urgent 23=Check, urgent w/ receipt 40=Postal Order CTX=Corp Trade Exchange PBC=Check, standard PPD=Prearranged Pay & Deposit WRT=Wire Transfer
47	STTLMNT_DT_EST	Date(10)	DATE	Date in which a deal transaction is estimated to be settled with a counterparty.
48	EFT_TRANS_HANDLING	Character(1)	VARCHAR2(1) NOT NULL	Transaction Handling D=Payment Only P=Prenotification X=Payment and Advice
49	REMIT_BANK_ACCOUNT	Character(35)	VARCHAR2(35) NOT NULL	Bank Account Number
50	REMIT_BRANCH_ID	Character(10)	VARCHAR2(10) NOT NULL	Branch ID
51	REMIT_CHECK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	Check Digit
52	REP_RTNG_NUM	Character(10)	VARCHAR2(10) NOT NULL	Routing Code
53	FORM_NBR_CONFIRMED	Character(1)	VARCHAR2(1) NOT NULL	Check Number Confirmed Y/N Table Edit Default Value: Y
54	DESCRLONG	Long Character	CLOB	Long Description
55	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag Y/N Table Edit Default Value: N
56	POSITIVE_PAY_DT	Date(10)	DATE	Positive Payment Date
57	POSITIVE_PAY_STAT	Character(1)	VARCHAR2(1) NOT NULL	Positive Payment Status C=Sent to bank N=Not Sent to bank S=Selected for transmission Z=Zero Payment Default Value: N
58	MICR_LINE	Character(50)	VARCHAR2(50) NOT NULL	MICR Line
59	RECONCILE_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The user ID that performed the reconciliation for a given transaction.
60	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
61	STTLMNT_DT_ACTUAL	Date(10)	DATE	Date in which a deal transaction is actually settled with a counterparty.
62	CASH_CLEARED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Cash Cleared Flag
63	CASH_CLEARED_DT	Date(10)	DATE	Cash Cleared Date
64	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
65	SCHEDULE_ID	Character(10)	VARCHAR2(10) NOT NULL	Schedule ID
66	TREASURY_PMT_NBR	Number(11,0)	DECIMAL(11) NOT NULL	Payment Confirm Number