Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FROPTIONS


                             FROPTIONS FILE

                           FR Company Options

This file contains certain company options that are required for interfacing
with the Lawson Billing system.

REFERENCED BY

AC56.1    AC560     AR01.1    AR150     AR33.5    AR42.2
AR42.7    AR44.3    AR502     AR560     AR90.1    ARLL.1
BL00.1    BL01.1    BL120     BL121     BL122     BL123
BL130     BL20.1    BL20.3    BL200     BL201     BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
BL98.1    BR11.1    BR48.1    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

FRO-COMPANY            Numeric 4
Element: Company       This field contains the company number
                       defined in the General Ledger, Account
                       Receivable, and Billing systems.

FRO-CASH-CODE          Alpha 4
Element: Cash Code     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-LEVEL      Alpha 5
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

FRO-INVC-TYPE          Alpha 4
Element: Invc Type     This field contains the default invoice
                       type used when interfacing the actual
                       charges into the Billng system.

FRO-LOCATION           Alpha 5
Element: Location      This field contains a valid stocking
                       location within the company inventory.

FRO-UOM                Alpha 4
Element: Uom           This field contains the valid stock
                       unit of measure for this item.


FRO-CURRENT-YEAR       Numeric 4
Element: Current Year  This field contains the value for the
                       current fiscal year.  For example, the
                       current year might be 1999.

FRO-PREVIOUS-YEAR      Numeric 4
Element: Previous Year 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-YEAR          Numeric 4
Element: Next Year     This field contains the next fiscal
                       year.  For example, if the current year
                       is 1999, the next year would be 2000.

FRO-LST-INVC-NBR       Numeric 8
Element: Invc Number   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-PREFIX        Alpha 2
Element: Invc Prefix   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-TYPE       Alpha 4
Element: Cr Invc Type

FRO-CR-INVC-PREFIX     Alpha 2
Element: Cr Invc Prefix

FRO-LST-CR-NBR         Numeric 8
Element: Lst Cr Nbr

FRO-REASON-CODE        Alpha 4
Element: Reason Code   This field contains the reason code,
                       which indicates the cause for credit
                       memos.

FRO-SALES-FL           Alpha 1
Element: Sales Fl      Y = Yes
                       N = No

FRO-CALENDAR-ID        Alpha 10
Element: Calendar Id

FRO-SALES-BY-DATE      Alpha 1
Element: Sales By Date Y = Yes
                       N = No

                         FROPTIONS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FROSET1   COMPANY                                                AC56.1  AC560
                                                                 AR01.1  AR150
                                                                 AR33.5  AR42.2
                                                                 AR42.7  AR44.3
                                                                 AR502   AR560
                                                                 AR90.1  ARLL.1
                                                                 BL00.1  BL01.1
                                                                 BL120   BL121
                                                                 BL122   BL123
                                                                 BL130   BL20.1
                                                                 BL20.3  BL200
                                                                 BL201   BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 ...

                         FROPTIONS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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