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

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
Name KEYFile Format NamenVarChar
100
NAME_TYPENo
EncodingEncoding TypenVarChar
100
FilePathFormat ProjectText
16
IsSystemSystem FormatVarChar
Y) Yes
N) No
1
N
FrmatTypeFormat TypeVarChar
I) Bank Statements
O) Payment File
L) Legal List
P) Predefined
B) Boleto File
R) Padron File
1
O
FileContntFormat Project ContentText
16
FrmatStatsFormat StatusVarChar
A) Assigned
U) Unassigned
1
U
PaymTypePayment TypeVarChar
O) Outgoing
I) Incoming
X)
1
X

SELECT statement

SELECT OFRM.AbsEntry AS 'Internal Number', OFRM.Name AS 'File Format Name', OFRM.Encoding AS 'Encoding Type', OFRM.FilePath AS 'Format Project', OFRM.IsSystem AS 'System Format', OFRM.FrmatType AS 'Format Type', OFRM.FileContnt AS 'Format Project Content', OFRM.FrmatStats AS 'Format Status', OFRM.PaymType AS 'Payment Type' FROM OFRM AS OFRM

Related information


Format ID FormatID Property· Table: OFRM
The format ID. This is a foreign key to the File Format table (OFRM). Field name: FrmId.
   Parent: Electronic File Format ElectronicFileFormat Object· Table: OLLF
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