|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Legal List Format
Table Name: OLLF
Table Description: Legal List Format
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| Name | Electronic File Name | nVarChar | 100 | - | Â | Â | Â |
| Descr | Electronic File Description | nVarChar | 250 | - | Â | Â | Â |
| MenuGuid | GUID of Menu Entry | nVarChar | 32 | - | Â | Â | Â |
| Version | Electronic File Version | nVarChar | 5 | - | Â | Â | Â |
| SchVersion | Electronic File Schema Version | nVarChar | 5 | - | Â | Â | Â |
| OutPath | Output Path | Text | 16 | - | Â | Â | Â |
| FrmId | OFRM Internal ID | Int | 11 | OFRM | Â | Â | Â |
| UpdateNum | Update Count | Int | 11 | - | 0 | Â | Â |
| MenuName | Menu Name | nVarChar | 100 | - | Â | Â | Â |
| MenuPath | Menu Path | nVarChar | 250 | - | Â | Â | Â |
| Assigned | Format Status | nVarChar | 10 | - | N | A | Assigned |
| Â | Â | Â | Â | Â | Â | N | Not Assigned |
| Â | Â | Â | Â | Â | Â | D | Deleted |
| SboVersion | Compatible Release Version | nVarChar | 13 | - | Â | Â | Â |
| Type | Format Type | nVarChar | 5 | - | L | AR | Electronic Document |
| Â | Â | Â | Â | Â | Â | L | Generic Electronic File |
| Â | Â | Â | Â | Â | Â | LI | Generic Electronic File for Intrastat |
| Â | Â | Â | Â | Â | Â | ARA | Electronic Authority Report |
| Â | Â | Â | Â | Â | Â | INTER | Internally Used |
| Â | Â | Â | Â | Â | Â | IM | Electronic Document - Input Message |
| Â | Â | Â | Â | Â | Â | GD | General Electronic Document |
| Â | Â | Â | Â | Â | Â | GWS | General Mapping for Web Service |
| Â | Â | Â | Â | Â | Â | GI | General Mapping for Document Import |
| Â | Â | Â | Â | Â | Â | NFeD | NF-e Invoice Document |
| Â | Â | Â | Â | Â | Â | NFeC | NF-e Cancelation Document |
| Â | Â | Â | Â | Â | Â | NFeS | NF-e Number Skipping Request |
| Â | Â | Â | Â | Â | Â | NFeWS | Web Service Mapping |
| Â | Â | Â | Â | Â | Â | CFDD | CFDi Electronic Document |
| Â | Â | Â | Â | Â | Â | CFDP | CFDi Electronic Payment & Reconciliation Document |
| Â | Â | Â | Â | Â | Â | CFDT | CFDI Electronic Transfer Document |
| Â | Â | Â | Â | Â | Â | CFDIM | CFDI Electronic Input Message Document |
| Â | Â | Â | Â | Â | Â | CFDWS | CFDi Electronic Mapping for Web Service |
| Â | Â | Â | Â | Â | Â | EETD | EET Electronic Document |
| Â | Â | Â | Â | Â | Â | EETWS | EET Electronic Mapping for Web Service |
| Â | Â | Â | Â | Â | Â | FPAD | FatturaPA Electronic Document |
| Â | Â | Â | Â | Â | Â | FPAPD | "FatturaPA" Electronic Purchasing Document |
| Â | Â | Â | Â | Â | Â | FPAI | FatturaPA Electronic Document for Import |
| Â | Â | Â | Â | Â | Â | FPAWS | FatturaPA Electronic Mapping for Web Service |
| Â | Â | Â | Â | Â | Â | MTDR | Making Tax Digital Report Submission |
| Â | Â | Â | Â | Â | Â | MTDWS | Making Tax Digital Mapping for Web Service |
| Â | Â | Â | Â | Â | Â | EISD | Electronic Document |
| Â | Â | Â | Â | Â | Â | EISWS | Electronic Document Web Service |
| Â | Â | Â | Â | Â | Â | IISD1 | Electronic Document for IIS INV |
| Â | Â | Â | Â | Â | Â | IISD2 | Electronic Document for IIS PCH |
| Â | Â | Â | Â | Â | Â | IISD3 | Electronic Document for IIS Deferred |
| Â | Â | Â | Â | Â | Â | IISD4 | Electronic Document for IIS JE |
| Â | Â | Â | Â | Â | Â | IISD5 | Electronic Document for IIS JE Received |
| Â | Â | Â | Â | Â | Â | IISWS | Electronic Document for IIS Web Service |
| Â | Â | Â | Â | Â | Â | ANND1 | Electronic Document for IIS Annual |
| Â | Â | Â | Â | Â | Â | ANND2 | Electronic Document for IIS Annual Cancel |
| Â | Â | Â | Â | Â | Â | ANNWS | Electronic Document for IIS Annual Web Service |
| Â | Â | Â | Â | Â | Â | PPLD | Electronic Document for PEPPOL Invoice |
| Â | Â | Â | Â | Â | Â | PPLWS | Electronic Document for PEPPOL Web Service |
| Â | Â | Â | Â | Â | Â | PPLCM | Electronic Document for PEPPOL Credit Note |
| Â | Â | Â | Â | Â | Â | PPLI | Electronic Document for PEPPOL Import |
| Â | Â | Â | Â | Â | Â | EBKD | Electronic Document for E-Books |
| Â | Â | Â | Â | Â | Â | EBKI | Electronic Document for E-Books Income Classification |
| Â | Â | Â | Â | Â | Â | EBKE | Electronic Document for E-Books Expense Classification |
| Â | Â | Â | Â | Â | Â | EBKR | Electronic Document for E-Books Request Documents |
| Â | Â | Â | Â | Â | Â | EBKRS | Electronic Document for E-Books Request Submitted Documents |
| Â | Â | Â | Â | Â | Â | EBKC | Electronic Document for Cancellation |
| Â | Â | Â | Â | Â | Â | EBKW | Electronic Document for E-Books Web Service |
| Â | Â | Â | Â | Â | Â | DOXD | Electronic Document for Document Information Extraction |
| Â | Â | Â | Â | Â | Â | DOXI | Electronic Document for Document Information Extraction Import |
| Â | Â | Â | Â | Â | Â | EWBD | Electronic Document for E-Way Bill |
| Â | Â | Â | Â | Â | Â | EINVD | Electronic Document for E-Billing |
| Â | Â | Â | Â | Â | Â | RTIED | Electronic Document for RTIE |
| Â | Â | Â | Â | Â | Â | RCTED | Electronic Correction Document for RTIE |
| Â | Â | Â | Â | Â | Â | RTIWS | Electronic Document for RTIE Web Service |
| Â | Â | Â | Â | Â | Â | AFED | Electronic Documents for Argentina |
| Â | Â | Â | Â | Â | Â | TROD | Electronic Transportation Documents for Argentina |
| Â | Â | Â | Â | Â | Â | AFEWS | Electronic Documents for Argentina Web Service |
| Â | Â | Â | Â | Â | Â | KSeF | KSeF Document for Poland |
| Â | Â | Â | Â | Â | Â | GST58 | GST Returns for BAS Report F5 F8 |
| Â | Â | Â | Â | Â | Â | GST7 | GST Returns for BAS Report F7 |
| Â | Â | Â | Â | Â | Â | SAFT | Report SAF-T for Portugal |
| Â | Â | Â | Â | Â | Â | SkatR | Electronic Document for RSU Gateway Report Submission |
| Â | Â | Â | Â | Â | Â | ILED | Electronic Document for Israel |
| Â | Â | Â | Â | Â | Â | PTSig | Portugal E-docs Signing Process |
| Â | Â | Â | Â | Â | Â | FEAP | Portugal Electronic Invoicing in Public Administration |
| Â | Â | Â | Â | Â | Â | VFact | Veri*factu Document for Spain |
| Â | Â | Â | Â | Â | Â | XMLD | Electronic Document PDF with XML Attachment |
| Â | Â | Â | Â | Â | Â | CAEAR | Electronic Document for Argentina CAEA Request |
| Â | Â | Â | Â | Â | Â | FReIN | Electronic Invoice in France |
| Â | Â | Â | Â | Â | Â | euBP | Electronic Tax Audit Document for Germany |
| SubType | Format Subtype | nVarChar | 6 | - | Â | Â | None |
| Â | Â | Â | Â | Â | Â | I | Intrastat |
| Â | Â | Â | Â | Â | Â | N | Normal Generic File Format |
| FileName | File Name | Text | 16 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| NAME | Yes | Name |