|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Data Archive - Transaction Log
Table Name: DAR1
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 | - | Â | Â | Â |
| DocType | Document Type | nVarChar | 20 | - | Â | Â | Â |
| DocNum | Document Number | Int | 11 | - | Â | Â | Â |
| DocAbs | Document Internal ID | Int | 11 | - | Â | Â | Â |
| Total | Total | Num | 19.6 | - | Â | Â | Â |
| RefDate | Posting Date | Date | 8 | - | Â | Â | Â |
| ClusterId | Cluster ID | Int | 11 | - | Â | Â | Â |
| Remarks | Remarks | nVarChar | 100 | - | Â | Â | Â |
| 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 | - | Â | Â | Â |
| KeySeg7 | Key Segment 7 | nVarChar | 20 | - | Â | Â | Â |
| KeySeg8 | Key Segment 8 | nVarChar | 15 | - | Â | Â | Â |
| KeySeg9 | Key Segment 9 | nVarChar | 15 | - | Â | Â | Â |
| KeySeg10 | Key Segment 10 | nVarChar | 15 | - | Â | Â | Â |
| Series | Series | Int | 11 | - | Â | Â | Â |
| DocSubType | Document Sub-Type | nVarChar | 2 | - | -- | Â | Â |
| PIndicator | Period Indicator | nVarChar | 10 | - | ' ' | Â | Â |
| Instance | Instance | Int | 6 | - | 0 | Â | Â |
| Segment | Segment | Int | 6 | - | 0 | Â | Â |
| CardCode | Card Code | nVarChar | 15 | OCRD | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | ArcEntry |
| Â | Â | Line_ID |
| ABS_TYPE | No | DocAbs |
| Â | Â | DocType |