PeopleSoft 9
Account Payables

Table Name VENDOR_PAY

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

Published June 06, 2007