|
|
SAP Business One SDK 10.0 - Database Tables Reference |
File Format
Table Name: OFRM
Table Description: File Format
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| Name | File Format Name | nVarChar | 100 | - | Â | Â | Â |
| Encoding | Encoding Type | nVarChar | 100 | - | Â | Â | Â |
| FilePath | Format Project | Text | 16 | - | Â | Â | Â |
| IsSystem | System Format | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| FrmatType | Format Type | VarChar | 1 | - | O | I | Bank Statements |
| Â | Â | Â | Â | Â | Â | O | Payment File |
| Â | Â | Â | Â | Â | Â | L | Legal List |
| Â | Â | Â | Â | Â | Â | P | Predefined |
| Â | Â | Â | Â | Â | Â | B | Boleto File |
| Â | Â | Â | Â | Â | Â | R | Padron File |
| FileContnt | Format Project Content | Text | 16 | - | Â | Â | Â |
| FrmatStats | Format Status | VarChar | 1 | - | U | A | Assigned |
| Â | Â | Â | Â | Â | Â | U | Unassigned |
| PaymType | Payment Type | VarChar | 1 | - | X | O | Outgoing |
| Â | Â | Â | Â | Â | Â | I | Incoming |
| Â | Â | Â | Â | Â | Â | X | Â |
| Hash | Binary Content Hash | nVarChar | 128 | - | Â | Â | Â |
| FileName | File Name | Text | 16 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| NAME_TYPE | No | Name |
| Â | Â | FrmatType |