Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             RETURNHDR FILE

                             Return Header

The Return Header file contains the return header record.

REFERENCED BY

BLI2.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

RTN-COMPANY          Numeric 4
Company              This field contains the company number.

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

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

RTN-USER-ID          Alpha 10  (Lower Case)
User ID Name         This field contains the name of the
                     user who entered the return.

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

RTN-BILL-TO          Numeric 4
Bill To              This field contains the bill-to
                     customer number from the original order.

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

RTN-DROPSHIP-FL      Alpha 1
Dropship Flag        This flag indicates whether goods being
                     shipped by the vendor directly to a
                     nonstandard location need to have the
                     receiving process performed.
                     Y = Yes
                     N = No

RTN-LOCATION         Alpha 5
Location Code        This field contains a valid stock
                     location within the company inventory.

RTN-POSTING-DATE     Numeric 8  (yyyymmdd)
Posting Date         This field contains the date assigned
                     to the journal entry for posting.

RTN-CUST-RET-REF     Alpha 10
Cust Ret Ref

RTN-CUST-REQ-ACT     Alpha 1
Cust Req Act         This field indicates whether a customer
                     wants a credit or replacement of goods
                     on a return.
                     C = Credit
                     R = Replacement

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

RTN-ORIG-INVC-PRE    Alpha 2
Orig Invc Pre        This field contains the prefix of the
                     original invoice against which the
                     return is being made.

RTN-ORIG-INVC-NBR    Numeric 8
Orig Invc Nbr        This field contains the number of the
                     original invoice against which the
                     return is being made.

RTN-INVC-PREFIX      Alpha 2
Invoice Prefix       This field contains the invoice prefix
                     that is assigned from either the company
                     or process level, depending on the
                     invoice-level option chosen.

RTN-INVC-NUMBER      Numeric 8
Invc Number          This 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.

RTN-ORDER-NBR        Numeric 8
Order Number         Each order is assigned a unique number.
                     Order numbers are either manually or
                     system assigned based on a company-level
                     option.

RTN-SHIPMENT-NBR     Numeric 10
Shipment Number      This field contains the shipment
                     number.  One order can have several
                     shipment numbers if the items of the
                     order were not shipped at the same time.


RTN-PROCESS-LEVEL    Alpha 5
Process Level        This field contains the process level.

RTN-INVC-TYPE        Alpha 4
Invoice Type         This field contains the invoice type
                     assigned to the return.  The type must
                     be a credit memo.

RTN-CURRENCY-CODE    Alpha 5
Currency Code        This field contains the company's base
                     currency code established in the Lawson
                     General Ledger system.

RTN-CONTACT          Alpha 20
Primary Contact      This field contains the name of the
                     main contact.

RTN-INT-PREFIX       Alpha 6
Int Prefix           This field contains the international
                     telephone prefix of the contact at the
                     customer site for which the return is
                     being entered.

RTN-PHONE-NMBR       Alpha 15
Telephone Number     This field contains the telephone
                     number of the contact at the customer
                     site from which the inventory is being
                     returned.

RTN-PHONE-EXT        Alpha 5
Telephone Extension  This field contains the contact's
                     telephone extension number.

RTN-STATUS           Numeric 1
Status               This field displays the status of the
                     transaction.

                     0 = Entered
                     1 = Released
                     9 = Closed

RTN-LAST-SEQ         Numeric 3
Last Sequence        This field contains the number used to
                     increment the line number.

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

RTN-LAST-LINE-NBR    Numeric 6
Last Line Number     This field contains the number of the
                     last line item added to the document. It
                     is used to determine what the next line
                     number is when you add another
                     item.

RTN-UND-ITEM-CNT     Numeric 3
Und Item Cnt         This field contains a count of items
                     that have not been selected for return.

RTN-UND-CM-CNT       Numeric 4
Und Cm Cnt           This field contains a count of returns
                     that have not selected whether or not to
                     create a credit memo.

RTN-CM-CNT           Numeric 3
Cm Cnt               This field contains the number of items
                     to be included on a credit memo.

RTN-AUTO-APP-FL      Alpha 1
Auto App Fl

RTN-CREATE-CM-CD     Alpha 1
Create Cm Cd

RTN-EP-TYPE          Alpha 5
Ep Type

RTN-EP-ACCOUNT       Alpha 32
Ep Account

RTN-EP-EXP-DATE      Numeric 8  (yyyymmdd)
Ep Exp Date

                         RETURNHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RTNSET1   COMPANY                                                BLI2.1
          AUTH-NO

RTNSET2   COMPANY       KeyChange, Subset
          INVC-PREFIX   Where INVC-PREFIX != Spaces
          INVC-NUMBER   Or    INVC-NUMBER != Zeroes

RTNSET3   COMPANY       KeyChange
          LOCATION
          STATUS
          AUTH-NO

RTNSET4   COMPANY       KeyChange
          CUSTOMER
          STATUS
          AUTH-NO

                         RETURNHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            RTN-COMPANY          -> ACO-COMPANY  (ACOSET1)

Arcustomer     ARCUSTOMER   Required

                            RTN-COMPANY          -> ACM-COMPANY
                            RTN-CUSTOMER         -> ACM-CUSTOMER

Billto         BILLTO       Required
                            When RTN-BILL-TO != Zeroes

                            ACO-CUST-GROUP       -> ABS-CUST-GROUP
                            RTN-CUSTOMER         -> ABS-CUSTOMER
                            RTN-BILL-TO          -> ABS-BILL-TO

Cucodes        CUCODES      Required
                            When RTN-CURRENCY-CODE != Spaces

                            RTN-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Custdesc       CUSTDESC     Required

                            ACO-CUST-GROUP       -> CUD-CUST-GROUP
                            RTN-CUSTOMER         -> CUD-CUSTOMER

Custorder      CUSTORDER    Not Required

                            RTN-COMPANY          -> COR-COMPANY
                            RTN-ORDER-NBR        -> COR-ORDER-NBR

Iclocation     ICLOCATION   Required

                            RTN-COMPANY          -> ICL-COMPANY
                            RTN-LOCATION         -> ICL-LOCATION

Oecompany      OECOMPANY    Required

                            RTN-COMPANY          -> OEC-COMPANY

Oeinvctype     OEINVCTYPE   Required

                            RTN-COMPANY          -> OIN-COMPANY
                            RTN-INVC-TYPE        -> OIN-INVC-TYPE

Oeinvoice      OEINVOICE    Required
                            When RTN-INVC-PREFIX != Spaces
                            Or   RTN-INVC-NUMBER != Zeroes

                            RTN-COMPANY          -> OEI-COMPANY
                            RTN-INVC-PREFIX      -> OEI-INVC-PREFIX
                            RTN-INVC-NUMBER      -> OEI-INVC-NUMBER

Oeproclev      OEPROCLEV    Required

                            RTN-COMPANY          -> OEP-COMPANY
                            RTN-PROCESS-LEVEL    -> OEP-PROCESS-LEVEL

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

                            RTN-COMPANY          -> OER-COMPANY
                            RTN-REASON-CODE      -> OER-REASON-CODE

Orig Invoice   OEINVOICE    Required
                            When RTN-ORIG-INVC-NBR != Zeroes

                            RTN-COMPANY          -> OEI-COMPANY
                            RTN-ORIG-INVC-PRE    -> OEI-INVC-PREFIX
                            RTN-ORIG-INVC-NBR    -> OEI-INVC-NUMBER

Shipto         SHIPTO       Required
                            When RTN-SHIP-TO != Zeroes

                            RTN-COMPANY          -> SHP-COMPANY
                            RTN-CUSTOMER         -> SHP-CUSTOMER
                            RTN-SHIP-TO          -> SHP-SHIP-TO