| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BU_SEL_OPTIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Business Unit Options
A=All Business Units
B=Specify Business Unit
|
| 3 |
PYMNT_PROCESSS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Paid/ unpaid vouchers
A=Paid and UnPaid
U=Unpaid
|
| 4 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 6 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 7 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
| 8 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 9 |
EFT_LAYOUT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
EFT Layout Code
|
| 10 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 11 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 12 |
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
|
| 13 |
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
|
| 14 |
ALC |
Character(8) |
VARCHAR2(8) NOT NULL |
Agency Location Code
|
| 15 |
GWA_REPORTER_CATG |
Character(2) |
VARCHAR2(2) NOT NULL |
GWA Reporter Category identifies the transactions (IPAC, TDO Payments and CASHLINK) that are being reported with the GWA standard classification. This field was added to support the Federal GWA modernization project.
00=Non Reporter
01=IPAC Only
02=AR Only
03=AP Payments Only
04=IPAC and AR
05=IPAC and AP Payments
06=AP Payments and AR
07=IPAC, AR and AP Pymts
|
| 16 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 17 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 18 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
|
| 19 |
SPS_TAS |
Character(27) |
VARCHAR2(27) NOT NULL |
Sender Treasury Account Symbol
|
| 20 |
SPS_BETC |
Character(8) |
VARCHAR2(8) NOT NULL |
Sender Business Event Type
|
| 21 |
SPS_BETC_ADJ |
Character(8) |
VARCHAR2(8) NOT NULL |
Sender Business Event Type
|
| 22 |
MERCHANDISE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
|
| 23 |
GROSS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Amount
|
| 24 |
PYMNT_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Payment Amount
|
| 25 |
GROSS_AMT_WRK |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Invoice Amount
|
| 26 |
TOTAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Amount
|
| 27 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 28 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 29 |
CF_ATTRIB_VALUE |
Character(20) |
VARCHAR2(20) NOT NULL |
ChartField Attribute Value
|
| 30 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 31 |
REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit SetID
|
| 32 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
| 33 |
REMIT_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit to Location
|
| 34 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 35 |
COUNTER1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Counter 1
|
| 36 |
COUNTER2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 2
|
| 37 |
COUNTER3 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 3
|
| 38 |
COUNTER4 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 4
|
| 39 |
TEMP_FLD1S |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 40 |
TEMP_FLD2S |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 41 |
LINE_VCHR_PCT |
Signed Number(29,20) |
DECIMAL(27,20) NOT NULL |
Line Voucher Ratio
|
| 42 |
FIELDNAME_FC |
Character(18) |
VARCHAR2(18) NOT NULL |
Fieldname for Fund Code.
|
| 43 |
AP_FUND_PROMPT1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Fund Code Prompt
|