| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | AbsEntry | Internal ID | int | 11 | 0 | | | | Allow NULL? |
| 2 | Code | Code | char | 1 | 0 | | | | Allow NULL? |
| 3 | ActType | Action Type | char | 1 | 0 | | | B=BP Check, C=Contingency, D=Document A/R, F=Draft, K=Skip, O=Other, P=Document A/P, R=Report, S=Setup | Allow NULL? |
| 4 | ActDesc | Action Description | nvarchar | 100 | 0 | | | | Allow NULL? |
| 5 | ActStatus | Action Status | char | 1 | 0 | | N | A=Authorized, B=Aborted, C=Canceled, D=Denied, E=Error, I=In Process, J=Rejected, N=New, O=OK, P=Pending, Q=Queued, R=Document Error, S=Sent, W=Waiting | Allow NULL? |
| 6 | ActEnv | Action Environment Type | int | 11 | 0 | | -1 | | Allow NULL? |
| 7 | ActMessage | Action Message | nvarchar | 254 | 0 | | | | Allow NULL? |
| 8 | ActData | Action Data | text | 16 | 0 | | | | |
| 9 | ObjectID | Object ID | nvarchar | 50 | 0 | | | | Allow NULL? |
| 10 | ReportID | Report ID | nvarchar | 50 | 0 | | | | Allow NULL? |
| 11 | BPLId | Branch ID | int | 11 | 0 | | -1 | | Allow NULL? |
| 12 | SrcObjType | Source Object Type | nvarchar | 20 | 0 | | | | Allow NULL? |
| 13 | SrcObjAbs | Source Object Internal ID | int | 11 | 0 | | | | Allow NULL? |
| 14 | PeriodType | Report Period Type | char | 1 | 0 | | | M=Month, P=Period, Q=Quarter, Y=Year | Allow NULL? |
| 15 | PeriodNum | Report Period Number | int | 11 | 0 | | | | Allow NULL? |
| 16 | Year | Report Year | int | 6 | 0 | | | | Allow NULL? |
| 17 | DateFrom | Report - Date From | date | 8 | 0 | | | | |
| 18 | DateTo | Report - Date To | date | 8 | 0 | | | | |
| 19 | Submits | Report - Number of Submissions | int | 6 | 0 | | | | Allow NULL? |
| 20 | DocBtch | Document Batch | nvarchar | 50 | 0 | | | | Allow NULL? |
| 21 | DocBtchLn | Document Batch Line | int | 6 | 0 | | | | Allow NULL? |
| 22 | AssignedID | Assigned ID | nvarchar | 50 | 0 | | | | Allow NULL? |
| 23 | SendDate | Send Date | date | 8 | 0 | | | | |
| 24 | ReceivDate | Received Date | date | 8 | 0 | | | | |
| 25 | UserSign | User Signature | int | 6 | 0 | | | | Allow NULL? |
| 26 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 27 | UserSign2 | Updating User | int | 6 | 0 | | | | Allow NULL? |
| 28 | UpdateDate | Update Date | date | 8 | 0 | | | | |
| 29 | LogInstanc | Log Instance | int | 6 | 0 | | | | Allow NULL? |
| 30 | ActData2 | Action Data 2 | text | 16 | 0 | | | | |
| 31 | IsRemoved | Is Removed | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 32 | Cancel | Cancelation | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 33 | CreateTS | Creatn Time - Incl. Secs | int | 11 | 0 | | | | Allow NULL? |
| 34 | UpdateTS | Update Full Time | int | 11 | 0 | | | | Allow NULL? |
| 35 | SendTS | Send Time - Incl. Secs | int | 11 | 0 | | | | Allow NULL? |
