| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 4 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 5 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 6 |
SEQNO2 |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 7 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 8 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 9 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 10 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 11 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 12 |
REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit SetID
|
| 13 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
| 14 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 15 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 16 |
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
|
| 17 |
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
|
| 18 |
PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 19 |
PAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 20 |
PYMNT_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Payment Amount
|
| 21 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 22 |
CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 23 |
BASE_CURRENCY_BNK |
Character(3) |
VARCHAR2(3) NOT NULL |
The base currency of the subject bank general ledger business unit.
|
| 24 |
CUR_RT_TYPE_BNK |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 25 |
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
|
| 26 |
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
|
| 27 |
PYMNT_HANDLING_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
|
| 28 |
BUSINESS_UNIT_BANK |
Character(5) |
VARCHAR2(5) NOT NULL |
The general ledger business unit associated with a given bank/counterparty.
|
| 29 |
PREPAID_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Prepaid Status
A=Applied
B=Pending Application
C=Pending Unapply
D=Pending Change
F=Fully Applied
I=Inactive
P=Available Prepayment
R=Restricted
U=Unapplied
X=Cancelled
|
| 30 |
PREPAID_APPLIED_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Applied Business Unit
|
| 31 |
PREPAID_APPL_VCHR |
Character(8) |
VARCHAR2(8) NOT NULL |
Applied Voucher ID
|
| 32 |
PREPAID_APPL_PYMNT |
Number(5,0) |
INTEGER NOT NULL |
Applied Payment Count
|
| 33 |
PREPAID_VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Prepaid Voucher Id
|
| 34 |
PREPAID_PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Prepayment Payment Number
|
| 35 |
PREPAID_CURR_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Prepayment Currency Code
|
| 36 |
PREPAID_BSE_CUR_BK |
Character(3) |
VARCHAR2(3) NOT NULL |
Prepayment Base Currency Bank
|
| 37 |
PREPAID_CUR_RT_TYP |
Character(5) |
VARCHAR2(5) NOT NULL |
Prepayment Bank Curr Rate Type
|
| 38 |
PREPAID_BNK_RT_MUL |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Prepayment Bank Rate Multiple
|
| 39 |
PREPAID_BNK_RT_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Prepayment Bank Rate Divisor
|
| 40 |
PREPAID_BU_BANK |
Character(5) |
VARCHAR2(5) NOT NULL |
Prepaid Business Unit Bank
|
| 41 |
ORIG_PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Original Payment Count
|
| 42 |
PREPAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Prepaid Amount
|
| 43 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 44 |
REMAINDER |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Remaining Amount
|
| 45 |
PYMNT_CNT_MAX |
Number(5,0) |
INTEGER NOT NULL |
Max payment count
|
| 46 |
PREPAID_MAX_PYMNT |
Number(5,0) |
INTEGER NOT NULL |
Maximum Prepayment Pymnt CNT
|
| 47 |
PYMNT_CNT_NEXT |
Number(5,0) |
INTEGER NOT NULL |
Next Sequential Payment Count
|
| 48 |
SEQNUM_NEXT |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 49 |
SEQNO_MAX |
Number(3,0) |
SMALLINT NOT NULL |
Maximum Sequence Number
|
| 50 |
TEST_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Initial Issue # Description
12/07/00 JJM R-JMESER-JM6J2 Added label ID "History"
|
| 51 |
PYMNT_DT |
Date(10) |
DATE |
Payment Date
|
| 52 |
PREPAID_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Prepayment Reference
|
| 53 |
PREPAID_AUTO_APPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatically Apply Prepayment
|
| 54 |
DSCNT_DUE_DT |
Date(10) |
DATE |
Discount Due Date
|
| 55 |
DSCNT_PAY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Discount Amount
|
| 56 |
PAID_AMT_DSCNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount on Paid Amount
|
| 57 |
DSCNT_CHCK |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount Check
|
| 58 |
PYMNT_GROSS_APPL |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Applied Payment Gross Amount
|
| 59 |
PYMNT_GROSS_REM |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Remaining Payment Gross Amount
|
| 60 |
DSCNT_PAY_AMT_APPL |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Applied Discount Amount
|
| 61 |
DSCNT_PAY_AMT_REM |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Remaining Discount Amount
|
| 62 |
NET_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The resulting net amount related to settlement cash flows subject to counterparty netting agreements.
|
| 63 |
VOUCHER_ID_TMP |
Character(8) |
VARCHAR2(8) NOT NULL |
Temporary Voucher ID
|
| 64 |
PYMNT_CNT_NEXT_APP |
Number(5,0) |
INTEGER NOT NULL |
Next Payment count application
|
| 65 |
PYMNT_CNT_NEXT_PPY |
Number(5,0) |
INTEGER NOT NULL |
Next Prepaid Payment Count Num
|
| 66 |
CHECK_PENDING_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
No Mult Pending Item Selection
Y/N Table Edit
Default Value: N
|
| 67 |
CHECK_APPL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Check for applied vouchers
Y/N Table Edit
Default Value: N
|
| 68 |
PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pay Cycle
|
| 69 |
PAY_CYCLE_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Pay Cycle Sequence Number
|
| 70 |
PYMNT_SELCT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Selection Status
C=Closed
D=Negative Voucher Sum
E=Externally Paid
F=Federal Sanctions Error
I=In Process - EFT
N=Not Selected for Payment
O=Financial Sanctions Review
P=Paid
R=Requested for Payment
S=Settlement Payment
V=Convert Error
X=Canceled
Y=Prepaid
|
| 71 |
WTHD_ADDTL_GROSS |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Additional Withheld Gross Amt
|
| 72 |
WTHD_PREPAY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Signifies if Withholding applies to the prepayment
N=Not Applicable
V=Postpone to regular voucher
|
| 73 |
WTHD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Withholding Applicable Flag
B=Global and 1099
G=Global
T=1099
|
| 74 |
PYCYCL_PREPAY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Cycle Prepayment Option
N=Not Applicable
V=Postpone to Regular Voucher
|
| 75 |
MULTI_PREPAY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Prepayment Switch
|
| 76 |
MAN_PREPAY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 77 |
AVAILABLE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Prepayment Available Amount
|
| 78 |
APPLIED_AMT_PPAY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Applied to Prepayment
|
| 79 |
APPLIED_PCT |
Signed Number(21,15) |
DECIMAL(19,15) NOT NULL |
Percent Applied to Prepayment
|
| 80 |
CF_BAL_LINE_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Chart Field Balancing Line Num
|
| 81 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 82 |
WHERE_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 83 |
WHERE_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 84 |
WHERE_CLAUSE3 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 85 |
WHERE_CLAUSE4 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 86 |
PYMNT_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange rate is stored
|
| 87 |
PYMNT_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange rate is store
|
| 88 |
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
|
| 89 |
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
|
| 90 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 91 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 92 |
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. "
|
| 93 |
VCHR_SRC |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Source
|
| 94 |
PREPAID_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prepaid offering
N=Exclude Prepaid
Y=Include Prepaid
|
| 95 |
OPTIONAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Optional flag
|
| 96 |
WHERE_CLAUSE_LONG3 |
Long Character(4000) |
CLOB |
Where Clause
|
| 97 |
DFT_GROUP_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Draft Group Code
|
| 98 |
DFT_MAT_DT |
Date(10) |
DATE |
Draft Maturity Date
|
| 99 |
DFT_SCHED_MAT_DT |
Date(10) |
DATE |
Draft Scheduled Maturity Date
|
| 100 |
DFT_SIGHT_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Draft Sight Code
|
| 101 |
EFT_LAYOUT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
EFT Layout Code
|
| 102 |
PYMNT_OVERFLOW_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Payment Overflow ID
|
| 103 |
PPAY_SEQNUM |
Number(6,0) |
INTEGER NOT NULL |
Sequence Number
Default Value: 1
|
| 104 |
SEQ_NUM2 |
Number(6,0) |
INTEGER NOT NULL |
Sequence Number
|
| 105 |
PPAY_SEQNUM_MAX |
Number(6,0) |
INTEGER NOT NULL |
Prepayment Max Sequence No
|