| # |
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 |
PYMNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Type
E=Express Payment
M=Manual Payment
R=Regular payment
W=Withholding Payment
Z=Zero Payment Check
|
| 7 |
REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit SetID
|
| 8 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
| 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 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 12 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 13 |
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
|
| 14 |
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
|
| 15 |
PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 16 |
PAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 17 |
PYMNT_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Payment Amount
|
| 18 |
CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 19 |
BASE_CURRENCY_BNK |
Character(3) |
VARCHAR2(3) NOT NULL |
The base currency of the subject bank general ledger business unit.
|
| 20 |
CUR_RT_TYPE_BNK |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 21 |
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
|
| 22 |
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
|
| 23 |
PYMNT_HANDLING_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
|
| 24 |
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. "
|
| 25 |
GROSS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Amount
|
| 26 |
BUSINESS_UNIT_BANK |
Character(5) |
VARCHAR2(5) NOT NULL |
The general ledger business unit associated with a given bank/counterparty.
|
| 27 |
SCHEDULED_PAY_DT |
Date(10) |
DATE |
Scheduled to Pay
|
| 28 |
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
|
| 29 |
PREPAID_APPLIED_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Applied Business Unit
|
| 30 |
PREPAID_APPL_VCHR |
Character(8) |
VARCHAR2(8) NOT NULL |
Applied Voucher ID
|
| 31 |
PREPAID_APPL_PYMNT |
Number(5,0) |
INTEGER NOT NULL |
Applied Payment Count
|
| 32 |
PREPAID_VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Prepaid Voucher Id
|
| 33 |
PREPAID_PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Prepayment Payment Number
|
| 34 |
PREPAID_CURR_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Prepayment Currency Code
|
| 35 |
PREPAID_BSE_CUR_BK |
Character(3) |
VARCHAR2(3) NOT NULL |
Prepayment Base Currency Bank
|
| 36 |
PREPAID_CUR_RT_TYP |
Character(5) |
VARCHAR2(5) NOT NULL |
Prepayment Bank Curr Rate Type
|
| 37 |
PREPAID_BNK_RT_MUL |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Prepayment Bank Rate Multiple
|
| 38 |
PREPAID_BNK_RT_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Prepayment Bank Rate Divisor
|
| 39 |
PREPAID_BU_BANK |
Character(5) |
VARCHAR2(5) NOT NULL |
Prepaid Business Unit Bank
|
| 40 |
ORIG_PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Original Payment Count
|
| 41 |
PREPAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Prepaid Amount
|
| 42 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 43 |
REMAINDER |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Remaining Amount
|
| 44 |
AVAILABLE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Prepayment Available Amount
|
| 45 |
APPLIED_AMT_PPAY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Applied to Prepayment
|
| 46 |
PYMNT_CNT_MAX |
Number(5,0) |
INTEGER NOT NULL |
Max payment count
|
| 47 |
PREPAID_MAX_PYMNT |
Number(5,0) |
INTEGER NOT NULL |
Maximum Prepayment Pymnt CNT
|
| 48 |
PYMNT_CNT_NEXT |
Number(5,0) |
INTEGER NOT NULL |
Next Sequential Payment Count
|
| 49 |
TEST_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Initial Issue # Description
12/07/00 JJM R-JMESER-JM6J2 Added label ID "History"
|
| 50 |
PYMNT_DT |
Date(10) |
DATE |
Payment Date
|
| 51 |
PREPAID_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Prepayment Reference
|
| 52 |
PREPAID_AUTO_APPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatically Apply Prepayment
|
| 53 |
DSCNT_DUE_DT |
Date(10) |
DATE |
Discount Due Date
|
| 54 |
DSCNT_PAY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Discount Amount
|
| 55 |
PAID_AMT_DSCNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount on Paid Amount
|
| 56 |
DSCNT_CHCK |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount Check
|
| 57 |
PYMNT_GROSS_APPL |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Applied Payment Gross Amount
|
| 58 |
PYMNT_GROSS_REM |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Remaining Payment Gross Amount
|
| 59 |
DSCNT_PAY_AMT_APPL |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Applied Discount Amount
|
| 60 |
DSCNT_PAY_AMT_REM |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Remaining Discount Amount
|
| 61 |
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.
|
| 62 |
VOUCHER_ID_TMP |
Character(8) |
VARCHAR2(8) NOT NULL |
Temporary Voucher ID
|
| 63 |
PYMNT_CNT_NEXT_APP |
Number(5,0) |
INTEGER NOT NULL |
Next Payment count application
|
| 64 |
PYMNT_CNT_NEXT_PPY |
Number(5,0) |
INTEGER NOT NULL |
Next Prepaid Payment Count Num
|
| 65 |
CHECK_PENDING_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
No Mult Pending Item Selection
Y/N Table Edit
Default Value: N
|
| 66 |
CHECK_APPL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Check for applied vouchers
Y/N Table Edit
Default Value: N
|
| 67 |
PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pay Cycle
|
| 68 |
PAY_CYCLE_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Pay Cycle Sequence Number
|
| 69 |
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
|
| 70 |
WTHD_ADDTL_GROSS |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Additional Withheld Gross Amt
|
| 71 |
WTHD_PREPAY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Signifies if Withholding applies to the prepayment
N=Not Applicable
V=Postpone to regular voucher
|
| 72 |
PYCYCL_PREPAY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Cycle Prepayment Option
N=Not Applicable
V=Postpone to Regular Voucher
|
| 73 |
MULTI_PREPAY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Prepayment Switch
|
| 74 |
MAN_PREPAY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 75 |
DSCNT_ALWAYS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Always take discount
|
| 76 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 77 |
WHERE_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 78 |
WHERE_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 79 |
WHERE_CLAUSE3 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 80 |
WHERE_CLAUSE4 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 81 |
DSCNT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Discount Amount
|
| 82 |
AMOUNT_DFR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Deferred Amount
|
| 83 |
DSCNT_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Discount
|
| 84 |
PAID_AMT_GROSS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Paid Amount
|
| 85 |
PAID_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Paid Amount
|
| 86 |
PAID_AMT_DSCNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Discount Paid Amount
|
| 87 |
PAID_AMT_GROSS_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Payment Amount
|
| 88 |
DFT_GROUP_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Draft Group Code
|
| 89 |
DFT_MAT_DT |
Date(10) |
DATE |
Draft Maturity Date
|
| 90 |
DFT_SCHED_MAT_DT |
Date(10) |
DATE |
Draft Scheduled Maturity Date
|
| 91 |
DFT_SIGHT_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Draft Sight Code
|
| 92 |
EFT_LAYOUT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
EFT Layout Code
|
| 93 |
STL_THROUGH |
Character(2) |
VARCHAR2(2) NOT NULL |
Settle through
01=Financial Gateway
02=Pay Cycle
|
| 94 |
WTHD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Withholding Applicable Flag
B=Global and 1099
G=Global
T=1099
|
| 95 |
NETAMT_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Net Amount
|
| 96 |
EXCISE_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Excise Tax
|
| 97 |
FREIGHT_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Freight
|
| 98 |
WTHD_SUT_APPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Sales/Use Tax
|
| 99 |
MISC_CHG_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Miscellaneous Charges
|
| 100 |
EXS_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Amount
|
| 101 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 102 |
STX_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 103 |
MISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc. Amount
|
| 104 |
PPAY_SEQNUM |
Number(6,0) |
INTEGER NOT NULL |
Sequence Number
Default Value: 1
|