TR_FEE_SEQ_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_TRD_NONVW
2	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
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	FEE_SEQ_NUM	Number(15,0)	DECIMAL(15) NOT NULL	Represents the sequential numbering of detail fee transactions within a given facility.
5	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: BANK_EX_ACTIVE
6	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_ACTVE
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: BANK_ACCTCUR_VW
8	SETTLEMENT_ID	Character(5)	VARCHAR2(5) NOT NULL	A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc Prompt Table: STL_INSTR_VW
9	FA_FEE_CODE	Character(20)	VARCHAR2(20) NOT NULL	Fee code mapped to Bank Fee code used for Fee Analysis. Prompt Table: %EDITTABLE Set Control Field: BUSINESS_UNIT
10	FEE_STRUCTURE	Character(5)	VARCHAR2(5) NOT NULL	Structure Code for Fee Analysis Prompt Table: FA_FEE_STR_HDR
11	FEE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The transaction fee amount.
12	TRANSACTION_DT	Date(10)	DATE NOT NULL	Transaction date (often used as trade date) Default Value: %date
13	VALUE_DT	Date(10)	DATE NOT NULL	Equivalent to a deal transaction's settlement date.
14	FEE_START	Date(10)	DATE	The beginning accrual date for fee transactions.
15	FEE_END	Date(10)	DATE	End of the fees accrual period
16	FEE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	The fee transaction status. D=Denied N=Not Selected P=Processed S=Selected Default Value: N
17	INT_BASIS	Character(2)	VARCHAR2(2) NOT NULL	Day Count Basis 30=30/360 3E=30E/360 A0=Actual/360 A5=Actual/365 AA=Actual/Actual
18	ACCTG_TMPL_ID_CF	Character(15)	VARCHAR2(15) NOT NULL	The treasury accounting template associated with a treasury facility fee that is to be expensed. Prompt Table: %EDITTABLE2
19	ACCTG_TMPL_ID_POS	Character(15)	VARCHAR2(15) NOT NULL	The treasury accounting template associated with a treasury facility fee that is to be amortized Prompt Table: %EDITTABLE2
20	SELLBUY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Represents Sell/Buyback Flag on the Fee Seq Row Y/N Table Edit Default Value: N
21	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 Prompt Table: FEE_PYMT_MTHD_V
22	FORMAT_ID	Character(10)	VARCHAR2(10) NOT NULL	Format ID Prompt Table: TR_FORMAT_VW
23	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
24	DTTM_ENTERED	DateTime(26)	TIMESTAMP	Date Time Stamp for Entry