| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
PROCESS_INSTANCE2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 3 |
ACH_LAYOUT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
ACH Layout Code
|
| 4 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 5 |
BANK_ACCT_ENCRYPT |
Character(250) |
VARCHAR2(250) NOT NULL |
Stores Encrypted BankAccount Value
|
| 6 |
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
|
| 7 |
BANK_ACCT_MASK |
Character(35) |
VARCHAR2(35) NOT NULL |
Account Number
|
| 8 |
BANK_ACCT_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Bank Account Sequence Number
|
| 9 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 10 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 11 |
BATCH_SEQ_NUM |
Number(15,0) |
DECIMAL(15) NOT NULL |
Batch Number
|
| 12 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
|
| 13 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 14 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 15 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 16 |
EFT_LAYOUT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
EFT Layout Code
|
| 17 |
FILE_NAME_SHORT |
Character(30) |
VARCHAR2(30) NOT NULL |
File Name
|
| 18 |
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
|
| 19 |
IBAN_ID_MASK |
Character(34) |
VARCHAR2(34) NOT NULL |
International Bank Account Num
|
| 20 |
IBAN_ID1 |
Character(34) |
VARCHAR2(34) NOT NULL |
IBAN - Internation Bank Account Number is used in European countries to uniquely identify Bank accounts across borders
|
| 21 |
IBAN_ID_ENCRYPT |
Character(250) |
VARCHAR2(250) NOT NULL |
Encrypt IBAN
|
| 22 |
PARTY_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Payee ID
|
| 23 |
PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pay Cycle
|
| 24 |
PAY_CYCLE_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Pay Cycle Sequence Number
|
| 25 |
PAYMENT_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
|
| 26 |
PYMNT_DT |
Date(10) |
DATE |
Payment Date
|
| 27 |
PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 28 |
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
|
| 29 |
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
|
| 30 |
REMIT_BANK_ACCOUNT |
Character(35) |
VARCHAR2(35) NOT NULL |
Bank Account Number
|
| 31 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
| 32 |
SCHEDULE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule ID
|
| 33 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 34 |
SRF_SRC_IS_BC |
Character(1) |
VARCHAR2(1) NOT NULL |
PIR SRF source is BC
N=No
Y=Yes
|
| 35 |
VCHR_BLD_KEY_C1 |
Character(25) |
VARCHAR2(25) NOT NULL |
Voucher Build Key Char 1
|
| 36 |
VCHR_BLD_KEY_C2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Voucher Build Key Char 1
|
| 37 |
VCHR_BLD_KEY_N1 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Voucher Build Key Num 1
|
| 38 |
VCHR_BLD_KEY_N2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Vchr Build Key Num 2
|
| 39 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 40 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 41 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 42 |
WS_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Worksheet ID
|
| 43 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 44 |
DEFAULT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Election
N=No
Y=Yes
|
| 45 |
PROFILE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Profile Selected
N=Un-Check
Y=Check
|
| 46 |
MICR_LINE |
Character(50) |
VARCHAR2(50) NOT NULL |
MICR Line
|
| 47 |
USF_UEID |
Character(12) |
VARCHAR2(12) NOT NULL |
Unique Entity Identifier
|
| 48 |
USF_EFT_IND |
Character(4) |
VARCHAR2(4) NOT NULL |
Entity EFT Indicator
|
| 49 |
DUNS_NUMBER |
Character(9) |
VARCHAR2(9) NOT NULL |
DUNS Number
|
| 50 |
USF_DUNS_PLUS4 |
Character(4) |
VARCHAR2(4) NOT NULL |
DUNS Suffix
|
| 51 |
USF_BANK_ACCT_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
Bank Account Nbr
|
| 52 |
IDX_VAL_KEY |
Number(30,0) |
DECIMAL(30) NOT NULL |
AutoGenerated Index Value key
|
| 53 |
ORIG_VALUE |
Character(254) |
VARCHAR2(254) NOT NULL |
Original Value
|
| 54 |
CHGD_VALUE |
Character(254) |
VARCHAR2(254) NOT NULL |
Changed Value
|
| 55 |
DATETIME_STAMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
|
| 56 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 57 |
BANK_ACCOUNT_NUM1 |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given internal partner bank/counterparty acco
|
| 58 |
BANK_ACCOUNT_NUM2 |
Character(35) |
VARCHAR2(35) NOT NULL |
Bank Account Number
|
| 59 |
ENCRYPT_PRFL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Encryption Profile ID
|
| 60 |
DECRYPT_PRFL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Decryption Profile ID
|