|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Data Archiving
Table Name: ODAR
Table Description: Data Archiving
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Numerator | Int | 11 | - | Â | Â | Â |
| PeriodDate | Period Date | Date | 8 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | - | Â | Â | Â |
| CreateDate | Archive Date | Date | 8 | - | Â | Â | Â |
| CreateTime | Archive Time | Int | 6 | - | Â | Â | Â |
| VersionNum | Version Number | Int | 11 | - | Â | Â | Â |
| JEPerLen | Journal Entry Period Length | VarChar | 1 | - | A | A | Period |
| Â | Â | Â | Â | Â | Â | S | Sub-period |
| Â | Â | Â | Â | Â | Â | M | Month |
| JERef1 | Journal Entry Reference 1 | nVarChar | 100 | - | Â | Â | Â |
| JERef2 | Journal Entry Reference 2 | nVarChar | 100 | - | Â | Â | Â |
| JEMemo | Journal Entry Remarks | nVarChar | 254 | - | Â | Â | Â |
| JEByProj | Journal Entry By Project | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| JEByProf | Journal Entry By Dist. Rule | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| INPerLen | Inventory Period Length | VarChar | 1 | - | A | A | Period |
| Â | Â | Â | Â | Â | Â | S | Sub-period |
| Â | Â | Â | Â | Â | Â | M | Month |
| INPriceSrc | Inventory Price Source | Int | 6 | OPLN | Â | Â | Â |
| INRef1 | Inventory Reference 1 | nVarChar | 11 | - | Â | Â | Â |
| INRef2 | Inventory Reference 2 | nVarChar | 11 | - | Â | Â | Â |
| INMemo | Inventory Remarks | nVarChar | 254 | - | Â | Â | Â |
| JEByCurr | Journal Entry by Currency | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| JEByDIM2 | Journal Entry by Dimension 2 | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| JEByDIM3 | Journal Entry by Dimension 3 | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| JEByDIM4 | Journal Entry by Dimension 4 | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| JEByDIM5 | Journal Entry by Dimension 5 | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DBReduc | DB Reduction (MB) | Num | 19.6 | - | Â | Â | Â |
| DBReducPer | DB Reduction (%) | Num | 19.6 | - | Â | Â | Â |
| TrandReduc | Transaction Reduction | Int | 11 | - | Â | Â | Â |
| TranReducP | Transaction Reduction (%) | Num | 19.6 | - | Â | Â | Â |
| INZeroPrc | Inventory Zero Price | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| TranRedArP | Trans. Reduc. Archived (%) | Num | 19.6 | - | Â | Â | Â |
| DelNonReco | Delete nonreconciled OBNK lns | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| RunName | Data Archive Run Name | nVarChar | 50 | - | Â | Â | Â |
| RODBGUID | Readonly DB GUID for Archiving | nVarChar | 32 | - | Â | Â | Â |
| ArchMethod | Archive Method | VarChar | 1 | - | F | F | By Financial Period |
| Â | Â | Â | Â | Â | Â | B | By Business Partner |
| Â | Â | Â | Â | Â | Â | R | Documents |
| DocSelect | Documents Selection | Text | 16 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |