| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
DUMMY_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy Field for Hiding Groups
|
| 5 |
FROM_PYMNT_DT |
Date(10) |
DATE |
To Payment Date
|
| 6 |
TO_PYMNT_DT |
Date(10) |
DATE |
To Payment Date
|
| 7 |
DATE_INC_SIZE |
Number(3,0) |
SMALLINT NOT NULL |
Date Increment Size
|
| 8 |
DATE_INC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Increment Type
D=Day(s)
M=Month(s)
W=Week(s)
|
| 9 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 10 |
RESET_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reset Flag
|
| 11 |
SCHEDULE_TYPE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedulepaymentflag
|
| 12 |
BUSINESS_UNIT_TRX |
Character(5) |
VARCHAR2(5) NOT NULL |
The Business Unit for a Treasury Deal (table TRX_HEADER_TR)
|
| 13 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 14 |
PAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 15 |
PAID_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Paid Amount
|
| 16 |
MERCHANDISE_AMT_VC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Voucher Merchandise Amount
|
| 17 |
MERCH_AMT_VC_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Voucher Merchandise Amount
|
| 18 |
MERCHANDISE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
|
| 19 |
MERCH_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Merchandise Amount
|
| 20 |
ADJUSTMENT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Adjustment Amount
|
| 21 |
ADJUSTMENT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Adjustment Amount (base)
|
| 22 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
| 23 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 24 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 25 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 26 |
NAME1_VNDR |
Character(40) |
VARCHAR2(40) NOT NULL |
Vendor Name
|
| 27 |
NAME2_VNDR |
Character(40) |
VARCHAR2(40) NOT NULL |
Vendor Name
|
| 28 |
STD_ID_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
ID Number
|
| 29 |
STD_ID_NUM_QUAL |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard ID Number
|
| 30 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 31 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 32 |
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
|
| 33 |
PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 34 |
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
|
| 35 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
|
| 36 |
SPS_TAS |
Character(27) |
VARCHAR2(27) NOT NULL |
Sender Treasury Account Symbol
|
| 37 |
SPS_BETC |
Character(8) |
VARCHAR2(8) NOT NULL |
Sender Business Event Type
|
| 38 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 39 |
SETID_FUND |
Character(5) |
VARCHAR2(5) NOT NULL |
Setid for Fund
|
| 40 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 41 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 42 |
SUB_LEVEL_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Sub level prefix code
|
| 43 |
ALLO_TR_AGENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Allocation Transfer Agency Identifier
|
| 44 |
AGENCY_ID1 |
Character(3) |
VARCHAR2(3) NOT NULL |
TAS agency id
|
| 45 |
BEGIN_PERIOD_AVAIL |
Character(4) |
VARCHAR2(4) NOT NULL |
Beginning Period of Availability (BPOA)
|
| 46 |
END_PERIOD_AVAIL |
Character(4) |
VARCHAR2(4) NOT NULL |
Ending Period of Availability (EPOA)
|
| 47 |
AVAIL_TYPE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Availability Type Code
A=Treasury cental smmry account
C=Cancelled
F=Clearing/suspense account
M=Merged surplus account
X=No-year account
|
| 48 |
MAIN_ACCOUNT |
Character(4) |
VARCHAR2(4) NOT NULL |
Main Account TAS
|
| 49 |
SUB_ACCOUNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Sub Account TAS
|
| 50 |
MONETARY_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
|
| 51 |
SELECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
EI Repos: Selection
Y/N Table Edit
|
| 52 |
PMNT_OR_CANC_DT |
Date(10) |
DATE |
Payment or Cancel Date
|
| 53 |
PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pay Cycle
|
| 54 |
PYMNT_ID_REF |
Character(20) |
VARCHAR2(20) NOT NULL |
Payment Reference
|
| 55 |
PIR_CLASSIFICATION |
Character(2) |
VARCHAR2(2) NOT NULL |
PIR Classification
BA=Adjustment
BC=Check
BI=International
BN=ACH/EFT
BW=Wire
|
| 56 |
USF_PIR_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
PIR Input System Name
|
| 57 |
PIR_VERSION_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
PIR Version ID
|
| 58 |
PIR_AGENCY_NAME |
Character(4) |
VARCHAR2(4) NOT NULL |
PIR Agency Name
|
| 59 |
PIR_SCHD_NUM |
Character(14) |
VARCHAR2(14) NOT NULL |
PIR Schedule Number
|
| 60 |
PIR_SUMM_NUM |
Character(6) |
VARCHAR2(6) NOT NULL |
PIR Schedule Number
|
| 61 |
PIR_SUMM_DT |
Date(10) |
DATE |
PIR Summary Date
|
| 62 |
PIR_PAYMENT_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
PIR Payment ID
|
| 63 |
PIR_VOUCHER_FRM_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
PIR Voucher Form Code
215=Adjustment
5515=Payment
|
| 64 |
HOLD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold
N=Hold
Y=Hold
|
| 65 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
|
| 66 |
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
|
| 67 |
PYMNT_DT |
Date(10) |
DATE |
Payment Date
|
| 68 |
CANCEL_DT |
Date(10) |
DATE |
Date Cancelled
|
| 69 |
PYMNT_HANDLING_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
|
| 70 |
TAS_BETC_SCH |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
TAS/BETC Per Schedule
|
| 71 |
TAS_BETC_PYMNT |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
TAS/BETC Per Payment
|
| 72 |
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
|
| 73 |
RECV_DFI_ID_NUM |
Character(12) |
VARCHAR2(12) NOT NULL |
Receiving DFI ID Number
|
| 74 |
ALC |
Character(8) |
VARCHAR2(8) NOT NULL |
Agency Location Code
|
| 75 |
IPAC_SENDER_DO |
Character(5) |
VARCHAR2(5) NOT NULL |
Sender Disbursing Office
|
| 76 |
CREATION_DT |
Date(10) |
DATE |
Creation Date
|
| 77 |
TREASURY_PMT_NBR |
Number(11,0) |
DECIMAL(11) NOT NULL |
Payment Confirm Number
|
| 78 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 79 |
SCHEDULE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule ID
|
| 80 |
PAID_AMT_GROSS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Paid Amount
|
| 81 |
PAID_AMT_GROSS_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Payment Amount
|
| 82 |
PAID_AMT_DSCNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount on Paid Amount
|
| 83 |
PAID_AMT_DSCNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Discount Paid Amount
|
| 84 |
LATE_CHRG_PAID |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Paid
|
| 85 |
LATE_CHRG_PAID_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Paid Base
|
| 86 |
PYMNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Amount
|
| 87 |
TOTAL_PAY_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Payment Amount - Base
|
| 88 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 89 |
NAME2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 2
|
| 90 |
REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit SetID
|
| 91 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
| 92 |
VENDOR_NAME_SHORT |
Character(14) |
VARCHAR2(14) NOT NULL |
Short Vendor Name
|
| 93 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 94 |
PIR_PMT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
PIR Payment Type
MISC=Miscellaneous
TRVL=Travel
VNDR=Vendor
|
| 95 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 96 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 97 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 98 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 99 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 100 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 101 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 102 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 103 |
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
|
| 104 |
ACH_RRC |
Character(3) |
VARCHAR2(3) NOT NULL |
ACH Return Reason Code
|
| 105 |
CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 106 |
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. "
|
| 107 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 108 |
EFT_LAYOUT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
EFT Layout Code
|
| 109 |
REPORT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Recreate Unshipped Report
Default Value: N
|
| 110 |
SAVE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Save Flag
N=Not Saved
Y=Saved
Default Value: N
|
| 111 |
PROCESS_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Process Group
|
| 112 |
ADJUSTMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment
|
| 113 |
COUNTER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
|
| 114 |
BETC_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Business Event Type Code
|
| 115 |
EXCEPTION_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Exception Type
DOET=Discount Overage > Tolerance
DOIT=Discount Overage <= Tolerance
DUET=Discount Underage > Tolerance
DUIT=Discount Underage <= Tolerance
IOET=Invoice Overage > Tolerance
IOIT=Invoice Overage <= Tolerance
IUET=Invoice Underage > Tolerance
IUIT=Invoice Underage <= Tolerance
|