Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RETURNLINE


                            RETURNLINE FILE

                              Return Line

The Return Line file contains the lines entered on a return.

REFERENCED BY

IC11.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RTL-COMPANY            Numeric 4
Element: Company       This field contains the company number.

RTL-AUTH-NO            Numeric 10
Element: Auth No       This field contains the authorization
                       number of the user who is entering the
                       return.

RTL-LINE-NBR           Numeric 6
Element: Line Nbr      This field contains the line number.

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

RTL-ORDER-NBR          Numeric 8
Element: Order Nbr     This field contains the order number.

RTL-LOCATION           Alpha 5
Element: Location      This field contains a valid stock
                       location within the company inventory.

RTL-DATE               Numeric 8  (yyyymmdd)
Element: Date          This field contains the system date
                       when the return was created.

RTL-ITEM               Alpha 32
Element: Item          This field contains the item
                       identifier.

RTL-DESCRIPTION        Alpha 30  (Lower Case)
Element: Description   This field contains the item
                       description.

RTL-LINE-TYPE          Alpha 1
Element: Line Type     This field contains the type of
                       inventory on this line.
                       I = Inventoried
                       N = Non-Stock
                       X = Special

RTL-REASON-CODE        Alpha 4
Element: Reason Code   This field contains the reason code,
                       which indicates the cause for credit
                       memos.

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

RTL-QUANTITY           Signed 13.4
Element: Quantity      This field contains the return quantity
                       in sell unit of measure.

RTL-SELL-UOM           Alpha 4
Element: Uom           This field contains the stock unit of
                       measure for the item.  If entered, it
                       must be a valid stock unit of measure
                       for this item.  If not entered, the
                       default stock unit of measure for this
                       item is assigned.

RTL-INVC-CW-QTY        Signed 13.4
Element: Quantity      This field contains the 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.

RTL-INVEN-CW-QTY       Signed 13.4
Element: Quantity      This field contains the 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.

RTL-ENTERED-PRICE      Signed 18.5
Element: Intl Cost     This field contains the price of the
                       line in original billing currency.

RTL-STD-COST           Signed 18.5
Element: Intl Cost     This field contains the cost of the
                       item that is being returned if the
                       company is using standard costing.

RTL-SELL-TO-STOCK      Signed 13.7
Element: Sell To Stock This field contains a conversion factor
                       for converting the line amount from sell
                       to stock unit of measure.

RTL-UNIT-PRICE         Signed 18.5
Element: Intl Cost     This field contains the unit price in
                       company base currency.

RTL-BASE-PRICE         Signed 18.5
Element: Intl Cost     This field contains the base price from
                       the order.

RTL-SPR-UOM            Alpha 4
Element: Uom           This field contains the sell pricing
                       unit of measure.

RTL-SPR-TO-STOCK       Signed 13.7
Element: Sell To Stock This field contains the conversion
                       factor from price to stock unit of
                       measure.

RTL-ENT-UNIT-COST      Signed 18.5
Element: Intl Cost     This field contains the entered unit
                       cost for the return line.

RTL-UNIT-COST          Signed 18.5
Element: Intl Cost     This field contains the approved unit
                       cost for this invoice line item in
                       company base currency.

RTL-ACTIVITY           Alpha 15
Element: Activity      This field contains the activity for
                       the sales account.

                       Activities are the processes or
                       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 Project Accounting.
                       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.

RTL-ACCT-CATEGORY      Alpha 5
Element: Acct Category This field contains the account
                       category for the sales account.

                       Account categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in Project Accounting.
                       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 Account Assignment
                       (AC07.1).

                       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.

RTL-ACTIVITY-C         Alpha 15
Element: Activity      This field contains the activity for
                       the Cost (COGS) account.

                       Activities are the processes or
                       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 Project Accounting.
                       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.

RTL-ACCT-CATEG-C       Alpha 5
Element: Acct Category This field contains the account
                       category for the Cost (COGS) account.

                       Account categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in Project Accounting.
                       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 Account Assignment
                       (AC07.1).

                       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.

RTL-ATN-OBJ-ID-C       Numeric 12
Element: Obj Id        This field contains the system-defined
                       object ID representing the Activity
                       Management commitment for Cost (COGS).

RTL-CUST-REQ-ACT       Alpha 1
Element: Cust Req Act  This field indicates whether the
                       customer wants a credit memo issued or
                       replacement of goods.
                       C = Credit Memo
                       R = Replacement

RTL-RESTK-CHG-CODE     Alpha 16
Element: Restk Chg CodeThis field contains the add-on charge
                       code indicating whether you want to
                       charge the customer for restocking.

RTL-INV-DISP-CD        Alpha 1
Element: Inv Disp Cd   This field indicates where to place
                       returned items.
                       R = Return To Stock
                       S = Scrap
                       I = Ignore

RTL-CREATE-CM-CD       Alpha 1
Element: All Flag      This field indicates whether or not to
                       create a credit memo.
                       Y = Yes
                       N = No

RTL-DETAIL-QTY         Signed 13.4
Element: Quantity      This field contains the summation of
                       all detail line quantity in stock unit
                       of measure.

RTL-SLS-ACCT-UNIT      Alpha 15
Element: Acct Unit     This field contains the sales
                       accounting unit to post to.

RTL-SLS-ACCOUNT        Numeric 6
Element: Account       This field contains the sales account
                       to post to.

RTL-SLS-SUB-ACCT       Numeric 4
Element: Sub Acct      This field contains the sales
                       subaccount to post to.

RTL-OFF-ACCT-UNIT      Alpha 15
Element: Acct Unit     This field contains the COGS offset
                       account unit to post to.

RTL-OFF-ACCOUNT        Numeric 6
Element: Account       This field contains the COGS offset
                       account to post to.

RTL-OFF-SUB-ACCT       Numeric 4
Element: Sub Acct      This field contains the COGS offset
                       subaccount to post to.

RTL-CGS-ACCT-UNIT      Alpha 15
Element: Acct Unit     This field contains the COGS account
                       unit to post to.

RTL-CGS-ACCOUNT        Numeric 6
Element: Account       This field contains the COGS account to
                       post to.

RTL-CGS-SUB-ACCT       Numeric 4
Element: Sub Acct      This field contains the COGS subaccount
                       to post to.

RTL-CV-ACCT-UNIT       Alpha 15
Element: Acct Unit     This field contains the cost variance
                       accounting unit.

RTL-CV-ACCOUNT         Numeric 6
Element: Account       This field contains the cost variance
                       account.

RTL-CV-SUB-ACCT        Numeric 4
Element: Sub Acct      This field contains the cost variance
                       subaccount.

RTL-PO-NUMBER          Alpha 14  (Right Justified)
Element: Po Number     This field contains the number
                       representing the purchase order.

RTL-PO-CODE            Alpha 4
Element: Po Code       This is the purchase order code.

RTL-STATUS             Numeric 1
Element: Status        This field contains the return status.
                       0 = Entered
                       1 = Released
                       9 = Closed

RTL-AVERAGE-COST       Signed 18.5
Element: Intl Cost     This field contains the cost of the
                       item that is being returned if the
                       company is using average costing.

RTL-SOH-QTY            Signed 13.4
Element: Quantity      This field contains the desired
                       quantity.

                         RETURNLINE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RTLSET1   COMPANY                                                IC11.1
          AUTH-NO
          LINE-NBR

RTLSET2   COMPANY
          CUSTOMER
          ITEM
          SHIP-TO
          DATE
          AUTH-NO
          LINE-NBR

RTLSET3   ATN-OBJ-ID-C  KeyChange, Subset
                        Where ATN-OBJ-ID-C != Zeroes

RTLSET4   COMPANY       KeyChange
          ITEM
          STATUS
          AUTH-NO
          LINE-NBR

RTLSET5   COMPANY       KeyChange
          REASON-CODE
          STATUS
          AUTH-NO
          LINE-NBR

RTLSET6   COMPANY
          LINE-NBR
          AUTH-NO

                         RETURNLINE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cogs Account   GLMASTER     Not Required
                            Valid When RTL-CGS-ACCT-UNIT != Spaces
                                  Or   RTL-CGS-ACCOUNT   != Zeroes
                                  Or   RTL-CGS-SUB-ACCT  != Zeroes

                            RTL-COMPANY           -> -COMPANY
                            RTL-CGS-ACCT-UNIT     -> -ACCT-UNIT
                            RTL-CGS-ACCOUNT       -> -ACCOUNT
                            RTL-CGS-SUB-ACCT      -> -SUB-ACCOUNT

Cogs Offset    GLMASTER     Not Required
                            Valid When RTL-OFF-ACCT-UNIT != Spaces
                                  Or   RTL-OFF-ACCOUNT   != Zeroes
                                  Or   RTL-OFF-SUB-ACCT  != Zeroes

                            RTL-COMPANY           -> GLM-COMPANY
                            RTL-OFF-ACCT-UNIT     -> GLM-ACCT-UNIT
                            RTL-OFF-ACCOUNT       -> GLM-ACCOUNT
                            RTL-OFF-SUB-ACCT      -> GLM-SUB-ACCOUNT

Coline         COLINE       Not Required
                            Valid When RTL-ORDER-NBR != Zeroes

                            RTL-COMPANY           -> COL-COMPANY
                            RTL-ORDER-NBR         -> COL-ORDER-NBR
                            RTL-LINE-NBR          -> COL-LINE-NBR

Glsystem       GLSYSTEM     Required

                            RTL-COMPANY           -> GLS-COMPANY

Iccompany      ICCOMPANY    Required

                            RTL-COMPANY           -> ICC-COMPANY

Iclocation     ICLOCATION   Required

                            RTL-COMPANY           -> ICL-COMPANY
                            RTL-LOCATION          -> ICL-LOCATION

Itemloc        ITEMLOC      Not Required
                            Valid When RTL-LINE-TYPE = "I"

                            RTL-COMPANY           -> ITL-COMPANY
                            RTL-LOCATION          -> ITL-LOCATION
                            RTL-ITEM              -> ITL-ITEM

Itemmast       ITEMMAST     Required
                            When RTL-LINE-TYPE != "X"

                            ICC-ITEM-GROUP        -> ITE-ITEM-GROUP
                            RTL-ITEM              -> ITE-ITEM

Oecompany      OECOMPANY    Required

                            RTL-COMPANY           -> OEC-COMPANY

Oeinvcline     OEINVCLINE   Required
                            When RTN-ORIG-INVC-PRE != Spaces
                            Or   RTN-ORIG-INVC-NBR != Zeroes

                            RTL-COMPANY           -> OIL-COMPANY
                            RTN-ORIG-INVC-PRE     -> OIL-INVC-PREFIX
                            RTN-ORIG-INVC-NBR     -> OIL-INVC-NUMBER
                            RTL-LINE-NBR          -> OIL-LINE-NBR

Oemisc         OEMISC       Not Required
                            Valid When RTL-RESTK-CHG-CODE != Spaces

                            RTL-COMPANY           -> OEM-COMPANY
                            RTL-RESTK-CHG-CODE    -> OEM-MISC
                            RTN-CURRENCY-CODE     -> OEM-CURRENCY-CODE

Oereason       OEREASON     Required
                            When RTL-REASON-CODE != Spaces

                            RTL-COMPANY           -> OER-COMPANY
                            RTL-REASON-CODE       -> OER-REASON-CODE

Reason         OEREASON     Required
                            When RTL-REASON-CODE != Spaces

                            RTL-COMPANY           -> OER-COMPANY
                            RTL-REASON-CODE       -> OER-REASON-CODE

Returnhdr      RETURNHDR    Required

                            RTL-COMPANY           -> RTN-COMPANY
                            RTL-AUTH-NO           -> RTN-AUTH-NO

Sales Account  GLMASTER     Required

                            RTL-COMPANY           -> GLM-COMPANY
                            RTL-SLS-ACCT-UNIT     -> GLM-ACCT-UNIT
                            RTL-SLS-ACCOUNT       -> GLM-ACCOUNT
                            RTL-SLS-SUB-ACCT      -> GLM-SUB-ACCOUNT

                         RETURNLINE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bins           WHSHLDTL
                            Valid When ITE-LOT-TRACK-FL = "N"
                                  And  ITL-BIN-TRACK-FL = "Y"

                            RTL-COMPANY           -> WHD-COMPANY
                            RTL-LOCATION          -> WHD-LOCATION
                            RTN-SHIPMENT-NBR      -> WHD-SHIPMENT-NBR
                            RTL-LINE-NBR          -> WHD-LINE-NBR
                                                     WHD-COMPONENT-SEQ
                                                     WHD-BIN
                                                     WHD-LOT
                                                     WHD-SUBLOT
                                                     WHD-UOM
                                                     WHD-SERIAL

Lots           WHSHLDTL
                            Valid When ITE-LOT-TRACK-FL = "Y"

                            RTL-COMPANY           -> WHD-COMPANY
                            RTL-LOCATION          -> WHD-LOCATION
                            RTN-SHIPMENT-NBR      -> WHD-SHIPMENT-NBR
                            RTL-LINE-NBR          -> WHD-LINE-NBR
                                                     WHD-COMPONENT-SEQ
                                                     WHD-BIN
                                                     WHD-LOT
                                                     WHD-SUBLOT
                                                     WHD-UOM
                                                     WHD-SERIAL

Oeshipdtl      WHSHLDTL

                            RTL-COMPANY           -> WHD-COMPANY
                            RTL-LOCATION          -> WHD-LOCATION
                            RTN-SHIPMENT-NBR      -> WHD-SHIPMENT-NBR
                            RTL-LINE-NBR          -> WHD-LINE-NBR
                                                     WHD-COMPONENT-SEQ
                                                     WHD-BIN
                                                     WHD-LOT
                                                     WHD-SUBLOT
                                                     WHD-UOM
                                                     WHD-SERIAL

Serials        WHSHLDTL
                            Valid When ITE-SER-TRACK-FL = "R"
                                  Or   ITE-SER-TRACK-FL = "I"

                            RTL-COMPANY           -> WHD-COMPANY
                            RTL-LOCATION          -> WHD-LOCATION
                            RTN-SHIPMENT-NBR      -> WHD-SHIPMENT-NBR
                            RTL-LINE-NBR          -> WHD-LINE-NBR
                                                     WHD-COMPONENT-SEQ
                                                     WHD-BIN
                                                     WHD-LOT
                                                     WHD-SUBLOT
                                                     WHD-UOM
                                                     WHD-SERIAL

Sohdetail      SOHDETAIL

                            RTL-COMPANY           -> SDT-COMPANY
                            RTL-LOCATION          -> SDT-LOCATION
                            RTL-ITEM              -> SDT-ITEM
                                                     SDT-UOM
                                                     SDT-LOT
                                                     SDT-SUBLOT
                                                     SDT-BIN

Uoms           WHSHLDTL
                            Valid When ITE-MULT-UOMS > Zeroes

                            RTL-COMPANY           -> WHD-COMPANY
                            RTL-LOCATION          -> WHD-LOCATION
                            RTN-SHIPMENT-NBR      -> WHD-SHIPMENT-NBR
                            RTL-LINE-NBR          -> WHD-LINE-NBR
                                                     WHD-COMPONENT-SEQ
                                                     WHD-BIN
                                                     WHD-LOT
                                                     WHD-SUBLOT
                                                     WHD-UOM
                                                     WHD-SERIAL