VNDR_PAY_EFFVW(SQL View) |
Index Back |
---|---|
Supplier Payment Defaults View |
SELECT %subrec(VENDOR_PAY_SBR, a) FROM PS_VENDOR_PAY a WHERE a.effdt = ( SELECT MAX(i.effdt) FROM PS_VENDOR_PAY i WHERE i.setid = a.setid AND i.vendor_id = a.vendor_id AND i.vndr_loc = a.vndr_loc AND i.seq_num = a.seq_num AND i.effdt <= %CurrentDateIn) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
2 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
3 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
4 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
5 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL |
Sequence
Default Value: 1 |
6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: USD Prompt Table: CURRENCY_CD_TBL |
8 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table: RT_TYPE_TBL |
9 | 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 |
10 | PYMNT_HOLD | Character(1) | VARCHAR2(1) NOT NULL |
Hold Payment
N=No Y=Yes Y/N Table Edit Default Value: N |
11 | PYMNT_GROUP_CD | Character(2) | VARCHAR2(2) NOT NULL |
Pay Group Code
Prompt Table: VNDR_PAYGRP_TBL |
12 | PYMNT_SEPARATE | Character(1) | VARCHAR2(1) NOT NULL |
Separate Payment
Y/N Table Edit Default Value: N |
13 | PYMNT_HANDLING_CD | Character(2) | VARCHAR2(2) NOT NULL |
Payment Handling
Prompt Table: PYMNT_HNDL_TBL |
14 | DSCNT_ALWAYS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Always take discount
Y/N Table Edit Default Value: N |
15 | DELAY_DAYS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Delay Days Flag
D=Default from BU N=Do Not Employ S=Specify Default Value: D |
16 | DSCNT_DELAY_DAYS | Signed Number(5,0) | DECIMAL(4) NOT NULL | Discount Delay Days |
17 | PYMNT_DELAY_DAYS | Signed Number(5,0) | DECIMAL(4) NOT NULL | Payment Delay Days |
18 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BNK_CD_CORP_VW |
19 | 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
Prompt Table: BNK_ACT_CORP_VW |
20 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL |
Payment Currency
Prompt Table: BANK_CURR_AP_VW |
21 | CUR_RT_TYPE_PYMNT | Character(5) | VARCHAR2(5) NOT NULL | Payment Currency Rate Type |
22 | EFT_PYMNT_FMT_CD | Character(3) | VARCHAR2(3) NOT NULL |
Payment Format
00=Standard SWIFT transfer 10=Urgent SWIFT 15=Euro-Transfer 21=Check, w/ receipt confirmation 22=Check, Urgent 23=Check, urgent w/ receipt 40=Postal Order CTX=Corp Trade Exchange PBC=Check, standard PPD=Prearranged Pay & Deposit WRT=Wire Transfer |
23 | EFT_RTNG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Complex Routing
D=Use DFI ID N=None R=Use Complex Routing Default Value: D |
24 | EFT_RTNG_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Routing Status
C=Complete I=Incomplete Default Value: I |
25 | EFT_TRANS_HANDLING | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Handling
D=Payment Only P=Prenotification X=Payment and Advice Default Value: X |
26 | PRENOTE_DATE | Date(10) | DATE | Prenotification Date |
27 | PRENOTE_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Prenotification Required
Y/N Table Edit Default Value: N |
28 | PRENOTE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Prenotification Status
C=Confirmed N=New P=Pending R=Rejected S=Submitted |
29 | EFT_DOM_COSTS_CD | Character(1) | VARCHAR2(1) NOT NULL |
Domestic Costs
1=Payer's Domestic Account 2=Payer's Foreign Account 3=Payee's Account 4=Trans Exp to Pyr, other to Pye |
30 | EFT_CORR_COSTS_CD | Character(1) | VARCHAR2(1) NOT NULL |
Correspondent's Costs
1=Payer's Domestic Account 2=Payer's Foreign Account 3=Payee's Account |
31 | EFT_CROSSED_CHECK | Character(1) | VARCHAR2(1) NOT NULL |
Crossed Check
Y/N Table Edit Default Value: N |
32 | EFT_CHECK_FWRD_CD | Character(1) | VARCHAR2(1) NOT NULL |
Check Forwarding
1=Payer's Bank 2=Payer 3=Payee 4=Payee's Bank |
33 | EFT_CHECK_DRAW_CD | Character(1) | VARCHAR2(1) NOT NULL |
Bank Check Drawn On
1=Payer's Bank 2=Payee's Bank |
34 | EFT_PAY_INST_CD1 | Character(3) | VARCHAR2(3) NOT NULL |
Payment Instruction 1
ACC=/ACC/ BEN=/BENONLY/ CHK=/CHECK/ COR=/CORPTRAD/ HLD=/HOLD/ INT=/INT/ IRR=PAYMENT IRREVOCABLE PHB=/PHONEBEN/ PHI=/PHONIBK/ PHN=/PHON/ RC1=ADV BEN W/CHARGES RC2=ADV BEN W/O CHARGES RCB=/RCB/ REC=/REC/ REJ=/REJT/ RET=BEN UNKNOWN RETURN TEB=/TELEBEN/ TEI=/TELEIBK/ TEL=/TELE/ XFR=INTERCOMPANY TRANSFER Prompt Table: EFT_PAY_INST_VW |
35 | EFT_PAY_INST_CD2 | Character(3) | VARCHAR2(3) NOT NULL |
Payment Instruction 2
Prompt Table: EFT_PAY_INST_VW |
36 | EFT_PAY_INST_CD3 | Character(3) | VARCHAR2(3) NOT NULL |
Payment Instruction 3
Prompt Table: EFT_PAY_INST_VW |
37 | EFT_PAY_INST_CD4 | Character(3) | VARCHAR2(3) NOT NULL |
Payment Instruction 4
Prompt Table: EFT_PAY_INST_VW |
38 | EFT_PAY_INST_REF1 | Character(40) | VARCHAR2(40) NOT NULL | Payment Instruction Ref 1 |
39 | EFT_PAY_INST_REF2 | Character(40) | VARCHAR2(40) NOT NULL | Payment Instruction Ref 2 |
40 | FACTORING_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Factoring
Y/N Table Edit Default Value: N |
41 | HOL_PROC_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Holiday Processing Option
A=Due After Holiday B=Due Before Holiday N=Not Applicable |
42 | HOL_PROC_DAYS | Number(3,0) | SMALLINT NOT NULL | Days before/after Holiday |
43 | HOL_PROC_OVERFL | Character(1) | VARCHAR2(1) NOT NULL |
Allow due date in next month
Y/N Table Edit Default Value: N |
44 | DFT_VNDR_PARAMS | Character(1) | VARCHAR2(1) NOT NULL |
Draft Vendor Parameters
Y/N Table Edit Default Value: N |
45 | DFT_OPT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Draft Optimization
D=Use Pay Cycle Default N=Do Not Use S=Specify Default Value: N |
46 | DFT_MAX_NUM | Number(2,0) | SMALLINT NOT NULL | Max Number of Drafts |
47 | DFT_ROUND_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Draft Rounding
D=Use Pay Cycle Default N=Do Not Use S=Specify Default Value: N |
48 | DFT_AMT_POS | Number(2,0) | SMALLINT NOT NULL | Rounding Position |
49 | DFT_REMAIN_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Remaining Amount Action
A=Alternate Pay Mthd N=Do not issue Draft Default Value: N |
50 | PYMNT_METHOD_ALT | Character(3) | VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House CHK=System Check DD=Direct Debit EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check WIR=Wire Report |
51 | GRP_PYMNT_DT | Character(1) | VARCHAR2(1) NOT NULL |
Group by Payment Date
Y/N Table Edit Default Value: N |
52 | APPLY_NETTING | Character(1) | VARCHAR2(1) NOT NULL |
Apply Netting
Y/N Table Edit Default Value: N |
53 | DFT_SIGHT_CD | Character(5) | VARCHAR2(5) NOT NULL |
Draft Sight Code
Prompt Table: APD_SIGHTCD_TBL |
54 | BCH_TRNCOST_CD | Character(1) | VARCHAR2(1) NOT NULL |
Transfer Cost Code
1=Payer 2=Payee Default Value: 1 |
55 | BCH_CALC_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Bank Charge source
T=Table U=User Specified |
56 | BCH_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency CD
Prompt Table: CURRENCY_CD_TBL |
57 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
58 | SMT_SPLIT_ID | Character(5) | VARCHAR2(5) NOT NULL |
Payment Split ID
Prompt Table: SMT_SPLIT_HD_VW |
59 | SMT_SPLIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Payment Split
Y/N Table Edit Default Value: N |