| # |
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 |
SOURCE_TXN |
Character(4) |
VARCHAR2(4) NOT NULL |
Source Transaction
|
| 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 |
PAY_DOC_DT |
Date(10) |
DATE |
Advice Date
|
| 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_DUE_DT |
Date(10) |
DATE |
Discount Due Date
|
| 10 |
SCHEDULED_PAY_DT |
Date(10) |
DATE |
Scheduled to Pay
|
| 11 |
PYMNT_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Payment Amount
|
| 12 |
GROSS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Amount
|
| 13 |
DSCNT_PAY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Discount Amount
|
| 14 |
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
|
| 15 |
PYMNT_MESSAGE |
Character(70) |
VARCHAR2(70) NOT NULL |
Payment Message
|
| 16 |
PYMNT_SEPARATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Separate Payment
|
| 17 |
PYMNT_HANDLING_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
|
| 18 |
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. "
|
| 19 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 20 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 21 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 22 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 23 |
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
|
| 24 |
LATE_CHRG_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Late Charge Code
|
| 25 |
LATE_CHRG_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Amount
|
| 26 |
LATE_CHRG_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Amount Base
|
| 27 |
LATE_CHRG_PAID |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Paid
|
| 28 |
LATE_CHRG_PAID_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Paid Base
|
| 29 |
LATE_CHRG_DNIE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Denied
|
| 30 |
LATE_CHRG_DNIE_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Paid Base
|
| 31 |
SIMPLE_INTR_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Simple Interest Days
|
| 32 |
SIMPLE_DAYS |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Simple Days
|
| 33 |
COMPOUND_DAYS |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Compound Days
|
| 34 |
COMPOUND_INTR_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Compound Interest Days
|
| 35 |
DAYS_IN_YEAR |
Number(3,0) |
SMALLINT NOT NULL |
Days in Year
|
| 36 |
INTEREST_RATE |
Number(9,5) |
DECIMAL(8,5) NOT NULL |
Interest Rate
|
| 37 |
INTEREST_RATE1 |
Number(9,5) |
DECIMAL(8,5) NOT NULL |
Annual Interest
|
| 38 |
SIMPLE_INTR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Simple Interest Amount
|
| 39 |
COMPOUND_INTR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Compound Interest Amount
|
| 40 |
NO_PAY_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
No Pay Days
|
| 41 |
NO_OF_MONTHS |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Number of Months
|
| 42 |
DAYS_OUTSTANDING |
Number(4,0) |
SMALLINT NOT NULL |
Days Outstanding
|