| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
EPAY_ECHECK_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
eCheck Option
Y/N Table Edit
Default Value: N
|
| 3 |
EPAY_CCI_VENDOR |
Character(16) |
VARCHAR2(16) NOT NULL |
eCheck Processor Name
Prompt Table:
EPAY_VENDOR_VW
|
| 4 |
SETTLEMENT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Vendor Rebate Settlement Method (Payment Method)
ACH=Automated Clearing House
AV=Adjustment Voucher
CHK=Check
CM=Credit Memo
DD=Direct Debit
DR=Draft
EFT=Electronic Funds Transfer
Default Value: ACH
|
| 5 |
ACH_ENTRY_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
ACH Class
WEB=WEB
Default Value: WEB
|
| 6 |
ECHECK_AUTH_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Authentication Method
DL=Driver's License
DOB=Date of Birth
NOA=No Authentication
PIN=PIN
SSN=Social Security Number
Default Value: PIN
|
| 7 |
ECHECK_TERMS_COND |
Long Character |
CLOB |
eCheck Authorization (Terms and Conditions)
|
| 8 |
EPAY_ECHECKPIN_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
eCheck Option
M=Mandatory
O=Optional
Default Value: M
|
| 9 |
EPAY_CC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
eCheck Option
Y/N Table Edit
Default Value: Y
|
| 10 |
EPAY_DD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
eCheck Option
Y/N Table Edit
Default Value: Y
|
| 11 |
EPAY_PAYPAL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
PayPal option
Y/N Table Edit
|
| 12 |
EPAY_PAYPAL_VENDOR |
Character(16) |
VARCHAR2(16) NOT NULL |
PayPal processor
Prompt Table:
EPAY_VENDOR_VW
|
| 13 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 14 |
LAST_MAINT_DTTM |
DateTime(26) |
TIMESTAMP |
A system generated value that reflects the date and time a transaction was last modified
|