Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RETURNHDR


                             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
Element: Company       This field contains the company number.

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

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

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

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

RTN-BILL-TO            Numeric 4
Element: Ship-to Code  This field contains the bill-to
                       customer number from the original order.

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

RTN-DROPSHIP-FL        Alpha 1
Element: 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
Element: Location Code This field contains a valid stock
                       location within the company inventory.

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

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

RTN-CUST-REQ-ACT       Alpha 1
Element: 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
Accounts Receivable    This field contains the reason code,
Code                   which indicates the cause for credit
                       memos.

RTN-ORIG-INVC-PRE      Alpha 2
Element: Invoice PrefixThis field contains the prefix of the
                       original invoice against which the
                       return is being made.

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

RTN-INVC-PREFIX        Alpha 2
Element: Invoice PrefixThis 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
Element: 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
Element: 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
Element: Shipment NumbeThis 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
Element: Process Level This field contains the process level.

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

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

RTN-CONTACT            Alpha 20
Element: Primary ContacThis field contains the name of the
                       main contact.

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

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

RTN-PHONE-EXT          Alpha 5
Element: Telephone ExteThis field contains the contact's
                       telephone extension number.

RTN-STATUS             Numeric 1
Element: Status        This field displays the status of the
                       transaction.
                       0 = Entered
                       1 = Released
                       9 = Closed

RTN-LAST-SEQ           Numeric 3
Element: Sequence NumbeThis field contains the number used to
                       increment the line number.

RTN-LAST-COMM-SEQ      Numeric 3
Element: Sequence Number

RTN-LAST-LINE-NBR      Numeric 6
Element: Line Number

RTN-UND-ITEM-CNT       Numeric 3
Element: Invoice Count This field contains a count of items
                       that have not been selected for return.

RTN-UND-CM-CNT         Numeric 4
Element: Sc Count      This field contains a count of returns
                       that have not selected whether or not to
                       create a credit memo.

RTN-CM-CNT             Numeric 3
Element: Invoice Count This field contains the number of items
                       to be included on a credit memo.

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

RTN-CREATE-CM-CD       Alpha 1
Element: All Flag

RTN-EP-TYPE            Alpha 5
Element: Ep Type

RTN-EP-ACCOUNT         Alpha 32
Element: Ep Account

RTN-EP-EXP-DATE        Numeric 8  (yyyymmdd)
Element: 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 -ORIG-INVC-NBR != Spaces

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

Shipto         SHIPTO       Required
                            When -SHIP-TO != Spaces

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