The table JRJOBMINDRECIPIENTS has to contain the recipients, if the recipients recognition is to be used.
The structure of the table:
Column name |
Data type |
Description |
Notes |
|---|---|---|---|
re_recipient_no |
(N)VARCHAR(50) |
Recipient number |
Required field. Each recipient needs a unique number that can be referenced in the vendor table. |
re_system |
(N)VARCHAR(12) |
Vendor number |
Name of a source system. |
re_name |
(N)VARCHAR(100) |
Vendor name |
Necessary for the recipient matching. |
re_street |
(N)VARCHAR(100) |
Street |
Necessary for the recipient matching. |
re_country |
(N)VARCHAR(50) |
Country |
Necessary for the recipient matching. |
re_zipcode |
(N)VARCHAR(15) |
ZIP |
Necessary for the recipient matching. |
re_city |
(N)VARCHAR(50) |
City |
Necessary for the recipient matching. |
re_iln |
(N)VARCHAR(13) |
International vendor number |
|
re_tax_id_no |
(N)VARCHAR(50) |
Tax number |
Necessary for the recipient matching. |
re_vat_id_no |
(N)VARCHAR(50) |
VAT ID |
Necessary for the recipient matching. |
modify_date |
DATETIME |
Modify date |
|
modified_by |
(N)VARCHAR(50) |
Modified by |
|
create_date |
DATETIME |
Create date |
|
created_by |
(N)VARCHAR(50) |
Created by |
