Home > Technical > Table Definitions > 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 |
||||
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. |
||||
STRTRADECODE |
VARCHAR(10) |
The location code for which this request was made. |
||||
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.
|
Primary Key: CTRCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |