Home > Technical > Table Definitions > SUPPLIERB2BCOMMS

SUPPLIERB2BCOMMS

This table shows how files are communicated for B2B transactions.

Column Type Description
STRSUPPLIERCODE VARCHAR(10) The supplier that these details are for.
SUPPLIER.strSupplierCode
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.
TRADUNIT.strTradeCode

INTTYPE

INTEGER

Indicates the type of entry.

0 is Supplier email address
1 is GR Discrepancy email address

 

Primary Key: STRSUPPLIERCODE + CTRCODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)