STLEFTTRAN_TEO3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
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	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
4	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
5	BUSINESS_DATE	Date(10)	DATE	Represents a date upon which business is conducted within a given company in a given country.
6	CASH_FLOW_LINE	Number(15,0)	DECIMAL(15) NOT NULL	A sequential number that indicates the time order sequence of a given deal transaction's cash flows.
7	CASH_FLOW_LEG	Number(1,0)	SMALLINT NOT NULL	A sequential number that indicates the relationship between a cash flow and its corresponding deal transaction leg
8	PAY_DOC_SEQ	Number(5,0)	INTEGER NOT NULL	Advice Sequence
9	CASH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Represents the type of cash flow stored in the Treasury database. 01=Actual 02=Provisional 03=Sample 04=Deactivated
10	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
13	BANK_CD_CUST	Character(5)	VARCHAR2(5) NOT NULL	Represents the customer bank or counterparty in a relationship that pairs differing sets of b
14	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
15	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
16	ACCT_BUS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	The general ledger business unit associated with a given bank/counterparty account.
17	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
18	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
19	RECONCILE_DT	Date(10)	DATE	The transaction reconciliation date.
20	RECONCILE_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The user ID that performed the reconciliation for a given transaction.
21	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
22	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
23	RECON_CYCLE_NBR	Number(10,0)	DECIMAL(10) NOT NULL	The bank statement ID.
24	STTLMNT_DT_ACTUAL	Date(10)	DATE	Date in which a deal transaction is actually settled with a counterparty.
25	NET_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Indicates the counterparty netting status of a given settlement transaction. D=Netted N=Net O=Not Netted Default Value: O
26	APPROVAL_OPRID	Character(30)	VARCHAR2(30) NOT NULL	A system generated value that reflects the operator that approved a given transaction.
27	CPTY_REFERENCE	Character(15)	VARCHAR2(15) NOT NULL	A reference identifier associated with a dealing counterparty transaction.
28	NET_REF_ID	Character(12)	VARCHAR2(12) NOT NULL	A reference identifier associated with a cash transaction subject to netting with a given bank/count
29	CF_SOURCE_REF_ID	Character(40)	VARCHAR2(40) NOT NULL	Reference identifier for a treasury system cash flow.
30	CP_NETTOR	Character(30)	VARCHAR2(30) NOT NULL	Allows the user to indicate whether a given dealing counterparty permits netting of inbound and outbou
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	SETTLEMENT_ID	Character(5)	VARCHAR2(5) NOT NULL	A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc
33	PYMNT_SELCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Selection Status C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid Default Value: X
34	APPROVAL_FLG_TR	Character(1)	VARCHAR2(1) NOT NULL	An internal work field that indicates that a given treasury transaction has been approved by A=Approved D=Denied N=None Required P=Pending Approval Default Value: N
35	APPROV_SUBMITTED	Character(1)	VARCHAR2(1) NOT NULL	An internal work field that indicates whether a treasury deal review and/or confirmation transac Default Value: N
36	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number
37	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
38	BASE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents a transaction amount calculated and stored in the base currency of its associated General Ledger bus
39	BASE_CURRENCY_BNK	Character(3)	VARCHAR2(3) NOT NULL	The base currency of the subject bank general ledger business unit.
40	BNK_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange spot rate is store
41	BNK_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange spot rate is stored either as
42	CUR_RT_TYPE_BNK	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
43	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
44	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount
45	PAID_AMT_BNK_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount - Base Bank Unit
46	PAID_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Paid Amount
47	PYMNT_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange rate is store
48	PYMNT_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange rate is stored
49	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
50	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
51	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
52	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
53	BANK_ID_QUAL	Character(3)	VARCHAR2(3) NOT NULL	"A bank/counterparty attribute that determines
54	BRANCH_ID	Character(10)	VARCHAR2(10) NOT NULL	The local branch office identifier associated with a given bank/counterparty.
55	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
56	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
57	BANK_ACCT_QUAL	Character(1)	VARCHAR2(1) NOT NULL	"An account attribute that determines C=Corporate Account
58	BNK_ID_NBR_TARG	Character(20)	VARCHAR2(20) NOT NULL	Target or Receiving EFT Bank
59	BANK_ACCT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	An account attribute that describes the ostensible purposes of a given bank/counterparty account. 01=Time Deposit 03=Checking Account 05=Stock 06=Bond 07=Life Insurance Value 08=Retirement Account 10=Business Account 11=Trust Fund Account 12=Stock & Bond Account 13=Life Insurance Acct CA=Current Account CH=Charges Account DA=Demand Deposit LN=Loan RD=Return Items on DDA RS=Return Items-Savings SA=Settlement Account SV=Savings Account Z=Mutually Defined
60	BANK_ACCT_NUM_TARG	Character(35)	VARCHAR2(35) NOT NULL	Target EFT Bnk Acct Num
61	CHECK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	Check Digit
62	BENEFICIARY_BANK	Character(30)	VARCHAR2(30) NOT NULL	The bank/counterparty associated with a given beneficiary.
63	BUS_UNIT_NAME	Character(30)	VARCHAR2(30) NOT NULL	Business Unit Name
64	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
65	EFT_RTNG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Complex Routing D=Use DFI ID N=None R=Use Complex Routing Default Value: D
66	EFT_RTNG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Routing Status C=Complete I=Incomplete Default Value: I
67	EFT_TRANS_HANDLING	Character(1)	VARCHAR2(1) NOT NULL	Transaction Handling D=Payment Only P=Prenotification X=Payment and Advice Default Value: X
68	EFT_DOM_COSTS_CD	Character(1)	VARCHAR2(1) NOT NULL	Domestic Costs 1=Payer's Domestic Account 2=Payer's Foreign Account 3=Payee's Account 4=Trans Exp to Pyr, other to Pye
69	EFT_CORR_COSTS_CD	Character(1)	VARCHAR2(1) NOT NULL	Correspondent's Costs 1=Payer's Domestic Account 2=Payer's Foreign Account 3=Payee's Account
70	EFT_CROSSED_CHECK	Character(1)	VARCHAR2(1) NOT NULL	Crossed Check Y/N Table Edit Default Value: N
71	EFT_CHECK_FWRD_CD	Character(1)	VARCHAR2(1) NOT NULL	Check Forwarding 1=Payer's Bank 2=Payer 3=Payee 4=Payee's Bank
72	EFT_CHECK_DRAW_CD	Character(1)	VARCHAR2(1) NOT NULL	Bank Check Drawn On 1=Payer's Bank 2=Payee's Bank
73	EFT_PAY_INST_CD1	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 1 ACC=/ACC/ BEN=/BENONLY/ CHK=/CHECK/ COR=/CORPTRAD/ HLD=/HOLD/ INT=/INT/ IRR=PAYMENT IRREVOCABLE PHB=/PHONEBEN/ PHI=/PHONIBK/ PHN=/PHON/ RC1=ADV BEN W/CHARGES RC2=ADV BEN W/O CHARGES RCB=/RCB/ REC=/REC/ REJ=/REJT/ RET=BEN UNKNOWN RETURN TEB=/TELEBEN/ TEI=/TELEIBK/ TEL=/TELE/ XFR=INTERCOMPANY TRANSFER Prompt Table: EFT_PAY_INST_VW
74	EFT_PAY_INST_CD2	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 2 Prompt Table: EFT_PAY_INST_VW
75	EFT_PAY_INST_CD3	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 3 Prompt Table: EFT_PAY_INST_VW
76	EFT_PAY_INST_CD4	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 4 Prompt Table: EFT_PAY_INST_VW
77	EFT_PAY_INST_REF1	Character(40)	VARCHAR2(40) NOT NULL	Payment Instruction Ref 1
78	EFT_PAY_INST_REF2	Character(40)	VARCHAR2(40) NOT NULL	Payment Instruction Ref 2
79	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
80	NAME1_AC	Character(40)	VARCHAR2(40) NOT NULL	Name 1 Alternate Char Set
81	NAME2	Character(40)	VARCHAR2(40) NOT NULL	Name 2
82	NAME2_AC	Character(40)	VARCHAR2(40) NOT NULL	Name 2 Alternate Char Set
83	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
84	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
85	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
86	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
87	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
88	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
89	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
90	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
91	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat WW=Trailer
92	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
93	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
94	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
95	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
96	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
97	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
98	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
99	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
100	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Int'l Prefix
101	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
102	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone Extension
103	FAX	Character(24)	VARCHAR2(24) NOT NULL	Fax Number
104	TR_RVL_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	The market rate type selected as applicable to mark-to-market revaluation events.
105	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
106	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
107	ADDENDA	Character(140)	VARCHAR2(140) NOT NULL	Payment Instruction
108	STL_THROUGH	Character(2)	VARCHAR2(2) NOT NULL	Settle through 01=Financial Gateway 02=Pay Cycle
109	PMTRUNINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process ID
110	REPETITVE_TRNFR_CD	Character(15)	VARCHAR2(15) NOT NULL	Repetitive Transfer Code assigned by customers Bank
111	DRAWDOWN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Drawdown Transfer Flag, either yes or no. N=No Y=Yes
112	PMT_FILE_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment File ID
113	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code