Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RETURNSGBK


                            RETURNSGBK FILE

This file stores user analysis values for Order Entry return lines. User
analysis values can be added to a return line transaction through OE30.3
(Return Line Detail).

User analysis values represent information your organization can use to
measure profitability. To utilize this measure of orgnizational profitability,
you must be set up to use the Strategic Ledger system.

UPDATED BY

OE130     OE30.1    OE30.2    OE30.3    OE30.4    OE30.5
OE30.6    OE30.7    OE30.9    OE330     OE530     OE830

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RSB-COMPANY            Numeric 4                                 OE130   OE30.1
Element: Company       Identifies the AP company if the          OE30.2  OE30.3
                       resource type = V.  Identifies the HR     OE30.4  OE30.5
                       company if the resource type = E.  It is  OE30.6  OE30.7
                       blank for type A, P or Q resources.       OE30.9  OE330
                                                                 OE530   OE830

RSB-AUTH-NO            Numeric 10                                OE130   OE30.1
Element: Auth No       This field contains the authorization     OE30.2  OE30.3
                       number of the user entering the return.   OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE330
                                                                 OE530   OE830

RSB-LINE-NBR           Numeric 6                                 OE130   OE30.1
Element: Line Number   This field contains the line number.      OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE330
                                                                 OE530   OE830

RSB-SEGMENT-BLOCK      Alpha 103                                 OE130   OE30.1
Element: User Analysis This field identifies the user analysis   OE30.2  OE30.3
                       values included in the transaction.       OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                       You can either type up to four values     OE30.9  OE330
                       or use Define (F6) to open the User       OE530   OE830
                       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.

                         RETURNSGBK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RSBSET1   COMPANY                                                OE130   OE30.1
          AUTH-NO                                                OE30.2  OE30.3
          LINE-NBR                                               OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE330
                                                                 OE530   OE830

                         RETURNSGBK FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Returnhdr      RETURNHDR    Not Required

                            RSB-COMPANY     -> RTN-COMPANY
                            RSB-AUTH-NO     -> RTN-AUTH-NO

Returnline     RETURNLINE   Not Required

                            RSB-COMPANY     -> RTL-COMPANY
                            RSB-AUTH-NO     -> RTL-AUTH-NO
                            RSB-LINE-NBR    -> RTL-LINE-NBR