| 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 | nvarchar | 8 | 0 | OECM | | | Allow NULL? |
| 3 | ParentID | Parent ID | int | 11 | 0 | ECM2 | | | Allow NULL? |
| 4 | ActType | Action Type | char | 1 | 0 | | | A=Internal Reconciliation, B=BP Check, C=Contingency, D=Document A/R, E=A/P Draft Document, F=A/R Draft Document, I=Payment - Incoming, K=Skip, L=VAT Liabilities, N=VAT Declarations, O=Other, P=Document A/P, R=Report, S=Setup, T=Transportation Document, U=Payment - Outgoing, V=VAT Obligations, W=Inventory Transfer, Y=VAT Payments | Allow NULL? |
| 5 | ActDesc | Action Description | nvarchar | 100 | 0 | | | | Allow NULL? |
| 6 | ActStatus | Action Status | char | 1 | 0 | | N | A=Authorized, B=Aborted, C=Canceled, D=Denied, E=Error, G=Warning, I=In Process, J=Rejected, M=Imported, N=New, O=OK, P=Pending, Q=Queued, R=Document Error, S=Sent, T=Temporary Error, V=Approved, W=Waiting | Allow NULL? |
| 7 | IsRemoved | Is Removed | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 8 | ActMessage | Action Message | nvarchar | 254 | 0 | | | | Allow NULL? |
| 9 | ActEnv | Action Environment Type | int | 11 | 0 | OBNI | -1 | | Allow NULL? |
| 10 | BPLId | Branch ID | int | 11 | 0 | OBPL | -1 | | Allow NULL? |
| 11 | Submits | Report - Number of Submissions | int | 6 | 0 | | | | Allow NULL? |
| 12 | ObjectID | Object ID | nvarchar | 50 | 0 | | | | Allow NULL? |
| 13 | ReportID | Report ID | nvarchar | 50 | 0 | | | | Allow NULL? |
| 14 | SrcObjType | Source Object Type | nvarchar | 20 | 0 | | | | Allow NULL? |
| 15 | SrcObjAbs | Source Object Internal ID | int | 11 | 0 | | | | Allow NULL? |
| 16 | Cancel | Cancelation | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 17 | AssignedID | Assigned ID | nvarchar | 50 | 0 | | | | Allow NULL? |
| 18 | DocBtch | Document Batch | nvarchar | 50 | 0 | | | | Allow NULL? |
| 19 | DocBtchLn | Document Batch Line | int | 6 | 0 | | | | Allow NULL? |
| 20 | GenType | Generation Type | char | 1 | 0 | | N | G=Generate, L=Generate - Later, N=Not Relevant, R=Send - Later, S=Send | Allow NULL? |
| 21 | TestMode | Test Mode | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 22 | PeriodType | Report Period Type | char | 1 | 0 | | | M=Month, P=Period, Q=Quarter, Y=Year | Allow NULL? |
| 23 | PeriodNum | Report Period Number | int | 11 | 0 | | | | Allow NULL? |
| 24 | Year | Report Year | int | 6 | 0 | | | | Allow NULL? |
| 25 | DateFrom | Report - Date From | date | 8 | 0 | | | | |
| 26 | DateTo | Report - Date To | date | 8 | 0 | | | | |
| 27 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 28 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 29 | CreateTS | Creation Time - Incl. Secs | int | 11 | 0 | | | | Allow NULL? |
| 30 | UserSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 31 | UpdateDate | Update Date | date | 8 | 0 | | | | |
| 32 | UpdateTS | Update Time - Incl. Secs | int | 11 | 0 | | | | Allow NULL? |
| 33 | LogInstanc | Log Instance | int | 6 | 0 | | | | Allow NULL? |
| 34 | SchedJobID | Scheduled Job ID | int | 11 | 0 | OBSJ | | | Allow NULL? |
| 35 | GUID | GUID | nvarchar | 100 | 0 | | | | Allow NULL? |
| 36 | Authority | Authority Code | nvarchar | 16 | 0 | OPAC | | | Allow NULL? |
