|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Quick Copy Log Manager
Table Name: OCPL
Table Description: Quick Copy Log Manager
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| StartDate | Start Date | Date | 8 | - | Â | Â | Â |
| StartTime | Start Time | nVarChar | 6 | - | Â | Â | Â |
| EndDate | End Date | Date | 8 | - | Â | Â | Â |
| EndTime | End Time | nVarChar | 6 | - | Â | Â | Â |
| CopySource | Copy Source | nVarChar | 254 | - | Â | Â | Â |
| CopyTarget | Copy Target | nVarChar | 254 | - | Â | Â | Â |
| UserName | User Name | nVarChar | 20 | - | Â | Â | Â |
| CopyMethod | Copy Method | Int | 6 | - | Â | 2 | Delete All Records Then Add New Records |
| Â | Â | Â | Â | Â | Â | 4 | Update Existing Records Without Adding New Records |
| Â | Â | Â | Â | Â | Â | 8 | Add New Records Without Updating Existing Records |
| Â | Â | Â | Â | Â | Â | 16 | Add New Records and Update Existing Records |
| Â | Â | Â | Â | Â | Â | 0 | N/A |
| FailRpn | Copy failed | Int | 6 | - | Â | 1 | Ignore All Errors and Copy Valid Records |
| Â | Â | Â | Â | Â | Â | 2 | Obtain User Confirmation |
| Â | Â | Â | Â | Â | Â | 3 | Terminate Copy Process When One or More Errors Occur |
| Â | Â | Â | Â | Â | Â | 4 | Terminate Copy Process When Number of Errors Exceeds |
| MissingUDF | UDF missing | VarChar | 1 | - | Â | 2 | N/A |
| Â | Â | Â | Â | Â | Â | 1 | Copy Records and Ignore Missing UDFs |
| Â | Â | Â | Â | Â | Â | 0 | Do Not Copy Records with Missing UDFs |
| CopyType | Copy Type | Int | 6 | - | Â | Â | Â |
| ErrorNum | Error Number | nVarChar | 11 | - | Â | Â | Â |
| NullifyAct | Nullify Account | Int | 6 | - | Â | 2 | N/A |
| Â | Â | Â | Â | Â | Â | 1 | Use Default Accounts in Target |
| Â | Â | Â | Â | Â | Â | 0 | Use Accounts in Source |
| CopyEmtVal | Copy Empty Value | Int | 6 | - | Â | 2 | N/A |
| Â | Â | Â | Â | Â | Â | 1 | Do Not Overwrite Target Fields and Keep Original Values |
| Â | Â | Â | Â | Â | Â | 0 | Overwrite Target Fields with Empty Values |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |