Home > Technical > Table Definitions > B2BEMAIL

B2BEMAIL

Used to store the Email details for Supplier Alerts and for PO Authorisation.

Column

Type

Description

INTTYPE

INT

0 is PO Authorisation

1. is Supplier Alert

STRKEY

VARCHAR(10)

For PO Auth this is the Trade Code

For Supplier Alert this is the Supplier Code

INTEMAILTYPE INT

For PO Auth this is:

1 – Authorisation email

2 – Request for Authorisation email.

For Supplier alert this field is ignored

YSNACTIVE

VARCHAR(1)  
STRPRIORITY VARCHAR(1)  
STRSUBJECT VARCHAR(50)  
STRSUBJECTBODY VARCHAR9200)  
STRBODY VARCHAR(2000)  
YSNBODYATTACHMENT VARCHAR(1000) If true, STRBODY will be added as an attachment
   
Converted from CHM to HTML with chm2web Pro 2.85 (unicode)