PYCYCL_NEG_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
2	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
3	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
4	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
5	REMIT_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Remitting Location
6	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
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	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling
12	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
13	SOURCE_TXN	Character(4)	VARCHAR2(4) NOT NULL	Source Transaction
14	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
15	PAY_DOC_ID	Character(20)	VARCHAR2(20) NOT NULL	Advice ID
16	PAY_DOC_SEQ	Number(5,0)	INTEGER NOT NULL	Advice Sequence
17	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
18	COMBINE_PYMNT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Combine Pymnt Option
19	PYMNT_SEPARATE	Character(1)	VARCHAR2(1) NOT NULL	Separate Payment
20	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount