Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FRISALES


                             FRISALES FILE

UPDATED BY

AR570

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

FRI-COMPANY            Numeric 4                                 AR570
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

FRI-CUSTOMER           Alpha 9  (Right Justified)                AR570
Element: Customer      This field contains the number that
                       represents a customer.

FRI-SHIP-TO            Numeric 4                                 AR570
Element: Ship To       This field contains the number
                       representing the ship to customer.

FRI-CONTR-NBR          Numeric 6                                 AR570
Element: Contr Nbr     This field contains the contract number.


FRI-SALES-TYPE         Alpha 1                                   AR570
Element: Sales Type    A = Actual Invoice
                       C = Call-In Estimated Invoice
                       S = Aggregate Sales

FRI-DATE               Numeric 8  (yyyymmdd)                     AR570
Element: Date          This field displays the system date
                       when this was created.

FRI-ADJ-NBR            Numeric 3                                 AR570
Element: Adj Nbr

FRI-SALES-CLOSE        Signed 18.2                               AR570
Element: Intl Amt

FRI-SALES-TAX          Signed 18.2
Element: Intl Amt

FRI-ADJUSTMENTS        Signed 18.2
Element: Intl Amt

FRI-SEGMENT-BLOCK      Alpha 103
Element: Segment Block This field identifies the user analysis
                       values included in the transaction.

                       You can either type up to four values
                       or use Define (F6) to open the User
                       Analysis Entry subform. Use this subform
                       to select the user analysis values you
                       want to include in the transaction. If
                       you choose to type values, use commas to
                       separate them. For example:
                       value1,value2,value3,value4

                       There are three conditions that affect
                       how you can select user analysis values.
                       See the User Analysis Entry form help or
                       the Strategic Ledger procedures manual
                       for additional information.

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

FRI-POST-DATE          Numeric 8  (yyyymmdd)
Element: Post Date     The date general ledger entries for the
                       transaction will be posted to the
                       general ledger.


FRI-FRL-USR-FLD-01     Alpha 20
Element: Frl Usr Fld 01

FRI-FRL-USR-FLD-02     Alpha 20
Element: Frl Usr Fld 02

FRI-FRL-USR-FLD-03     Alpha 20
Element: Frl Usr Fld 03

FRI-FRL-USR-FLD-04     Alpha 20
Element: Frl Usr Fld 04

FRI-FRL-USR-FLD-05     Alpha 20
Element: Frl Usr Fld 05

                         FRISALES FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FRISET1   COMPANY                                                AR570
          CUSTOMER
          SHIP-TO
          CONTR-NBR
          SALES-TYPE
          DATE
          ADJ-NBR

FRISET2   COMPANY
          CUSTOMER
          SHIP-TO
          CONTR-NBR
          SALES-TYPE*
          DATE
          ADJ-NBR