|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Data Archive - Candidate
Table Name: DAR4
Table Description: Data Archive - Candidate
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ArcEntry | Data Archive Entry | Int | 11 | - | Â | Â | Â |
| Series | Series | 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 | - | Â | Â | Â |
| Type | Type | VarChar | 1 | - | R | R | Recommendation |
| Â | Â | Â | Â | Â | Â | M | Marked |
| 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 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | ArcEntry |
| Â | Â | Line_ID |
| ABS_TYPE | No | DocAbs |
| Â | Â | DocType |