|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Data Archive - Transaction Log
Table Name: DAR2
Table Description: Data Archive - Transaction Log
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ArcEntry | Data Archive Entry | Int | 11 | - | Â | Â | Â |
| Line_ID | Row Number | Int | 11 | - | 0 | Â | Â |
| Approve | Approve | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DocType | Document Type | Int | 11 | - | Â | Â | Â |
| DocNum | Document Number | Int | 11 | - | Â | Â | Â |
| DocAbs | Document Abs Entry | Int | 11 | - | Â | Â | Â |
| CardCode | Customer/Vendor Code | nVarChar | 15 | - | Â | Â | Â |
| RefDate | Posting Date | Date | 8 | - | Â | Â | Â |
| DueDate | Due Date | Date | 8 | - | Â | Â | Â |
| TaxDate | Document Date | Date | 8 | - | Â | Â | Â |
| Total | Total | Num | 19.6 | - | Â | Â | Â |
| Action | Action | VarChar | 1 | - | T | R | Remove |
| Â | Â | Â | Â | Â | Â | L | Locked |
| Â | Â | Â | Â | Â | Â | T | Temporary |
| Remarks | Remarks | nVarChar | 50 | - | Â | Â | Â |
| KeySeg1 | Key Segment 1 | nVarChar | 15 | - | Â | Â | Â |
| KeySeg2 | Key Segment 2 | nVarChar | 15 | - | Â | Â | Â |
| KeySeg3 | Key Segment 3 | nVarChar | 15 | - | Â | Â | Â |
| KeySeg4 | Key Segment 4 | nVarChar | 15 | - | Â | Â | Â |
| KeySeg5 | Key Segment 5 | nVarChar | 15 | - | Â | Â | Â |
| KeySeg6 | Key Segment 6 | nVarChar | 15 | - | Â | Â | Â |
| ClusterId | Cluster ID | Int | 11 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | ArcEntry |
| Â | Â | Line_ID |