AP_APY2055_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPR_DEF_TBL_AP
3	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
4	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
5	PYMNT_DT	Date(10)	DATE	Payment Date
6	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
7	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
8	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
9	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
10	PYMNT_FILENAME	Character(18)	VARCHAR2(18) NOT NULL	Report ID
11	POS_PAY_FILENAME	Character(18)	VARCHAR2(18) NOT NULL	Positive Pay File Name
12	ERROR_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Error Status 1=None 2=Unbalanced 3=CF Combo Error 4=No Exchange Rate 5=Acct Not Specified 6=IU Processor Error 7=Document Sequencing Error
13	OUTDEST	Character(127)	VARCHAR2(127) NOT NULL	Process Scheduler Output Destination
14	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
15	AE_APPSTATUS	Number(1,0)	SMALLINT NOT NULL	AE Application Warning Status
16	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
17	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section