| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
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 |
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
Default Value: CHK
Prompt Table:
BNK_RCN_MTHD_VW
|
| 6 |
FORM_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Form Identification
Prompt Table:
%EDITTABLE
|
| 7 |
FORM_ID_MISC |
Character(6) |
VARCHAR2(6) NOT NULL |
Form for Notifications
|
| 8 |
LAST_FORM_NBR_USED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last Ref Number
|
| 9 |
EFT_HDR_COMMENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Header Comment
|
| 10 |
LAST_EFT_FILE_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Last File Number
Default Value: 0000
|
| 11 |
FORM_NBR_CONFIRM |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirm Numbers
Y/N Table Edit
Default Value: N
|
| 12 |
POSITIVE_PAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Positive Payment Flag
Y/N Table Edit
Default Value: N
|
| 13 |
FORM_ID_POS |
Character(6) |
VARCHAR2(6) NOT NULL |
Positive Payment Form
Prompt Table:
%EDITTABLE2
|
| 14 |
FILE_COPY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
File Copy
Y/N Table Edit
Default Value: N
|
| 15 |
FILE_COPY_FORM |
Character(6) |
VARCHAR2(6) NOT NULL |
File Copy Form
Prompt Table:
%EDITTABLE
|
| 16 |
EFT_LAYOUT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
EFT Layout Code
Prompt Table:
%EDITTABLE5
|
| 17 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
Prompt Table:
BANK_DOC_VW1
|
| 18 |
MAN_DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Manual Document Type
Prompt Table:
BANK_DOC_VW2
|
| 19 |
HOL_PROC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Holiday Processing Option
A=Due After Holiday
B=Due Before Holiday
N=Not Applicable
Default Value: N
|
| 20 |
HOL_PROC_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days before/after Holiday
|
| 21 |
HOL_PROC_OVERFL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow due date in next month
Y/N Table Edit
Default Value: N
|
| 22 |
COMPANY_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Company ID - Company Tax ID
|
| 23 |
ORIGINATING_DFI_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Originating DFI ID
|
| 24 |
PAY_SCHEDULE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Schedule
Y/N Table Edit
Default Value: N
|
| 25 |
PRENOTE_DATE |
Date(10) |
DATE |
Prenotification Date
Default Value: %Date
|
| 26 |
PRENOTE_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Prenotification Required
Y/N Table Edit
Default Value: N
|
| 27 |
PRENOTE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Prenotification Status
C=Confirmed
N=New
P=Pending
R=Rejected
S=Submitted
|
| 28 |
VALUE_DT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Value Date
Y/N Table Edit
Default Value: N
|
| 29 |
VALUE_DT_DAYS |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Value Date Days
|
| 30 |
PAYMENT_TIME |
Time(15) |
TIMESTAMP |
Represents the precise time of the day in which settlements will no longer be accepted by a given c
|
| 31 |
STL_THROUGH |
Character(2) |
VARCHAR2(2) NOT NULL |
Settle through
01=Financial Gateway
02=Pay Cycle
Default Value: 02
|
| 32 |
FORMAT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Format ID
Prompt Table:
PMT_FMT_MTHD_VW
|