SCHD_PYMNT_MTHD

(SQL Table)
Index Back

Schedule Restrictions/Pay Meth

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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
2 EFT_LAYOUT_CD Character(10) VARCHAR2(10) NOT NULL EFT Layout Code

Prompt Table: LAYOUT_CD_VW

3 NO_OF_PAYMENTS Number(3,0) SMALLINT NOT NULL Payments Per Schedule
4 GFAP_EFTNOOFAPPROP Number(3,0) SMALLINT NOT NULL Appropriations Per Schedule
5 LIMIT_FLG Character(1) VARCHAR2(1) NOT NULL Apply Restriction

Y/N Table Edit

Default Value: N

6 TAS_BETC_SCH Signed Number(5,0) DECIMAL(4) NOT NULL TAS/BETC Per Schedule
7 TAS_BETC_PYMNT Signed Number(5,0) DECIMAL(4) NOT NULL TAS/BETC Per Payment
8 SAME_DAY_AMT_PYMNT Signed Number(27,2) DECIMAL(25,2) NOT NULL Same Day ACH Amount Per Payment

Default Value: 0