| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 4 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 5 |
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
|
| 6 |
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
|
| 7 |
CANCEL_DT |
Date(10) |
DATE |
Date Cancelled
|
| 8 |
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
|
| 9 |
ACH_RRC |
Character(3) |
VARCHAR2(3) NOT NULL |
ACH Return Reason Code
|
| 10 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 11 |
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
|
| 12 |
RESTORE_ENCUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Restore Encumbrance to PO
|
| 13 |
WITHHOLDING |
Character(1) |
VARCHAR2(1) NOT NULL |
Withholding Post Functions
|
| 14 |
ESCHEATED_DT |
Date(10) |
DATE |
Stale Date
|
| 15 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
|
| 16 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 17 |
PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 18 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 19 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 20 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 21 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 22 |
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
|
| 23 |
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
|
| 24 |
POSITIVE_PAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Positive Payment Flag
|
| 25 |
RUN_CNTL_ID2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 26 |
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.
|
| 27 |
DO_DOC_SEQUENCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Do Document Sequencing
|
| 28 |
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.
|
| 29 |
DOC_SEQ_DATE |
Date(10) |
DATE |
Specifies the date that a document sequence number is assigned to a document or the date the document was created.
|
| 30 |
DOC_SEQ_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
|
| 31 |
DOC_SEQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled
A=GL BU Undefined
B=GL BU Blank
C=Accounting Date blank
D=Doc Type Blank
E=Jrnl Type, Code, Doc Undefine
F=Sequence Range Undefine
G=Max. Sequence Number Reached
H=Manual Nbr for Auto Doc Type
I=No Manual Number Entered
J=Duplicate Manual Number
K=Invalid Ledger
L=Invalid Ledger Group
N=No Status
|
| 32 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 33 |
PMT_PYMNT_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Settlement Status
C=Canceled
CM=Cancelled with Message
E=Error
H=Hold
L=Loaded
N=None
P=Paid
PC=Pending Cancellation
R=Received by Bank
S=Send to Bank
SC=In Process
|
| 34 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 35 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 36 |
PYMNT_REASON_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Payment Reason Code
|