| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 2 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 3 |
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
|
| 4 |
PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 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 |
SELECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
EI Repos: Selection
Y/N Table Edit
|
| 7 |
PMNT_OR_CANC_DT |
Date(10) |
DATE |
Payment or Cancel Date
|
| 8 |
PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pay Cycle
|
| 9 |
PYMNT_ID_REF |
Character(20) |
VARCHAR2(20) NOT NULL |
Payment Reference
|
| 10 |
PIR_CLASSIFICATION |
Character(2) |
VARCHAR2(2) NOT NULL |
PIR Classification
BA=Adjustment
BC=Check
BI=International
BN=ACH/EFT
BW=Wire
|
| 11 |
USF_PIR_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
PIR Input System Name
|
| 12 |
PIR_VERSION_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
PIR Version ID
|
| 13 |
PIR_AGENCY_NAME |
Character(4) |
VARCHAR2(4) NOT NULL |
PIR Agency Name
|
| 14 |
PIR_SCHD_NUM |
Character(14) |
VARCHAR2(14) NOT NULL |
PIR Schedule Number
|
| 15 |
PIR_SUMM_NUM |
Character(6) |
VARCHAR2(6) NOT NULL |
PIR Schedule Number
|
| 16 |
PIR_SUMM_DT |
Date(10) |
DATE |
PIR Summary Date
|
| 17 |
PIR_PAYMENT_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
PIR Payment ID
|
| 18 |
PIR_VOUCHER_FRM_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
PIR Voucher Form Code
215=Adjustment
5515=Payment
|
| 19 |
HOLD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold
N=Hold
Y=Hold
|
| 20 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
|
| 21 |
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
|
| 22 |
PYMNT_DT |
Date(10) |
DATE |
Payment Date
|
| 23 |
CANCEL_DT |
Date(10) |
DATE |
Date Cancelled
|
| 24 |
PYMNT_HANDLING_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
|
| 25 |
TAS_BETC_SCH |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
TAS/BETC Per Schedule
|
| 26 |
TAS_BETC_PYMNT |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
TAS/BETC Per Payment
|
| 27 |
DFI_ID_NUM |
Character(12) |
VARCHAR2(12) NOT NULL |
A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
|
| 28 |
RECV_DFI_ID_NUM |
Character(12) |
VARCHAR2(12) NOT NULL |
Receiving DFI ID Number
|
| 29 |
ALC |
Character(8) |
VARCHAR2(8) NOT NULL |
Agency Location Code
|
| 30 |
IPAC_SENDER_DO |
Character(5) |
VARCHAR2(5) NOT NULL |
Sender Disbursing Office
|
| 31 |
CREATION_DT |
Date(10) |
DATE |
Creation Date
|
| 32 |
TREASURY_PMT_NBR |
Number(11,0) |
DECIMAL(11) NOT NULL |
Payment Confirm Number
|
| 33 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 34 |
SCHEDULE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule ID
|
| 35 |
PAID_AMT_GROSS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Paid Amount
|
| 36 |
PAID_AMT_GROSS_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Payment Amount
|
| 37 |
PAID_AMT_DSCNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount on Paid Amount
|
| 38 |
PAID_AMT_DSCNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Discount Paid Amount
|
| 39 |
LATE_CHRG_PAID |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Paid
|
| 40 |
LATE_CHRG_PAID_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Paid Base
|
| 41 |
PYMNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Amount
|
| 42 |
TOTAL_PAY_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Payment Amount - Base
|
| 43 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 44 |
NAME2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 2
|
| 45 |
REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit SetID
|
| 46 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
| 47 |
VENDOR_NAME_SHORT |
Character(14) |
VARCHAR2(14) NOT NULL |
Short Vendor Name
|
| 48 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 49 |
PIR_PMT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
PIR Payment Type
MISC=Miscellaneous
TRVL=Travel
VNDR=Vendor
|
| 50 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 51 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 52 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 53 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 54 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 55 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 56 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 57 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 58 |
BANK_ACCT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
An account attribute that describes the ostensible purposes of a given bank/counterparty account.
01=Time Deposit
03=Checking Account
05=Stock
06=Bond
07=Life Insurance Value
08=Retirement Account
10=Business Account
11=Trust Fund Account
12=Stock & Bond Account
13=Life Insurance Acct
CA=Current Account
CH=Charges Account
DA=Demand Deposit
LN=Loan
RD=Return Items on DDA
RS=Return Items-Savings
SA=Settlement Account
SV=Savings Account
Z=Mutually Defined
|
| 59 |
ACH_RRC |
Character(3) |
VARCHAR2(3) NOT NULL |
ACH Return Reason Code
|
| 60 |
CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 61 |
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. "
|
| 62 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 63 |
EFT_LAYOUT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
EFT Layout Code
|
| 64 |
REPORT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Recreate Unshipped Report
Default Value: N
|
| 65 |
SAVE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Save Flag
N=Not Saved
Y=Saved
Default Value: N
|
| 66 |
PROCESS_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Process Group
|