FILENAME: D9530F25 MASTER
DESCRIPTION: FRSV3.0 VENDOR MFD
FIELDNAME ALIAS FORMAT DESCRIPTION FIELDTYPE
VN004_VNRT VENDOR_NUM
A11
VENDOR NUMBER
I
VN_DGT1 VN005
A1
VENDOR DIGIT
VN_DGT2_11 VN007
A10
VENDOR DIGIT 2-11
VN_DGT2_10 VN006 A09 VENDOR DIGIT 2-10
VN_DGT11 A01 VENDOR DIGIT 11
VN020 DROP_FLAG
A1
DROP FLAG
VN022 DELETE_FLAG
A1
DELETE FLAG
VN024 FREEZE_FLAG
A1
FREEZE FLAG
VN026 CHECK_IN_PROC_IND
A1
CHECK IN PROC IND
VN028 NOTES_FLAG
A1
NOTES FLAG
VN083 ORIGIN
A1
ORIGIN IND
VN161 CAMPUS_CODE
A2
CAMPUS CODE
VN030 VENDOR_NAME
A30
VENDOR NAME
VN032 ADDR_LINE_1
A30
REMIT ADDRESS 1
VN034 ADDR_LINE_2
A30
REMIT ADDRESS 2
VN036 ADDR_LINE_3
A30
REMIT ADDRESS 3
VN038 ADDR_LINE_4
A30
REMIT ADDRESS 4
VN040 CITY
A20
REMIT CITY
VN042 STATE
A2
REMIT STATE
VN044 COUNTRY
A3
REMIT COUNTRY
VN046 ZIP
A12
REMIT ZIP
VN047 ZIP_CODE1_5
A5
REMIT ZIP CODE 1_5
VN048 ZIP_CODE6_9 A3
REMIT ZIP CODE 6_9
VN049 ZIP_CODE10_12
A3
REMIT ZIP CODE 10_12
PHONE PHONE
A15
PHONE
AREA_CD
VN050
A3
AREA CODE
PH_PRE
VN051A
A3
PHONE PRE
PH_SUF
VN053
A4
PHONE SUF

PHON_EXT

VN054

A5

PHONE EXT

VN059

CONTACT_NAME

A30

CONTACT NAME

VN060
EMAIL_ADDR A40 EMAIL ADDR
VN061
TAX_ID A9 TAX ID
VN062 CODE_1099 A1 CODE 1099
VN063 HOLD_FLAG A1 HOLD FLAG
VN064 LIMIT_CODE I6 LIMIT CODE
VN066 (use VN19B) VENDOR_TYPE A2 VENDOR TYPE
VN068 DISC_CODE A2 DISC CODE
VN070 MAJOR_COMMODITY A3 MAJOR COMMODITY
VN074 CURRENCY_CODE A3 CURRENCY CODE
VN076 RETENTION_MONTHS A2 RETENTION MONTHS
VN078 PAYMENT_SCHEDULE A1 PAYMENT SCHEDULE
VN080 DISC_DUE_DAYS I6 DISC DUE DAYS
VN082 DISC_PERCENT D6.3 DISC PERCENT
VN084 TERMS_IND A1 TERMS IND
VN086 NET_DUE_DAYS I6 NET DUE DAYS
VN087 OVRD_DISC_DUE_DAYS I6 OVRD DISC DUE DAYS
VN088 OVRD_DISC_PERCENT D6.3 OVRD DISC PERCENT
VN090 OVRD_TERMS_IND A1 OVRD TERMS IND
VN092 OVRD_NET_DUE_DAYS I6 OVRD NET DUE DAYS
VN094 ORDER_ADDR_LINE_1 A30 ORDER ADDRESS 1
VN096 ORDER_ADDR_LINE_2 A30 ORDER ADDRESS 2
VN098 ORDER_ADDR_LINE_3 A30 ORDER ADDRESS 3
VN100 ORDER_ADDR_LINE_4 A30 ORDER ADDRESS 4
VN102 ORDER_CITY A20 ORDER CITY
VN103 ORDER_STATE A2 ORDER STATE
VN104 ORDER_COUNTRY A3 ORDER COUNTRY
VN106 ORDER_ZIP A12 ORDER ZIP
VN107 ORD_ZIP_CODE1_5 A5 ORDER ZIP CODE 1_5
VN108 ORD_ZIP_CODE6_9 A3 ORDER ZIP CODE6_9
VN109 ORD_ZIP_CODE10_12 A3 ORDER ZIP CODE10_12
ORDER PHONE ORDER_PHONE A15 ORDER PHONE
ORD_AREA_CD VN110 A3 ORDER AREA CODE
ORD_PH_PRE VN111A A3 ORDER PHONE PRE
ORD_PH_SUF VN113 A4 ORDER PHONE SUF
ORD_PHON_EXT VN114 A5 ORDER PHONE EXT
VN116 ORDER_FAX A10 ORDER FAX
VN119 ORDER_CONTACT_NAME A30 ORDER CONTACT NAME
VN120 ORDER_EMAIL_ADDR A40 ORDER EMAIL
VN121 CREATE_DT YYMD CREATE DT
VN123 DT_OF_LAST_ACTV YYMD DT OF LAST ACTV
VN125 LAST_BANK_NUM A2 LAST BANK NUM
VN126 LAST_CHECK_NUM A6 LAST CHECK NUM
VN128 LAST_CHECK_DT YYMD LAST CHECK DT
VN130 LAST_INVOICE_NUM A14 LAST INVOICE NUM
VN132 LAST_PO_NUM A7 LAST PO NUM
VN134 YTD_PAID_AMT D14.2M YTD PAID AMT
VN136 PRIOR_YTD_PAID_AMT D14.2M PRIOR YTD PAID AMT
VN138 TOTAL_FREIGHT D12.2M TOTAL FREIGHT
VN140 TOTAL_INSURANCE D12.2M TOTAL INSURANCE
VN142 TOTAL_TAX D12.2M TOTAL TAX
VN144 TOTAL_OTHER D12.2M TOTAL OTHER
VN148 CM_PO_TOTAL D14.2M CM PO TOTAL
VN150 YTD_PO_TOTAL D14.2M YTD PO TOTAL
VN152 PRIOR_YTD_PO_TOTAL D14.2M PRIOR YTD PO TOTAL
VN154 CM_PO_COUNT I6 CM PO COUNT
VN156 YTD_PO_COUNT I9 YTD PO COUNT
VN158 PRIOR_YTD_PO_COUNT I9 PRIOR YTD PO COUNT
VN160 PO_FREIGHT_CODE A2 PO FREIGHT CODE
VN162 TAX_ID_NOTICE_IND A1 TAX ID NOTICE IND
VN163 TAX_ID_NOTICE_YR A4 TAX ID NOTICE YR
VN055 FAX_NUM A10 FAX NUM
VN165 CUSTOMER_NUMBER A15 CUSTOMER NUMBER
VN167 W9_ON_FILE_IND A1 W9 ON FILE IND
VN168 W9_DATE YYMD W9 DATE
VN171 EDI_TRADE_PARTNER A1 EDI TRADE PART
VN172 EDI_INFO_CHANGED A1 EDI INFO CHG
VN173 EDI_INV_MTHD A3 EDI INV MTHD
VN176 EFT_BANK_ACCOUNT A17 EDI BANK ACCT
VN177 EFT_BANK_ROUTING A9 EDI BANK ROUT
VN180 USER_CODE_1 A2 USER CODE1
VN181 USER_CODE_2 A2 USER CODE2
VN182 USER_CODE_3 A2 USER CODE3
VN184 LAST_CHG_ID A6 LAST CHG ID
VN185 LAST_CHG_DT YYMD LAST CHG DATE
VN19A UC_STATE_FEIN_SUFF A2 UC STATE FEIN SUFF
VN19B VENDOR_TYPE A3 VENDOR TYPE  

 

 

508 UsableNet Approved (v. 1.2.1)