Field
Name: |
Type: |
Length: |
Index: |
Description: |
V_SEQ |
sequence |
|
x |
|
V_NUM |
char |
10 |
x |
|
V_ORG |
char |
50 |
x |
|
V_NOTE1 |
char |
50 |
|
|
V_STREET |
char |
50 |
|
|
V_CITY |
char |
50 |
|
|
V_NOTE2 |
char |
50 |
|
|
V_ZIP |
char |
50 |
|
|
V_CONTACT |
char |
50 |
|
|
V_PHONE |
char |
20 |
|
|
V_YTD |
number |
2dp |
|
|
V_MARKUP |
number |
2dp |
|
|
V_NOTE3 |
char |
55 |
|
|
V_TASK |
char |
4 |
|
|
V_TYPE |
char |
20 |
|
|
V_OPEN |
boolean |
|
|
|
V_ALLOCATE |
boolean |
|
|
|
V_TAX_ID |
char |
15 |
|
|
V_ACCT_NUM |
char |
10 |
|
|
V_CURRN |
number |
2dp |
|
|
V_30DAY |
number |
2dp |
|
|
V_60DAY |
number |
2dp |
|
|
V_90DAY |
number |
2dp |
|
|
V_BALN |
number |
2dp |
|
|
V_LAST_AP |
short date |
1980..2079 |
|
|
V_ADDED_BY |
char |
3 |
|
|
V_ADDED_WHEN |
short date |
1980..2079 |
|
|
V_TIME |
date |
|
|
|
V_1 |
number |
2dp |
|
|
V_2 |
number |
2dp |
|
|
V_3 |
number |
2dp |
|
|
V_4 |
number |
2dp |
|
|
V_5 |
number |
2dp |
|
|
V_6 |
number |
2dp |
|
|
V_7 |
number |
2dp |
|
|
V_8 |
number |
2dp |
|
|
V_9 |
number |
2dp |
|
|
V_10 |
number |
2dp |
|
|
V_11 |
number |
2dp |
|
|
V_12 |
number |
2dp |
|
|
V_L1 |
number |
2dp |
|
|
V_L2 |
number |
2dp |
|
|
V_L3 |
number |
2dp |
|
|
V_L4 |
number |
2dp |
|
|
V_L5 |
number |
2dp |
|
|
V_L6 |
number |
2dp |
|
|
V_L7 |
number |
2dp |
|
|
V_L8 |
number |
2dp |
|
|
V_L9 |
number |
2dp |
|
|
V_L10 |
number |
2dp |
|
|
V_L11 |
number |
2dp |
|
|
V_L12 |
number |
2dp |
|
|
V_TERMS1 |
number |
0dp |
|
|
V_TERMS2 |
number |
0dp |
|
|
V_TERMS3 |
number |
0dp |
|
|
V_CGL |
number |
2dp |
|
|
V_DGL |
number |
2dp |
|
|
V_CK_MEMO |
char |
80 |
|
default memo for checks |
V_NOTES |
char |
2000 |
|
|
V_FAX |
char |
20 |
|
fax phone |
V_DISC_DGL |
number |
2dp |
|
discount dGL |
V_NAME1 |
char |
40 |
|
vendor rep |
V_PHONE1 |
char |
20 |
|
|
V_FAX1 |
char |
20 |
|
|
V_PAGER1 |
char |
20 |
|
|
V_CAR_PHONE1 |
char |
20 |
|
|
V_NAME2 |
char |
40 |
|
|
V_PHONE2 |
char |
20 |
|
|
V_FAX2 |
char |
20 |
|
|
V_CAR_PHONE2 |
char |
20 |
|
|
V_PAGER2 |
char |
20 |
|
|
V_NAME3 |
char |
40 |
|
|
V_PHONE3 |
char |
20 |
|
|
V_FAX3 |
char |
20 |
|
|
V_PAGER3 |
char |
20 |
|
|
V_CAR_PHONE3 |
char |
20 |
|
|
V_HOME_PHONE1 |
char |
20 |
|
|
V_HOME_PHONE2 |
char |
20 |
|
|
V_HOME_PHONE3 |
char |
20 |
|
|
V_ACTIVE |
number |
0dp |
x |
active vendor? yes or no |
V_1099 |
number |
0dp |
|
|
V_MEDIA_VNUM |
char |
10 |
x |
|
V_ADDRESS2_1 |
char |
50 |
|
|
V_ADDRESS2_2 |
char |
50 |
|
|
V_ADDRESS2_3 |
char |
50 |
|
|
V_ADDRESS2_4 |
char |
50 |
|
|
V_ADDRESS3_1 |
char |
50 |
|
|
V_ADDRESS3_2 |
char |
50 |
|
|
V_ADDRESS3_3 |
char |
50 |
|
|
V_ADDRESS3_4 |
char |
50 |
|
|
V_COMM |
short num |
2dp |
|
media commission |
V_HOLD |
short int |
(0 to 255) |
|
vendor on-hold? |
V_HOLD_WHY |
char |
2000 |
|
why is the vendor on hold? |
V_MEDIA_KIND |
short int |
(0 to 255) |
|
|
V_WEB_URL |
char |
50 |
|
|
V_EMAIL |
char |
50 |
|
|
V_CORP_ID |
char |
100 |
|
corporate vendor ID number |
V_MARKET |
char |
40 |
|
media market (for media vendors) |