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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
FROSET1 |
| 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 |
| |||||||
| Iccompany | ICCOMPANY | Required |
| |||||||
| Iclocation | ICLOCATION | Required |
| |||||||
| Icvaluom | ICVALUOM | Required |
| |||||||
| Oecompany | OECOMPANY | Required |
| |||||||
| Oeinvctype | OEINVCTYPE | Required |
| |||||||
| Oeproclev | OEPROCLEV | Required |
|
Programs
No Lawson programs are documented as updating or referencing this table.