| # |
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
|
| 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 |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 5 |
WS_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Worksheet ID
|
| 6 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 7 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 8 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 9 |
XREF_SELECTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Selected
Y/N Table Edit
Default Value: N
|
| 10 |
PAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 11 |
PYMNT_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Payment Amount
|
| 12 |
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.
|
| 13 |
DSCNT_PAY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Discount Amount
|
| 14 |
DSCNT_DUE_DT |
Date(10) |
DATE |
Discount Due Date
|
| 15 |
SCHEDULED_PAY_DT |
Date(10) |
DATE |
Scheduled to Pay
|
| 16 |
PAID_AMT_GROSS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Paid Amount
|
| 17 |
PAID_AMT_DSCNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount on Paid Amount
|
| 18 |
CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 19 |
REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit SetID
|
| 20 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
| 21 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 22 |
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
|
| 23 |
PAID_AMT_BNK_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount - Base Bank Unit
|
| 24 |
BASE_CURRENCY_BNK |
Character(3) |
VARCHAR2(3) NOT NULL |
The base currency of the subject bank general ledger business unit.
|
| 25 |
CUR_RT_TYPE_BNK |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 26 |
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
|
| 27 |
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
|
| 28 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 29 |
BUSINESS_UNIT_BANK |
Character(5) |
VARCHAR2(5) NOT NULL |
The general ledger business unit associated with a given bank/counterparty.
|
| 30 |
HOL_PROC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Holiday Processing Option
A=Due After Holiday
B=Due Before Holiday
N=Not Applicable
|
| 31 |
HOL_PROC_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days before/after Holiday
|
| 32 |
HOL_PROC_OVERFL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow due date in next month
|
| 33 |
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. "
|
| 34 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 35 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 36 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 37 |
GROSS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Amount
|
| 38 |
DSCNT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Discount Amount
|
| 39 |
CUR_RT_TYPE_PYMNT |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment Currency Rate Type
|
| 40 |
PYMNT_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange rate is stored
|
| 41 |
PYMNT_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange rate is store
|
| 42 |
PAID_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Paid Amount
|
| 43 |
PAID_AMT_GROSS_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Payment Amount
|
| 44 |
PAID_AMT_DSCNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Discount Paid Amount
|
| 45 |
CUR_RT_TYPE_PAID |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment Rate Type
|
| 46 |
PAID_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored either as
|
| 47 |
PAID_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is store
|
| 48 |
DFT_MAT_DT |
Date(10) |
DATE |
Draft Maturity Date
|
| 49 |
DFT_SCHED_MAT_DT |
Date(10) |
DATE |
Draft Scheduled Maturity Date
|
| 50 |
DFT_MASTER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Draft Master ID
|
| 51 |
PAY_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID for a bank on the disbursing side of a settlement transaction.
|
| 52 |
PAY_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
The bank for the disbursing side of a settlement transaction.
|
| 53 |
PAY_BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
The bank account for the disbursing side of a settlement transaction.
|
| 54 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 55 |
BANK_ACCT_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Bank Account Sequence Number
|
| 56 |
PYMNT_SEPARATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Separate Payment
Y/N Table Edit
Default Value: N
|
| 57 |
COMBINE_PYMNT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Combine Pymnt Option
Y/N Table Edit
Default Value: N
|
| 58 |
WTHD_CALC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Withholding Calculated
Default Value: N
|
| 59 |
WTHD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Withholding Applicable Flag
B=Global and 1099
G=Global
T=1099
|