FCST_BNKXFR_EXT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	BAX_TRANSFER_ID	Character(12)	VARCHAR2(12) NOT NULL	An unique key identifier that represents a bank transfer transaction.
3	BUSINESS_DATE	Date(10)	DATE	Represents a date upon which business is conducted within a given company in a given country.
4	ACCT_BUS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	The general ledger business unit associated with a given bank/counterparty account.
5	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
7	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
8	BANK_CD_CUST	Character(5)	VARCHAR2(5) NOT NULL	Represents the customer bank or counterparty in a relationship that pairs differing sets of b Prompt Table: BAX_ACCT_VW3
9	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: %EDITTABLE2
10	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: %EDITTABLE3
11	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. Prompt Table: BANK_ID_VW
12	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account. Prompt Table: BANK_ACCT_TBL
13	TRANSACTION_LINE	Number(3,0)	SMALLINT NOT NULL	The separate and distinct base instrument type components of a given deal transaction.
14	RECONCILE_DT	Date(10)	DATE	The transaction reconciliation date.
15	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
16	STTLMNT_DT_ACTUAL	Date(10)	DATE	Date in which a deal transaction is actually settled with a counterparty.
17	CPTY_REFERENCE	Character(15)	VARCHAR2(15) NOT NULL	A reference identifier associated with a dealing counterparty transaction.
18	CF_SOURCE_REF_ID	Character(40)	VARCHAR2(40) NOT NULL	Reference identifier for a treasury system cash flow.
19	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
20	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
21	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
22	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount
23	PAID_AMT_BNK_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount - Base Bank Unit
24	PAID_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Paid Amount
25	PYMNT_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange rate is store
26	PYMNT_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange rate is stored
27	TRANSACTION_DATE	Date(10)	DATE	Transaction Date
28	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