EX_VNDPMT_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
4	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
5	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
6	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
7	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
8	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
9	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
10	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
11	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
12	PYMNT_DT	Date(10)	DATE	Payment Date
13	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number
14	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
15	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
16	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
17	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
18	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount