Contractor Setup
Field Name |
Caption |
Mask |
Description |
Field Type |
VN_ACT_FLG |
Active Vendor |
|
Active Contractor |
Boolean |
VN_ADDRES1 |
Address |
50x |
Address |
Text |
VN_ADDRES2 |
Address 2 |
50x |
Address |
Text |
VN_CITY |
City |
100x |
City |
Text |
VN_COMMENT1 |
Long Note |
|
Long Note |
Memo |
VN_CONTACT |
Contact |
30x |
Contact |
Text |
VN_CRT_BY |
Created By |
25x |
Created By |
Text |
VN_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
VN_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
VN_EMAIL |
Email Address |
150x |
Email Address |
Text |
VN_ENCUM |
Total Encumbered |
-nnnnnnnn.nn |
Total Encumbered |
Double |
VN_FAX_PHN |
Fax Phone |
25x |
Fax Phone |
Text |
VN_HM_PHN |
Home Phone |
25x |
Home Phone |
Text |
VN_ID |
Vendor Rec # |
nnnnnnnn |
AutoID Number |
Long Integer |
VN_MOB_PHN |
Mobile Phone |
25x |
Mobile Phone |
Text |
VN_MOD_BY |
Last Modified By |
25x |
Modified By |
Text |
VN_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
VN_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
VN_PAGER |
Pager |
25x |
Pager |
Text |
VN_PAID |
Total Paid |
-nnnnnnnn.nn |
Total Paid |
Double |
VN_POSTAL |
Zip Code |
15x |
Zip Code |
Text |
VN_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
VN_STAT_CD |
Vendor Status |
nnn |
Contractor Status |
Integer |
VN_STAT_TY |
Vendor Status Text |
25x |
Contractor Status Txt |
Text |
VN_STATE |
State |
25x |
State |
Text |
VN_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
VN_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
VN_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
VN_USER13 |
User 13 |
|
User 13 |
Boolean |
VN_USER14 |
User 14 |
|
User 14 |
Boolean |
VN_USER15 |
User 15 |
|
User 15 |
Boolean |
VN_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
VN_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
VN_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
VN_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
VN_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
VN_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
VN_USER4 |
User 4 |
30x |
User 4 |
Text |
VN_USER5 |
User 5 |
30x |
User 5 |
Text |
VN_USER6 |
User 6 |
30x |
User 6 |
Text |
VN_USER7 |
User 7 |
-nnnnnnnn.nn |
User 7 |
Double |
VN_USER8 |
User 8 |
-nnnnnnnn.nn |
User 8 |
Double |
VN_USER9 |
User 9 |
-nnnnnnnn.nn |
User 9 |
Double |
VN_VEND_CD |
Vendor |
10x |
Vendor |
Text |
VN_VEND_TY |
Vendor Name |
60x |
Vendor Name |
Text |
VN_WEB |
Web Site |
30x |
Web Site |
Text |
VN_WK_PHN |
Work Phone |
25x |
Work Phone |
Text |