Home > Technical > Table Definitions > SUPPLIERB2BCOMMS
This table shows how files are communicated for B2B transactions.
Column | Type | Description |
STRSUPPLIERCODE | VARCHAR(10) | The
supplier that these details are for.![]() |
CTRCODE | INT | A unique number generated by the system. |
STRTYPE | VARCHAR(10) | Indicates whether this method is used for sending or receiving files. Values can be SEND or RECEIVE. |
STRMETHOD | VARCHAR(10) | The method of communication. At this stage only email is supported. Set to EMAIL. |
STRADDRESS | VARCHAR(60) | If we are sending the data via email, this contains the email address we are sending to. |
STRUSERCODE | VARCHAR(20) | If we are receiving data via email, this is the user code of the POP3 mailbox we need to check. |
STRPASSWORD | VARCHAR(60) | If we are receiving data via email, this is the password of the POP3 mailbox we need to check. |
STROURADDRESS | VARCHAR(60) | If we are sending data via email, this is the email address used to indicate the sender (basically our email address). |
STRTRADECODE |
VARCHAR(10) |
The location that this communications record is for. |
INTTYPE |
INTEGER |
Indicates the type of entry. 0 is Supplier email address |
Primary Key: STRSUPPLIERCODE + CTRCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |