VNFILE: VENDOR FILE

ElementElement NameTable or FileSQL or Focus
VN003VENDOR KEYVNFILEVENDOR_KEY
VN004VENDOR NUMBERVNFILEVENDOR_NUM
VN005VENDOR DIGIT 1VNFILEVENDOR_DIGIT_1
VN006VENDOR DIGITS 2-10VNFILEVENDOR_DIGITS_2_10
VN007VENDOR DIGITS 2-11VNFILEVENDOR_DIGITS_2_11
VN008STD ADDR ID REDFVNFILESTD_ADDR_ID
VN010VN SEGMENT NUMBERVNFILESEGMENT_NUM
VN020DROP FLAGVNFILEDROP_FLAG
VN022DELETE FLAGVNFILEDELETE_FLAG
VN024FREEZE FLAGVNFILEFREEZE_FLAG
VN026CHECK IN-PROCESSVNFILECHECK_IN_PROC_IND
VN028VN NOTES FLAGVNFILENOTES_FLAG
VN030VENDOR NAMEVNFILEVENDOR_NAME
VN031Z VENDOR NAMEVNFILEVENDOR_NAME
VN032ADDRESS LINE 1VNFILEADDR_LINE_1
VN034ADDRESS LINE 2VNFILEADDR_LINE_2
VN036ADDRESS LINE 3VNFILEADDR_LINE_3
VN038ADDRESS LINE 4VNFILEADDR_LINE_4
VN040CITYVNFILECITY
VN042STATEVNFILESTATE
VN044COUNTRYVNFILECOUNTRY
VN046ZIP CODEVNFILEZIP
VN047ZIP CODE 5VNFILEZIP_5
VN048ZIP CODE 4VNFILEZIP_4
VN049ZIP CODE 3VNFILEZIP_3
VN050VN PHONE AREA CODEVNFILEPHONE_AREA_CODE
VN051VN PHONE (7)VNFILEPHONE_NUMBER
VN052VN PHONE FIRST 3VNFILEPHONE_EXCHANGE
VN053VN PHONE LAST 4VNFILEPHONE_NUMBER_4
VN054VN PHONE EXTVNFILEPHONE_EXTENSION
VN055VN FAX NUMBER AREAVNFILEFAX_AREA_CODE
VN056VN FAX NUMBER (7)VNFILEFAX_NUMBER
VN057VN FAX NUMBER FIRSTVNFILEFAX_EXCHANGE
VN058VN FAX NUMBER LAST 4VNFILEFAX_NUMBER_4
VN059VN CONTACT NAMEVNFILECONTACT_NAME
VN060VN EMAILVNFILEEMAIL
VN061VN FEDERAL/TAX IDVNFILETAX_ID
VN062VN 1099/1042 CODEVNFILECODE_1099
VN063VN AP HOLDVNFILEHOLD_FLAG
VN064VN AP DOLLAR LIMITVNFILELIMIT_CODE
VN066VENDOR TYPE CODEVNFILEVENDOR_TYPE
VN068VN DISCOUNT CODEVNFILEDISC_CODE
VN070VN COMMODITY CODEVNFILEMAJOR_COMMODITY
VN074VN CURRENCY CODEVNFILECURRENCY_CODE
VN076VN RETENTION MTHSVNFILERETENTION_MONTHS
VN078VN PAY SCHEDULEVNFILEPAYMENT_SCHEDULE
VN080VN PAY DISC DUE DAYSVNFILEDISC_DUE_DAYS
VN082VN PAY DISC PERCENTVNFILEDISC_PERCENT
VN084VN PAY INDICATORVNFILETERMS_IND
VN086VN PAY DAYSVNFILENET_DUE_DAYS
VN087VN PAY OVR DISC DAYSVNFILEOVRD_DISC_DUE_DAYS
VN088VN PAY OVR DISC PRCTVNFILEOVRD_DISC_PERCENT
VN090VN PAY OVR INDICVNFILEOVRD_TERMS_IND
VN092VN PAY OVR DAYSVNFILEOVRD_NET_DUE_DAYS
VN094VN ORD FROM ADDR1VNFILEADDR_2_LINE_1
VN095STD DELIV TO ADDR1VNFILEADDR_2_LINE_1
VN096VN ORD FROM ADDR2VNFILEADDR_2_LINE_2
VN097STD DELIV TO ADDR2VNFILEADDR_2_LINE_2
VN098VN ORD FROM ADDR3VNFILEADDR_2_LINE_3
VN099STD DELIV TO ADDR3VNFILEADDR_2_LINE_3
VN100VN ORD FROM ADDR4VNFILEADDR_2_LINE_4
VN101STD DELIV TO ADDR4VNFILEADDR_2_LINE_4
VN102VN ORD FROM CITYVNFILECITY_2
VN103VN ORD FROM STATEVNFILESTATE_2
VN104VN ORD FROM COUNTRYVNFILECOUNTRY_2
VN106VN ORD FROM ZIPVNFILEZIP_2
VN107ORD ZIP CODE 1-5VNFILEZIP2_1_5
VN108ORD ZIP CODE 6-9VNFILEZIP2_6_9
VN109ORD ZIP CODE 10-12VNFILEZIP2_10_12
VN110VN ORD PHONE AREA CDVNFILEPHONE_2_AREA_CODE
VN111VN ORD PHONE (7)VNFILEPHONE_2_NUMBER
VN112VN ORD PHONE FIRST 3VNFILEPHONE_2_EXCHANGE
VN113VN ORD PHONE LAST 4VNFILEPHONE_2_NUMBER_4
VN114VN ORD PHONE EXTVNFILEPHONE_2_EXTENSION
VN115VN ORD FAX NUM AREAVNFILEFAX_2_AREA_CODE
VN116VN ORD FAX NUM(7)VNFILEFAX_2_NUMBER
VN117VN ORD FAX NUM FRSTVNFILEFAX_2_EXCHANGE
VN118VN ORD FAX NUM LST 4VNFILEFAX_2_NUMBER_4
VN119VN ORD CONT NAMEVNFILECONTACT_NAME_2
VN120VN ORD EMAILVNFILEEMAIL_2
VN121VN ESTAB DATEVNFILECREATE_DT
VN122VN ESTAB DATE-6VNFILECREATE_DT_6
VN123VN LAST ACTIVE DATEVNFILEDT_LAST_ACTV
VN124VN LAST ACTIVE DT-6VNFILEDT_LAST_ACTV_6
VN125VN LAST BANK NUMBERVNFILELAST_BANK_NUM
VN126VN LAST CHECK NUMBERVNFILELAST_CHECK_NUM
VN128VN LAST CHECK DATEVNFILELAST_CHECK_DT
VN129VN LAST CHECK DT-6VNFILELAST_CHECK_DT_6
VN130VN LAST INVOICE NUMBVNFILELAST_INVOICE_NUM
VN132VN LAST PO NUMBERVNFILELAST_NUM
VN134VN YTD PAID AMTVNFILEYTD_PAID_AMT
VN136VN PRI YTD PAID AMTVNFILEPRIOR_YTD_PAID_AMT
VN138VN TOTAL FREIGHTVNFILETOTAL_FREIGHT
VN140VN TOTAL INSURANCEVNFILETOTAL_INSURANCE
VN142VN TOTAL TAXVNFILETOTAL_TAX
VN144VN TOTAL OTHERVNFILETOTAL_OTHER
VN148VN CM PO AMOUNTVNFILECM_TOTAL
VN150VN YTD PO AMOUNTVNFILEYTD_TOTAL
VN152VN PRIOR YR PO AMTVNFILEPRIOR_YTD_TOTAL
VN154VN NUM OF PO IN CMVNFILECM_COUNT
VN156VN NUM OF PO YTDVNFILEYTD_COUNT
VN158VN NUM PO PRIOR YRVNFILEPRIOR_YTD_COUNT
VN160VN PO FREIGHTVNFILEFREIGHT_CODE
VN161VN CAMPUS CODEVNFILECAMPUS_CODE
VN162VN TIN NOTICE INDVNFILETAX_ID_NOTICE_IND
VN163VN TIN NOTICE YRVNFILETAX_ID_NOTICE_YR
VN165VN CUSTOMER NUMBERVNFILECUSTOMER_NUMBER
VN167VN W9 FILE INDVNFILEW9_FILE_IND
VN168VN W9 DATEVNFILEW9_DATE
VN169VN W9 DATE-6VNFILEW9_DATE_6
VN171VN EDI TRADE PARTVNFILEEDI_TRADE_PART
VN172VN EDI INFO CHNGVNFILEEDI_INFO_CHNG
VN173VN EDI INV MTHDVNFILEEDI_INV_MTHD
VN176VN EFT BANK ACCTVNFILEEFT_BANK_ACCT
VN177VN EFT BANK ROUTVNFILEEFT_BANK_ROUT
VN180VN USER CODE 1VNFILEUSER_CODE_1
VN181VN USER CODE 2VNFILEUSER_CODE_2
VN182VN USER CODE 3VNFILEUSER_CODE_3
VN184CREATE/CHG OPER IDVNFILECREATE_CHG_OPER_ID
VN185VN DATE LAST CHNGVNFILEDATE_LAST_CHNG
VN186VN DATE LAST CHNG-6VNFILEDATE_LAST_CHNG_6
VN187EDI EFT PARTNERVNFILEEDI_EFT_PARTNER
VN188EDI INV PARTNERVNFILEEDI_INV_PARTNER
VN189REMIT ADVICE FLAGVNFILEREMIT_ADVICE_FLAG
VN201VN SMALL BUS INDICVNFILEVN_SMALL_BUS_INDIC
VN202VN DISADVANTAGED INDVNFILEVN_DISADVANTAGED_I
VN203VN FEMALE OWNED INDVNFILEVN_FEMALE_OWNED_IN
VN204VN BLACK OWNED INDICVNFILEVN_BLACK_OWNED_IND
VN205VN HISPANIC OWNED INVNFILEVN_HISPANIC_OWNED_
VN206VN NAT AMER OWNED INVNFILEVN_NAT_AMER_OWNED_
VN207VN ASIAN-AMER BUS INVNFILEVN_ASIAN_AMER_BUS_
VN208VN VETERAN BUS INDICVNFILEVN_VETERAN_BUS_IND
VN209VN VIET VET BUS INDVNFILEVN_VIET_VET_BUS_IN
VN210VN INDIV BUS INDICVNFILEVN_INDIV_BUS_INDIC
VN211VN TYPE 11 BUS INDICVNFILEVN_TYPE_11_BUS_IND
VN212VN TYPE 12 BUS INDICVNFILEVN_TYPE_12_BUS_IND
VN213VN TYPE 13 BUS INDICVNFILEVN_TYPE_13_BUS_IND
VN214VN TYPE 14 BUS INDICVNFILEVN_TYPE_14_BUS_IND
VN215VN TYPE 15 BUS INDICVNFILEVN_TYPE_15_BUS_IND
VN502VN CONTROL REC KEYVNFILEVENDOR_CONTROL_KEY
VN512CNTRL VCHR GROSSVNFILEGROSS_AMT
VN514CNTRL VCHR DISCVNFILEDISC_AMT
VN516CNTRL CM PAIDVNFILECM_PAID
VN518CNTRL YTD PAIDVNFILEYTD_PAID
VN520CNTRL LAST CHECKVNFILELAST_CHECK_NUM
VN522CNTRL DUMMY CHECKVNFILEDUMMY_CHECK_NUM

©2000 All Rights Reserved