|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Personal Data Retention Periods - History
Table Name: ADRP
Table Description: Personal Data Retention Periods - History
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| PeriodCode | Period Code | nVarChar | 20 | - | Â | Â | Â |
| PeriodName | Period Description | nVarChar | 100 | - | Â | Â | Â |
| DatSubType | Data Subject Type | nVarChar | 4 | - | Â | OCRD | Business Partner |
| Â | Â | Â | Â | Â | Â | OCPR | Contact Person |
| Â | Â | Â | Â | Â | Â | OHEM | Employee |
| Â | Â | Â | Â | Â | Â | OUSR | User |
| Â | Â | Â | Â | Â | Â | CPN1 | Campaign - BP |
| ObjType | Object Type | Int | 11 | - | -1 | -1 | All |
| Â | Â | Â | Â | Â | Â | 2 | Business Partner |
| Â | Â | Â | Â | Â | Â | 23 | Sales Quotation |
| Â | Â | Â | Â | Â | Â | 17 | Sales Order |
| Â | Â | Â | Â | Â | Â | 15 | Delivery Notes |
| Â | Â | Â | Â | Â | Â | 234000031 | Return Request |
| Â | Â | Â | Â | Â | Â | 16 | Return |
| Â | Â | Â | Â | Â | Â | 203 | A/R Down Payment |
| Â | Â | Â | Â | Â | Â | 13 | A/R Invoice |
| Â | Â | Â | Â | Â | Â | 14 | A/R Credit Memo |
| Â | Â | Â | Â | Â | Â | 165 | A/R Correction Invoice |
| Â | Â | Â | Â | Â | Â | 280 | A/R Tax Invoice |
| Â | Â | Â | Â | Â | Â | 1470000113 | Purchase Request |
| Â | Â | Â | Â | Â | Â | 540000006 | Purchase Quotation |
| Â | Â | Â | Â | Â | Â | 22 | Purchase Order |
| Â | Â | Â | Â | Â | Â | 20 | Goods Receipt PO |
| Â | Â | Â | Â | Â | Â | 234000032 | Goods Return Request |
| Â | Â | Â | Â | Â | Â | 21 | Goods Return |
| Â | Â | Â | Â | Â | Â | 204 | A/P Down Payment |
| Â | Â | Â | Â | Â | Â | 18 | A/P Invoice |
| Â | Â | Â | Â | Â | Â | 19 | A/P Credit Memo |
| Â | Â | Â | Â | Â | Â | 163 | A/P Correction Invoice |
| Â | Â | Â | Â | Â | Â | 281 | A/P Tax Invoice |
| Â | Â | Â | Â | Â | Â | 69 | Landed Costs |
| Â | Â | Â | Â | Â | Â | 24 | Incoming Payments |
| Â | Â | Â | Â | Â | Â | 46 | Outgoing Payments |
| Â | Â | Â | Â | Â | Â | 57 | Checks for Payment |
| Â | Â | Â | Â | Â | Â | 321 | Internal Reconciliation |
| Â | Â | Â | Â | Â | Â | 34 | Recurring Posting |
| Â | Â | Â | Â | Â | Â | 30 | Journal Entry |
| Â | Â | Â | Â | Â | Â | 59 | Goods Receipt |
| Â | Â | Â | Â | Â | Â | 60 | Goods Issue |
| Â | Â | Â | Â | Â | Â | 162 | Inventory Revaluation |
| Â | Â | Â | Â | Â | Â | 1470000065 | Inventory Counting |
| Â | Â | Â | Â | Â | Â | 10000071 | Inventory Posting |
| Â | Â | Â | Â | Â | Â | 1250000001 | Inventory Transfer Request |
| Â | Â | Â | Â | Â | Â | 67 | Inventory Transfer |
| Â | Â | Â | Â | Â | Â | 202 | Production Order |
| PeriodYear | Period Years | Int | 11 | - | Â | Â | Â |
| Active | Active | VarChar | 1 | - | Y | Y | Active |
| Â | Â | Â | Â | Â | Â | N | Inactive |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| CreateTime | Creation Time | Int | 11 | - | Â | Â | Â |
| UpdateDate | Update Date | Date | 8 | - | Â | Â | Â |
| UpdateTime | Update Time | Int | 11 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | OUSR | Â | Â | Â |
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | I | Interface |
| Â | Â | Â | Â | Â | Â | U | Update |
| Â | Â | Â | Â | Â | Â | M | Import |
| Â | Â | Â | Â | Â | Â | O | DI API |
| Â | Â | Â | Â | Â | Â | S | Service Layer |
| Â | Â | Â | Â | Â | Â | W | Web Client |
| Â | Â | Â | Â | Â | Â | A | Doc. Generation Wizard |
| Â | Â | Â | Â | Â | Â | D | Restore Wizard |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | T | Year Transfer |
| VersionNum | Version Number | nVarChar | 13 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | LogInstanc |