| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | AbsEntry | Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | StartDate | Start Date | date | 8 | 0 | | | | |
| 3 | StartTime | Start Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | EndDate | End Date | date | 8 | 0 | | | | |
| 5 | EndTime | End Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 6 | CopySource | Copy Source | nvarchar | 254 | 0 | | | | Allow NULL? |
| 7 | CopyTarget | Copy Target | nvarchar | 254 | 0 | | | | Allow NULL? |
| 8 | UserName | User Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 9 | CopyMethod | Copy Method | int | 6 | 0 | | | 0=N/A, 16=Add New Records and Update Existing Records, 2=Delete All Records Then Add New Records, 4=Update Existing Records Without Adding New Records, 8=Add New Records Without Updating Existing Records | Allow NULL? |
| 10 | FailRpn | Copy failed | int | 6 | 0 | | | 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 | Allow NULL? |
| 11 | MissingUDF | UDF missing | char | 1 | 0 | | | 0=Do Not Copy Records with Missing UDFs, 1=Copy Records and Ignore Missing UDFs, 2=N/A | Allow NULL? |
| 12 | CopyType | Copy Type | int | 6 | 0 | | | | Allow NULL? |
| 13 | ErrorNum | Error Number | nvarchar | 11 | 0 | | | | Allow NULL? |
| 14 | NullifyAct | Nullify Account | int | 6 | 0 | | | 0=Use Accounts in Source, 1=Use Default Accounts in Target, 2=N/A | Allow NULL? |
| 15 | CopyEmtVal | Copy Empty Value | int | 6 | 0 | | | 0=Overwrite Target Fields with Empty Values, 1=Do Not Overwrite Target Fields and Keep Original Values, 2=N/A | Allow NULL? |