Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FRSALES


                              FRSALES FILE

                          FR Sales Remittance

This file contains the sales remittance header data.  Individual charges are
defined to the FRCYCCHG file.

REFERENCED BY

AR150

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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


FRL-CUSTOMER           Alpha 9  (Right Justified)
Element: Customer NumbeThis field contains the customer number
                       defined in the Accounts receivable
                       system.


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


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


FRL-SALES-TYPE         Alpha 1
Element: Sales Type    This field contains the type of
                       invoice. An invoice can exist for all
                       three types for a given period, however,
                       only one can be active.

                       A = Actual Invoice
                       C = Call-In Estimate
                       E = Estimated Invoice
                       S = Aggregate Sales

FRL-DATE               Numeric 8  (yyyymmdd)
Element: Date          This date must match a valid cycle date
                       specified in FR00.1 (Calendar).


FRL-ADJ-NBR            Numeric 3
Element: Adj Nbr

FRL-FISCAL-YEAR        Numeric 4
Element: Last Closed YeThis is the current fiscal year.  This
                       field is updated by Period Closing
                       (GL199).

FRL-FISCAL-MONTH       Numeric 2
Element: Fiscal Month  This field contains the number for the
                       fiscal month.

FRL-CYCLE-NBR          Numeric 2
Element: Cycle Number  This field contains the number of the
                       cycle.  A cycle number displays in
                       FR00.1 (Calendar) for each cycle date
                       field.

FRL-STATUS             Numeric 1
Element: Status        This field displays the status of the
                       transaction.
                       0 = Unreleased
                       1 = Released
                       2 = Invoiced
                       9 = Closed

FRL-REGISTER-CLOSE     Signed 18.2
Element: Closing RegistThis field contains the closing register
                       amount.

FRL-SALES-TAX          Signed 18.2
Element: Sales Tax     This field contains the submitted sales
                       tax amount from the franchisee.

FRL-ADJUSTMENTS        Signed 18.2
Element: Adjustments   This field allows entry of adjustments
                       such as overrings.

FRL-NET-SALES          Signed 18.2
Element: Net Sales     This field contains the submitted net
                       sales figure from the franchisee.

FRL-TTL-REG-CLOSE      Signed 18.2
Element: Intl Amt

FRL-TTL-SALES-TAX      Signed 18.2
Element: Intl Amt

FRL-TTL-ADJUSTMENT     Signed 18.2
Element: Intl Amt

FRL-TTL-NET-SALES      Signed 18.2
Element: Intl Amt

FRL-TTL-CHARGES        Signed 18.2
Element: Total Charges This field contains the total of the
                       calculated charges for the invoice.

FRL-TTL-DUE            Signed 18.2
Element: Total Due     This field contains the amount due for
                       the invoice.  It will equal the total
                       charges, unless a line was overridden.

FRL-TTL-VARIANCE       Signed 18.2
Element: Total VarianceThis field contains the calculated
                       difference between the total subnmitted
                       charges and the total calculated
                       charges.

FRL-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.

FRL-INVC-NUMBER        Numeric 8
Element: Invoice NumberThis field contains the invoice number
                       assigned by the system.  Invoice numbers
                       are assigned at the company or process
                       level, depending on an invoice-level
                       option on the company file.

FRL-ENTER-CHG-FL       Alpha 1
Element: Enter Charge FThis field indicates whether the user
                       must define submitted charges for the
                       remittance.
                       Y = Yes
                       N = No

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

FRL-POST-DATE          Numeric 8  (yyyymmdd)
General Ledger         The date general ledger entries for the
Posting Date           transaction will be posted to the
                       general ledger.


                         FRSALES FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FRLSET1   COMPANY
          CUSTOMER
          SHIP-TO
          CONTR-NBR
          SALES-TYPE
          DATE
          ADJ-NBR

FRLSET2   COMPANY       KeyChange, Subset                        AR150
          CUSTOMER      Where SALES-TYPE != "A"
          SHIP-TO       And   STATUS     =  1
          CONTR-NBR
          DATE
          SALES-TYPE
          ADJ-NBR

FRLSET3   COMPANY       KeyChange, Subset
          CUSTOMER      Where SALES-TYPE != "E"
          SHIP-TO       And   STATUS     >  Zeroes
          CONTR-NBR*
          DATE*
          SALES-TYPE
          ADJ-NBR

FRLSET4   COMPANY       KeyChange, Subset
          CUSTOMER      Where SALES-TYPE = "A"
          SHIP-TO       And   STATUS     = 1
          CONTR-NBR
          DATE
          SALES-TYPE
          ADJ-NBR

FRLSET5   COMPANY       KeyChange, Subset
          CUSTOMER      Where SALES-TYPE = "A"
          SHIP-TO       And   STATUS     < 2
          CONTR-NBR
          DATE
          SALES-TYPE
          ADJ-NBR

FRLSET6   COMPANY       Subset
          CUSTOMER      Where SALES-TYPE = "S"
          SHIP-TO
          CONTR-NBR
          DATE
          ADJ-NBR
          SALES-TYPE

FRLSET7   COMPANY       KeyChange, Subset
          CUSTOMER      Where STATUS < 2
          SHIP-TO
          CONTR-NBR
          DATE
          SALES-TYPE
          ADJ-NBR

FRLSET9   COMPANY
          CUSTOMER
          SHIP-TO
          CONTR-NBR
          DATE
          SALES-TYPE
          ADJ-NBR

                         FRSALES FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            FRL-COMPANY       -> ACO-COMPANY  (ACOSET1)

Custdesc       CUSTDESC     Required

                            ACO-CUST-GROUP    -> CUD-CUST-GROUP
                            FRL-CUSTOMER      -> CUD-CUSTOMER

Frcontmast     FRCONTMAST   Required

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

Froptions      FROPTIONS    Required

                            FRL-COMPANY       -> FRO-COMPANY

Oecompany      OECOMPANY    Required

                            FRL-COMPANY       -> OEC-COMPANY

Shipto         SHIPTO       Required

                            FRL-COMPANY       -> SHP-COMPANY
                            FRL-CUSTOMER      -> SHP-CUSTOMER
                            FRL-SHIP-TO       -> SHP-SHIP-TO