PeopleSoft 9
Account Payables

Table Name VENDOR_LOC

Table Description
VENDOR_LOC
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 No
EFF_STATUS VARCHAR(1) No No
CURRENCY_CD VARCHAR(3) No Yes
CUR_RT_TYPE VARCHAR(5) No No
FREIGHT_TERMS VARCHAR(10) No Yes
SHIP_TYPE_ID VARCHAR(10) No Yes
DISP_METHOD VARCHAR(3) No No
PYMNT_TERMS_CD VARCHAR(5) No Yes
MATCH_OPT_FLG VARCHAR(1) No No
MATCH_CNTRL_ID VARCHAR(10) No Yes
MATCH_OPT VARCHAR(1) No No
ERS_ACTION VARCHAR(1) No No
ERS_FLAG VARCHAR(1) No No
VCHR_APPRVL_FLG VARCHAR(1) No No
BUSPROCNAME VARCHAR(30) No No
APPR_RULE_SET VARCHAR(30) No No
BUYER_ID VARCHAR(30) No No
REMIT_SETID VARCHAR(5) No No
REMIT_VENDOR VARCHAR(10) No No
REMIT_LOC VARCHAR(10) No No
REMIT_ADDR_SEQ_NUM INT No No
ADDR_SEQ_NUM_ORDR INT No No
PRICE_SETID VARCHAR(5) No No
PRICE_VENDOR VARCHAR(10) No No
PRICE_LOC VARCHAR(10) No No
RETURN_VENDOR VARCHAR(10) No No
RET_ADDR_SEQ_NUM INT No No
DST_CNTRL_ID VARCHAR(10) No Yes
PREFERRED_LANGUAGE VARCHAR(3) No No
RFQ_DISP_MTHD VARCHAR(3) No No
CNTRCT_DISP_MTHD VARCHAR(3) No No
PRIMARY_VENDOR VARCHAR(10) No No
PRIM_ADDR_SEQ_NUM INT No No
SHIPTO_ID VARCHAR(10) No Yes
SUT_BASE_ID VARCHAR(10) No No
SALETX_TOL_AMT decimal(26,3) No No
SALETX_TOL_CUR_CD VARCHAR(3) No No
SALETX_TOL_PCT decimal(5,2) No No
SALETX_TOL_RT_TYPE VARCHAR(5) No No
SALETX_CD_ERS VARCHAR(8) No No
SALES_USE_TX_FLG VARCHAR(1) No No
AUTO_ASN_FLG VARCHAR(1) No No
SALETX_TOL_FLG VARCHAR(1) No No
SHIP_LOC_FLG VARCHAR(1) No No
WTHD_CD VARCHAR(5) No Yes
WTHD_SW VARCHAR(1) No No
DOC_TYPE VARCHAR(8) No Yes
DOC_TYPE_FLG VARCHAR(1) No No
RTV_DISPATCH_METH VARCHAR(3) No No
RTV_NOTIFY_METH VARCHAR(3) No No
RTV_DEBIT_OPT VARCHAR(1) No No
VNDR_SBI_FLG VARCHAR(1) No No
SBI_APPROVAL_FLG VARCHAR(1) No No
ACCOUNT VARCHAR(10) No No
ALTACCT VARCHAR(10) No No
DEPTID VARCHAR(10) No No
OPERATING_UNIT VARCHAR(8) No No
PRODUCT VARCHAR(6) No No
FUND_CODE VARCHAR(5) No No
CLASS_FLD VARCHAR(5) No No
PROGRAM_CODE VARCHAR(5) No No
BUDGET_REF VARCHAR(8) No No
AFFILIATE VARCHAR(5) No No
AFFILIATE_INTRA1 VARCHAR(10) No No
AFFILIATE_INTRA2 VARCHAR(10) No No
CHARTFIELD1 VARCHAR(10) No No
CHARTFIELD2 VARCHAR(10) No No
CHARTFIELD3 VARCHAR(10) No No
PROJECT_ID VARCHAR(15) No No
CONSIGNED_FLAG VARCHAR(1) No No
VCHR_CONSIGN_OPT VARCHAR(1) No No
BANK_ACCT_SEQ_NBR SMALLINT No No
ACCT_TEMPL_FLG VARCHAR(1) No No
PAY_TRM_BSE_DT_DFT VARCHAR(1) No No
RECV_ONLY_MTCH_FLG VARCHAR(1) No No
VCHR_MTCH_ADJ_DFLT VARCHAR(1) No No
ERS_INV_DT_OPT VARCHAR(1) No No
ERS_INV_DT_DFLT VARCHAR(1) No No
ERS_TAX_TYPE_DFLT VARCHAR(1) No No
ERS_TAX_CD_OPT VARCHAR(1) No No
LAST_SBI_NUM decimal(10) No No
SBI_DOC_DFLT VARCHAR(1) No No
SBI_PRINT_OPT VARCHAR(1) No No
VCHR_TAX_ADJ_DFT VARCHAR(1) No No
RTV_VCHR_ADJ_DFLT VARCHAR(1) No No
VAT_SUSPENSION_FLG VARCHAR(1) No No
VAT_ROUND_RULE VARCHAR(1) No No
REPL_DISP_METHOD VARCHAR(3) No No
VNDR_UPN_FLG VARCHAR(1) No No
DISP_CO_FLAG VARCHAR(1) No No
DATE_CALC_BASIS VARCHAR(1) No No
PAY_SCHEDULE_TYPE VARCHAR(3) No No
FEDERAL_INDICATOR VARCHAR(1) No No
TRADING_PARTNER VARCHAR(6) No No
ALC VARCHAR(8) No No
WORKFLOW_OPT VARCHAR(1) No No
PHYSICAL_NATURE VARCHAR(1) No No
VAT_SVC_PERFRM_FLG VARCHAR(1) No No
ULTIMATE_USE_CD VARCHAR(8) No No
ADDR_SEQ_NUM_SHFR INT No No
POA_REQUIRED VARCHAR(1) No No
ACK_ALERT_DISP SMALLINT No No
ACK_ALERT_SHIP SMALLINT No No
POA_CO_REQUIRED VARCHAR(1) No No
POA_TOL_FLAG VARCHAR(1) No No
POA_SCHED_EARLY SMALLINT No No
POA_SCHED_LATE SMALLINT No No
POA_QTY_OVER SMALLINT No No
POA_QTY_UNDER SMALLINT No No
POA_PRICE_OVER SMALLINT No No
POA_PRICE_UNDER SMALLINT No No
CC_ACCEPT_CC VARCHAR(1) No No
CC_DISP_OPTION VARCHAR(1) No No
CC_ALLOW_OVERRIDE VARCHAR(1) No No
CC_SECURITY_ID DECIMAL(10) No No
CC_USE_FLAG VARCHAR(1) No No
MATCH_DELAY_FLG VARCHAR(1) No No
MATCH_DELAY_DAYS SMALLINT No No
COMMENTS_2000 CLOB No No
Index
Name Type Unique Member
PS_VENDOR_LOC PK Yes
PSAVENDOR_LOC IE1 No
Member(s) of "PS_VENDOR_LOC" Index
SETID
VENDOR_ID
VNDR_LOC
EFFDT
Member(s) of "PSAVENDOR_LOC" Index
SETID
VENDOR_ID
EFFDT

Published June 06, 2007