| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
|
| 2 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 3 |
BANK_CD_CPTY |
Character(5) |
VARCHAR2(5) NOT NULL |
An internal key field convention that facilitates the system distinction between banks and counterparties.
|
| 4 |
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
|
| 5 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 6 |
ACCT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Status - Active/Inactive
A=Active
I=Inactive
Default Value: A
|
| 7 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 8 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 9 |
BRANCH_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Branch Name
Prompt Table:
BANK_BRANCH_VW2
|
| 10 |
PYMNT_HANDLING_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
Prompt Table:
%EDITTABLE4
|
| 11 |
PYMNT_OVRD_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Handling Override Amt
|
| 12 |
RECON_TYPE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates which method has been utilized to reconcile a given source system transaction.
A=Automatic
M=Manual
N=None
S=Semi Manual
|
| 13 |
RECON_HEADER |
Character(1) |
VARCHAR2(1) NOT NULL |
An internal work field that indicates that the account balance has been submitted with the bank statement.
Y/N Table Edit
Default Value: N
|
| 14 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 15 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
RT_TYPE_TBL
|
| 16 |
RATE_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
Rate index
Prompt Table:
RT_INDEX_FX_VW
|
| 17 |
SETTLEMENT_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc
Prompt Table:
STL_INSTRUCT_VW
|
| 18 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 19 |
LAST_PYMNT_ID_USED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last Payment Id
|
| 20 |
PYMNT_ID_REF_LEN |
Number(3,0) |
SMALLINT NOT NULL |
Check # Length
Default Value: 6
|
| 21 |
FRACT_RTG_NUM |
Character(20) |
VARCHAR2(20) NOT NULL |
Federal Reserve bank routing number used for funds transfer.
|
| 22 |
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
|
| 23 |
DFI_ID_QUAL |
Character(2) |
VARCHAR2(2) NOT NULL |
A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
01=Transit Number
02=Swift ID/BIC
03=CHIPS Participant ID
04=Canadian Bank Branch/Institute
05=CHIPS Universal ID
ZZ=Mutually Defined
|
| 24 |
NPL_BNK_CHRT_VALUE |
Character(15) |
VARCHAR2(15) NOT NULL |
Bank Chartfield Value
Prompt Table:
%EDITTABLE6
|
| 25 |
IU_PYBL_NPL_ACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
InterFund Payable Nonpooled
Prompt Table:
GL_ACCT_BUGL_VW
|
| 26 |
IU_RCVBL_NPL_ACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
InterFund Receivable Nonpooled
Prompt Table:
GL_ACCT_BUGL_VW
|
| 27 |
CSH_PL_CLRG_ACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Cash Pooled Clearing Account
Prompt Table:
GL_ACCT_BUGL_VW
|
| 28 |
CSH_PL_ACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Cash Pooled Account
Prompt Table:
GL_ACCT_BUGL_VW
|
| 29 |
PL_BNK_ACCT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pooled Bank Account
Y/N Table Edit
Default Value: N
|
| 30 |
AR |
Character(1) |
VARCHAR2(1) NOT NULL |
Receivables
Y/N Table Edit
Default Value: N
|
| 31 |
AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Payables
Y/N Table Edit
Default Value: N
|
| 32 |
TR |
Character(1) |
VARCHAR2(1) NOT NULL |
Treasury
Y/N Table Edit
Default Value: N
|
| 33 |
BI |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing
Y/N Table Edit
Default Value: N
|
| 34 |
EX |
Character(1) |
VARCHAR2(1) NOT NULL |
Expenses
Y/N Table Edit
Default Value: N
|
| 35 |
GP |
Character(1) |
VARCHAR2(1) NOT NULL |
Global Payroll Source
Y/N Table Edit
Default Value: N
|
| 36 |
PP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Predictor
Y/N Table Edit
Default Value: N
|
| 37 |
RCN_ACCTG_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to indicate that the subject bank account's eligible transactions will generate ac
Y/N Table Edit
Default Value: N
|
| 38 |
ENABLE_WF_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows a user to enable workflow worklist processing for automated reconciliation purposes. Th
F=Nofitication Framework
N=No Workflow
Y=Workflow
Default Value: F
|
| 39 |
DEPOSIT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Deposit Type
A=Amount
B=Balance of Net Pay
P=Percent
Prompt Table:
%EDITTABLE2
|
| 40 |
FORECAST |
Character(1) |
VARCHAR2(1) NOT NULL |
Include in Cash Forecast
Y/N Table Edit
Default Value: N
|
| 41 |
TARGET_BALANCE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The target bank account balance assigned to a given bank account.
|
| 42 |
PRE_RECONCILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to indicate whether the automated reconciliation process should apply a n
Y/N Table Edit
Default Value: N
|
| 43 |
CASH_CNTL_USE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cash Clearing
Y/N Table Edit
Default Value: N
|
| 44 |
DRAFT_CNTL_USE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Drafts Payable
Y/N Table Edit
Default Value: N
|
| 45 |
DRAFT_CNTL_AR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
AR Draft Cash Control
Y/N Table Edit
Default Value: N
|
| 46 |
DIT_USE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Deposit in Transit field for JFMIP functionality
Y/N Table Edit
Default Value: N
|
| 47 |
CHECK_DIGIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Check Digit
|
| 48 |
INT_BASIS |
Character(2) |
VARCHAR2(2) NOT NULL |
Day Count Basis
30=30/360
3E=30E/360
A0=Actual/360
A5=Actual/365
AA=Actual/Actual
|
| 49 |
MARGIN_PTS |
Number(4,0) |
SMALLINT NOT NULL |
Margin (Pts)
|
| 50 |
CREATION_DT |
Date(10) |
DATE |
Creation Date
Default Value: %date
|
| 51 |
OPRID_ENTERED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Entered By
07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase.
03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!!
FYI - The alternatives to use a User ID as uppercase:
1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID
2) Use %Upper meta-SQL in SQL statements
3) Use Upper function in peoplecodes
|
| 52 |
OPRID_LAST_UPDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Last User to Update
|
| 53 |
DEPOSIT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
Prompt Table:
SP_BUARBK_NONVW
|
| 54 |
DEBIT_RATE |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Represents the debit-specific interest rate applicable to an internal current account.
|
| 55 |
CREDIT_RATE |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Represents the credit-specific interest rate applicable to an internal current account.
|
| 56 |
BANK_ACCT_QUAL |
Character(1) |
VARCHAR2(1) NOT NULL |
"An account attribute that determines
C=Corporate Account
Default Value: C
|
| 57 |
PREFERRED_LANGUAGE |
Character(3) |
VARCHAR2(3) NOT NULL |
Preferred Language
ARA=Arabic
CFR=Canadian French
CZE=Czech
DAN=Danish
DUT=Dutch
E=English
ENG=English
ESP=Spanish
F=French
FIN=Finnish
FRA=French
GER=German
HUN=Hungarian
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
NOR=Norwegian
POL=Polish
POR=Portuguese
RUS=Russian
SVE=Swedish
THA=Thai
UKE=UK English
ZHS=Simplified Chinese
ZHT=Traditional Chinese
|
| 58 |
PAYER_ID_NUM |
Character(10) |
VARCHAR2(10) NOT NULL |
Remitter ID Number
|
| 59 |
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
Default Value: 03
|
| 60 |
DEFAULT_ACCT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to designate a specific internal current account as the default account for an inter
|
| 61 |
CHRG_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Charge Bank
Prompt Table:
BNK_CD_CORP_VW
|
| 62 |
CHRG_BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
Charge Account
Prompt Table:
BNK_ACT_CHRG_VW
|
| 63 |
CREDIT_RT_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
Credit Rate Index
Prompt Table:
RT_INDEX_TBL
|
| 64 |
CREDIT_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Credit Rate Type
Prompt Table:
RT_TYPE_TBL
|
| 65 |
CREDIT_MARGIN_PTS |
Signed Number(13,8) |
DECIMAL(11,8) NOT NULL |
Credit Margin Point
|
| 66 |
DEBIT_RT_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
Debit Rate Index
Prompt Table:
RT_INDEX_TBL
|
| 67 |
DEBIT_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Debit Rate Type
Prompt Table:
RT_TYPE_TBL
|
| 68 |
DEBIT_MARGIN_PTS |
Signed Number(13,8) |
DECIMAL(11,8) NOT NULL |
Debit Margin Point
|
| 69 |
SCHEDULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule ID
|
| 70 |
POOL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Pool ID field.
Prompt Table:
BANK_POOL_VW3
|
| 71 |
INTEREST_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrue Interest
|
| 72 |
BCH_CHRG_PAYEE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
TRF Charge by Vendor
Y/N Table Edit
Default Value: N
|
| 73 |
IBAN_CHECK_DIGIT |
Character(2) |
VARCHAR2(2) NOT NULL |
IBAN Check Digit
|
| 74 |
RFC_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Regional Financial Center
|
| 75 |
PYCYCL_PAY_LIMIT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a direct debit in its entry currency (DD_CURRENCY). This field is maintained by the Direct debit generation process.
|
| 76 |
PYCYCL_PAY_LMTCURR |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
BANK_ACCT_CURR
|
| 77 |
SINGLE_PAY_LIMIT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a direct debit in its entry currency (DD_CURRENCY). This field is maintained by the Direct debit generation process.
|
| 78 |
SINGLE_PAY_LMTCURR |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
BANK_ACCT_CURR
|
| 79 |
IPAC_SENDER_DO |
Character(5) |
VARCHAR2(5) NOT NULL |
Sender Disbursing Office
|
| 80 |
BNK_RCN_CONTROL |
Character(1) |
VARCHAR2(1) NOT NULL |
Enforce or lift edits when unreconciling
Y/N Table Edit
Default Value: Y
|
| 81 |
BNK_STMT_CONTROL |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to lift or enforce Bank Statement edits
Y/N Table Edit
Default Value: Y
|
| 82 |
IBAN_ID |
Character(34) |
VARCHAR2(34) NOT NULL |
IBAN - Internation Bank Account Number is used in European countries to uniquely identify Bank accounts across borders
|