|
|
SAP Business One SDK 10.0 - Database Tables Reference |
SWFQ History Table
Table Name: AWFQ
Table Description: SWFQ History Table
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| SequenceID | Sequence ID | Int | 11 | - | Â | Â | Â |
| SourceDB | Source Database | nVarChar | 100 | - | Â | Â | Â |
| Timestamp | Time Stamp | nVarChar | 20 | - | Â | Â | Â |
| ObjectType | Object Type | nVarChar | 30 | - | Â | Â | Â |
| TransType | Transaction Type | VarChar | 1 | - | Â | A | Add |
| Â | Â | Â | Â | Â | Â | U | Update |
| Â | Â | Â | Â | Â | Â | C | Cancel |
| Â | Â | Â | Â | Â | Â | D | Delete |
| FieldsInKe | Number of Fields in Key | Int | 11 | - | Â | Â | Â |
| FieldNames | Key Field Names | nVarChar | 254 | - | Â | Â | Â |
| FieldValue | Key Field Values | nVarChar | 254 | - | Â | Â | Â |
| UserID | UserID | nVarChar | 25 | - | Â | Â | Â |
| TaskID | Task ID | nVarChar | 64 | - | Â | Â | Â |
| TrigEvntID | Trigger Event ID | nVarChar | 64 | - | Â | Â | Â |
| TrigParams | Trigger Parameters | Text | 16 | - | Â | Â | Â |
| LogInst | Log Instance | Int | 11 | - | Â | Â | Â |
| IsSuccess | Is Message Handled Successfully | VarChar | 1 | - | Â | Â | Â |
| ResultMemo | Memo of the Result | nVarChar | 250 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | SequenceID |
| Â | Â | LogInst |