SCHD_PYMNT_MT_S

(SQL Table)
Index Back

Schedule Restrictions/Pay Meth

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

Prompt Table: LAYOUT_CD_VW

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

Y/N Table Edit

Default Value: N

7 TAS_BETC_SCH Signed Number(5,0) DECIMAL(4) NOT NULL TAS/BETC Per Schedule
8 TAS_BETC_PYMNT Signed Number(5,0) DECIMAL(4) NOT NULL TAS/BETC Per Payment