Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             OERETLNIN FILE

REFERENCED BY

OE530

UPDATED BY

OE56.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

RLI-COMPANY          Numeric 4                                   OE56.2
Company              The company number represents an
                     established company and is entered on
                     all function codes.

RLI-AUTH-NO          Numeric 10                                  OE56.2
Auth No

RLI-LINE-NBR         Numeric 6                                   OE56.2
Line Number          This field contains the line number.

RLI-RET-REF-NBR      Alpha 20                                    OE56.2
Ret Ref Nbr

RLI-LOCATION         Alpha 5                                     OE56.2
Location Code        This field contains a valid stocking
                     location within the company inventory.

RLI-RTN-DATE         Numeric 8  (yyyymmdd)                       OE56.2
Rtn Date

RLI-UPDATE-TIME      Numeric 6                                   OE56.2
Update Time          This field contains the system time
                     when the record was updated.

RLI-CUSTOMER         Alpha 9  (Right Justified)                  OE56.2
Customer Number      This field contains the number that
                     represents a customer.

RLI-SHIP-TO          Numeric 4                                   OE56.2
Ship-to Code         This field contains the number
                     representing the ship-to customer.

RLI-ORDER-NBR        Numeric 8                                   OE56.2
Order Number         This field contains the order number.

RLI-ORIG-LINE-NBR    Numeric 6                                   OE56.2
Original Line Number

RLI-ITEM             Alpha 32                                    OE56.2
Item Number          This field contains the item
                     identifier.

RLI-DESCRIPTION      Alpha 30  (Lower Case)                      OE56.2
Description          This field contains the description.

RLI-LINE-TYPE        Alpha 1                                     OE56.2
Line Type            This field contains the type of
                     inventory on this line.

RLI-REASON-CODE      Alpha 4                                     OE56.2
Reason Code          This field contains the reason code,
                     which indicates the cause for credit
                     memos.

RLI-QUANTITY         Signed 13.4                                 OE56.2
Quantity             This field contains the requested
                     quantity.

RLI-SELL-UOM         Alpha 4                                     OE56.2
Sell Unit of Measure This field contains the stocking UOM
                     for the item.

RLI-INVC-CW-QTY      Signed 13.4                                 OE56.2
Invc Cw Qty          Invoice Catch Weight Quantity. This
                     field is valid only for catch weight
                     items. This is used in extended price
                     calculation, but quantity is used for
                     pricing.

RLI-INVEN-CW-QTY     Signed 13.4                                 OE56.2
Inven Cw Qty         Inventory Catch Weight Quantity. This
                     field is used only for credit memo
                     catch weight items, if the item is
                     returned to inventory. This is defaulted
                     from Invoice Catch Weight Quantity.

RLI-STD-COST         Signed 13.5                                 OE56.2
Standard Cost

RLI-SELL-TO-STOCK    Signed 13.7                                 OE56.2
Sell to Stock

RLI-ORIG-UNIT-COST   Signed 13.5                                 OE56.2
Orig Unit Cost

RLI-ENT-UNIT-COST    Signed 13.5                                 OE56.2
Ent Unit Cost

RLI-UNIT-COST        Signed 13.5                                 OE56.2
Unit Cost            This field contains the unit cost.

RLI-CUST-REQ-ACT     Alpha 1                                     OE56.2
Cust Req Act

RLI-RESTK-CHG-CODE   Alpha 16                                    OE56.2
Restk Chg Code

RLI-INV-DISP-CD      Alpha 1                                     OE56.2
Inv Disp Cd

RLI-CREATE-CM-CD     Alpha 1                                     OE56.2
Create Cm Cd

RLI-DETAIL-QTY       Signed 13.4                                 OE56.2
Detail Qty           This field shows the total quantity of
                     details defined for a detail tracked
                     item. It is matched against the line
                     quantity field to determine if details
                     are in balance.
                     In the item detail screen, it is the
                     quantity for a particular lot or bin.

RLI-DTL-CW-QTY       Signed 13.4                                 OE56.2
Dtl Cw Qty

RLI-PO-NUMBER        Alpha 7  (Right Justified)                  OE56.2
PO Number            This field contains the number
                     representing the purchase order.

RLI-LAST-COMM-SEQ    Numeric 3                                   OE56.2
Last Comment         This is the sequence number of the last
Sequence Number      comment line entered for this
                     requisition line.

RLI-STATUS           Numeric 1                                   OE56.2
Status               This field contains the status of the
                     transaction.

RLI-AVERAGE-COST     Signed 13.5                                 OE56.2
Average Cost

RLI-SOH-QTY          Signed 13.4                                 OE56.2
Stock On Hand        This field contains the quantity that
Quantity             is currently on hand in inventory.

RLI-ACTIVITY-C       Alpha 15                                    OE56.2
Activity for Cst of  Activities are the processes or
Goods Sold           procedures that produce work. Cost
                     objects (products, services, customers,
                     and so on) are the reasons for
                     performing the activity. Activities and
                     cost object activities are used
                     synonymously in the Lawson Activity
                     Management system. Direct costs are
                     posted to activities, and indirect costs
                     are allocated to activities based on
                     activity drivers.

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

RLI-ACCT-CATEG-C     Alpha 5                                     OE56.2
Acct Categ (Cst of   Account categories are groupings of
Goods Sold)          costs, revenues, or a combination of
                     both used for reporting and inquiries
                     for activities in the Lawson Activity
                     Management system. All transactions are
                     posted to an account category within an
                     activity. You can assign a specific
                     General Ledger account or range of
                     accounts (company, accounting unit,
                     account, and subaccount) that make up
                     the transactions posted to an account
                     category using AC07.1 (Account
                     Assignment).

                     Period-to-date, year-to-date, and
                     life-to-date balances are maintained by
                     account category for activities. Account
                     categories must be assigned to
                     activities before you do any budgeting
                     or transaction processing.

RLI-ATN-OBJ-ID-C     Numeric 12
AC System Object ID  The system defined object id
(Cost)               representing the Activity Management
                     committment.

RLI-STOCK-UOM        Alpha 4
Stocking Unit of     This is the stock unit of measure for
Measure              the item.

                         OERETLNIN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RLISET1   COMPANY                                                OE530   OE56.2
          AUTH-NO
          LINE-NBR

RLISET2   COMPANY                                                OE56.2
          RET-REF-NBR
          AUTH-NO
          LINE-NBR

RLISET3   COMPANY                                                OE56.2
          LOCATION
          RTN-DATE
          AUTH-NO
          LINE-NBR