Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            OERETHDRIN FILE

REFERENCED BY

OE530

UPDATED BY

OE56.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

RHI-AUTH-NO          Numeric 10                                  OE56.1
Auth No

RHI-RET-REF-NBR      Alpha 20                                    OE56.1
Ret Ref Nbr

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

RHI-RTN-DATE         Numeric 8  (yyyymmdd)                       OE56.1
Rtn Date

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

RHI-USER-ID          Alpha 10  (Lower Case)                      OE56.1
User ID Name         Contains the user ID of the person who
                     last changed this record.

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

RHI-BILL-TO          Numeric 4                                   OE56.1
Bill-To Customer
Number

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

RHI-DROPSHIP-FL      Alpha 1                                     OE56.1
Dropship Flag        This flag indicates whether goods being
                     shipped by the vendor directly to a non
                     standard location need to have the
                     receiving process performed.

RHI-POSTING-DATE     Numeric 8  (yyyymmdd)                       OE56.1
Posting Date         The date assigned to the journal entry
                     for posting.


RHI-CUST-REQ-ACT     Alpha 1                                     OE56.1
Cust Req Act

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

RHI-ORIG-INVC-PRE    Alpha 2                                     OE56.1
Orig Invc Pre


RHI-ORIG-INVC-NBR    Numeric 8                                   OE56.1
Orig Invc Nbr


RHI-ORDER-NBR        Numeric 8                                   OE56.1
Order Number         This field contains the order number.

RHI-SHIPMENT-NBR     Numeric 10                                  OE56.1
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.


RHI-PROCESS-LEVEL    Alpha 5                                     OE56.1
Process Level        This field contains the process level,
                     which is the reporting hierarchy below
                     company.

RHI-INVC-TYPE        Alpha 4                                     OE56.1
Invoice Type

RHI-CURRENCY-CODE    Alpha 5                                     OE56.1
Currency Code        This field contains the company base
                     currency code established in GL10.1
                     (Company).

RHI-CONTACT          Alpha 20                                    OE56.1
Primary Contact      This is the name of the main contact.

RHI-INT-PREFIX       Alpha 6                                     OE56.1
Int Prefix

RHI-PHONE-NMBR       Alpha 15                                    OE56.1
Telephone Number

RHI-PHONE-EXT        Alpha 5                                     OE56.1
Telephone Extension  This field contains the telephone
                     extension number.

RHI-RESTK-CHG-CODE   Alpha 16                                    OE56.1
Restk Chg Code

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

RHI-LAST-SEQ         Numeric 3                                   OE56.1
Last Sequence

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

RHI-LAST-LINE-NBR    Numeric 6                                   OE56.1
Last Line Number     This field contains the number of the
                     last line item added to the requisition.
                      It is used to determine the number when
                     the next line is added to the
                     requisition.

RHI-UND-ITEM-CNT     Numeric 3                                   OE56.1
Und Item Cnt

RHI-UND-CM-CNT       Numeric 4                                   OE56.1
Und Cm Cnt

RHI-CM-CNT           Numeric 3                                   OE56.1
Cm Cnt

RHI-RECORD-ERROR     Alpha 1                                     OE56.1
Record Error

                         OERETHDRIN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RHISET1   COMPANY                                                OE530   OE56.1
          AUTH-NO

RHISET2   COMPANY                                                OE56.1
          RET-REF-NBR
          AUTH-NO

RHISET3   COMPANY                                                OE56.1
          LOCATION
          RTN-DATE
          AUTH-NO