Home > Technical > Table Definitions > B2BREQUEST

B2BREQUEST

If the system wants to send a B2B file to a supplier or another store, it will make a request in this table. The B2B Service will periodically poll the table and process the request. When a web order is imported through B2B it is logged in the BE database with unique values in both DAILYSALES and CUSTORDERHDR tables - to prevent clashes with orders initiated at the POS or through the back office order function.

 

Column

Type

Description

CTRCODE

BIGINT

A unique number assigned by the system.

STRSOURCE

VARCHAR(5)

A code that indicates the source that requested the B2B action, for example PO = Purchase Order.

LINTREFERENCE

INT

The code of the transaction that requested the B2B action. If STRSOURCE was 'PO' then this would be the purchase order number.

STRSUPPLIERCODE

VARCHAR(10)

The supplier code for which this request was made.

SUPPLIER.strSupplierCode

STRTRADECODE

VARCHAR(10)

The location code for which this request was made.

TRADUNIT.strTradeCode

STROUTPUTTYPE

VARCHAR(20)

Indicates the format of the B2B message, for example STENA means the Stena-formatted purchase order.

STRSTATUS

VARCHAR(10)

Indicates the status of the request.

New  

A new, unprocessed action.

Sent  

The request has been processed.

 

Primary Key: CTRCODE

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