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 |