| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
CURTEMPINSTANCE |
Number(4,0) |
SMALLINT NOT NULL |
Temp Table Instance
|
| 3 |
DFT_MASTER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Draft Master ID
|
| 4 |
DFT_CREATE_KEY |
Character(10) |
VARCHAR2(10) NOT NULL |
Draft Create Key
|
| 5 |
SOURCE_TXN |
Character(4) |
VARCHAR2(4) NOT NULL |
Source Transaction
|
| 6 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 7 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 8 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 9 |
PAY_DOC_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Advice ID
|
| 10 |
PAY_DOC_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Advice Sequence
|
| 11 |
AE_DO_WHEN |
Character(1) |
VARCHAR2(1) NOT NULL |
When
|
| 12 |
SQLROWS |
Number(5,0) |
INTEGER NOT NULL |
SQL Rows
|
| 13 |
PYMNT_CNT_MAX |
Number(5,0) |
INTEGER NOT NULL |
Max payment count
|
| 14 |
PYMNT_CNT_TOTAL |
Number(5,0) |
INTEGER NOT NULL |
Total Payment Count
|
| 15 |
DESCR100 |
Character(100) |
VARCHAR2(100) NOT NULL |
Length 100 Description
|
| 16 |
PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pay Cycle
|
| 17 |
PAY_CYCLE_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Pay Cycle Sequence Number
|
| 18 |
DFT_XREF_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Used during Pay Cycle
A=Amount Modified
N=New
U=Unchanged
|
| 19 |
DFT_XREF_INCL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used during Pay Cycle to include or exclude Drafts from Pay Cycle based after Draft rounding
E=Xref Excluded
I=Xref Included
Default Value: I
|
| 20 |
PAID_AMT_NEW |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 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_METHOD_ALT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House
CHK=System Check
DD=Direct Debit
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
WIR=Wire Report
|
| 23 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 24 |
CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 25 |
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. "
|
| 26 |
PYMNT_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Payment Amount
|
| 27 |
DSCNT_PAY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Discount Amount
|
| 28 |
GROSS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Amount
|
| 29 |
DSCNT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Discount Amount
|
| 30 |
PAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 31 |
PAID_AMT_GROSS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Paid Amount
|
| 32 |
PAID_AMT_DSCNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount on Paid Amount
|
| 33 |
PAID_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Paid Amount
|
| 34 |
PAID_AMT_GROSS_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Payment Amount
|
| 35 |
PAID_AMT_DSCNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Discount Paid Amount
|
| 36 |
AMT11 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 11
|
| 37 |
AMT12 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 12
|
| 38 |
AMT13 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 13
|
| 39 |
AMT14 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 14
|
| 40 |
AMT15 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 15
|
| 41 |
AMT16 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 16
|
| 42 |
AMT17 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 17
|
| 43 |
AMT18 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 18
|
| 44 |
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
|
| 45 |
PYMNT_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Payment
N=No
Y=Yes
|