Home > Technical > Table Definitions > B2BAUDIT

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.

B2BREQUEST.ctrCode

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)