| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pay Cycle
|
| 2 |
PAY_CYCLE_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Pay Cycle Sequence Number
|
| 3 |
ERR_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Cycle Error Type
ALL=All Error Types
S01=Supplier Bank
S02=IPAC Information
S03=Federal Payment
S04=Currency Conversion Related
S05=Negative Payment
S06=Financial Gateway Staging
S07=Payment Error
S08=Financial Sanctions
S09=Negative Payment/With.Restored
S10=Federal Payment Restrictions
S11=TAS & BETC Required
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 5 |
PAY_DOC_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Advice ID
|
| 6 |
PAY_DOC_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Advice Sequence
|
| 7 |
PYCYCL_KEY_FIELD1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Pay Cycle Mapping Key Field 1
|
| 8 |
PYCYCL_KEY_FIELD2 |
Date(10) |
DATE |
Pay Cycle Mapping Key Field 2
|
| 9 |
PYCYCL_KEY_FIELD3 |
Number(15,0) |
DECIMAL(15) NOT NULL |
Pay Cycle Mapping Key Field 3
|
| 10 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 11 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 12 |
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
|
| 13 |
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
|
| 14 |
PYMNT_ID_REF |
Character(20) |
VARCHAR2(20) NOT NULL |
Payment Reference
|
| 15 |
SOURCE_TXN |
Character(4) |
VARCHAR2(4) NOT NULL |
Source Transaction
|
| 16 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 17 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 18 |
ERROR_MESSAGE |
Character(254) |
VARCHAR2(254) NOT NULL |
For Standard Journal (SJE)
|