|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Import Mapping Determination
Table Name: AEC4
Table Description: Import Mapping Determination
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal ID | Int | 11 | - | Â | Â | Â |
| Code | Code | nVarChar | 8 | OECM | Â | Â | Â |
| LineNum | Row Number | Int | 11 | - | Â | Â | Â |
| ObjType | Object Type | nVarChar | 20 | - | -1 | 18 | A/P Invoice |
| Â | Â | Â | Â | Â | Â | 19 | A/P Credit Memo |
| Â | Â | Â | Â | Â | Â | 204 | A/P Down Payment |
| Â | Â | Â | Â | Â | Â | 163 | A/P Correction Invoice |
| Â | Â | Â | Â | Â | Â | 164 | A/P Correction Invoice Reversal |
| Â | Â | Â | Â | Â | Â | 20 | Goods Receipt PO |
| Â | Â | Â | Â | Â | Â | 21 | Goods Return |
| Â | Â | Â | Â | Â | Â | 24 | Incoming Payment |
| Â | Â | Â | Â | Â | Â | 46 | Outgoing Payment |
| ObjXPath | Object Type XPath | nVarChar | 254 | - | Â | Â | Â |
| FieldType | Field Type | VarChar | 1 | - | T | T | Federal Tax ID |
| Â | Â | Â | Â | Â | Â | A | Additional ID |
| Â | Â | Â | Â | Â | Â | U | Unified Federal Tax ID |
| Â | Â | Â | Â | Â | Â | C | CNPJ |
| Â | Â | Â | Â | Â | Â | L | Alias Name |
| Â | Â | Â | Â | Â | Â | I | IBAN |
| Â | Â | Â | Â | Â | Â | N | BP Name |
| FieldXPath | Field XPath | nVarChar | 254 | - | Â | Â | Â |
| ImportFmt | Import Format | Int | 11 | OLLF | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | OUSR | Â | Â | Â |
| UpdateDate | Update Date | Date | 8 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 6 | - | Â | Â | Â |
| DflDSerie | Default Digital Series | Int | 11 | NNM1 | -1 | Â | Â |
| VersionNum | Version Number | Int | 11 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | LogInstanc |