|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Export Mapping Determination
Table Name: AEC7
Table Description: Export Mapping Determination
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal ID | Int | 11 | - | Â | Â | Â |
| Code | Protocol Code | Int | 11 | OECM | Â | 0 | Invalid |
| Â | Â | Â | Â | Â | Â | 1 | GEN |
| Â | Â | Â | Â | Â | Â | 2 | EET |
| Â | Â | Â | Â | Â | Â | 3 | CFDI |
| Â | Â | Â | Â | Â | Â | 4 | FPA |
| Â | Â | Â | Â | Â | Â | 5 | MTD |
| Â | Â | Â | Â | Â | Â | 6 | EWB |
| Â | Â | Â | Â | Â | Â | 7 | PEPPOL |
| Â | Â | Â | Â | Â | Â | 8 | HOI |
| Â | Â | Â | Â | Â | Â | 9 | MYF |
| Â | Â | Â | Â | Â | Â | 10 | EIS |
| Â | Â | Â | Â | Â | Â | 11 | IIS |
| Â | Â | Â | Â | Â | Â | 12 | IIS_ANNUAL |
| Â | Â | Â | Â | Â | Â | 13 | DIGIPOORT |
| Â | Â | Â | Â | Â | Â | 14 | E-Books |
| Â | Â | Â | Â | Â | Â | 15 | DOX |
| Â | Â | Â | Â | Â | Â | 16 | RTIE |
| Â | Â | Â | Â | Â | Â | 17 | E-Billing |
| Â | Â | Â | Â | Â | Â | 18 | Tax Service |
| Â | Â | Â | Â | Â | Â | 19 | AFE |
| Â | Â | Â | Â | Â | Â | 20 | Document Signature |
| Â | Â | Â | Â | Â | Â | 21 | KSeF |
| Â | Â | Â | Â | Â | Â | 22 | GSTReturn |
| Â | Â | Â | Â | Â | Â | 23 | PT Document Signature |
| Â | Â | Â | Â | Â | Â | 24 | Skat DK |
| Â | Â | Â | Â | Â | Â | 25 | EII |
| Â | Â | Â | Â | Â | Â | 26 | NFe |
| Â | Â | Â | Â | Â | Â | 27 | PT eInvoicing |
| Â | Â | Â | Â | Â | Â | 28 | PT Electronic Communications |
| Â | Â | Â | Â | Â | Â | 29 | Veri*factu |
| Â | Â | Â | Â | Â | Â | 30 | BAS |
| Â | Â | Â | Â | Â | Â | 31 | PDF with XML Attachment |
| Â | Â | Â | Â | Â | Â | 32 | FReINV |
| Â | Â | Â | Â | Â | Â | 33 | euBP |
| Â | Â | Â | Â | Â | Â | 34 | ILOI |
| Â | Â | Â | Â | Â | Â | 35 | EDGT |
| Â | Â | Â | Â | Â | Â | 36 | EDCR |
| Â | Â | Â | Â | Â | Â | 37 | NAV |
| Priority | Determination Priority | Int | 11 | - | Â | Â | Â |
| BPCode | Customer/Vendor Code | nVarChar | 15 | OCRD | Â | Â | Â |
| Country | Country/Region | nVarChar | 3 | OCRY | Â | Â | Â |
| Serie | Digital Series | Int | 11 | NNM1 | -1 | Â | Â |
| DocType | Document 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 |
| Â | Â | Â | Â | Â | Â | 67 | Inventory Transfers |
| Â | Â | Â | Â | Â | Â | 15 | Deliveries |
| Â | Â | Â | Â | Â | Â | 16 | Returns |
| Â | Â | Â | Â | Â | Â | 14 | A/R Credit Memos |
| Â | Â | Â | Â | Â | Â | 13 | A/R Invoices |
| DocSubType | Document Subtype | nVarChar | 2 | - | -- | -- | Â |
| Â | Â | Â | Â | Â | Â | AR | All A/R Documents |
| Â | Â | Â | Â | Â | Â | AP | All A/P Documents |
| ExportFmt | Export 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 | - | Â | Â | Â |
| FileNP | File Name and Path | Text | 16 | - | Â | Â | Â |
| VersionNum | Version Number | Int | 11 | - | Â | Â | Â |
| EIIAction | EII Invoice Action | VarChar | 1 | - | S | S | Send |
| Â | Â | Â | Â | Â | Â | D | Decision |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |