biuan SAP® BUSINESS ONE SDK
SQL Administration / Legal List Format / Legal List Format
DTW Inventory / Item Master Data / Legal List Format
API Electronic File Formats Service / Electronic File Format
OLLF - Legal List Format Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
NameElectronic File NamenVarChar
100
DescrElectronic File DescriptionnVarChar
127
MenuGuidGUID of Menu EntrynVarChar
32
VersionElectronic File VersionnVarChar
5
SchVersionElectronic File Schema VersionnVarChar
5
OutPathOutput PathText
16
FrmIdOFRM Internal IDInt
11OFRM
File Format
UpdateNumUpdate CountInt
11
0
MenuNameMenu NamenVarChar
100
MenuPathMenu PathnVarChar
127
AssignedFormat StatusnVarChar
A) Assigned
N) Not Assigned
D) Deleted
10
N
SboVersionCompatible Release VersionnVarChar
11
TypeFormat TypenVarChar
AR) Electronic Document
L) Generic Electronic File
ARA) Electronic Authority Report
INTER) Internally Used
IM) Electronic Document - Input Message
NFeD) NF-e Invoice Document
NFeC) NF-e Cancelation Document
NFeS) NF-e Number Skipping Request
5
L
SubTypeFormat SubtypenVarChar
6

Table relationship map

SELECT statement

SELECT OLLF.AbsEntry AS 'Internal Number', OLLF.Name AS 'Electronic File Name', OLLF.Descr AS 'Electronic File Description', OLLF.MenuGuid AS 'GUID of Menu Entry', OLLF.Version AS 'Electronic File Version', OLLF.SchVersion AS 'Electronic File Schema Version', OLLF.OutPath AS 'Output Path', OLLF.FrmId AS 'OFRM Internal ID', OLLF.UpdateNum AS 'Update Count', OLLF.MenuName AS 'Menu Name', OLLF.MenuPath AS 'Menu Path', OLLF.Assigned AS 'Format Status', OLLF.SboVersion AS 'Compatible Release Version', OLLF.Type AS 'Format Type', OLLF.SubType AS 'Format Subtype' FROM OLLF AS OLLF

Related information


Electronic File Format ElectronicFileFormat Object· Table: OLLF
Represents the generic electronic file formats in SAP Business One. Source table: OLLF.
   Parent: Electronic File Formats Service ElectronicFileFormatsService Service· Table: OLLF

Electronic File Formats Service ElectronicFileFormatsService Service· Table: OLLF
The ElectronicFileFormatsService service enables you to import, look up, and delete the generic electronic file formats in SAP Business One. Source table: OLLF.

OLLF SQL Table

File Format OFRM SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates