TR_WR_DTL_CRYPT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	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
3	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 Default Value: W
4	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
5	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
6	BANK_ACCT_ENCRYPT	Character(250)	VARCHAR2(250) NOT NULL	Stores Encrypted BankAccount Value
7	BNK_ID_ACT_ENCRYPT	Character(250)	VARCHAR2(250) NOT NULL	Stores Encrypted value of BankID and AccountNumber
8	IBAN_ID	Character(34)	VARCHAR2(34) NOT NULL	IBAN - Internation Bank Account Number is used in European countries to uniquely identify Bank accounts across borders
9	IBAN_ID_ENCRYPT	Character(250)	VARCHAR2(250) NOT NULL	Encrypt IBAN
10	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp Default Value: %datetime