PeopleSoft 9.0
Cash Management

Table Name VENDOR_PAY

Table Description
VENDOR_PAY
Columns
Name Datatype Is PK Is FK
SETID CHAR(5) Yes No
VENDOR_ID CHAR(10) Yes No
VNDR_LOC CHAR(10) Yes No
EFFDT PSDATE Yes No
SEQ_NUM SMALLINT Yes No
EFF_STATUS CHAR(1) No No
CURRENCY_CD CHAR(3) No No
CUR_RT_TYPE CHAR(5) No No
PYMNT_METHOD CHAR(3) No No
PYMNT_HOLD CHAR(1) No No
PYMNT_GROUP_CD CHAR(2) No No
PYMNT_SEPARATE CHAR(1) No No
PYMNT_HANDLING_CD CHAR(2) No No
DSCNT_ALWAYS_FLG CHAR(1) No No
DELAY_DAYS_FLG CHAR(1) No No
DSCNT_DELAY_DAYS SMALLINT No No
PYMNT_DELAY_DAYS SMALLINT No No
BANK_CD CHAR(5) No No
BANK_ACCT_KEY CHAR(4) No No
CURRENCY_PYMNT CHAR(3) No No
CUR_RT_TYPE_PYMNT CHAR(5) No No
EFT_PYMNT_FMT_CD CHAR(3) No No
EFT_RTNG_FLG CHAR(1) No No
EFT_RTNG_STATUS CHAR(1) No No
EFT_TRANS_HANDLING CHAR(1) No No
PRENOTE_DATE PSDATE No No
PRENOTE_REQD CHAR(1) No No
PRENOTE_STATUS CHAR(1) No No
EFT_DOM_COSTS_CD CHAR(1) No No
EFT_CORR_COSTS_CD CHAR(1) No No
EFT_CROSSED_CHECK CHAR(1) No No
EFT_CHECK_FWRD_CD CHAR(1) No No
EFT_CHECK_DRAW_CD CHAR(1) No No
EFT_PAY_INST_CD1 CHAR(3) No No
EFT_PAY_INST_CD2 CHAR(3) No No
EFT_PAY_INST_CD3 CHAR(3) No No
EFT_PAY_INST_CD4 CHAR(3) No No
EFT_PAY_INST_REF1 CHAR(40) No No
EFT_PAY_INST_REF2 CHAR(40) No No
FACTORING_FLG CHAR(1) No No
HOL_PROC_OPT CHAR(1) No No
HOL_PROC_DAYS SMALLINT No No
HOL_PROC_OVERFL CHAR(1) No No
DFT_VNDR_PARAMS CHAR(1) No No
DFT_OPT_FLG CHAR(1) No No
DFT_MAX_NUM SMALLINT No No
DFT_ROUND_FLG CHAR(1) No No
DFT_AMT_POS SMALLINT No No
DFT_REMAIN_OPT CHAR(1) No No
PYMNT_METHOD_ALT CHAR(3) No No
GRP_PYMNT_DT CHAR(1) No No
APPLY_NETTING CHAR(1) No No
DFT_SIGHT_CD CHAR(5) No No
BCH_TRNCOST_CD CHAR(1) No No
BCH_CALC_SRC CHAR(1) No No
BCH_CURRENCY_CD CHAR(3) No No
AMOUNT DECIMAL(26,3) No No
SMT_SPLIT_ID CHAR(5) No No
SMT_SPLIT_FLG CHAR(1) No No
VNDR_PYMNT_HLD_FLG CHAR(1) No No
PYMNT_HOLD_OPT CHAR(4) No No
PYMNT_HLD_DT_OPT CHAR(1) No No
PYMNT_HOLD_CD CHAR(5) No No
PYMN_HOLD_FRM_DT PSDATE No No
PYMN_HOLD_TO_DT PSDATE No No
PYMNT_HOLD_PCT DECIMAL(8,3) No No
PYMNT_HOLD_COMMENT CHAR(254) No No
PYMNT_HOLD_AMT DECIMAL(15,2) No No
HOLD_INV_MAX_AMT DECIMAL(15,2) No No
LATE_CHRG_FLG CHAR(1) No No
LATE_CHRG_OPT CHAR(1) No No
LATE_CHRG_CD CHAR(4) No No
APPL_CREDIT_DFLT CHAR(1) No No
GFAP_EFTDEPACCTNUM CHAR(13) No No
GFAP_EFT_TIN_CODE CHAR(1) No No
GFAP_EFT_TREASURY CHAR(1) No No
GFAP_EFT_BBK_NAME CHAR(51) No No
GFAP_EFT_BBK_REM CHAR(76) No No
GFAP_EFT_BBKABANUM CHAR(9) No No
GFAP_EFT_BNF_CODE CHAR(47) No No
GFAP_EFT_ENCL_CODE CHAR(1) No No
GFAP_EFT_LTD_PAY CHAR(1) No No
GFAP_EFT_PROD_CODE CHAR(4) No No
GFAP_EFT_RFB_INFO CHAR(16) No No
GFAP_EFT_TYPE_CODE CHAR(2) No No
GFAP_EFTTOP_ELGBL CHAR(1) No No
ENTITY_ID_CODE CHAR(3) No No
REF_ID_QUAL CHAR(3) No No
REF_ID CHAR(30) No No
RECV_ID_QUAL CHAR(2) No No
RECV_ID CHAR(80) No No
CONTACT_NAME CHAR(50) No No
COMM_QUAL CHAR(2) No No
COMM_NUM CHAR(80) No No
POLICY_TYPE CHAR(3) No No
POLICY_NUM CHAR(30) No No
EFT_LAYOUT_CD CHAR(10) No No
ALLOW_DEBIT_MEMO CHAR(1) No No
PYMNT_TERMS_CD CHAR(5) No No
USE_VCHR_DATES CHAR(1) No No
INV_ID_SUFFIX CHAR(2) No No
DBMEMO_PYMNT_HOLD CHAR(1) No No
PYMNT_HOLD_REASON CHAR(3) No No
PYMNT_MESSAGE CHAR(70) No No
DBMEMO_DISP_METHOD CHAR(3) No No
DBMEMO_ADDR_OPTION CHAR(1) No No
ADDRESS_SEQ_NUM INT No No
CNTCT_SEQ_NUM INT No No
Index
Name Type Unique Member
PS_VENDOR_PAY PK Yes
Member(s) of "PS_VENDOR_PAY" Index
SETID
VENDOR_ID
VNDR_LOC
EFFDT
SEQ_NUM

Published April 30, 2007