| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 4 |
FILTER_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Filter criteria for payment mass maintenance
CN=Cancel
ES=Escheat/Stale-date
UC=Undo Cancel
UE=Undo Escheat/Stale-date
|
| 5 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 6 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 7 |
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
|
| 8 |
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
|
| 9 |
RESTORE_ENCUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Restore Encumbrance to PO
|
| 10 |
STL_THROUGH |
Character(2) |
VARCHAR2(2) NOT NULL |
Settle through
01=Financial Gateway
02=Pay Cycle
|
| 11 |
PYMNT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Status
A=Alignment
E=ACH/EFT Prenote
L=Stale Dated Payment
N=Reprinted with same ref number
O=Overflow
P=Paid
R=Replaced
S=Stopped
T=Undo Escheatment
U=Undo Cancel
V=Void
W=Escheated Check
X=Deleted
|
| 12 |
CANCEL_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Action
C=Do Not Reissue/Close Liability
H=Re-Open Voucher(s)/Put on Hold
N=No Cancel Action
P=Processed
R=Re-Open Voucher(s)/Re-Issue
S=Stale Dated Check
W=Escheated
|
| 13 |
CANCEL_DT |
Date(10) |
DATE |
Date Cancelled
|
| 14 |
PYMNT_HOLD_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Hold Reason
ACC=Accounting in Dispute
ACV=Federal Supplier Inactive
ALC=Agency Location Code Required
AMT=Amount in Dispute
CCR=CCR Expired
CRT=Contract Retention
EFT=EFT incomplete or not Prenoted
FNS=Financial Sanctions
GDS=Goods in Dispute
GNV=G-Invoicing Hold
IPC=Inbound IPAC Required
OTH=Other
QTY=Quantity in Dispute
SAM=SAM Expired
WTH=Withholding Hold
|
| 15 |
ACH_RRC |
Character(3) |
VARCHAR2(3) NOT NULL |
ACH Return Reason Code
|
| 16 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 17 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 18 |
PROCESSING_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count based on Processing Level used to determine the Processing Group. A value of zero indicates include all data into one Processing Group. This count can be used to help tune at a site that is running into issues with large runs causing blocking and deadlocks on the base tables updated by the Process. When processing, if Commit Count is greater than the specified Processing Count and the Processing Level is the same as the Commit Level, the Processing Count should be set to the Commit Count.
|
| 19 |
ERROR_COUNT |
Number(9,0) |
DECIMAL(9) NOT NULL |
Error Count
|
| 20 |
PROCESS_DATE |
Date(10) |
DATE |
Process Date
|
| 21 |
WITHHOLDING |
Character(1) |
VARCHAR2(1) NOT NULL |
Withholding Post Functions
|
| 22 |
ESCHEATED_DT |
Date(10) |
DATE |
Stale Date
|
| 23 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
|
| 24 |
DO_DOC_SEQUENCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Do Document Sequencing
|
| 25 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 26 |
PYMNT_REASON_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Payment Reason Code
|