| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
|
| 2 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
Default Value: NEXT
|
| 3 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
Default Value: 1
|
| 4 |
PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 5 |
PYMNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Type
E=Express Payment
M=Manual Payment
R=Regular payment
W=Withholding Payment
Z=Zero Payment Check
|
| 6 |
PAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 7 |
PYMNT_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Payment Amount
|
| 8 |
DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
| 9 |
DSCNT_PAY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Discount Amount
|
| 10 |
DSCNT_DUE_DT |
Date(10) |
DATE |
Discount Due Date
|
| 11 |
SCHEDULED_PAY_DT |
Date(10) |
DATE |
Scheduled to Pay
|
| 12 |
PAID_AMT_GROSS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Paid Amount
|
| 13 |
PAID_AMT_DSCNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount on Paid Amount
|
| 14 |
CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
Prompt Table:
BANK_CURR_AP_VW
|
| 15 |
RVL_DTTM |
DateTime(26) |
TIMESTAMP |
Revaluation DateTime
|
| 16 |
PYMNT_SELCT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Selection Status
C=Closed
D=Negative Voucher Sum
E=Externally Paid
F=Federal Sanctions Error
I=In Process - EFT
N=Not Selected for Payment
O=Financial Sanctions Review
P=Paid
R=Requested for Payment
S=Settlement Payment
V=Convert Error
X=Canceled
Y=Prepaid
Default Value: N
|
| 17 |
REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit SetID
Prompt Table:
REMIT_SETID_VW
|
| 18 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
Prompt Table:
VNDR_RMT_VW
|
| 19 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
VNDR_REM_LOC_VW
|
| 20 |
REMIT_ADDR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Remitting Location
Default Value: VNDR_RMTADD2_VW.REMIT_ADDR_SEQ_NUM
Prompt Table:
VNDR_RMTADD3_VW
|
| 21 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 22 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_CD_VW8
|
| 23 |
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
Prompt Table:
BANK_ACCT_VW11
|
| 24 |
PYMNT_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Action
P=Prepayment Applied
R=Record a Payment
S=Schedule Payment
W=Escheated Payment
X=Cancelled
Default Value: S
|
| 25 |
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
Prompt Table:
BNK_PYMTHD_VW1
|
| 26 |
PYMNT_MESSAGE |
Character(70) |
VARCHAR2(70) NOT NULL |
Payment Message
|
| 27 |
PYMNT_HOLD_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment Hold Code
Prompt Table:
PYMNT_HOLD_CD
|
| 28 |
PYMNT_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Payment
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 29 |
VNDR_PYMNT_HLD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Vendor Payment Hold
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 30 |
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
|
| 31 |
PYMNT_HOLD_WTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
On Withholding Hold
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 32 |
PYMNT_SEPARATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Separate Payment
Y/N Table Edit
Default Value: N
|
| 33 |
BANK_ACCT_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Bank Account Sequence Number
Prompt Table:
RMT_BANK_SEQ_VW
|
| 34 |
PYMNT_HANDLING_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
Prompt Table:
PYMNT_HNDL_TBL
|
| 35 |
REMIT_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit Bank Setid
Prompt Table:
RMT_BANK_SET_VW
|
| 36 |
REMIT_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit Bank Code
Prompt Table:
RMT_BANK_CD_VW
|
| 37 |
REMIT_BNK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
Remit Bank Account
Prompt Table:
RMT_BNK_ACCT_VW
|
| 38 |
PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pay Cycle
|
| 39 |
PAY_CYCLE_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Pay Cycle Sequence Number
|
| 40 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 41 |
EFT_PYMNT_FMT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Format
00=Standard SWIFT transfer
10=Urgent SWIFT
15=Euro-Transfer
21=Check, w/ receipt confirmation
22=Check, Urgent
23=Check, urgent w/ receipt
40=Postal Order
CTX=Corp Trade Exchange
PBC=Check, standard
PPD=Prearranged Pay & Deposit
WRT=Wire Transfer
|
| 42 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
Y/N Table Edit
Default Value: N
|
| 43 |
PAID_AMT_BNK_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount - Base Bank Unit
|
| 44 |
BASE_CURRENCY_BNK |
Character(3) |
VARCHAR2(3) NOT NULL |
The base currency of the subject bank general ledger business unit.
|
| 45 |
CUR_RT_TYPE_BNK |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 46 |
BNK_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange spot rate is stored either as
|
| 47 |
BNK_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange spot rate is store
|
| 48 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 49 |
POST_STATUS_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Status
N=Payment Not Applied
P=Posted
U=Unposted
Default Value: U
|
| 50 |
BUSINESS_UNIT_BANK |
Character(5) |
VARCHAR2(5) NOT NULL |
The general ledger business unit associated with a given bank/counterparty.
|
| 51 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 52 |
HOL_PROC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Holiday Processing Option
A=Due After Holiday
B=Due Before Holiday
N=Not Applicable
Default Value: N
|
| 53 |
HOL_PROC_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days before/after Holiday
|
| 54 |
HOL_PROC_OVERFL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow due date in next month
Y/N Table Edit
Default Value: N
|
| 55 |
LC_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Treasury Letter of Credit Number Assigned by the System
Prompt Table:
LC_HDR_AP_VW
|
| 56 |
ORIG_PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Original Payment Count
|
| 57 |
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. "
|
| 58 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 59 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 60 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 61 |
GROSS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Amount
|
| 62 |
DSCNT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Discount Amount
|
| 63 |
CUR_RT_TYPE_PYMNT |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment Currency Rate Type
|
| 64 |
PYMNT_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange rate is stored
|
| 65 |
PYMNT_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange rate is store
|
| 66 |
PAID_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Paid Amount
|
| 67 |
PAID_AMT_GROSS_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Payment Amount
|
| 68 |
PAID_AMT_DSCNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Discount Paid Amount
|
| 69 |
RVL_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Rate Type
|
| 70 |
RVL_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Revaluation Exchange Rate Mult
|
| 71 |
RVL_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Revaluation Exchange Rate Div
|
| 72 |
RVL_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Revalued Amount
|
| 73 |
RVL_AMT_DSCNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Revalued Discount Amount
|
| 74 |
PREPAID_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Prepaid Status
A=Applied
B=Pending Application
C=Pending Unapply
D=Pending Change
F=Fully Applied
I=Inactive
P=Available Prepayment
R=Restricted
U=Unapplied
X=Cancelled
Default Value: U
|
| 75 |
PREPAID_APPLIED_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Applied Business Unit
|
| 76 |
PREPAID_APPL_VCHR |
Character(8) |
VARCHAR2(8) NOT NULL |
Applied Voucher ID
|
| 77 |
PREPAID_APPL_PYMNT |
Number(5,0) |
INTEGER NOT NULL |
Applied Payment Count
|
| 78 |
WTHD_PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Wthd Payment Count
Default Value: 0
|
| 79 |
POST_STATUS_WTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Withholding Status
N=Not Postable
P=Posted
U=Unposted
X=Cancelled Withholding
Default Value: U
|
| 80 |
WTHD_ADDTL_GROSS |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Additional Withheld Gross Amt
|
| 81 |
GRP_PYMNT_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Group by Payment Date
Y/N Table Edit
Default Value: N
|
| 82 |
SOURCE_TXN |
Character(4) |
VARCHAR2(4) NOT NULL |
Source Transaction
|
| 83 |
PYMNT_GROUP_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Group Code
Prompt Table:
VNDR_PAYGRP_TBL
|
| 84 |
SINGLE_PYMNT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Single Payment
Y/N Table Edit
Default Value: N
|
| 85 |
CUR_RT_TYPE_PAID |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment Rate Type
Prompt Table:
CUR_RT_TYPE_TBL
|
| 86 |
PAID_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored either as
|
| 87 |
PAID_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is store
|
| 88 |
SPEC_PYMNT_EX_RT |
Character(1) |
VARCHAR2(1) NOT NULL |
Specify Pymnt Ex Rate
Y/N Table Edit
Default Value: N
|
| 89 |
APPLIED_PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 90 |
NET_SELCT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Netting Select Status
H=Hold
N=Not Applicable
S=Selected
Default Value: N
|
| 91 |
NET_TXN_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Transaction Status
B=Balance
D=DeSelect - Full
DB=DeSelect Split - Balance
DF=DeSelect - Full
DN=DeSelect Split - Net
N=Net
NA=Not Applicable
S=Split - Net / Balance
Default Value: NA
|
| 92 |
NET_REF_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
A reference identifier associated with a cash transaction subject to netting with a given bank/count
|
| 93 |
DFT_SIGHT_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Draft Sight Code
Prompt Table:
APD_SIGHTCD_TBL
|
| 94 |
DFT_MAT_DT |
Date(10) |
DATE |
Draft Maturity Date
|
| 95 |
DFT_SCHED_MAT_DT |
Date(10) |
DATE |
Draft Scheduled Maturity Date
|
| 96 |
DFT_GROUP_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Draft Group Code
|
| 97 |
DFT_MASTER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Draft Master ID
|
| 98 |
DFT_CREATE_KEY |
Character(10) |
VARCHAR2(10) NOT NULL |
Draft Create Key
|
| 99 |
PYMNT_REASON_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Payment Reason Code
Prompt Table:
XPYM_RSN_US_VW
|
| 100 |
SCHEDULE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule ID
|
| 101 |
LATE_CHRG_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Late Charge Code
Prompt Table:
LATE_CHRG_VW
|
| 102 |
LATE_CHRG_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Late Charge Option
C=Compute Charges
N=Not Applicable
Default Value: N
|
| 103 |
LATE_CHRG_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Amount
|
| 104 |
LATE_CHRG_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Amount Base
|
| 105 |
LATE_CHRG_DNIE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Denied
|
| 106 |
LATE_CHRG_DNIE_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Paid Base
|
| 107 |
LATE_CHRG_PAID |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Paid
|
| 108 |
LATE_CHRG_PAID_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Paid Base
|
| 109 |
ECN_DSCNT_DNIE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount Denied
Y/N Table Edit
Default Value: N
|
| 110 |
VOUCHER_ID_RELATED |
Character(8) |
VARCHAR2(8) NOT NULL |
Related Voucher
|
| 111 |
BUS_UNIT_RELATED |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
|
| 112 |
APPL_CREDIT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Credit Status
A=Applied
N=Not Applicable
P=Pending
Default Value: N
|
| 113 |
PYMNT_APPR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved
D=Denied
N=Approved Status
P=Pending
|
| 114 |
BANK_RPL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Replacement Status
B=Invalid electronic bank setup
C=Bank currency not supported
L=Invalid bank layout
N=Not Replaced
P=Payment method not supported
R=Missing currency convert rates
S=Invalid Set ID
Y=Bank Replaced
Default Value: N
|
| 115 |
PYMNT_CNT_RELATED |
Number(5,0) |
INTEGER NOT NULL |
Payment
|
| 116 |
IPAC_PYMNT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
IPAC Payment flag - will indicate that a payment is for IPAC
Y/N Table Edit
Default Value: N
|
| 117 |
EFT_LAYOUT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
EFT Layout Code
Prompt Table:
AP_BNKLYT_VW
|
| 118 |
STL_THROUGH |
Character(2) |
VARCHAR2(2) NOT NULL |
Settle through
01=Financial Gateway
02=Pay Cycle
|