Vendors
Field Name |
Caption |
Mask |
Description |
Field Type |
PV_ADDR1 |
Address |
75x |
Address Line 1: |
Text |
PV_ADDR2 |
Address 2 |
75x |
Address Line 2: |
Text |
PV_ADDR3 |
Address 3 |
75x |
Address Line 3: |
Text |
PV_ADDR4 |
Address 4 |
75x |
Address Line 4: |
Text |
PV_CITY |
City |
20x |
City: |
Text |
PV_CO_ID |
Link to comment |
|
Link to Comment |
Text |
PV_CONTACT |
Contact Name |
30x |
Vendor Contact Name |
Text |
PV_CRT_BY |
Created By |
25x |
Created By |
Text |
PV_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
PV_DESC |
Description |
50x |
Vendor Name: |
Text |
PV_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
PV_EMAIL |
150x |
E-Mail address: |
Text |
|
PV_ID |
Vendor Rec # |
nnnnnnnn |
Unique Identifier: |
Long Integer |
PV_IMG_FLG |
|
|
Image Available: Image open 0 = False, 1 = True |
Boolean |
PV_MOD_BY |
Modified By |
25x |
Modified By : Person that Last Modified Record |
Text |
PV_MOD_DT |
Modified Date |
mm/dd/yyyy |
Modified Date : Date Record Last Modified |
Date/Time |
PV_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
PV_MOV_FLG |
|
|
Movie Available: Movie open 0 = False, 1 = True |
Boolean |
PV_NUMBER |
Vendor ID |
15x |
Vendor Number |
Text |
PV_PHONE |
Phone Number |
25x |
Phone Number: |
Text |
PV_POONLY |
Restrict PO List |
|
On Purchase Orders for this Vendor, should only their parts be shown? |
Boolean |
PV_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
PV_STATE |
State |
20x |
State: |
Text |
PV_URL |
Web Address |
50x |
Web Page URL: |
Text |
PV_USER10 |
User 10 |
mm/dd/yyyy |
User 10 : User Defined Date |
Date/Time |
PV_USER11 |
User 11 |
mm/dd/yyyy |
User 11 : User Defined Date |
Date/Time |
PV_USER12 |
User 12 |
-nnnnnnnnn.nn |
User 12 : User Defined Double |
Double |
PV_USER13 |
User 13 |
-nnnnnnnnn.nn |
User 13 : User Defined Double |
Double |
PV_USER14 |
User 14 |
30x |
User 14 : User Defined Alphanumeric |
Text |
PV_USER15 |
User 15 |
30x |
User 15 : User Defined Alphanumeric |
Text |
PV_USER1CD |
User 1 |
nnn |
User 1 : User Defined Code 1 |
Integer |
PV_USER1TY |
User 1 Text |
25x |
User 1 Text : User Defined Description 1 |
Text |
PV_USER2CD |
User 2 |
nnn |
User 2 : User Defined Code 2 |
Integer |
PV_USER2TY |
User 2 Text |
25x |
User 2 Text : User Defined Description 2 |
Text |
PV_USER3CD |
User 3 |
nnn |
User 3 : User Defined Code 3 |
Integer |
PV_USER3TY |
User 3 Text |
25x |
User 3 Text : User Defined Description 3 |
Text |
PV_USER4 |
User 4 |
nnnnnnnnn.nn |
User 4 : User Defined Numeric Value |
Double |
PV_USER5 |
User 5 |
30x |
User 5 : User Defined Alphanumeric |
Text |
PV_USER6 |
User 6 |
|
User 6 : User Defined Logical 1 |
Boolean |
PV_USER7 |
User 7 |
|
User 7 : User Defined Logical 2 |
Boolean |
PV_USER8 |
User 8 |
|
User 8 : User Defined Logical 3 |
Boolean |
PV_USER9 |
User 9 |
mm/dd/yyyy |
User 9 : User Defined Date |
Date/Time |
PV_ZIP |
Zip |
15x |
Zip Code: |
Text |