PYMNT_APPL_WS1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
2	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: BANK_CD_TBL
3	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
4	PYMNT_ID_REF	Character(20)	VARCHAR2(20) NOT NULL	Payment Reference
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
7	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
8	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number
9	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
10	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
11	PYMNT_DT	Date(10)	DATE	Payment Date
12	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
13	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
14	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. "
15	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount
16	PAID_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Paid Amount
17	PAID_AMT_GROSS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Paid Amount
18	PAID_AMT_DSCNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount on Paid Amount
19	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
20	CUR_RT_TYPE_PYMNT	Character(5)	VARCHAR2(5) NOT NULL	Payment Currency Rate Type
21	PYMNT_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange rate is stored
22	PYMNT_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange rate is store
23	PAID_AMT_GROSS_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Gross Payment Amount
24	PAID_AMT_DSCNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Discount Paid Amount
25	PYMNT_GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Payment Amount
26	GROSS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Gross Amount
27	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
28	DSCNT_PAY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Discount Amount
29	DSCNT_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Discount Amount
30	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
31	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
32	DSCNT_DUE_DT	Date(10)	DATE	Discount Due Date
33	SCHEDULED_PAY_DT	Date(10)	DATE	Scheduled to Pay
34	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
35	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
36	PYMNT_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Hold Payment N=No Y=Yes Y/N Table Edit
37	PYMNT_HOLD_WTHD	Character(1)	VARCHAR2(1) NOT NULL	On Withholding Hold N=No Y=Yes Y/N Table Edit
38	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
39	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
40	INVOICE_DT	Date(10)	DATE	Invoice Date
41	PAID_AMT_BNK_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount - Base Bank Unit
42	BASE_CURRENCY_BNK	Character(3)	VARCHAR2(3) NOT NULL	The base currency of the subject bank general ledger business unit.
43	CUR_RT_TYPE_BNK	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
44	BNK_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange spot rate is stored either as
45	BNK_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange spot rate is store
46	BUSINESS_UNIT_BANK	Character(5)	VARCHAR2(5) NOT NULL	The general ledger business unit associated with a given bank/counterparty.