Home > Technical > Table Definitions > B2BAUDIT
As the B2B Service performs its functions, it will record audit information to this table.
Column |
Type |
Description |
CTRCODE |
BIGINT |
A unique number assigned by the system. |
DTMWHEN |
DATETIME |
The date/time the audit event was recorded. |
LINTREQUESTNUM |
INT |
The request for which the audit message was generated. |
STRMESSAGE |
VARCHAR(100) |
The audit message. |
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. |
MEMFULLMESSAGE |
VARCHAR(2000) |
If a long message is required, it is stored here. |
Primary Key: CTRCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |