Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FRCONTMAST


                            FRCONTMAST FILE

                           FR Contract Master

This is the contract master. It is specific to a customer and ship-to.

REFERENCED BY

AR150

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

FRM-CUSTOMER           Alpha 9  (Right Justified)
Element: Customer      This field contains the customer number
                       defined in the Accounts Receivable
                       system.

FRM-SHIP-TO            Numeric 4
Element: Ship To       This field contains the customer ship-to
                       number defined in the Billing system.

FRM-CONTR-NBR          Numeric 6
Element: Contr Nbr     This field contains the number
                       representing the business agreement and
                       terms between the franchiser and
                       franchisee.

FRM-ACTIVE-FLAG        Alpha 1
Element: Active Flag   This determines if the contract is
                       active or inactive.
                       A = Active
                       I = Inactive

FRM-CONTRACT-DATE      Numeric 8  (yyyymmdd)
Element: Contract Date This field contains the beginning date
                       for the contract.  Charges are processed
                       only after the cycle date is greater
                       than this date.

FRM-TERMINATE-DATE     Numeric 8  (yyyymmdd)
Element: Date          If entered, defines the end date of the
                       contract. Charges will not be processed
                       beyond the termination date.

FRM-GROUP-CODE         Alpha 4
Element: Group Code    This field contains a free-form grouping
                       code, which allows users to run reports
                       for certain sub-groups of contracts.

FRM-TAXABLE-FLAG       Alpha 1
Element: Taxable Flag  Defines if Taxable.
                       E = Exempt
                       T = Taxable

FRM-TAX-CODE           Alpha 10
Element: Tax Code      This field contains a code representing
                       specific tax information.  This must be
                       valid Tax Code.


FRM-LAST-ACT-DATE      Numeric 8  (yyyymmdd)
Element: Last Act Date This field contains the date of the last
                       release for an estimate, call-in
                       estimate, or actual sales record.

FRM-TTL-ESTIMATES      Signed 18.2
Element: Intl Amt      This field contains the total of the
                       outstanding estimates.

FRM-LAST-SEQ           Numeric 3
Element: Seq           This field contains the last sequence
                       number defined for a contract.

FRM-CURRENCY-CODE      Alpha 5
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

FRM-VARIANCE-LIMIT     Signed 18.2
Element: Variance LimitThis field contains the monetary value
                       for the maximum variance allowed between
                       the submitted and calculated sales
                       remittances.

                       The Franchise Management system compares
                       this variance limit with the sum total
                       of all line variances of a remittance.
                       If remittance variance totals are over
                       this limit, the remittance cannot be
                       released when you run FR121 (Release
                       Sales Remittances).  The report
                       generated by FR121 lists each remittance
                       total variance and the contract variance
                       limit stored in this field.

FRM-PROCESS-LEVEL      Alpha 5
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

FRM-CALENDAR-ID        Alpha 10
Element: Calendar Id

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

FRM-SALES-BY-DATE      Alpha 1
Element: Sales By Date

FRM-BUDGET-ID          Alpha 10
Element: Budget Id

FRM-ESTIMATES-FL       Alpha 1
Element: Estimates Fl  A = Estimates from actuals
                       B = Estimates from budget

                         FRCONTMAST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FRMSET1   COMPANY                                                AR150
          CUSTOMER
          SHIP-TO
          CONTR-NBR

FRMSET2   COMPANY       KeyChange, Subset
          GROUP-CODE    Where ACTIVE-FLAG = "A"
          CUSTOMER
          SHIP-TO
          CONTR-NBR

                         FRCONTMAST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            FRM-COMPANY       -> ACO-COMPANY  (ACOSET1)

Arcustomer     ARCUSTOMER   Required

                            FRM-COMPANY       -> ACM-COMPANY
                            FRM-CUSTOMER      -> ACM-CUSTOMER

Custdesc       CUSTDESC     Required

                            ACO-CUST-GROUP    -> CUD-CUST-GROUP
                            FRM-CUSTOMER      -> CUD-CUSTOMER

Oecompany      OECOMPANY    Required

                            FRM-COMPANY       -> OEC-COMPANY

Shipto         SHIPTO       Required

                            FRM-COMPANY       -> SHP-COMPANY
                            FRM-CUSTOMER      -> SHP-CUSTOMER
                            FRM-SHIP-TO       -> SHP-SHIP-TO

                         FRCONTMAST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Frcharge       FRCHARGE

                            FRM-COMPANY       -> FRG-COMPANY
                            FRM-CUSTOMER      -> FRG-CUSTOMER
                            FRM-SHIP-TO       -> FRG-SHIP-TO
                            FRM-CONTR-NBR     -> FRG-CONTR-NBR
                                                 FRG-SEQ

Frsales        FRSALES

                            FRM-COMPANY       -> FRL-COMPANY
                            FRM-CUSTOMER      -> FRL-CUSTOMER
                            FRM-SHIP-TO       -> FRL-SHIP-TO
                            FRM-CONTR-NBR     -> FRL-CONTR-NBR
                                                 FRL-DATE
                                                 FRL-SALES-TYPE
                                                 FRL-ADJ-NBR