Home > Technical > Table Definitions > B2BSENDFILE

B2BSENDFILE

When the B2B Service processes a request and determines that it needs to send a file, it writes the message to a text file and a record to this table. It periodically polls this table to determine what it needs to send. This provides a queuing mechanism so if B2B Server is terminated, it still has a list of the messages it needs to send.

Column

Type

Description

CTRCODE

BIGINT

A unique number assigned by the system.

STRFILENAME

VARCHAR(100)

The full filename including the path, of the message that is to be sent.

STRSUPPLIERCODE

VARCHAR(10)

The supplier code to which the file is being sent.

SUPPLIER.strSupplierCode

STRTRADECODE

VARCHAR(10)

The location code to which the file is being sent.

TRADUNIT.strTradeCode

DTMWHEN

DATETIME

The date/time the record was created.

STRSUBJECT

VARCHAR(30)

The subject message to be used on the email.

STRADDRESS

VARCHAR(100)

The address to which the message is being sent, for example an email address.

YSNINCLUDEINMESSAGE

VARCHAR(1)

'T' if the text stored at STRFILENAME should be included in the message. 'F' indicates it should be an attachment.

STRSTATUS

VARCHAR(10)

Indicates the status of the record.

New  

A new, unprocessed action.

Sent  

The message has been sent.

INTTYPE

INTEGER

Indicates the type of entry.

0 is Supplier entry
1 is GR Discrepancy entry
2 is Loyalty member emails

MEMBODYTEXT

 

The text of the defined email template for the CUSTACCNEW type will be inserted into this field.

 

Primary Key: CTRCODE

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