BCH_PYMNT_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
3	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	PAY_DOC_ID	Character(20)	VARCHAR2(20) NOT NULL	Advice ID
6	PAY_DOC_SEQ	Number(5,0)	INTEGER NOT NULL	Advice Sequence
7	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
8	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
9	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
10	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
11	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
12	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
13	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
14	REMIT_LOC	Character(10)	VARCHAR2(10) NOT NULL	Remit to Location
15	BANK_ACCT_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Bank Account Sequence Number
16	PYMNT_DT	Date(10)	DATE	Payment Date
17	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
18	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
19	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
20	AMOUNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
21	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
22	DECIMAL_POSITIONS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions