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

AR150     AR42.2    AR42.7    AR560     AR90.1    BR11.1
PHI3.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
Accounts Receivable    This field contaiins the cash code
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: Invoice Type  This field contains the default invoice
                       type used when interfacing the actual
                       charges into the Billng system.

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

FRO-UOM                Alpha 4
Element: Unit of MeasurThis 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: Invoice PrefixThis 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
Accounts Receivable    This field contains the reason code,
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                                                AR150   AR42.2
                                                                 AR42.7  AR560
                                                                 AR90.1  BR11.1
                                                                 PHI3.1  WH20.7

                         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