The table JRJOBMINDVENDORDATA has to contain the vendors that are to be recognized and matched to invoices.
The structure of the table:
Column name |
Data type |
Description |
Notes |
|---|---|---|---|
ve_vendor_no |
(N)VARCHAR(50) |
Vendor number |
Required field. Has to be unique for each vendor of each recipient. |
ve_recipient_no |
(N)VARCHAR(50) |
Recipient number |
Required field. Contains the recipient number maintained in the JRJOBMINDRECIPIENTS table. If no recipient recognition is activated, a random value can be used. |
ve_name |
(N)VARCHAR(100) |
Vendor name |
Necessary for the vendor matching. |
ve_ve_zipcode |
(N)VARCHAR(15) |
ZIP |
|
ve_city |
(N)VARCHAR(50) |
City |
|
ve_country |
(N)VARCHAR(50) |
Country |
|
ve_telephone_no |
(N)VARCHAR(50) |
Telephone |
Necessary for the vendor matching. |
ve_fax_no |
(N)VARCHAR(50) |
Fax |
|
ve_email |
(N)VARCHAR(100) |
||
ve_bank |
(N)VARCHAR(50) |
Bank name |
|
ve_bank_no |
(N)VARCHAR(30) |
Bank code |
|
ve_account_no |
(N)VARCHAR(50) |
Account number |
|
ve_swift_bic |
(N)VARCHAR(30) |
BIC |
Necessary for the vendor matching. |
ve_iban |
(N)VARCHAR(30) |
IBAN |
Necessary for the vendor matching. |
ve_iln |
(N)VARCHAR(13) |
International vendor number |
|
ve_tax_id_no |
(N)VARCHAR(50) |
Tax number |
Necessary for the vendor matching. |
ve_vat_id_no |
(N)VARCHAR(50) |
VAT ID |
Necessary for the vendor matching. |
ve_clerk_id |
(N)VARCHAR(50) |
Clerk name |
|
customer_no |
(N)VARCHAR(50) |
Customer number used by this vendor |
|
modify_date |
DATETIME |
Modify date |
|
modified_by |
(N)VARCHAR(50) |
Modified by |
|
create_date |
DATETIME |
Create date |
|
created_by |
(N)VARCHAR(50) |
Created by |
