FROPTIONS – FR Company Options
- System
- FR (FR)
- Prefix
FRO- Primary key
COMPANY- Fields
- 18
- Updated by
- 0 programs
- Referenced by
- 0 programs
FROPTIONS is the FR Company Options table in Lawson FR (prefix FRO). It is indexed by COMPANY (FROSET1). It is related 1:1 to ARCOMP, ICCOMPANY, ICLOCATION, ICVALUOM, OECOMPANY, OEINVCTYPE and OEPROCLEV. The table has 18 fields, 1 index and 7 documented relations.
About FROPTIONS
This file contains certain company options that are required for interfacing with the Lawson Billing system.
Fields (18)
Column = COBOL field name without the FRO- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
FRO-COMPANY PKCOMPANY | Numeric 4 | This field contains the company number defined in the General Ledger, Account Receivable, and Billing systems. | — |
FRO-CASH-CODECASH_CODE | Alpha 4 | This field contaiins the cash code defined in the Accounts Receivable system, which determines the cash account used when entering a note prepayment. | — |
FRO-PROCESS-LEVELPROCESS_LEVEL | Alpha 5 | This field contains the process level, which is the reporting hierarchy below company. | — |
FRO-INVC-TYPEINVC_TYPE | Alpha 4 | This field contains the default invoice type used when interfacing the actual charges into the Billng system. | — |
FRO-LOCATIONLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | — |
FRO-UOMUOM | Alpha 4 | This field contains the valid stock unit of measure for this item. | — |
FRO-CURRENT-YEARCURRENT_YEAR | Numeric 4 | This field contains the value for the current fiscal year. For example, the current year might be 1999. | — |
FRO-PREVIOUS-YEARPREVIOUS_YEAR | Numeric 4 | This field contains the value for the previous fiscal year. For example, if the current year is 1999, the previous year would be 1998. | — |
FRO-NEXT-YEARNEXT_YEAR | Numeric 4 | This field contains the next fiscal year. For example, if the current year is 1999, the next year would be 2000. | — |
FRO-LST-INVC-NBRLST_INVC_NBR | Numeric 8 | This field contains the last invoice number for invoices generated from the Franchise Management System. This counter is used if Franchise Management processing occurs at the company level. | — |
FRO-INVC-PREFIXINVC_PREFIX | Alpha 2 | This field contains the invoice prefix that is assigned from either the company or process level, depending on the invoice-level option chosen. | — |
FRO-CR-INVC-TYPECR_INVC_TYPE | Alpha 4 | — | — |
FRO-CR-INVC-PREFIXCR_INVC_PREFIX | Alpha 2 | — | — |
FRO-LST-CR-NBRLST_CR_NBR | Numeric 8 | — | — |
FRO-REASON-CODEREASON_CODE | Alpha 4 | This field contains the reason code, which indicates the cause for credit memos. | — |
FRO-SALES-FLSALES_FL | Alpha 1 | —
| — |
FRO-CALENDAR-IDCALENDAR_ID | Alpha 10 | — | — |
FRO-SALES-BY-DATESALES_BY_DATE | Alpha 1 | —
| — |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
FROSET1 | COMPANY | Primary | AC56.1, AC560, AR01.1, ARLL.1, BR11.1, BR48.1, WH20.2, WH20.7 |
Relations
One to one (7) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Arcomp | ARCOMP | Required | FRO-COMPANY → -COMPANY | |
| Iccompany | ICCOMPANY | Required | FRO-COMPANY → ICC-COMPANY | |
| Iclocation | ICLOCATION | Required | FRO-COMPANY → ICL-COMPANY, FRO-LOCATION → ICL-LOCATION | |
| Icvaluom | ICVALUOM | Required | ICC-ITEM-GROUP → ICV-ITEM-GROUP, FRO-UOM → ICV-VALID-UOM | |
| Oecompany | OECOMPANY | Required | FRO-COMPANY → OEC-COMPANY | |
| Oeinvctype | OEINVCTYPE | Required | FRO-COMPANY → OIN-COMPANY, FRO-INVC-TYPE → OIN-INVC-TYPE | |
| Oeproclev | OEPROCLEV | Required | FRO-COMPANY → OEP-COMPANY, FRO-PROCESS-LEVEL → OEP-PROCESS-LEVEL |
Programs
No Lawson programs are documented as updating or referencing this table.