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