|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Already Displayed 347, 349 and WTax Reports
Table Name: ORFL
Table Description: Already Displayed 347, 349 and WTax Reports
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ReportType | Report Type | Int | 11 | - | Â | 1 | 347 |
| Â | Â | Â | Â | Â | Â | 2 | 349 |
| Â | Â | Â | Â | Â | Â | 3 | WT |
| Â | Â | Â | Â | Â | Â | 4 | O & P |
| Â | Â | Â | Â | Â | Â | 5 | Annual List |
| Â | Â | Â | Â | Â | Â | 6 | Tax Report |
| DocType | Document Type | nVarChar | 20 | - | Â | 13 | Invoice |
| Â | Â | Â | Â | Â | Â | 14 | Revert Invoice |
| Â | Â | Â | Â | Â | Â | 18 | Purchase |
| Â | Â | Â | Â | Â | Â | 19 | Revert purchase |
| Â | Â | Â | Â | Â | Â | 203 | A/R Down Payment |
| Â | Â | Â | Â | Â | Â | 204 | A/P Down Payment |
| DocEntry | Document Internal ID | Int | 11 | - | Â | Â | Â |
| LineNum | Row No. | Int | 11 | - | Â | Â | Â |
| TaxCode | Tax Code | nVarChar | 8 | - | Â | Â | Â |
| OrdinalNum | Ordinal Num (BTF & Cancelled) | Int | 11 | - | -1 | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | ReportType |
| Â | Â | DocType |
| Â | Â | LineNum |
| Â | Â | TaxCode |
| Â | Â | OrdinalNum |