Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FRCHARGE


                             FRCHARGE FILE

                               FR Charges

This file contains the charges, defined in FR05.1 (Stardard Sales Based
Charge), FR06.1 (Standard Note Based Charge), or FR07.1 (Stardard Special
Charge) and assigned to the contract.  Use those forms to delete charges from
this file.

Through the use of the Charge Type field, this record handles sales-based,
note-based, and special charges.

UPDATED BY

AR150

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

FRG-CONTR-NBR          Numeric 6
Element: Contract NumbeThis field contains the number
                       representing the business agreement and
                       terms between the franchiser and
                       franchisee.

FRG-CHARGE             Alpha 8
Element: Charge        This field contains a valid charge in
                       the Franchise Management system.

FRG-SEQ                Numeric 3
Element: Sequence      This field contains the record sequence
                       number.  For a given contract, each
                       charge must have a unique sequence
                       number.  This field contains  the sort
                       order in FR20.1 (Sales Remittance).

FRG-DESC               Alpha 30  (Lower Case)
Element: Description   This field contains the charge
                       description.

FRG-CHARGE-TYPE        Numeric 1
Element: Charge Type   This field value indicates whether the
                       charge is a sales-based, note-based, or
                       special charge.
                       1 = Sales-Based
                       2 = Note-Based
                       3 = Special

FRG-BEGIN-DATE         Numeric 8  (yyyymmdd)
Element: Begin Date    This field contains the beginning date
                       of the charge.  Charges are processed
                       only after the cycle date is greater
                       than the beginning date.

FRG-END-DATE           Numeric 8  (yyyymmdd)
Element: End Date      This field contains the ending date of
                       the charge.  Charges are not processed
                       if the cycle date is greater than the
                       ending date, and the ending date is not
                       zeros.

FRG-NEXT-CYC-DATE      Numeric 8  (yyyymmdd)
Element: Next Cycle DatThis field contains the next date that
                       a charge will be processed.  The
                       frequency of the charge determines this
                       date.


FRG-ACTIVE-FLAG        Alpha 1
Element: Status        This field indicates whether the charge
                       is active or inactive.
                       A = Active
                       I = Inactive

FRG-FREQUENCY          Alpha 1
Element: Frequency     This field indicates the charge
                       frequency.  When an estimate is created,
                       the next charge date is incremented
                       based on this value.
                       W = Weekly
                       M = Monthly
                       Q = Quarterly
                       Y = Yearly

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

FRG-INTEREST-RATE      Signed 7.5
Element: Interest Rate This field contains the annual interest
                       rate assiciated with a note-based
                       charge.

FRG-NOTE-AMOUNT        Signed 18.2
Element: Note Amount   This field contains the original amount
                       of a note-based charge.

FRG-CURRENT-BAL        Signed 18.2
Element: Current BalancThis field contains the current balance
                       of a note-based charge.

FRG-CHARGE-TO-DATE     Signed 18.2
Element: Charges To DatThis field contains the cumulative
                       charges to date accrued against a
                       note-based charge.  This reflects both
                       principal and interest.

FRG-PAYMNT-AMT         Signed 18.2
Element: Payment AmountThis field contains the charge amount in
                       currency.

FRG-NBR-OF-PMTS        Numeric 4
Element: Number of PaymThis field contains the original number
                       of payments contracted for a note-based
                       charge.

FRG-REMAINING-PMTS     Numeric 4
Element: Remaining PaymThis field contains the remaining number
                       of payments for a note-based charge.
                       This value is decremented as a cycle is
                       processed.

FRG-CALC-TYPE          Alpha 1
Element: Calculation TyThis field contains the calculation
                       type.

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

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

FRG-MIN-AMOUNT         Signed 18.2
Element: Minimum AmountThis field contains the minimum amount
                       of a sales-based charge.

FRG-MAX-AMOUNT         Signed 18.2
Element: Maximum AmountThis field contains the upper limit of a
                       sales-based charge.

FRG-PERC-OF-SALES      Percent 5.3  (Percent)
Element: Perc Of Sales This field contains the base percentage
                       of sales for a sales-based charge.  It
                       can be overridden with the sliding-scale
                       percentage.

FRG-BASE-AMOUNT        Signed 18.2
Element: Base Amount   This field contains the base amount to
                       be posted to the General Ledger Account
                       Master file.

FRG-STEP-OPERAND       Numeric 1
Element: Scale Optioin This field indicates whether the charge
                       is computed using the percentage defined
                       for the upper limit or using the
                       appropriate step of the sliding scale.
                       0 = Use Highest Step Pct
                       1 = Add Step Values

FRG-STEP-LIMIT         Signed 18.2 Occurs 10 Times
Element: Step Limit    This field contains the upper limit of
                       revenue for a sliding scale.

FRG-STEP-PCT           Percent 5.2  (Percent) Occurs 10 Times
Element: Step PercentagThis field contains the percentage of
                       sales associated with the step of the
                       sliding scale.

FRG-BALANCE-FL         Alpha 1                                   AR150
Element: Balance Flag  This field determines whether or not to
                       print the note balance on the franchisee
                       statement when FR150 (Statement Report)
                       is run.
                       N = No
                       Y = Yes

FRG-ACTIVITY           Alpha 15
Element: Activity      This field contains the activity
                       identifier defined in the Activity
                       Management system.

                       Activities are grouped or organized by
                       activity levels.  There are two kinds of
                       activities: "posting allowed" and
                       "Summary only."  Use posting level
                       activities to budget and maintain all
                       posted tranaactions.  Summary activities
                       or macro activities combine information
                       and balances from lower level activities
                       for reporting and inquiries.

FRG-ACCT-CATEGORY      Alpha 5
Element: Account CategoThis field contains a valid account
                       category defined in the Activity
                       Management system.

FRG-ACC-ACCT-UNIT      Alpha 15
Element: Accrual - AcctThis field contains the accrual
                       accounting unit.

FRG-ACC-ACCOUNT        Numeric 6
Element: Accrual - AccoThis field contains the accrual account.

FRG-ACC-SUB-ACCT       Numeric 4
Element: Accrual - SubaThis field contains the accrual
                       subaccount.

FRG-ACO-ACCT-UNIT      Alpha 15
Accrual Offset -       This field contains the accrual offset
Acct Unit              accounting unit.

FRG-ACO-ACCOUNT        Numeric 6
Accrual Offset -       This field contains the accrual offset
Account                account.

FRG-ACO-SUB-ACCT       Numeric 4
Accrual Offset -       This field contains the accrual offset
Subaccount             subaccount.

FRG-NAC-ACCT-UNIT      Alpha 15
Note Accrual - Acct    This field contains the note accrual
Unit                   accounting unit.

FRG-NAC-ACCOUNT        Numeric 6
Note Accrual -         This field contains the note accrual
Account                account.

FRG-NAC-SUB-ACCT       Numeric 4
Note Accrual -         This field contains the note accrual
Subaccount             subaccount.

FRG-NAO-ACCT-UNIT      Alpha 15
Note Accr Offset -     This field contains the note accrual
Acct Unit              offset accounting unit.

FRG-NAO-ACCOUNT        Numeric 6
Note Accr Offset -     This field contains the note accrual
Account                offset account.

FRG-NAO-SUB-ACCT       Numeric 4
Note Accr Offset -     This field contains the note accrual
Subaccount             offset subaccount.

FRG-REV-ACCT-UNIT      Alpha 15
Element: Sales - Acct UThis field contains the revenue
                       accounting unit.

FRG-REV-ACCOUNT        Numeric 6
Element: Sales - AccounThis field contains the revenue account.

FRG-REV-SUB-ACCT       Numeric 4
Element: Sales - SubaccThis field contains the revenue
                       subaccount.

FRG-NOTE-ACCT-UNIT     Alpha 15
Note Asset - Acct      This field contains the note asset
Unit                   accounting unit.

FRG-NOTE-ACCOUNT       Numeric 6
Element: Note Asset - AThis field contains the note asset
                       account.

FRG-NOTE-SUB-ACCT      Numeric 4
Note Asset -           This field contains the note asset
Subaccount             subaccount.

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

                         FRCHARGE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FRGSET1   COMPANY
          CUSTOMER
          SHIP-TO
          CONTR-NBR
          SEQ

FRGSET2   COMPANY       KeyChange, Subset                        AR150
          CUSTOMER      Where CHARGE-TYPE = 2
          SHIP-TO       And   BALANCE-FL  = "Y"
          CONTR-NBR
          SEQ

                         FRCHARGE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            FRG-COMPANY          -> ACO-COMPANY

Arcustomer     ARCUSTOMER   Required

                            FRG-COMPANY          -> ACM-COMPANY
                            FRG-CUSTOMER         -> ACM-CUSTOMER

Custdesc       CUSTDESC     Required

                            ACO-CUST-GROUP       -> CUD-CUST-GROUP
                            FRG-CUSTOMER         -> CUD-CUSTOMER

Froptions      FROPTIONS    Required

                            FRG-COMPANY          -> FRO-COMPANY

Oecompany      OECOMPANY    Required

                            FRG-COMPANY          -> OEC-COMPANY

Shipto         SHIPTO       Required

                            FRG-COMPANY          -> SHP-COMPANY
                            FRG-CUSTOMER         -> SHP-CUSTOMER
                            FRG-SHIP-TO          -> SHP-SHIP-TO

                         FRCHARGE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Frcontmast     FRCONTMAST

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