Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OERETHDRIN


                            OERETHDRIN FILE

UPDATED BY

OE530     OE56.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RHI-COMPANY            Numeric 4                                 OE56.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

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

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

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

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

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

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

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

RHI-BILL-TO            Numeric 4                                 OE56.1
Element: Bill To       This field contains the mailing address
                       for the invoice.  Bill to addresses are
                       maintained in the Accounts Receviable
                       Bill To form AR09.4.

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

RHI-DROPSHIP-FL        Alpha 1                                   OE56.1
Element: 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
Element: Posting Date  The date assigned to the journal entry
                       for posting.

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

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

RHI-ORIG-INVC-PRE      Alpha 2                                   OE56.1
Element: Invoice Prefix

RHI-ORIG-INVC-NBR      Numeric 8                                 OE56.1
Element: Invc Number

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

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


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

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

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

RHI-CONTACT            Alpha 20                                  OE56.1
Element: Primary ContacThis is the name of the main contact.

RHI-INT-PREFIX         Alpha 6                                   OE56.1
Telephone Country
Code

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

RHI-PHONE-EXT          Alpha 5                                   OE56.1
Element: Telephone ExteThis field contains the telephone
                       extension number.

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

RHI-STATUS             Numeric 1                                 OE56.1
Element: Status        This field displays the status of the
                       transaction.

RHI-LAST-SEQ           Numeric 3                                 OE56.1
Element: Sequence Number

RHI-LAST-COMM-SEQ      Numeric 3                                 OE56.1
Element: Sequence NumbeThis is the sequence number of the last
                       comment line entered for this
                       requisition line.

RHI-LAST-LINE-NBR      Numeric 6                                 OE56.1
Element: 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.

RHI-UND-ITEM-CNT       Numeric 3                                 OE56.1
Element: Invoice Count

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

RHI-CM-CNT             Numeric 3                                 OE56.1
Element: Invoice Count

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

RHI-EP-TYPE            Alpha 5                                   OE56.1
Element: Ep Type

RHI-EP-ACCOUNT         Alpha 32                                  OE56.1
Element: Ep Account

RHI-EP-EXP-DATE        Numeric 8  (yyyymmdd)                     OE56.1
Element: Ep Exp Date

                         OERETHDRIN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RHISET1   COMPANY                                                OE530   OE56.1
          AUTH-NO

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

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