CSH_SWEEP_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	CSH_SWEEP_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a Cash Sweep/Concentratoin structure. The identifier is manually entered by the user and not automatically generated by the system.
3	CSH_SWEEP_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cash Sweep Type - Physical or Notional. N=Notional P=Physical
4	TRANSACTION_DT	Date(10)	DATE	Transaction date (often used as trade date)
5	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
6	SUB_BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The tableset ID for a sub bank account on the Cash Sweep Structure Definition.
7	SUB_BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Sub Bank Code on the Cash Sweep Structure Definition.
8	SUB_BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	Sub Bank Account on the Cash Sweep Structure Definition
9	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
10	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
11	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
12	CURRENCY_CD_ACCT	Character(3)	VARCHAR2(3) NOT NULL	The default currency defined for an external bank account.
13	TARGET_BALANCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The target bank account balance assigned to a given bank account.
14	TARGET_BAL_REVAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The target bank account balance assigned to a given bank account revalued to another currency.
15	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
16	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
17	MIN_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Minimum Amount
18	MAX_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Maximum Amount
19	RCMD_XFER_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Cash Pool Recommended Transfer Amount
20	ACTL_XFER_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Cash Pool Actual Transfer Amount
21	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
22	POSITION_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	The transaction currency of a given position or exposure.
23	POS_IMPCT_ORIG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the calculated monetary value for a specific position tree node; the result
24	POS_IMPCT_REVAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the calculated monetary value for a specific position tree node; the result revalued to another currency.
25	RATE_MULT_2	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
26	RATE_DIV_2	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
27	TRANSFER_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Transfer Class to indicate if Transfer is a Bank Transfer (BAX) or EFT Tansfer 1=Bank Transfer 2=EFT Transfer
28	CSH_SWEEP_ACT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cash Sweep Activity Type B=Bi-Directional C=Concentration F=Funding
29	ALLOW_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Allow user override Y/N Table Edit
30	TR_WR_TEMPLATE_ID	Character(12)	VARCHAR2(12) NOT NULL	Treasury Wires / Treasury Wire Templates This uniquely identifies templates within a Business Unit. Prompt Table: %EDITTABLE
31	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
32	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
33	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.