|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Electronic Document Import Files - History
Table Name: AEC8
Table Description: Electronic Document Import Files - History
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal ID | Int | 11 | - | Â | Â | Â |
| Code | Code | nVarChar | 8 | - | Â | Â | Â |
| ParentID | Parent ID | Int | 11 | - | Â | Â | Â |
| ActType | Action Type | Int | 11 | - | 0 | 1 | Setup |
| Â | Â | Â | Â | Â | Â | 2 | Report |
| Â | Â | Â | Â | Â | Â | 3 | A/R Document |
| Â | Â | Â | Â | Â | Â | 4 | A/P Document |
| Â | Â | Â | Â | Â | Â | 5 | A/R Draft Document |
| Â | Â | Â | Â | Â | Â | 6 | A/P Draft Document |
| Â | Â | Â | Â | Â | Â | 7 | Other |
| Â | Â | Â | Â | Â | Â | 8 | Skip |
| Â | Â | Â | Â | Â | Â | 9 | Contingency |
| Â | Â | Â | Â | Â | Â | 10 | BP Check |
| Â | Â | Â | Â | Â | Â | 11 | Incoming Payment |
| Â | Â | Â | Â | Â | Â | 12 | Outgoing Payment |
| Â | Â | Â | Â | Â | Â | 13 | Internal Reconciliation |
| Â | Â | Â | Â | Â | Â | 14 | Transportation Document |
| Â | Â | Â | Â | Â | Â | 15 | Inventory Transfer |
| Â | Â | Â | Â | Â | Â | 16 | VAT Obligations |
| Â | Â | Â | Â | Â | Â | 17 | VAT Declarations |
| Â | Â | Â | Â | Â | Â | 18 | VAT Liabilities |
| Â | Â | Â | Â | Â | Â | 19 | VAT Payments |
| Â | Â | Â | Â | Â | Â | 20 | Delivery |
| Â | Â | Â | Â | Â | Â | 21 | Return |
| Â | Â | Â | Â | Â | Â | 22 | A/R Invoice |
| Â | Â | Â | Â | Â | Â | 23 | A/R Credit Memo |
| Â | Â | Â | Â | Â | Â | 24 | Goods Receipt PO |
| Â | Â | Â | Â | Â | Â | 25 | Goods Return |
| Â | Â | Â | Â | Â | Â | 26 | A/P Invoice |
| Â | Â | Â | Â | Â | Â | 27 | A/P Credit Memo |
| Â | Â | Â | Â | Â | Â | 28 | Draft Incoming Payment |
| Â | Â | Â | Â | Â | Â | 29 | Draft Outgoing Payment |
| Â | Â | Â | Â | Â | Â | 30 | Journal Entry |
| Â | Â | Â | Â | Â | Â | 31 | E-Books Expense |
| Â | Â | Â | Â | Â | Â | 45 | Goods Issue |
| Â | Â | Â | Â | Â | Â | 46 | Goods Receipt |
| Â | Â | Â | Â | Â | Â | 47 | Pick List |
| Â | Â | Â | Â | Â | Â | 48 | Draft Goods Issue |
| Â | Â | Â | Â | Â | Â | 49 | Draft Goods Receipt |
| ActDesc | Action Description | nVarChar | 100 | - | Â | Â | Â |
| ActStatus | Action Status | VarChar | 1 | - | N | N | New |
| Â | Â | Â | Â | Â | Â | P | Pending |
| Â | Â | Â | Â | Â | Â | E | Error |
| Â | Â | Â | Â | Â | Â | T | Temporary Error |
| Â | Â | Â | Â | Â | Â | O | OK |
| Â | Â | Â | Â | Â | Â | S | Sent |
| Â | Â | Â | Â | Â | Â | R | Document Error |
| Â | Â | Â | Â | Â | Â | W | Waiting |
| Â | Â | Â | Â | Â | Â | A | Authorized |
| Â | Â | Â | Â | Â | Â | I | In Process |
| Â | Â | Â | Â | Â | Â | J | Rejected |
| Â | Â | Â | Â | Â | Â | D | Denied |
| Â | Â | Â | Â | Â | Â | C | Canceled |
| Â | Â | Â | Â | Â | Â | B | Aborted |
| Â | Â | Â | Â | Â | Â | Q | Queued |
| Â | Â | Â | Â | Â | Â | M | Imported |
| Â | Â | Â | Â | Â | Â | G | Warning |
| Â | Â | Â | Â | Â | Â | V | Approved |
| Â | Â | Â | Â | Â | Â | F | Approving |
| Â | Â | Â | Â | Â | Â | H | Rejecting |
| Â | Â | Â | Â | Â | Â | K | Generated |
| Â | Â | Â | Â | Â | Â | Y | Ready to Process |
| Â | Â | Â | Â | Â | Â | L | Determined |
| ActMessage | Action Message | nVarChar | 254 | - | Â | Â | Â |
| TestMode | Test Mode | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| GUID | GUID | nVarChar | 100 | - | Â | Â | Â |
| Authority | Authorities Code | nVarChar | 16 | - | Â | Â | Â |
| ProcSource | Processing Source | nVarChar | 20 | - | Â | Â | Â |
| MetaData | Metadata | Text | 16 | - | Â | Â | Â |
| MIMEType | MIME Type | nVarChar | 128 | - | Â | Â | Â |
| FileName | File Name | Text | 16 | - | Â | Â | Â |
| CardCode | BP Code | nVarChar | 15 | - | Â | Â | Â |
| DocDate | Document Date | Date | 8 | - | Â | Â | Â |
| ObjType | Object Type | nVarChar | 20 | - | Â | Â | Â |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| CreateTS | Creation Time - Incl. Secs. | Int | 11 | - | Â | Â | Â |
| UpdateDate | Update Date | Date | 8 | - | Â | Â | Â |
| UpdateTS | Update Time - Incl. Secs. | Int | 11 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | - | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | - | Â | Â | Â |
| AssignedID | Assigned ID | nVarChar | 100 | - | Â | Â | Â |
| IsBPManual | BP is Set Manually | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| ACTION | Yes | Code |
| Â | Â | AbsEntry |